CRE_v1

Tables (37)

ReschAnesthesiaKindStoreVO (Untitled7)

    ReschBasicStoreVO (Untitled)

    • Key — Primary key — NOT NULL
    • lclTpCd — String — 선택한 지역 코드
    • rschRprvId — String — 승인 ID
    • Field (periods) — Sting
    • period1 — String — 수진기간 From
    • period2 — String — 수진기간 To
    • gender — String — 성별 ( 전체 : A, 남자:M, 여자:F)
    • ageTpCd — String — 수진 당시 나이 (세 :Y, 개월:M, 일:D)
    • age1 — String — 나이 From (0)
    • age2 — String — 나이 To (150)
    • pactTpCd — String — 환자구분 코드 (전체:A, 입원:I, 외래:O, 응급:E)
    • ptTpNm — 환자구분 명(I|입원/:/O|외래/:/E|응급/:/)
    • select — String — 선택한 카테고리 영역 리스트 (진단,검사,수술,약품,오더,수가,CC,서식)
    • condition (Field5)
    • ptBrdyDtSt (Field7)
    • ptBrdyDtEd (Field8)
    • stfNo (Field9)
    • language (Field)
    • queryFlowId (Field2)
    • queryFlowNm (Field3)
    • shareYn (Field4)
    • shareStfNo (Field6)
    • irbNo (Field10)
    • irbMethod (Field11)
    • uploadPatients (Field12)

    ReschChiefComplaintStoreVO (Untitled8)

    • cfcmVocIdy (Key) — Primary key — NOT NULL
    • cfcmVocNm (Field)
    • lclTpCd (Field2)

    ReschConcernPatientStoreVO (Untitled9)

      ReschDiagnosisMedicalStoreVO (Untitled10)

        ReschDiagnosisStoreVO (Untitled5)

        • select1 (Field)
        • name1 (Field2)
        • condition1 (Field3)
        • dgnsDtSt (Field4)
        • dgnsDtEt (Field5)

        ReschDoctorStoreVO (Untitled3)

        • select1 (Key) — Primary key — NOT NULL
        • name1 (Field)
        • Field2

        ReschExamDetailStoreVO (Untitled11)

          ReschExamStoreVO (Untitled6)

            ReschFeeStoreVO (Untitled12)

              ReschFinalResultStoreVO (Untitled13)

                ReschFormDetailStoreVO (Untitled14)

                  ReschFormStoreVO (Untitled15)

                    ReschGroupInfoStoreVO (Untitled16)

                      ReschHospitalStoreVO (Untitled2)

                      • select1 (Key) — Primary key — NOT NULL
                      • name1 (Field2)

                      ReschMedicalStoreVO (Untitled4)

                      • select1 (Key) — Primary key — NOT NULL
                      • name1 (Field)
                      • cobdition1 (Field2)

                      ReschMedicineStoreVO (Untitled17)

                        ReschNursAssessmentStoreVO (Untitled18)

                          ReschNursCircumstanceStoreVO (Untitled19)

                            ReschNursDeptStoreVO (Untitled20)

                              ReschNursDiagnosisStoreVO (Untitled21)

                                ReschNursEavItemsStoreVO (Untitled22)

                                  ReschNursEavStoreVO (Untitled23)

                                    ReschNursPlanStoreVO (Untitled24)

                                      ReschNursStateEavStoreVO (Untitled25)

                                        ReschNursStateStoreVO (Untitled26)

                                          ReschOrderStoreVO (Untitled27)

                                            ReschPathologyStoreVO (Untitled28)

                                              ReschPostOPCheckOutPlaceStoreVO (Untitled29)

                                                ReschRediationDoctorStoreVO (Untitled30)

                                                  ReschRediationTherapyRegionStoreVO (Untitled31)

                                                    ReschRediationTherapyRoomStoreVO (Untitled32)

                                                      ReschRediationTreatmentStoreVO (Untitled33)

                                                        ReschSurgicalDiagnosisStoreVO (Untitled34)

                                                          ReschSurgicalDoctorStoreVO (Untitled35)

                                                            ReschSurgicalMedicalStoreVO (Untitled36)

                                                              ReschSurgicalStoreVO (Untitled37)