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
|
create table if not exists client (
id integer primary key autoincrement,
name text not null unique,
email text,
billable_rate integer,
created_at datetime default current_timestamp
);
create table if not exists project (
id integer primary key autoincrement,
name text not null unique,
client_id integer not null,
billable_rate integer,
created_at datetime default current_timestamp,
foreign key (client_id) references client(id)
);
create table if not exists time_entry (
id integer primary key autoincrement,
start_time datetime not null,
end_time datetime,
description text,
client_id integer not null,
project_id integer,
billable_rate integer,
foreign key (client_id) references client(id),
foreign key (project_id) references project(id)
);
|
