Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATCHTGT
This table holds information about the target, which is used to hold a collection of assets, for use as an attachment target.
Column Name Column Type Description ATCHTGT_ID BIGINT NOT NULL The primary key to the attachment target. STOREENT_ID INTEGER NOT NULL DEFAULT 0 The store entity ID that owns the attachment target. MEMBER_ID BIGINT NOT NULL The owner of the attachment target. IDENTIFIER VARCHAR(128) NOT NULL The identifier that represents the attachment target. ATTACHUSG_ID CHAR(64) The attachment usage ID for the attachment. MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use. FIELD1 BIGINT Customizable. FIELD2 DOUBLE Customizable. FIELD3 VARCHAR(254) Customizable. FIELD4 VARCHAR(254) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000854 STOREENT_ID+MEMBER_ID+IDENTIFIER Unique Index SQL100520030258170 ATCHTGT_ID Primary Key I0000862 STOREENT_ID Non-Unique Index I0000863 MEMBER_ID Non-Unique Index I0000864 ATTACHUSG_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1104 ATTACHUSG_ID ATTACHUSG ATTACHUSG_ID Cascade F_1103 MEMBER_ID MEMBER MEMBER_ID Cascade F_1102 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1108 ATCHTGT_ID ATCHAST ATCHTGT_ID Cascade F_1114 ATCHTGT_ID ATCHREL ATCHTGT_ID Cascade F_1105 ATCHTGT_ID ATCHTGTDSC ATCHTGT_ID Cascade _vcc_freeselect_bottom_