AECC database project.
stau.space
1CREATE TABLE IF NOT EXISTS board_member (
2 m_id VARCHAR(9) NOT NULL,
3 position VARCHAR(20) NOT NULL,
4 year NUMERIC(4,0) CHECK (year > 1701 AND year < 2100) NOT NULL,
5 role ENUM("Write", "Read", "None") NOT NULL,
6 password BINARY(64) NOT NULL,
7
8 PRIMARY KEY (m_id),
9 FOREIGN KEY (m_id) REFERENCES member(m_id) ON DELETE CASCADE
10);