医院科研管理系统

CREATE TABLE Projects (

project_id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

start_date DATE,

end_date DATE

);

CREATE TABLE Researchers (

researcher_id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

email VARCHAR(255) UNIQUE NOT NULL

);

资产管理系统

CREATE TABLE Assignments (

assignment_id INT AUTO_INCREMENT PRIMARY KEY,

project_id INT,

researcher_id INT,

role VARCHAR(255),

FOREIGN KEY (project_id) REFERENCES Projects(project_id),

FOREIGN KEY (researcher_id) REFERENCES Researchers(researcher_id)

);

]]>