forked from zuhairtaha/tasks-mysql-nodejs-app
-
Notifications
You must be signed in to change notification settings - Fork 2
/
database_2.sql
28 lines (23 loc) · 912 Bytes
/
database_2.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
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`begins` date DEFAULT NULL,
`ends` date DEFAULT NULL,
`status` enum('not-started','ongoing','finished') DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `class` */
/*Table structure for table `student` */
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`class_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `name_index` (`name`(191)),
KEY `class_id_fk` (`class_id`),
CONSTRAINT `class_id_fk` FOREIGN KEY (`class_id`) REFERENCES `class` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;