ERD

Tables (7)

CATEGORY (CATEGORY_ID)

  • PARENT_ID(FK) — varchar — Primary key — NOT NULL
  • NAME — varchar

DELIVERY (DELIVERY_ID)

  • CITY — varchar — Primary key — NOT NULL
  • STREET — varchar
  • ZIPCODE — number
  • STATUS — varchar
  • MEMBER_ID(FK) — varchar — Foreign key → OPDERS.MEMBER_ID(FK) — NOT NULL

ITEM (ITEM_ID)

  • NAME — varchar — Primary key — NOT NULL
  • PRICE — number
  • STOCKQUNTITY — varchar

MEMBER (MEMBER_ID)

  • NAME — varchar — Primary key — NOT NULL
  • CITY — varchar
  • STREET — varchar
  • ZIPCODE — number

OPDERS (ORDER_ID)

  • MEMBER_ID(FK) — varchar — Primary key — NOT NULL
  • DELIVERY_ID(FK) — varchar
  • ORDERDATE — date
  • STATUS — varchar
  • NAME — varchar — Foreign key → MEMBER.NAME — NOT NULL

ORDER_ITEM (ORDER_ITEM_ID)

  • ORDER_ID(FK) — varchar — Primary key — NOT NULL
  • ITEM_ID(FK) — varchar
  • ORDERPRICE — number
  • COUNT — number
  • MEMBER_ID(FK) — varchar — Foreign key → OPDERS.MEMBER_ID(FK) — NOT NULL
  • NAME — varchar — Foreign key → ITEM.NAME — NOT NULL

Untitled

  • CATEGORY_ID(FK) — varchar — Primary key — NOT NULL
  • NAME — varchar — Foreign key → ITEM.NAME — NOT NULL
  • PARENT_ID(FK) — varchar — Foreign key → CATEGORY.PARENT_ID(FK) — NOT NULL
  • ITEM_ID(FK) — varchar