Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATCHRELDSC
This is a description table for an attachment relation.
Column Name Column Type Description ATCHRELDSC_ID BIGINT NOT NULL The unique identifier for this attachment relation description. ATCHREL_ID BIGINT NOT NULL The attachment relation ID. LANGUAGE_ID INTEGER NOT NULL The language ID. NAME VARCHAR(128) The language-dependent name for the attachment relation. SHORTDESCRIPTION VARCHAR(254) The short description for the attachment relation. LONGDESCRIPTION VARCHAR(4000) The long description for the attachment relation. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000861 ATCHREL_ID+LANGUAGE_ID Unique Index SQL100520030257740 ATCHRELDSC_ID Primary Key I0000875 ATCHREL_ID Non-Unique Index I0000876 LANGUAGE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1116 ATCHREL_ID ATCHREL ATCHREL_ID Cascade F_1117 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade _vcc_freeselect_bottom_