ㅇㄴ

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)