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) );此段脚本加上注释字段

此段脚本定义了7张表，分别是PatientBasicInfo表、NursingInfo表、DiagnosisInfo表、FeeInfo表、CheckReport表、DrugInfo表和MedicalRecord表，每张表中都包含了一些基本的字段，如patient_id、patient_name、patient_age、patient_gender、patient_address、nursing_time、nursing_content、diagnosis_time、diagnosis_content、fee_time、fee_content、report_time、report_content、drug_time、drug_content和record_time、record_content等。