TCTYPE

This table contains the types of terms and conditions.

Column Descriptions:

NameTypeDescription
TCTYPE_IDCHAR (64) NOT NULLA unique identifier for the term or condition.
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>TCTYPE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_831TCTYPE_IDTCSUBTYPETCTYPE_IDCascade