MEMBERINFO

Tables (7)

CATEGORY

  • CATEGORY_ID — INT — Primary key — NOT NULL
  • PARENT_ID — VARCHAR
  • NAME — VARCHAR

CATEGORY_ITEM

  • ITEM_ID — INT — Foreign key → ITEM.ITEM_ID — NOT NULL
  • CATEGORY_ID — INT — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL

DELIVERY

  • DELIVERY_ID — INT — Primary key — NOT NULL
  • CITY — VARCHAR
  • STREET — VARCHAR
  • ZIPCODE — INT
  • STATUS — VARCHAR

ITEM

  • ITEM_ID — INT — Primary key — NOT NULL
  • NAME — VARCHAR
  • PRICE — INT
  • STOCKQUANTITY — INT

MEMBER

  • MEMBER_ID — INT — Primary key — NOT NULL
  • NAME — VARCHAR
  • CITY — VARCHAR
  • STREET — VARCHAR
  • ZIPCODE — INT

ORDERS

  • ORDER_ID — INT — Primary key — NOT NULL
  • ORDERDATE — DATE
  • STATUS — VARCHAR
  • MEMBER_ID — INT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID — INT — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL

ORDER_ITEM

  • ORDER_ID — INT — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • ORDERPRICE — INT
  • COUNT — INT
  • ITEM_ID — INT — Foreign key → ITEM.ITEM_ID — NOT NULL