2026-2027届小程序/APP毕业设计优质选题汇总：百个热门方向完整推荐

每天都在改Bug的切图仔

286人浏览 · 2026-07-09 14:16:02

每天都在改Bug的切图仔 · 2026-07-09 14:16:02 发布

前言

📌博主介绍：一线全栈工程师，毕设实战引路人。技术栈覆盖Java、Python、C#、PHP、Node.js及UniApp跨端开发，擅长多语言项目落地与架构设计。持续分享毕设源码、开题报告、技术选型心得与职场踩坑经验。用工程化思维写代码，帮你把毕设做成作品集。👍👍

毕业设计选题越来越重要，也越来越让同学感到焦虑。（切记先收藏起来）

很多同学不知道该如何确定题目，也不清楚导师真正关注的是什么，导致选题阶段浪费了很多时间。（选题指导）

其实，选题阶段最重要的不是一开始就想一个 “完美题目”，而是先把自己能做什么、感兴趣什么、导师可能认可什么理清楚。很多同学之所以选题困难，往往是因为没有把研究方向、题目来源、实践条件和论文写作要求结合起来考虑。（选题避坑）

如果选题没有做好，后面的开题、调研、实验、写作都会受到影响。因此，建议大家在正式确定题目之前，先多查资料、多和导师沟通，尽量选择一个既有研究价值、又有数据和案例支撑的题目。（有疑问可随时咨询，免费解答）

也可以参考一些优秀的毕业设计题目，帮助自己打开思路，避免走弯路（收藏，收藏，收藏~）

文章最下面，获取源码和数据库

小程序/APP选题参考

基于微信小程序的宠物交易平台的设计与实现
基于微信小程序的“猿小机”电脑DIY商城
“银发乐享”—基于微信小程序的老年人娱乐活动平台
基于微信小程序的乡村助农系统
基于微信小程序的“云净坊”洗护平台
基于微信小程序的宠物知识和服务平台
基于微信小程序的导盲眼镜设备管理系统
基于微信点餐小程序
基于微信小程序的健身服务平台
基于微信小程序的厨艺帮设计与开发
基于微信小程序的个性书籍推荐与比价系统的设计与实现
外卖小程序
拾光纱语婚纱摄影服务小程序
CampusSwap二手物品交易微信小程序
校园跑腿小程序
“学迹”校园生活互助服务APP
企业知识学习APP
手机移动购物App
退休老人再就业app
中医舌象分析app
景区智能推荐app
校园导览APP
校园生活助手APP
旅游攻略APP
面向学习效率提升的协同专注APP
基于鸿蒙系统的小红书APP
企业采购APP
个人健康管理与运动追踪APP
校园交易市场App
上课签到APP
个人体检系统APP
小区团购管理APP
keysDoctor开智健身房小程序
校园体测服务微信小程序
基于微信点餐小程序
非遗文创商城小程序
患者陪诊服务小程序
大学生时间胶囊小程序
智能科室推荐与预约挂号小程序
社区生活服务小程序
角色扮演委托服务小程序
招聘服务小程序
宠物医生在线接诊小程序
智能水果识别微信小程序
社区便民服务App
共享充电桩导航APP
智能健身打卡app
基于用户画像的个性化旅游向导APP
宠乐付APP
武夷岩茶购物App
个性化健康饮食app
个人财务管理APP
青岛旅游APP
个人运动打卡与健康数据记录App
“幸福花店”线上销售小程序
城市共享车位微信小程序
大学生消费记账小程序
基于微信小程序的健身服务平台
实验室设备报修小程序
“茶速达”奶茶点餐小程序
智能健康管理助手小程序
高校心理咨询与测评小程序
流浪动物管理小程序
儿童成长档案小程序
某饭店点菜小程序
行测学习智能分析小程序
社区老年人健康管理小程序
校园二手物品交易小程序
鲜花礼品销售小程序
家庭物品数字化管理与智能提醒小程序
社区团购系统小程序
少儿编程培训APP后台管理系统
老年人手机助手APP
宿舍管理APP
GZ市蔬菜水果配送app
学习自律APP
旅游助手APP
高校图书馆座位预约APP
多模态AI创意内容生成APP
野生动物智能识别APP
关爱独居老人健康APP
个人科研记录APP
情绪追踪与可视化APP
家政服务app
车载语音无障碍交互APP
学生点名APP
大学校园二手商品交易小程序
空气质量数据在线分析与预警小程序
易跑拉货搬家小程序
网吧综合管理小程序
少儿古诗词AI学习小程序
陇南乡镇政务服务预约小程序
递道生鲜社区团购微信小程序
焕颜美容预约小程序
校园自习室预约小程序
校园教材循环小程序的交易系统
高校寻物平台小程序
阳光网上文具商城小程序
宠物寄养小程序
在线心理咨询服务小程序
时间管理服务小程序
梦幻空间音乐播放器小程序
校园快递代取小程序
食堂订餐微信小程序
四川自驾游攻略管理小程序
高校请假管理小程序
高校餐厅在线点餐小程序
健身房预约管理小程序
健身指导小程序
河南美食详鉴小程序
小四川饭店智能点餐小程序

