Pere Casafont
05/09/2018, 12:34 PMCREATE TABLE user_track
(
user_id BIGINT,
track_id BIGINT,
preference_score DOUBLE NOT NULL,
PRIMARY KEY (user_id, track_id),
CONSTRAINT user_track_user_id_fk FOREIGN KEY (user_id) REFERENCES user (id)
ON UPDATE CASCADE
ON DELETE CASCADE,
CONSTRAINT user_track_track_id_fk FOREIGN KEY (track_id) REFERENCES track (id)
ON UPDATE CASCADE
ON DELETE CASCADE
);