CREATE TABLE "users" (
   "id" integer PRIMARY KEY,
   "name" text UNIQUE NOT NULL
);;

CREATE TABLE "projects" (
   "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "projects_id_seq"),
   "name" text NOT NULL,
   "description" text,
   "color" text NOT NULL,
   "owner" integer NOT NULL,
   "collaborators" text NOT NULL
);;

CREATE TABLE "timeentries" (
   "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "timeentries_id_seq"),
   "projectid" integer NOT NULL,
   "name" text NOT NULL,
   "starttime" integer NOT NULL,
   "endtime" integer,
   "owner" integer NOT NULL
);;