数据库参考

CREATE TABLE `auth` (
  `auth_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '授权ID',
  `user_group` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户组',
  `mod_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '模块名',
  `table_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '表名',
  `page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '页面标题',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '路由路径',
  `parent` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父级菜单',
  `parent_sort` int(10) NOT NULL DEFAULT '0' COMMENT '父级菜单排序',
  `position` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '位置',
  `mode` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '_blank' COMMENT '跳转方式',
  `add` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可增加',
  `del` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可删除',
  `set` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可修改',
  `get` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可查看',
  `field_add` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '添加字段',
  `field_set` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '修改字段',
  `field_get` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '查询字段',
  `table_nav_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '跨表导航名称',
  `table_nav` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '跨表导航',
  `option` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '配置',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`auth_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户权限管理';
DROP TABLE IF EXISTS `upload`;
CREATE TABLE `upload` (
  `upload_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '上传ID',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件名',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '访问路径',
  `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件路径',
  `display` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '显示顺序',
  `father_id` int(11) DEFAULT '0' COMMENT '父级ID',
  `dir` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件夹',
  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件类型',
  PRIMARY KEY (`upload_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文件上传';
insert into `upload` values ('1','movie.mp4','/upload/movie.mp4','',null,'0',null,'video');
DROP TABLE IF EXISTS `logistics_delivery`;
CREATE TABLE `logistics_delivery` (
  `logistics_delivery_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '物流配送ID',
  `order_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
  `product_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品名称',
  `purchase_quantity` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '购买数量',
  `total_transaction_amount` double(10,2) DEFAULT '0.00' COMMENT '交易总额',
  `the_date_of_issuance` date DEFAULT NULL COMMENT '发货日期',
  `delivery_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '配送订单',
  `ordinary_users` int(11) DEFAULT '0' COMMENT '普通用户',
  `shipping_address` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收货地址',
  `delivery_status` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '配送状态',
  `signing_status` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '签收状态',
  `recommend` int(11) NOT NULL DEFAULT '0' COMMENT '智能推荐',
  `contact_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人名字',
  `merchant_id` int(11) DEFAULT NULL COMMENT '商家id',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `courier_type` int(11) NOT NULL DEFAULT '1' COMMENT '配送方式（1：商家配送，2：其他配送）',
  `courier_id` int(11) DEFAULT NULL COMMENT '配送员ID',
  `courier_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配送员名字',
  `courier_detail` longtext COLLATE utf8mb4_general_ci COMMENT '配送详情',
  PRIMARY KEY (`logistics_delivery_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='物流配送';
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '产品ID',
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
  `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '封面图：用于显示于产品列表页',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `price_ago` double(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '原价',
  `price` double(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '卖价',
  `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量',
  `inventory` int(11) NOT NULL DEFAULT '0' COMMENT '商品库存',
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品分类',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击量',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '正文',
  `img_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '主图1',
  `img_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '主图2',
  `img_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '主图3',
  `img_4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '主图4',
  `img_5` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '主图5',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `customize_field` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '自定义字段',
  `source_table` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源表',
  `source_field` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源字段',
  `source_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '添加人',
  `integral` int(11) DEFAULT '0' COMMENT '积分',
  `list_status` smallint(1) DEFAULT '1' COMMENT '上架状态（0：下架；1上架）',
  PRIMARY KEY (`goods_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品信息';
insert into `goods` values ('1','测试商品1','/upload/goods.jpg','测试商品1','110.0','99.0','0','80','分类一','0','<p>测试商品1</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','5','1','0','1');
insert into `goods` values ('2','测试商品2','/upload/goods.jpg','测试商品2','220.0','110.0','0','10','分类二','0','<p>测试商品2</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','6','1','0','1');
insert into `goods` values ('3','测试商品3','/upload/goods.jpg','测试商品3','20.0','10.0','0','10','分类二','0','<p>测试商品3</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','7','1','0','1');
insert into `goods` values ('4','测试商品4','/upload/goods.jpg','测试商品4','199.0','99.0','0','20','分类二','0','<p>测试商品4</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','8','1','0','1');
insert into `goods` values ('5','测试商品5','/upload/goods.jpg','测试商品5','110.0','99.0','0','30','分类二','0','<p>测试商品5</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','9','1','0','1');
insert into `goods` values ('6','测试商品6','/upload/goods.jpg','测试商品6','999.0','888.0','0','40','分类三','0','<p>测试商品6</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','10','1','0','1');
insert into `goods` values ('7','测试商品7','/upload/goods.jpg','测试商品7','20.0','220.0','0','110','分类一','0','<p>测试商品7</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','11','1','0','1');
insert into `goods` values ('8','测试商品8','/upload/goods.jpg','测试商品8','20.0','30.0','0','30','分类二','0','<p>测试商品8</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','12','1','0','1');
insert into `goods` values ('9','测试商品9','/upload/goods.jpg','测试商品9','40.0','35.0','0','20','分类三','0','<p>测试商品9</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','13','1','0','1');
insert into `goods` values ('10','测试商品10','/upload/goods.jpg','测试商品10','50.0','45.0','0','80','分类一','0','<p>测试商品10</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','14','1','0','1');
insert into `goods` values ('11','测试商品11','/upload/goods.jpg','测试商品11','60.0','50.0','0','10','分类二','0','<p>测试商品11</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','15','1','0','1');
insert into `goods` values ('12','测试商品12','/upload/goods.jpg','测试商品12','70.0','60.0','0','30','分类三','0','<p>测试商品12</p>','/upload/img_1.jpg','/upload/img_2.jpg','/upload/img_3.jpg','/upload/img_4.jpg','/upload/img_5.jpg','2026-04-16 11:28:32','2026-04-16 11:28:32','[{"field_name":"品牌","field_value":""},{"field_name":"规格","field_value":""}]','mall_center','mall_center_id','16','1','0','1');
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
  `cart_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '购物车ID',
  `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '图片',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `state` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态：使用中，已失效',
  `price` double(8,2) NOT NULL DEFAULT '0.00' COMMENT '单价',
  `price_ago` double(8,2) NOT NULL DEFAULT '0.00' COMMENT '原价',
  `price_count` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '总价',
  `num` int(8) unsigned NOT NULL DEFAULT '1' COMMENT '数量',
  `goods_id` mediumint(8) unsigned NOT NULL COMMENT '商品id',
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未分类' COMMENT '商品分类',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `norms` varchar(64) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '规格',
  PRIMARY KEY (`cart_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='购物车';
DROP TABLE IF EXISTS `message_inform`;
CREATE TABLE `message_inform` (
  `message_inform_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '通知ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '通知人ID',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `state` varchar(255) DEFAULT NULL COMMENT '状态',
  `type` varchar(64) DEFAULT NULL COMMENT '分类',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`message_inform_id`) USING BTREE,
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='通知记录';
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `order_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `order_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
  `goods_id` mediumint(8) unsigned NOT NULL COMMENT '商品ID',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品标题',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品图片',
  `price` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
  `price_ago` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '原价',
  `num` int(8) NOT NULL DEFAULT '1' COMMENT '数量',
  `price_count` double(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总价',
  `norms` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '规格',
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未分类' COMMENT '商品分类',
  `contact_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人姓名',
  `contact_email` varchar(125) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人邮箱',
  `contact_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人手机',
  `contact_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收件地址',
  `postal_code` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮政编码',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '买家ID',
  `merchant_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `state` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '待付款' COMMENT '订单状态：待付款，待发货，待签收，已签收，待退款，已退款，已拒绝，已完成',
  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '订单备注',
  `delivery_state` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '未配送' COMMENT '发货状态：未配送，已配送',
  `vip_discount` double(10,2) DEFAULT '0.00' COMMENT '折扣',
  `integral` int(11) DEFAULT '0' COMMENT '积分',
  `buy_type` tinyint(2) DEFAULT '1' COMMENT '1-全额购买，2-积分兑换，3-钱包购买',
  `desc` varchar(64) COLLATE utf8mb4_general_ci DEFAULT '其他原因' COMMENT '取消订单原因',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单';
DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
  `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组ID',
  `display` smallint(4) unsigned NOT NULL DEFAULT '100' COMMENT '显示顺序',
  `name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '描述',
  `source_table` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源表',
  `source_field` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源字段',
  `source_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
  `register` smallint(1) unsigned DEFAULT '0' COMMENT '注册位置',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户组';
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `article_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章id',
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '文章分类',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
  `praise_len` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '来源',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '来源地址',
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标签',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '正文',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '封面图',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '文章描述',
  PRIMARY KEY (`article_id`,`title`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文章';
DROP TABLE IF EXISTS `access_token`;
CREATE TABLE `access_token` (
  `token_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '临时访问牌ID',
  `token` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '临时访问牌',
  `info` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '信息',
  `maxage` int(2) NOT NULL DEFAULT '2' COMMENT '最大寿命：默认2小时',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户编号',
  PRIMARY KEY (`token_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='登陆访问时长';
DROP TABLE IF EXISTS `code_token`;
CREATE TABLE `code_token` (
  `code_token_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '验证码ID',
  `token` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '令牌',
  `code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '验证码',
  `expire_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '失效时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`code_token_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='验证码';
DROP TABLE IF EXISTS `vip_level`;
CREATE TABLE `vip_level` (
  `vip_level_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '等级ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '等级名称',
  `discount` double(10,2) NOT NULL COMMENT '折扣',
  `price` double(10,2) DEFAULT NULL COMMENT '会员价格',
  `description` text COLLATE utf8mb4_general_ci COMMENT '会员权益',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`vip_level_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='论坛分类';
insert into `vip_level` values ('4','黄金会员','0.85',null,null,'2026-04-16 11:28:32','2026-04-16 11:28:32');
DROP TABLE IF EXISTS `collect`;
CREATE TABLE `collect` (
  `collect_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '收藏ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收藏人ID',
  `source_table` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源表',
  `source_field` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来源字段',
  `source_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '封面',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`collect_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='收藏';
DROP TABLE IF EXISTS `customer_chat_group`;
CREATE TABLE `customer_chat_group` (
  `customer_chat_group_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '沟通群组ID',
  `member` text NOT NULL COMMENT '成员信息',
  `read_state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '已读状态，0=未读，1=已读',
  `last_read_time` timestamp NULL DEFAULT NULL COMMENT '最后阅读时间',
  `unread_count` int(11) DEFAULT '0' COMMENT '未读消息数',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`customer_chat_group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='在线沟通群组表';
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `notice_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `title` varchar(125) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '正文',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`notice_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='公告';

代码参考

{
  "navigationBarTitleText": "生鲜商品列表",
  "usingComponents": {
    "tn-nav-bar": "/tuniao-ui/components/tn-nav-bar/tn-nav-bar",
    "uni-pagination": "/uni_modules/uni-pagination/components/uni-pagination/uni-pagination",
    "search": "/components/businessCp/search",
    "me-dropdown": "/components/me-dropdown/index"
    "navigationBarTitleText": "商家用户列表",
  "usingComponents": {
    "tn-nav-bar": "/tuniao-ui/components/tn-nav-bar/tn-nav-bar",
    "uni-forms": "/uni_modules/uni-forms/components/uni-forms/uni-forms",
    "uni-forms-item": "/uni_modules/uni-forms/components/uni-forms-item/uni-forms-item",
    "uni-easyinput": "/uni_modules/uni-easyinput/components/uni-easyinput/uni-easyinput",
    "uni-pagination": "/uni_modules/uni-pagination/components/uni-pagination/uni-pagination",
    "date-range-picker": "/components/date-range-picker/date-range-picker",
    "date-selector": "/components/dengrq-datetime-picker/dateSelector/index"
  "navigationBarTitleText": "普通用户列表",
  "usingComponents": {
    "tn-nav-bar": "/tuniao-ui/components/tn-nav-bar/tn-nav-bar",
    "uni-forms": "/uni_modules/uni-forms/components/uni-forms/uni-forms",
    "uni-forms-item": "/uni_modules/uni-forms/components/uni-forms-item/uni-forms-item",
    "uni-easyinput": "/uni_modules/uni-easyinput/components/uni-easyinput/uni-easyinput",
    "uni-pagination": "/uni_modules/uni-pagination/components/uni-pagination/uni-pagination",
    "date-range-picker": "/components/date-range-picker/date-range-picker",
    "date-selector": "/components/dengrq-datetime-picker/dateSelector/index"
  "navigationBarTitleText": "微信授权登录",
  "enablePullDownRefresh": false,
  "usingComponents": {
    "tn-nav-bar": "/tuniao-ui/components/tn-nav-bar/tn-nav-bar",
    "uni-popup": "/uni_modules/uni-popup/components/uni-popup/uni-popup"
  "navigationBarTitleText": "评论",
  "usingComponents": {
    "tn-nav-bar": "/tuniao-ui/components/tn-nav-bar/tn-nav-bar",
    "uni-easyinput": "/uni_modules/uni-easyinput/components/uni-easyinput/uni-easyinput",
    "t-color-picker": "/pagesB/components/t-color-picker"
  "navigationBarTitleText": "生鲜资讯详情",
  "usingComponents": {
    "tn-nav-bar": "/tuniao-ui/components/tn-nav-bar/tn-nav-bar",
    "uni-card": "/uni_modules/uni-card/components/uni-card/uni-card",
    "list_article": "/components/diy/list_article",
    "div_article": "/components/diy/div_article",
    "list_comment": "/components/diy/list_comment"
  "navigationBarTitleText": "购物车",
  "usingComponents": {
    "tn-nav-bar": "/tuniao-ui/components/tn-nav-bar/tn-nav-bar",
    "tn-tabbar": "/tuniao-ui/components/tn-tabbar/tn-tabbar",
    "list_cart": "/components/diy/list_cart",
    "list_goods": "/components/diy/list_goods"