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
);
