ㅇㄴㅇ

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)