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)