-- phpMyAdmin SQL Dump -- version 3.4.11.1deb2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 30, 2022 at 05:37 PM -- Server version: 5.5.31 -- PHP Version: 5.4.4-14+deb7u4 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `CABINETMEDICAL` -- -- -------------------------------------------------------- -- -- Table structure for table `CONSULTATION` -- CREATE TABLE IF NOT EXISTS `CONSULTATION` ( `NumCons` int(6) NOT NULL AUTO_INCREMENT, `Date` date NOT NULL, `Medecin` int(6) NOT NULL, `Patient` bigint(13) NOT NULL, PRIMARY KEY (`NumCons`), KEY `fk_medecin` (`Medecin`), KEY `fk_patient` (`Patient`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `CONSULTATION` -- INSERT INTO `CONSULTATION` (`NumCons`, `Date`, `Medecin`, `Patient`) VALUES (1, '2010-12-26', 526736, 18012025324421), (2, '2011-01-04', 126389, 18012025324421), (3, '2011-01-04', 126389, 28403039213753), (4, '2011-01-04', 943223, 28403039213753), (5, '2011-01-05', 943223, 18012025324421), (6, '2011-01-06', 526736, 18012025324421), (7, '2011-01-06', 943223, 28403039213753); -- -------------------------------------------------------- -- -- Table structure for table `MEDECIN` -- CREATE TABLE IF NOT EXISTS `MEDECIN` ( `Matricule` int(6) NOT NULL, `Nom` char(50) NOT NULL, PRIMARY KEY (`Matricule`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `MEDECIN` -- INSERT INTO `MEDECIN` (`Matricule`, `Nom`) VALUES (126389, 'Hadley'), (526736, 'House'), (943223, 'Foreman'); -- -------------------------------------------------------- -- -- Table structure for table `MEDICAMENT` -- CREATE TABLE IF NOT EXISTS `MEDICAMENT` ( `CodeMedicament` char(10) NOT NULL, `Libelle` char(50) NOT NULL, PRIMARY KEY (`CodeMedicament`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `MEDICAMENT` -- INSERT INTO `MEDICAMENT` (`CodeMedicament`, `Libelle`) VALUES ('DDB100', 'Dortdebout'), ('PMB2000', 'Pasmalaubide'), ('PMC30', 'Pasmalaucrane'); -- -------------------------------------------------------- -- -- Table structure for table `PATIENT` -- CREATE TABLE IF NOT EXISTS `PATIENT` ( `NumSecu` bigint(13) NOT NULL, `Nom` char(50) NOT NULL, PRIMARY KEY (`NumSecu`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `PATIENT` -- INSERT INTO `PATIENT` (`NumSecu`, `Nom`) VALUES (18012025324421, 'Adam Labrosse'), (28403039213753, 'Constance Sirre'); -- -------------------------------------------------------- -- -- Table structure for table `PRESCRIPTION` -- CREATE TABLE IF NOT EXISTS `PRESCRIPTION` ( `NumCons` int(10) NOT NULL, `Medicament` char(20) NOT NULL, `NbPrises` int(3) NOT NULL, PRIMARY KEY (`NumCons`,`Medicament`), KEY `fk_medicament` (`Medicament`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `PRESCRIPTION` -- INSERT INTO `PRESCRIPTION` (`NumCons`, `Medicament`, `NbPrises`) VALUES (1, 'PMB2000', 2), (1, 'PMC30', 1), (2, 'PMC30', 1), (3, 'PMB2000', 1), (4, 'DDB100', 1); -- -- Constraints for dumped tables -- -- -- Constraints for table `CONSULTATION` -- ALTER TABLE `CONSULTATION` ADD CONSTRAINT `fk_medecin` FOREIGN KEY (`Medecin`) REFERENCES `MEDECIN` (`Matricule`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_patient` FOREIGN KEY (`Patient`) REFERENCES `PATIENT` (`NumSecu`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `PRESCRIPTION` -- ALTER TABLE `PRESCRIPTION` ADD CONSTRAINT `fk_numcons` FOREIGN KEY (`NumCons`) REFERENCES `CONSULTATION` (`NumCons`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_medicament` FOREIGN KEY (`Medicament`) REFERENCES `MEDICAMENT` (`CodeMedicament`) ON DELETE CASCADE ON UPDATE CASCADE; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;