3팀
테이블 (7)
CATEGORY (CopyOfUntitled4)
- CATEGORY_ID (Key) — NUMBER — 기본 키 — NOT NULL
- PARENT_ID (FK) — NUMBER
- NAME (Field) — VARCHAR2
CATEGORY_ITEM (Untitled5)
- CATEGORYID (KEY) — NUMBER — 기본 키 — NOT NULL
- ITEM_ID (Key2) — NUMBER — 외래 키 → ITEM.ITEM_ID — NOT NULL
- CATEGORY_ID (Key) — NUMBER — 외래 키 → CATEGORY.CATEGORY_ID — NOT NULL
- ITEM_ID (FK) — NUMBER
DELIVERY (CopyOfUntitled2)
- DELIVERY_ID (Key) — NUMBER — 기본 키 — NOT NULL
- CITY (Field) — VARCHAR2
- STREET (Field2) — VARCHAR2
- ZIPCODE (Field3) — VARCHAR2
- STATUS (Field4) — VARCHAR2
ITEM (CopyOfUntitled6)
- ITEM_ID (Key) — NUMBER — 기본 키 — NOT NULL
- NAME (Field) — VARCHAR2
- PRICE (Field2) — NUMBER
- STOCKQUANTITY (Field3) — VARCHAR2
MEMBER (CopyOfUntitled)
- MEMBER_ID (Key) — NUMBER — 기본 키 — NOT NULL
- NAME (Field) — VARCHAR2
- CITY (Field2) — VARCHAR2
- STREET (Field3) — VARCHAR2
- ZIPCODE (Field4) — VARCHAR2
ORDERS (CopyOfORDERS)
- ORDER_ID (Key) — NUMBER — 기본 키 — NOT NULL
- MEMBER_ID (FK) — VARCHAR2
- DELIVERY_ID (FK2) — VARCHAR2
- ORDERDATE (Field3) — DATE
- STATUS (Field4) — VARCHAR2
- MEMBER_ID (Key2) — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- DELIVERY_ID (Key3) — NUMBER — 외래 키 → DELIVERY.DELIVERY_ID — NOT NULL
ORDER_ITEM (Untitled3)
- ORDER_ITEM_ID (Key) — NUMBER — 기본 키 — NOT NULL
- ORDER_ID (FK) — NUMBER
- ITEM_ID (FK2) — NUMBER
- ORDERPRICE (Field) — NUMBER
- COUNT (Field2) — NUMBER
- ORDER_ID (Key2) — NUMBER — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (Key3) — NUMBER — 외래 키 → ITEM.ITEM_ID — NOT NULL