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.