生成以下表的sql脚本 HIS系统包含患者基本信息表、护理信息表、诊疗信息表、费用信息表、检查报告表、药品信息表、病历文书表等表。

CREATE TABLE PatientBasicInfo(
patient_id INTEGER PRIMARY KEY,
patient_name VARCHAR(50),
patient_age INTEGER,
patient_gender VARCHAR(10),
patient_address VARCHAR(100)
);CREATE TABLE NursingInfo(
nursing_id INTEGER PRIMARY KEY,
patient_id INTEGER,
nursing_time VARCHAR(50),
nursing_content VARCHAR(100)
);CREATE TABLE DiagnosisInfo(
diagnosis_id INTEGER PRIMARY KEY,
patient_id INTEGER,
diagnosis_time VARCHAR(50),
diagnosis_content VARCHAR(100)
);CREATE TABLE FeeInfo(
fee_id INTEGER PRIMARY KEY,
patient_id INTEGER,
fee_time VARCHAR(50),
fee_content VARCHAR(100)
);CREATE TABLE CheckReport(
report_id INTEGER PRIMARY KEY,
patient_id INTEGER,
report_time VARCHAR(50),
report_content VARCHAR(100)
);CREATE TABLE DrugInfo(
drug_id INTEGER PRIMARY KEY,
patient_id INTEGER,
drug_time VARCHAR(50),
drug_content VARCHAR(100)
);CREATE TABLE MedicalRecord(
record_id INTEGER PRIMARY KEY,
patient_id INTEGER,
record_time VARCHAR(50),
record_content VARCHAR(100)
);