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