· 10 years ago · Feb 06, 2016, 07:00 PM
1CREATE DATABASE IF NOT EXISTS `ziekenhuis_15088073` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `ziekenhuis_15088073`;
3-- MySQL dump 10.13 Distrib 5.7.9, for Win32 (AMD64)
4--
5-- Host: localhost Database: ziekenhuis
6-- ------------------------------------------------------
7-- Server version 5.7.9-log
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `afspraak_15088073`
22--
23
24DROP TABLE IF EXISTS `afspraak_15088073`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `afspraak_15088073` (
28 `tijd` varchar(5) NOT NULL,
29 `aantal_minuten` varchar(4) NOT NULL,
30 `datum` date NOT NULL,
31 `status` varchar(10) NOT NULL,
32 `BSN` char(9) DEFAULT NULL,
33 `v_id` char(7) NOT NULL,
34 PRIMARY KEY (`datum`, `tijd`, `v_id`)
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `afspraak_15088073`
40--
41
42LOCK TABLES `afspraak_15088073` WRITE;
43/*!40000 ALTER TABLE `afspraak_15088073` DISABLE KEYS */;
44INSERT INTO `afspraak_15088073` VALUES ('16:28','68','2016-02-01','voldaan','914531288','8851386'),('13:12','87','2016-02-01','voldaan','281713684','1999806'),('15:38','68','2016-02-01','voldaan','469151853','1574442'),('17:48','76','2016-02-09','ingepland',NULL,'4565361'),('15:26','43','2016-02-05','ingepland','869220698','2570055'),('12:34','20','2016-02-08','ingepland',NULL,'1500574'),('16:16','78','2016-02-04','voldaan','375448098','2791585'),('16:16','35','2016-02-12','ingepland',NULL,'5095876'),( '13:44','26','2016-02-02','voldaan','780839937','9207072'),('11:30','25','2016-02-11','ingepland',NULL,'1475887'),('13:01','26','2016-01-29','voldaan','534422268','1798857');
45/*!40000 ALTER TABLE `afspraak_15088073` ENABLE KEYS */;
46UNLOCK TABLES;
47
48
49--
50-- Table structure for table `polikliniek_voorkeur_15088073`
51--
52
53DROP TABLE IF EXISTS `polikliniek_voorkeur_15088073`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `polikliniek_voorkeur_15088073` (
57 `naam` varchar(50) NOT NULL,
58 `BSN` char(9) NOT NULL,
59 PRIMARY KEY (`naam`, `BSN`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `polikliniek_voorkeur_15088073`
65--
66
67LOCK TABLES `polikliniek_voorkeur_15088073` WRITE;
68/*!40000 ALTER TABLE `polikliniek_voorkeur_15088073` DISABLE KEYS */;
69INSERT INTO `polikliniek_voorkeur_15088073` VALUES ('Cefdinir', '626709350'),( 'Clonazepam','431056781'),('Cocklebur','111222336'),('Cold and Sinus Maximum Strength','259542162'),('Lidocaine Hydrochloride','573750004'),('phenol','412809498'),('Regular Strength Aspirin EC', '111222334'),('Simvastatin','111222335'),('Sure Fresh Essence', '269164864'),('TEMAZEPAM', '831407600');
70/*!40000 ALTER TABLE `polikliniek_voorkeur_15088073` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `contactpersoon_email_15088073`
75--
76
77DROP TABLE IF EXISTS `contactpersoon_email_15088073`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `contactpersoon_email_15088073` (
81 `emailadres` varchar(50) NOT NULL,
82 `BSN` char(9) NOT NULL,
83 PRIMARY KEY (`emailadres`, `BSN`)
84) ENGINE=InnoDB DEFAULT CHARSET=utf8;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `contactpersoon_email_15088073`
89--
90
91LOCK TABLES `contactpersoon_email_15088073` WRITE;
92/*!40000 ALTER TABLE `contactpersoon_email_15088073` DISABLE KEYS */;
93INSERT INTO `contactpersoon_email_15088073` VALUES ('aturnerw@unesco.org', '626709350'),( 'mweaverk@amazonaws.com','431056781'),('mwilliams17@bloomberg.com','111222336'),('aevansi@japanpost.jp','259542162'),('ddunnq@livejournal.com','573750004'),('smoore7@tripadvisor.com','111222334'),('nstevensc@merriam-webster.com', '111222334'),('pross14@apache.org','111222335'),('eflores4@ftc.gov', '269164864'),('dmccoys@webs.com', '831407600');
94/*!40000 ALTER TABLE `contactpersoon_email_15088073` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `patient_15088073`
99--
100
101DROP TABLE IF EXISTS `patient_15088073`;
102/*!40101 SET @saved_cs_client = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `patient_15088073` (
105 `BSN` char(9) NOT NULL,
106 `achternaam` varchar(20) NOT NULL,
107 `tussenvoegsel` varchar(10) DEFAULT NULL,
108 `voornaam` varchar(20) NOT NULL,
109 `geslacht` varchar(6) NOT NULL,
110 `straat` varchar(30) NOT NULL,
111 `huisnr` varchar(6) NOT NULL,
112 `postcode` varchar(15) DEFAULT NULL,
113 `woonplaats` varchar(50) NOT NULL,
114 `geboorte_datum` date NOT NULL,
115 `emailadressen` varchar(50) NOT NULL,
116 `v_id` char(7) NOT NULL,
117 PRIMARY KEY (`BSN`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `patient_15088073`
123--
124
125LOCK TABLES `patient_15088073` WRITE;
126/*!40000 ALTER TABLE `patient_15088073` DISABLE KEYS */;
127INSERT INTO `patient_15088073` VALUES ('102991207','Jones',NULL,'Gösta','Male','Myrtle','2253',NULL,'Sapiranga','1971-09-18','jjonesr@joomla.org','1170772'),('111222333','Ross',NULL,'Daphnée','Male','Wayridge','52',NULL,'Batán','1988-06-10','pross14@apache.org', '1218225'),('111222334','Stevens',NULL,'Edmée','Female','Monument','5','92004 CEDEX','Nanterre','1986-08-14','nstevensc@merriam-webster.com', '1102232'),('111222335','Howell',NULL,'Ã…sa','Female','Scofield','79',NULL,'Baitu','1956-02-20','rhowell0@indiatimes.com', '1226636'),('111222336','Turner',NULL,'Estée','Male','Kenwood','874',NULL,'Fengle','1966-10-15','eturnera@acquirethisname.com','1984427'),('129913975','Hart',NULL,'Méline','Female','Claremont','23584',NULL,'Ledenice','1967-08-29','mhartj@gmpg.org', '1142005'),('131214215','Bailey',NULL,'Rébecca','Female','Comanche','0278','2490-105','Cercal','1971-10-07','ebaileyd@ted.com', '1431346'),('141976095','Mccoy',NULL,'Michèle','Male','Pine View','064',NULL,'Temayang','1979-11-14','dmccoys@webs.com', '1279188'),('182567754','Nichols',NULL,'Personnalisée','Female','Erie','4031',NULL,'Kuwait City','1975-07-12','anichols18@salon.com', '1798857'),('208234644','Castillo',NULL,'Léonore','Male','Dapin','772',NULL,'Simunul','1960-11-03','hcastilloh@seesaa.net', '1999806'),('221486853','Gonzales',NULL,'Régine','Male','Judy','21787',NULL,'Bojongsari','1961-11-24','cgonzales1d@nature.com', '1876537'),('223395189','Hunter',NULL,'Maïlys','Male','Corben','62',NULL,'Grazhdanka','1984-05-03','phunteru@smugmug.com', '1379663'),('243287628','Edwards',NULL,'Börje','Female','Knutson','8025',NULL,'Pandangan Kulon','1979-09-02','aedwards12@utexas.edu','1730237'),('250724752','Edwards',NULL,'Mén','Female','Coolidge','17','68505','Lincoln','1969-05-02','tedwardsb@tumblr.com', '1005109'),('251538489','Harris',NULL,'Nuó','Male','Washington','1',NULL,'Hunkuyi','1954-12-08','kharrisv@oakley.com', '1903576'),('280617489','Long',NULL,'Frédérique','Female','Bellgrove','98',NULL,'Kizel','1967-01-11','klong8@youtu.be', '1750578'),('287810974','Flores',NULL,'Zoé','Female','Bashford','2653',NULL,'Skoura','1977-11-04','eflores4@ftc.gov', '1941216'),('291777206','Arnold',NULL,'Almérinda','Female','Lighthouse Bay','83405',NULL,'Admiralteisky','1951-01-13','karnold2@amazon.com', '1974773'),('308014768','Franklin',NULL,'Amélie','Male','Larry','975',NULL,'Longkali','1960-06-14','kfranklin13@canalblog.com', '1708574'),('324076567','Long',NULL,'Maëlyss','Female','Forest Dale','020',NULL,'Bous','1960-08-28','jlong6@meetup.com', '1657446'),('326896474','Moore',NULL,'Clémence','Female','Amoth','9',NULL,'Kirawsk','1979-08-05','smoore7@tripadvisor.com', '1400237'),('341399613','Smith',NULL,'Léa','Female','Basil','6667',NULL,'Hongguang','1988-12-23','ssmithz@gravatar.com','1201085'),('342266003','Romero',NULL,'Yú','Male','Delaware','897',NULL,'Mojo','1976-01-03','eromero1@cmu.edu', '1143320'),('372904711','Boyd',NULL,'Céline','Female','Eastwood','300',NULL,'DamboÅ™ice','1986-02-02','bboyd1c@stanford.edu','1998312'),('375677681','Turner',NULL,'Vénus','Male','Fuller','6326',NULL,'Gia NghÄ©a','1976-07-21','aturnerw@unesco.org', '1362128'),('385540485','Ray',NULL,'Pélagie','Female','Caliangt','80307','400 70','Göteborg','1958-05-30','kraym@eventbrite.com', '1940682'),('389371992','Garrett',NULL,'Marie-noël','Male','Bellgrove','00042',NULL,'Gradizhsk','1978-01-21','mgarrettn@hao123.com', '1356606'),('489508264','Sanchez',NULL,'Renée','Female','Haas','8656',NULL,'Shchigry','1962-02-02','ssanchez5@hhs.gov', '1791907'),('505627006','Flores',NULL,'Annotée','Male','Lotheville','03222',NULL,'Curug','1980-07-23','rflores19@mayoclinic.com', '1305277'),('520624099','Rogers',NULL,'Mylène','Male','Johnson','01','21460','Emiliano Zapata','1950-06-18','crogers3@tiny.cc', '1682968'),('525064334','Perez',NULL,'Ã…sa','Female','Raven','5048','72209','Little Rock','1962-04-14','aperezl@friendfeed.com', '1430544'),('560589341','Stevens',NULL,'Maï','Male','Utah','36',NULL,'Donggong','1984-07-31','hstevens9@va.gov', '1462369'),('586585697','Dunn',NULL,'Célestine','Male','Starling','8',NULL,'Aliaga','1980-08-08','ddunnq@livejournal.com', '1674633'),('587755481','Mcdonald',NULL,'Cunégonde','Female','Morningstar','3440','94745 CEDEX','Arcueil','1966-06-30','tmcdonald15@rediff.com', '1021075'),('595157439','Nichols',NULL,'Clémence','Male','Menomonie','186',NULL,'Manyana','1957-10-07','rnicholsy@163.com', '1099072'),('655627320','Cox',NULL,'Cécilia','Male','Sutherland','11',NULL,'Ten’gushevo','1977-02-06','rcoxx@unicef.org', '1037372'),('722190724','Garza',NULL,'Nadège','Female','Milwaukee','2726',NULL,'Mihara','1952-05-19','pgarzaf@reverbnation.com','1819471'),('782167407','Mendoza',NULL,'Ophélie','Male','Bluestem','80','78897 CEDEX','Saint-Quentin-en-Yvelines','1955-03-11','rmendozao@furl.net','1423545'),('815310558','Davis',NULL,'Ã…ke','Male','Springs','76906',NULL,'Lokwabe','1959-03-24','vdavis1b@upenn.edu' ,'1827750'),('823191085','Rogers',NULL,'Björn','Male','Monterey','8317',NULL,'Hamamatsu','1953-03-17','rrogers16@twitpic.com', '1140857'),('835725434','Rivera',NULL,'Maïlys','Male','Bay','14047',NULL,'Satovcha','1987-05-20','jrivera11@apache.org', '1926630'),('842233281','Vasquez',NULL,'Athéna','Female','Atwood','4728',NULL,'Qukuhu','1957-01-22','tvasquez1a@whitehouse.gov', '1330380'),('848949676','Reynolds',NULL,'Garçon','Female','Meadow Valley','650',NULL,'PÅ‚oÅ„sk','1955-02-09','dreynoldsp@google.ca', '1962992'),('863573049','Oliver',NULL,'Desirée','Male','Crest Line','32',NULL,'Daitou','1971-11-30','coliverg@angelfire.com', '1020468'),('873452082','Weaver',NULL,'Bérangère','Male','Veith','69987',NULL,'Nakhabino','1980-08-25','mweaverk@amazonaws.com', '1124658'),('876886128','Carpenter',NULL,'Gaëlle','Female','Dunning','351',NULL,'Kedrovyy','1982-03-28','rcarpentere@biglobe.ne.jp', '1551993'),('896672173','Chavez',NULL,'Clélia','Female','Eggendart','82228',NULL,'NunchÃa','1950-06-30','kchavezt@youku.com','1136310'),('945395474','Medina',NULL,'Thérèse','Male','Northwestern','4',NULL,'Sagay','1964-06-12','kmedina10@vinaora.com', '1800898'),('975612951','Williams',NULL,'Agnès','Male','Karstens','1102',NULL,'Xijia','1985-07-17','mwilliams17@bloomberg.com', '1360841'),('986605492','Evans',NULL,'Cécile','Female','Manitowish','7',NULL,'Popovi','1957-02-19','aevansi@japanpost.jp', '1034483');
128/*!40000 ALTER TABLE `patient_15088073` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `polikliniek_15088073`
133--
134
135DROP TABLE IF EXISTS `polikliniek_15088073`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `polikliniek_15088073` (
139 `naam` varchar(50) NOT NULL,
140 `plaats` varchar(50) NOT NULL,
141 `specialisme` varchar(20) NOT NULL,
142 `BSN` char(9) NOT NULL,
143 PRIMARY KEY (`naam`),
144 KEY `BSN_idx` (`BSN`)
145) ENGINE=InnoDB DEFAULT CHARSET=utf8;
146/*!40101 SET character_set_client = @saved_cs_client */;
147
148--
149-- Dumping data for table `polikliniek_15088073`
150--
151
152LOCK TABLES `polikliniek_15088073` WRITE;
153/*!40000 ALTER TABLE `polikliniek_15088073` DISABLE KEYS */;
154INSERT INTO `polikliniek_15088073` VALUES ('Cefdinir','That Phanom','oncologie','626709350'),('Clonazepam','Phaya Thai','oncologie','431056781'),('Cocklebur','Jishu','gezondheid','111222336'),('Cold and Sinus Maximum Strength','Neglasari','Ledematen','259542162'),('Lidocaine Hydrochloride','Cukalat','oncologie','573750004'),('phenol','Folques','oncologie','412809498'),('Regular Strength Aspirin EC','Vřesina','Darmen','111222334'),('Simvastatin','Maimará','Ledematen','111222335'),('Sure Fresh Essence','Zhongshan','Gewrichten','269164864'),('TEMAZEPAM','Zizhao','gezondheid','831407600');
155/*!40000 ALTER TABLE `polikliniek_15088073` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `verpleegkundige_15088073`
160--
161
162DROP TABLE IF EXISTS `verpleegkundige_15088073`;
163/*!40101 SET @saved_cs_client = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `verpleegkundige_15088073` (
166 `v_id` char(7) NOT NULL,
167 `naam` varchar(45) NOT NULL,
168 `datum_in_dienst` date NOT NULL,
169 `geslacht` varchar(6) NOT NULL,
170 `geboorte_datum` date NOT NULL,
171 `uurtarief` int(11) NOT NULL,
172 PRIMARY KEY (`v_id`)
173) ENGINE=InnoDB DEFAULT CHARSET=utf8;
174/*!40101 SET character_set_client = @saved_cs_client */;
175
176--
177-- Dumping data for table `verpleegkundige_15088073`
178--
179
180LOCK TABLES `verpleegkundige_15088073` WRITE;
181/*!40000 ALTER TABLE `verpleegkundige_15088073` DISABLE KEYS */;
182INSERT INTO `verpleegkundige_15088073` VALUES ('1003037','Martin Jenkins','2013-08-13','Male','1983-03-25',22),('1074229','Craig Kennedy','2014-11-29','Male','1988-08-22',22),('1077535','Gerald Patterson','2011-12-17','Male','1984-02-09',21),('1092748','Rachel Larson','1998-10-28','Female','1985-12-13',18),('1126527','Rachel Reynolds','1994-12-23','Female','1988-07-12',22),('1134241','Judy Henry','2001-09-04','Female','1964-07-12',21),('1140611','Catherine Miller','1992-11-05','Female','1980-01-10',13),('1142466','Henry Andrews','2009-05-05','Male','1990-12-20',19),('1282353','Andrew Williams','1998-11-02','Male','1991-04-22',13),('1318644','Maria Carter','2012-02-29','Female','1978-06-01',18),('1324641','Barbara Chapman','2000-06-10','Female','1966-08-26',22),('1341689','Steven Larson','1994-02-16','Male','1983-02-20',13),('1346443','Christine Smith','2010-12-29','Female','1986-08-06',16),('1356400','Ruby Stephens','2010-11-11','Female','1982-10-29',13),('1375315','Eugene Sanchez','2011-02-23','Male','1984-09-10',21),('1401742','Anne Stephens','2012-05-13','Female','1982-12-15',14),('1406850','Phyllis Gonzalez','1991-12-05','Female','1970-12-11',19),('1443925','Walter Bishop','2010-09-05','Male','1976-02-23',21),('1475887','Carlos Martinez','2008-12-23','Male','1984-05-02',12),('1476934','Sandra Welch','2010-03-02','Female','1979-03-10',14),('1500574','Norma Gomez','2005-08-14','Female','1977-08-11',21),('1506066','Cheryl Black','2010-12-26','Female','1966-03-18',19),('1566817','Carlos Phillips','2002-05-30','Male','1982-10-08',22),('1584788','Robert Price','1996-11-18','Male','1963-08-22',16),('1586884','Lisa Edwards','2011-05-30','Female','1988-05-23',18),('1590940','Denise Lopez','2008-03-04','Female','1969-07-07',14),('1600020','Catherine Greene','1998-03-11','Female','1994-08-18',18),('1617307','Benjamin Washington','2014-01-19','Male','1986-09-01',18),('1620531','Lillian Baker','2008-08-31','Female','1963-01-14',15),('1630532','Norma Williams','1998-10-23','Female','1991-06-30',12),('1656956','Andrea Berry','2012-09-03','Female','1991-10-17',21),('1658192','Cynthia Harper','2003-08-15','Female','1966-04-15',14),('1661568','Dorothy Cook','2002-03-11','Female','1973-03-23',14),('1696781','Thomas Mills','2008-08-02','Male','1967-12-07',13),('1765798','Cheryl Henderson','1996-06-16','Female','1963-04-24',20),('1781315','Stephanie Hawkins','2011-11-01','Female','1978-05-22',14),('1792988','Anna Harvey','2009-04-01','Female','1965-08-21',22),('1798857','Richard Shaw','2004-10-28','Male','1962-06-01',21),('1806021','Robert Marshall','2005-02-26','Male','1982-12-17',14),('1818937','Roy Evans','2000-04-13','Male','1980-01-25',19),('1827560','Irene Morris','2010-07-28','Female','1991-11-01',21),('1844420','Debra Scott','2001-12-21','Female','1965-01-16',20),('1846996','Mildred Romero','2010-01-01','Female','1978-11-02',21),('1856336','Justin Hunt','2003-04-30','Male','1976-09-21',22),('1879016','Rachel Ellis','2013-08-09','Female','1961-10-31',13),('1923034','Kathryn Cole','2010-11-08','Female','1963-07-16',13),('1960729','Kimberly Burns','1992-08-02','Female','1989-11-04',20),('1994277','Jose Ray','2014-04-25','Male','1977-06-28',16),('1999806','Ann Graham','1992-07-22','Female','1980-04-21',12),('4565361','Howard Flores','2011-10-22','Male','1978-09-13',12);
183/*!40000 ALTER TABLE `verpleegkundige_15088073` ENABLE KEYS */;
184UNLOCK TABLES;
185/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
186
187/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
188/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
189/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
190/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
191/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
192/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
193/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
194
195-- Dump completed on 2016-01-22 17:53:20