-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathschema.txt
63 lines (54 loc) · 1.54 KB
/
schema.txt
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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
Five Tables: Registration, Echo-screening, Penicillin-screening, Name-id, and Login-info.
---
1. Registration Table:
id autoincrement (int) PRIMARY KEY
first-name (TEXT)
last-name (TEXT)
birth-date (DATE)
age (int)
school-name (TEXT)
standard (decimal)
village (TEXT)
sub-county (TEXT)
church (TEXT)
childrens-Home
care-taker (TEXT)
father (TEXT)
mother (TEXT)
care-taker-phone VARCHAR(14) eg: 00254721123456, +254721123456
alternate-phone VARCHAR(14)
---
2. Echo-screening Table:
id (int) PRIMARY KEY (matches ID from registration table)
date (DATETIME)
location (TEXT)
anterior-mitral-valve-leaflet-thickness SET(Normal, Abnormal)
posterior-mitral-valve-leaflet-thickness SET(Normal, Thickened)
posterior-mitral-valve-mobility SET(Normal, Reduced)
aortic-valve-thickness SET(Normal, Thickened)
mitral-valve-function SET(Normal, Abnormal)
aortic-valve-function SET(Normal, Abnormal)
anterior-mitral-valve-leaflet-mobility SET(Normal, Abnormal)
mitral-regurgitation SET(">1.5cm", ">1cm")
aortic-regurgitation BOOL
comments (TEXT)
---
3. Penicillin-screening Table:
id (int) PRIMARY KEY (matches ID from registration table)
date (DATETIME)
location (TEXT)
worsening-exercise-intolerance (BOOL)
poor-pcn-reaction (BOOL)
injection-given (BOOL)
comments (TEXT)
---
4. Name-id Table:
id (int) PRIMARY KEY
first-name-last-name (TEXT) eg. Evans-Kipkoech
---
5. Login-info Table:
username (TEXT) PRIMARY KEY
first-name (TEXT)
last-name (TEXT)
position (TEXT) eg. doctor, volunteer
hashed-password (CHAR(n)) where n is length of hash depending on the hashing function used