ATCHREL

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

Column Descriptions:

Name	Type	Description
ATCHREL_ID	BIGINT NOT NULL	The primary key of the attachment relation.
OBJECT_ID	CHAR (64) NOT NULL	The object ID is the primary key of the business object that owns the attachment relation.
ATCHOBJTYP_ID	INTEGER NOT NULL	The attachment object type ID of the business object which owns the attachment relation.
ATCHTGT_ID	BIGINT NOT NULL	The attachment target ID that is attached to the business object in this attachment relation.
ATCHRLUS_ID	INTEGER NOT NULL	The attachment relation usage ID that describes the usage of this attachment relation.
LASTUPDATE	TIMESTAMP	The time the attachment relation was last updated.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	The sequence number for displaying the attachment relation.
BIGINTOBJECT_ID	BIGINT	The primary key (BigInt type) of the business object that owns the attachment relation.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ATCHREL_ID	Primary Key
I0000860	ATCHOBJTYP_ID+OBJECT_ID+ATCHRLUS_ID+ATCHTGT_ID	Unique Index
I0000873	ATCHOBJTYP_ID	Non-Unique Index
I0000874	ATCHTGT_ID	Non-Unique Index
I0000877	ATCHRLUS_ID	Non-Unique Index
I0001207	BIGINTOBJECT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1113	ATCHOBJTYP_ID	ATCHOBJTYP	ATCHOBJTYP_ID	Cascade
F_1114	ATCHTGT_ID	ATCHTGT	ATCHTGT_ID	Cascade
F_1122	ATCHRLUS_ID	ATCHRLUS	ATCHRLUS_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1116	ATCHREL_ID	ATCHRELDSC	ATCHREL_ID	Cascade