-- Start of DDL Script for Table SD_HOSPITAL.INPATIENTINFO
-- Generated 25-三月-2021 10:06:39 from SD_HOSPITAL@HISLIS

CREATE TABLE inpatientinfo
    (recordflow                     VARCHAR2(32 BYTE) NOT NULL,
    ipid                           VARCHAR2(20 BYTE) NOT NULL,
    pid                            VARCHAR2(20 BYTE),
    adminissionno                  VARCHAR2(15 BYTE),
    admissiontimes                 NUMBER(5,0),
    patientname                    VARCHAR2(40 BYTE),
    sexcode                        VARCHAR2(10 BYTE),
    sex                            VARCHAR2(30 BYTE),
    age                            VARCHAR2(16 BYTE),
    agedesc                        VARCHAR2(20 BYTE),
    marriagestatuscode             VARCHAR2(10 BYTE),
    marriagestatus                 VARCHAR2(30 BYTE),
    feetypecode                    VARCHAR2(20 BYTE),
    feetypename                    VARCHAR2(150 BYTE),
    patientclass                   VARCHAR2(10 BYTE),
    admissionregistertime          VARCHAR2(14 BYTE),
    admissionway                   VARCHAR2(10 BYTE),
    admissionpurpose               VARCHAR2(10 BYTE),
    admissionhospital              VARCHAR2(40 BYTE),
    admissiondeptcode              VARCHAR2(10 BYTE),
    admissiondept                  VARCHAR2(40 BYTE),
    admissionwardcode              VARCHAR2(10 BYTE),
    admissionward                  VARCHAR2(40 BYTE),
    hospital                       VARCHAR2(40 BYTE),
    deptcode                       VARCHAR2(10 BYTE),
    deptname                       VARCHAR2(40 BYTE),
    wardcode                       VARCHAR2(10 BYTE),
    wardname                       VARCHAR2(40 BYTE),
    dischargetime                  VARCHAR2(14 BYTE),
    bedno                          VARCHAR2(20 BYTE),
    bedfeetype                     VARCHAR2(10 BYTE),
    room                           VARCHAR2(10 BYTE),
    stateofillness                 VARCHAR2(10 BYTE),
    doctorid                       VARCHAR2(10 BYTE),
    doctor                         VARCHAR2(40 BYTE),
    medicalfrpcode                 VARCHAR2(10 BYTE),
    medicalgrp                     VARCHAR2(30 BYTE),
    nursionglevel                  VARCHAR2(20 BYTE),
    nurseid                        VARCHAR2(10 BYTE),
    nurse                          VARCHAR2(40 BYTE),
    nursinggrpcode                 VARCHAR2(10 BYTE),
    nursionggrp                    VARCHAR2(30 BYTE),
    instatus                       VARCHAR2(6 BYTE),
    mrstatus                       VARCHAR2(1 BYTE),
    dischargeway                   VARCHAR2(10 BYTE),
    managetype                     VARCHAR2(2 BYTE) NOT NULL,
    impflag                        VARCHAR2(2 BYTE) NOT NULL,
    returndesc                     VARCHAR2(200 BYTE),
    zyid00                         NUMBER(10,0),
    admissiontime                  VARCHAR2(14 BYTE),
    indepttype                     VARCHAR2(11 BYTE),
    zzdoctorcode                   VARCHAR2(10 BYTE),
    zzdoctorname                   VARCHAR2(40 BYTE),
    zrdoctorcode                   VARCHAR2(10 BYTE),
    zrdoctorname                   VARCHAR2(40 BYTE),
    indoctorname                   VARCHAR2(30 BYTE),
    opdoctorid                     VARCHAR2(10 BYTE),
    opdoctor                       VARCHAR2(30 BYTE),
    clinicdiagnosis                VARCHAR2(100 BYTE),
    clinicdiagnosiscode            VARCHAR2(100 BYTE),
    zydoctorcode                   VARCHAR2(10 BYTE),
    zydoctorname                   VARCHAR2(30 BYTE),
    jxdoctorcode                   VARCHAR2(10 BYTE),
    jxdoctorname                   VARCHAR2(30 BYTE),
    sxdoctorcode                   VARCHAR2(10 BYTE),
    sxdoctorname                   VARCHAR2(30 BYTE),
    medicineipid                   VARCHAR2(30 BYTE),
    medicalpaycode                 VARCHAR2(20 BYTE),
    medicalpayname                 VARCHAR2(50 BYTE),
    indoctorcode                   VARCHAR2(10 BYTE),
    resultdate                     VARCHAR2(8 BYTE),
    resulttime                     VARCHAR2(8 BYTE),
    createdate                     CHAR(8 BYTE) DEFAULT to_char(sysdate,'YYYYMMDD') NOT NULL,
    createtime                     CHAR(8 BYTE) DEFAULT to_char(sysdate,'HH24:MI:SS') NOT NULL,
    medicinecentertype             VARCHAR2(10 BYTE),
    medicinepatienttype            VARCHAR2(10 BYTE),
    inserttimeindepttype           VARCHAR2(10 BYTE),
    inserttime                     VARCHAR2(16 BYTE),
    cppinflag                      VARCHAR2(1 BYTE))
  SEGMENT CREATION IMMEDIATE
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  TABLESPACE  ts_yy
  STORAGE   (
    INITIAL     65536
    NEXT        1048576
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
  NOCACHE
  MONITORING
  NOPARALLEL
  LOGGING
/

-- Grants for Table
GRANT DELETE ON inpatientinfo TO sd_dzbljk
/
GRANT INSERT ON inpatientinfo TO sd_dzbljk
/
GRANT SELECT ON inpatientinfo TO sd_dzbljk
/
GRANT UPDATE ON inpatientinfo TO sd_dzbljk
/




-- Indexes for INPATIENTINFO

CREATE INDEX index_inpatientinfo_pid ON inpatientinfo
  (
    pid                             ASC
  )
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  ts_yy_index
  STORAGE   (
    INITIAL     65536
    NEXT        1048576
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
NOPARALLEL
LOGGING
/

CREATE INDEX index_inpatientinfo_ipid ON inpatientinfo
  (
    ipid                            ASC
  )
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  ts_yy_index
  STORAGE   (
    INITIAL     65536
    NEXT        1048576
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
NOPARALLEL
LOGGING
/



-- Constraints for INPATIENTINFO

ALTER TABLE inpatientinfo
ADD PRIMARY KEY (recordflow)
USING INDEX
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  ts_yy
  STORAGE   (
    INITIAL     65536
    NEXT        1048576
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
/


-- Triggers for INPATIENTINFO

CREATE OR REPLACE TRIGGER tr_inpatientinfo_bins
 BEFORE
  INSERT
 ON inpatientinfo
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
begin
  if inserting then
    if :new.RecordFlow is null then  --序号
       select SQ_InPatientInfo_RecordFlow.nextval into :new.RecordFlow from dual where rownum=1;
    end if;    
  end if;  
Exception
  when others        then
    raise_application_error(-20002,substr(nvl(sqlerrm, '原因不明出错')||'！*',1,220));
End tr_InPatientInfo_bins;
/


-- Comments for INPATIENTINFO

COMMENT ON TABLE inpatientinfo IS '病人住院信息中间表'
/
COMMENT ON COLUMN inpatientinfo.adminissionno IS '住院号'
/
COMMENT ON COLUMN inpatientinfo.admissiondept IS '入院科室'
/
COMMENT ON COLUMN inpatientinfo.admissiondeptcode IS '入院科室代码'
/
COMMENT ON COLUMN inpatientinfo.admissionhospital IS '入院时院区'
/
COMMENT ON COLUMN inpatientinfo.admissionpurpose IS '入院目的'
/
COMMENT ON COLUMN inpatientinfo.admissionregistertime IS '入院登记时间（格式：yyyyMMddHHmmss）'
/
COMMENT ON COLUMN inpatientinfo.admissiontime IS '首次入科时间（格式：yyyyMMddHHmmss）'
/
COMMENT ON COLUMN inpatientinfo.admissiontimes IS '住院次数'
/
COMMENT ON COLUMN inpatientinfo.admissionward IS '入院病区'
/
COMMENT ON COLUMN inpatientinfo.admissionwardcode IS '入院病区代码'
/
COMMENT ON COLUMN inpatientinfo.admissionway IS '入院方式'
/
COMMENT ON COLUMN inpatientinfo.age IS '年龄'
/
COMMENT ON COLUMN inpatientinfo.agedesc IS '年龄说明'
/
COMMENT ON COLUMN inpatientinfo.bedfeetype IS '床位费类型'
/
COMMENT ON COLUMN inpatientinfo.bedno IS '床号'
/
COMMENT ON COLUMN inpatientinfo.clinicdiagnosis IS '门诊诊断'
/
COMMENT ON COLUMN inpatientinfo.clinicdiagnosiscode IS '门诊诊断代码'
/
COMMENT ON COLUMN inpatientinfo.createdate IS '创建日期'
/
COMMENT ON COLUMN inpatientinfo.createtime IS '创建时间'
/
COMMENT ON COLUMN inpatientinfo.deptcode IS '当前科室代码'
/
COMMENT ON COLUMN inpatientinfo.deptname IS '病人出生地代码'
/
COMMENT ON COLUMN inpatientinfo.dischargetime IS '出院时间（格式：yyyyMMddHHmmss）'
/
COMMENT ON COLUMN inpatientinfo.dischargeway IS '出院方式【SW：死亡；ZC：正常；ZY：转院】'
/
COMMENT ON COLUMN inpatientinfo.doctor IS '管床医生'
/
COMMENT ON COLUMN inpatientinfo.doctorid IS '管床医生ID'
/
COMMENT ON COLUMN inpatientinfo.feetypecode IS '费别代码'
/
COMMENT ON COLUMN inpatientinfo.feetypename IS '费别'
/
COMMENT ON COLUMN inpatientinfo.hospital IS '当前院区'
/
COMMENT ON COLUMN inpatientinfo.impflag IS '接口是否处理（0-未处理 1-处理成功 2-处理失败）必填'
/
COMMENT ON COLUMN inpatientinfo.indepttype IS '入科操作状态（1-入科确认 2-取消入科）'
/
COMMENT ON COLUMN inpatientinfo.indoctorcode IS '收住医生代码'
/
COMMENT ON COLUMN inpatientinfo.instatus IS '住院状态【0：入院(待入科)；1：在科；2：出科(待入科)；3：待出院；4：出院；5：结算】'
/
COMMENT ON COLUMN inpatientinfo.ipid IS '病人住院流水号 必填'
/
COMMENT ON COLUMN inpatientinfo.jxdoctorcode IS '进修医生代码'
/
COMMENT ON COLUMN inpatientinfo.jxdoctorname IS '进修医生名称'
/
COMMENT ON COLUMN inpatientinfo.managetype IS '处理类型（1-新入院 2-出院3-住院信息修改（包括转科、转病区、转床、转诊疗组、转护理组等） 4-退院（删除） 5-出院后召回）必填'
/
COMMENT ON COLUMN inpatientinfo.marriagestatus IS '婚姻状况'
/
COMMENT ON COLUMN inpatientinfo.marriagestatuscode IS '婚姻状况代码'
/
COMMENT ON COLUMN inpatientinfo.medicalfrpcode IS '诊疗组代码'
/
COMMENT ON COLUMN inpatientinfo.medicalgrp IS '诊疗组'
/
COMMENT ON COLUMN inpatientinfo.medicalpaycode IS '医疗付费方式代码'
/
COMMENT ON COLUMN inpatientinfo.medicalpayname IS '医疗付费方式名称'
/
COMMENT ON COLUMN inpatientinfo.medicinecentertype IS '医保中心类别'
/
COMMENT ON COLUMN inpatientinfo.medicineipid IS '医保住院号'
/
COMMENT ON COLUMN inpatientinfo.medicinepatienttype IS '医保病人类别'
/
COMMENT ON COLUMN inpatientinfo.mrstatus IS '病历状态【i：正常；o：待归档；p：归档】'
/
COMMENT ON COLUMN inpatientinfo.nurse IS '管床护士'
/
COMMENT ON COLUMN inpatientinfo.nurseid IS '管床护士ID'
/
COMMENT ON COLUMN inpatientinfo.nursinggrpcode IS '护理组代码'
/
COMMENT ON COLUMN inpatientinfo.nursionggrp IS '护理组'
/
COMMENT ON COLUMN inpatientinfo.nursionglevel IS '护理等级'
/
COMMENT ON COLUMN inpatientinfo.opdoctor IS '门诊医生姓名'
/
COMMENT ON COLUMN inpatientinfo.opdoctorid IS '门诊医生代码'
/
COMMENT ON COLUMN inpatientinfo.patientclass IS '病人身份'
/
COMMENT ON COLUMN inpatientinfo.patientname IS '病人姓名'
/
COMMENT ON COLUMN inpatientinfo.pid IS '病人ID'
/
COMMENT ON COLUMN inpatientinfo.recordflow IS '记录流水号 必填 key'
/
COMMENT ON COLUMN inpatientinfo.resultdate IS '回写日期'
/
COMMENT ON COLUMN inpatientinfo.resulttime IS '回写时间'
/
COMMENT ON COLUMN inpatientinfo.returndesc IS '反馈说明'
/
COMMENT ON COLUMN inpatientinfo.room IS '病房'
/
COMMENT ON COLUMN inpatientinfo.sex IS '性别'
/
COMMENT ON COLUMN inpatientinfo.sexcode IS '性别代码'
/
COMMENT ON COLUMN inpatientinfo.stateofillness IS '病情'
/
COMMENT ON COLUMN inpatientinfo.sxdoctorcode IS '实习医生代码'
/
COMMENT ON COLUMN inpatientinfo.sxdoctorname IS '实习医生名称'
/
COMMENT ON COLUMN inpatientinfo.wardcode IS '当前病区代码'
/
COMMENT ON COLUMN inpatientinfo.wardname IS '当前病区名称'
/
COMMENT ON COLUMN inpatientinfo.zrdoctorname IS '主任医生姓名'
/
COMMENT ON COLUMN inpatientinfo.zydoctorcode IS '住院医生代码'
/
COMMENT ON COLUMN inpatientinfo.zydoctorname IS '住院医生名称'
/
COMMENT ON COLUMN inpatientinfo.zyid00 IS 'ZYID00'
/
COMMENT ON COLUMN inpatientinfo.zzdoctorcode IS '主治医生代码'
/
COMMENT ON COLUMN inpatientinfo.zzdoctorname IS '主任医生代码'
/

-- End of DDL Script for Table SD_HOSPITAL.INPATIENTINFO