13 lines
509 B
SQL
13 lines
509 B
SQL
-- Table to store users' favourite study spaces
|
|
CREATE TABLE favourite_study_spaces (
|
|
user_id uuid REFERENCES users(id) ON DELETE CASCADE,
|
|
study_space_id uuid REFERENCES study_spaces(id) ON DELETE CASCADE,
|
|
created_at timestamp with time zone DEFAULT now(),
|
|
updated_at timestamp with time zone DEFAULT now(),
|
|
PRIMARY KEY (user_id, study_space_id)
|
|
);
|
|
|
|
CREATE TRIGGER favourite_study_spaces_updated_at
|
|
AFTER UPDATE ON favourite_study_spaces
|
|
FOR EACH ROW EXECUTE FUNCTION handle_updated_at();
|