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 Descriptions

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
SQL060903235126720	ATCHRLUS_ID	Primary Key

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