편의점
테이블 (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