实训设计-仿星巴克小程序

小程序后端设计

后端数据库设计

classification表

id	typename	type
1	咖啡	coffee
2	点心	cake
3	周边产品	pro

image表

id	imageurl	imagetype	iamgetitle
1	https://artwork.starbucks.com.cn/banners-mp-homepage/main_d7fa4e91-d8a1-400d-8bea-e330b8a598e0.jpg	banner-mp	首页轮播背景
2	https://artwork.starbucks.com.cn/banners-mp-homepage/main_6acf5679-8e54-44d5-8200-7e0101712423.gif	banner-mp	首页轮播背景
3	https://artwork.starbucks.com.cn/banners-mp-home-tabs-mop/main_95de8913-a2f0-4ede-940e-e89e63d95e09.png	banner-tabs	首页按钮
4	https://artwork.starbucks.com.cn/banners-mp-home-tabs-mod/main_315dbfdc-6ae2-45c2-8965-145fe64a672a.png	banner-tabs	首页按钮
5	https://artwork.starbucks.com.cn/banners-mp-mod/main_55041b45-5502-4328-806a-e2ac87221daf.jpg	banner-bottom	首页轮播
6	https://artwork.starbucks.com.cn/banners-mp-mod/main_2df8a1df-c491-4f8e-9060-1a27dd379e05.jpg	banner-bottom	首页轮播
7	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/wel_back.png	member-level	银星级
8	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/green_back.png	member-level	玉星级
9	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/gold_back.png	member-level	金星级
10	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/wel_star.svg	member-little	银星级小星星
11	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/green_star.svg	member-little	玉星级小星星
12	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/gold_star.svg	member-little	金星级小星星
13	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/wel_image_two.png	member-wel	可直通玉星级并获赠玉星晋级饮品券
14	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/wel_image_three.png	member-wel	各类奖励星星活动
15	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/icon_now.png	member-rule	积分规则小图标
16	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/icon_delivery.png	member-rule	积分规则小图标
17	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/icon_store.png	member-rule	积分规则小图标
18	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/no_star.png	member-record	无记录图片
19	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_setting_new.png	mine-set	设置按钮
20	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_jiangpin.png	mine-starbuck	奖品
21	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_kafeihao_new.png	mine-starbuck	星咖号
22	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_presents.png	mine-starbuck	我的礼物
23	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_address_new.png	mine-function	地址
24	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_bill.png	mine-function	发票
25	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_gzh.png	mine-function	公众号
26	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_kefu.png	mine-function	客服
27	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_terms_new.png	mine-function	条款与证明
28	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/default_head.png	mine-head	默认头像
29	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/header_img_welcome.png	mine-background	背景
30	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/mine/icon_coupon_num.png	mine-coupon	礼券图标
31	https://artwork.starbucks.com.cn/banners-mp-mod/main_688818cc-ba69-41e3-a4f4-8a896dfc8457.png	banner-bottom	首页轮播
32	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/green_one.png	member-green	玉星晋级饮品券
33	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/green_two.png	member-green	生日饮品券
34	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/green_three.png	member-green	金星在望饮品券
35	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/star_image_flag.png	member-green	永享玉星级
36	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/gold_one.png	member-gold	金星晋级饮品券
37	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/green_two.png	member-gold	生日饮品券
38	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/gold_three.png	member-gold	周年庆饮品券
39	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/gold_four.png	member-gold	好礼星星兑换
40	https://active.starbucks.com.cn/wxmini_vanilla/prod/images/member/gold_five.png	member-gold	金星级专属电子星礼卡

orders表

id	openid	title	num	makedate	username	placedate	usertell	state	temperature	size
1		燕麦奶	1	2022/04/08 23:38:56	张月函	2022-04-08	18848428080	0	热	中杯

products表

id	imageurl	title	price	type
1	https://pcmd.starbucks.com.cn/MopPics/202012/186-MOPCatalog-0-342x324_2-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	燕麦奶	39	coffee
2	https://pcmd.starbucks.com.cn/MopPics/202012/186-MOPCatalog-0-342x324_2-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	经典瑞士卷	29	cake
3	https://pcmd.starbucks.com.cn/MopPics/202201/106-MOP-0-342x324_1641286564179-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	浓郁咖啡拿铁	37	coffee
4	https://pcmd.starbucks.com.cn/MopPics/202202/410-MOP-0-342x324_1645496962081-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	山茶花星冰乐	41	coffee
5	https://pcmd.starbucks.com.cn/MopPics/202202/407-MOP-0-342x324_1645496954470-zh.png?resize=p_4,w_228&image_process=image/resize,w_228,	山茶花拿铁	41	coffee
6	https://pcmd.starbucks.com.cn/MopPics/202202/404-MOP-0-342x324_1645496945905-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	樱花拿铁	41	coffee
7	https://pcmd.starbucks.com.cn/MopPics/202202/405-MOP-0-342x324_1645496948923-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	樱花星冰乐	41	coffee
8	https://pcmd.starbucks.com.cn/MopPics/202202/406-MOP-0-342x324_1645496951724-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	漫樱白桃拿铁	41	coffee
9	https://pcmd.starbucks.com.cn/MopPics/202202/6110403-MOP-0-342x324_1645539924455-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	便携式滴滤咖啡	79	pro
10	https://pcmd.starbucks.com.cn/MopPics/202111/710018874-MOP-0-342x324_1637737180737-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	红酒牛肉酥	35	cake
11	https://pcmd.starbucks.com.cn/MopPics/202108/C19032596-MOP-0-342x324_0-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	都爱拿铁组合(12杯)	396	coffee
12	https://pcmd.starbucks.com.cn/MopPics/202109/281-MOP-0-342x324_1-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	燕麦丝绒拿铁	39	coffee
13	https://pcmd.starbucks.com.cn/MopPics/202012/16-MOPCatalog-0-342x324-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	馥芮白	38	coffee
14	https://pcmd.starbucks.com.cn/MopPics/202012/44-MOPCatalog-0-342x324-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	拿铁	33	coffee
15	https://pcmd.starbucks.com.cn/MopPics/202012/34-MOPCatalog-0-342x324-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	美式咖啡	30	coffee
16	https://pcmd.starbucks.com.cn/MopPics/202012/104-MOPCatalog-0-342x324-zh.png?resize=p_4,w_228&image_process=image/resize,w_228	经典巧克力饮品	33	coffee

user表

id	nickname	openid	imageurl	sessionkey	token	username	phone	password	userlevel	address
1	哈哈哈	oFCod5DOVTGHt5Qx0_bt2_ddYWEI	https://thirdwx.qlogo.cn/mmopen/vi_32/AXRG7vypnphvVn7BWanmfbbpSfJqlsOZKDOibdObL6kEVtxwwHicUkej7PtnkELwpYh5T2gSQUiclolxGlibvN63Rw/132	kE5hx2KRlvhsXCXXpI0SXA==	562f8056ba69f867fd244bee8ffd4096	张月函	18848428080	3651e5f096ce2396d1a570364dc4df0d	1	四川省成都市锦江区xx街道