7 lines
283 B
MySQL
7 lines
283 B
MySQL
|
CREATE TABLE project_member (
|
||
|
|
project_member_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,
|
||
|
|
added_at timestamptz NOT NULL
|
||
|
|
);
|