1z8QRiGt

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7CREATE DATABASE studentdb;
8
9	use studentdb;
10
11-- -----------------------------------------------------
12-- Schema studentdb
13-- -----------------------------------------------------
14
15-- -----------------------------------------------------
16-- Schema studentdb
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS studentdb DEFAULT CHARACTER SET utf8 ;
19USE studentdb ;
20
21-- -----------------------------------------------------
22-- Table studentdb.student
23-- -----------------------------------------------------
24CREATE TABLE IF NOT EXISTS studentdb.student (
25  idStudent INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
26  firstName VARCHAR(45) NULL,
27  lastName VARCHAR(45) NULL,
28  address VARCHAR(45) NULL,
29  phone VARCHAR(45) NULL,
30  studentEmail VARCHAR(45) NULL,
31  personalEmail VARCHAR(45) NULL,
32  interest VARCHAR(45) NULL,
33  active BIT(0) NULL,
34  program VARCHAR(45) NULL
35 
36  );
37
38
39
40CREATE TABLE IF NOT EXISTS studentdb.notes (
41  idNotes INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
42  idStudent INT NULL,
43  /*UNIQUE INDEX idNotes_UNIQUE (idNotes ASC) VISIBLE,
44  UNIQUE INDEX idStudent_UNIQUE (idStudent ASC) VISIBLE,*/
45  CONSTRAINT idStudent
46    FOREIGN KEY (idStudent)
47    REFERENCES studentdb.student (idStudent)
48    ON DELETE CASCADE
49    ON UPDATE CASCADE
50	
51	);
52
53
54-- -----------------------------------------------------
55-- Table studentdb.jobs
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS studentdb.jobs (
58  idjobs INT /*UNSIGNED*/ NOT NULL PRIMARY KEY,
59  idStudent INT NULL,
60  jobActive BIT(0) NULL,
61
62  /*UNIQUE INDEX idStudent_UNIQUE (idStudent ASC) VISIBLE,*/
63  CONSTRAINT idStudent
64    FOREIGN KEY (idStudent)
65    REFERENCES studentdb.student (idStudent)
66    ON DELETE CASCADE
67    ON UPDATE CASCADE
68	
69	);
70
71
72-- -----------------------------------------------------
73-- Table studentdb.graduated
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS studentdb.graduated (
76  idgraduated  BIT(0) NOT NULL PRIMARY KEY,
77  idStudent INT NOT NULL,
78  
79  CONSTRAINT idStudent
80    FOREIGN KEY (idStudent)
81    REFERENCES studentdb.student (idStudent)
82    ON DELETE CASCADE
83    ON UPDATE CASCADE
84	
85	);
86
87
88-- -----------------------------------------------------
89-- Table studentdb.internship
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS studentdb.internship (
92  idinternship INT UNSIGNED NOT NULL PRIMARY KEY,
93  idStudent INT NULL,
94  internshipCompany VARCHAR(45) NULL,
95  internshipSemester VARCHAR(45) NULL,
96  
97  /*INDEX idStudent_idx (idStudent ASC) VISIBLE,*/
98  CONSTRAINT idStudent
99    FOREIGN KEY (idStudent)
100    REFERENCES studentdb.student (idStudent)
101    ON DELETE CASCADE
102    ON UPDATE CASCADE
103	
104	);
105
106
107-- -----------------------------------------------------
108-- Table studentdb.courseSubstitutions
109-- -----------------------------------------------------
110CREATE TABLE IF NOT EXISTS studentdb.courseSubstitutions (
111  idcourseSubstitutions INT UNSIGNED NOT NULL PRIMARY KEY,
112  courseSubstitutionsClass VARCHAR(45) NULL,
113  idStudent INT NULL,
114 
115  /*INDEX idStudent_idx (idStudent ASC) VISIBLE,*/
116  CONSTRAINT idStudent
117    FOREIGN KEY (idStudent)
118    REFERENCES studentdb.student (idStudent)
119    ON DELETE CASCADE
120    ON UPDATE CASCADE
121	
122	);
123
124
125
126-- -----------------------------------------------------
127-- Table studentdb.Program
128-- -----------------------------------------------------
129CREATE TABLE IF NOT EXISTS studentdb.Program (
130  idProgram INT NOT NULL AUTO_INCREMENT PROGRAM PRIMARY KEY,
131  year YEAR(4) NULL,
132  /*PRIMARY KEY (idProgram),*/
133  /*UNIQUE INDEX idProgram_UNIQUE (idProgram ASC) VISIBLE*/
134  
135  );
136
137
138SET SQL_MODE=@OLD_SQL_MODE;
139SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
140SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;