ATCHRELDSC

This is a description table for an attachment relation.

Column Descriptions:

NameTypeDescription
ATCHRELDSC_IDBIGINT NOT NULLThe unique identifier for this attachment relation description.
ATCHREL_IDBIGINT NOT NULLThe attachment relation ID.
LANGUAGE_IDINTEGER NOT NULLThe language ID.
NAMEVARCHAR (128)The language-dependent name for the attachment relation.
SHORTDESCRIPTIONVARCHAR (254)The short description for the attachment relation.
LONGDESCRIPTIONVARCHAR (4000)The long description for the attachment relation.
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>ATCHRELDSC_IDPrimary Key
I0000861ATCHREL_ID+LANGUAGE_IDUnique Index
I0000875ATCHREL_IDNon-Unique Index
I0000876LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1116ATCHREL_IDATCHRELATCHREL_IDCascade
F_1117LANGUAGE_IDLANGUAGELANGUAGE_IDCascade