oculus-db/createDB.sql at master · DaGrisa/oculus-db · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
/* createDB.sql
script for creating the whole database
@creator dgr
@history	2015-03-26	dgr	create
*/

-- dropping all tables
SOURCE ./ddl/drop.sql

-- creating all tables
-- consider foreign key dependencies!
SOURCE ./ddl/usergroup.sql
SOURCE ./ddl/user.sql
SOURCE ./ddl/calendar.sql
SOURCE ./ddl/workinghours.sql
SOURCE ./ddl/calendarworkinghours.sql
SOURCE ./ddl/doctor.sql
SOURCE ./ddl/patient.sql
SOURCE ./ddl/orthoptist.sql
SOURCE ./ddl/receptionist.sql
SOURCE ./ddl/administrator.sql
SOURCE ./ddl/eventtype.sql
SOURCE ./ddl/calendarevent.sql
SOURCE ./ddl/queue.sql
SOURCE ./ddl/permission.sql
SOURCE ./ddl/userpermission.sql
SOURCE ./ddl/diagnosis.sql
SOURCE ./ddl/examinationprotocol.sql
SOURCE ./ddl/medicine.sql
SOURCE ./ddl/prescription.sql
SOURCE ./ddl/prescriptionentry.sql
SOURCE ./ddl/servicecode.sql
SOURCE ./ddl/insurancecarrier.sql
SOURCE ./ddl/examinationprotocolservicecode.sql
SOURCE ./ddl/workdisability.sql
SOURCE ./ddl/visualaid.sql
SOURCE ./ddl/referralletter.sql
SOURCE ./ddl/examinationresult.sql