process1

Tables (6)

CLIENT (client)

  • CLIENT_NO (client_no) — int — Primary key — NOT NULL
  • NAME (name) — varchar
  • LOC (loc) — varchar
  • ADDR (addr) — varchar
  • ZIPCODE (zipcode) — int
  • TEL (tel) — varchar
  • MILE (mile) — int

DELIVERY (delivery)

  • INVOICE_NO (invoice_no) — int — Primary key — NOT NULL
  • DELIVERY_ADDR (delivery_addr) — varchar
  • DELIVERY_MODEL (delivery_model) — varchar
  • DELIVERY_QUANTITY (delivery_quantity) — int
  • CLIENT_NO (client_no) — int — Foreign key → CLIENT.CLIENT_NO — NOT NULL

EMP (emp)

  • EMP_NO (emp_no) — int — Primary key — NOT NULL
  • NAME (name) — varchar
  • TEL (tel) — varchar
  • JOB (job) — varchar

ORDER (order)

  • ORDER_NO (order_no) — int — Primary key — NOT NULL
  • ORDER_DATE (order_date) — date
  • CLIENT_NO (client_no) — int — Foreign key → CLIENT.CLIENT_NO — NOT NULL
  • EMP_NO (emp_no) — int — Foreign key → EMP.EMP_NO — NOT NULL

ORDER_ITEM (order_item)

  • ORDER_ITEM_NO (order_item_no) — int — Primary key — NOT NULL
  • MNAME (mname) — varchar
  • QUANTITY (quantity) — int
  • PRICE (price) — int
  • PRONO (pronno) — int — Foreign key → PRODUCT.PRONO — NOT NULL
  • ORDER_NO (order_no) — int — Foreign key → ORDER.ORDER_NO — NOT NULL

PRODUCT (product)

  • PRONO (pronno) — int — Primary key — NOT NULL
  • PNAME (pname) — varchar
  • MNAME (mname) — varchar
  • ORIGIN (origin) — varchar
  • PRICE (pirce) — int
  • INVEN (inven) — int
  • MAKER (maker) — varchar