Table: Bracket Entity

Table: Bracket Entity

This holds bracket information used in loan searches. Each bracket entity falls in a category. The ID and parent ID are pre-defined constants from the API. Bracket item entities hold the information of each bracket range.

Column Data Type Column Info Value Notes Other
idchar(100)The id of the entity
parent_idchar(100)ID of parent category
labelvarchar(255)The label of the entity instance
descriptionvarchar(255)The description of the entity instance
has_additional_valuetinyint(1)Whether or not this bracket has additional value information1 - yes, 0 - no
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List