ERP
Tables (4)
ClientMember (clientMember)
- ID (id) — varchar2(20) — Primary key — NOT NULL
- PW (pw) — varchar2(20)
- Company (corp) — varchar2(30)
Order List (orderList)
- Order Number (orderNum) — number
- Trad Company Name (tradCorpName) — varchar2(20)
- Order Date (orderDate) — varchar2(20)
- Product Name (productName2) — varchar2(30) — Foreign key → Stock List.Product Name — NOT NULL
- Quantity (quantity) — number
- Price (price) — number
- Total Price (totalPrice) — number
Sell List (estimate)
- Estimate Number (estNum) — number
- Estimate Company (estCorp) — varchar2(20)
- Estimate Date (estDate) — varchar2(20)
- Product Name (productName2) — varchar2(30) — Foreign key → Stock List.Product Name — NOT NULL
- Quantity (quantity) — number
- Unit Price (unitprice) — number
- Supply Price (supplyPrice) — number
Stock List (stockList)
- Product Name (productName) — varchar2(30) — Primary key — NOT NULL
- Location (loc) — varchar2(20)
- Product Supply Company Name (productCorpName) — varchar2(20)
- Total Quantity (totalQuantity) — number