This repository has been archived by the owner on Feb 7, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
tables.sql
127 lines (96 loc) · 3.66 KB
/
tables.sql
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
DROP TABLE IF EXISTS `courses`;
CREATE TABLE `courses` (
`cat_num` varchar(255) NOT NULL,
`term` varchar(255) DEFAULT NULL,
`bracketed` tinyint(1) DEFAULT NULL,
`field` varchar(255) DEFAULT NULL,
`number` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`description` text,
`prerequisites` text,
`notes` text,
PRIMARY KEY (`cat_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table courses_faculty
# ------------------------------------------------------------
DROP TABLE IF EXISTS `courses_faculty`;
CREATE TABLE `courses_faculty` (
`cat_num` varchar(255) NOT NULL,
`faculty_id` varchar(255) NOT NULL,
PRIMARY KEY (`cat_num`, `faculty_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table faculty
# ------------------------------------------------------------
DROP TABLE IF EXISTS `faculty`;
CREATE TABLE `faculty` (
`id` varchar(255) NOT NULL DEFAULT '',
`first` varchar(255) DEFAULT NULL,
`middle` varchar(255) DEFAULT NULL,
`last` varchar(255) DEFAULT NULL,
`suffix` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table fields
# ------------------------------------------------------------
DROP TABLE IF EXISTS `fields`;
CREATE TABLE `fields` (
`id` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table Qcomments
# ------------------------------------------------------------
DROP TABLE IF EXISTS `Qcomments`;
CREATE TABLE `Qcomments` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`number` varchar(255) DEFAULT NULL,
`cat_num` varchar(255) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
`term` varchar(255) DEFAULT NULL,
`comment` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table Qcourses
# ------------------------------------------------------------
DROP TABLE IF EXISTS `Qcourses`;
CREATE TABLE `Qcourses` (
`course_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`number` varchar(255) DEFAULT NULL,
`cat_num` varchar(255) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
`term` varchar(255) DEFAULT NULL,
`enrollment` varchar(255) DEFAULT NULL,
`response_rate` varchar(255) DEFAULT NULL,
`course_overall` varchar(255) DEFAULT NULL,
`materials` varchar(255) DEFAULT NULL,
`assignments` varchar(255) DEFAULT NULL,
`feedback` varchar(255) DEFAULT NULL,
`section` varchar(255) DEFAULT NULL,
`workload` varchar(255) DEFAULT NULL,
`difficulty` varchar(255) DEFAULT NULL,
`would_you_recommend` varchar(255) DEFAULT NULL,
`evaluations` varchar(255) DEFAULT NULL,
PRIMARY KEY (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table Qinstructors
# ------------------------------------------------------------
DROP TABLE IF EXISTS `Qinstructors`;
CREATE TABLE `Qinstructors` (
`id_unique` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(255) NOT NULL DEFAULT '',
`cat_num` varchar(255) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
`term` varchar(255) DEFAULT NULL,
`first` varchar(255) DEFAULT NULL,
`last` varchar(255) DEFAULT NULL,
`instructor_overall` varchar(255) DEFAULT NULL,
`effective_lectures_or_presentations` varchar(255) DEFAULT NULL,
`accessible_outside_class` varchar(255) DEFAULT NULL,
`generates_enthusiasm` varchar(255) DEFAULT NULL,
`facilitates_discussion_encourages_participation` varchar(255) DEFAULT NULL,
`gives_useful_feedback` varchar(255) DEFAULT NULL,
`returns_assignments_in_timely_fashion` varchar(255) DEFAULT NULL,
`number` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id_unique`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;