HealthApp-Backend/tables.sql at master · CompoTypo/HealthApp-Backend · 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
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
64
65
66
67
68
69
70
71
72
73
74
75
#### SQL

create table users (
    UID INTEGER PRIMARY KEY AUTOINCREMENT,
	Fname TEXT NOT NULL,
    Lname TEXT NOT NULL,
    Uname TEXT NOT NULL,
    Email TEXT NOT NULL,
    Hash TEXT NOT NULL,
    DOB TEXT NOT NULL,
	Sex TEXT,
    Race TEXT,
    Type TEXT NOT NULL
);

insert into vitals.Wght,

create table doctorinfo (
    Hash TEXT NOT NULL,
    License TEXT NOT NULL,
    Spec TEXT NOT NULL,
    Degree TEXT NOT NULL,
    Almat TEXT NOT NULL
);

create table patientinfo (
    Hash TEXT NOT NULL,
    Title TEXT,
    Descr TEXT,
    RTime INTEGER NOT NULL
);

create table dates (
    Hash TEXT NOT NULL,
    Title TEXT,
    Descr TEXT,
    RTime INTEGER NOT NULL
);

create table msgs (
    Hash TEXT NOT NULL,
    Tokey TEXT NOT NULL,
    Sub TEXT,
    Body TEXT,
    RTime INTEGER NOT NULL
);

create table bp (
    Hash TEXT NOT NULL,

    RTime INTEGER NOT NULL
);

create table vitals (
    Hash TEXT NOT NULL,
    Temp REAL,
    Wght Real,
    Sys INTEGER,
    Dia INTEGER,
    Pulse INTEGER,
    RTime INTEGER NOT NULL
);


# edges connecting users and describing it
create table relations (
    Hash TEXT NOT NULL,
    Temp REAL NOT NULL,
    Wght Real NOT NULL,
    RTime INTEGER NOT NULL
);

SELECT users.Fname, users.Lname
FROM users
INNER JOIN users ON users.CustomerID=Customers.CustomerID;