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