Database – Bracket Item Entity (bracket_item_entity)
Updated 1 week ago
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 | Other |
id | int(11) | The id of the entity | ||
bracket_id | char(100) | ID of associated bracket | ||
bracket_item_begin | decimal(11,2) | Begining 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 | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |