java基于springboot婚庆信息系统（计算机毕业设计）

后端

---

数据库表设计

---

CREATE TABLE chat (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

userid bigint(20) NOT NULL COMMENT ‘用户id’,

adminid bigint(20) DEFAULT NULL COMMENT ‘管理员id’,

ask longtext COMMENT ‘提问’,

reply longtext COMMENT ‘回复’,

isreply int(11) DEFAULT NULL COMMENT ‘是否回复’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=1600669907600 DEFAULT CHARSET=utf8 COMMENT=‘客服聊天表’;

CREATE TABLE config (

id bigint(20) NOT NULL AUTO_INCREMENT,

name varchar(100) NOT NULL COMMENT ‘配置参数名称’,

value varchar(100) DEFAULT NULL COMMENT ‘配置参数值’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT=‘配置文件’;

CREATE TABLE dingdanxinxi (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

sheyingzhuti varchar(200) NOT NULL COMMENT ‘摄影主题’,

tuanduibianhao varchar(200) DEFAULT NULL COMMENT ‘团队编号’,

tuanduimingcheng varchar(200) DEFAULT NULL COMMENT ‘团队名称’,

tupian varchar(200) DEFAULT NULL COMMENT ‘图片’,

siyi varchar(200) DEFAULT NULL COMMENT ‘司仪’,

chedui varchar(200) DEFAULT NULL COMMENT ‘车队’,

yuepaijiage varchar(200) DEFAULT NULL COMMENT ‘约拍价格’,

lifumingcheng varchar(200) DEFAULT NULL COMMENT ‘礼服名称’,

lifujiage varchar(200) DEFAULT NULL COMMENT ‘礼服价格’,

zongjiage varchar(200) DEFAULT NULL COMMENT ‘总价格’,

xiadanriqi date DEFAULT NULL COMMENT ‘下单日期’,

yuyueshijian date DEFAULT NULL COMMENT ‘预约时间’,

paishedizhi varchar(200) NOT NULL COMMENT ‘拍摄地址’,

yonghuming varchar(200) DEFAULT NULL COMMENT ‘用户名’,

xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,

shouji varchar(200) DEFAULT NULL COMMENT ‘手机’,

sfsh varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,

shhf longtext COMMENT ‘审核回复’,

ispay varchar(200) DEFAULT ‘未支付’ COMMENT ‘是否支付’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=1600669852795 DEFAULT CHARSET=utf8 COMME

必看视频！获取2024年最新Java开发全套学习资料 备注Java

NT=‘订单信息’;

CREATE TABLE lifuleixing (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

leixing varchar(200) NOT NULL COMMENT ‘类型’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=1600669557861 DEFAULT CHARSET=utf8 COMMENT=‘礼服类型’;

CREATE TABLE lifuxinxi (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

lifubianhao varchar(200) DEFAULT NULL COMMENT ‘礼服编号’,

lifumingcheng varchar(200) DEFAULT NULL COMMENT ‘礼服名称’,

leixing varchar(200) DEFAULT NULL COMMENT ‘类型’,

tupian varchar(200) DEFAULT NULL COMMENT ‘图片’,

caizhi varchar(200) DEFAULT NULL COMMENT ‘材质’,

jieshao longtext COMMENT ‘介绍’,

lifujiage int(11) NOT NULL COMMENT ‘礼服价格’,

beizhu varchar(200) DEFAULT NULL COMMENT ‘备注’,

PRIMARY KEY (id),

UNIQUE KEY lifubianhao (lifubianhao)

) ENGINE=InnoDB AUTO_INCREMENT=1600668453283 DEFAULT CHARSET=utf8 COMMENT=‘礼服信息’;

CREATE TABLE news (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

title varchar(200) NOT NULL COMMENT ‘标题’,

picture varchar(200) NOT NULL COMMENT ‘图片’,

content longtext NOT NULL COMMENT ‘内容’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=1600669253948 DEFAULT CHARSET=utf8 COMMENT=‘新闻资讯’;

CREATE TABLE sheyingtuandui (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

tuanduibianhao varchar(200) DEFAULT NULL COMMENT ‘团队编号’,

tuanduimingcheng varchar(200) NOT NULL COMMENT ‘团队名称’,

tupian varchar(200) DEFAULT NULL COMMENT ‘图片’,

siyi varchar(200) DEFAULT NULL COMMENT ‘司仪’,

chedui varchar(200) DEFAULT NULL COMMENT ‘车队’,

lianxiren varchar(200) DEFAULT NULL COMMENT ‘联系人’,

lianxidianhua varchar(200) DEFAULT NULL COMMENT ‘联系电话’,

tuanduizhuangtai varchar(200) DEFAULT NULL COMMENT ‘团队状态’,

tuanduidengji varchar(200) DEFAULT NULL COMMENT ‘团队等级’,

tuanduitese varchar(200) DEFAULT NULL COMMENT ‘团队特色’,

yuepaijiage int(11) NOT NULL COMMENT ‘约拍价格’,

tuanduijieshao longtext COMMENT ‘团队介绍’,

PRIMARY KEY (id),

UNIQUE KEY tuanduibianhao (tuanduibianhao)

) ENGINE=InnoDB AUTO_INCREMENT=1600669379709 DEFAULT CHARSET=utf8 COMMENT=‘摄影团队’;

CREATE TABLE storeup (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

userid bigint(20) NOT NULL COMMENT ‘用户id’,

refid bigint(20) DEFAULT NULL COMMENT ‘收藏id’,

tablename varchar(200) DEFAULT NULL COMMENT ‘表名’,

name varchar(200) NOT NULL COMMENT ‘收藏名称’,

picture varchar(200) NOT NULL COMMENT ‘收藏图片’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=1600669826253 DEFAULT CHARSET=utf8 COMMENT=‘收藏表’;

CREATE TABLE token (

id bigint(20) NOT NULL AUTO_INCREMENT,

userid bigint(20) NOT NULL COMMENT ‘用户id’,

username varchar(100) NOT NULL COMMENT ‘用户名’,

tablename varchar(100) DEFAULT NULL COMMENT ‘表名’,

role varchar(100) DEFAULT NULL COMMENT ‘角色’,

token varchar(200) NOT NULL COMMENT ‘密码’,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘新增时间’,

expiratedtime timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘过期时间’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT=‘token表’;

CREATE TABLE users (

id bigint(20) NOT NULL AUTO_INCREMENT,

username varchar(100) NOT NULL COMMENT ‘用户名’,

password varchar(100) NOT NULL COMMENT ‘密码’,

role varchar(100) DEFAULT ‘管理员’ COMMENT ‘角色’,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘新增时间’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=‘用户表’;

CREATE TABLE xinxi (

id bigint(20) NOT NULL AUTO_INCREMENT,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

sheyingzhuti varchar(200) DEFAULT NULL COMMENT ‘摄影主题’,

tupian varchar(200) DEFAULT NULL COMMENT ‘图片’,

zongjiage varchar(200) DEFAULT NULL COMMENT ‘总价格’,

yuyueshijian varchar(200) DEFAULT NULL COMMENT ‘预约时间’,

yonghuming varchar(200) DEFAULT NULL COMMENT ‘用户名’,

xingming varchar(200) DEFAULT NULL COMMENT ‘姓名’,

shouji varchar(200) DEFAULT NULL COMMENT ‘手机’,

tixingneirong longtext NOT NULL COMMENT ‘提醒内容’,

beizhu varchar(200) DEFAULT NULL COMMENT ‘备注’,

tixingshijian date DEFAULT NULL COMMENT ‘提醒时间’,

sfsh varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,

shhf longtext COMMENT ‘审核回复’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=1600669786421 DEFAULT CHARSET=utf8 COMMENT=‘信息’;

最后

这份《“java高分面试指南”-25分类227页1000+题50w+字解析》同样可分享给有需要的朋友，感兴趣的伙伴们可挑战一下自我，在不看答案解析的情况，测试测试自己的解题水平，这样也能达到事半功倍的效果！（好东西要大家一起看才香）

(id)

) ENGINE=InnoDB AUTO_INCREMENT=1600669786421 DEFAULT CHARSET=utf8 COMMENT=‘信息’;

最后

这份《“java高分面试指南”-25分类227页1000+题50w+字解析》同样可分享给有需要的朋友，感兴趣的伙伴们可挑战一下自我，在不看答案解析的情况，测试测试自己的解题水平，这样也能达到事半功倍的效果！（好东西要大家一起看才香）

[外链图片转存中…(img-dyiC8YXw-1716455837884)]

[外链图片转存中…(img-XhmZvm6f-1716455837885)]