5wYJED9H

1SET FOREIGN_KEY_CHECKS = 0;# MySQL returned an empty result set (i.e. zero rows).
2DROP TABLE IF EXISTS `Bed_Type`;# MySQL returned an empty result set (i.e. zero rows).
3DROP TABLE IF EXISTS `Bed`;# MySQL returned an empty result set (i.e. zero rows).
4DROP TABLE IF EXISTS `Kamer`;# MySQL returned an empty result set (i.e. zero rows).
5DROP TABLE IF EXISTS `Patient`;# MySQL returned an empty result set (i.e. zero rows).
6DROP TABLE IF EXISTS `Patient_Notitie`;# MySQL returned an empty result set (i.e. zero rows).
7SET FOREIGN_KEY_CHECKS = 1;# MySQL returned an empty result set (i.e. zero rows).
8CREATE TABLE `Bed_Type` (
9    `bed_type_nr` VARCHAR(12) NOT NULL,
10    `bed_type_omschrijving` VARCHAR(12) NOT NULL,
11    PRIMARY KEY (`bed_type_nr`)
12);# MySQL returned an empty result set (i.e. zero rows).
13CREATE TABLE `Bed` (
14    `bed_nr` INTEGER(12) NOT NULL,
15    `bed_kamer_nr` VARCHAR(4) NOT NULL,
16    `bed_type_nr` VARCHAR(32) NOT NULL,
17    `bed_beschikbaarheid` VARCHAR(18) NOT NULL,
18    PRIMARY KEY (`bed_nr`)
19);# MySQL returned an empty result set (i.e. zero rows).
20CREATE TABLE `Kamer` (
21    `kamer_nr` INTEGER(12) NOT NULL,
22    `kamer_omschrijving` VARCHAR(32) NOT NULL,
23    PRIMARY KEY (`kamer_nr`)
24);# MySQL returned an empty result set (i.e. zero rows).
25CREATE TABLE `Patient` (
26    `patient_nr` INTEGER(12) NOT NULL,
27    `patient_achternaam` VARCHAR(32) NOT NULL,
28    `patient_voornaam` VARCHAR(32) NOT NULL,
29    `patient_geboortedatum` DATE NOT NULL,
30    `patient_bed_nr` INTEGER(18) NOT NULL,
31    PRIMARY KEY (`patient_nr`)
32);# MySQL returned an empty result set (i.e. zero rows).
33CREATE TABLE `Patient_Notitie` (
34    `pn_patient_nr` INTEGER(12) NOT NULL,
35    `pn_notitie_datum` DATE NOT NULL,
36    `pn_notitie_commentaar` VARCHAR(254) NOT NULL,
37    PRIMARY KEY (`pn_patient_nr`, `pn_notitie_datum`)
38);# MySQL returned an empty result set (i.e. zero rows).