Database – Bracket Item Entity (bracket_item_entity)
Description
Bracket item entities hold bracket ranges for search brackets. A '0.00' in the bracket_item_end symbolizes an infinite boundary. The additional_value field is reserved for future use.
Column | Data Type | Column Info | Value Notes |
id | int(11) | The id of the entity | |
bracket_id | char(100) | ID of associated bracket | |
bracket_item_begin | decimal(11,2) | Beginning value of bracket item | |
bracket_item_end | decimal(11,2) | Ending value of the bracket item | |
additional_value | decimal(11,2) | Additional value information for the bracket item | Unused. |
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes 0 - no |
created | timestamp | When the entity was created | |
lastUpdated | timestamp | When the entity was last updated |