WebSphere Commerce database table: ATCHOBJTYP

WebSphere Commerce database table: ATCHOBJTYP

This table holds the information about the types of business objects that are configured to have attachments. For example, attachments can be associated to CATALOG, CATGROUP, and CATENTRY business objects.
Column Descriptions
Column Name Column Type Description
ATCHOBJTYP_ID INTEGER NOT NULL The primary key of the attachment object type.
IDENTIFIER CHAR(32) NOT NULL The identifier of the attachment object type. For example, CATALOG is used to represent that the object type in an attachment relationship is of type Catalog.
SEQUENCE DOUBLE NOT NULL DEFAULT 0 The sequence number.
DESCRIPTION VARCHAR(254) The administrative description for the attachment object type.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000853 IDENTIFIER Unique Index
SQL060903235125660 ATCHOBJTYP_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1113 ATCHOBJTYP_ID ATCHREL ATCHOBJTYP_ID Cascade

Column Name	Column Type	Description
ATCHOBJTYP_ID	INTEGER NOT NULL	The primary key of the attachment object type.
IDENTIFIER	CHAR(32) NOT NULL	The identifier of the attachment object type. For example, CATALOG is used to represent that the object type in an attachment relationship is of type Catalog.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	The sequence number.
DESCRIPTION	VARCHAR(254)	The administrative description for the attachment object type.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
I0000853	IDENTIFIER	Unique Index
SQL060903235125660	ATCHOBJTYP_ID	Primary Key