4277b7b2a8
personal projects are projects that have no team. they can only seen by the project members (one of which is whoever first creates the project).
6 lines
254 B
SQL
6 lines
254 B
SQL
CREATE TABLE personal_project (
|
|
personal_project_id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
|
|
project_id uuid NOT NULL REFERENCES project(project_id) ON DELETE CASCADE,
|
|
user_id uuid NOT NULL REFERENCES user_account(user_id) ON DELETE CASCADE
|
|
);
|