Warehouse Inventory Management

The Office Locations table stores details about each office, including the Office Name and Office Address, serving as a directory for office-based operations and locations that may coordinate with warehouses.

The Warehouses table provides information about the warehouses connected to each office location. It includes fields such as Office Location Name, Warehouse Name, and Address, offering a clear overview of where inventory is stored.

The Employees table records employee details like First Name, Last Name, and their respective Supervisors. This table helps track which employees are managing specific tasks and which supervisors oversee them.

The Items of Equipment table keeps a record of all the equipment in the system, including Name and Description. This serves as a catalog of all items that may be stored in the warehouses or assigned to employees.

The Items Status table tracks the current condition or Status of each item, along with relevant dates. This helps in monitoring whether items are available, in use, or under maintenance.

The Items in Warehouses table records the placement of equipment in different warehouses, including the Item Name, Warehouse Name, and assignment details such as Given To Employee and Date From. This helps ensure an accurate log of inventory and the movement of items between locations and personnel.

The Tasks table details various assignments or tasks, including Task Name and Description, helping manage what tasks need to be completed and which employees are assigned to them.

The Employee Items on Tasks table connects specific tasks with the employees and equipment assigned to them. It tracks details such as Employee Name, Task Name, Item Name, and task timelines like Start Date and End Date. This ensures that the right equipment is allocated to employees for their tasks, streamlining the workflow and use of resources.

This database allows efficient tracking of inventory, task assignments, and item usage within warehouses, making sure that equipment is well-managed and allocated correctly.