· 6 years ago · Dec 17, 2019, 07:32 AM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Client : 127.0.0.1
6-- Généré le : Mar 17 Décembre 2019 à 00:06
7-- Version du serveur : 5.6.17
8-- Version de PHP : 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données : `clinique`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `medecin`
27--
28
29CREATE TABLE IF NOT EXISTS `medecin` (
30 `ID_MEDECIN` int(11) NOT NULL AUTO_INCREMENT,
31 `CIVILITE` varchar(3) DEFAULT NULL,
32 `NOM` varchar(50) DEFAULT NULL,
33 `PRENOM` varchar(50) DEFAULT NULL,
34 PRIMARY KEY (`ID_MEDECIN`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
36
37--
38-- Contenu de la table `medecin`
39--
40
41INSERT INTO `medecin` (`ID_MEDECIN`, `CIVILITE`, `NOM`, `PRENOM`) VALUES
42(1, 'Mr', 'Toto', 'Bernard'),
43(2, 'Mr', 'Test', 'Test');
44
45-- --------------------------------------------------------
46
47--
48-- Structure de la table `patient`
49--
50
51CREATE TABLE IF NOT EXISTS `patient` (
52 `N_SECU` char(15) NOT NULL DEFAULT '',
53 `CIVILITE` varchar(3) DEFAULT NULL,
54 `NOM` varchar(50) DEFAULT NULL,
55 `PRENOM` varchar(50) DEFAULT NULL,
56 `ADRESSE` varchar(50) DEFAULT NULL,
57 `CP` varchar(50) DEFAULT NULL,
58 `VILLE` varchar(50) DEFAULT NULL,
59 `DATE_NAISSANCE` varchar(50) DEFAULT NULL,
60 `LIEU_NAISSANCE` varchar(50) DEFAULT NULL,
61 `ID_MEDECIN` int(11) DEFAULT NULL,
62 PRIMARY KEY (`N_SECU`),
63 KEY `ID_MEDECIN` (`ID_MEDECIN`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65
66--
67-- Contenu de la table `patient`
68--
69
70INSERT INTO `patient` (`N_SECU`, `CIVILITE`, `NOM`, `PRENOM`, `ADRESSE`, `CP`, `VILLE`, `DATE_NAISSANCE`, `LIEU_NAISSANCE`, `ID_MEDECIN`) VALUES
71('100026544006294', 'Mr', 'Moureaux', 'Baptiste', '3 rue du buala', '65000', 'TARBES', '2019-11-27', 'TARBES', 1);
72
73-- --------------------------------------------------------
74
75--
76-- Structure de la table `rdv`
77--
78
79CREATE TABLE IF NOT EXISTS `rdv` (
80 `ID_RDV` int(11) NOT NULL AUTO_INCREMENT,
81 `DATE_H_RDV` datetime DEFAULT NULL,
82 `DUREE` int(11) DEFAULT NULL,
83 `ID_MEDECIN` int(11) NOT NULL,
84 `N_SECU` char(15) NOT NULL,
85 PRIMARY KEY (`ID_RDV`),
86 KEY `ID_MEDECIN` (`ID_MEDECIN`),
87 KEY `N_SECU` (`N_SECU`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
89
90--
91-- Contraintes pour les tables exportées
92--
93
94--
95-- Contraintes pour la table `patient`
96--
97ALTER TABLE `patient`
98 ADD CONSTRAINT `PATIENT_ibfk_1` FOREIGN KEY (`ID_MEDECIN`) REFERENCES `medecin` (`ID_MEDECIN`);
99
100--
101-- Contraintes pour la table `rdv`
102--
103ALTER TABLE `rdv`
104 ADD CONSTRAINT `RDV_ibfk_1` FOREIGN KEY (`ID_MEDECIN`) REFERENCES `medecin` (`ID_MEDECIN`),
105 ADD CONSTRAINT `RDV_ibfk_2` FOREIGN KEY (`N_SECU`) REFERENCES `patient` (`N_SECU`);
106
107/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
108/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
109/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;