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_


+

Search Tips   |   Advanced Search