。本数据库旨在管理个人简历信息包括姓名、性别、出生日期、身份证号、电话、邮箱等信息根据以上信息建立五个表用数据库代码实现

CREATE TABLE Person ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, gender ENUM('Male', 'Female') NOT NULL, date_of_birth DATE NOT NULL, id_number VARCHAR(18) NOT NULL, phone VARCHAR(20) NOT NULL, email VARCHAR(50) NOT NULL );

CREATE TABLE Education ( id INT PRIMARY KEY AUTO_INCREMENT, person_id INT NOT NULL, degree VARCHAR(50) NOT NULL, major VARCHAR(50) NOT NULL, start_date DATE NOT NULL, end_date DATE NOT NULL, school VARCHAR(100) NOT NULL, FOREIGN KEY (person_id) REFERENCES Person(id) );

CREATE TABLE Experience ( id INT PRIMARY KEY AUTO_INCREMENT, person_id INT NOT NULL, company VARCHAR(100) NOT NULL, position VARCHAR(50) NOT NULL, start_date DATE NOT NULL, end_date DATE NOT NULL, job_description TEXT NOT NULL, FOREIGN KEY (person_id) REFERENCES Person(id) );

CREATE TABLE Skill ( id INT PRIMARY KEY AUTO_INCREMENT, person_id INT NOT NULL, name VARCHAR(50) NOT NULL, level ENUM('Beginner', 'Intermediate', 'Expert') NOT NULL, FOREIGN KEY (person_id) REFERENCES Person(id) );

CREATE TABLE Certificate ( id INT PRIMARY KEY AUTO_INCREMENT, person_id INT NOT NULL, name VARCHAR(100) NOT NULL, issuing_organization VARCHAR(100) NOT NULL, date_obtained DATE NOT NULL, FOREIGN KEY (person_id) REFERENCES Person(id) )