This table holds the attachment relation between a business object and an attachment target.
Column Description(s):
Column Name | Column 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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000860 |
ATCHOBJTYP_ID+OBJECT_ID+ATCHRLUS_ID+ATCHTGT_ID |
Unique Index |
SQL050212031157880 |
ATCHREL_ID |
Primary Key |
I0000873 |
ATCHOBJTYP_ID |
Non-Unique Index |
I0000874 |
ATCHTGT_ID |
Non-Unique Index |
I0000877 |
ATCHRLUS_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1113 |
ATCHOBJTYP_ID |
ATCHOBJTYP |
ATCHOBJTYP_ID |
Cascade |
F_1122 |
ATCHRLUS_ID |
ATCHRLUS |
ATCHRLUS_ID |
Cascade |
F_1114 |
ATCHTGT_ID |
ATCHTGT |
ATCHTGT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1116 |
ATCHREL_ID |
ATCHRELDSC |
ATCHREL_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.