kzKdcYwP

1
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
7-- -----------------------------------------------------
8-- Schema APLICATIVO
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema APLICATIVO
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `APLICATIVO` DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci ;
15USE `APLICATIVO` ;
16
17-- -----------------------------------------------------
18-- Table `APLICATIVO`.`PERIODS`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `APLICATIVO`.`PERIODS` (
21  `idPeriods` INT NOT NULL,
22  `name` VARCHAR(90) NULL,
23  PRIMARY KEY (`idPeriods`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `APLICATIVO`.`SLOTS`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `APLICATIVO`.`SLOTS` (
31  `idSlot` INT NOT NULL,
32  `name` VARCHAR(90) NULL,
33  `Period_id` INT NOT NULL,
34  PRIMARY KEY (`idSlot`),
35  INDEX `Period_id_idx` (`Period_id` ASC) VISIBLE,
36  CONSTRAINT `Period_id`
37    FOREIGN KEY (`Period_id`)
38    REFERENCES `APLICATIVO`.`PERIODS` (`idPeriods`)
39    ON DELETE NO ACTION
40    ON UPDATE NO ACTION)
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `APLICATIVO`.`SEMESTERS`
46-- -----------------------------------------------------
47CREATE TABLE IF NOT EXISTS `APLICATIVO`.`SEMESTERS` (
48  `idSemester` INT NOT NULL,
49  `semester` VARCHAR(90) NULL,
50  `Slot_id` INT NOT NULL,
51  PRIMARY KEY (`idSemester`),
52  INDEX `Slot_id_idx` (`Slot_id` ASC) VISIBLE,
53  CONSTRAINT `Slot_id`
54    FOREIGN KEY (`Slot_id`)
55    REFERENCES `APLICATIVO`.`SLOTS` (`idSlot`)
56    ON DELETE NO ACTION
57    ON UPDATE NO ACTION)
58ENGINE = InnoDB;
59
60
61-- -----------------------------------------------------
62-- Table `APLICATIVO`.`STUDENTS`
63-- -----------------------------------------------------
64CREATE TABLE IF NOT EXISTS `APLICATIVO`.`STUDENTS` (
65  `idStudent` INT NOT NULL,
66  `identification` VARCHAR(16) NULL,
67  `name` VARCHAR(45) NULL,
68  `lastName` VARCHAR(45) NULL,
69  `phone` VARCHAR(14) NULL,
70  `mail` VARCHAR(256) NULL,
71  `Semester_id` INT NOT NULL,
72  PRIMARY KEY (`idStudent`),
73  INDEX `Semester_id_idx` (`Semester_id` ASC) VISIBLE,
74  CONSTRAINT `Semester_id`
75    FOREIGN KEY (`Semester_id`)
76    REFERENCES `APLICATIVO`.`SEMESTERS` (`idSemester`)
77    ON DELETE NO ACTION
78    ON UPDATE NO ACTION)
79ENGINE = InnoDB;
80
81
82-- -----------------------------------------------------
83-- Table `APLICATIVO`.`ACTIVITIES`
84-- -----------------------------------------------------
85CREATE TABLE IF NOT EXISTS `APLICATIVO`.`ACTIVITIES` (
86  `idActivitie` INT NOT NULL,
87  `activityName` VARCHAR(90) NULL,
88  `date` DATE NULL,
89  `time` TIME NULL,
90  `ACTIVITIEScol` VARCHAR(45) NULL,
91  `score` DECIMAL(4,2) NULL,
92  `Student_id` INT NOT NULL,
93  `Slot_id` INT NOT NULL,
94  PRIMARY KEY (`idActivitie`),
95  INDEX `Student_id_idx` (`Student_id` ASC) VISIBLE,
96  INDEX `Slot_id_idx` (`Slot_id` ASC) VISIBLE,
97  CONSTRAINT `Student_id`
98    FOREIGN KEY (`Student_id`)
99    REFERENCES `APLICATIVO`.`STUDENTS` (`idStudent`)
100    ON DELETE NO ACTION
101    ON UPDATE NO ACTION,
102  CONSTRAINT `SlotA_id`
103    FOREIGN KEY (`Slot_id`)
104    REFERENCES `APLICATIVO`.`SLOTS` (`idSlot`)
105    ON DELETE NO ACTION
106    ON UPDATE NO ACTION)
107ENGINE = InnoDB;
108
109
110-- -----------------------------------------------------
111-- Table `APLICATIVO`.`SESSIONS`
112-- -----------------------------------------------------
113CREATE TABLE IF NOT EXISTS `APLICATIVO`.`SESSIONS` (
114  `idSession` INT NOT NULL,
115  `name` VARCHAR(90) NULL,
116  `Slot_id` INT NOT NULL,
117  PRIMARY KEY (`idSession`),
118  INDEX `Slot_id_idx` (`Slot_id` ASC) VISIBLE,
119  CONSTRAINT `SlotB_id`
120    FOREIGN KEY (`Slot_id`)
121    REFERENCES `APLICATIVO`.`SLOTS` (`idSlot`)
122    ON DELETE NO ACTION
123    ON UPDATE NO ACTION)
124ENGINE = InnoDB;
125
126
127-- -----------------------------------------------------
128-- Table `APLICATIVO`.`ASSISTANCES`
129-- -----------------------------------------------------
130CREATE TABLE IF NOT EXISTS `APLICATIVO`.`ASSISTANCES` (
131  `idAssistance` INT NOT NULL,
132  `date` DATE NULL,
133  `time` TIME NULL,
134  `Studen_id` INT NOT NULL,
135  `Session_id` INT NOT NULL,
136  PRIMARY KEY (`idAssistance`),
137  INDEX `Studen_id_idx` (`Studen_id` ASC) VISIBLE,
138  INDEX `Session_id_idx` (`Session_id` ASC) VISIBLE,
139  CONSTRAINT `Studen_id`
140    FOREIGN KEY (`Studen_id`)
141    REFERENCES `APLICATIVO`.`STUDENTS` (`idStudent`)
142    ON DELETE NO ACTION
143    ON UPDATE NO ACTION,
144  CONSTRAINT `Session_id`
145    FOREIGN KEY (`Session_id`)
146    REFERENCES `APLICATIVO`.`SESSIONS` (`idSession`)
147    ON DELETE NO ACTION
148    ON UPDATE NO ACTION)
149ENGINE = InnoDB;
150
151
152SET SQL_MODE=@OLD_SQL_MODE;
153SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
154SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
155