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)
);