YSMygsqS

1-- MySQL Script generated by MySQL Workbench
2-- Mon Feb 11 10:38:54 2019
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @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';
9
10-- -----------------------------------------------------
11-- Schema projetbdd1
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema projetbdd1
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `projetbdd1` DEFAULT CHARACTER SET utf8 ;
18USE `projetbdd1` ;
19
20-- -----------------------------------------------------
21-- Table `projetbdd1`.`users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `projetbdd1`.`users` (
24  `username` VARCHAR(50) NOT NULL,
25  `password` VARCHAR(255) NULL,
26  `user_type` VARCHAR(50) NULL,
27  `created_at` TIMESTAMP NULL,
28  PRIMARY KEY (`username`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `projetbdd1`.`ens`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `projetbdd1`.`ens` (
36  `users_username` VARCHAR(50) NOT NULL,
37  `adresse` VARCHAR(45) NULL,
38  `telephone` VARCHAR(45) NULL,
39  `grade` VARCHAR(45) NULL,
40  `nom` VARCHAR(45) NULL,
41  `prenom` VARCHAR(45) NULL,
42  `date_naiss` VARCHAR(45) NULL,
43  INDEX `fk_ens_users1_idx` (`users_username` ASC) ,
44  PRIMARY KEY (`users_username`),
45  CONSTRAINT `fk_ens_users1`
46    FOREIGN KEY (`users_username`)
47    REFERENCES `projetbdd1`.`users` (`username`)
48    ON DELETE NO ACTION
49    ON UPDATE NO ACTION)
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `projetbdd1`.`etu`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `projetbdd1`.`etu` (
57  `users_username` VARCHAR(50) NOT NULL,
58  `adresse` VARCHAR(45) NULL,
59  `telephone` VARCHAR(45) NULL,
60  `annee_etude` VARCHAR(45) NULL,
61  `filiere` VARCHAR(45) NULL,
62  `niveau_etude` VARCHAR(45) NULL,
63  `nom` VARCHAR(45) NULL,
64  `prenom` VARCHAR(45) NULL,
65  `date_naiss` VARCHAR(45) NULL,
66  `ens_users_username` VARCHAR(50) NOT NULL,
67  INDEX `fk_etu_users_idx` (`users_username` ASC) ,
68  PRIMARY KEY (`users_username`),
69  INDEX `fk_etu_ens1_idx` (`ens_users_username` ASC) ,
70  CONSTRAINT `fk_etu_users`
71    FOREIGN KEY (`users_username`)
72    REFERENCES `projetbdd1`.`users` (`username`)
73    ON DELETE NO ACTION
74    ON UPDATE NO ACTION,
75  CONSTRAINT `fk_etu_ens1`
76    FOREIGN KEY (`ens_users_username`)
77    REFERENCES `projetbdd1`.`ens` (`users_username`)
78    ON DELETE NO ACTION
79    ON UPDATE NO ACTION)
80ENGINE = InnoDB;
81
82
83-- -----------------------------------------------------
84-- Table `projetbdd1`.`stage`
85-- -----------------------------------------------------
86CREATE TABLE IF NOT EXISTS `projetbdd1`.`stage` (
87  `idStage` INT NOT NULL,
88  `entreprise` VARCHAR(45) NULL,
89  `poste` VARCHAR(45) NULL,
90  `mission` VARCHAR(1000) NULL,
91  `duree` INT NULL,
92  `tech_utilise` VARCHAR(45) NULL,
93  `contact_maitre_stage` VARCHAR(45) NULL,
94  `date_Debut` DATE NULL,
95  `etu_users_username` VARCHAR(50) NOT NULL,
96  PRIMARY KEY (`idStage`),
97  INDEX `fk_stage_etu1_idx` (`etu_users_username` ASC) ,
98  CONSTRAINT `fk_stage_etu1`
99    FOREIGN KEY (`etu_users_username`)
100    REFERENCES `projetbdd1`.`etu` (`users_username`)
101    ON DELETE NO ACTION
102    ON UPDATE NO ACTION)
103ENGINE = InnoDB;
104
105
106SET SQL_MODE=@OLD_SQL_MODE;
107SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
108SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;