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_


+

Search Tips   |   Advanced Search