CREATE TABLE IF NOT EXISTS logger ( m_id VARCHAR(9) NOT NULL, t_id INT NOT NULL, FOREIGN KEY (m_id) REFERENCES member(m_id) ON DELETE CASCADE, FOREIGN KEY (t_id) REFERENCES transaction(t_id) ON DELETE CASCADE, PRIMARY KEY (m_id, t_id) );