Database – Collateral Field Entity (collateral_field_entity)
Description
This holds meta-data about the four primary fields available to all collateral types (labelled "A","B","C","D"). The id and collateral_type fields have values that come from the API.
Column | Data Type | Column Info | Value Notes | Other |
id | char(50) | The id of the entity | ||
collateral_type | char(50) | Collection for the type of the associated collateral | ||
data_type | enum | Type of data stored in collateral field |
| |
max_length | mediumint(9) | The maximum length of the value | ||
label | varchar(255) | The label of the entity instance | ||
required | tinyint(1) | Whether or not a field is requried to create an entity instance | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no |