ㄴㅇㄹ

Tables (14)

Business_Location

  • Location_ID — INT
  • Location_Name — VARCHAR(255)
  • Location_Address — VARCHAR(255)
  • Postal_Code — VARCHAR(20)
  • Location_Tel — VARCHAR(20)
  • Owner_Tel — VARCHAR(20)
  • Owner_Name — VARCHAR(255)
  • Fax_Num — VARCHAR(20)
  • Manager_Name — VARCHAR(255)

Contract

  • Agreement_ID — INT
  • Start_Date — DATE
  • End_Date — DATE
  • Revenue_Ratio — DECIMAL(5, 2)
  • Vendor_ID — INT

Invoice

  • Invoice_Num — INT
  • Invoice_Date — DATE
  • Ship_Date — DATE
  • Term — VARCHAR(255)
  • Customer_Tell — VARCHAR(255)
  • Vendor_ID — INT

Machine

  • Serial_Number — INT
  • Purchase_Date — DATE
  • Purchase_Price — DECIMAL(10, 2)
  • Repair_Count — INT
  • Status — VARCHAR(255)

Move_Order

  • Move_Order_ID — INT
  • Move_Order_Date — DATE

Movement

  • Movement_ID — INT
  • Movement_Date — DATE
  • Type — VARCHAR(255)
  • Location_ID — INT
  • Serial_Number — INT
  • Move_Order_ID — INT

Product

  • Product_ID — INT
  • Type — VARCHAR(255)
  • Manufacturer — VARCHAR(255)
  • Product_Name — VARCHAR(255)
  • Company_Info — VARCHAR(255)

Product_Invoice

  • Invoice_Num — INT
  • Product_ID — INT
  • Qty — INT
  • Unit_Price — DECIMAL(10, 2)
  • Amount — DECIMAL(10, 2)
  • Sub_Total — DECIMAL(10, 2)
  • Shipping_Charge — DECIMAL(10, 2)
  • Sales_Tax — DECIMAL(10, 2)
  • Credit_Due — DECIMAL(10, 2)
  • Total_Due — DECIMAL(10, 2)

Product_Purchase_Order

  • Product_Purchase_Order_ID — INT
  • Purchase_Order_ID — INT
  • Product_ID — INT
  • Qty — INT
  • Unit_Price — DECIMAL(10, 2)
  • Total_Order_Amount — DECIMAL(10, 2)

Purchase_Order

  • Purchase_Order_ID — INT
  • Purchase_Date — DATE
  • Buyer — VARCHAR(255)
  • Vendor_ID — INT

Purchase_Qty

  • Purchase_Qty_ID — INT
  • Purchase_Request_ID — INT
  • Product_ID — INT
  • Qty — INT

Purchase_Request

  • Purchase_Request_ID — INT
  • Purchase_Request_Date — DATE
  • Manager — VARCHAR(255)
  • Comment — TEXT — EX

Technician

  • Technician_ID — INT
  • Technician_Name — VARCHAR(255)

Vendor

  • Vendor_ID — INT
  • Vendor_Name — VARCHAR(255)
  • Vendor_Address — VARCHAR(255)
  • Vendor_Postal_Code — VARCHAR(20)
  • Vendor_Tel_Num — VARCHAR(20)
  • Vendor_Fax_Num — VARCHAR(20)