WebSphere Commerce database table: ATCHREL

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


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex 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 NameColumn Name(s)Foreign Table NameForeign 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 NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1116 ATCHREL_ID ATCHRELDSC ATCHREL_ID Cascade

Feedback