Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATCHREL
This table holds the attachment relation between a business object and an attachment target.
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. BIGINTOBJECT_ID BIGINT The bigintobject ID is the primary key(BigInt type) of the business object that owns the attachment relation OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000860 ATCHOBJTYP_ID+OBJECT_ID+ATCHRLUS_ID+ATCHTGT_ID Unique Index SQL100520030257580 ATCHREL_ID Primary Key I0000873 ATCHOBJTYP_ID Non-Unique Index I0000874 ATCHTGT_ID Non-Unique Index I0000877 ATCHRLUS_ID Non-Unique Index I0001207 BIGINTOBJECT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Names Constraint Type F_1116 ATCHREL_ID ATCHRELDSC ATCHREL_ID Cascade _vcc_freeselect_bottom_