Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATCHTGTDSC
This table holds the description of an attachment target.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000855 ATCHTGT_ID+LANGUAGE_ID Unique Index SQL100520030258310 ATCHTGTDSC_ID Primary Key I0000865 ATCHTGT_ID Non-Unique Index I0000866 LANGUAGE_ID Non-Unique Index I0001208 NAME Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1105 ATCHTGT_ID ATCHTGT ATCHTGT_ID Cascade F_1106 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade _vcc_freeselect_bottom_