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:

NameTypeDescription
ATCHOBJTYP_IDINTEGER NOT NULLThe primary key of the attachment object type.
IDENTIFIERCHAR (32) NOT NULLThe 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.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence number.
DESCRIPTIONVARCHAR (254)The administrative description for the attachment object type.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ATCHOBJTYP_IDPrimary Key
I0000853IDENTIFIERUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1113ATCHOBJTYP_IDATCHRELATCHOBJTYP_IDCascade