MemberINFO

Tables (7)

CATEGORY

  • CATEGORY_ID — varchar — Primary key — NOT NULL
  • PARENT_ID — varchar
  • NAME — varchar

CATEGORY_ITEM

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

DELIVERY

  • DELIVERY_ID — varchar — Primary key — NOT NULL
  • CITY — varchar
  • STREET — varchar
  • ZIPCODE — varchar
  • STATUS — varchar

ITEM

  • ITEM_ID — varchar — Primary key — NOT NULL
  • NAME — varchar
  • PRICE — int
  • STOCKQUANTITY — int

MEMBER

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

ORDERS

  • ORDER_ID — varchar — Primary key — NOT NULL
  • MEMBER_ID — varchar — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID — varchar — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
  • ORDERDATE — date
  • STATUS — varchar

ORDER_ITEM

  • ORDER_ITEM_ID — varchar — Primary key — NOT NULL
  • ORDER_ID — varchar — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
  • ORDERPRICE — int
  • COUNT — int