ㅇㄴㅇ
Tables (12)
ASSET
- AssetID — INT
- ProductID — INT
- ManufacturerID — INT
- PurchaseOrderID — INT
- InvoiceID — INT
- AssetSerialNo — VARCHAR(50)
- AcquisitionDate — DATE
- AcquisitionCost — DECIMAL(10, 2)
BUSINESS_LOCATION
- BusinessLocationName — VARCHAR(255)
- BusinessLocationAddress — VARCHAR(255)
- BusinessLocationPhoneNo — VARCHAR(20)
CONTRACT
- ContractID — INT
- BusinessLocationName — VARCHAR(255)
- ContractStartDate — DATE
- ContractEndDate — DATE
INSTALLS_REMOVES_ASSET
- InstallRemoveID — INT
- AssetID — INT
- BusinessLocationName — VARCHAR(255)
- DateInstalledRemoved — DATE
INVOICE
- InvoiceID — INT
- VendorName — VARCHAR(255)
- PurchaseOrderID — INT
- InvoiceDate — DATE
- Terms — VARCHAR(255)
- ShipDate — DATE
- DueDate — DATE
- Total — DECIMAL(10, 2)
MACHINE_PURCHASE_REQUEST
- MachinePurchaseRequestID — INT
- DateOfRequest — DATE — NOT NULL
- ManufacturerID — INT
- ProductID — INT
- QuantityRequested — INT
MANUFACTURER
- ManufacturerID — INT
- ManufacturerName — VARCHAR(255) — NOT NULL
MOVE_ORDER
- MoveOrderID — INT
- BusinessLocationName — VARCHAR(255)
- AssetID — INT
- MoveOrderDate — DATE
PRODUCT
- ProductID — INT
- ProductName — VARCHAR(255) — NOT NULL
- ManufacturerID — INT
- ProductType — VARCHAR(50)
- AcquisitionDate — DATE
- AcquisitionCost — DECIMAL(10, 2)
PRODUCT_ON_REQUEST
- ProductOnRequestID — INT
- MachinePurchaseRequestID — INT
- ProductID — INT
- ManufacturerID — INT
- QuantityRequested — INT
PURCHASE_ORDER
- PurchaseOrderID — INT
- VendorName — VARCHAR(255)
- ProductID — INT
- ManufacturerID — INT
- OrderDate — DATE
- QuantityPurchased — INT
- UnitPurchasePrice — DECIMAL(10, 2)
VENDOR
- VendorName — VARCHAR(255)
- VendorPhoneNo — VARCHAR(20)
- VendorAddress — VARCHAR(255)
- VendorAffiliateNumber — VARCHAR(100)