基于java毕设springboot餐厅预约订座系统毕业设计毕设源码毕业设计论文开题报告参考（4）数据库

深藏阁楼爱情的钟 2022-10-11 10:55 147阅读 0赞

### 关于我们概要表：gaiyao ###

存放关于我们的相关项目数据

### 广告表：guanggao ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> Int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> wz1 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告1的文字 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> tpdz1 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告1的图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> ljdz1 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告1的链接地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> wz2 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告2的文字 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> tpdz2 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告2的图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> ljdz2 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告2的链接地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> wz3 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告3的文字 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> tpdz3 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告3的图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> ljdz3 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告3的链接地址 </td> 
 </tr> 
 </tbody> 
</table>

### 留言表：liuyan ###

### 会员表：huiyuan ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> shouji </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 手机号：用户名 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> mima </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 密码 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> </td> 
 <td style="vertical-align:top;width:3cm;"> </td> 
 <td style="vertical-align:top;width:260.5pt;"> </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xingming </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 姓名 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xingbie </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 性别 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> qq </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> QQ号 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> youxiang </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> Email </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> touxiang </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 头像地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> jianjie </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 简介 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> jieshao </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 介绍 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> add_riqi </td> 
 <td style="vertical-align:top;width:3cm;"> date </td> 
 <td style="vertical-align:top;width:260.5pt;"> 注册日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> add_shijian </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 注册时间 </td> 
 </tr> 
 </tbody> 
</table>

### 座位分类表：dingzuo\_fenlei ###

### 座位表：dingzuo ###

样本如下

### 座位预约订单表：dingzuo\_yuyue ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> u_id </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 用户id </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> yuyue_riqi </td> 
 <td style="vertical-align:top;width:3cm;"> date </td> 
 <td style="vertical-align:top;width:260.5pt;"> 预约日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> yuyue_xingqiji </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 预约星期几 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xiadan_shijian </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 下单时间 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> zuowei_id </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 座位id </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> zuowei_mc </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 座位名称 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> fenlei_renshu </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 座位人数 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> fenlei_leixing </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 座位类型：大堂还是包厢 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> lianxiren </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 联系人 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> dianhua </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 电话 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> beizhu </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> zt </td> 
 <td style="vertical-align:top;width:3cm;"> tinyint </td> 
 <td style="vertical-align:top;width:260.5pt;"> 状态：1表示待审核、2表示拒绝、3表示审核通过 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> zt_beizhu </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 操作备注 </td> 
 </tr> 
 </tbody> 
</table>