/*==============================================================*/
/* Table: ADT.ADMISSIONTIME_CHANGE_APPLY */
/*==============================================================*/
drop table ADT.ADMISSIONTIME_CHANGE_APPLY;
db2 sql-------------------------------
CREATE TABLE ADT.ADMISSIONTIME_CHANGE_APPLY (
APPLY_SN VARCHAR(36) not null,
IPID VARCHAR(25),
PID VARCHAR(25),
ADMINISSION_NO VARCHAR(15),
PATIENT_NAME VARCHAR(40),
APPLIER_ID VARCHAR(36),
APPLIER VARCHAR(30),
APPLY_TIME VARCHAR(14),
DEPT_CODE VARCHAR(20),
DEPT_NAME VARCHAR(64),
WARD_CODE VARCHAR(20),
WARD_NAME VARCHAR(100),
AUDIT_STATUS VARCHAR(5),
APPLY_REASON VARCHAR(500),
AUDIT_USER_ID VARCHAR(36),
AUDIT_USER_NAME VARCHAR(50),
ADMISSION_TIME VARCHAR(14),
AUDITING_TIME VARCHAR(14),
CONSTRAINT PK_ADMISSIONTIME_CHANGE_APPLY PRIMARY KEY (APPLY_SN)
);
oracle sql-------------------------------
CREATE TABLE ADT.ADMISSIONTIME_CHANGE_APPLY (
APPLY_SN VARCHAR2(36) not null,
IPID VARCHAR2(25),
PID VARCHAR2(25),
ADMINISSION_NO VARCHAR2(15),
PATIENT_NAME VARCHAR2(40),
APPLIER_ID VARCHAR2(36),
APPLIER VARCHAR2(30),
APPLY_TIME VARCHAR2(14),
DEPT_CODE VARCHAR2(20),
DEPT_NAME VARCHAR2(64),
WARD_CODE VARCHAR2(20),
WARD_NAME VARCHAR2(100),
AUDIT_STATUS VARCHAR2(5),
APPLY_REASON VARCHAR2(500),
AUDIT_USER_ID VARCHAR2(36),
AUDIT_USER_NAME VARCHAR2(50),
ADMISSION_TIME VARCHAR2(14),
AUDITING_TIME VARCHAR2(14),
CONSTRAINT PK_ADMISSIONTIME_CHANGE_APPLY PRIMARY KEY (APPLY_SN)
);
create index IDX_ADM_CHANGE_APPLY_TIME on ADMISSIONTIME_CHANGE_APPLY(APPLY_TIME);
/*==============================================================*/
/* Table: ADT.CLINIC_PATH */
/*==============================================================*/
drop table ADT.CLINIC_PATH;
db2 sql-------------------------------
CREATE TABLE ADT.CLINIC_PATH (
IPID VARCHAR(25) not null,
ENTER_PATH_TIME VARCHAR(14),
PATH_EXIT_TIME VARCHAR(14),
PATH_DISEASE_CODE VARCHAR(20),
PATH_DISEASE_NAME VARCHAR(150),
DISEASE_FLOW_CODE VARCHAR(20),
DISEASE_FLOW_NAME VARCHAR(150),
EXIT_REASON VARCHAR(500),
NOENTER_REASON VARCHAR(500),
CONSTRAINT PK_CLINIC_PATH PRIMARY KEY (IPID)
);
oracle sql-------------------------------
CREATE TABLE ADT.CLINIC_PATH (
IPID VARCHAR2(25) not null,
ENTER_PATH_TIME VARCHAR2(14),
PATH_EXIT_TIME VARCHAR2(14),
PATH_DISEASE_CODE VARCHAR2(20),
PATH_DISEASE_NAME VARCHAR2(150),
DISEASE_FLOW_CODE VARCHAR2(20),
DISEASE_FLOW_NAME VARCHAR2(150),
EXIT_REASON VARCHAR2(500),
NOENTER_REASON VARCHAR2(500),
CONSTRAINT PK_CLINIC_PATH PRIMARY KEY (IPID)
);
/*==============================================================*/
/* Table: ADT.FP_INFO */
/*==============================================================*/
drop table ADT.FP_INFO;
db2 sql-------------------------------
CREATE TABLE ADT.FP_INFO (
IPID VARCHAR(25) not null,
URLMD5 VARCHAR(100) not null,
CONSTRAINT PK_FP_INFO PRIMARY KEY (IPID,URLMD5)
);
oracle sql-------------------------------
CREATE TABLE ADT.FP_INFO (
IPID VARCHAR2(25) not null,
URLMD5 NVARCHAR2(100) not null,
CONSTRAINT PK_FP_INFO PRIMARY KEY (IPID,URLMD5)
);
/*==============================================================*/
/* Table: ADT.IN_HOSPITAL_RECORD */
/*==============================================================*/
drop table ADT.IN_HOSPITAL_RECORD;
db2 sql-------------------------------
CREATE TABLE ADT.IN_HOSPITAL_RECORD (
REC_SN VARCHAR(32) not null,
PATIENT_NAME VARCHAR(40),
SEX VARCHAR(10),
DATA_OF_BIRTH VARCHAR(14),
IS_AGAIN_IN VARCHAR(10),
PID_OLD VARCHAR(20),
MJ_DIAG VARCHAR(500),
DAMAGE_POI_CAUSE VARCHAR(300),
ADMISSION_WAY VARCHAR(10),
ADMISSION_WAY_COMMENT VARCHAR(200),
ADMISSION_STATE VARCHAR(800),
ADMISSION_DEPT VARCHAR(40),
ADMISSION_DEPT_CODE VARCHAR(20),
BED_NO VARCHAR(20),
FRONT_TYPE VARCHAR(10),
PLAN_IN_TIME VARCHAR(14),
DOCTOR_SIGNATURE VARCHAR(200),
DOCTOR_SIGNATURE_ID VARCHAR(150),
REMARKS CLOB(1M),
CREATOR VARCHAR(30),
CREATOR_NAME VARCHAR(50),
CREATETIME VARCHAR(30),
MODIFIER VARCHAR(64),
MODIFIER_NAME VARCHAR(50),
MODIFYTIME VARCHAR(14),
SUBMIT_STATUS VARCHAR(1),
SUBMIT_TIME VARCHAR(14),
SUBMIT_USER_ID VARCHAR(36),
SUBMIT_USER_NAME VARCHAR(50),
MJ_DIAG_CODE VARCHAR(20),
DAMAGE_POI_CAUSE_CODE VARCHAR(20),
CONSTRAINT PK_IN_HOSPITAL_RECORD PRIMARY KEY (REC_SN)
);
oracle sql-------------------------------
CREATE TABLE ADT.IN_HOSPITAL_RECORD (
REC_SN VARCHAR2(32) not null,
PATIENT_NAME VARCHAR2(40),
SEX VARCHAR2(10),
DATA_OF_BIRTH VARCHAR2(14),
IS_AGAIN_IN VARCHAR2(10),
PID_OLD VARCHAR2(20),
MJ_DIAG VARCHAR2(500),
DAMAGE_POI_CAUSE VARCHAR2(300),
ADMISSION_WAY VARCHAR2(10),
ADMISSION_WAY_COMMENT VARCHAR2(200),
ADMISSION_STATE VARCHAR2(800),
ADMISSION_DEPT VARCHAR2(40),
ADMISSION_DEPT_CODE VARCHAR2(20),
BED_NO VARCHAR2(20),
FRONT_TYPE VARCHAR2(10),
PLAN_IN_TIME VARCHAR2(14),
DOCTOR_SIGNATURE VARCHAR2(200),
DOCTOR_SIGNATURE_ID VARCHAR2(150),
REMARKS CLOB,
CREATOR VARCHAR2(30),
CREATOR_NAME VARCHAR2(50),
CREATETIME VARCHAR2(30),
MODIFIER VARCHAR2(64),
MODIFIER_NAME VARCHAR2(50),
MODIFYTIME VARCHAR2(14),
SUBMIT_STATUS VARCHAR2(1),
SUBMIT_TIME VARCHAR2(14),
SUBMIT_USER_ID VARCHAR2(36),
SUBMIT_USER_NAME VARCHAR2(50),
MJ_DIAG_CODE VARCHAR2(20),
DAMAGE_POI_CAUSE_CODE VARCHAR2(20),
CONSTRAINT PK_IN_HOSPITAL_RECORD PRIMARY KEY (REC_SN)
);
/*==============================================================*/
/* Table: ADT.INP_CASE_INFO */
/*==============================================================*/
drop table ADT.INP_CASE_INFO;
db2 sql-------------------------------
CREATE TABLE ADT.INP_CASE_INFO (
REC_SN VARCHAR(32) not null,
IPID VARCHAR(25),
RECORD_TYPE VARCHAR(100),
RELATED_REC_SN VARCHAR(36),
MODULE_NAME VARCHAR(200),
ACTION_NAME VARCHAR(50),
METHODNAME VARCHAR(30),
FLAG VARCHAR(36),
CONSTRAINT PK_INP_CASE_INFO PRIMARY KEY (REC_SN)
);
oracle sql-------------------------------
CREATE TABLE ADT.INP_CASE_INFO (
REC_SN VARCHAR2(32) not null,
IPID VARCHAR2(25),
RECORD_TYPE VARCHAR2(100),
RELATED_REC_SN VARCHAR2(36),
MODULE_NAME VARCHAR2(200),
ACTION_NAME VARCHAR2(50),
METHODNAME VARCHAR2(30),
FLAG VARCHAR2(36),
CONSTRAINT PK_INP_CASE_INFO PRIMARY KEY (REC_SN)
);
/*==============================================================*/
/* Table: ADT.INP_CHANGE_INFO */
/*==============================================================*/
drop table ADT.INP_CHANGE_INFO;
db2 sql-------------------------------
CREATE TABLE ADT.INP_CHANGE_INFO (
CHANGE_SN VARCHAR(20) not null,
IPID VARCHAR(25),
CHANGE_TIME VARCHAR(14),
CHANGE_TYPE VARCHAR(10),
SRC_CODE VARCHAR(36),
SRC_DESC VARCHAR(40),
DEST_CODE VARCHAR(10),
DEST_DESC VARCHAR(40),
OPERATOR VARCHAR(30),
OPERATOR_ID VARCHAR(10),
OPERATOR_TIME VARCHAR(14),
REMARK VARCHAR(1000),
CONSTRAINT PK_INP_CHANGE_INFO PRIMARY KEY (CHANGE_SN)
);
oracle sql-------------------------------
CREATE TABLE ADT.INP_CHANGE_INFO (
CHANGE_SN VARCHAR2(20) not null,
IPID VARCHAR2(25),
CHANGE_TIME VARCHAR2(14),
CHANGE_TYPE VARCHAR2(10),
SRC_CODE VARCHAR2(36),
SRC_DESC VARCHAR2(40),
DEST_CODE VARCHAR2(10),
DEST_DESC VARCHAR2(40),
OPERATOR VARCHAR2(30),
OPERATOR_ID VARCHAR2(10),
OPERATOR_TIME VARCHAR2(14),
REMARK VARCHAR2(1000),
CONSTRAINT PK_INP_CHANGE_INFO PRIMARY KEY (CHANGE_SN)
);
create index IDX_INP_CHANGE_INFO_IPID on INP_CHANGE_INFO(IPID);
/*==============================================================*/
/* Table: ADT.INP_MEDICARE_AUDIT */
/*==============================================================*/
drop table ADT.INP_MEDICARE_AUDIT;
db2 sql-------------------------------
CREATE TABLE ADT.INP_MEDICARE_AUDIT (
REC_SN VARCHAR(32) not null,
IPID VARCHAR(25),
PID VARCHAR(25),
MEDICARE_AUDIT_STATUS VARCHAR(1),
CREATOR VARCHAR(30),
CREATOR_NAME VARCHAR(50),
CREATOR_TIME VARCH
海泰EMR3.0表结构
需积分: 10 78 浏览量
2019-04-26
10:43:50
上传
评论 2
收藏 1.43MB ZIP 举报
海泰EMR3.0表结构 （1427个子文件） 
adodb.dll 108KB Interop.MSDASC.dll 14KB
aaa表结构查看器.exe 112KB
EMRTableViewer_ExportSql.txt 1.76MB INPORD.MEDICAL_ORDER.txt 19KB INPCASE.OPERATION_INFO_REC.txt 13KB ADT.INPATIENT.txt 13KB MPI.PATIENT.txt 12KB INPORD.DRUG_ORDER.txt 11KB VISITDIABETES.VISIT_PATIENT_INFO.txt 11KB htszzx.ART_OPERATION_INFO_REC.txt 11KB OUTP.OUT_REGISTER.txt 10KB OUTPORD.OUTP_DRUG_ORDER.txt 9KB OUTPORD.OUTP_MEDICAL_ORDER.txt 9KB HTCPP.CP_SET_LEVEL_ITEM_ORDER_INFO.txt 9KB NURSING.APACHE_SCORE.txt 8KB EMERGENCYP.EMERGENCY_PATIENT.txt 8KB HTCPP.IN_PATIENT.txt 8KB MPI.PATIENT_CUSTOM.txt 8KB INPCHILD.INPATIENT_CHILD.txt 8KB INPCASE.OPERA_RELATION_INFO_REC.txt 8KB HTIP.PATIENT_INFO.txt 8KB CDR.DATA_INPATIENT.txt 7KB OUTP.OUTPATIENT.txt 7KB NURSING.ICU_NURSING_BILL.txt 7KB NURSING.SPECIAL_BILL.txt 7KB CDR.DATA_MEDICAL_ORDER.txt 7KB INPORD.ORDER_EXECUTE.txt 7KB INPTEMPER.TEMPERATURE.txt 6KB INPCASE.FRONT_SHEET_FEE.txt 6KB DRUG.DRUG_DICT.txt 6KB VISITDIABETES.VISIT_PATIENT_RECORD.txt 6KB OUTP.OUTP_TURN_INP_INFO.txt 6KB NURSING.ICU_NURSING_DETAIL.txt 6KB EMERPORD.EMERP_DRUG_ORDER.txt 6KB htszzx.ART_PERIOD_PATIENT_MAIN.txt 6KB OUTM.OUT_DRUG_PACKAGE.txt 6KB PH.DISEASE_REPORT.txt 6KB INPORD.TREATMENT_ORDER.txt 6KB INPORD.EXAM_APPLY.txt 6KB CDR.DATA_DRUG_ORDER.txt 6KB NURSING.EMER_SPECIAL_BILL.txt 6KB INPCASE.OPERATION_INFO_SUB_REC.txt 6KB NURSING.EMER_TEMPERATURE.txt 6KB PA.DRUG_PACKAGE.txt 6KB LAB.LAB_REPORT.txt 6KB INPCASE.OUT_CONSULTATION_APPLY.txt 6KB LAB.LAB_APPLY_ITEM.txt 5KB ADT.INPATIENT_OTHER.txt 5KB htszzx.ART_OPERA_RELATION_INFO_REC.txt 5KB INPCASE.CONSULTATION_REC.txt 5KB EMERPORD.EMERP_MEDICAL_ORDER.txt 5KB INPCASE.BIVARIATE_STRUCTS_SHEET.txt 5KB MIC.DRUG_CATALOG.txt 5KB INFECT.INFECT_APPLY_OPERA_ITEM.txt 5KB htszzx.ART_MONITOR_FREA.txt 5KB INPCASE.PROGRESS_NOTE.txt 5KB EMERGENCYP.EMERGENCY_REGISTER.txt 5KB EMERGENCYPCASE.EMER_MODULE_BILL.txt 5KB HTCPP.CPP_LEVEL_ITEM.txt 5KB CDR.DATA_TEMPERATURE.txt 5KB MEDTERM.MEDICAL_ITEM_DICT.txt 5KB PA.ORDER_PACKAGE_ITEM.txt 5KB OUTPORD.OUTP_TREATMENT_ORDER.txt 5KB NURSING.SPECIAL_BILL_STAT.txt 5KB INPORD.EXAM_ORDER.txt 5KB VISITDIABETES.VISIT_ADVICE.txt 5KB VISITDIABETES.VISIT_LAB_REPORT .txt 5KB OUTPORD.OUTP_EXAM_APPLY.txt 5KB INPCASE.CONSULTATION_APPLY.txt 5KB OUTPORD.OUTP_CHARGE_APPLY.txt 5KB NURSING.MODULE_BILL.txt 5KB NURCONFIG.SPECIAL_BILL_CONFIG.txt 5KB MIC.PLANTED_CATALOG.txt 5KB htszzx.ART_PROGRESS_NOTE.txt 5KB INPCASE.OPERATION_INFO_REC_OR.txt 5KB MIC.CLINIC_PROJECT_CATALOG.txt 5KB INPORD.ANTIBIOTIC_REASON_REC_QZ.txt 5KB INPCASE.INP_DIAG.txt 5KB EXAM.EXAM_ORDER_ITEM.txt 5KB INPORD.ORDER_PAY_ITEM.txt 4KB ADT.MEDICAL_RECORD_LOG.txt 4KB DRUG.OUT_DRUG_DEFAULT_DOSAGE.txt 4KB INPCASE.ADMISSION_DISCHARGE_24H_REC.txt 4KB INPCASE.DEATH_REC.txt 4KB INPORD.LAB_APPLY.txt 4KB BIVSTUCT.BIVARIATE_CONS_REC.txt 4KB LEAVEORD.LEAVE_DRUG_ORDER.txt 4KB INPCASE.DEATH_24H_REC.txt 4KB INPCASE.MINOR_OPERATION_REC.txt 4KB HTCPP.CP_PATIENT.txt 4KB INFECT.INFECT_APPLY_ANTIMICRO_ITEM.txt 4KB EXAM.EXAM_REPORT.txt 4KB INPCHILD.CHILD_TEMPERATURE.txt 4KB INFECT.INFECT_APPLY.txt 4KB INPORD.ANTIBIOTIC_APPLY.txt 4KB INPCASE.CROSS_DEPT_DISPOSE.txt 4KB OUTP.OUTP_DIAG.txt 4KB INPORD.DISPENSE_APPLY.txt 4KB NURCONFIG.GRID_BILL_CONFIG.txt 4KB共 1427 条
- 1
- 2
- 3
- 4
- 5
- 6
- 15
资源评论
