ATCHRLUS

This table holds usage information for attachment relations. For example, an attachment can be a warranty document related to a product. In this case the usage is 'warranty'.

Column Descriptions:

NameTypeDescription
ATCHRLUS_IDINTEGER NOT NULLThe primary key for the attachment relation usage.
IDENTIFIERVARCHAR (254)The identifier for the attachment relation usage. For example, 'Image'.
IMAGEVARCHAR (254)The image path that represent the attachment relation usage.
SEQUENCEDOUBLEThe sequence number.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ATCHRLUS_IDPrimary Key
I0000878IDENTIFIERUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1120ATCHRLUS_IDATCHRLUSDSATCHRLUS_IDCascade
F_1122ATCHRLUS_IDATCHRELATCHRLUS_IDCascade