php校园学校宿舍管理系统毕设 php毕业设计题目课题选题 php毕业设计项目作品源码(2)系统概要和数据库表 Love The Way You Lie 2022-09-15 14:51 213阅读 0赞 ## 开发概要 ## 开发环境:windows7 + iis + php (可以自行搭建其他比如phpstudy之类的) 开发语言:php7 开发工具:phpstorm(其他开发工具vscode、dreamweaver等都可以) 数据库:mysql8 数据库管理工具:navicat 其他开发语言:html + css +javascript ### 概要表(关于我们):gaiyao ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">biaoti</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">标题</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">neirong</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">内容</p> </td> </tr> </tbody> </table> 存放关于我们的相关项目数据 ### 广告表:guanggao ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">wz1</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告1的文字</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">tpdz1</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告1的图片地址</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">ljdz1</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告1的链接地址</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">wz2</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告2的文字</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">tpdz2</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告2的图片地址</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">ljdz2</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告2的链接地址</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">wz3</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告3的文字</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">tpdz3</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告3的图片地址</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">ljdz3</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">广告3的链接地址</p> </td> </tr> </tbody> </table> ### 留言表:liuyan ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int(11)</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xingming</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar(50)</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">姓名</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">dianhua</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar(50)</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">电话</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">youxiang</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar(50)</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">邮箱</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">zhuti</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar(250)</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">主题</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">neirong</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">longtext</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">内容</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">riqi</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">date</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">日期</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">shijian</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">datetime</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">时间</p> </td> </tr> </tbody> </table> ### 分院表:fenyuan ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_biaoti</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">char</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">分院标题</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_jianjie</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">分院简介</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_neirong</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">分院内容介绍</p> </td> </tr> </tbody> </table> 样本 ### 班级表:banji ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">mingcheng</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">班级名称,编号</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">fenyuan_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">外键,所属分院id</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">banzhuren_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">外键,班主任id</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">jianjie</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">班级简介</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">班级详细信息</p> </td> </tr> </tbody> </table> 样本 ### 教室分类(教学楼)表:jiaoshi\_fenlei ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">caidan_mingcheng</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">教室分类名称</p> </td> </tr> </tbody> </table> 样本 ### 教室表:jiaoshi ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_lxid1</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">教室分类id</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_biaoti</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">教室标题</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_riqi</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">date</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息日期</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_neirong</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息内容</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">riqi</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">datetime</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息发布的日期</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">shijian</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">datetime</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息发布的时间</p> </td> </tr> </tbody> </table> ### 宿舍分类(宿舍楼)表:sushe\_fenlei ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">caidan_mingcheng</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">教室分类名称</p> </td> </tr> </tbody> </table> 样本 ### 宿舍表:sushe ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_lxid1</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">教室分类id</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_biaoti</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">教室标题</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_riqi</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">date</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息日期</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_neirong</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息内容</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">riqi</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">datetime</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息发布的日期</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">shijian</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">datetime</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">信息发布的时间</p> </td> </tr> </tbody> </table> ### 宿舍-查寝表:sushe\_chaqin ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">suguan_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">宿舍管理员id,外键</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">chaqin_shijian</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">date</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">查寝时间</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">chaqin_shuoming</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">查寝备注说明</p> </td> </tr> </tbody> </table> ### 宿舍-查寝-打分表:sushe\_chaqin\_dafen ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">suguan_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">宿舍管理员id,外键</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">chaqin_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">查寝表id,外键</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">qinshi_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">寝室id,外键</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">qinshi_fenshu</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">寝室的分数</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">qinshi_beizhu</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">寝室的分数备注说明</p> </td> </tr> </tbody> </table> ### 课程表:kecheng ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_biaoti</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">char</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">课程标题</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_jianjie</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">课程简介</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">bixiu</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">tinyint</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">是否必修:1表示必修,0表示相反</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xuefen</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">学分</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_tupian</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">char</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">课程封面图片</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xinxi_neirong</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">课程介绍内容</p> </td> </tr> </tbody> </table> 样本 ### 排课表:paike ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">banji_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">外键,班级id,表示是哪个班级的排课表</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">kecheng_ids</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">课程的id集合</p> <p style="margin-left:.0001pt;">每天排课是6节课,排课星期1到5</p> <p style="margin-left:.0001pt;">每个id以都逗号分隔,最终拆成数组,对应需要是1到30;</p> <p style="margin-left:.0001pt;">星期1,数字是1到6</p> <p style="margin-left:.0001pt;">星期2,数字是7到12,以此类推</p> <p style="margin-left:.0001pt;">注意考虑:拆分成数组,数组从0序号开始</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">kecheng_ids2</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">课程表包含的课程id集合(去除重复了)</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">kecheng_mcs</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">课程表</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">laoshi_ids</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">对应的课程的老师id集合</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">laoshi_mcs</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">对应的课程的老师id(对应老师名称)集合</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">jiaoshi_ids</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">对应课程的教室id的集合</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">jiaoshi_mcs</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">对应课程的教室id(对应中文名称)的集合</p> </td> </tr> </tbody> </table> 样本 ### 学生表:xuesheng ### <table> <tbody> <tr> <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> <p style="margin-left:.0001pt;"><strong>字段名</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> <p style="margin-left:.0001pt;"><strong>类型</strong></p> </td> <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> <p style="margin-left:.0001pt;"><strong>备注</strong></p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">Int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">自动递增;菜单的id(主键),不允许空</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">banzhuren_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">外键,班主任id</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">banji_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">外键,班级id</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xingming</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">姓名</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xingbie</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">性别:男或女</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">sfz</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">身份证(用作学生账号)</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">mima</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">密码</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">xuehao</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">学号</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">youxiang</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">邮箱</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">qq</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">Qq</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">weixin</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">微信</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">sushe_id</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">int</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">宿舍id</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">sushe_mc</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">宿舍id中文名称</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">jianjie</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">简介</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">touxiang</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">varchar</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">头像</p> </td> </tr> <tr> <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> <p style="margin-left:.0001pt;">neirong</p> </td> <td style="vertical-align:top;width:3cm;"> <p style="margin-left:.0001pt;">text</p> </td> <td style="vertical-align:top;width:260.5pt;"> <p style="margin-left:.0001pt;">学生介绍内容</p> </td> </tr> </tbody> </table>
还没有评论,来说两句吧...