06.20 ERD

Tables (6)

CATEGORY

  • CATEGORY_ID — NUMBER — Primary key
  • PARENT_ID — NUMBER
  • NAME — VARCHAR(50)

CATEGORY_ITEM

  • CATEGORY_ID — NUMBER — Foreign key → CATEGORY.CATEGORY_ID
  • ITEM_ID — NUMBER — Foreign key

DELIVERY

  • DELIVERY_ID — VARCHAR(20 — Primary key
  • CITY — VARCHAR(50)
  • STREET — VARCHAR(50)
  • ZIPCODE — VARCHAR(10)
  • STATUS — VARCHAR(20)

MEMBER

  • MEMBER_ID — NUMBER — Primary key
  • NAME — VARCHAR(50)
  • CITY — VARCHAR(50)
  • STREET — VARCHAR(50)
  • ZIPCODE — VARCHAR(10)

ORDERS

  • ORDER_ID — NUMBER — Primary key
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID
  • DELIVERY_ID — VARCHAR(20 — Foreign key → DELIVERY.DELIVERY_ID
  • ORDERDATE — DATE
  • STATUS — VARCHAR(20)

ORDER_ITEM

  • ORDER_ITEM_ID — NUMBER — Primary key
  • ITEM_ID — NUMBER — Foreign key
  • ORDER_ID — NUMBER — Foreign key → ORDERS.ORDER_ID
  • ORDERPRICE — NUMBER
  • COUNT — NUMBER