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