collateral_field_entity - 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

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

  • text
  • number
  • date

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


How did we do?


Powered by HelpDocs (opens in a new tab)