Item_status Table
The item_status table holds information about the status of an item. Item status values are created and changed in this table. Referential integrity constraints prevent deletion of an item status code that is currently in use. Any entry of item_status in the item table is validated by the presence of an item_status entry in the item_status table. This data validation could also be enforced with a trigger.
- The item_status column is the primary key. Notice that this is not an identity key. In this table we care what the value of the key is. The value has meaning, and an identity column where the key is a sequentially assigned number would not always support the meaning of the key values.
- The descr column is the description of the item status.
- The available_for_request column is a Boolean field that indicates whether the item to which the status is assigned is available for request. The data type is bit. Other tables indicate a Boolean field by the data type tinyint; both data types work to indicate a Boolean field. The default is 0 or False.
- The n_items column is the number of items assigned to this status.