/** WLC Inventory SQL **/

Items

• id
• identifier unique_identifier
• description
• status
• datetime_added
• datetime_updated
• datetime_deleted

Departments

• id
• name

Department_Items

• item_id
• department_id

Requisition

• id
• type
• department_id
• requester_id
• provider_id
• purpose
• datetime_added
• datetime_provided

Item_Requisition

• item_id
• requesition_id

Users

• id
• email
• password
• firstname
• lastname
• middlename
• status
• user_type