<?xml version="1.0" encoding="utf-8" ?>
<!--<sqlMap namespace="CLIP.e-Form.Consent.Dfh" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >-->
<sqlMap namespace="CLIP.e-Form.Consent.Knuh" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
  <alias>
    <typeAlias type="CLIP.eForm.Consent.Entity.UserVO, CLIP.e-Form.Consent.Entity" alias="UserVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.PatientVO, CLIP.e-Form.Consent.Entity" alias="PatientVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.ClnDateForDropdownVO, CLIP.e-Form.Consent.Entity" alias="ClnDateForDropdownVO"/>
    <!--<typeAlias type="CLIP.eForm.Consent.Entity.ConsentSetVO, CLIP.e-Form.Consent.Entity" alias="ConsentSetVO"/>-->
    <typeAlias type="CLIP.eForm.Consent.Entity.ConsentFormListVO, CLIP.e-Form.Consent.Entity" alias="ConsentFormListVO"/>
    
    <typeAlias type="CLIP.eForm.Consent.Entity.PatListVO, CLIP.e-Form.Consent.Entity" alias="PatListVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.DeptListVO, CLIP.e-Form.Consent.Entity" alias="DeptListVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.DocListVO, CLIP.e-Form.Consent.Entity" alias="DocListVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.PatInfoListVO, CLIP.e-Form.Consent.Entity" alias="PatInfoListVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.UserSignImageVO, CLIP.e-Form.Consent.Entity" alias="UserSignImageVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.UnFinishedListVO, CLIP.e-Form.Consent.Entity" alias="UnFinishedListVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.ImageServerPropsVO, CLIP.e-Form.Consent.Entity" alias="ImageServerPropsVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.MobileLoginResult, CLIP.e-Form.Consent.Entity" alias="MobileLoginResult"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.UserLoginDeptList, CLIP.e-Form.Consent.Entity" alias="UserLoginDeptList"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.MobileUserInfo, CLIP.e-Form.Consent.Entity" alias="MobileUserInfo"/>
  </alias>

  <resultMaps>
    <resultMap id="UserMap"           class="UserVO">
      <result property="userId"       column="userId"       nullValue="" />
      <result property="userName"     column="userName"     nullValue="" />
      <result property="userDeptCode" column="userDeptCode" nullValue="" />
      <result property="userDeptName" column="userDeptName" nullValue="" />
      <result property="deptEngAbbr"  column="deptEngAbbr"  nullValue="" />
      <result property="jobKindCd"    column="jobKindCd"    nullValue="" />
      <result property="jobKindNm"    column="jobKindNm"    nullValue="" />
      <result property="instCd"       column="instCd"       nullValue="" />
      <result property="userTelNo"    column="userTelNo"    nullValue="" />
      <result property="ioFlag"       column="ioFlag"       nullValue="" />
    </resultMap>

    <resultMap id="PatientMap" class="PatientVO">
      <result property="ordDeptCd"   column="ordDeptCd"   nullValue="" />
      <result property="deptEngAbbr" column="deptEngAbbr" nullValue="" />
      <result property="ordDeptNm"   column="ordDeptNm"   nullValue="" />
      <result property="pid"         column="pid"         nullValue="" />
      <result property="cretNo"      column="cretNo"      nullValue="" />
      <result property="roomCd"      column="roomCd"      nullValue="" />
      <result property="inDd"        column="inDd"        nullValue="" />
      <result property="dschDd"      column="dschDd"      nullValue="" />
      <result property="ordType"     column="ordType"     nullValue="" />
      <result property="instCd"      column="instCd"      nullValue="" />
      <result property="mainDrId"    column="mainDrId"    nullValue="" />
      <result property="mainDrName"  column="mainDrName"  nullValue="" />
      <result property="erDrNm"      column="erDrNm"      nullValue="" />
      <result property="firstRgstDt" column="firstRgstDt" nullValue="" />
      <result property="sa"          column="sa"          nullValue="" />
      <result property="patientName" column="patientName" nullValue="" />
      <result property="juminNo"     column="juminNo"     nullValue="" />
      <result property="orgJuminNo"  column="orgJuminNo"     nullValue="" />
      <result property="zipCdAddr"   column="zipCdAddr"   nullValue="" />
      <result property="telNum"      column="telNum"      nullValue="" />
      <result property="insuKind"    column="insuKind"    nullValue="" />
      <result property="ward"        column="ward"        nullValue="" />
      <result property="dxCd"        column="dxCd"        nullValue="" />
      <result property="dxNm"        column="dxNm"        nullValue="" />
      <result property="gbn"         column="gbn"         nullValue="" />
      <result property="opDeptCd"    column="opDeptCd"    nullValue="" />
      <result property="opDeptNm"    column="opDeptNm"    nullValue="" />
      <result property="opDrNm"      column="opDrNm"      nullValue="" />
      <result property="opDrId"      column="opDrId"      nullValue="" />
      <result property="opCnfmDd"    column="opCnfmDd"    nullValue="" />
      <result property="perfDrNm"    column="perfDrNm"    nullValue="" />
      <result property="perfDrFlag"  column="perfDrFlag"  nullValue="" />
      <result property="perfDrDept"  column="perfDrDept"  nullValue="" />
      <result property="opDiagNm"    column="opDiagNm"    nullValue="" />
      <result property="opNm"        column="opNm"        nullValue="" />
      <result property="anstDrNm1"   column="anstDrNm1"   nullValue="" />
      <result property="anstDrFlag1" column="anstDrFlag1" nullValue="" />
      <result property="anstDeptNm1" column="anstDeptNm1" nullValue="" />
      <result property="anstDrNm2"   column="anstDrNm2"   nullValue="" />
      <result property="anstDrFlag2" column="anstDrFlag2" nullValue="" />
      <result property="anstDeptNm2" column="anstDeptNm2" nullValue="" />
      <result property="anstDrNm3"   column="anstDrNm3"   nullValue="" />
      <result property="anstDrFlag3" column="anstDrFlag3" nullValue="" />
      <result property="anstDeptNm3" column="anstDeptNm3" nullValue="" />
      <result property="opRsrvNo"    column="opRsrvNo"    nullValue="" />
      <result property="orderNo"     column="orderNo"     />
      <result property="printTime"   column="printTime"   nullValue="" />
      <result property="ocrCd"       column="ocrCd"       nullValue="" />
      <result property="inputId"     column="inputId"     nullValue="" />
      <result property="inputNm"     column="inputNm"     nullValue="" />
      <result property="signImg"     column="signImg"     nullValue="" />
      <result property="bp"          column="bp"          nullValue="" />
      <result property="dm"          column="dm"          nullValue="" />
      <result property="heart"       column="heart"       nullValue="" />
      <result property="kidney"      column="kidney"      nullValue="" />
      <result property="respiration" column="respiration" nullValue="" />
      <result property="hx"          column="hx"          nullValue="" />
      <result property="allergy"     column="allergy"     nullValue="" />
      <result property="drug"        column="drug"        nullValue="" />
      <result property="smoking"     column="smoking"     nullValue="" />
      <result property="idio"        column="idio"        nullValue="" />
      <result property="nacrotics"   column="nacrotics"   nullValue="" />
      <result property="airway"      column="airway"      nullValue="" />
      <result property="hemorrhage"  column="hemorrhage"  nullValue="" />
      <result property="statusEtc"   column="statusEtc"   nullValue="" />
    </resultMap>

    <resultMap id="ClnDateForDropdownMap" class="ClnDateForDropdownVO">
      <result property="ClnDate" column="ClnDate" />
      <result property="ClnFormatDate" column="ClnFormatDate" />
      <result property="VisitType" column="VisitType" />
      <result property="VisitTypeName" column="VisitTypeName" />
      <result property="ClnDeptCode" column="ClnDeptCode" />
      <result property="ClnDeptName" column="ClnDeptName" />
      <result property="DeptCd" column="DeptCd" />
      <result property="CretNo" column="cretno" />
      <result property="orddrid" column="orddrid" />
    </resultMap>

    <!--resultMap id="ConsentSetMap" class="ConsentSetVO">
      <result property="FormRid" column="FORM_RID" />
      <result property="FormGuid" column="FORM_GUID" />
      <result property="FormCd" column="FORM_CD" />
      <result property="FormName" column="FORM_NAME" />
      <result property="FullCategoryName" column="FULL_CATEGORY_NAME" />
      <result property="SetAuth" column="SET_AUTH" />
      <result property="PrntCnt" column="PRNTCNT"/>
      <result property="PrintOnly" column="PRINT_ONLY"/>
      <result property="OcrTagYN" column="OCRTAGPRNTYN"/>
      <result property="FormPrintName" column="formprntnm"/>
      <result property="OpDiagName" column="opdiagnm"/>
      <result property="OpName" column="opnm"/>
      <result property="UserDrFlag" column="userdrflag"/>
      <result property="LinkFormCd" column="lnkformcd"/>
    </resultMap -->

    <resultMap id="ConsentFormMap" class="ConsentFormListVO">
      <result property="consentMstRid"    column="CONSENT_MST_RID" />
      <result property="createUserId"     column="CREATE_USER_ID"       nullValue="" />
      <result property="createUserName"   column="CREATE_USER_NAME"     nullValue="" />
      <result property="modifyUserId"     column="MODIFY_USER_ID"       nullValue="" />
      <result property="modifyUserName"   column="MODIFY_USER_NAME"     nullValue="" />
      <result property="createDatetime"   column="CREATE_DATETIME"      nullValue="" />
      <result property="ocrTag"           column="OCR_TAG"              nullValue="" />
      <result property="pid"              column="PID"                  nullValue="" />
      <result property="inDd"             column="INDD"                 nullValue="" />
      <result property="ordType"          column="ORD_TYPE"             nullValue="" />
      <result property="ordDeptCd"        column="ORD_DEPT_CD"          nullValue="" />
      <result property="cretNo"           column="CRET_NO"                           />
      <result property="opRsrvNo"         column="OPRSRVNO"             nullValue="" />
      <result property="patientName"      column="PATIENT_NAME"         nullValue="" />
      <result property="consentState"     column="CONSENT_STATE"        nullValue="" />
      <result property="consentStateEng"  column="CONSENT_STATE_ENG"    nullValue="" />
      <result property="formCd"           column="FORM_CD"              nullValue="" />
      <result property="formGuid"         column="FORM_GUID"            nullValue="" />
      <result property="formName"         column="FORM_NAME"            nullValue="" />
      <result property="formRid"          column="FORM_RID"                          />
      <result property="printOnly"        column="PRNT_ONLY"            nullValue="" />
      <result property="printCnt"         column="PRINT_CNT"                         />
      <result property="ocrTagPrntYn"     column="OCR_TAG_PRNT_YN"      nullValue="" />
      <result property="formPrntNm"       column="FORM_PRNT_NM"         nullValue="" />
      <result property="certUseYn"        column="CERT_USE_YN"          nullValue="" />
      <result property="opDiagNm"         column="OP_DIAG_NM"           nullValue="" />
      <result property="opNm"             column="OP_NM"                nullValue="" />
      <result property="userDrFlag"       column="USERDRFLAG"           nullValue="" />
      <result property="linkFormCd"       column="LNKFORMCD"            nullValue="" />
      <result property="jinjeongCd"       column="JINJEONGCD"           nullValue="" />
      <result property="DrOnly"           column="DRONLY"               nullValue="" />
    </resultMap>

    <resultMap id="PatListMap" class="PatListVO">
      <result property="pid"       column="pid"       nullValue="" />
      <result property="inDd"      column="inDd"      nullValue="" />
      <result property="cretNo"    column="cretNo" />
      <result property="instCd"    column="instCd"    nullValue="" />
      <result property="ordType"   column="ordType"    nullValue="" />
      <result property="hngNm"     column="hngNm"     nullValue="" />
      <result property="ordDeptCd" column="ordDeptCd" nullValue="" />
      <result property="doctorId"  column="doctorId"  nullValue="" />
      <result property="sa"        column="sa"        nullValue="" />
      <result property="deptNm"    column="deptNm"    nullValue="" />
      <result property="doctorNm"  column="doctorNm"  nullValue="" />
      <result property="roomCd"    column="roomCd"    nullValue="" />
      <result property="opRoomNm"  column="opRoomNm"  nullValue="" />
      <result property="oprsRvNo"  column="oprsRvNo"  nullValue="" />
    </resultMap>

    <resultMap id="DeptListMap" class="DeptListVO">
      <result property="deptCd" column="deptCd" nullValue="" />
      <result property="deptNm" column="deptNm" nullValue="" />
    </resultMap>

    <resultMap id="DocListMap" class="DocListVO">
      <result property="doctorId"  column="doctorId" />
      <result property="doctorNm" column="doctorNm" />
      <result property="doctorKind" column="doctorKind" />
      <result property="drKind" column="drKind" />
    </resultMap>

    <resultMap id="PatInfoListMap" class="PatInfoListVO">
      <result property="pid"  column="pid" />
      <result property="hngnm" column="hngnm" />
      <result property="rrgstno1" column="rrgstno1" />
      <result property="rrgstno2" column="rrgstno2" />
      <result property="age" column="age" />
      <result property="mpphontel" column="mpphontel" />
      <result property="addr" column="addr" />
      <result property="lastorddd" column="lastorddd" />
      <result property="lastorddept" column="lastorddept" />
      <result property="lastinsukind" column="lastinsukind" />
    </resultMap>

    <resultMap id="UserSignImageMap" class="UserSignImageVO">
      <result property="SignImage"  column="SIGNDATA" />
    </resultMap>

    <resultMap id="UnFinishedListMap" class="UnFinishedListVO">
      <result property="patientCode"  column="patientCode" />
      <result property="formcd" column="formcd" />
      <result property="consentName" column="consentName" />
      <result property="hngnm" column="hngnm" />
      <result property="orderdate" column="orderdate" />
      <result property="printonly" column="printonly" />
      <result property="certtarget" column="certtarget" />
      <result property="consentState" column="consentState" />
      <result property="consentMstRid" column="consentMstRid" />
      <result property="orddd" column="orddd" />
      <result property="visitType" column="visitType" />
      <result property="orddeptcd" column="orddeptcd" />
      <result property="orderno" column="orderno" />
      <result property="ordercd" column="ordercd" />
      <result property="ocrNumber" column="ocrNumber" />
      <result property="cretno" column="cretno" />
      <result property="createusername" column="createusername" />
      <result property="formrid" column="formrid" />
      <result property="formguid" column="formguid" />
    </resultMap>

    <resultMap id="ImageServerPropsMap" class="ImageServerPropsVO">
      <result property="ipaddr" column="IPADDRESS"/>
      <result property="localpath" column="LOCALPATH"/>
      <result property="active" column="ACTIVE"/>
      <result property="username" column="CIFSUSER"/>
      <result property="userpasswd" column="CIFSPASS"/>
    </resultMap>
    <resultMap id="MobileLoginResultMap" class="MobileLoginResult">
      <result property="usernm" column="usernm"/>
      <result property="pwd" column="pwd_sha256"/>
      <result property="userid" column="userid"/>
    </resultMap>
    <resultMap id="UserLoginDeptListResultMap" class="UserLoginDeptList">
      <result property="dutplceInstCd" column="dutplceInstCd" nullValue="" />
      <result property="dutplceCd" column="dutplceCd" nullValue="" />
      <result property="deptHngNm" column="deptHngNm" nullValue="" />
      <!--<result property="deptnm" column="deptnm"/>-->
      <result property="jobKindCd" column="jobKindCd" nullValue="" />
      <result property="jobKindNm" column="jobKindNm" nullValue="" />
      <result property="sortNo" column="sortNo"/>
      <result property="indexPage" column="mobile" nullValue="" />
      <result property="userId" column="userId" nullValue="" />
      <result property="userName" column="userName" nullValue="" />
      <result property="drKind" column="drKind" nullValue="" />
    </resultMap>
    <resultMap id="MobileUserInfoResultMap" class="MobileUserInfo">
      <result property="userid" column="userid"/>
      <result property="usernm" column="usernm"/>
      <result property="dutplcecd" column="dutplcecd"/>
      <result property="deptengnm" column="deptengnm"/>
      <result property="dutplceinstcd" column="dutplceinstcd"/>
      <result property="dutplceinstnm" column="dutplceinstnm"/>
      <result property="jobkindcd" column="jobkindcd"/>
      <result property="jobkindnm" column="jobkindnm"/>
    </resultMap>
  </resultMaps>
</sqlMap>