user_notice

CREATE TABLE `sitedb`.`user_notice` ( id BIGINT(20) NOT NULL AUTO_INCREMENT, study_id BIGINT(20) NOT NULL, sender_id BIGINT(20) NOT NULL, receiver_id BIGINT(20) NOT NULL, is_comment BOOLEAN NOT NULL, message TEXT NOT NULL, create_date DATETIME DEFAULT NOW(), url TEXT NOT NULL, ischeck BOOLEAN DEFAULT 0, PRIMARY KEY (id), FOREIGN KEY (study_id) REFERENCES study(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (sender_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (receiver_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;