ATCHREL

This table holds the attachment relation between a business object and an attachment target.

Column Descriptions:

NameTypeDescription
ATCHREL_IDBIGINT NOT NULLThe primary key of the attachment relation.
OBJECT_IDCHAR (64) NOT NULLThe object ID is the primary key of the business object that owns the attachment relation.
ATCHOBJTYP_IDINTEGER NOT NULLThe attachment object type ID of the business object which owns the attachment relation.
ATCHTGT_IDBIGINT NOT NULLThe attachment target ID that is attached to the business object in this attachment relation.
ATCHRLUS_IDINTEGER NOT NULLThe attachment relation usage ID that describes the usage of this attachment relation.
LASTUPDATETIMESTAMPThe time the attachment relation was last updated.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence number for displaying the attachment relation.
BIGINTOBJECT_IDBIGINTThe primary key (BigInt type) of the business object that owns the attachment relation.
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>ATCHREL_IDPrimary Key
I0000860 ATCHOBJTYP_ID+OBJECT_ID+ATCHRLUS_ID+ATCHTGT_IDUnique Index
I0000873ATCHOBJTYP_IDNon-Unique Index
I0000874ATCHTGT_IDNon-Unique Index
I0000877ATCHRLUS_IDNon-Unique Index
I0001207BIGINTOBJECT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1113ATCHOBJTYP_IDATCHOBJTYPATCHOBJTYP_IDCascade
F_1114ATCHTGT_IDATCHTGTATCHTGT_IDCascade
F_1122ATCHRLUS_IDATCHRLUSATCHRLUS_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1116ATCHREL_IDATCHRELDSCATCHREL_IDCascade