AZX6Qjnm

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='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema student_records
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema student_records
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `student_records` DEFAULT CHARACTER SET utf8 ;
18USE `student_records` ;
19
20-- -----------------------------------------------------
21-- Table `student_records`.`course`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `student_records`.`course` (
24  `courseID` INT(11) NOT NULL AUTO_INCREMENT,
25  `courseName` VARCHAR(45) NOT NULL,
26  PRIMARY KEY (`courseID`))
27ENGINE = InnoDB
28AUTO_INCREMENT = 21
29DEFAULT CHARACTER SET = utf8;
30
31
32-- -----------------------------------------------------
33-- Table `student_records`.`student`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `student_records`.`student` (
36  `CNP` VARCHAR(45) NOT NULL,
37  `last_name` VARCHAR(45) NOT NULL,
38  `first_name` VARCHAR(45) NOT NULL,
39  `password` VARCHAR(45) NOT NULL,
40  PRIMARY KEY (`CNP`))
41ENGINE = InnoDB
42DEFAULT CHARACTER SET = utf8;
43
44
45-- -----------------------------------------------------
46-- Table `student_records`.`student_course_table`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `student_records`.`student_course_table` (
49  `studentCNP` VARCHAR(45) NOT NULL,
50  `courseID` INT(11) NOT NULL,
51  `courseGrade` FLOAT NOT NULL,
52  INDEX `student_CNP_idx` (`studentCNP` ASC),
53  INDEX `course_id_idx` (`courseID` ASC),
54  CONSTRAINT `course_id`
55    FOREIGN KEY (`courseID`)
56    REFERENCES `student_records`.`course` (`courseID`)
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION,
59  CONSTRAINT `student_CNP`
60    FOREIGN KEY (`studentCNP`)
61    REFERENCES `student_records`.`student` (`CNP`)
62    ON DELETE NO ACTION
63    ON UPDATE NO ACTION)
64ENGINE = InnoDB
65DEFAULT CHARACTER SET = utf8;
66
67
68SET SQL_MODE=@OLD_SQL_MODE;
69SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
70SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;