Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ATCHRLUSDS

This table holds the description of an attachment relation usage.

Column Name Column Type Description
ATCHRLUSDS_ID INTEGER NOT NULL The primary key to the attachment relation usage description.
ATCHRLUS_ID INTEGER NOT NULL The attachment relation usage ID.
LANGUAGE_ID INTEGER NOT NULL The language ID.
NAME VARCHAR(128) The language dependent name of the attachment relation usage.
SHORTDESCRIPTION VARCHAR(254) The short description for the attachment relation usage.
LONGDESCRIPTION VARCHAR(4000) The long description for the attachment relation usage.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000879 ATCHRLUS_ID+LANGUAGE_ID Unique Index
SQL100520030258030 ATCHRLUSDS_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1120 ATCHRLUS_ID ATCHRLUS ATCHRLUS_ID Cascade
F_1121 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search