1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
| -- Structure de la table `acquerir`
CREATE TABLE IF NOT EXISTS `acquerir` (
`ID_etudiant` varchar(50) NOT NULL,
`ID_experience_pro` varchar(50) NOT NULL,
PRIMARY KEY (`ID_etudiant`,`ID_experience_pro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `centres_d'interets` (
`ID_centres_d'interets` varchar(50) NOT NULL,
`Intitule_de_l'interet` varchar(50) NOT NULL,
`Regularite` varchar(50) NOT NULL,
`Niveau` varchar(50) NOT NULL,
PRIMARY KEY (`ID_centres_d'interets`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Structure de la table `competences`
CREATE TABLE IF NOT EXISTS `competences` (
`ID_competence` varchar(50) NOT NULL,
`Intitule_de_la_competence` varchar(50) NOT NULL,
`Niveau` varchar(50) NOT NULL,
PRIMARY KEY (`ID_competence`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `education` (
`ID_education` varchar(50) NOT NULL,
`Etudes_superieures` varchar(50) NOT NULL,
`Contenu_de_la_formation` varchar(50) NOT NULL,
`Annee_d'obtention` int(4) NOT NULL,
`Lieu_d'obtention` varchar(50) NOT NULL,
PRIMARY KEY (`ID_education`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `etudiant` (
`ID nom` varchar(50) NOT NULL,
`Prénom` varchar(50) NOT NULL,
`Etat_civil` varchar(20) NOT NULL,
`Date_de_naissance` varchar(50) NOT NULL,
`Adresse` varchar(60) NOT NULL,
`Numéro_de_tel` int(10) NOT NULL,
`E-mail` varchar(50) NOT NULL,
PRIMARY KEY (`ID nom`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Structure de la table `experiences_professionnelles`
CREATE TABLE IF NOT EXISTS `experiences_professionnelles` (
`ID_experience_pro` varchar(50) NOT NULL,
`Intitulé_du_post` varchar(50) NOT NULL,
`Durée_de_la_mission` varchar(20) NOT NULL,
`Missions_confiées` text NOT NULL,
`Nom_de_l'entreprise` varchar(50) NOT NULL,
`Ville` varchar(25) NOT NULL,
PRIMARY KEY (`ID_experience_pro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Structure de la table `posseder`
CREATE TABLE IF NOT EXISTS `posseder` (
`ID_etudiant` varchar(50) NOT NULL,
`ID_competences` varchar(50) NOT NULL,
PRIMARY KEY (`ID_etudiant`,`ID_competences`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Structure de la table `pratiquer`
CREATE TABLE IF NOT EXISTS `pratiquer` (
`ID_etudiant` varchar(50) NOT NULL,
`ID-centres_d'interets` varchar(50) NOT NULL,
PRIMARY KEY (`ID_etudiant`,`ID-centres_d'interets`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Structure de la table `suivre`
CREATE TABLE IF NOT EXISTS `suivre` (
`ID_etudiant` varchar(50) NOT NULL,
`ID_education` varchar(50) NOT NULL,
PRIMARY KEY (`ID_etudiant`,`ID_education`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
Partager