sql_init.sql

create database edt;

use edt;

create table `elleve`(
    `id` int AUTO_INCREMENT,
    `nom` varchar(50) not null,
    `prenom` varchar(50) not null,
    `mail` varchar(100),
    `classe` varchar(50),
    `id_importation` int,
    primary key(`id`)
)ENGINE=InnoDB;

create table `proph`(
    `id` int AUTO_INCREMENT,
    `nom` varchar(50) not null,
    `prenom` varchar(50) not null,
    `mail` varchar(100),
    `id_importation` int,
    primary key(`id`)
)ENGINE=InnoDB;

create table `rdv`(
    `id` int AUTO_INCREMENT,
    `nom` varchar(50) not null,
    `date` timestamp not null,
    `durre` int not null,
    `couleur` varchar(50) not null,
    `id_elleve` int not null,
    `id_proph` int not null,
    `lieu` varchar(50) not null,
    `id_importation` int,
    `abs` int,
    CONSTRAINT uc_rdv unique(`date`, `id_elleve`),
    primary key(`id`),
    foreign key(`id_elleve`) references elleve(`id`),
    foreign key(`id_proph`) references proph(`id`)
)ENGINE=InnoDB;

create table `importation`(
    `id` int not null  AUTO_INCREMENT,
    `nom` varchar(100),
    `date` timestamp not null,
    primary key(`id`)
)ENGINE=InnoDB;


SHOW TABLE STATUS;