stock
Tables (4)
CUSTOMER
- C_CODE — Primary key — NOT NULL
- C_NAME
- C_CEO
- C_ADDR
- C_PHONE
PRODUCT
- P_CODE (Key) — Primary key — NOT NULL
- P_NAME
- P_COST
- P_GROUP
STOCK
- P_CODE (Key) — Foreign key → PRODUCT.P_CODE — NOT NULL
- S_QTY
TRADE
- T_SEQ (Key) — Primary key — NOT NULL
- T_DATE
- T_QTY
- T_COST
- C_CODE — Foreign key → CUSTOMER.C_CODE — NOT NULL
- P_CODE (Key2) — Foreign key → PRODUCT.P_CODE — NOT NULL