WebSphere Commerce database table: ATCHTGTDSC

This table holds the description of an attachment target.


Column Description(s):
Column NameColumn TypeDescription
ATCHTGTDSC_ID BIGINT NOT NULL The primary key of the attachment target description.
ATCHTGT_ID BIGINT NOT NULL The attachment target ID.
LANGUAGE_ID INTEGER NOT NULL The language ID.
NAME VARCHAR(128) The language dependent name of the attachment target.
SHORTDESCRIPTION VARCHAR(254) The short description of the attachment target.
LONGDESCRIPTION VARCHAR(4000) The long description of the attachment target.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000855 ATCHTGT_ID+LANGUAGE_ID Unique Index
SQL050212031158530 ATCHTGTDSC_ID Primary Key
I0000865 ATCHTGT_ID Non-Unique Index
I0000866 LANGUAGE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1105 ATCHTGT_ID ATCHTGT ATCHTGT_ID Cascade
F_1106 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback