forked from sac50/FitLogger
-
Notifications
You must be signed in to change notification settings - Fork 0
/
DatabaseSchema.txt
125 lines (112 loc) · 2.94 KB
/
DatabaseSchema.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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
CREATE TABLE distance (
id integer primary key autoincrement,
exercise_id integer,
length real,
units text,
FOREIGN KEY (exercise_id) REFERENCES exercises(id)
)
CREATE TABLE distance_result (
id integer primary key autoincrement,
workout_result_id integer,
length real,
units text,
FOREIGN KEY (workout_result_id) REFERENCES workout_result(id)
)
CREATE TABLE exercises (
id integer primary key autoincrement,
name text,
type text,
comment text,
deleted boolean
)
CREATE TABLE interval_result (
id integer primary key autoincrement,
workout_result_id integer,
interval_id integer, --> the interval id that it relates it to
interval_set_num integer, --> the # of num repeats, which cycle it is in
interval_Set_id integer, --> the interval set that was done
length real,
units text,
FOREIGN KEY (interval_id) REFERENCES intervals(id),
FOREIGN KEY (interval_set_id) REFERENCES interval_sets(id)
)
CREATE TABLE interval_sets (
id integer primary key autoincrement,
interval_id integer,
name text,
length real,
type text,
units text,
FOREIGN KEY (interval_id) REFERENCES intervals(id)
)
CREATE TABLE intervals (
id integer primary key autoincrement,
exercise_id integer,
num_repeats,
FOREIGN KEY (exercise_id) REFERENCES exercises(id)
)
CREATE TABLE set_result (
id integer primary key autoincrement,
workout_result_id integer,
set_number integer,
reps integer,
weight real,
FOREIGN KEY (workout_result_id) REFERENCES workout_result(id)
)
CREATE TABLE sets (
id integer primary key autoincrement,
exercise_id integer,
reps integer,
weight real,
FOREIGN KEY (exercise_id) REFERENCES exercises(id)
)
CREATE TABLE time (
id integer primary key autoincrement,
exercise_id integer,
length integer,
units text,
FOREIGN KEY (exercise_id) REFERENCES exercises(id)
)
CREATE TABLE time_result (
id integer primary key autoincrement,
workout_result_id integer,
length integer,
units text,
FOREIGN KEY (workout_result_id) REFERENCES workout_result(id);
)
CREATE TABLE workout_result (
id integer primary key autoincrement,
workout_id integer,
exercise_id integer,
date text
FOREIGN KEY (workout_id) REFERENCES workouts(id);
FOREIGN KEY (exercise_id) REFERENCES exercises(id);
)
CREATE TABLE workouts (
id integer primary key autoincrement,
name text,
type text,
exercise_sequence text,
repeats text,
repeats_sunday boolean,
repeats_monday boolean,
repeats_tuesday boolean,
repeats_wednesday boolean,
repeats_thursday boolean,
repeats_friday boolean,
repeats_saturday boolean,
comment text
)
CREATE TABLE exercise_goals {
id integer primary key autoincrement,
name text not null,
mode integer not null,
type integer not null,
exercise_id integer,
goal_one real,
goal_two real,
starting_best_one real,
starting_best_two real,
unit integer
FOREIGN KEY (exercise_id) REFERENCES exercises(id);
)