ERD

Tables (7)

Copy Of MEMBER_ID (MEMBER)

  • Key (MEMBER_ID) — Primary key — NOT NULL
  • Field (NAME)
  • Field (CITY)
  • Field (STREET)
  • Field (ZIPCODE)

Untitled (ORDERS)

  • Key (ORDER_ID) — Primary key — NOT NULL
  • Field (ORDERDATE)
  • Field (STATUS)
  • Key (DELIVERY_ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_ID) — Foreign key → Copy Of MEMBER_ID.Key — NOT NULL

Untitled (DELVERY)

  • Key (DELIVERY_ID) — Primary key — NOT NULL
  • Field (CITY)
  • Field (STREET)
  • Field (ZIPCODE)
  • Field (STATUS)

Untitled (ORDER_ITEM)

  • Key (ORDER_ITEM_ID) — Primary key — NOT NULL
  • Field (ORDERPRICE)
  • Field (COUNT)
  • Key (ORDER_ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ITEM_ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (ITEM)

  • Key (ITEM_ID) — Primary key — NOT NULL
  • Field (NAME)
  • Field (PRICE)
  • Field (STOCKQUANTITY)

Untitled (CATEGIRY_ITEM)

  • Key (ITEM_ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (CATEGORY_ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (CATEGORY)

  • Key (CATEGORY_ID) — Primary key — NOT NULL
  • Key (PARENT_ID) — Primary key — NOT NULL
  • Field (NAME)