Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ATCHRLUS

This table holds usage information for attachment relations. For example, an attachment can be a warranty document related to a product. In this case the usage is 'warranty'.

Column Name Column Type Description
ATCHRLUS_ID INTEGER NOT NULL The primary key for the attachment relation usage.
IDENTIFIER VARCHAR(254) The identifier for the attachment relation usage. For example, 'Image'.
IMAGE VARCHAR(254) The image path that represent the attachment relation usage.
SEQUENCE DOUBLE The sequence number.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000878 IDENTIFIER Unique Index
SQL100520030257890 ATCHRLUS_ID Primary Key

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1122 ATCHRLUS_ID ATCHREL ATCHRLUS_ID Cascade
F_1120 ATCHRLUS_ID ATCHRLUSDS ATCHRLUS_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search