CREATE TABLE IF NOT EXISTS board_member ( m_id VARCHAR(9) NOT NULL, position VARCHAR(20) NOT NULL, year NUMERIC(4,0) CHECK (year > 1701 AND year < 2100) NOT NULL, role ENUM("Write", "Read", "None") NOT NULL, password BINARY(64) NOT NULL, PRIMARY KEY (m_id), FOREIGN KEY (m_id) REFERENCES member(m_id) ON DELETE CASCADE );