1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE TABLE IF NOT EXISTS Enseignants (
IdEnseignat SMALLINT(4) UNSIGNED NOT NULL PRIMARY KEY,
NomEnseignat VARCHAR(15) NOT NULL,
PrenomEnseignat VARCHAR(15) NOT NULL ) ENGINE = InnoDB;
CREATE TABLE IF NOT EXISTS Personne_Conctacter (
IdPersonneContactee SMALLINT(4) UNSIGNED NOT NULL PRIMARY KEY,
NomPersonne VARCHAR(15) NOT NULL,
PrenomPersonne VARCHAR(15) NOT NULL,
MoyenContact VARCHAR(25) NOT NULL ) ENGINE = InnoDB;
CREATE TABLE IF NOT EXISTS Entreprise (
N_Entreprise INT UNSIGNED NOT NULL PRIMARY KEY,
NomEntreprise VARCHAR(30) NOT NULL,
Adresse TINYTEXT NOT NULL,
IdPersonneContactee SMALLINT(4) UNSIGNED NOT NULL
FOREIGN KEY ( `IdPersonneContactee` )
REFERENCES Personne_Conctacter ( `IdPersonneContactee` )
ON DELETE CASCADE ) ENGINE = InnoDB; |
