ATCHRLUSDS

This table holds the description of an attachment relation usage.


Column Descriptions:

Name Type Description
ATCHRLUSDS_ID INTEGER NOT NULL The primary key to the attachment relation usage description.
ATCHRLUS_ID INTEGER NOT NULL The attachment relation usage ID.
LANGUAGE_ID INTEGER NOT NULL The language ID.
NAME VARCHAR (128) The language dependent name of the attachment relation usage.
SHORTDESCRIPTION VARCHAR (254) The short description for the attachment relation usage.
LONGDESCRIPTION VARCHAR (4000) The long description for the attachment relation usage.
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> ATCHRLUSDS_ID Primary Key
I0000879 ATCHRLUS_ID+LANGUAGE_ID Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1120 ATCHRLUS_ID ATCHRLUS ATCHRLUS_ID Cascade
F_1121 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade