TopicSelection/course_selection.sql at master · Xin-Felix/TopicSelection · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50725
Source Host           : localhost:3306
Source Database       : course_selection

Target Server Type    : MYSQL
Target Server Version : 50725
File Encoding         : 65001

Date: 2019-11-29 16:46:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_username` varchar(255) CHARACTER SET utf8 NOT NULL,
  `admin_password` varchar(255) CHARACTER SET utf8 NOT NULL,
  `admin_level` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '1',
  `admin_type` varchar(255) NOT NULL DEFAULT '1',
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for choose_message
-- ----------------------------
DROP TABLE IF EXISTS `choose_message`;
CREATE TABLE `choose_message` (
  `choose_id` int(11) NOT NULL AUTO_INCREMENT,
  `choose_question_id` int(11) NOT NULL,
  `choose_student_id` int(11) NOT NULL,
  `choose_teacher_id` int(11) NOT NULL,
  `choose_teacher_result` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`choose_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for question_message
-- ----------------------------
DROP TABLE IF EXISTS `question_message`;
CREATE TABLE `question_message` (
  `title_id` int(11) NOT NULL AUTO_INCREMENT,
  `title_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `title_type` varchar(255) CHARACTER SET utf8 NOT NULL,
  `title_source` varchar(255) CHARACTER SET utf8 NOT NULL,
  `title_background` longtext CHARACTER SET utf8 NOT NULL,
  `title_content` longtext CHARACTER SET utf8 NOT NULL,
  `title_require` longtext CHARACTER SET utf8 NOT NULL,
  `title_result` int(11) NOT NULL DEFAULT '1',
  `teacher_id` varchar(255) CHARACTER SET utf8 NOT NULL,
  `question_type` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`title_id`)
) ENGINE=InnoDB AUTO_INCREMENT=677 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for student_message
-- ----------------------------
DROP TABLE IF EXISTS `student_message`;
CREATE TABLE `student_message` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_code` varchar(255) CHARACTER SET utf8 NOT NULL,
  `student_password` varchar(255) CHARACTER SET utf8 NOT NULL,
  `student_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `student_major` varchar(255) CHARACTER SET utf8 NOT NULL,
  `student_phone` varchar(255) CHARACTER SET utf8 NOT NULL,
  `student_qq` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB AUTO_INCREMENT=339 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for teacher_message
-- ----------------------------
DROP TABLE IF EXISTS `teacher_message`;
CREATE TABLE `teacher_message` (
  `teacher_id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_code` varchar(255) CHARACTER SET utf8 NOT NULL,
  `teacher_password` varchar(255) CHARACTER SET utf8 NOT NULL,
  `teacher_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `teacher_level` varchar(255) CHARACTER SET utf8 NOT NULL,
  `teacher_direction` varchar(255) CHARACTER SET utf8 NOT NULL,
  `teacher_source` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`teacher_id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;