ERD

Tables (7)

CATEGORY (범주)

  • CATEGORY_ID (범주아이디) — VARCHAR — Primary key — NOT NULL
  • PARENT_ID (부모) — VARCHAR
  • NAME (이름) — VARCHAR

CATEGORY_ITEM (범주 아이템)

  • CATEGORY_ID(FK) (범주아이디) — VARCHAR — Primary key — NOT NULL
  • ITEM_ID(FK) (아이템아이디) — VARCHAR
  • CATEGORY_ID (범주아이디2) — VARCHAR — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • ITEM_ID (아이템ID) — VARCHAR — Foreign key → ITEM.ITEM_ID — NOT NULL

DELIVERY (배달)

  • DELIVERY_ID (배달아이디) — VARCHAR — Primary key — NOT NULL
  • CITY (지역) — VARCHAR
  • STREET (거리) — VARCHAR
  • ZIPCODE (우편번호) — VARCHAR
  • STATUS (상태) — VARCHAR

ITEM (아이템)

  • ITEM_ID (아이템ID) — VARCHAR — Primary key — NOT NULL
  • NAME (이름) — VARCHAR
  • PRICE (가격) — NUMBER
  • STOCKQUANTITY (재고수량) — NUMBER

MEMBER (회원)

  • MEMBER_ID (회원) — VARCHAR — Primary key — NOT NULL
  • NAME (이름) — VACHAR
  • CITY (지역) — VACHAR
  • STREET (거리) — VARCHAR
  • ZIPCODE (우편번호) — NUMBER

ORDERS (명령)

  • ORDER_ID(FK) (명령아이디) — VARCHAR — Primary key — NOT NULL
  • MEMBER_ID(FK) (회원아이디) — VARCHAR
  • ORDERDATE (주문일) — NUMBER
  • STATUS (상태) — VARCHAR
  • MEMBER_ID (회원2) — VARCHAR — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID (배달아이디) — VARCHAR — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL

ORDER_ITEM (주문한것)

  • ORDER_ITEM_ID (주문한것아이디) — VARCHAR — Primary key — NOT NULL
  • ITEM_ID(FK) (아이템아이디) — VARCHAR
  • ORDER_ID(FK) (주문아이디) — VARCHAR
  • ORDERPRICE (주문한가격) — NUMBER
  • COUNT (돈을 세다) — NUMBER
  • ORDER_ID(FK) (명령아이디) — VARCHAR — Foreign key → ORDERS.ORDER_ID(FK) — NOT NULL
  • CATEGORY_ID(FK) (범주아이디) — VARCHAR — Foreign key → CATEGORY_ITEM.CATEGORY_ID(FK) — NOT NULL