ERD

Tables (7)

CAREGORY_ITEM (CopyOfCopyOfUntitled22)

  • CATEGORY_ID (Key2) — Foreign key → CATEGOET.CATEGORY_ID — NOT NULL
  • ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL

CATEGOET (CopyOfCopyOfCopyOfUntitled22)

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

DELIVERY (CopyOfCopyOfUntitled2)

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

ITEM (CopyOfUntitled2)

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

MEMBER (CopyOfCopyOfUntitled)

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

ORDERS (CopyOfUntitled)

  • ODER_ID (Key) — Primary key — NOT NULL
  • MEMBER_ID (Key4) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID (Key2) — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
  • ORDERDATE (Field3)
  • STATUS (Field4)

ORDER_ITEM_ID (Untitled)

  • ODER_ITEM_ID (Key) — Primary key — NOT NULL
  • ODER_ID (Key2) — Foreign key → ORDERS.ODER_ID — NOT NULL
  • ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • ORDERPRICE (Field3)
  • COUNT (Field4)