ERD

Tables (7)

CATEGORY (Untitled6)

  • CATEGORY_ID (Key) — Primary key — NOT NULL
  • NAME (ename) — varchar
  • PARENT_ID (pid) — varchar — NOT NULL

CATEGORY_ITEM (ITEM_ID)

  • ITEM_ID (iid2) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
  • CATEGORY_ID (Key) — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL

DELIVERY (Untitled4)

  • DELIVERY_ID (did) — varchar — Primary key — NOT NULL
  • STREET (str) — varchar
  • ZIPCODE (zcode) — varchar
  • STATUS (status) — varchar
  • CITY (city) — varchar — NOT NULL

ITEM (Untitled5)

  • ITEM_ID (iid) — varchar — Primary key — NOT NULL
  • PRICE (eprice) — number
  • STOCKQUANTITY (sto) — varchar
  • NAME (ename) — varchar — NOT NULL

MEMBER (Untitled3)

  • MEMBER_ID (mid) — varchar — Primary key — NOT NULL
  • CITY (Field) — varchar
  • STREET (Field2) — varchar
  • ZIPCODE (Field3) — varchar
  • NAME (ename) — varchar — NOT NULL

ORDER _ITEM (Untitled)

  • ORDER_ITEM_ID (oii) — varchar — Primary key — NOT NULL
  • ORDERPRICE (oprice) — number
  • COUNT (cnt) — number
  • ORDER_ID (oid2) — varchar — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • ITEM_ID (iid2) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL

ORDERS (Untitled2)

  • ORDER_ID (oid) — varchar — Primary key — NOT NULL
  • DELIVERY_ID (Field) — varchar
  • ORDERDATE (Field2) — varchar
  • STATUS (Field3) — varchar
  • MEMBER_ID (mid2) — varchar — Foreign key → MEMBER.MEMBER_ID — NOT NULL