COLLTYPE

This table defines all possible types of Collateral. Examples of Collateral types are image, flash and text.

Column Descriptions:

NameTypeDescription
COLLTYPE_IDINTEGER NOT NULLThe internal reference number of the Collateral Type.
NAMEVARCHAR (254)The name of the Collateral Type.
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>COLLTYPE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_248COLLTYPE_IDCOLLATERALCOLLTYPE_IDCascade