편의점

테이블 (4)

ITEM

  • ITEM_NUMBER — INTEGER — 기본 키 — NOT NULL
  • ITEM_NAME — VARCHAR(20)
  • ITEM_TYPE — VARCHAR(20)
  • ITEM_VALUE — INTEGER

ITEM_MANAGEMENT

  • ITEM_NUMBER — INTEGER — 외래 키 → ITEM.ITEM_NUMBER — NOT NULL
  • ITEM_EXPIRATION DATE — DATE
  • ITEM_COUNT — INTEGER

ORDER

  • ITEM_NUMBER — INTEGER — 외래 키 → ITEM.ITEM_NUMBER — NOT NULL
  • ORDER_COUNT — INTEGER
  • ORDER_DATE — DATE
  • ORDER_SUPPLIER — VARCHAR(20)

SALES

  • ITEM_NUMBER — INTEGER — 외래 키 → ITEM.ITEM_NUMBER — NOT NULL
  • ITEM_TYPE — VARCHAR(20)
  • ITEM_SALES — INTEGER