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 |