AakMh5ZG

1
2CREATE TABLE IF NOT EXISTS "chamber" (
3	"chamber_id" SERIAL PRIMARY KEY NOT NULL,
4	"chamber_capacity" INTEGER NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS "diagnosis" (
8	"diagnosis_id" SERIAL PRIMARY KEY NOT NULL,
9	"diagnosis_name" VARCHAR NOT NULL
10);
11
12CREATE TABLE IF NOT EXISTS "doctor_position" (
13	"doctor_position_id" SERIAL PRIMARY KEY NOT NULL,
14	"doctor_position_name" VARCHAR NULL DEFAULT NULL
15);
16
17CREATE TABLE IF NOT EXISTS "doctor" (
18	"doctor_id" SERIAL PRIMARY KEY NOT NULL,
19	"doctor_name" VARCHAR NOT NULL,
20	"doctor_surname" VARCHAR NOT NULL,
21	"doctor_position_id" INTEGER NOT NULL REFERENCES doctor_position(doctor_position_id) ON DELETE CASCADE ON UPDATE CASCADE
22);
23
24CREATE TABLE IF NOT EXISTS "procedure" (
25	"procedure_id" SERIAL PRIMARY KEY NOT NULL,
26	"procedure_name" VARCHAR NOT NULL
27);
28
29CREATE TABLE IF NOT EXISTS "pacient" (
30	"pacient_id" SERIAL PRIMARY KEY NOT NULL,
31	"pacient_name" VARCHAR NOT NULL,
32	"pacient_surname" VARCHAR NOT NULL,
33	"pacient_birth_date" DATE NOT NULL,
34	"pacient_weight" INTEGER NOT NULL,
35	"pacient_height" INTEGER NOT NULL
36);
37
38CREATE TABLE IF NOT EXISTS "pacient_journal" (
39	"pacient_journal_id" SERIAL PRIMARY KEY NOT NULL,
40	"pacient_id" INTEGER NOT NULL REFERENCES pacient(pacient_id) ON DELETE CASCADE ON UPDATE CASCADE,
41	"diagnosis_id" INTEGER NOT NULL REFERENCES diagnosis(diagnosis_id) ON DELETE CASCADE ON UPDATE CASCADE,
42	"doctor_id" INTEGER NOT NULL REFERENCES doctor(doctor_id) ON DELETE CASCADE ON UPDATE CASCADE,
43	"chamber_id" INTEGER REFERENCES chamber(chamber_id) ON DELETE CASCADE ON UPDATE CASCADE,
44	"in_date" DATE NOT NULL,
45	"out_date" DATE NULL
46);
47
48CREATE TABLE IF NOT EXISTS "pacient_procedure" (
49	"pacient_procedure_id" SERIAL PRIMARY KEY NOT NULL,
50	"pacient_journal_id" INTEGER NOT NULL REFERENCES pacient_journal(pacient_journal_id) ON DELETE CASCADE ON UPDATE CASCADE,
51	"procedure_id" INTEGER NOT NULL REFERENCES "procedure"(procedure_id) ON DELETE CASCADE ON UPDATE CASCADE,
52	"doctor_id" INTEGER NOT NULL REFERENCES doctor(doctor_id) ON DELETE CASCADE ON UPDATE CASCADE,
53	"pacient_procedure_date" DATE NOT NULL,
54	"pacient_procedure_done" INTEGER NOT NULL
55);
56
57