学习5

-- 创建老年人信息表
CREATE TABLE elderly_info (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
id_card VARCHAR(20) NOT NULL UNIQUE,
contact VARCHAR(20)
);

-- 创建评估结果表
CREATE TABLE assessment_result (
id INT AUTO_INCREMENT PRIMARY KEY,
elderly_id INT NOT NULL,
assessment_date DATE NOT NULL,
score INT NOT NULL,
level VARCHAR(20) NOT NULL,
FOREIGN KEY (elderly_id) REFERENCES elderly_info(id)
);