Skip to content

database

Rafael Macedo edited this page Mar 8, 2024 · 1 revision

-- Table Definition CREATE TABLE "public"."workout_sessions" ( "id" uuid NOT NULL DEFAULT gen_random_uuid(), "week_number" int4 NOT NULL DEFAULT 0, "day_number" int4 NOT NULL DEFAULT 0, "completed" bool NOT NULL DEFAULT false, "created_at" timestamp, "updated_at" timestamp, PRIMARY KEY ("id") );

CREATE TABLE workouts ( id UUID DEFAULT gen_random_uuid(), exercise VARCHAR NOT NULL, weight VARCHAR NOT NULL, reps VARCHAR NOT NULL, sets VARCHAR NOT NULL, rest VARCHAR NOT NULL, notes VARCHAR, order int NOT NULL DEFAULT 1, created_at TIMESTAMP WITHOUT TIME ZONE, updated_at TIMESTAMP WITHOUT TIME ZONE, PRIMARY KEY (id) );

Clone this wiki locally