Nomad

Tables (9)

group

  • group_id — INT — Primary key — NOT NULL
  • group_num — INT
  • member_list — varchar(20)

group_order

  • group_order_id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → group.group_id
  • store_id — INT — Foreign key → store.store_id
  • order_status — INT
  • delivery_id — INT
  • delivery_date — varchar(20)
  • address — varchar(20)
  • grouptype — varchar(20)
  • maxValue — INT
  • latitude — DOUBLE
  • longitude — DOUBLE
  • buildingName — varchar(20)
  • orderStatus — varchar(20

member

  • member_id — INT — Primary key — NOT NULL
  • member_nickname — varchar(20)
  • member_email — varchar(20)
  • member_phone — varchar(20)
  • token — varchar(20)
  • member_point — INT
  • member_type — INT
  • group_id — INT — Foreign key → group.group_id
  • chat_id — INT

member_order

  • member_order_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → member.member_id
  • total_cost — INT
  • order_date — varchar(20)
  • group_order_id — INT — Foreign key → group_order.group_order_id
  • store_id — INT — Foreign key → store.store_id
  • payMethod — varchar(20)
  • orderTime — varchar(20)
  • Field

menu

  • menu_id — INT — Primary key — NOT NULL
  • store_id — INT — Foreign key → store.store_id
  • menu_name — varchar(20)
  • menu_price — INT
  • description — varchar(300)
  • imgUrl — varchar(300)

order_detail

  • member_order_id — INT — Foreign key → member_order.member_order_id
  • payment — INT
  • manu_id — INT
  • manu_name — varchar(20)
  • menu_cost — INT
  • menu_quantity — INT
  • menu_detail — varchar(20)
  • menu_id — INT — Foreign key → menu.menu_id

review

  • review_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → member.member_id
  • member_order_id — INT — Foreign key → member_order.member_order_id
  • review_comment — varchar(20)
  • created — varchar(20)
  • review_star — DOUBLE

review_reply

  • reply — varchar(20) — Primary key — NOT NULL
  • review_id — INT — Foreign key → review.review_id
  • store_id — INT — Foreign key → store.store_id
  • reply_comment — varchar(20)
  • created — varchar(20)

store

  • store_id — INT — Primary key — NOT NULL
  • store_name — varchar(20)
  • store_address — varchar(20)
  • phoneNumber — varchar(20)
  • store_open — varchar(20)
  • member_id — INT — Foreign key → member.member_id
  • latitude — DOUBLE
  • longitude — DOUBLE
  • openTime — varchar(20)
  • closeTime — varchar(20)
  • deliveryTip — INT
  • logoUrl — varchar(300)