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