7 lines
272 B
SQL
7 lines
272 B
SQL
CREATE TABLE task_watcher (
|
|
task_watcher_id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
|
|
task_id uuid NOT NULL REFERENCES task(task_id) ON DELETE CASCADE,
|
|
user_id uuid NOT NULL REFERENCES user_account(user_id) ON DELETE CASCADE,
|
|
watched_at timestamptz NOT NULL
|
|
);
|