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