1 files changed, 28 insertions, 0 deletions
diff --git a/internal/database/schema.sql b/internal/database/schema.sql
new file mode 100644
index 0000000..a4483e1
--- /dev/null
+++ b/internal/database/schema.sql
@@ -0,0 +1,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)
+);