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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000854 STOREENT_ID+MEMBER_ID+IDENTIFIER Unique Index
SQL050212031158410 ATCHTGT_ID Primary Key
I0000862 STOREENT_ID Non-Unique Index
I0000863 MEMBER_ID Non-Unique Index
I0000864 ATTACHUSG_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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 NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback