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