编辑代码

CREATE DATABASE nursing_home_manage_sys;
USE nursing_home_manage_sys;

CREATE TABLE nhm_elderly_info (
    elderly_id INT NOT NULL PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    gender CHAR(1) NOT NULL,
    age INT NOT NULL,
    id_card VARCHAR(18) NOT NULL,
    phone VARCHAR(15),
    room_id INT,
    check_in_date DATE NOT NULL,
    health_status VARCHAR(255),
    notes TEXT,
    FOREIGN KEY (room_id) REFERENCES nhm_room_info(room_id)
);

-- 其他表的创建语句类似，根据文档依次创建