Database Table: COLLTYPE

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

Column Name Column Type Column Description
COLLTYPE_ID INTEGER
NOT NULL
The internal reference number of the Collateral Type.
NAME VARCHAR (254)
NULL
The name of the Collateral Type.
Indexes:
Index Name Indexed Column Names Index Type
SQL030625034932520 COLLTYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_248 COLLTYPE_ID COLLATERAL COLLTYPE_ID Cascade