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)