Table: Collateral Field Entity

Table: Collateral Field Entity

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
idchar(50)The id of the entity
collateral_typechar(50)Collection for the type of the associated collateral
data_typeenumType of data stored in collateral field
  • text
  • number
  • date
max_lengthmediumint(9)The maximum length of the value
labelvarchar(255)The label of the entity instance
requiredtinyint(1)Whether or not a field is requried to create an entity instance1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List