Scribd
Upload
7 views14 pages

Medical Database Table Structures

The document contains SQL statements for creating multiple tables in a database, including `calculation_type`, `commonly_used_diagnosis`, `commonly_used_drugs`, and others. Each table is defined with specific columns, data types, and comments describing their purpose. The tables are designed to manage various aspects of medical records, diagnoses, drugs, and examinations.

Uploaded by

zubair khan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views14 pages

Medical Database Table Structures

The document contains SQL statements for creating multiple tables in a database, including `calculation_type`, `commonly_used_diagnosis`, `commonly_used_drugs`, and others. Each table is defined with specific columns, data types, and comments describing their purpose. The tables are designed to manage various aspects of medical records, diagnoses, drugs, and examinations.

Uploaded by

zubair khan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

CREATE TABLE `calculation_type` (

`Calculation_Type_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '结


算类别 ID',
`Calculation_Type_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '结算类别',
PRIMARY KEY (`Calculation_Type_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `commonly_used_diagnosis` (
`Commonly_Used_Diagnosis_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT '常用诊断 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID',
`Disease_ID` int(11) NULL DEFAULT NULL COMMENT '疾病 ID',
PRIMARY KEY (`Commonly_Used_Diagnosis_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `commonly_used_drugs` (
`Commonly_Used_Drugs` int(11) NOT NULL AUTO_INCREMENT COMMENT '常
用药品 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID',
`Drugs_ID` int(11) NULL DEFAULT NULL COMMENT '药品 ID',
PRIMARY KEY (`Commonly_Used_Drugs`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `commonly_used_fmedical` (
`Commonly_Used_Fmedical_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT '常用非药品项目 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID',
`Fmedical_Items_ID` int(11) NULL DEFAULT NULL COMMENT '非药品收费项目
ID',
PRIMARY KEY (`Commonly_Used_Fmedical_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `constant_items` (
`Constant_Items_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '常数项
ID',
`Constant_Type_ID` int(11) NOT NULL COMMENT '常数项类别 ID',
`Constant_Items_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '常数项编码',
`Constant_Items_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '常数项名称',
PRIMARY KEY (`Constant_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 165 CHARACTER SET = utf8
COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `constant_type` (
`Constant_Type_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '常数项类
别 ID',
`Constant_Type_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '常数项类别编码',
`Constant_Type_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '常数项类别名称 科室分类、收费方式、性别类型、医生职称、药品类
型、药品剂型',
PRIMARY KEY (`Constant_Type_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `day_cal` (
`Day_Cal_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '日结 ID',
`User_ID` int(11) NOT NULL COMMENT '用户 ID',
`Day_Cal_Date` datetime(0) NOT NULL ON UPDATE
CURRENT_TIMESTAMP(0) COMMENT '日结日期',
`YF_Total` double(11, 2) NOT NULL COMMENT '药费',
`GH_Total` double(11, 2) NOT NULL COMMENT '挂号费',
`Day_Cal_Total` double(11, 2) NOT NULL COMMENT '日结总额',
`CL_Total` double(11, 2) NOT NULL COMMENT '材料费',
`JC_Total` double(11, 2) NOT NULL COMMENT '检查费',
`CZ_Total` double(11, 2) NOT NULL COMMENT '处置+麻醉费',
`QT_Total` double(11, 2) NOT NULL COMMENT '其他费用',
PRIMARY KEY (`Day_Cal_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `department` (
`Department_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '科室 ID',
`Department_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '科室编码',
`Department_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '科室名称',
`Department_Category_ID` int(11) NULL DEFAULT NULL COMMENT '科室分类
（参考常数项表 内科、外科等）',
`Department_Type` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '科室类型（1 临床 2 医技 3 财务 4 行政
5 其他 ）',
PRIMARY KEY (`Department_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8
COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `diagnosis` (
`Diagnosis_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '诊断 ID',
`Disease_ID` int(11) NULL DEFAULT NULL COMMENT '疾病 ID',
`Medical_Record_ID` int(11) NULL DEFAULT NULL COMMENT '病历 ID',
`Main_Diagnosis_Mark` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '主诊标志 1 非主诊 2 主诊',
`Suspect_Mark` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '疑似标志 1 确认 2 疑似',
`Onset_Date` date NULL DEFAULT NULL COMMENT '发病日期（患者发病的日期）',
`Diagnosis_Mark` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '诊断标志 1 初诊 2 终诊',
PRIMARY KEY (`Diagnosis_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `diagnosis_template` (
`Diagnosis_Template_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT
'诊断模板 ID',
`Medical_Record_Home_Page_Template_ID` int(11) NULL DEFAULT NULL
COMMENT '病历首页模板 ID',
`Disease_ID` int(11) NULL DEFAULT NULL COMMENT '疾病 ID',
`Main_Diagnosis_Mark` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '主诊标志 1 非主诊 2 主诊',
`Suspect_Mark` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '疑似标志 1 非疑似 2 疑似',
PRIMARY KEY (`Diagnosis_Template_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `disease` (
`Disease_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '疾病 ID',
`Disease_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '疾病编码',
`Disease_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '疾病名称',
`Disease_ICD` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '疾病 ICD 编码',
`Disease_Type_ID` int(11) NOT NULL COMMENT '疾病分类 ID（参考疾病分类表）',
`Disease_Customize_Name1` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '疾病自定义名称 1',
`Disease_Customize_Name2` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '疾病自定义名称 2',
PRIMARY KEY (`Disease_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29396 CHARACTER SET = utf8
COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `disease_type` (
`Disease_Type_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '疾病分类
ID',
`Disease_Type_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '疾病分类编码',
`Disease_Type_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '疾病分类名称',
`Disease_Type_Sequence` int(11) NULL DEFAULT NULL,
`Disease_Type_Type` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '疾病类别：1 西医疾病 2 中医疾病',
`Disease_Folder_ID` int(11) NULL DEFAULT NULL COMMENT '疾病文件夹
ID',
PRIMARY KEY (`Disease_Type_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 483 CHARACTER SET = utf8
COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `drugs` (
`Drugs_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '药品 ID',
`Drugs_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '药品编码',
`Drugs_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '药品名称',
`Drugs_Format` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '药品规格（如 100g/盒）',
`Drugs_Unit` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '包装单位（盒、瓶等）',
`Drugs_Manufacturer` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '生产厂家',
`Drugs_Dosage_ID` int(11) NULL DEFAULT NULL COMMENT '药品剂型 ID （参照
常数项表 冲剂等）',
`Drugs_Type_ID` int(11) NULL DEFAULT NULL COMMENT '药品类型 ID（参照常数项
表 西药 中成药 中草药）',
`Drugs_Price` double(11, 2) NULL DEFAULT NULL COMMENT '药品单价',
`Drugs_MnemonicCode` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '拼音助记码',
`Create_Time` date NULL DEFAULT NULL,
`Reverse1` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL,
`Reverse2` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL,
`Reverse3` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`Drugs_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2967 CHARACTER SET = utf8
COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `examination` (
`Examination_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '检查检验
ID',
`Medical_Record_ID` int(11) NULL DEFAULT NULL COMMENT '病历 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID(开设检查检验项的医生
ID)',
`Examination_Mark` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '检查检验标志：1 检查 2 检验',
`Doctor_Advice` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '医生嘱托',
`Submit_Time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间',
PRIMARY KEY (`Examination_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `examination_drugs_items` (
`Examination_Drugs_Items_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT 'id',
`Examination_Fmedical_Items_ID` int(11) NULL DEFAULT NULL
COMMENT '检查检验 非药品明细 ID',
`Drugs_ID` int(11) NULL DEFAULT NULL COMMENT '药品 id',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '开立药物的医技医生 ID（默认为空
当为医技医生开立时存储医技医生的 ID）',
`Drugs_Usage` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NULL DEFAULT NULL COMMENT '用法：1 静脉滴注 2 静脉可注 3 肌肉注射 4 口服 5 皮试 6 皮下注
射',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '开立数量',
`Actual_Quantity` int(11) NULL DEFAULT NULL COMMENT '实际数量（开立数量-退
药数量）',
`Drugs_Dispensing_Status` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '发药状态 ：1 未发药 2 已发药',
`Expense_Items_ID` int(11) NULL DEFAULT NULL COMMENT '收费明细 ID',
`Times` int(11) NULL DEFAULT NULL COMMENT '次数',
`Days` int(11) NULL DEFAULT NULL COMMENT '天数 （与 Times 联合使用 *天*次）',
`Dosage` double(11, 2) NULL DEFAULT NULL COMMENT '用量',
PRIMARY KEY (`Examination_Drugs_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `examination_fmedical_items` (
`Examination_Fmedical_Items_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT '非药品检查检验明细 ID',
`Examination_ID` int(11) NULL DEFAULT NULL COMMENT '检查检验 ID',
`Fmedical_Items_ID` int(11) NULL DEFAULT NULL COMMENT '非药品 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '登记该非药品收费项目的医技医生
ID',
`Registration_Status` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '登记状态：1 未登记 2 已登记',
`Purpose_Requirements` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '目的和要求',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '开立数量',
`Actual_Quantity` int(11) NULL DEFAULT NULL COMMENT '实际数量（开立数量-退
的数量）',
`Examination_Result_ID` int(11) NULL DEFAULT NULL COMMENT '检查检验结
果 ID',
`Expense_Items_ID` int(11) NULL DEFAULT NULL COMMENT '收费 ID',
`Valid_Status` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '有效状态：1 有效 2 无效（针对未登记的项目
可以作废）',
PRIMARY KEY (`Examination_Fmedical_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `examination_result` (
`Examination_Result_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT
'检查检验结果 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医技医生 ID',
`Findings` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '检查\\检验所见',
`Diagnostic_Suggestion` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '诊断意见',
`Submit_Time` datetime(0) NULL DEFAULT NULL COMMENT '诊断录入时间',
PRIMARY KEY (`Examination_Result_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `examination_result_image` (
`Examination_Result_Image_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT '检查检验图片 ID',
`Examination_Result_ID` int(11) NULL DEFAULT NULL COMMENT '检查检验结
果 ID',
`Image_URL` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '图片 url',
`Image_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '图片名称',
PRIMARY KEY (`Examination_Result_Image_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `expense_items` (
`Expense_Items_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '费用明细
ID',
`Medical_Record_ID` int(11) NOT NULL COMMENT '病历 ID',
`Total_Cost` double(11, 2) NOT NULL COMMENT '总费用',
`Pay_Status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NOT NULL COMMENT '收费状态:1 已缴费 2 退费',
`Invoice_ID` int(11) NULL DEFAULT NULL COMMENT '交费后，打印发票并生成发票号。退
费时根据发票号确定退费项目是什么。\r\n 发票上项目全部退掉，重打剩余部分。\r\n 或者退掉部分。',
`Expense_Type_ID` int(11) NULL DEFAULT NULL COMMENT '每个收费项目对应一个收
费条目 Expense_Type_ID 记录该项目的收费类型',
PRIMARY KEY (`Expense_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 118 CHARACTER SET = utf8
COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `expense_type` (
`Expense_Type_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '费用科目
ID',
`Expense_Type_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '费用科目编码',
`Expense_Type_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '费用科目名称',
PRIMARY KEY (`Expense_Type_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `fmedical_items` (
`Fmedical_Items_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '非药品
项目 ID',
`Fmedical_Items_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '非药品项目编码',
`Fmedical_Items_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '非药品项目名称',
`Fmedical_Items_Format` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '非药品项目规格',
`Fmedical_Items_Price` double(11, 2) NOT NULL COMMENT '非药品项目单价',
`Expense_Type_ID` int(11) NOT NULL COMMENT '所属费用科目 ID',
`Department_ID` int(11) NOT NULL COMMENT '执行科室 ID',
`Fmedical_Items_MnemonicCode` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NOT NULL COMMENT '拼音助记码',
`Fmedical_Items_Type` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '非药品项目类别（1 检查 2 检验 3 处置）',
`Create_Time` date NULL DEFAULT NULL COMMENT '创建时间',
`Reverse1` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '预留 1：创建人',
`Reverse2` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '预留 2：最近修改时间',
`Reverse3` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '预留 3：修改人',
PRIMARY KEY (`Fmedical_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `function` (
`Function_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '功能 ID',
`Role_ID` int(11) NOT NULL COMMENT '角色 ID',
`Function_URL` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '功能 URL',
`Function_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '功能名',
`Reverse1` int(11) NULL DEFAULT NULL COMMENT '预留 子菜单指向父菜单，无需指向
Role',
PRIMARY KEY (`Function_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `group_examination` (
`Group_Examination_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT
'检查检验组套 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '创建医生 ID',
`Group_Examination_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '组套编码',
`Group_Examination_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '组套 ID',
`Group_Examination_Scope` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '适用范围 ：1 个人 2 科室 3 全院',
`Create_Time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`Group_Examination_Type` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '组套检查检验类型：1 检查 2 检验',
PRIMARY KEY (`Group_Examination_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `group_examination_drugs_items` (
`Group_Examination_Drugs_Items_ID` int(11) NOT NULL
AUTO_INCREMENT COMMENT 'id',
`Group_Examination_Fmedical_Items_ID` int(11) NULL DEFAULT NULL
COMMENT '检查检验组套 非药品明细 ID',
`Drugs_ID` int(11) NULL DEFAULT NULL COMMENT '药品 id',
`Drugs_Usage` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NULL DEFAULT NULL COMMENT '用法：1 静脉滴注 2 静脉可注 3 肌肉注射 4 口服 5 皮试 6 皮下注
射',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '开立数量',
`Times` int(11) NULL DEFAULT NULL COMMENT '次数',
`Days` int(11) NULL DEFAULT NULL COMMENT '天数 （与 Times 联合使用 *天*次）',
`Dosage` double(11, 2) NULL DEFAULT NULL COMMENT '用量',
PRIMARY KEY (`Group_Examination_Drugs_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `group_examination_fmedical_items` (
`Group_Examination_Fmedical_Items_ID` int(11) NOT NULL
AUTO_INCREMENT COMMENT '非药品检查检验组套明细 ID',
`Group_Examination_ID` int(11) NULL DEFAULT NULL COMMENT '检查检验组套
ID',
`Fmedical_Items_ID` int(11) NULL DEFAULT NULL COMMENT '非药品 ID',
`Purpose_Requirements` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '目的和要求',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '数量',
PRIMARY KEY (`Group_Examination_Fmedical_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `group_prescription` (
`Group_Prescription_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT
'处方组套 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID',
`Group_Prescription_Code` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组合编码',
`Group_Prescription_Name` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组合名称',
`Group_Prescription_Scope` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '适用范围：1 个人 2 科室 3 全院',
`Create_Time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`Prescription_Type` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '处方类型：1 成药处方 2 草药处方',
PRIMARY KEY (`Group_Prescription_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `group_prescription_items` (
`Group_Prescription_Items_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT '处方条目 ID',
`Group_Prescription_ID` int(11) NULL DEFAULT NULL COMMENT '成药处方组
套 ID',
`Drugs_ID` int(11) NULL DEFAULT NULL COMMENT '药品 ID',
`Drugs_Usage` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NULL DEFAULT NULL COMMENT '用法：1 静脉滴注 2 静脉可注 3 肌肉注射 4 口服 5 皮试 6 皮下注
射',
`Dosage` double(11, 2) NULL DEFAULT NULL COMMENT '用量',
`Times` int(11) NULL DEFAULT NULL COMMENT '频次',
`Days` int(11) NULL DEFAULT NULL COMMENT '天数 （与频次组合 得到*天*次 如 1 天 3
次）',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '数量',
`Drugs_Advice` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '用药嘱托',
PRIMARY KEY (`Group_Prescription_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `group_treatment` (
`Group_Treatment_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '创建
医生',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '创建医生 ID',
`Group_Treatment_Code` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '组合代码',
`Group_Treatment_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '组合名称',
`Group_Treatment_Scope` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '适用范围 ：1 个人 2 科室 3 全院',
`Create_Time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`Group_Treatment_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `group_treatment_items` (
`Group_Treatment_Items_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT '处置组套明细 ID',
`Group_Treatment_ID` int(11) NULL DEFAULT NULL COMMENT '处置组套
ID',
`Fmedical_Items_ID` int(11) NULL DEFAULT NULL COMMENT '非药品项目
ID',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '开立数量',
`Group_Treatment_Scope` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '适用范围 1 个人 2 科室 3 全院',
PRIMARY KEY (`Group_Treatment_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `invoice` (
`Invoice_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '发票 ID',
`Invoice_NO` char(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '发票号',
`Total_Cost` double(11, 2) NULL DEFAULT NULL COMMENT '总计',
`Is_Day_Cal` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NOT NULL COMMENT '是否日结 1 未日结 2 已日结',
`Pay_Time` datetime(0) NULL DEFAULT NULL COMMENT '收费时间',
`User_ID` int(11) NULL DEFAULT NULL COMMENT '收费员',
`Pay_Mode_ID` int(11) NULL DEFAULT NULL COMMENT '支付方式 ID（参考常数项表 现
金、医保卡、银行卡、信用卡等）',
PRIMARY KEY (`Invoice_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `medical_record` (
`Medical_Record_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '病历
ID',
`Is_Treament_Over` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '是否诊毕 1:未诊毕 2:已诊毕',
`First_Diagnosis_Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '初
诊医生 ID',
`Final_Diagnosis_Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '确
诊医生 ID',
`First_Diagnosis_Time` datetime(0) NULL DEFAULT NULL COMMENT '初诊
时间',
`Final_Diagnosis_Time` datetime(0) NULL DEFAULT NULL COMMENT '确诊
时间',
`Doctor_ID` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`Medical_Record_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `medical_record_home_page` (
`Medical_Record_Home_Page_ID` int(11) NOT NULL AUTO_INCREMENT
COMMENT '病历首页',
`Medical_Record_ID` int(11) NULL DEFAULT NULL COMMENT '病历 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID',
`Chief_Complaint` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '主诉：病人对自我感觉最痛苦的病情的简要叙述',
`Present_History` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '现病史',
`Present_Treatment` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '现病治疗情况',
`Past_History` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '既往史',
`Allergic_History` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '过敏史',
`Physical_Examination` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '体格检查',
`Assistant_Examination` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '辅助检查结果（根据检查检验结果）',
PRIMARY KEY (`Medical_Record_Home_Page_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `medical_record_home_page_template` (
`Medical_Record_Home_Page_Template_ID` int(11) NOT NULL
AUTO_INCREMENT COMMENT '病历首页模板 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci
NULL DEFAULT NULL COMMENT '模板名称',
`Scope` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
DEFAULT NULL COMMENT '使用范围：1 个人 2 科室 3 全院',
`Chief_Complaint` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '主诉',
`Present_History` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '现病史',
`Physical_Examination` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '体格检查',
PRIMARY KEY (`Medical_Record_Home_Page_Template_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `patient` (
`Patient_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '患者 ID',
`Patient_Name` varchar(20) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '患者名称',
`Patient_Gender` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '患者性别 1 男 2 女',
`Patient_Birth` date NOT NULL COMMENT '患者生日',
`Patient_Age` int(3) NULL DEFAULT NULL COMMENT '患者年龄',
`Patient_IDentity` varchar(18) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '患者身份证号',
`Patient_Address` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '患者地址',
PRIMARY KEY (`Patient_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `prescription` (
`Prescription_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '处方
ID',
`Medical_Record_ID` int(11) NULL DEFAULT NULL COMMENT '病历 id',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 id',
`Submit_Time` datetime(0) NULL DEFAULT NULL COMMENT '开立时间（暂存情况下不
设置开立时间）',
`Prescription_Type` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '处方类型：1 成药 2 草药',
`Valid_Status` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '有效状态：1 有效 2 无效（针对全部未收款的
处方可以作废）',
PRIMARY KEY (`Prescription_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `prescription_items` (
`Prescription_Items_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT
'处方条目 ID',
`Prescription_ID` int(11) NULL DEFAULT NULL COMMENT '成药处方 id',
`Drags_ID` int(11) NULL DEFAULT NULL COMMENT '药品 id',
`Expense_Items_ID` int(11) NULL DEFAULT NULL COMMENT '收费 ID',
`Drugs_Usage` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NULL DEFAULT NULL COMMENT '用法：1 静脉滴注 2 静脉可注 3 肌肉注射 4 口服 5 皮试 6 皮下注
射',
`Dosage` double(11, 2) NULL DEFAULT NULL COMMENT '用量',
`Times` int(11) NULL DEFAULT NULL COMMENT '频次',
`Days` int(11) NULL DEFAULT NULL COMMENT '天数 （与频次组合 得到*天*次 如 1 天 3
次）',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '数量',
`Drugs_Advice` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '用药嘱托',
`Drugs_Dispensing_Status` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '发药状态：1 未发药 2 已发药',
`Actual_Quantity` int(11) NULL DEFAULT NULL COMMENT '实际数量（开立数量-退
药数量）',
PRIMARY KEY (`Prescription_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `registration` (
`Registration_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '挂号
ID',
`Medical_Record_ID` int(11) NULL DEFAULT NULL COMMENT '病历 ID',
`Registration_Level_ID` int(11) NULL DEFAULT NULL COMMENT '挂号级别
ID',
`Patient_ID` int(11) NULL DEFAULT NULL COMMENT '患者 ID',
`Department_ID` int(11) NULL DEFAULT NULL COMMENT '科室 ID',
`Calculation_Type_ID` int(11) NULL DEFAULT NULL COMMENT '结算类别
ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID',
`Registration_Date` datetime(0) NULL DEFAULT NULL COMMENT '挂号日
期',
`Buy_Medical_Record` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '是否购买病历本 0:没有 1:有 购买病历本需要
加 1 元',
`Registration_Total_Cost` double(11, 2) NULL DEFAULT NULL
COMMENT '挂号总费用',
`Expense_Type_ID` int(11) NULL DEFAULT NULL COMMENT '费用科目 ID',
`Expense_Items_ID` int(11) NULL DEFAULT NULL COMMENT '费用项目 ID',
`Registration_Status` char(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '挂号状态 1 未看诊 2 已看诊 3 诊毕 4 退
号',
PRIMARY KEY (`Registration_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `registration_level` (
`Registration_Level_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT
'挂号等级 ID',
`Registration_Level_Name` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NOT NULL COMMENT '挂号等级名称',
`Is_Default` varchar(1) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '是否默认 1 不是 2 是',
`Registration_Sequence` int(11) NULL DEFAULT NULL COMMENT '显示顺序
号',
`Registration_Cost` double(11, 2) NOT NULL COMMENT '挂号费用',
PRIMARY KEY (`Registration_Level_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `role` (
`Role_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色 ID',
`Function_id` int(11) NOT NULL COMMENT '功能 ID',
`Role_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '角色名',
PRIMARY KEY (`Role_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `scheduling_info` (
`Scheduling_Info_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '排班
信息 ID',
`Doctor_ID` int(11) NOT NULL COMMENT '医生 ID',
`Scheduling_NoonBreak` char(11) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '排班午别（1 上午 2 下午 3 晚上 4 全
天）',
`Scheduling_StartTime` datetime(0) NULL DEFAULT NULL COMMENT '排班
开始时间',
`Scheduling_EndTime` datetime(0) NULL DEFAULT NULL COMMENT '排班结束
时间',
`Scheduling_Weekday` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '排班日',
`Scheduling_LimitCount` int(3) NULL DEFAULT NULL COMMENT '排班限额',
`Scheduling_RestCount` int(3) NULL DEFAULT NULL COMMENT '剩余号数',
PRIMARY KEY (`Scheduling_Info_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `scheduling_rule` (
`Scheduling_Rule_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '排版
规则 ID',
`Doctor_ID` int(11) NOT NULL COMMENT '医生 ID',
`Scheduling_Rule_NoonBreak` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排班午别',
`Scheduling_Rule_StartTime` date NULL DEFAULT NULL COMMENT '排班开始
日期',
`Scheduling_Rule_EndTime` date NULL DEFAULT NULL COMMENT '排版结束日
期',
`Scheduling_Rule_Weekday` varchar(255) CHARACTER SET utf8
COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排版日',
`Scheduling_Rule_LimitCount` int(3) NULL DEFAULT NULL COMMENT '排
班限额',
PRIMARY KEY (`Scheduling_Rule_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `treatment` (
`Treatment_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '处置 ID',
`Medical_Record_ID` int(11) NULL DEFAULT NULL COMMENT '病历号 ID',
`Doctor_ID` int(11) NULL DEFAULT NULL COMMENT '医生 ID',
`Submit_Time` datetime(0) NULL DEFAULT NULL COMMENT '提交时间',
PRIMARY KEY (`Treatment_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `treatment_items` (
`Treatment_Items_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT
'id',
`Treatment_ID` int(11) NULL DEFAULT NULL COMMENT '处置 id',
`Fmedical_Items_ID` int(11) NULL DEFAULT NULL COMMENT '非药品目录
id',
`Quantity` int(11) NULL DEFAULT NULL COMMENT '数量',
`Actual_Quantity` int(11) NULL DEFAULT NULL COMMENT '实际数量（开立数量-实
际数量）',
`Expense_Items_ID` int(11) NULL DEFAULT NULL COMMENT '费用明细 ID',
`Valid_Status` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NULL DEFAULT NULL COMMENT '有效状态：1 有效 2 无效（针对未收费的项目
可以作废）',
PRIMARY KEY (`Treatment_Items_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `user` (
`User_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户 ID',
`User_loginName` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '用户登录名',
`User_password` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '用户密码',
`Role_ID` int(11) NOT NULL COMMENT '角色 ID',
`User_Name` varchar(255) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL COMMENT '用户姓名',
`Department_ID` int(11) NOT NULL COMMENT '科室 ID',
`User_Title_ID` int(11) NOT NULL COMMENT '医生职称 ID（常数项表中 主任医师 副主任医
师 主治医师 住院医师）',
`User_Gender` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NULL DEFAULT NULL COMMENT '性别 1 男 2 女',
`User_Status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci
NULL DEFAULT NULL COMMENT '工作状态：是否在线',
`User_Scheduling_LimitCount` int(10) NULL DEFAULT NULL,
PRIMARY KEY (`User_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE
= utf8_general_ci ROW_FORMAT = Dynamic;

You might also like