· 9 years ago · Nov 09, 2016, 08:32 PM
1CREATE TABLE IF NOT EXISTS type_of_activity(id_type INTEGER PRIMARY KEY, name VARCHAR(20))
2
3CREATE TABLE IF NOT EXISTS activity(
4 id_activity INTEGER PRIMARY KEY AUTOINCREMENT,
5 id_type INTEGER,
6 start_time TEXT,
7 distance REAL,
8 duration INTEGER,
9 elevation INTEGER,
10 FOREIGN KEY(id_type) REFERENCES type_of_activity(id_type))