CREATE TABLE "exitpointroaster"( 
    "id"                    bigserial PRIMARY KEY,
    "status"                VARCHAR NOT NULL,
    "user_id"               INT NOT NULL,
    "exitpoint_id"          INT NOT NULL,
    "dayshift"              BOOLEAN NOT NULL,    
    "nightshift"            BOOLEAN NOT NULL,
    "date"                  date NOT NULL,
    "created_at"            TIMESTAMPTZ NOT NULL DEFAULT(now())
);
ALTER TABLE "exitpointroaster" ADD FOREIGN KEY ("user_id") REFERENCES  "users" ("id");

CREATE TABLE "roastercount"( 
    "id"                    bigserial PRIMARY KEY,
    "user_id"               INT NOT NULL,
    "counter"               INT NOT NULL,
    "created_at"            TIMESTAMPTZ NOT NULL DEFAULT(now()),
    "updated_at"            TIMESTAMPTZ NOT NULL DEFAULT(now())
);

ALTER TABLE "roastercount" ADD FOREIGN KEY ("user_id") REFERENCES  "users" ("id");