ATCHTGTDSC

This table holds the description of an attachment target.

Column Descriptions:

NameTypeDescription
ATCHTGTDSC_IDBIGINT NOT NULLThe primary key of the attachment target description.
ATCHTGT_IDBIGINT NOT NULLThe attachment target ID.
LANGUAGE_IDINTEGER NOT NULLThe language ID.
NAMEVARCHAR (128)The language dependent name of the attachment target.
SHORTDESCRIPTIONVARCHAR (254)The short description of the attachment target.
LONGDESCRIPTIONVARCHAR (4000)The long description of the attachment target.
UP_NAMEVARCHAR (128)The equivalent value of the NAME 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.
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>ATCHTGTDSC_IDPrimary Key
I0000855ATCHTGT_ID+LANGUAGE_IDUnique Index
I0000865ATCHTGT_IDNon-Unique Index
I0000866LANGUAGE_IDNon-Unique Index
I0001208NAMENon-Unique Index
IPF00019UP_NAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1105ATCHTGT_IDATCHTGTATCHTGT_IDCascade
F_1106LANGUAGE_IDLANGUAGELANGUAGE_IDCascade