ATCHTGT

This table holds information about the target, which is used to hold a collection of assets, for use as an attachment target.

Column Descriptions:

NameTypeDescription
ATCHTGT_IDBIGINT NOT NULLThe primary key to the attachment target.
STOREENT_IDINTEGER NOT NULL DEFAULT 0The store entity ID that owns the attachment target.
MEMBER_IDBIGINT NOT NULLThe owner of the attachment target.
IDENTIFIERVARCHAR (128) NOT NULLThe identifier that represents the attachment target.
ATTACHUSG_IDCHAR (64)The attachment usage ID for the attachment.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Reserved for IBM internal use.
FIELD1BIGINTCustomizable.
FIELD2DOUBLECustomizable.
FIELD3VARCHAR (254)Customizable.
FIELD4VARCHAR (254)Customizable.
UP_IDENTIFIERVARCHAR (128)The equivalent value of the IDENTIFIER column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
OPTCOUNTERSMALLINTThe 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>ATCHTGT_IDPrimary Key
I0000854STOREENT_ID+MEMBER_ID+IDENTIFIERUnique Index
I0000862STOREENT_IDNon-Unique Index
I0000863MEMBER_IDNon-Unique Index
I0000864ATTACHUSG_IDNon-Unique Index
IPF00018UP_IDENTIFIERNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1102STOREENT_IDSTOREENTSTOREENT_IDCascade
F_1103MEMBER_IDMEMBERMEMBER_IDCascade
F_1104ATTACHUSG_IDATTACHUSGATTACHUSG_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1105ATCHTGT_IDATCHTGTDSCATCHTGT_IDCascade
F_1108ATCHTGT_IDATCHASTATCHTGT_IDCascade
F_1114ATCHTGT_IDATCHRELATCHTGT_IDCascade