stau.space / aecc-db
AECC database project.
fork atom
aecc-db / lib / sql / activity_transaction.sql
at master 255 B view raw
1CREATE TABLE IF NOT EXISTS activity_transaction ( 2 a_id INT NOT NULL, 3 t_id INT NOT NULL, 4 5 PRIMARY KEY (a_id, t_id), 6 FOREIGN KEY (a_id) REFERENCES activity(a_id) ON DELETE CASCADE, 7 FOREIGN KEY (t_id) REFERENCES transaction(t_id) ON DELETE CASCADE 8);