Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ATCHASTLG

This table holds the attachment asset to language relationship.

Column Name Column Type Description
ATCHASTLG_ID BIGINT NOT NULL The primary key of the attachment asset language.
ATCHAST_ID BIGINT NOT NULL The attachment asset ID.
LANGUAGE_ID INTEGER The language ID.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000859 ATCHAST_ID+LANGUAGE_ID Unique Index
SQL100520030257190 ATCHASTLG_ID Primary Key
I0000871 ATCHAST_ID Non-Unique Index
I0000872 LANGUAGE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1111 ATCHAST_ID ATCHAST ATCHAST_ID Cascade
F_1112 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search