Available Vehicle Capacity & Deliveries

The "Deliveries" table records detailed information about each delivery. It includes the delivery ID, vehicle number, order details, loaded capacity, start and end dates, and the vehicle's total and remaining capacity. This table is essential for tracking each delivery's progress and ensuring that vehicles are utilized efficiently while meeting delivery schedules.

The "Vehicles" table contains information about the vehicles used for deliveries. It includes the vehicle number, year, make, model, engine size, carrier name, and capacity details. This table helps in managing the fleet by providing a clear overview of each vehicle's specifications and current capacity, ensuring that the right vehicle is assigned to each delivery task.

The "Orders" table tracks orders placed by customers. It includes the order ID, status, customer company, dispatch and expected delivery dates, total and loaded capacity, destination address, weight, and shipment details. This table is crucial for managing orders, monitoring their progress, and ensuring that all delivery requirements are met.

The "Customers" table stores information about the companies that place orders. It includes the company name, registration number, address, phone, email, website, contact details, and notes. This table helps in maintaining accurate customer records, facilitating communication, and providing excellent customer service.

The "Contacts" table keeps track of individual contacts within customer companies. It includes the contact person's name, job title, phone numbers, email, and notes. This table is essential for maintaining detailed records of all key contacts, ensuring that communication is targeted and effective.

The "User Properties" table records information about users of the database. It includes details such as the record owner, created by, date created, last modified by, user email, first and last names, role, and access dates. This table is important for managing user access and roles, ensuring that the database is used securely and efficiently by authorized personnel.