ㄴㅇㄹ
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)