admin/database/postgres/migrations/0035.sql - main - dimamir/rill

admin/database/postgres/migrations/0035.sql

8 строк389 B

Aditya Hegde

feat: Request project access flow (#5198)

12 июл 2024, 10:34

12 июл 2024, 10:3486f36a3

CREATE TABLE project_access_requests (
    id UUID NOT NULL DEFAULT uuid_generate_v4() PRIMARY KEY,
    user_id UUID REFERENCES users (id) ON DELETE CASCADE,
    project_id UUID REFERENCES projects (id) ON DELETE CASCADE,
    created_on TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE UNIQUE INDEX project_access_requests_user_id_project_idx ON project_access_requests (user_id, project_id);