AECC database project.
stau.space
1CREATE TABLE IF NOT EXISTS member (
2 m_id VARCHAR(9) NOT NULL,
3 name VARCHAR(30) NOT NULL,
4 second_name VARCHAR(30) NOT NULL,
5 last_name VARCHAR(30) NOT NULL,
6 second_last_name VARCHAR(30) NOT NULL,
7 email VARCHAR(40) NOT NULL,
8 phone_number VARCHAR(15) NOT NULL,
9 status ENUM("Active", "Inactive") NOT NULL,
10
11 PRIMARY KEY (m_id),
12 FULLTEXT (name, second_name, last_name, second_last_name)
13);