ds

Tables (14)

business_location

  • Location_ID — int(11) — Primary key — NOT NULL
  • 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

  • Contract_ID — int(11) — Primary key — NOT NULL
  • Start_Date — date
  • End_Date — date
  • Revenue_Ratio — decimal(5,2)
  • Location_ID — int(11) — Foreign key → business_location.Location_ID — NOT NULL

invoice

  • Invoice_Num — int(11) — Primary key — NOT NULL
  • Invoice_Date — date
  • Ship_Date — date
  • Term — varchar(255)
  • Customer_Tell — varchar(255)
  • Vendor_ID — int(11) — Foreign key → vendor.Vendor_ID

machine

  • Serial_Number — int(11) — Primary key — NOT NULL
  • Purchase_Date — date
  • Purchase_Price — decimal(10,2)
  • Repair_Count — int(11)
  • Status — varchar(255)
  • Invoice_Num — int(11) — Foreign key → invoice.Invoice_Num — NOT NULL
  • Contract_ID — int(11) — Foreign key → contract.Contract_ID — NOT NULL

move_order

  • Move_Order_ID — int(11) — Primary key — NOT NULL
  • Move_Order_Date — date
  • Technician_ID — int(11) — Foreign key → technician.Technician_ID — NOT NULL

movement

  • Movement_ID — int(11) — Primary key — NOT NULL
  • Movement_Date — date
  • Type — varchar(255)
  • Location_ID — int(11) — Foreign key → business_location.Location_ID
  • Serial_Number — int(11) — Foreign key → machine.Serial_Number
  • Move_Order_ID — int(11) — Foreign key → move_order.Move_Order_ID

product

  • Product_ID — int(11) — Primary key — NOT NULL
  • Type — varchar(255)
  • Manufacturer — varchar(255)
  • Product_Name — varchar(255)
  • Company_Info — varchar(255)

product_invoice

  • Product_Invoice_ID — int(11) — Primary key — NOT NULL
  • Invoice_Num — int(11) — Foreign key → invoice.Invoice_Num
  • Product_ID — int(11) — Foreign key → product.Product_ID
  • Qty — int(11)
  • 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(11) — Primary key — NOT NULL
  • Purchase_Order_ID — int(11) — Foreign key → purchase_order.Purchase_Order_ID
  • Product_ID — int(11) — Foreign key → product.Product_ID
  • Qty — int(11)
  • Unit_Price — decimal(10,2)
  • Total_Order_Amount — decimal(10,2)

purchase_order

  • Purchase_Order_ID — int(11) — Primary key — NOT NULL
  • Purchase_Date — date
  • Buyer — varchar(255)
  • Vendor_ID — int(11) — Foreign key → vendor.Vendor_ID

purchase_qty

  • Purchase_Qty_ID — int(11) — Primary key — NOT NULL
  • Product_ID — int(11) — Foreign key → product.Product_ID
  • Qty — int(11)

purchase_request

  • Purchase_Request_ID — int(11) — Primary key — NOT NULL
  • Purchase_Request_Date — date
  • Manager — varchar(255)
  • Comment — text
  • Location_ID — int(11) — Foreign key → business_location.Location_ID — NOT NULL
  • Purchase_Qty_ID — int(11) — Foreign key → purchase_qty.Purchase_Qty_ID — NOT NULL

technician

  • Technician_ID — int(11) — Primary key — NOT NULL
  • Technician_Name — varchar(255)

vendor

  • Vendor_ID — int(11) — Primary key — NOT NULL
  • Vendor_Name — varchar(255)
  • Vendor_Address — varchar(255)
  • Vendor_Postal_Code — varchar(20)
  • Vendor_Tel_Num — varchar(20)
  • Vendor_Fax_Num — varchar(20)