ERD_한수민

테이블 (7)

CAREGORY_ITEM (category_item)

  • CATEGORY_iD (category_id) — INT — 외래 키 → CATEGORY.CATEGORY_iD — NOT NULL
  • ITEM_ID (item_id) — INT — 외래 키 → ITEM.ITEM_ID — NOT NULL

CATEGORY (category)

  • CATEGORY_iD (category_id) — INT — 기본 키 — NOT NULL
  • PARENT_ID (parent_id) — INT
  • NAME (name) — VARCHAR

DELIVERY (delivery)

  • DELIVERY_ID (delivery_id) — INT — 기본 키 — NOT NULL
  • CITY (city) — VARCHAR
  • STREET (street) — VARCHAR
  • ZIPCODE (zipcode) — INT
  • STATUS (status) — VARCHAR

ITEM (item)

  • ITEM_ID (item_id) — INT — 기본 키 — NOT NULL
  • NAME (name) — VARCHAR
  • PRICE (price) — INT
  • STOCKQUANTITY (stockquantity) — INT

MEMBER (member)

  • MEMBER_ID (member_id) — INT — 기본 키 — NOT NULL
  • NAME (name) — VARCHAR
  • CITY (city) — VARCHAR
  • STREET (street) — VARCHAR
  • ZIPCODE (zipcode) — INT

ORDERS (orders)

  • ORDER_ID (order_id) — INT — 기본 키 — NOT NULL
  • MEMBER_ID (member_id) — INT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID (delivery_id) — INT — 외래 키 → DELIVERY.DELIVERY_ID — NOT NULL
  • ORDERDATE (orderdate) — DATE
  • STATUS (Field) — VARCHAR

ORDER_ITEM (order_item)

  • ODER_ITEM_ID (order_item_id) — INT — 기본 키 — NOT NULL
  • ORDER_ID (order_id) — INT — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • ITEM_ID (item_id2) — INT — 외래 키 → ITEM.ITEM_ID — NOT NULL
  • ORDERPRICE (orderprice) — INT
  • COUNT (count) — INT