ATCHTGTDSC

This table holds the description of an attachment target.

Column Descriptions:

Name	Type	Description
ATCHTGTDSC_ID	BIGINT NOT NULL	The primary key of the attachment target description.
ATCHTGT_ID	BIGINT NOT NULL	The attachment target ID.
LANGUAGE_ID	INTEGER NOT NULL	The language ID.
NAME	VARCHAR (128)	The language dependent name of the attachment target.
SHORTDESCRIPTION	VARCHAR (254)	The short description of the attachment target.
LONGDESCRIPTION	VARCHAR (4000)	The long description of the attachment target.
UP_NAME	VARCHAR (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.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ATCHTGTDSC_ID	Primary Key
I0000855	ATCHTGT_ID+LANGUAGE_ID	Unique Index
I0000865	ATCHTGT_ID	Non-Unique Index
I0000866	LANGUAGE_ID	Non-Unique Index
I0001208	NAME	Non-Unique Index
IPF00019	UP_NAME	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1105	ATCHTGT_ID	ATCHTGT	ATCHTGT_ID	Cascade
F_1106	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade