ㅇㄴ
Tables (11)
ASSET
- AssetID — INT
- ProductID — INT
- PurchaseOrderID — INT
- AcquisitionDate — DATE
- AcquisitionCost — DECIMAL(15, 2)
BUSINESS_LOCATION
- LocationID — INT
- Address — VARCHAR(255)
- Phone — VARCHAR(20)
- ManagerName — VARCHAR(255)
CONTRACT
- ContractID — INT
- StartDate — DATE
- EndDate — DATE
- Details — TEXT
INVOICE
- InvoiceID — INT
- PurchaseOrderID — INT
- InvoiceDate — DATE
- TotalAmount — DECIMAL(15, 2)
MACHINE_PURCHASE_REQUEST
- RequestID — INT
- RequestDate — DATE
- EmployeeName — VARCHAR(255)
MANUFACTURER
- ManufacturerID — INT
- ManufacturerName — VARCHAR(255)
ORDER
- OrderID — INT
- LocationID — INT
- OrderDate — DATE
PURCHASE_ORDER
- PurchaseOrderID — INT
- OrderDate — DATE
- VendorID — INT
PURCHASE_REQUEST
- PurchaseRequestID — INT
- RequestID — INT
TECHNICIAN
- TechnicianID — INT
- Name — VARCHAR(255)
- SkillLevel — VARCHAR(50)
VENDOR
- VendorID — INT
- VendorName — VARCHAR(255)
- VendorPhone — VARCHAR(20)
- VendorEmail — VARCHAR(255)