chair
Tables (16)
ChairMaterials
- chairMaterialID — INT
- chairRefID — INT
- materialRefID — INT
- materialName — VARCHAR(50)
- quantityRequired — INT
- pricePerUnit — DECIMAL(10, 2)
- totalMaterialCost — DECIMAL(10, 2)
Customers
- customerID — INT
- name — VARCHAR(100)
- contactInfo — VARCHAR(100)
- address — VARCHAR(100)
DefectiveProducts
- defectiveID — INT
- productRefID — INT
- quantity — INT
- status — VARCHAR(50)
DeliveryCompanies
- Key — Primary key — NOT NULL
- companyID — INT
- name — VARCHAR(100)
- contactInfo — VARCHAR(100)
- location — VARCHAR(100)
- estimatedDeliveryTime — INT
DeliveryRecords
- recordID — INT
- productRefID — INT
- companyRefID — INT
- quantity — INT
- deliveryDate — DATE
- orderDate — DATE
- receivedDate — DATE
- saleAmount — DECIMAL(10, 2)
DeliveryVehicles
- vehicleID — INT
- type — VARCHAR(50)
- status — VARCHAR(50)
- licensePlate — VARCHAR(20)
- yearModel — YEAR
- maintenanceInterval — INT
EmployeeManagement
- employeeID — INT
- name — VARCHAR(100)
- contactNumber — VARCHAR(15)
- age — INT
- gender — CHAR(1)
- birthdate — DATE
- annualWorkDays — INT
- monthlyWorkDays — INT
- remainingVacationDays — INT
- hireDate — DATE
- yearsOfService — INT
- position — VARCHAR(50)
- department — VARCHAR(50)
- canDrive — BOOLEAN
EmployeeSalary
- employeeSalaryID — INT
- employeeRefID — INT
- baseSalary — DECIMAL(10, 2)
- bonus — DECIMAL(10, 2)
- taxDeduction — DECIMAL(10, 2)
- totalSalary — DECIMAL(10, 2)
- salaryDate — DATE
FinancialRecords
- recordID — INT
- recordDate — DATE
- recordType — VARCHAR(50)
- transactionCategory — VARCHAR(50)
- description — TEXT
- amount — DECIMAL(10, 2)
- paymentMethod — VARCHAR(50)
- transactionStatus — VARCHAR(50)
- relatedEmployeeRefID — INT
- relatedMaterialRefID — INT
- relatedOrderRefID — INT
IncomingRecords
- incomingRecordID — INT
- materialRefID — INT
- incomingDate — DATE
- quantity — INT
MaintenanceRecords
- maintenanceRecordID — INT
- equipmentRefID — INT
- maintenanceDate — DATE
- description — TEXT
- cost — DECIMAL(10, 2)
Orders
- orderID — INT
- customerRefID — INT
- productRefID — INT
- companyRefID — INT
- deliveryRecordRefID — INT
- orderDate — DATE
- quantity — INT
- deliveryStatus — VARCHAR(50)
ProductInventory
- productID — INT
- name — VARCHAR(50)
- stockAmount — INT
- dispatchedAmount — INT
- price — DECIMAL(10, 2)
RawMaterials
- materialID — INT — Primary key
- name — VARCHAR(50)
- incomingAmount — INT
- consumedAmount — INT
- balance — INT
- price — DECIMAL(10, 2)
- supplierRefID — INT
Suppliers
- supplierID — INT — Primary key
- name — VARCHAR(100)
- contactInfo — VARCHAR(100)
- address — VARCHAR(100)
- unitPrice — DECIMAL(10, 2)
- minimumOrderAmount — DECIMAL(10, 2)
TruckDepartures
- departureID — INT
- vehicleRefID — INT
- loadedChairs — INT
- destination — VARCHAR(100)
- departureDate — DATE
- driver1RefID — INT
- driver2RefID — INT