/*
SQLyog Ultimate v11.27 (32 bit)
MySQL - 5.7.19 : Database - classattence
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`classattence` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `classattence`;

/*Table structure for table `attence` */

DROP TABLE IF EXISTS `attence`;

CREATE TABLE `attence` (
  `week` int(11) DEFAULT NULL,
  `coursesection` int(11) DEFAULT NULL,
  `teacherid` varchar(10) DEFAULT NULL,
  `classid` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `attence` */

insert  into `attence`(`week`,`coursesection`,`teacherid`,`classid`) values (3,3,'20161','1000');

/*Table structure for table `attence_zibiao` */

DROP TABLE IF EXISTS `attence_zibiao`;

CREATE TABLE `attence_zibiao` (
  `stuid` varchar(12) DEFAULT NULL,
  `teachid` varchar(10) DEFAULT NULL,
  `week` int(11) DEFAULT NULL,
  `coursesection` int(11) DEFAULT NULL,
  `istrue` tinyint(1) DEFAULT NULL,
  `classid` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `attence_zibiao` */

insert  into `attence_zibiao`(`stuid`,`teachid`,`week`,`coursesection`,`istrue`,`classid`) values ('201631104126','10001',1,3,1,'1000'),('201631104112','10001',1,3,1,'1000'),('201631104238','10001',1,3,0,'1000'),('201631104249','10001',1,3,1,'1000'),('201631104249','10001',1,3,0,'1000');

/*Table structure for table `course` */

DROP TABLE IF EXISTS `course`;

CREATE TABLE `course` (
  `beginweeek` int(11) DEFAULT NULL,
  `finishweek` int(11) DEFAULT NULL,
  `coursesection` int(10) DEFAULT NULL,
  `classid` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `course` */

insert  into `course`(`beginweeek`,`finishweek`,`coursesection`,`classid`) values (1,17,3,1);

/*Table structure for table `schedule` */

DROP TABLE IF EXISTS `schedule`;

CREATE TABLE `schedule` (
  `classid` varchar(10) DEFAULT NULL,
  `classname` varchar(20) DEFAULT NULL,
  `classroom` varchar(10) DEFAULT NULL,
  `teacherid` varchar(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `schedule` */

insert  into `schedule`(`classid`,`classname`,`classroom`,`teacherid`) values ('1000','卓越班','明理楼b101','10001'),('1001','一班','明理楼b102','10002'),('1002','二班','博学楼b101','10001'),('1003','三班','明理楼B101','10001'),('1000','01','00','10001');

/*Table structure for table `selectcourse` */

DROP TABLE IF EXISTS `selectcourse`;

CREATE TABLE `selectcourse` (
  `stuid` varchar(12) DEFAULT NULL,
  `teacherid` varchar(12) DEFAULT NULL,
  `classid` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `selectcourse` */

insert  into `selectcourse`(`stuid`,`teacherid`,`classid`) values ('20161','10001','1000');

/*Table structure for table `student` */

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
  `stuid` varchar(99) DEFAULT NULL,
  `classid` varchar(10) DEFAULT NULL,
  `classname` varchar(10) DEFAULT NULL,
  `name` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `student` */

insert  into `student`(`stuid`,`classid`,`classname`,`name`) values ('201631104150','1000','01','阿力腾别克'),('201631104120','1000','01','安瑞超'),('201631104140','1000','01','蔡杰'),('201631100000','1000','01','陈露伟'),('201631104240','1000','01','藏仁聪'),('201631104131','1000','01','陈星宇'),('201631104121','1000','01','陈宇'),('201631104225','1000','01','陈亚男'),('201631104141','1000','01','程序'),('201631104229','1000','01','段江南'),('201631104136','1000','01','杜彦骁'),('201631104218','1000','01','邓睿旖'),('201631104149','1000','01','达斯托尔'),('201631104125','1000','01','范怡'),('201631104211','1000','01','冯鑫华'),('201631104217','1000','01','龚蓉'),('201631104116','1000','01','龚梦霞'),('201631104148','1000','01','官明婷'),('201631104216','1000','01','龚彦心'),('201631104244','1000','01','郭芩材'),('201631104129','1000','01','韩宇萱'),('201631104242','1000','01','侯良晨'),('201631104118','1000','01','黄可'),('201631104122','1000','01','黄云仙'),('201631104117','1000','01','黄雪'),('201631104212','1000','01','江中美'),('201631104143','1000','01','李川'),('201631104123','1000','01','雷越群'),('201631104246','1000','01','李豪'),('201631104204','1000','01','雷琴'),('201631104108','1000','01','李梦琼'),('201631104232','1000','01','雷紫琳'),('201631104231','1000','01','李佩霞'),('201631104133','1000','01','李琴'),('201631104107','1000','01','李如星'),('201631104208','1000','01','李婉'),('201631104249','1000','01','廖东剑'),('201631104237','1000','01','廖俊杰'),('201631104224','1000','01','林晨'),('201631104146','1000','01','刘超'),('201631104215','1000','01','刘佳丽'),('201631104142','1000','01','刘阳'),('201631104145','1000','01','刘兆新'),('201531100697','1000','01','刘子琪'),('201531100671','1000','01','陆暄文'),('201631104228','1000','01','陆泳延'),('201631104207','1000','01','龙运'),('201631104205','1000','01','马江虹'),('201631104239','1000','01','欧宇'),('201631104119','1000','01','罗淋'),('201631104223','1000','01','彭雪倩'),('201631104226','1000','01','蒲亚萍'),('201531100670','1000','01','祁正斌'),('201631104247','1000','01','沙马羽茜'),('201631104124','1000','01','尚进'),('201631104105','1000','01','沈旭'),('201631104220','1000','01','田雅微'),('201531100736','1000','01','覃玉海'),('201531100706','1000','01','孙吉科'),('201631104132','1000','01','王佳馨'),('201531100648','1000','01','汪秀生'),('201631104111','1000','01','涂雨佳'),('201631104202','1000','01','王可欣'),('201631104114','1000','01','王林月'),('201631104245','1000','01','王思惟'),('201631111237','1000','01','王雯菁'),('201631104241','1000','01','王选'),('201631104209','1000','01','王鲜'),('201631104236','1000','01','王鑫'),('201631104203','1000','01','王艳'),('201631104127','1000','01','王颖'),('201631104115','1000','01','魏彩霞'),('201631104101','1000','01','吴沂蔓'),('201631132103','1000','01','武璇'),('201631104112','1000','01','伍丽'),('201631104137','1000','01','夏伟'),('201631104227','1000','01','熊婷'),('201631104243','1000','01','徐铭'),('201631104221','1000','01','肖草草'),('201631104210','1000','01','许心薇'),('201631104102','1000','01','许美辰'),('201631104214','1000','01','闫飞帆'),('201631104201','1000','01','杨爱'),('201631104103','1000','01','杨七滟'),('201631104147','1000','01','杨鑫'),('201631104134','1000','01','尧伟玉'),('201631104109','1000','01','叶栏桧'),('201631104135','1000','01','于龙飞'),('201631104230','1000','01','余明凤'),('201631104144','1000','01','袁智雨'),('201631104233','1000','01','张家菁'),('201631104126','1000','01','张铃竣'),('201631104238','1000','01','张旭辉'),('201631104128','1000','01','钟雨庭'),('201631104138','1000','01','张世林'),('201631104235','1000','01','周星宇'),('201631104139','1000','01','张熠坤');

/*Table structure for table `teacher` */

DROP TABLE IF EXISTS `teacher`;

CREATE TABLE `teacher` (
  `teachid` varchar(10) DEFAULT NULL,
  `name` varchar(10) DEFAULT NULL,
  `sex` char(2) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `picture` varchar(40) DEFAULT NULL,
  `title` varchar(10) DEFAULT NULL,
  `password` varchar(8) DEFAULT NULL,
  `introduce` varchar(100) DEFAULT NULL,
  `departments` varchar(10) DEFAULT NULL COMMENT '院系'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `teacher` */

insert  into `teacher`(`teachid`,`name`,`sex`,`phone`,`picture`,`title`,`password`,`introduce`,`departments`) values ('10001','老师','1','120','12','讲师','10001','厉害','计科院');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;