study_report

CREATE TABLE `sitedb`.`study_report` ( study_id BIGINT(20) NOT NULL, user_id BIGINT(20) NOT NULL, description TEXT, create_date DATETIME DEFAULT NOW(), PRIMARY KEY (study_id, user_id), FOREIGN KEY (study_id) REFERENCES study(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;