ALTER TABLE COMTCADMINISTCODE COMMENT = '행정코드'; ALTER TABLE COMTCADMINISTCODERECPTNLOG COMMENT = '행정코드수신로그'; ALTER TABLE COMTCCMMNCLCODE COMMENT = '공통분류코드'; ALTER TABLE COMTCCMMNCODE COMMENT = '공통코드'; ALTER TABLE COMTCCMMNDETAILCODE COMMENT = '공통상세코드'; ALTER TABLE COMTCZIP COMMENT = '우편번호'; ALTER TABLE COMTECOPSEQ COMMENT = 'COMTECOPSEQ'; ALTER TABLE COMTHCONFMHISTORY COMMENT = '승인이력'; ALTER TABLE COMTHDBMNTRNGLOGINFO COMMENT = 'DB서비스모니터링로그정보'; ALTER TABLE COMTHEMAILDSPTCHMANAGE COMMENT = '메일발신관리'; ALTER TABLE COMTHEMPLYRINFOCHANGEDTLS COMMENT = '업무사용자정보변경내역'; ALTER TABLE COMTHHTTPMONLOGINFO COMMENT = 'HTTP서비스모니터링로그정보'; ALTER TABLE COMTHPROGRMCHANGEDTLS COMMENT = '프로그램변경내역'; ALTER TABLE COMTHSYSHIST COMMENT = '시스템이력'; ALTER TABLE COMTHTRSMRCVMNTRNGLOGINFO COMMENT = '송수신모니터링로그정보'; ALTER TABLE COMTNADBK COMMENT = '주소록'; ALTER TABLE COMTNADBKMANAGE COMMENT = '주소록관리'; ALTER TABLE COMTNADMINISTRATIONWORD COMMENT = '행정용어사전관리'; ALTER TABLE COMTNANNVRSRYMANAGE COMMENT = '기념일정보'; ALTER TABLE COMTNANSWER COMMENT = '댓글'; ALTER TABLE COMTNAUTHORGROUPINFO COMMENT = '권한그룹정보'; ALTER TABLE COMTNAUTHORINFO COMMENT = '권한정보'; ALTER TABLE COMTNAUTHORROLERELATE COMMENT = '권한롤관계'; ALTER TABLE COMTNBACKUPOPERT COMMENT = '백업작업'; ALTER TABLE COMTNBACKUPRESULT COMMENT = '백업결과'; ALTER TABLE COMTNBACKUPSCHDULDFK COMMENT = '백업스케줄요일'; ALTER TABLE COMTNBANNER COMMENT = '배너'; ALTER TABLE COMTNBATCHOPERT COMMENT = '배치작업'; ALTER TABLE COMTNBATCHRESULT COMMENT = '배치결과'; ALTER TABLE COMTNBATCHSCHDUL COMMENT = '배치스케줄'; ALTER TABLE COMTNBATCHSCHDULDFK COMMENT = '배치스케줄요일'; ALTER TABLE COMTNBBS COMMENT = '게시판'; ALTER TABLE COMTNBBSMASTER COMMENT = '게시판마스터'; ALTER TABLE COMTNBBSMASTEROPTN COMMENT = '게시판마스터옵션'; ALTER TABLE COMTNBBSUSE COMMENT = '게시판활용'; ALTER TABLE COMTNBKMKMENUMANAGERESULT COMMENT = '바로가기 메뉴 등록'; ALTER TABLE COMTNBNDTCECKMANAGE COMMENT = '당직체크관리정보'; ALTER TABLE COMTNBNDTDIARY COMMENT = '당직관리'; ALTER TABLE COMTNBNDTMANAGE COMMENT = '당직관리정보'; ALTER TABLE COMTNCLUB COMMENT = '동호회속성'; ALTER TABLE COMTNCLUBUSER COMMENT = '동호회사용자'; ALTER TABLE COMTNCMMNTY COMMENT = '커뮤니티 속성'; ALTER TABLE COMTNCMMNTYUSER COMMENT = '커뮤니티사용자'; ALTER TABLE COMTNCNSLTLIST COMMENT = '상담내역'; ALTER TABLE COMTNCNTCINSTT COMMENT = '연계기관'; ALTER TABLE COMTNCNTCMESSAGE COMMENT = '연계메시지'; ALTER TABLE COMTNCNTCMESSAGEITEM COMMENT = '연계메시지항목'; ALTER TABLE COMTNCNTCSERVICE COMMENT = '연계서비스'; ALTER TABLE COMTNCNTCSYSTEM COMMENT = '연계시스템'; ALTER TABLE COMTNCNTNTSLIST COMMENT = '컨텐츠목록'; ALTER TABLE COMTNCOMMENT COMMENT = '댓글'; ALTER TABLE COMTNCOMMUTE COMMENT = '출퇴근관리'; ALTER TABLE COMTNCPYRHTINFO COMMENT = '저작권정보'; ALTER TABLE COMTNCTSNNMANAGE COMMENT = '경조사정보'; ALTER TABLE COMTNDAMCALRES COMMENT = '지식정보요청제공'; ALTER TABLE COMTNDAMKNOIFM COMMENT = '지식정보'; ALTER TABLE COMTNDAMMAPKNO COMMENT = '지식맵(유형별)'; ALTER TABLE COMTNDAMMAPTEAM COMMENT = '지식맵(조직별)'; ALTER TABLE COMTNDAMPRO COMMENT = '지식전문가'; ALTER TABLE COMTNDBMNTRNG COMMENT = 'DB서비스모니터링'; ALTER TABLE COMTNDEPTJOB COMMENT = '부서업무정보'; ALTER TABLE COMTNDEPTJOBBX COMMENT = '부서업무함'; ALTER TABLE COMTNDIARYINFO COMMENT = '일지정보'; ALTER TABLE COMTNDTAUSESTATS COMMENT = '자료이용현황통계'; ALTER TABLE COMTNEMPLYRINFO COMMENT = '업무사용자정보'; ALTER TABLE COMTNEMPLYRSCRTYESTBS COMMENT = '사용자보안설정'; ALTER TABLE COMTNENTRPRSMBER COMMENT = '기업회원'; ALTER TABLE COMTNEVENTATDRN COMMENT = '행사참석자'; ALTER TABLE COMTNEVENTINFO COMMENT = '행사/이벤트정보'; ALTER TABLE COMTNEVENTMANAGE COMMENT = '행사관리'; ALTER TABLE COMTNEXTRLHRINFO COMMENT = '외부인사정보'; ALTER TABLE COMTNFAQINFO COMMENT = 'FAQ정보'; ALTER TABLE COMTNFILE COMMENT = '파일속성'; ALTER TABLE COMTNFILEDETAIL COMMENT = '파일상세정보'; ALTER TABLE COMTNFILESYSMNTRNG COMMENT = '파일시스템모니터링'; ALTER TABLE COMTNFILESYSMNTRNGLOGINFO COMMENT = '파일시스템모니터링로그정보'; ALTER TABLE COMTNFXTRSMANAGE COMMENT = 'COMTNFXTRSMANAGE'; ALTER TABLE COMTNGNRLMBER COMMENT = '일반회원'; ALTER TABLE COMTNHPCMINFO COMMENT = '도움말정보'; ALTER TABLE COMTNHTTPMON COMMENT = 'HTTP서비스모니터링'; ALTER TABLE COMTNINDVDLINFOPOLICY COMMENT = '개인정보정책확인'; ALTER TABLE COMTNINDVDLPGECNTNTS COMMENT = '마이페이지 컨텐츠'; ALTER TABLE COMTNINDVDLPGEESTBS COMMENT = '마이페이지 설정'; ALTER TABLE COMTNINDVDLYRYCMANAGE COMMENT = '개인별연차관리'; ALTER TABLE COMTNINFRMLSANCTN COMMENT = '약식결재정보'; ALTER TABLE COMTNINSTTCODE COMMENT = '기관코드'; ALTER TABLE COMTNINSTTCODERECPTNLOG COMMENT = '기관코드수신로그'; ALTER TABLE COMTNINTNETSVC COMMENT = '인터넷서비스'; ALTER TABLE COMTNLEADERSCHDUL COMMENT = '간부일정정보'; ALTER TABLE COMTNLEADERSCHDULDE COMMENT = '간부일정관리'; ALTER TABLE COMTNLEADERSTTUS COMMENT = '간부상태정보'; ALTER TABLE COMTNLOGINLOG COMMENT = '접속로그'; ALTER TABLE COMTNLOGINPOLICY COMMENT = '로그인정책'; ALTER TABLE COMTNLOGINSCRINIMAGE COMMENT = '로그인화면이미지'; ALTER TABLE COMTNMAINIMAGE COMMENT = '메인이미지'; ALTER TABLE COMTNMEMOREPRT COMMENT = '메모보고관리'; ALTER TABLE COMTNMEMOTODO COMMENT = '메모할일정보'; ALTER TABLE COMTNMENUCREATDTLS COMMENT = '메뉴생성내역'; ALTER TABLE COMTNMENUINFO COMMENT = '메뉴정보'; ALTER TABLE COMTNMTGINFO COMMENT = '회의정보'; ALTER TABLE COMTNMTGPLACEFXTRS COMMENT = '회의실비품'; ALTER TABLE COMTNMTGPLACEMANAGE COMMENT = '회의실관리'; ALTER TABLE COMTNMTGPLACERESVE COMMENT = '회의실예약정보'; ALTER TABLE COMTNNCRD COMMENT = '명함정보속성'; ALTER TABLE COMTNNCRDUSER COMMENT = '명함사용자속성'; ALTER TABLE COMTNNEWSINFO COMMENT = '뉴스정보'; ALTER TABLE COMTNNOTE COMMENT = '쪽지관리'; ALTER TABLE COMTNNOTERECPTN COMMENT = '받은쪽지함관리'; ALTER TABLE COMTNNOTETRNSMIT COMMENT = '보낸쪽지함관리'; ALTER TABLE COMTNNTFCINFO COMMENT = '정보알림'; ALTER TABLE COMTNNTTSTATS COMMENT = '게시물통계'; ALTER TABLE COMTNNTWRKINFO COMMENT = '네트워크정보'; ALTER TABLE COMTNNTWRKSVCMNTRNG COMMENT = '네트워크서비스모니터링'; ALTER TABLE COMTNNTWRKSVCMNTRNGLOGINFO COMMENT = '네트워크서비스모니터링로그정보'; ALTER TABLE COMTNONLINEMANUAL COMMENT = '온라인메뉴얼'; ALTER TABLE COMTNONLINEPOLLIEM COMMENT = '온라인POLL항목'; ALTER TABLE COMTNONLINEPOLLMANAGE COMMENT = '온라인POLL관리'; ALTER TABLE COMTNONLINEPOLLRESULT COMMENT = '온라인POLL결과'; ALTER TABLE COMTNORGNZTINFO COMMENT = '조직정보'; ALTER TABLE COMTNPOPUPMANAGE COMMENT = '팝업 정보 관리'; ALTER TABLE COMTNPRIVACYLOG COMMENT = '개인정보조회 로그'; ALTER TABLE COMTNPROCESSMON COMMENT = '프로세스모니터링'; ALTER TABLE COMTNPROCESSMONLOGINFO COMMENT = '프로세스모니터링로그정보'; ALTER TABLE COMTNPROGRMLIST COMMENT = '프로그램목록'; ALTER TABLE COMTNPROXYINFO COMMENT = '프록시정보'; ALTER TABLE COMTNPROXYLOGINFO COMMENT = '프록시로그정보'; ALTER TABLE COMTNQAINFO COMMENT = 'QA정보'; ALTER TABLE COMTNQESTNRINFO COMMENT = '설문지정보'; ALTER TABLE COMTNQUSTNRIEM COMMENT = '설문항목'; ALTER TABLE COMTNQUSTNRQESITM COMMENT = '설문문항'; ALTER TABLE COMTNQUSTNRRESPONDINFO COMMENT = '설문응답자정보'; ALTER TABLE COMTNQUSTNRRSPNSRESULT COMMENT = '설문응답결과'; ALTER TABLE COMTNQUSTNRTMPLAT COMMENT = '설문템플릿'; ALTER TABLE COMTNRECENTSRCHWRD COMMENT = '최근검색어'; ALTER TABLE COMTNRECENTSRCHWRDMANAGE COMMENT = '최근검색어관리'; ALTER TABLE COMTNRECOMENDSITEINFO COMMENT = '추천사이트정보'; ALTER TABLE COMTNREPRTSTATS COMMENT = '보고서통계'; ALTER TABLE COMTNRESTDE COMMENT = '휴일관리'; ALTER TABLE COMTNROLEINFO COMMENT = '롤정보'; ALTER TABLE COMTNROLES_HIERARCHY COMMENT = '롤 계층구조'; ALTER TABLE COMTNROUGHMAP COMMENT = '약도관리'; ALTER TABLE COMTNRSS COMMENT = 'RSS관리'; ALTER TABLE COMTNRWARDMANAGE COMMENT = '포상관리'; ALTER TABLE COMTNSCHDULINFO COMMENT = '일정정보'; ALTER TABLE COMTNSCRAP COMMENT = '스크랩'; ALTER TABLE COMTNSERVEREQPMNINFO COMMENT = '서버장비정보'; ALTER TABLE COMTNSERVEREQPMNRELATE COMMENT = '서버장비관계'; ALTER TABLE COMTNSERVERINFO COMMENT = '서버정보'; ALTER TABLE COMTNSERVERRESRCELOGINFO COMMENT = '서버자원로그정보'; ALTER TABLE COMTNSITELIST COMMENT = '사이트목록'; ALTER TABLE COMTNSITEMAP COMMENT = '사이트맵'; ALTER TABLE COMTNSMS COMMENT = '문자메시지'; ALTER TABLE COMTNSMSRECPTN COMMENT = '문자메시지수신'; ALTER TABLE COMTNSTPLATINFO COMMENT = '약관정보'; ALTER TABLE COMTNSTSFDG COMMENT = '만족도'; ALTER TABLE COMTNSYNCHRNSERVERINFO COMMENT = '동기화서버정보'; ALTER TABLE COMTNSYSLOG COMMENT = '시스템로그'; ALTER TABLE COMTNSYSTEMCNTC COMMENT = '시스템연계'; ALTER TABLE COMTNTMPLATINFO COMMENT = '템플릿'; ALTER TABLE COMTNTROBLINFO COMMENT = '장애정보'; ALTER TABLE COMTNTRSMRCVLOG COMMENT = '송수신로그'; ALTER TABLE COMTNTRSMRCVMNTRNG COMMENT = '송수신모니터링'; ALTER TABLE COMTNTWITTER COMMENT = '트위터계정관리'; ALTER TABLE COMTNUNITYLINK COMMENT = '통합링크'; ALTER TABLE COMTNUSERABSNCE COMMENT = '사용자부재'; ALTER TABLE COMTNUSERLOG COMMENT = '사용자로그'; ALTER TABLE COMTNVCATNMANAGE COMMENT = '휴가관리'; ALTER TABLE COMTNWEBLOG COMMENT = '웹로그'; ALTER TABLE COMTNWIKIBKMK COMMENT = 'Wiki북마크'; ALTER TABLE COMTNWIKMNTHNGREPRT COMMENT = '주간/월간보고정보'; ALTER TABLE COMTNWORDDICARYINFO COMMENT = '용어사전정보'; ALTER TABLE COMTRDNMADRZIP COMMENT = '도로명주소'; ALTER TABLE COMTSBBSSUMMARY COMMENT = '게시물통계요약'; ALTER TABLE COMTSSYSLOGSUMMARY COMMENT = '시스템로그요약'; ALTER TABLE COMTSTRSMRCVLOGSUMMARY COMMENT = '송수신로그요약'; ALTER TABLE COMTSUSERSUMMARY COMMENT = '사용자통계요약'; ALTER TABLE COMTSWEBLOGSUMMARY COMMENT = '웹로그 요약'; ALTER TABLE IDS COMMENT = 'IDS'; ALTER TABLE IMGTEMP COMMENT = 'IMGTEMP'; ALTER TABLE J_ATTACHFILE COMMENT = 'Jfile업로드'; ALTER TABLE COMTNBLOG COMMENT = '블로그게시판'; ALTER TABLE COMTNBLOGUSER COMMENT = '블로그사용자'; ALTER TABLE `COMTCADMINISTCODE` CHANGE `ABL_DE` `ABL_DE` char(20) DEFAULT NULL COMMENT '폐지일' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `ADMINIST_ZONE_CODE` `ADMINIST_ZONE_CODE` varchar(10) NOT NULL COMMENT '행정구역코드' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `ADMINIST_ZONE_NM` `ADMINIST_ZONE_NM` varchar(60) DEFAULT NULL COMMENT '행정구역명' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `ADMINIST_ZONE_SE` `ADMINIST_ZONE_SE` char(1) NOT NULL COMMENT '행정구역구분' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `CREAT_DE` `CREAT_DE` char(20) DEFAULT NULL COMMENT '생성일' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `UPPER_ADMINIST_ZONE_CODE` `UPPER_ADMINIST_ZONE_CODE` varchar(10) DEFAULT NULL COMMENT '상위행정구역코드' ; ALTER TABLE `COMTCADMINISTCODE` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `ABL_DE` `ABL_DE` char(20) DEFAULT NULL COMMENT '폐지일' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `ABL_ENNC` `ABL_ENNC` char(1) DEFAULT NULL COMMENT '폐지유무' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `ADMINIST_ZONE_CODE` `ADMINIST_ZONE_CODE` varchar(10) NOT NULL COMMENT '행정구역코드' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `ADMINIST_ZONE_NM` `ADMINIST_ZONE_NM` varchar(60) DEFAULT NULL COMMENT '행정구역명' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `ADMINIST_ZONE_SE` `ADMINIST_ZONE_SE` char(1) NOT NULL COMMENT '행정구역구분' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `CHANGE_SE_CODE` `CHANGE_SE_CODE` varchar(2) DEFAULT NULL COMMENT '변경구분코드' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `CREAT_DE` `CREAT_DE` char(20) DEFAULT NULL COMMENT '생성일' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `CTPRVN_CODE` `CTPRVN_CODE` varchar(2) DEFAULT NULL COMMENT '시도코드' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `EMD_CODE` `EMD_CODE` varchar(3) DEFAULT NULL COMMENT '읍면동코드' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `LI_CODE` `LI_CODE` varchar(2) DEFAULT NULL COMMENT '리코드' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `LOWEST_ADMINIST_ZONE_NM` `LOWEST_ADMINIST_ZONE_NM` varchar(60) DEFAULT NULL COMMENT '최하위행정구역명' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(20) NOT NULL COMMENT '발생일' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `OPERT_SN` `OPERT_SN` decimal(10,0) NOT NULL COMMENT '작업일련번호' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `PROCESS_SE` `PROCESS_SE` varchar(2) DEFAULT NULL COMMENT '처리구분' ; ALTER TABLE `COMTCADMINISTCODERECPTNLOG` CHANGE `SIGNGU_CODE` `SIGNGU_CODE` varchar(3) DEFAULT NULL COMMENT '시군구코드' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `CL_CODE_DC` `CL_CODE_DC` varchar(200) DEFAULT NULL COMMENT '분류코드설명' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `CL_CODE_NM` `CL_CODE_NM` varchar(60) DEFAULT NULL COMMENT '분류코드명' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `CL_CODE` `CL_CODE` char(3) NOT NULL COMMENT '분류코드' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTCCMMNCLCODE` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `CL_CODE` `CL_CODE` char(3) COMMENT '분류코드' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `CODE_ID_DC` `CODE_ID_DC` varchar(200) DEFAULT NULL COMMENT '코드ID설명' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `CODE_ID_NM` `CODE_ID_NM` varchar(60) DEFAULT NULL COMMENT '코드ID명' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `CODE_ID` `CODE_ID` varchar(6) NOT NULL COMMENT '코드ID' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTCCMMNCODE` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `CODE_DC` `CODE_DC` varchar(200) DEFAULT NULL COMMENT '코드설명' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `CODE_ID` `CODE_ID` varchar(6) NOT NULL COMMENT '코드ID' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `CODE_NM` `CODE_NM` varchar(60) DEFAULT NULL COMMENT '코드명' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `CODE` `CODE` varchar(15) NOT NULL COMMENT '코드' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTCCMMNDETAILCODE` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTCZIP` CHANGE `CTPRVN_NM` `CTPRVN_NM` varchar(20) DEFAULT NULL COMMENT '시도명' ; ALTER TABLE `COMTCZIP` CHANGE `EMD_NM` `EMD_NM` varchar(60) DEFAULT NULL COMMENT '읍면동명' ; ALTER TABLE `COMTCZIP` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTCZIP` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTCZIP` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTCZIP` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTCZIP` CHANGE `LI_BULD_NM` `LI_BULD_NM` varchar(60) DEFAULT NULL COMMENT '리건물명' ; ALTER TABLE `COMTCZIP` CHANGE `LNBR_DONG_HO` `LNBR_DONG_HO` varchar(20) DEFAULT NULL COMMENT '번지동호' ; ALTER TABLE `COMTCZIP` CHANGE `SIGNGU_NM` `SIGNGU_NM` varchar(20) DEFAULT NULL COMMENT '시군구명' ; ALTER TABLE `COMTCZIP` CHANGE `SN` `SN` decimal(10,0) NOT NULL DEFAULT '0' COMMENT '일련번호' ; ALTER TABLE `COMTCZIP` CHANGE `ZIP` `ZIP` varchar(6) NOT NULL COMMENT '우편번호' ; ALTER TABLE `COMTECOPSEQ` CHANGE `NEXT_ID` `NEXT_ID` decimal(30,0) DEFAULT NULL COMMENT '다음아이디' ; ALTER TABLE `COMTECOPSEQ` CHANGE `TABLE_NAME` `TABLE_NAME` varchar(20) NOT NULL DEFAULT '' COMMENT '테이블명' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `CONFM_DE` `CONFM_DE` char(20) DEFAULT NULL COMMENT '승인일' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `CONFM_NO` `CONFM_NO` decimal(8,0) NOT NULL COMMENT '승인번호' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `CONFM_RQESTER_ID` `CONFM_RQESTER_ID` varchar(20) NOT NULL COMMENT '승인요청자ID' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `CONFM_STTUS_CODE` `CONFM_STTUS_CODE` char(4) NOT NULL COMMENT '승인상태코드' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `CONFM_TY_CODE` `CONFM_TY_CODE` char(4) NOT NULL COMMENT '승인유형코드' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `CONFMER_ID` `CONFMER_ID` varchar(20) DEFAULT NULL COMMENT '승인자ID' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `OPERT_ID` `OPERT_ID` varchar(20) DEFAULT NULL COMMENT '작업ID' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `OPERT_TY_CODE` `OPERT_TY_CODE` char(4) DEFAULT NULL COMMENT '작업유형코드' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `TRGET_JOB_ID` `TRGET_JOB_ID` char(20) DEFAULT NULL COMMENT '대상업무ID' ; ALTER TABLE `COMTHCONFMHISTORY` CHANGE `TRGET_JOB_TY_CODE` `TRGET_JOB_TY_CODE` char(3) DEFAULT NULL COMMENT '대상업무유형코드' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `CECK_SQL` `CECK_SQL` varchar(250) DEFAULT NULL COMMENT '체크SQL' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `DATA_SOURC_NM` `DATA_SOURC_NM` varchar(60) NOT NULL COMMENT '데이터소스명' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `DBMS_KND` `DBMS_KND` varchar(2) DEFAULT NULL COMMENT 'DBMS종류' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL DEFAULT '' COMMENT '로그ID' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `LOG_INFO` `LOG_INFO` varchar(2000) DEFAULT NULL COMMENT '로그정보' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTHDBMNTRNGLOGINFO` CHANGE `SERVER_NM` `SERVER_NM` varchar(60) DEFAULT NULL COMMENT '서버명' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) COMMENT '첨부파일ID' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `DSPTCH_DT` `DSPTCH_DT` char(20) NOT NULL COMMENT '발신일시' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `EMAIL_CN` `EMAIL_CN` mediumtext DEFAULT NULL COMMENT '이메일내용' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `MSSAGE_ID` `MSSAGE_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '메시지ID' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `RCVER` `RCVER` varchar(50) NOT NULL COMMENT '수신자' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `SJ` `SJ` varchar(60) NOT NULL COMMENT '제목' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `SNDNG_RESULT_CODE` `SNDNG_RESULT_CODE` char(1) DEFAULT NULL COMMENT '발송결과코드' ; ALTER TABLE `COMTHEMAILDSPTCHMANAGE` CHANGE `SNDR` `SNDR` varchar(50) NOT NULL COMMENT '발신자' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `AREA_NO` `AREA_NO` varchar(4) DEFAULT NULL COMMENT '지역번호' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `BRTHDY` `BRTHDY` char(20) DEFAULT NULL COMMENT '생일' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `CHANGE_DE` `CHANGE_DE` char(20) NOT NULL DEFAULT '' COMMENT '변경일' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `DETAIL_ADRES` `DETAIL_ADRES` varchar(100) DEFAULT NULL COMMENT '상세주소' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `EMAIL_ADRES` `EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '이메일주소' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `EMPL_NO` `EMPL_NO` varchar(20) DEFAULT NULL COMMENT '사원번호' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `EMPLYR_STTUS_CODE` `EMPLYR_STTUS_CODE` char(1) DEFAULT NULL COMMENT '사용자상태코드' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `ESNTL_ID` `ESNTL_ID` char(20) DEFAULT NULL COMMENT '고유ID' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `FXNUM` `FXNUM` varchar(20) DEFAULT NULL COMMENT '팩스번호' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `GROUP_ID` `GROUP_ID` char(20) DEFAULT NULL COMMENT '그룹ID' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `HOUSE_ADRES` `HOUSE_ADRES` varchar(100) DEFAULT NULL COMMENT '주택주소' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `HOUSE_END_TELNO` `HOUSE_END_TELNO` varchar(4) DEFAULT NULL COMMENT '주택끝전화번호' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `HOUSE_MIDDLE_TELNO` `HOUSE_MIDDLE_TELNO` varchar(4) DEFAULT NULL COMMENT '주택중간전화번호' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `MBTLNUM` `MBTLNUM` varchar(20) DEFAULT NULL COMMENT '이동전화번호' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `OFFM_TELNO` `OFFM_TELNO` varchar(20) DEFAULT NULL COMMENT '사무실전화번호' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `ORGNZT_ID` `ORGNZT_ID` char(20) DEFAULT NULL COMMENT '조직ID' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `PSTINST_CODE` `PSTINST_CODE` char(8) DEFAULT NULL COMMENT '소속기관코드' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `SEXDSTN_CODE` `SEXDSTN_CODE` char(1) DEFAULT NULL COMMENT '성별코드' ; ALTER TABLE `COMTHEMPLYRINFOCHANGEDTLS` CHANGE `ZIP` `ZIP` varchar(6) DEFAULT NULL COMMENT '우편번호' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `HTTP_STTUS_CODE` `HTTP_STTUS_CODE` varchar(3) DEFAULT NULL COMMENT 'HTTP상태코드' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL DEFAULT '' COMMENT '로그ID' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `LOG_INFO` `LOG_INFO` varchar(2000) DEFAULT NULL COMMENT '로그정보' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `SITE_URL` `SITE_URL` varchar(100) DEFAULT NULL COMMENT '사이트URL' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `SYS_ID` `SYS_ID` varchar(20) NOT NULL COMMENT '시스템ID' ; ALTER TABLE `COMTHHTTPMONLOGINFO` CHANGE `WEBSVC_KND` `WEBSVC_KND` varchar(10) DEFAULT NULL COMMENT '웹서비스종류' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `CHANGE_REQUST_CN` `CHANGE_REQUST_CN` varchar(1000) DEFAULT NULL COMMENT '변경요청내용' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `OPETR_ID` `OPETR_ID` varchar(20) DEFAULT NULL COMMENT '처리자ID' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `PROCESS_DE` `PROCESS_DE` char(20) DEFAULT NULL COMMENT '처리일' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `PROCESS_STTUS_CODE` `PROCESS_STTUS_CODE` varchar(15) NOT NULL COMMENT '처리상태코드' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `PROGRM_FILE_NM` `PROGRM_FILE_NM` varchar(60) NOT NULL COMMENT '프로그램파일명' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `REQUST_NO` `REQUST_NO` decimal(10,0) NOT NULL DEFAULT '0' COMMENT '요청번호' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `REQUST_PROCESS_CN` `REQUST_PROCESS_CN` mediumtext DEFAULT NULL COMMENT '요청처리내용' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `REQUST_SJ` `REQUST_SJ` varchar(60) NOT NULL COMMENT '요청제목' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `RQESTDE` `RQESTDE` char(20) DEFAULT NULL COMMENT '요청일' ; ALTER TABLE `COMTHPROGRMCHANGEDTLS` CHANGE `RQESTER_ID` `RQESTER_ID` varchar(20) NOT NULL COMMENT '요청자ID' ; ALTER TABLE `COMTHSYSHIST` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTHSYSHIST` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTHSYSHIST` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTHSYSHIST` CHANGE `HIST_CN` `HIST_CN` varchar(2500) NOT NULL COMMENT '이력내용' ; ALTER TABLE `COMTHSYSHIST` CHANGE `HIST_ID` `HIST_ID` char(20) NOT NULL COMMENT '이력ID' ; ALTER TABLE `COMTHSYSHIST` CHANGE `HIST_SE_CODE` `HIST_SE_CODE` char(6) NOT NULL COMMENT '이력구분코드' ; ALTER TABLE `COMTHSYSHIST` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTHSYSHIST` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTHSYSHIST` CHANGE `SYS_NM` `SYS_NM` varchar(255) NOT NULL COMMENT '시스템명' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `CNTC_ID` `CNTC_ID` char(8) NOT NULL COMMENT '연계ID' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL COMMENT '로그ID' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `LOG_INFO` `LOG_INFO` varchar(2000) DEFAULT NULL COMMENT '로그정보' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTHTRSMRCVMNTRNGLOGINFO` CHANGE `TEST_CLASS_NM` `TEST_CLASS_NM` varchar(255) DEFAULT NULL COMMENT '테스트클래스명' ; ALTER TABLE `COMTNADBK` CHANGE `ADBK_CONSTNT_ID` `ADBK_CONSTNT_ID` char(20) NOT NULL COMMENT '주소록구성원ID' ; ALTER TABLE `COMTNADBK` CHANGE `ADBK_ID` `ADBK_ID` char(20) NOT NULL COMMENT '주소록ID' ; ALTER TABLE `COMTNADBK` CHANGE `EMAIL_ADRES` `EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '이메일주소' ; ALTER TABLE `COMTNADBK` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) DEFAULT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNADBK` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNADBK` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNADBK` CHANGE `FXNUM` `FXNUM` varchar(20) DEFAULT NULL COMMENT '팩스번호' ; ALTER TABLE `COMTNADBK` CHANGE `HOUSE_TELNO` `HOUSE_TELNO` varchar(20) DEFAULT NULL COMMENT '주택전화번호' ; ALTER TABLE `COMTNADBK` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNADBK` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNADBK` CHANGE `MBTLNUM` `MBTLNUM` varchar(20) DEFAULT NULL COMMENT '이동전화번호' ; ALTER TABLE `COMTNADBK` CHANGE `NCRD_ID` `NCRD_ID` char(20) DEFAULT NULL COMMENT '명함ID' ; ALTER TABLE `COMTNADBK` CHANGE `NM` `NM` varchar(50) DEFAULT NULL COMMENT '이름' ; ALTER TABLE `COMTNADBK` CHANGE `OFFM_TELNO` `OFFM_TELNO` varchar(20) DEFAULT NULL COMMENT '사무실전화번호' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `ADBK_ID` `ADBK_ID` char(20) NOT NULL COMMENT '주소록ID' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `ADBK_NM` `ADBK_NM` varchar(50) NOT NULL COMMENT '주소록명' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `OTHBC_SCOPE` `OTHBC_SCOPE` varchar(20) NOT NULL COMMENT '공개범위' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `TRGET_ORGNZT_ID` `TRGET_ORGNZT_ID` char(20) DEFAULT NULL COMMENT '대상조직ID' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNADBKMANAGE` CHANGE `WRTER_ID` `WRTER_ID` varchar(20) DEFAULT NULL COMMENT '작성자ID' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `ADMINIST_WORD_ABRV_NM` `ADMINIST_WORD_ABRV_NM` varchar(255) DEFAULT NULL COMMENT '행정용어약어명' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `ADMINIST_WORD_DC` `ADMINIST_WORD_DC` varchar(4000) DEFAULT NULL COMMENT '행정용어설명' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `ADMINIST_WORD_DFN` `ADMINIST_WORD_DFN` varchar(2500) DEFAULT NULL COMMENT '행정용어정의' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `ADMINIST_WORD_ENG_NM` `ADMINIST_WORD_ENG_NM` varchar(255) DEFAULT NULL COMMENT '행정용어영문명' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `ADMINIST_WORD_ID` `ADMINIST_WORD_ID` char(20) NOT NULL DEFAULT '' COMMENT '행정용어ID' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `ADMINIST_WORD_NM` `ADMINIST_WORD_NM` varchar(255) DEFAULT NULL COMMENT '행정용어명' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `RELATE_STD_WORD` `RELATE_STD_WORD` varchar(255) DEFAULT NULL COMMENT '관계표준용어' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `THEMA_RELM` `THEMA_RELM` varchar(255) DEFAULT NULL COMMENT '주제영역' ; ALTER TABLE `COMTNADMINISTRATIONWORD` CHANGE `WORD_SE` `WORD_SE` varchar(255) DEFAULT NULL COMMENT '용어구분' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `ANNVRSRY_ID` `ANNVRSRY_ID` varchar(20) NOT NULL COMMENT '기념일ID' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `ANNVRSRY_NM` `ANNVRSRY_NM` varchar(255) NOT NULL COMMENT '기념일명' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `ANNVRSRY_NTCN_BGNDE` `ANNVRSRY_NTCN_BGNDE` char(20) DEFAULT NULL COMMENT '알림시작일' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `ANNVRSRY_NTCN_SETUP` `ANNVRSRY_NTCN_SETUP` char(1) DEFAULT NULL COMMENT '알림설정' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `ANNVRSRY_SE` `ANNVRSRY_SE` varchar(2) NOT NULL COMMENT '기념일구분' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `ANNVRSRY` `ANNVRSRY` char(20) NOT NULL COMMENT '기념일' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `CLDR_SE` `CLDR_SE` char(1) NOT NULL COMMENT '달력구분' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `MEMO` `MEMO` varchar(1000) DEFAULT NULL COMMENT '메모' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `REPTIT_AT` `REPTIT_AT` char(1) DEFAULT NULL COMMENT '반복여부' ; ALTER TABLE `COMTNANNVRSRYMANAGE` CHANGE `USER_ID` `USER_ID` varchar(20) NOT NULL COMMENT '사용자ID' ; ALTER TABLE `COMTNANSWER` CHANGE `ANSWER_NO` `ANSWER_NO` decimal(20,0) NOT NULL COMMENT '답글번호' ; ALTER TABLE `COMTNANSWER` CHANGE `ANSWER` `ANSWER` varchar(200) DEFAULT NULL COMMENT '댓글' ; ALTER TABLE `COMTNANSWER` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNANSWER` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNANSWER` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNANSWER` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNANSWER` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNANSWER` CHANGE `NTT_ID` `NTT_ID` decimal(20,0) NOT NULL COMMENT '게시물ID' ; ALTER TABLE `COMTNANSWER` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNANSWER` CHANGE `WRTER_ID` `WRTER_ID` varchar(20) DEFAULT NULL COMMENT '작성자ID' ; ALTER TABLE `COMTNANSWER` CHANGE `WRTER_NM` `WRTER_NM` varchar(20) DEFAULT NULL COMMENT '작성자명' ; ALTER TABLE `COMTNAUTHORGROUPINFO` CHANGE `GROUP_CREAT_DE` `GROUP_CREAT_DE` char(20) NOT NULL COMMENT '그룹생성일' ; ALTER TABLE `COMTNAUTHORGROUPINFO` CHANGE `GROUP_DC` `GROUP_DC` varchar(100) DEFAULT NULL COMMENT '그룹설명' ; ALTER TABLE `COMTNAUTHORGROUPINFO` CHANGE `GROUP_ID` `GROUP_ID` char(20) NOT NULL DEFAULT '' COMMENT '그룹ID' ; ALTER TABLE `COMTNAUTHORGROUPINFO` CHANGE `GROUP_NM` `GROUP_NM` varchar(60) NOT NULL COMMENT '그룹명' ; ALTER TABLE `COMTNAUTHORINFO` CHANGE `AUTHOR_CODE` `AUTHOR_CODE` varchar(30) NOT NULL DEFAULT '' COMMENT '권한코드' ; ALTER TABLE `COMTNAUTHORINFO` CHANGE `AUTHOR_CREAT_DE` `AUTHOR_CREAT_DE` char(20) NOT NULL COMMENT '권한생성일' ; ALTER TABLE `COMTNAUTHORINFO` CHANGE `AUTHOR_DC` `AUTHOR_DC` varchar(200) DEFAULT NULL COMMENT '권한설명' ; ALTER TABLE `COMTNAUTHORINFO` CHANGE `AUTHOR_NM` `AUTHOR_NM` varchar(60) NOT NULL COMMENT '권한명' ; ALTER TABLE `COMTNAUTHORROLERELATE` CHANGE `AUTHOR_CODE` `AUTHOR_CODE` varchar(30) NOT NULL COMMENT '권한코드' ; ALTER TABLE `COMTNAUTHORROLERELATE` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNAUTHORROLERELATE` CHANGE `ROLE_CODE` `ROLE_CODE` varchar(50) NOT NULL COMMENT '롤코드' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `BACKUP_OPERT_ID` `BACKUP_OPERT_ID` varchar(20) NOT NULL COMMENT '백업작업ID' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `BACKUP_OPERT_NM` `BACKUP_OPERT_NM` varchar(60) DEFAULT NULL COMMENT '백업작업명' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `BACKUP_ORGINL_DRCTRY` `BACKUP_ORGINL_DRCTRY` varchar(255) DEFAULT NULL COMMENT '백업원본디렉토리' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `BACKUP_STRE_DRCTRY` `BACKUP_STRE_DRCTRY` varchar(255) DEFAULT NULL COMMENT '백업저장디렉토리' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `CMPRS_SE` `CMPRS_SE` varchar(2) DEFAULT NULL COMMENT '압축구분' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `EXECUT_CYCLE` `EXECUT_CYCLE` varchar(2) DEFAULT NULL COMMENT '실행주기' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `EXECUT_SCHDUL_DE` `EXECUT_SCHDUL_DE` char(20) DEFAULT NULL COMMENT '실행일정일' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `EXECUT_SCHDUL_HOUR` `EXECUT_SCHDUL_HOUR` char(2) DEFAULT NULL COMMENT '실행일정시' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `EXECUT_SCHDUL_MNT` `EXECUT_SCHDUL_MNT` char(2) DEFAULT NULL COMMENT '실행일정분' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `EXECUT_SCHDUL_SECND` `EXECUT_SCHDUL_SECND` char(2) DEFAULT NULL COMMENT '실행일정초' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBACKUPOPERT` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `BACKUP_FILE` `BACKUP_FILE` varchar(255) DEFAULT NULL COMMENT '백업파일' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `BACKUP_OPERT_ID` `BACKUP_OPERT_ID` varchar(20) NOT NULL COMMENT '백업작업ID' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `BACKUP_RESULT_ID` `BACKUP_RESULT_ID` varchar(20) NOT NULL COMMENT '백업결과ID' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `ERROR_INFO` `ERROR_INFO` varchar(2000) DEFAULT NULL COMMENT '오류정보' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `EXECUT_BEGIN_TM` `EXECUT_BEGIN_TM` varchar(14) DEFAULT NULL COMMENT '실행시작시각' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `EXECUT_END_TM` `EXECUT_END_TM` varchar(14) DEFAULT NULL COMMENT '실행종료시각' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBACKUPRESULT` CHANGE `STTUS` `STTUS` varchar(2) DEFAULT NULL COMMENT '상태' ; ALTER TABLE `COMTNBACKUPSCHDULDFK` CHANGE `BACKUP_OPERT_ID` `BACKUP_OPERT_ID` varchar(20) NOT NULL COMMENT '백업작업ID' ; ALTER TABLE `COMTNBACKUPSCHDULDFK` CHANGE `EXECUT_SCHDUL_DFK_SE` `EXECUT_SCHDUL_DFK_SE` char(1) NOT NULL COMMENT '실행일정요일구분' ; ALTER TABLE `COMTNBANNER` CHANGE `BANNER_DC` `BANNER_DC` varchar(200) DEFAULT NULL COMMENT '배너설명' ; ALTER TABLE `COMTNBANNER` CHANGE `BANNER_ID` `BANNER_ID` char(20) NOT NULL DEFAULT '' COMMENT '배너ID' ; ALTER TABLE `COMTNBANNER` CHANGE `BANNER_IMAGE_FILE` `BANNER_IMAGE_FILE` varchar(60) DEFAULT NULL COMMENT '배너이미지파일' ; ALTER TABLE `COMTNBANNER` CHANGE `BANNER_IMAGE` `BANNER_IMAGE` varchar(60) NOT NULL COMMENT '배너이미지' ; ALTER TABLE `COMTNBANNER` CHANGE `BANNER_NM` `BANNER_NM` varchar(60) NOT NULL COMMENT '배너명' ; ALTER TABLE `COMTNBANNER` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBANNER` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBANNER` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBANNER` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBANNER` CHANGE `LINK_URL` `LINK_URL` varchar(255) NOT NULL COMMENT '링크URL' ; ALTER TABLE `COMTNBANNER` CHANGE `REFLCT_AT` `REFLCT_AT` char(1) NOT NULL COMMENT '반영여부' ; ALTER TABLE `COMTNBANNER` CHANGE `SORT_ORDR` `SORT_ORDR` decimal(8,0) DEFAULT NULL COMMENT '정렬순서' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `BATCH_OPERT_ID` `BATCH_OPERT_ID` varchar(20) NOT NULL COMMENT '배치작업ID' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `BATCH_OPERT_NM` `BATCH_OPERT_NM` varchar(60) DEFAULT NULL COMMENT '배치작업명' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `BATCH_PROGRM` `BATCH_PROGRM` varchar(255) DEFAULT NULL COMMENT '배치프로그램' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `PARAMTR` `PARAMTR` varchar(250) DEFAULT NULL COMMENT '파라미터' ; ALTER TABLE `COMTNBATCHOPERT` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `BATCH_OPERT_ID` `BATCH_OPERT_ID` varchar(20) NOT NULL COMMENT '배치작업ID' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `BATCH_RESULT_ID` `BATCH_RESULT_ID` varchar(20) NOT NULL COMMENT '배치결과ID' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `BATCH_SCHDUL_ID` `BATCH_SCHDUL_ID` varchar(20) NOT NULL COMMENT '배치일정ID' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `ERROR_INFO` `ERROR_INFO` varchar(2000) DEFAULT NULL COMMENT '오류정보' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `EXECUT_BEGIN_TM` `EXECUT_BEGIN_TM` varchar(14) DEFAULT NULL COMMENT '실행시작시각' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `EXECUT_END_TM` `EXECUT_END_TM` varchar(14) DEFAULT NULL COMMENT '실행종료시각' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `PARAMTR` `PARAMTR` varchar(250) DEFAULT NULL COMMENT '파라미터' ; ALTER TABLE `COMTNBATCHRESULT` CHANGE `STTUS` `STTUS` varchar(2) DEFAULT NULL COMMENT '상태' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `BATCH_OPERT_ID` `BATCH_OPERT_ID` varchar(20) NOT NULL COMMENT '배치작업ID' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `BATCH_SCHDUL_ID` `BATCH_SCHDUL_ID` varchar(20) NOT NULL COMMENT '배치일정ID' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `EXECUT_CYCLE` `EXECUT_CYCLE` varchar(2) DEFAULT NULL COMMENT '실행주기' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `EXECUT_SCHDUL_DE` `EXECUT_SCHDUL_DE` char(20) DEFAULT NULL COMMENT '실행일정일' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `EXECUT_SCHDUL_HOUR` `EXECUT_SCHDUL_HOUR` char(2) DEFAULT NULL COMMENT '실행일정시' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `EXECUT_SCHDUL_MNT` `EXECUT_SCHDUL_MNT` char(2) DEFAULT NULL COMMENT '실행일정분' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `EXECUT_SCHDUL_SECND` `EXECUT_SCHDUL_SECND` char(2) DEFAULT NULL COMMENT '실행일정초' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBATCHSCHDUL` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBATCHSCHDULDFK` CHANGE `BATCH_SCHDUL_ID` `BATCH_SCHDUL_ID` varchar(20) NOT NULL COMMENT '배치일정ID' ; ALTER TABLE `COMTNBATCHSCHDULDFK` CHANGE `EXECUT_SCHDUL_DFK_SE` `EXECUT_SCHDUL_DFK_SE` char(1) NOT NULL COMMENT '실행일정요일구분' ; ALTER TABLE `COMTNBBS` CHANGE `ANSWER_AT` `ANSWER_AT` char(1) DEFAULT NULL COMMENT '댓글여부' ; ALTER TABLE `COMTNBBS` CHANGE `ANSWER_LC` `ANSWER_LC` decimal(8,0) DEFAULT NULL COMMENT '댓글위치' ; ALTER TABLE `COMTNBBS` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNBBS` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNBBS` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBBS` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBBS` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBBS` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBBS` CHANGE `NTCE_BGNDE` `NTCE_BGNDE` char(20) DEFAULT NULL COMMENT '게시시작일' ; ALTER TABLE `COMTNBBS` CHANGE `NTCE_ENDDE` `NTCE_ENDDE` char(20) DEFAULT NULL COMMENT '게시종료일' ; ALTER TABLE `COMTNBBS` CHANGE `NTCR_ID` `NTCR_ID` varchar(20) DEFAULT NULL COMMENT '게시자ID' ; ALTER TABLE `COMTNBBS` CHANGE `NTCR_NM` `NTCR_NM` varchar(20) DEFAULT NULL COMMENT '게시자명' ; ALTER TABLE `COMTNBBS` CHANGE `NTT_CN` `NTT_CN` mediumtext DEFAULT NULL COMMENT '게시물내용' ; ALTER TABLE `COMTNBBS` CHANGE `NTT_ID` `NTT_ID` decimal(20,0) NOT NULL COMMENT '게시물ID' ; ALTER TABLE `COMTNBBS` CHANGE `NTT_NO` `NTT_NO` decimal(20,0) DEFAULT NULL COMMENT '게시물번호' ; ALTER TABLE `COMTNBBS` CHANGE `NTT_SJ` `NTT_SJ` varchar(2000) DEFAULT NULL COMMENT '게시물제목' ; ALTER TABLE `COMTNBBS` CHANGE `PARNTSCTT_NO` `PARNTSCTT_NO` decimal(10,0) DEFAULT NULL COMMENT '부모글번호' ; ALTER TABLE `COMTNBBS` CHANGE `PASSWORD` `PASSWORD` varchar(200) DEFAULT NULL COMMENT '비밀번호' ; ALTER TABLE `COMTNBBS` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTNBBS` CHANGE `SORT_ORDR` `SORT_ORDR` decimal(8,0) DEFAULT NULL COMMENT '정렬순서' ; ALTER TABLE `COMTNBBS` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNBBS` CHANGE `BLOG_ID` `BLOG_ID` char(20) NULL COMMENT '블로그 ID' ; ALTER TABLE `COMTNBBS` CHANGE `NOTICE_AT` `NOTICE_AT` char(1) NULL COMMENT '공지사항여부' ; ALTER TABLE `COMTNBBS` CHANGE `SECRET_AT` `SECRET_AT` char(1) NULL COMMENT '비밀글여부' ; ALTER TABLE `COMTNBBS` CHANGE `SJ_BOLD_AT` `SJ_BOLD_AT` char(1) NULL COMMENT '제목볼드여부' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `ATCH_POSBL_FILE_NUMBER` `ATCH_POSBL_FILE_NUMBER` decimal(2,0) NOT NULL COMMENT '첨부가능파일숫자' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `ATCH_POSBL_FILE_SIZE` `ATCH_POSBL_FILE_SIZE` decimal(8,0) DEFAULT NULL COMMENT '첨부가능파일사이즈' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `BBS_INTRCN` `BBS_INTRCN` varchar(2400) DEFAULT NULL COMMENT '게시판소개' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `BBS_NM` `BBS_NM` varchar(255) NOT NULL COMMENT '게시판명' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `BBS_TY_CODE` `BBS_TY_CODE` char(6) NOT NULL COMMENT '게시판유형코드' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `FILE_ATCH_POSBL_AT` `FILE_ATCH_POSBL_AT` char(1) NOT NULL COMMENT '파일첨부가능여부' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `REPLY_POSBL_AT` `REPLY_POSBL_AT` char(1) DEFAULT NULL COMMENT '답장가능여부' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `TMPLAT_ID` `TMPLAT_ID` char(20) DEFAULT NULL COMMENT '템플릿ID' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `BLOG_AT` `BLOG_AT` char(2) NULL COMMENT '블로그 여부' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `BLOG_ID` `BLOG_ID` char(20) NULL COMMENT '블로그 ID' ; ALTER TABLE `COMTNBBSMASTER` CHANGE `CMMNTY_ID` `CMMNTY_ID` char(20) NULL COMMENT '커뮤니티ID' ; ALTER TABLE `COMTNBBSMASTEROPTN` CHANGE `ANSWER_AT` `ANSWER_AT` char(1) NOT NULL COMMENT '댓글여부' ; ALTER TABLE `COMTNBBSMASTEROPTN` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNBBSMASTEROPTN` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBBSMASTEROPTN` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBBSMASTEROPTN` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBBSMASTEROPTN` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBBSMASTEROPTN` CHANGE `STSFDG_AT` `STSFDG_AT` char(1) NOT NULL COMMENT '만족도여부' ; ALTER TABLE `COMTNBBSUSE` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNBBSUSE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBBSUSE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBBSUSE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBBSUSE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBBSUSE` CHANGE `REGIST_SE_CODE` `REGIST_SE_CODE` char(6) DEFAULT NULL COMMENT '등록구분코드' ; ALTER TABLE `COMTNBBSUSE` CHANGE `TRGET_ID` `TRGET_ID` char(20) NOT NULL DEFAULT '' COMMENT '대상ID' ; ALTER TABLE `COMTNBBSUSE` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNBKMKMENUMANAGERESULT` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '업무사용자ID' ; ALTER TABLE `COMTNBKMKMENUMANAGERESULT` CHANGE `MENU_ID` `MENU_ID` decimal(20,0) NOT NULL DEFAULT '0' COMMENT '메뉴ID' ; ALTER TABLE `COMTNBKMKMENUMANAGERESULT` CHANGE `MENU_NM` `MENU_NM` varchar(60) NOT NULL COMMENT '메뉴명' ; ALTER TABLE `COMTNBKMKMENUMANAGERESULT` CHANGE `PROGRM_STRE_PATH` `PROGRM_STRE_PATH` varchar(100) NOT NULL COMMENT '프로그램저장경로' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `BNDT_CECK_CODE_NM` `BNDT_CECK_CODE_NM` varchar(255) NOT NULL COMMENT '당직체크코드명' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `BNDT_CECK_CODE` `BNDT_CECK_CODE` varchar(10) NOT NULL COMMENT '당직체크코드' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `BNDT_CECK_SE` `BNDT_CECK_SE` char(2) NOT NULL COMMENT '당직체크구분' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBNDTCECKMANAGE` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `BNDT_CECK_CODE` `BNDT_CECK_CODE` varchar(10) NOT NULL COMMENT '당직체크코드' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `BNDT_CECK_SE` `BNDT_CECK_SE` char(2) NOT NULL COMMENT '당직체크구분' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `BNDT_DE` `BNDT_DE` char(8) NOT NULL COMMENT '당직일자' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `BNDT_ID` `BNDT_ID` varchar(20) NOT NULL COMMENT '당직ID' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `CHCK_STTUS` `CHCK_STTUS` varchar(1000) DEFAULT NULL COMMENT '점검상태' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBNDTDIARY` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBNDTMANAGE` CHANGE `BNDT_DE` `BNDT_DE` char(8) NOT NULL COMMENT '당직일자' ; ALTER TABLE `COMTNBNDTMANAGE` CHANGE `BNDT_ID` `BNDT_ID` varchar(20) NOT NULL COMMENT '당직ID' ; ALTER TABLE `COMTNBNDTMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBNDTMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBNDTMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBNDTMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBNDTMANAGE` CHANGE `RM` `RM` varchar(2500) DEFAULT NULL COMMENT '비고' ; ALTER TABLE `COMTNCLUB` CHANGE `CLB_ID` `CLB_ID` char(20) NOT NULL COMMENT '동호회ID' ; ALTER TABLE `COMTNCLUB` CHANGE `CLB_INTRCN` `CLB_INTRCN` varchar(2400) DEFAULT NULL COMMENT '동호회소개' ; ALTER TABLE `COMTNCLUB` CHANGE `CLB_NM` `CLB_NM` varchar(255) NOT NULL COMMENT '동호회명' ; ALTER TABLE `COMTNCLUB` CHANGE `CMMNTY_ID` `CMMNTY_ID` char(20) NOT NULL COMMENT '커뮤니티ID' ; ALTER TABLE `COMTNCLUB` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCLUB` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCLUB` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCLUB` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCLUB` CHANGE `REGIST_SE_CODE` `REGIST_SE_CODE` char(6) DEFAULT NULL COMMENT '등록구분코드' ; ALTER TABLE `COMTNCLUB` CHANGE `TMPLAT_ID` `TMPLAT_ID` char(20) DEFAULT NULL COMMENT '템플릿ID' ; ALTER TABLE `COMTNCLUB` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `CLB_ID` `CLB_ID` char(20) NOT NULL COMMENT '동호회ID' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `CMMNTY_ID` `CMMNTY_ID` char(20) NOT NULL COMMENT '커뮤니티ID' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `OPRTR_AT` `OPRTR_AT` char(1) NOT NULL COMMENT '운영인여부' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `SBSCRB_DE` `SBSCRB_DE` datetime DEFAULT NULL COMMENT '가입일자' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `SECSN_DE` `SECSN_DE` char(20) DEFAULT NULL COMMENT '탈퇴일' ; ALTER TABLE `COMTNCLUBUSER` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCMMNTY` CHANGE `CMMNTY_ID` `CMMNTY_ID` char(20) NOT NULL COMMENT '커뮤니티ID' ; ALTER TABLE `COMTNCMMNTY` CHANGE `CMMNTY_INTRCN` `CMMNTY_INTRCN` varchar(2400) DEFAULT NULL COMMENT '커뮤니티소개' ; ALTER TABLE `COMTNCMMNTY` CHANGE `CMMNTY_NM` `CMMNTY_NM` varchar(255) NOT NULL COMMENT '커뮤니티명' ; ALTER TABLE `COMTNCMMNTY` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCMMNTY` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCMMNTY` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCMMNTY` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCMMNTY` CHANGE `REGIST_SE_CODE` `REGIST_SE_CODE` char(6) DEFAULT NULL COMMENT '등록구분코드' ; ALTER TABLE `COMTNCMMNTY` CHANGE `TMPLAT_ID` `TMPLAT_ID` char(20) DEFAULT NULL COMMENT '템플릿ID' ; ALTER TABLE `COMTNCMMNTY` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `CMMNTY_ID` `CMMNTY_ID` char(20) NOT NULL COMMENT '커뮤니티ID' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `MNGR_AT` `MNGR_AT` char(1) NOT NULL COMMENT '관리자여부' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `SBSCRB_DE` `SBSCRB_DE` datetime DEFAULT NULL COMMENT '가입일자' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `SECSN_DE` `SECSN_DE` char(20) DEFAULT NULL COMMENT '탈퇴일' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCMMNTYUSER` CHANGE `MBER_STTUS` `MBER_STTUS` varchar(15) NULL COMMENT '회원 상태' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `AREA_NO` `AREA_NO` varchar(4) DEFAULT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `CNSLT_CN` `CNSLT_CN` varchar(2500) DEFAULT NULL COMMENT '상담내용' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `CNSLT_ID` `CNSLT_ID` char(20) NOT NULL COMMENT '상담ID' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `CNSLT_SJ` `CNSLT_SJ` varchar(255) DEFAULT NULL COMMENT '상담제목' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `EMAIL_ADRES` `EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '이메일주소' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `EMAIL_ANSWER_AT` `EMAIL_ANSWER_AT` char(1) DEFAULT NULL COMMENT '메일답변여부' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `END_MBTLNUM` `END_MBTLNUM` varchar(4) DEFAULT NULL COMMENT '끝이동전화번호' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `END_TELNO` `END_TELNO` varchar(4) DEFAULT NULL COMMENT '끝전화번호' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `FRST_MBTLNUM` `FRST_MBTLNUM` varchar(4) DEFAULT NULL COMMENT '처음휴대폰번호' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `MANAGT_CN` `MANAGT_CN` varchar(2500) DEFAULT NULL COMMENT '조치내용' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `MANAGT_DE` `MANAGT_DE` char(20) DEFAULT NULL COMMENT '조치일' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `MIDDLE_MBTLNUM` `MIDDLE_MBTLNUM` varchar(4) DEFAULT NULL COMMENT '중간이동전화번호' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `MIDDLE_TELNO` `MIDDLE_TELNO` varchar(4) DEFAULT NULL COMMENT '중간전화번호' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `OTHBC_AT` `OTHBC_AT` char(1) DEFAULT NULL COMMENT '공개여부' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `QNA_PROCESS_STTUS_CODE` `QNA_PROCESS_STTUS_CODE` char(1) DEFAULT NULL COMMENT '질의응답처리상태코드' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `WRITNG_DE` `WRITNG_DE` char(20) DEFAULT NULL COMMENT '작성일' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `WRITNG_PASSWORD` `WRITNG_PASSWORD` varchar(20) DEFAULT NULL COMMENT '작성비밀번호' ; ALTER TABLE `COMTNCNSLTLIST` CHANGE `WRTER_NM` `WRTER_NM` varchar(20) DEFAULT NULL COMMENT '작성자명' ; ALTER TABLE `COMTNCNTCINSTT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCNTCINSTT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCNTCINSTT` CHANGE `INSTT_ID` `INSTT_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '기관ID' ; ALTER TABLE `COMTNCNTCINSTT` CHANGE `INSTT_NM` `INSTT_NM` varchar(100) DEFAULT NULL COMMENT '기관명' ; ALTER TABLE `COMTNCNTCINSTT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCNTCINSTT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCNTCINSTT` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `CNTC_MSSAGE_ID` `CNTC_MSSAGE_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '연계메시지ID' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `CNTC_MSSAGE_NM` `CNTC_MSSAGE_NM` varchar(100) DEFAULT NULL COMMENT '연계메시지명' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `UPPER_CNTC_MSSAGE_ID` `UPPER_CNTC_MSSAGE_ID` varchar(20) DEFAULT NULL COMMENT '상위연계메시지ID' ; ALTER TABLE `COMTNCNTCMESSAGE` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `CNTC_MSSAGE_ID` `CNTC_MSSAGE_ID` varchar(20) NOT NULL COMMENT '연계메시지ID' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `IEM_ID` `IEM_ID` varchar(20) NOT NULL COMMENT '항목ID' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `IEM_LT` `IEM_LT` decimal(8,0) DEFAULT NULL COMMENT '항목길이' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `IEM_NM` `IEM_NM` varchar(100) DEFAULT NULL COMMENT '항목명' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `IEM_TY` `IEM_TY` varchar(50) DEFAULT NULL COMMENT '항목유형' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCNTCMESSAGEITEM` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `INSTT_ID` `INSTT_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '기관ID' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `REQUST_MSSAGE_ID` `REQUST_MSSAGE_ID` varchar(20) DEFAULT NULL COMMENT '요청메시지ID' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `RSPNS_MSSAGE_ID` `RSPNS_MSSAGE_ID` varchar(20) DEFAULT NULL COMMENT '응답메시지ID' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `SVC_ID` `SVC_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '서비스ID' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `SVC_NM` `SVC_NM` varchar(255) DEFAULT NULL COMMENT '서비스명' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `SYS_ID` `SYS_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '시스템ID' ; ALTER TABLE `COMTNCNTCSERVICE` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `INSTT_ID` `INSTT_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '기관ID' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `SYS_ID` `SYS_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '시스템ID' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `SYS_IP` `SYS_IP` varchar(23) DEFAULT NULL COMMENT '시스템IP' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `SYS_NM` `SYS_NM` varchar(255) DEFAULT NULL COMMENT '시스템명' ; ALTER TABLE `COMTNCNTCSYSTEM` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCNTNTSLIST` CHANGE `CNTNTS_ID` `CNTNTS_ID` varchar(20) NOT NULL COMMENT '컨텐츠ID' ; ALTER TABLE `COMTNCNTNTSLIST` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNCOMMENT` CHANGE `ANSWER_NO` `ANSWER_NO` decimal(20,0) NOT NULL COMMENT '댓글번호' ; ALTER TABLE `COMTNCOMMENT` CHANGE `ANSWER` `ANSWER` varchar(200) DEFAULT NULL COMMENT '댓글' ; ALTER TABLE `COMTNCOMMENT` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNCOMMENT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCOMMENT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCOMMENT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCOMMENT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCOMMENT` CHANGE `NTT_ID` `NTT_ID` decimal(20,0) NOT NULL COMMENT '게시물ID' ; ALTER TABLE `COMTNCOMMENT` CHANGE `PASSWORD` `PASSWORD` varchar(200) DEFAULT NULL COMMENT '비밀번호' ; ALTER TABLE `COMTNCOMMENT` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNCOMMENT` CHANGE `WRTER_ID` `WRTER_ID` varchar(20) DEFAULT NULL COMMENT '작성자ID' ; ALTER TABLE `COMTNCOMMENT` CHANGE `WRTER_NM` `WRTER_NM` varchar(20) DEFAULT NULL COMMENT '작성자명' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `ORGNZT_ID` `ORGNZT_ID` varchar(20) DEFAULT NULL COMMENT '조직ID' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `OVTMWRK_HOURS` `OVTMWRK_HOURS` char(2) DEFAULT NULL COMMENT '초과근무시간' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `RM` `RM` varchar(100) DEFAULT NULL COMMENT '비고' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `WRK_END_STATUS` `WRK_END_STATUS` varchar(10) DEFAULT NULL COMMENT '퇴근상태' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `WRK_END_TIME` `WRK_END_TIME` varchar(14) DEFAULT NULL COMMENT '퇴근시간' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `WRK_HOURS` `WRK_HOURS` char(2) DEFAULT NULL COMMENT '근무시간' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `WRK_START_STATUS` `WRK_START_STATUS` varchar(10) DEFAULT NULL COMMENT '출근상태' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `WRK_START_TIME` `WRK_START_TIME` varchar(14) DEFAULT NULL COMMENT '출근시간' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `WRKT_DT` `WRKT_DT` varchar(10) NOT NULL COMMENT '출근날짜' ; ALTER TABLE `COMTNCOMMUTE` CHANGE `WRKTM_ID` `WRKTM_ID` char(20) NOT NULL COMMENT '출퇴근 구분 ID' ; ALTER TABLE `COMTNCPYRHTINFO` CHANGE `CPYRHT_ID` `CPYRHT_ID` char(20) NOT NULL COMMENT '저작권ID' ; ALTER TABLE `COMTNCPYRHTINFO` CHANGE `CPYRHT_PRTC_POLICY_CN` `CPYRHT_PRTC_POLICY_CN` varchar(2500) DEFAULT NULL COMMENT '저작권보호정책내용' ; ALTER TABLE `COMTNCPYRHTINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCPYRHTINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCPYRHTINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCPYRHTINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `BRTHDY` `BRTHDY` char(20) NOT NULL COMMENT '생일' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `CONFM_AT` `CONFM_AT` char(1) DEFAULT NULL COMMENT '승인여부' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `CTSNN_CODE` `CTSNN_CODE` char(2) NOT NULL COMMENT '경조코드' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `CTSNN_ID` `CTSNN_ID` varchar(20) NOT NULL COMMENT '경조ID' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `CTSNN_NM` `CTSNN_NM` varchar(255) NOT NULL COMMENT '경조명' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `INFRML_SANCTN_ID` `INFRML_SANCTN_ID` char(20) DEFAULT NULL COMMENT '약식결재ID' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(20) NOT NULL COMMENT '발생일' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `RELATE` `RELATE` char(2) NOT NULL COMMENT '관계' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `REQST_DE` `REQST_DE` char(20) NOT NULL COMMENT '신청일' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `RETURN_RESN` `RETURN_RESN` varchar(1000) DEFAULT NULL COMMENT '반환사유' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `RM` `RM` varchar(2500) DEFAULT NULL COMMENT '비고' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `SANCTN_DT` `SANCTN_DT` datetime DEFAULT NULL COMMENT '결재일시' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `SANCTNER_ID` `SANCTNER_ID` varchar(20) NOT NULL COMMENT '결재자ID' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `TRGTER_NM` `TRGTER_NM` varchar(20) NOT NULL COMMENT '대상자명' ; ALTER TABLE `COMTNCTSNNMANAGE` CHANGE `USER_ID` `USER_ID` varchar(20) NOT NULL COMMENT '사용자ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `ANSWER_DP` `ANSWER_DP` decimal(20,0) DEFAULT NULL COMMENT '답변깊이' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `ANSWER_GROUP_NO` `ANSWER_GROUP_NO` decimal(20,0) DEFAULT NULL COMMENT '답변그룹번호' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `ANSWER_ORDR` `ANSWER_ORDR` decimal(20,0) DEFAULT NULL COMMENT '답변순서' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) DEFAULT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `EXPERT_ID` `EXPERT_ID` char(20) DEFAULT NULL COMMENT '전문가ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `KNWLDG_CN` `KNWLDG_CN` varchar(2500) DEFAULT NULL COMMENT '지식내용' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `KNWLDG_ID` `KNWLDG_ID` char(20) NOT NULL COMMENT '지식ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `KNWLDG_NM` `KNWLDG_NM` varchar(60) DEFAULT NULL COMMENT '지식명' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `KNWLDG_TY_CODE` `KNWLDG_TY_CODE` varchar(3) DEFAULT NULL COMMENT '지식유형코드' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `ORGNZT_ID` `ORGNZT_ID` char(20) DEFAULT NULL COMMENT '조직ID' ; ALTER TABLE `COMTNDAMCALRES` CHANGE `PARNTS_KNWLDG_ID` `PARNTS_KNWLDG_ID` char(20) DEFAULT NULL COMMENT '부모지식ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `COLCT_DE` `COLCT_DE` char(20) DEFAULT NULL COMMENT '수집일자' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `DSUSE_DE` `DSUSE_DE` char(20) DEFAULT NULL COMMENT '폐기일' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) DEFAULT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `EVL_DE` `EVL_DE` char(20) DEFAULT NULL COMMENT '평가일자' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `EXPERT_ID` `EXPERT_ID` char(20) DEFAULT NULL COMMENT '전문가ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `KNWLDG_CN` `KNWLDG_CN` varchar(2500) DEFAULT NULL COMMENT '지식내용' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `KNWLDG_EVL` `KNWLDG_EVL` char(1) DEFAULT NULL COMMENT '지식평가' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `KNWLDG_ID` `KNWLDG_ID` char(20) NOT NULL COMMENT '지식ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `KNWLDG_NM` `KNWLDG_NM` varchar(60) DEFAULT NULL COMMENT '지식명' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `KNWLDG_TY_CODE` `KNWLDG_TY_CODE` varchar(3) DEFAULT NULL COMMENT '지식유형코드' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `KWRD` `KWRD` varchar(100) DEFAULT NULL COMMENT '키워드' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `ORGNZT_ID` `ORGNZT_ID` char(20) DEFAULT NULL COMMENT '조직ID' ; ALTER TABLE `COMTNDAMKNOIFM` CHANGE `OTHBC_AT` `OTHBC_AT` char(1) DEFAULT NULL COMMENT '공개여부' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `CL_DE` `CL_DE` char(20) DEFAULT NULL COMMENT '분류일' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `EXPERT_ID` `EXPERT_ID` char(20) DEFAULT NULL COMMENT '전문가ID' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `KNWLDG_TY_CODE` `KNWLDG_TY_CODE` varchar(3) NOT NULL COMMENT '지식유형코드' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `KNWLDG_TY_NM` `KNWLDG_TY_NM` varchar(60) DEFAULT NULL COMMENT '지식유형명' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `KNWLDG_URL` `KNWLDG_URL` varchar(255) DEFAULT NULL COMMENT '지식URL' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDAMMAPKNO` CHANGE `ORGNZT_ID` `ORGNZT_ID` char(20) DEFAULT NULL COMMENT '조직ID' ; ALTER TABLE `COMTNDAMMAPTEAM` CHANGE `CL_DE` `CL_DE` char(20) DEFAULT NULL COMMENT '분류일' ; ALTER TABLE `COMTNDAMMAPTEAM` CHANGE `KNWLDG_URL` `KNWLDG_URL` varchar(255) DEFAULT NULL COMMENT '지식URL' ; ALTER TABLE `COMTNDAMMAPTEAM` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDAMMAPTEAM` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDAMMAPTEAM` CHANGE `ORGNZT_ID` `ORGNZT_ID` char(20) NOT NULL COMMENT '조직ID' ; ALTER TABLE `COMTNDAMMAPTEAM` CHANGE `ORGNZT_NM` `ORGNZT_NM` varchar(20) DEFAULT NULL COMMENT '조직명' ; ALTER TABLE `COMTNDAMPRO` CHANGE `EXPERT_CONFM_DE` `EXPERT_CONFM_DE` char(20) DEFAULT NULL COMMENT '전문가승인일' ; ALTER TABLE `COMTNDAMPRO` CHANGE `EXPERT_DC` `EXPERT_DC` varchar(2000) DEFAULT NULL COMMENT '전문가설명' ; ALTER TABLE `COMTNDAMPRO` CHANGE `EXPERT_GRAD` `EXPERT_GRAD` char(1) NOT NULL COMMENT '전문가등급' ; ALTER TABLE `COMTNDAMPRO` CHANGE `EXPERT_ID` `EXPERT_ID` char(20) NOT NULL COMMENT '전문가ID' ; ALTER TABLE `COMTNDAMPRO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDAMPRO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDAMPRO` CHANGE `KNWLDG_TY_CODE` `KNWLDG_TY_CODE` varchar(3) NOT NULL COMMENT '지식유형코드' ; ALTER TABLE `COMTNDAMPRO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDAMPRO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `CECK_SQL` `CECK_SQL` varchar(250) DEFAULT NULL COMMENT '체크SQL' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `DATA_SOURC_NM` `DATA_SOURC_NM` varchar(60) NOT NULL COMMENT '데이터소스명' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `DBMS_KND` `DBMS_KND` varchar(2) DEFAULT NULL COMMENT 'DBMS종류' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTNDBMNTRNG` CHANGE `SERVER_NM` `SERVER_NM` varchar(60) DEFAULT NULL COMMENT '서버명' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `CHARGER_ID` `CHARGER_ID` varchar(20) NOT NULL COMMENT '담당자ID' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `DEPT_JOB_CN` `DEPT_JOB_CN` varchar(2500) NOT NULL COMMENT '부서업무내용' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `DEPT_JOB_ID` `DEPT_JOB_ID` char(20) NOT NULL COMMENT '부서업무ID' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `DEPT_JOB_NM` `DEPT_JOB_NM` varchar(255) NOT NULL COMMENT '부서업무명' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `DEPT_JOBBX_ID` `DEPT_JOBBX_ID` char(6) NOT NULL COMMENT '부서업무함ID' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDEPTJOB` CHANGE `PRIORT` `PRIORT` char(1) NOT NULL COMMENT '우선순위' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `DEPT_ID` `DEPT_ID` varchar(20) NOT NULL COMMENT '부서ID' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `DEPT_JOBBX_ID` `DEPT_JOBBX_ID` char(6) NOT NULL COMMENT '부서업무함ID' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `DEPT_JOBBX_NM` `DEPT_JOBBX_NM` varchar(255) NOT NULL COMMENT '부서업무함명' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `INDICT_ORDR` `INDICT_ORDR` decimal(6,0) DEFAULT NULL COMMENT '표시순서' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDEPTJOBBX` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `DIARY_ID` `DIARY_ID` char(20) NOT NULL COMMENT '일지ID' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `DIARY_NM` `DIARY_NM` varchar(255) DEFAULT NULL COMMENT '일지명' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `DIARY_PROGRSRT` `DIARY_PROGRSRT` decimal(3,0) DEFAULT NULL COMMENT '일지진척율' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `DRCT_MATTER` `DRCT_MATTER` varchar(2500) DEFAULT NULL COMMENT '지시사항' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `PARTCLR_MATTER` `PARTCLR_MATTER` varchar(2500) DEFAULT NULL COMMENT '특이사항' ; ALTER TABLE `COMTNDIARYINFO` CHANGE `SCHDUL_ID` `SCHDUL_ID` char(20) NOT NULL COMMENT '일정ID' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) NOT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `DTA_USE_STATS_ID` `DTA_USE_STATS_ID` char(20) NOT NULL COMMENT '자료사용통계ID' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `FILE_SN` `FILE_SN` decimal(10,0) NOT NULL COMMENT '파일순번' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNDTAUSESTATS` CHANGE `NTT_ID` `NTT_ID` decimal(20,0) NOT NULL COMMENT '게시물ID' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `AREA_NO` `AREA_NO` varchar(4) NOT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `BRTHDY` `BRTHDY` char(20) DEFAULT NULL COMMENT '생일' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `CRTFC_DN_VALUE` `CRTFC_DN_VALUE` varchar(100) DEFAULT NULL COMMENT '인증DN값' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `DETAIL_ADRES` `DETAIL_ADRES` varchar(100) DEFAULT NULL COMMENT '상세주소' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `EMAIL_ADRES` `EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '이메일주소' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `EMPL_NO` `EMPL_NO` varchar(20) DEFAULT NULL COMMENT '사원번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `EMPLYR_STTUS_CODE` `EMPLYR_STTUS_CODE` char(1) NOT NULL COMMENT '사용자상태코드' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `ESNTL_ID` `ESNTL_ID` char(20) NOT NULL COMMENT '고유ID' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `FXNUM` `FXNUM` varchar(20) DEFAULT NULL COMMENT '팩스번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `GROUP_ID` `GROUP_ID` char(20) COMMENT '그룹ID' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `HOUSE_ADRES` `HOUSE_ADRES` varchar(100) NOT NULL COMMENT '주택주소' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `HOUSE_END_TELNO` `HOUSE_END_TELNO` varchar(4) NOT NULL COMMENT '주택끝전화번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `HOUSE_MIDDLE_TELNO` `HOUSE_MIDDLE_TELNO` varchar(4) NOT NULL COMMENT '주택중간전화번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `IHIDNUM` `IHIDNUM` varchar(200) DEFAULT NULL COMMENT '주민등록번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `MBTLNUM` `MBTLNUM` varchar(20) DEFAULT NULL COMMENT '이동전화번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `OFCPS_NM` `OFCPS_NM` varchar(60) DEFAULT NULL COMMENT '직위명' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `OFFM_TELNO` `OFFM_TELNO` varchar(20) DEFAULT NULL COMMENT '사무실전화번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `ORGNZT_ID` `ORGNZT_ID` char(20) COMMENT '조직ID' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `PASSWORD_CNSR` `PASSWORD_CNSR` varchar(100) NOT NULL COMMENT '비밀번호정답' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `PASSWORD_HINT` `PASSWORD_HINT` varchar(100) NOT NULL COMMENT '비밀번호힌트' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `PASSWORD` `PASSWORD` varchar(200) NOT NULL COMMENT '비밀번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `PSTINST_CODE` `PSTINST_CODE` char(8) DEFAULT NULL COMMENT '소속기관코드' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `SBSCRB_DE` `SBSCRB_DE` datetime DEFAULT NULL COMMENT '가입일자' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `SEXDSTN_CODE` `SEXDSTN_CODE` char(1) DEFAULT NULL COMMENT '성별코드' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `USER_NM` `USER_NM` varchar(60) NOT NULL COMMENT '사용자명' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `ZIP` `ZIP` varchar(6) NOT NULL COMMENT '우편번호' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `LOCK_AT` `LOCK_AT` char(1) NULL COMMENT '잠금여부' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `LOCK_CNT` `LOCK_CNT` numeric(3) NULL COMMENT '잠금회수' ; ALTER TABLE `COMTNEMPLYRINFO` CHANGE `LOCK_LAST_PNTTM` `LOCK_LAST_PNTTM` datetime NULL COMMENT '잠금최종시점' ; ALTER TABLE `COMTNEMPLYRSCRTYESTBS` CHANGE `AUTHOR_CODE` `AUTHOR_CODE` varchar(30) NOT NULL COMMENT '권한코드' ; ALTER TABLE `COMTNEMPLYRSCRTYESTBS` CHANGE `MBER_TY_CODE` `MBER_TY_CODE` char(5) DEFAULT NULL COMMENT '회원유형코드' ; ALTER TABLE `COMTNEMPLYRSCRTYESTBS` CHANGE `SCRTY_DTRMN_TRGET_ID` `SCRTY_DTRMN_TRGET_ID` varchar(20) NOT NULL COMMENT '보안설정대상ID' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ADRES` `ADRES` varchar(100) NOT NULL COMMENT '주소' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `APPLCNT_EMAIL_ADRES` `APPLCNT_EMAIL_ADRES` varchar(50) NOT NULL COMMENT '신청자이메일주소' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `APPLCNT_IHIDNUM` `APPLCNT_IHIDNUM` varchar(200) DEFAULT NULL COMMENT '신청인주민등록번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `APPLCNT_NM` `APPLCNT_NM` varchar(50) NOT NULL COMMENT '신청인명' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `AREA_NO` `AREA_NO` varchar(4) NOT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `BIZRNO` `BIZRNO` varchar(10) DEFAULT NULL COMMENT '사업자등록번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `CMPNY_NM` `CMPNY_NM` varchar(60) NOT NULL COMMENT '회사명' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `CXFC` `CXFC` varchar(50) DEFAULT NULL COMMENT '대표이사' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `DETAIL_ADRES` `DETAIL_ADRES` varchar(100) DEFAULT NULL COMMENT '상세주소' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_END_TELNO` `ENTRPRS_END_TELNO` varchar(4) NOT NULL COMMENT '기업끝전화번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_MBER_ID` `ENTRPRS_MBER_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '기업회원ID' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_MBER_PASSWORD_CNSR` `ENTRPRS_MBER_PASSWORD_CNSR` varchar(100) NOT NULL COMMENT '기업회원비밀번호정답' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_MBER_PASSWORD_HINT` `ENTRPRS_MBER_PASSWORD_HINT` varchar(100) NOT NULL COMMENT '기업회원비밀번호힌트' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_MBER_PASSWORD` `ENTRPRS_MBER_PASSWORD` varchar(200) DEFAULT NULL COMMENT '기업회원비밀번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_MBER_STTUS` `ENTRPRS_MBER_STTUS` varchar(15) DEFAULT NULL COMMENT '기업회원상태' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_MIDDLE_TELNO` `ENTRPRS_MIDDLE_TELNO` varchar(4) NOT NULL COMMENT '기업중간전화번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ENTRPRS_SE_CODE` `ENTRPRS_SE_CODE` char(8) DEFAULT NULL COMMENT '기업구분코드' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ESNTL_ID` `ESNTL_ID` char(20) NOT NULL COMMENT '고유ID' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `FXNUM` `FXNUM` varchar(20) DEFAULT NULL COMMENT '팩스번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `GROUP_ID` `GROUP_ID` char(20) COMMENT '그룹ID' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `INDUTY_CODE` `INDUTY_CODE` char(1) DEFAULT NULL COMMENT '업종코드' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `JURIRNO` `JURIRNO` varchar(13) DEFAULT NULL COMMENT '법인등록번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `SBSCRB_DE` `SBSCRB_DE` datetime DEFAULT NULL COMMENT '가입일자' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `ZIP` `ZIP` varchar(6) NOT NULL COMMENT '우편번호' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `LOCK_AT` `LOCK_AT` char(1) NULL COMMENT '잠금여부' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `LOCK_CNT` `LOCK_CNT` numeric(3) NULL COMMENT '잠금회수' ; ALTER TABLE `COMTNENTRPRSMBER` CHANGE `LOCK_LAST_PNTTM` `LOCK_LAST_PNTTM` datetime NULL COMMENT '잠금최종시점' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `APPLCNT_ID` `APPLCNT_ID` varchar(20) NOT NULL COMMENT '신청인ID' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `CONFM_AT` `CONFM_AT` char(1) DEFAULT NULL COMMENT '승인여부' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `EVENT_ID` `EVENT_ID` char(20) NOT NULL COMMENT '행사ID' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `INFRML_SANCTN_ID` `INFRML_SANCTN_ID` char(20) DEFAULT NULL COMMENT '약식결재ID' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `REQST_DE` `REQST_DE` char(20) NOT NULL COMMENT '신청일' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `RETURN_RESN` `RETURN_RESN` varchar(1000) DEFAULT NULL COMMENT '반환사유' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `SANCTN_DT` `SANCTN_DT` datetime DEFAULT NULL COMMENT '결재일시' ; ALTER TABLE `COMTNEVENTATDRN` CHANGE `SANCTNER_ID` `SANCTNER_ID` varchar(20) NOT NULL COMMENT '결재자ID' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `BSNS_CODE` `BSNS_CODE` varchar(2) DEFAULT NULL COMMENT '사업코드' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `BSNS_YEAR` `BSNS_YEAR` char(4) DEFAULT NULL COMMENT '사업년도' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `CHARGER_NM` `CHARGER_NM` varchar(50) DEFAULT NULL COMMENT '담당자명' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `EVENT_CN` `EVENT_CN` varchar(1000) DEFAULT NULL COMMENT '행사내용' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `EVENT_CONFM_AT` `EVENT_CONFM_AT` char(1) DEFAULT NULL COMMENT '행사승인여부' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `EVENT_CONFM_DE` `EVENT_CONFM_DE` char(20) DEFAULT NULL COMMENT '행사승인날짜' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `EVENT_ID` `EVENT_ID` char(20) NOT NULL COMMENT '행사ID' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `EVENT_SVC_BGNDE` `EVENT_SVC_BGNDE` char(20) DEFAULT NULL COMMENT '행사서비스시작일' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `EVENT_SVC_ENDDE` `EVENT_SVC_ENDDE` char(20) DEFAULT NULL COMMENT '행사서비스종료일' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `EVENT_TY_CODE` `EVENT_TY_CODE` char(1) DEFAULT NULL COMMENT '행사유형코드' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `PRPARETG_CN` `PRPARETG_CN` varchar(2500) DEFAULT NULL COMMENT '준비물내용' ; ALTER TABLE `COMTNEVENTINFO` CHANGE `SVC_USE_NMPR_CO` `SVC_USE_NMPR_CO` decimal(10,0) DEFAULT NULL COMMENT '서비스사용인원수' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `CT_OCCRRNC_AT` `CT_OCCRRNC_AT` char(1) DEFAULT NULL COMMENT '비용발생여부' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_AUSPC_INSTT_NM` `EVENT_AUSPC_INSTT_NM` varchar(60) DEFAULT NULL COMMENT '행사주최기관명' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_BGNDE` `EVENT_BGNDE` char(20) NOT NULL COMMENT '행사시작일' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_CN` `EVENT_CN` varchar(1000) DEFAULT NULL COMMENT '행사내용' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_ENDDE` `EVENT_ENDDE` char(20) NOT NULL COMMENT '행사종료일' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_ID` `EVENT_ID` char(20) NOT NULL COMMENT '행사ID' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_MNGT_INSTT_NM` `EVENT_MNGT_INSTT_NM` varchar(60) DEFAULT NULL COMMENT '행사주관기관명' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_NM` `EVENT_NM` varchar(60) NOT NULL COMMENT '행사명' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_PLACE` `EVENT_PLACE` varchar(200) NOT NULL COMMENT '행사장소' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_PURPS` `EVENT_PURPS` varchar(200) NOT NULL COMMENT '행사목적' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `EVENT_SE` `EVENT_SE` varchar(2) NOT NULL COMMENT '행사구분' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `PARTCPT_CT` `PARTCPT_CT` decimal(16,0) DEFAULT NULL COMMENT '참가비용' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `PSNCPA` `PSNCPA` decimal(10,0) NOT NULL COMMENT '정원' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `RCEPT_BGNDE` `RCEPT_BGNDE` char(20) NOT NULL COMMENT '접수시작일' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `RCEPT_ENDDE` `RCEPT_ENDDE` char(20) NOT NULL COMMENT '접수종료일' ; ALTER TABLE `COMTNEVENTMANAGE` CHANGE `REFRN_URL` `REFRN_URL` varchar(1024) DEFAULT NULL COMMENT '참조URL' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `AREA_NO` `AREA_NO` varchar(4) DEFAULT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `BRTHDY` `BRTHDY` char(20) DEFAULT NULL COMMENT '생일' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `EMAIL_ADRES` `EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '이메일주소' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `END_TELNO` `END_TELNO` varchar(4) DEFAULT NULL COMMENT '끝전화번호' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `EVENT_ID` `EVENT_ID` char(20) NOT NULL COMMENT '행사ID' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `EXTRL_HR_ID` `EXTRL_HR_ID` char(20) NOT NULL COMMENT '외부인사ID' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `EXTRL_HR_NM` `EXTRL_HR_NM` varchar(60) DEFAULT NULL COMMENT '외부인사명' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `MIDDLE_TELNO` `MIDDLE_TELNO` varchar(4) DEFAULT NULL COMMENT '중간전화번호' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `OCCP_TY_CODE` `OCCP_TY_CODE` char(1) DEFAULT NULL COMMENT '직업유형코드' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `PSITN_INSTT_NM` `PSITN_INSTT_NM` varchar(100) DEFAULT NULL COMMENT '소속기관명' ; ALTER TABLE `COMTNEXTRLHRINFO` CHANGE `SEXDSTN_CODE` `SEXDSTN_CODE` char(1) DEFAULT NULL COMMENT '성별코드' ; ALTER TABLE `COMTNFAQINFO` CHANGE `ANSWER_CN` `ANSWER_CN` varchar(2500) DEFAULT NULL COMMENT '답변내용' ; ALTER TABLE `COMTNFAQINFO` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) COMMENT '첨부파일ID' ; ALTER TABLE `COMTNFAQINFO` CHANGE `FAQ_ID` `FAQ_ID` char(20) NOT NULL COMMENT 'FAQID' ; ALTER TABLE `COMTNFAQINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNFAQINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNFAQINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNFAQINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) NOT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNFAQINFO` CHANGE `QESTN_CN` `QESTN_CN` varchar(2500) DEFAULT NULL COMMENT '질문내용' ; ALTER TABLE `COMTNFAQINFO` CHANGE `QESTN_SJ` `QESTN_SJ` varchar(255) DEFAULT NULL COMMENT '질문제목' ; ALTER TABLE `COMTNFAQINFO` CHANGE `QNA_PROCESS_STTUS_CODE` `QNA_PROCESS_STTUS_CODE` char(1) DEFAULT NULL COMMENT '질의응답처리상태코드' ; ALTER TABLE `COMTNFAQINFO` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTNFILE` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) NOT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNFILE` CHANGE `CREAT_DT` `CREAT_DT` datetime NOT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNFILE` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) NOT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `FILE_CN` `FILE_CN` mediumtext DEFAULT NULL COMMENT '파일내용' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `FILE_EXTSN` `FILE_EXTSN` varchar(20) NOT NULL COMMENT '파일확장자' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `FILE_SIZE` `FILE_SIZE` decimal(8,0) DEFAULT NULL COMMENT '파일크기' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `FILE_SN` `FILE_SN` decimal(10,0) NOT NULL COMMENT '파일순번' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `FILE_STRE_COURS` `FILE_STRE_COURS` varchar(2000) NOT NULL COMMENT '파일저장경로' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `ORIGNL_FILE_NM` `ORIGNL_FILE_NM` varchar(255) DEFAULT NULL COMMENT '원파일명' ; ALTER TABLE `COMTNFILEDETAIL` CHANGE `STRE_FILE_NM` `STRE_FILE_NM` varchar(255) NOT NULL COMMENT '저장파일명' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FILE_SYS_ID` `FILE_SYS_ID` char(20) NOT NULL COMMENT '파일시스템ID' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FILE_SYS_MANAGE_NM` `FILE_SYS_MANAGE_NM` varchar(255) NOT NULL COMMENT '파일시스템관리명' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FILE_SYS_NM` `FILE_SYS_NM` varchar(60) NOT NULL COMMENT '파일시스템명' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FILE_SYS_SIZE` `FILE_SYS_SIZE` decimal(8,0) NOT NULL COMMENT '파일시스템크기' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FILE_SYS_THRHLD` `FILE_SYS_THRHLD` decimal(8,0) NOT NULL COMMENT '파일시스템임계치' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FILE_SYS_USGQTY` `FILE_SYS_USGQTY` decimal(8,0) DEFAULT NULL COMMENT '파일시스템사용량' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTNFILESYSMNTRNG` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FILE_SYS_ID` `FILE_SYS_ID` char(20) NOT NULL COMMENT '파일시스템ID' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FILE_SYS_MANAGE_NM` `FILE_SYS_MANAGE_NM` varchar(255) NOT NULL COMMENT '파일시스템관리명' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FILE_SYS_NM` `FILE_SYS_NM` varchar(60) NOT NULL COMMENT '파일시스템명' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FILE_SYS_SIZE` `FILE_SYS_SIZE` decimal(8,0) NOT NULL COMMENT '파일시스템크기' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FILE_SYS_THRHLD` `FILE_SYS_THRHLD` decimal(8,0) NOT NULL COMMENT '파일시스템임계치' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FILE_SYS_USGQTY` `FILE_SYS_USGQTY` decimal(8,0) DEFAULT NULL COMMENT '파일시스템사용량' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL DEFAULT '' COMMENT '로그ID' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `LOG_INFO` `LOG_INFO` varchar(2000) DEFAULT NULL COMMENT '로그정보' ; ALTER TABLE `COMTNFILESYSMNTRNGLOGINFO` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTNFXTRSMANAGE` CHANGE `FXTRS_CODE` `FXTRS_CODE` char(14) NOT NULL COMMENT '비품코드' ; ALTER TABLE `COMTNFXTRSMANAGE` CHANGE `FXTRS_NM` `FXTRS_NM` varchar(100) NOT NULL COMMENT '비품명' ; ALTER TABLE `COMTNFXTRSMANAGE` CHANGE `MAKR_NM` `MAKR_NM` varchar(100) DEFAULT NULL COMMENT '제작자명' ; ALTER TABLE `COMTNFXTRSMANAGE` CHANGE `PRICE` `PRICE` decimal(16,0) DEFAULT NULL COMMENT '가격' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `ADRES` `ADRES` varchar(100) NOT NULL COMMENT '주소' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `AREA_NO` `AREA_NO` varchar(4) NOT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `DETAIL_ADRES` `DETAIL_ADRES` varchar(100) DEFAULT NULL COMMENT '상세주소' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `END_TELNO` `END_TELNO` varchar(4) NOT NULL COMMENT '끝전화번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `ESNTL_ID` `ESNTL_ID` char(20) NOT NULL COMMENT '고유ID' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `GROUP_ID` `GROUP_ID` char(20) COMMENT '그룹ID' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `IHIDNUM` `IHIDNUM` varchar(200) DEFAULT NULL COMMENT '주민등록번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `MBER_EMAIL_ADRES` `MBER_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '회원이메일주소' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `MBER_FXNUM` `MBER_FXNUM` varchar(20) DEFAULT NULL COMMENT '회원팩스번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `MBER_ID` `MBER_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '회원ID' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `MBER_NM` `MBER_NM` varchar(50) NOT NULL COMMENT '회원명' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `MBER_STTUS` `MBER_STTUS` varchar(15) DEFAULT NULL COMMENT '회원상태' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `MBTLNUM` `MBTLNUM` varchar(20) NOT NULL COMMENT '이동전화번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `MIDDLE_TELNO` `MIDDLE_TELNO` varchar(4) NOT NULL COMMENT '중간전화번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `PASSWORD_CNSR` `PASSWORD_CNSR` varchar(100) DEFAULT NULL COMMENT '비밀번호정답' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `PASSWORD_HINT` `PASSWORD_HINT` varchar(100) DEFAULT NULL COMMENT '비밀번호힌트' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `PASSWORD` `PASSWORD` varchar(200) NOT NULL COMMENT '비밀번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `SBSCRB_DE` `SBSCRB_DE` datetime DEFAULT NULL COMMENT '가입일자' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `SEXDSTN_CODE` `SEXDSTN_CODE` char(1) DEFAULT NULL COMMENT '성별코드' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `ZIP` `ZIP` varchar(6) NOT NULL COMMENT '우편번호' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `LOCK_AT` `LOCK_AT` char(1) NULL COMMENT '잠금여부' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `LOCK_CNT` `LOCK_CNT` numeric(3) NULL COMMENT '잠금회수' ; ALTER TABLE `COMTNGNRLMBER` CHANGE `LOCK_LAST_PNTTM` `LOCK_LAST_PNTTM` datetime NULL COMMENT '잠금최종시점' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `HPCM_DC` `HPCM_DC` varchar(2500) DEFAULT NULL COMMENT '도움말설명' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `HPCM_DFN` `HPCM_DFN` varchar(1000) DEFAULT NULL COMMENT '도움말정의' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `HPCM_ID` `HPCM_ID` char(20) NOT NULL COMMENT '도움말ID' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `HPCM_SE_CODE` `HPCM_SE_CODE` char(1) DEFAULT NULL COMMENT '도움말구분코드' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNHPCMINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNHTTPMON` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNHTTPMON` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNHTTPMON` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNHTTPMON` CHANGE `HTTP_STTUS_CODE` `HTTP_STTUS_CODE` varchar(3) DEFAULT NULL COMMENT 'HTTP상태코드' ; ALTER TABLE `COMTNHTTPMON` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNHTTPMON` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNHTTPMON` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNHTTPMON` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTNHTTPMON` CHANGE `SITE_URL` `SITE_URL` varchar(100) DEFAULT NULL COMMENT '사이트URL' ; ALTER TABLE `COMTNHTTPMON` CHANGE `SYS_ID` `SYS_ID` varchar(20) NOT NULL COMMENT '시스템ID' ; ALTER TABLE `COMTNHTTPMON` CHANGE `WEBSVC_KND` `WEBSVC_KND` varchar(10) DEFAULT NULL COMMENT '웹서비스종류' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `INDVDL_INFO_POLICY_AGRE_AT` `INDVDL_INFO_POLICY_AGRE_AT` char(1) DEFAULT NULL COMMENT '개인정보정책동의여부' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `INDVDL_INFO_POLICY_CN` `INDVDL_INFO_POLICY_CN` varchar(2500) DEFAULT NULL COMMENT '개인정보정책내용' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `INDVDL_INFO_POLICY_ID` `INDVDL_INFO_POLICY_ID` char(20) NOT NULL DEFAULT '' COMMENT '개인정보정책ID' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `INDVDL_INFO_POLICY_NM` `INDVDL_INFO_POLICY_NM` varchar(255) DEFAULT NULL COMMENT '개인정보정책명' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNINDVDLINFOPOLICY` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNINDVDLPGECNTNTS` CHANGE `CNTC_URL` `CNTC_URL` varchar(255) NOT NULL COMMENT '연계URL' ; ALTER TABLE `COMTNINDVDLPGECNTNTS` CHANGE `CNTNTS_DC` `CNTNTS_DC` varchar(250) DEFAULT NULL COMMENT '컨텐츠설명' ; ALTER TABLE `COMTNINDVDLPGECNTNTS` CHANGE `CNTNTS_ID` `CNTNTS_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '컨텐츠ID' ; ALTER TABLE `COMTNINDVDLPGECNTNTS` CHANGE `CNTNTS_LINK_URL` `CNTNTS_LINK_URL` varchar(1000) DEFAULT NULL COMMENT '컨텐츠링크URL' ; ALTER TABLE `COMTNINDVDLPGECNTNTS` CHANGE `CNTNTS_NM` `CNTNTS_NM` varchar(100) NOT NULL COMMENT '컨텐츠명' ; ALTER TABLE `COMTNINDVDLPGECNTNTS` CHANGE `CNTNTS_USE_AT` `CNTNTS_USE_AT` char(1) NOT NULL COMMENT '컨텐츠사용여부' ; ALTER TABLE `COMTNINDVDLPGEESTBS` CHANGE `ALGN_CO` `ALGN_CO` decimal(10,0) DEFAULT NULL COMMENT '배열개수' ; ALTER TABLE `COMTNINDVDLPGEESTBS` CHANGE `ALGN_MTHD` `ALGN_MTHD` char(1) DEFAULT NULL COMMENT '배열방식' ; ALTER TABLE `COMTNINDVDLPGEESTBS` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '업무사용자ID' ; ALTER TABLE `COMTNINDVDLPGEESTBS` CHANGE `TITLEBAR_COLOR` `TITLEBAR_COLOR` char(7) DEFAULT NULL COMMENT '타이틀바색상' ; ALTER TABLE `COMTNINDVDLPGEESTBS` CHANGE `UPEND_IMAGE` `UPEND_IMAGE` varchar(1024) DEFAULT NULL COMMENT '상단이미지' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `OCCRRNC_YEAR` `OCCRRNC_YEAR` char(4) NOT NULL COMMENT '발생년도' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `REMNDR_YRYC_CO` `REMNDR_YRYC_CO` decimal(5,1) DEFAULT NULL COMMENT '잔여연차개수' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `USE_YRYC_CO` `USE_YRYC_CO` decimal(5,1) DEFAULT NULL COMMENT '사용연차개수' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `USER_ID` `USER_ID` varchar(20) NOT NULL COMMENT '사용자ID' ; ALTER TABLE `COMTNINDVDLYRYCMANAGE` CHANGE `YRYC_OCCRRNC_CO` `YRYC_OCCRRNC_CO` decimal(5,1) DEFAULT NULL COMMENT '연차발생개수' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `APPLCNT_ID` `APPLCNT_ID` varchar(20) NOT NULL COMMENT '신청인ID' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `CONFM_AT` `CONFM_AT` char(1) NOT NULL COMMENT '승인여부' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `INFRML_SANCTN_ID` `INFRML_SANCTN_ID` char(20) NOT NULL COMMENT '약식결재ID' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `JOB_SE_CODE` `JOB_SE_CODE` char(3) NOT NULL COMMENT '업무구분코드' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `REQST_DE` `REQST_DE` char(20) NOT NULL COMMENT '신청일' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `RETURN_RESN` `RETURN_RESN` varchar(1000) DEFAULT NULL COMMENT '반환사유' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `SANCTN_DT` `SANCTN_DT` datetime DEFAULT NULL COMMENT '결재일시' ; ALTER TABLE `COMTNINFRMLSANCTN` CHANGE `SANCTNER_ID` `SANCTNER_ID` varchar(20) NOT NULL COMMENT '결재자ID' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `ABL_DE` `ABL_DE` char(20) DEFAULT NULL COMMENT '폐지일' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `ABL_ENNC` `ABL_ENNC` char(1) DEFAULT NULL COMMENT '폐지유무' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `ALL_INSTT_NM` `ALL_INSTT_NM` varchar(255) DEFAULT NULL COMMENT '전체기관명' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `BEST_INSTT_CODE` `BEST_INSTT_CODE` char(7) DEFAULT NULL COMMENT '최상위기관코드' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `BSIS_DE` `BSIS_DE` char(20) DEFAULT NULL COMMENT '기초일' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `CHANGE_DE` `CHANGE_DE` char(20) DEFAULT NULL COMMENT '변경일' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `CHANGE_TIME` `CHANGE_TIME` varchar(6) DEFAULT NULL COMMENT '변경시간' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `CREAT_DE` `CREAT_DE` char(20) DEFAULT NULL COMMENT '생성일' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `FXNUM` `FXNUM` varchar(20) DEFAULT NULL COMMENT '팩스번호' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `INSTT_ABRV_NM` `INSTT_ABRV_NM` varchar(50) DEFAULT NULL COMMENT '기관약어명' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `INSTT_CODE` `INSTT_CODE` char(7) NOT NULL COMMENT '기관코드' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `INSTT_ODR` `INSTT_ODR` char(2) DEFAULT NULL COMMENT '기관차수' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `INSTT_TY_LCLAS` `INSTT_TY_LCLAS` char(2) DEFAULT NULL COMMENT '기관유형대분류' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `INSTT_TY_MLSFC` `INSTT_TY_MLSFC` char(2) DEFAULT NULL COMMENT '기관유형중분류' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `INSTT_TY_SCLAS` `INSTT_TY_SCLAS` char(2) DEFAULT NULL COMMENT '기관유형소분류' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `LOWEST_INSTT_NM` `LOWEST_INSTT_NM` varchar(100) DEFAULT NULL COMMENT '최하위기관명' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `ODR` `ODR` char(1) DEFAULT NULL COMMENT '차수' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `ORD` `ORD` char(3) DEFAULT NULL COMMENT '서열' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `REPRSNT_INSTT_CODE` `REPRSNT_INSTT_CODE` char(7) DEFAULT NULL COMMENT '대표기관코드' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `SORT_ORDR` `SORT_ORDR` decimal(8,0) DEFAULT NULL COMMENT '정렬순서' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `TELNO` `TELNO` varchar(20) DEFAULT NULL COMMENT '전화번호' ; ALTER TABLE `COMTNINSTTCODE` CHANGE `UPPER_INSTT_CODE` `UPPER_INSTT_CODE` char(7) DEFAULT NULL COMMENT '상위기관코드' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `ABL_DE` `ABL_DE` char(20) DEFAULT NULL COMMENT '폐지일' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `ABL_ENNC` `ABL_ENNC` char(1) DEFAULT NULL COMMENT '폐지유무' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `ALL_INSTT_NM` `ALL_INSTT_NM` varchar(255) DEFAULT NULL COMMENT '전체기관명' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `BEST_INSTT_CODE` `BEST_INSTT_CODE` char(7) DEFAULT NULL COMMENT '최상위기관코드' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `BSIS_DE` `BSIS_DE` char(20) DEFAULT NULL COMMENT '기초일' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `CHANGE_DE` `CHANGE_DE` char(20) DEFAULT NULL COMMENT '변경일' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `CHANGE_SE_CODE` `CHANGE_SE_CODE` varchar(2) DEFAULT NULL COMMENT '변경구분코드' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `CHANGE_TIME` `CHANGE_TIME` varchar(6) DEFAULT NULL COMMENT '변경시간' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `CREAT_DE` `CREAT_DE` char(20) DEFAULT NULL COMMENT '생성일' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `ETC_CODE` `ETC_CODE` char(2) DEFAULT NULL COMMENT '기타코드' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `FXNUM` `FXNUM` varchar(20) DEFAULT NULL COMMENT '팩스번호' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `INSTT_ABRV_NM` `INSTT_ABRV_NM` varchar(50) DEFAULT NULL COMMENT '기관약어명' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `INSTT_CODE` `INSTT_CODE` char(7) NOT NULL COMMENT '기관코드' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `INSTT_ODR` `INSTT_ODR` char(2) DEFAULT NULL COMMENT '기관차수' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `INSTT_TY_LCLAS` `INSTT_TY_LCLAS` char(2) DEFAULT NULL COMMENT '기관유형대분류' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `INSTT_TY_MLSFC` `INSTT_TY_MLSFC` char(2) DEFAULT NULL COMMENT '기관유형중분류' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `INSTT_TY_SCLAS` `INSTT_TY_SCLAS` char(2) DEFAULT NULL COMMENT '기관유형소분류' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `LOWEST_INSTT_NM` `LOWEST_INSTT_NM` varchar(100) DEFAULT NULL COMMENT '최하위기관명' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(20) NOT NULL COMMENT '발생일' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `ODR` `ODR` char(1) DEFAULT NULL COMMENT '차수' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `OPERT_SN` `OPERT_SN` decimal(10,0) NOT NULL COMMENT '작업일련번호' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `ORD` `ORD` char(3) DEFAULT NULL COMMENT '서열' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `PROCESS_SE` `PROCESS_SE` varchar(2) DEFAULT NULL COMMENT '처리구분' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `REPRSNT_INSTT_CODE` `REPRSNT_INSTT_CODE` char(7) DEFAULT NULL COMMENT '대표기관코드' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `SORT_ORDR` `SORT_ORDR` decimal(8,0) DEFAULT NULL COMMENT '정렬순서' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `TELNO` `TELNO` varchar(20) DEFAULT NULL COMMENT '전화번호' ; ALTER TABLE `COMTNINSTTCODERECPTNLOG` CHANGE `UPPER_INSTT_CODE` `UPPER_INSTT_CODE` char(7) DEFAULT NULL COMMENT '상위기관코드' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `INTNET_SVC_DC` `INTNET_SVC_DC` varchar(200) DEFAULT NULL COMMENT '인터넷서비스설명' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `INTNET_SVC_ID` `INTNET_SVC_ID` char(20) NOT NULL DEFAULT '' COMMENT '인터넷서비스ID' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `INTNET_SVC_NM` `INTNET_SVC_NM` varchar(20) NOT NULL COMMENT '인터넷서비스명' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNINTNETSVC` CHANGE `REFLCT_AT` `REFLCT_AT` char(1) NOT NULL COMMENT '반영여부' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `LEADER_ID` `LEADER_ID` varchar(20) NOT NULL COMMENT '간부ID' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `REPTIT_SE_CODE` `REPTIT_SE_CODE` char(1) DEFAULT NULL COMMENT '반복구분코드' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_BGNDE` `SCHDUL_BGNDE` char(20) DEFAULT NULL COMMENT '일정시작일' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_CHARGER_ID` `SCHDUL_CHARGER_ID` varchar(20) NOT NULL COMMENT '일정담당자ID' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_CN` `SCHDUL_CN` varchar(2500) NOT NULL COMMENT '일정내용' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_ENDDE` `SCHDUL_ENDDE` char(20) DEFAULT NULL COMMENT '일정종료일' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_ID` `SCHDUL_ID` char(20) NOT NULL COMMENT '일정ID' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_NM` `SCHDUL_NM` varchar(255) NOT NULL COMMENT '일정명' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_PLACE` `SCHDUL_PLACE` varchar(255) DEFAULT NULL COMMENT '일정장소' ; ALTER TABLE `COMTNLEADERSCHDUL` CHANGE `SCHDUL_SE` `SCHDUL_SE` char(1) DEFAULT NULL COMMENT '일정구분' ; ALTER TABLE `COMTNLEADERSCHDULDE` CHANGE `SCHDUL_DE` `SCHDUL_DE` char(8) NOT NULL COMMENT '일정일' ; ALTER TABLE `COMTNLEADERSCHDULDE` CHANGE `SCHDUL_ID` `SCHDUL_ID` char(20) NOT NULL COMMENT '일정ID' ; ALTER TABLE `COMTNLEADERSTTUS` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록자시점' ; ALTER TABLE `COMTNLEADERSTTUS` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNLEADERSTTUS` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종등록자시점' ; ALTER TABLE `COMTNLEADERSTTUS` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNLEADERSTTUS` CHANGE `LEADER_ID` `LEADER_ID` varchar(20) NOT NULL COMMENT '간부ID' ; ALTER TABLE `COMTNLEADERSTTUS` CHANGE `LEADER_STTUS` `LEADER_STTUS` char(1) NOT NULL COMMENT '간부상태' ; ALTER TABLE `COMTNLOGINLOG` CHANGE `CONECT_ID` `CONECT_ID` varchar(20) DEFAULT NULL COMMENT '접속ID' ; ALTER TABLE `COMTNLOGINLOG` CHANGE `CONECT_IP` `CONECT_IP` varchar(23) DEFAULT NULL COMMENT '접속IP' ; ALTER TABLE `COMTNLOGINLOG` CHANGE `CONECT_MTHD` `CONECT_MTHD` char(4) DEFAULT NULL COMMENT '접속방식' ; ALTER TABLE `COMTNLOGINLOG` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNLOGINLOG` CHANGE `ERROR_CODE` `ERROR_CODE` char(3) DEFAULT NULL COMMENT '오류코드' ; ALTER TABLE `COMTNLOGINLOG` CHANGE `ERROR_OCCRRNC_AT` `ERROR_OCCRRNC_AT` char(1) DEFAULT NULL COMMENT '오류발생여부' ; ALTER TABLE `COMTNLOGINLOG` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL COMMENT '로그ID' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `DPLCT_PERM_AT` `DPLCT_PERM_AT` char(1) NOT NULL COMMENT '중복허용여부' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '업무사용자ID' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `IP_INFO` `IP_INFO` varchar(23) NOT NULL COMMENT 'IP정보' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNLOGINPOLICY` CHANGE `LMTT_AT` `LMTT_AT` char(1) NOT NULL COMMENT '제한여부' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `IMAGE_DC` `IMAGE_DC` varchar(200) DEFAULT NULL COMMENT '이미지설명' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `IMAGE_FILE` `IMAGE_FILE` varchar(60) DEFAULT NULL COMMENT '이미지파일' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `IMAGE_ID` `IMAGE_ID` char(20) NOT NULL DEFAULT '' COMMENT '이미지ID' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `IMAGE_NM` `IMAGE_NM` varchar(20) NOT NULL COMMENT '이미지명' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `IMAGE` `IMAGE` varchar(60) NOT NULL COMMENT '이미지' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNLOGINSCRINIMAGE` CHANGE `REFLCT_AT` `REFLCT_AT` char(1) NOT NULL COMMENT '반영여부' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `IMAGE_DC` `IMAGE_DC` varchar(200) DEFAULT NULL COMMENT '이미지설명' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `IMAGE_FILE` `IMAGE_FILE` varchar(60) DEFAULT NULL COMMENT '이미지파일' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `IMAGE_ID` `IMAGE_ID` char(20) NOT NULL DEFAULT '' COMMENT '이미지ID' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `IMAGE_NM` `IMAGE_NM` varchar(20) NOT NULL COMMENT '이미지명' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `IMAGE` `IMAGE` varchar(60) NOT NULL COMMENT '이미지' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNMAINIMAGE` CHANGE `REFLCT_AT` `REFLCT_AT` char(1) NOT NULL COMMENT '반영여부' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `DRCT_MATTER_REGIST_DT` `DRCT_MATTER_REGIST_DT` varchar(14) DEFAULT NULL COMMENT '지시사항등록일시' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `DRCT_MATTER` `DRCT_MATTER` varchar(2500) DEFAULT NULL COMMENT '지시사항' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `REPORT_CN` `REPORT_CN` varchar(2500) NOT NULL COMMENT '보고내용' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `REPORT_DE` `REPORT_DE` char(20) NOT NULL COMMENT '보고일' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `REPORTR_ID` `REPORTR_ID` varchar(20) NOT NULL COMMENT '보고자ID' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `REPORTR_INQIRE_DT` `REPORTR_INQIRE_DT` varchar(14) DEFAULT NULL COMMENT '보고자조회일시' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `REPRT_ID` `REPRT_ID` char(6) NOT NULL DEFAULT '' COMMENT '보고서ID' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `REPRT_SJ` `REPRT_SJ` varchar(255) NOT NULL COMMENT '보고서제목' ; ALTER TABLE `COMTNMEMOREPRT` CHANGE `WRTER_ID` `WRTER_ID` varchar(20) NOT NULL COMMENT '작성자ID' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `TODO_BEGIN_TIME` `TODO_BEGIN_TIME` varchar(14) NOT NULL COMMENT '할일시작시간' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `TODO_CN` `TODO_CN` varchar(2500) NOT NULL COMMENT '할일내용' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `TODO_END_TIME` `TODO_END_TIME` varchar(14) NOT NULL COMMENT '할일종료시간' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `TODO_ID` `TODO_ID` char(20) NOT NULL COMMENT '할일ID' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `TODO_SJ` `TODO_SJ` varchar(255) NOT NULL COMMENT '할일제목' ; ALTER TABLE `COMTNMEMOTODO` CHANGE `WRTER_ID` `WRTER_ID` varchar(20) NOT NULL COMMENT '작성자ID' ; ALTER TABLE `COMTNMENUCREATDTLS` CHANGE `AUTHOR_CODE` `AUTHOR_CODE` varchar(30) NOT NULL COMMENT '권한코드' ; ALTER TABLE `COMTNMENUCREATDTLS` CHANGE `MAPNG_CREAT_ID` `MAPNG_CREAT_ID` varchar(30) COMMENT '매핑생성ID' ; ALTER TABLE `COMTNMENUCREATDTLS` CHANGE `MENU_NO` `MENU_NO` decimal(20,0) NOT NULL COMMENT '메뉴번호' ; ALTER TABLE `COMTNMENUINFO` CHANGE `MENU_DC` `MENU_DC` varchar(250) DEFAULT NULL COMMENT '메뉴설명' ; ALTER TABLE `COMTNMENUINFO` CHANGE `MENU_NM` `MENU_NM` varchar(60) NOT NULL COMMENT '메뉴명' ; ALTER TABLE `COMTNMENUINFO` CHANGE `MENU_NO` `MENU_NO` decimal(20,0) NOT NULL COMMENT '메뉴번호' ; ALTER TABLE `COMTNMENUINFO` CHANGE `MENU_ORDR` `MENU_ORDR` decimal(5,0) NOT NULL COMMENT '메뉴순서' ; ALTER TABLE `COMTNMENUINFO` CHANGE `PROGRM_FILE_NM` `PROGRM_FILE_NM` varchar(60) NOT NULL COMMENT '프로그램파일명' ; ALTER TABLE `COMTNMENUINFO` CHANGE `RELATE_IMAGE_NM` `RELATE_IMAGE_NM` varchar(60) DEFAULT NULL COMMENT '관계이미지명' ; ALTER TABLE `COMTNMENUINFO` CHANGE `RELATE_IMAGE_PATH` `RELATE_IMAGE_PATH` varchar(100) DEFAULT NULL COMMENT '관계이미지경로' ; ALTER TABLE `COMTNMENUINFO` CHANGE `UPPER_MENU_NO` `UPPER_MENU_NO` decimal(20,0) COMMENT '상위메뉴번호' ; ALTER TABLE `COMTNMTGINFO` CHANGE `ATDRN_CO` `ATDRN_CO` decimal(10,0) DEFAULT NULL COMMENT '참석자수' ; ALTER TABLE `COMTNMTGINFO` CHANGE `CLSDR_MTG_AT` `CLSDR_MTG_AT` char(1) DEFAULT NULL COMMENT '비공개회의여부' ; ALTER TABLE `COMTNMTGINFO` CHANGE `ETC_MATTER` `ETC_MATTER` varchar(1000) DEFAULT NULL COMMENT '기타사항' ; ALTER TABLE `COMTNMTGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNMTGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNMTGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNMTGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MNAER_DEPT_ID` `MNAER_DEPT_ID` varchar(20) DEFAULT NULL COMMENT '주관자부서ID' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MNAER_ID` `MNAER_ID` varchar(20) DEFAULT NULL COMMENT '주관자ID' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MNGT_DEPT_ID` `MNGT_DEPT_ID` varchar(20) DEFAULT NULL COMMENT '주관부서ID' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_AT` `MTG_AT` char(1) DEFAULT NULL COMMENT '회의여부' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_BEGIN_TM` `MTG_BEGIN_TM` varchar(14) DEFAULT NULL COMMENT '회의시작시간' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_CO` `MTG_CO` decimal(5,0) DEFAULT NULL COMMENT '회의수' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_DE` `MTG_DE` char(20) DEFAULT NULL COMMENT '회의일' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_END_TM` `MTG_END_TM` varchar(14) DEFAULT NULL COMMENT '회의종료시간' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_ID` `MTG_ID` char(20) NOT NULL COMMENT '회의ID' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_MTR_CN` `MTG_MTR_CN` varchar(1000) DEFAULT NULL COMMENT '회의안건내용' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_NM` `MTG_NM` varchar(255) DEFAULT NULL COMMENT '회의명' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_PLACE` `MTG_PLACE` varchar(255) DEFAULT NULL COMMENT '회의장소' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_RESULT_CN` `MTG_RESULT_CN` varchar(1000) DEFAULT NULL COMMENT '회의결과내용' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_RESULT_ENNC` `MTG_RESULT_ENNC` char(1) DEFAULT NULL COMMENT '회의결과유무' ; ALTER TABLE `COMTNMTGINFO` CHANGE `MTG_SN` `MTG_SN` decimal(10,0) DEFAULT NULL COMMENT '회의순번' ; ALTER TABLE `COMTNMTGINFO` CHANGE `NONATDRN_CO` `NONATDRN_CO` decimal(10,0) DEFAULT NULL COMMENT '불참자수' ; ALTER TABLE `COMTNMTGINFO` CHANGE `READNG_AT` `READNG_AT` char(1) DEFAULT NULL COMMENT '열람여부' ; ALTER TABLE `COMTNMTGINFO` CHANGE `READNG_BGNDE` `READNG_BGNDE` char(20) DEFAULT NULL COMMENT '열람개시일' ; ALTER TABLE `COMTNMTGPLACEFXTRS` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNMTGPLACEFXTRS` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNMTGPLACEFXTRS` CHANGE `FXTRS_CODE` `FXTRS_CODE` char(14) NOT NULL COMMENT '비품코드' ; ALTER TABLE `COMTNMTGPLACEFXTRS` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNMTGPLACEFXTRS` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNMTGPLACEFXTRS` CHANGE `MTGRUM_ID` `MTGRUM_ID` char(20) NOT NULL COMMENT '회의실ID' ; ALTER TABLE `COMTNMTGPLACEFXTRS` CHANGE `QY` `QY` decimal(20,0) NOT NULL COMMENT '량' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `ACEPTNC_POSBL_NMPR` `ACEPTNC_POSBL_NMPR` decimal(10,0) NOT NULL COMMENT '수용가능인원' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `LC_DETAIL` `LC_DETAIL` varchar(200) DEFAULT NULL COMMENT '위치상세' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `LC_SE` `LC_SE` char(5) DEFAULT NULL COMMENT '위치구분' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `MTGRUM_ID` `MTGRUM_ID` char(20) NOT NULL COMMENT '회의실ID' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `MTGRUM_NM` `MTGRUM_NM` varchar(255) NOT NULL COMMENT '회의실명' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `OPN_BEGIN_TM` `OPN_BEGIN_TM` varchar(6) NOT NULL COMMENT '개방시작시각' ; ALTER TABLE `COMTNMTGPLACEMANAGE` CHANGE `OPN_END_TM` `OPN_END_TM` varchar(6) NOT NULL COMMENT '개방종료시각' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `ATNDNC_NMPR` `ATNDNC_NMPR` decimal(10,0) DEFAULT NULL COMMENT '참석인원' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `MTG_CN` `MTG_CN` varchar(2500) DEFAULT NULL COMMENT '회의내용' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `MTG_SJ` `MTG_SJ` varchar(100) NOT NULL COMMENT '회의제목' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `MTGRUM_ID` `MTGRUM_ID` char(20) NOT NULL COMMENT '회의실ID' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `RESVE_BEGIN_TM` `RESVE_BEGIN_TM` varchar(14) NOT NULL COMMENT '예약시작시각' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `RESVE_DE` `RESVE_DE` char(8) NOT NULL COMMENT '예약일' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `RESVE_END_TM` `RESVE_END_TM` varchar(14) NOT NULL COMMENT '예약종료시각' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `RESVE_ID` `RESVE_ID` char(20) NOT NULL COMMENT '예약ID' ; ALTER TABLE `COMTNMTGPLACERESVE` CHANGE `RSVCTM_ID` `RSVCTM_ID` varchar(20) NOT NULL COMMENT '예약자ID' ; ALTER TABLE `COMTNNCRD` CHANGE `ADRES` `ADRES` varchar(100) DEFAULT NULL COMMENT '주소' ; ALTER TABLE `COMTNNCRD` CHANGE `AREA_NO` `AREA_NO` varchar(4) DEFAULT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNNCRD` CHANGE `CLSF_NM` `CLSF_NM` varchar(60) DEFAULT NULL COMMENT '직급명' ; ALTER TABLE `COMTNNCRD` CHANGE `CMPNY_NM` `CMPNY_NM` varchar(60) DEFAULT NULL COMMENT '회사명' ; ALTER TABLE `COMTNNCRD` CHANGE `DEPT_NM` `DEPT_NM` varchar(60) DEFAULT NULL COMMENT '부서명' ; ALTER TABLE `COMTNNCRD` CHANGE `DETAIL_ADRES` `DETAIL_ADRES` varchar(100) DEFAULT NULL COMMENT '상세주소' ; ALTER TABLE `COMTNNCRD` CHANGE `EMAIL_ADRES` `EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '이메일주소' ; ALTER TABLE `COMTNNCRD` CHANGE `END_MBTLNUM` `END_MBTLNUM` varchar(4) DEFAULT NULL COMMENT '끝이동전화번호' ; ALTER TABLE `COMTNNCRD` CHANGE `END_TELNO` `END_TELNO` varchar(4) DEFAULT NULL COMMENT '끝전화번호' ; ALTER TABLE `COMTNNCRD` CHANGE `EXTRL_USER_AT` `EXTRL_USER_AT` char(1) DEFAULT NULL COMMENT '외부사용자여부' ; ALTER TABLE `COMTNNCRD` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNCRD` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNCRD` CHANGE `IDNTFC_NO` `IDNTFC_NO` varchar(10) DEFAULT NULL COMMENT '식별번호' ; ALTER TABLE `COMTNNCRD` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNCRD` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNCRD` CHANGE `MBTLNUM` `MBTLNUM` varchar(20) DEFAULT NULL COMMENT '이동전화번호' ; ALTER TABLE `COMTNNCRD` CHANGE `MIDDLE_MBTLNUM` `MIDDLE_MBTLNUM` varchar(4) DEFAULT NULL COMMENT '중간이동전화번호' ; ALTER TABLE `COMTNNCRD` CHANGE `MIDDLE_TELNO` `MIDDLE_TELNO` varchar(4) DEFAULT NULL COMMENT '중간전화번호' ; ALTER TABLE `COMTNNCRD` CHANGE `NATION_NO` `NATION_NO` varchar(10) DEFAULT NULL COMMENT '국가번호' ; ALTER TABLE `COMTNNCRD` CHANGE `NCRD_ID` `NCRD_ID` char(20) NOT NULL COMMENT '명함ID' ; ALTER TABLE `COMTNNCRD` CHANGE `NCRD_TRGTER_ID` `NCRD_TRGTER_ID` varchar(20) DEFAULT NULL COMMENT '명함대상자ID' ; ALTER TABLE `COMTNNCRD` CHANGE `NM` `NM` varchar(50) NOT NULL COMMENT '이름' ; ALTER TABLE `COMTNNCRD` CHANGE `OFCPS_NM` `OFCPS_NM` varchar(60) DEFAULT NULL COMMENT '직위명' ; ALTER TABLE `COMTNNCRD` CHANGE `OTHBC_AT` `OTHBC_AT` char(1) NOT NULL COMMENT '공개여부' ; ALTER TABLE `COMTNNCRD` CHANGE `RM` `RM` varchar(2500) DEFAULT NULL COMMENT '비고' ; ALTER TABLE `COMTNNCRD` CHANGE `TELNO` `TELNO` varchar(20) DEFAULT NULL COMMENT '전화번호' ; ALTER TABLE `COMTNNCRDUSER` CHANGE `CREAT_DT` `CREAT_DT` datetime NOT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNNCRDUSER` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '업무사용자ID' ; ALTER TABLE `COMTNNCRDUSER` CHANGE `NCRD_ID` `NCRD_ID` char(20) NOT NULL COMMENT '명함ID' ; ALTER TABLE `COMTNNCRDUSER` CHANGE `REGIST_SE_CODE` `REGIST_SE_CODE` char(6) NOT NULL COMMENT '등록구분코드' ; ALTER TABLE `COMTNNCRDUSER` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) COMMENT '첨부파일ID' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) NOT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `NEWS_CN` `NEWS_CN` varchar(2500) DEFAULT NULL COMMENT '뉴스내용' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `NEWS_ID` `NEWS_ID` char(20) NOT NULL COMMENT '뉴스ID' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `NEWS_ORIGIN` `NEWS_ORIGIN` varchar(250) DEFAULT NULL COMMENT '뉴스출처' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `NEWS_SJ` `NEWS_SJ` varchar(100) DEFAULT NULL COMMENT '뉴스제목' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `NTCE_AT` `NTCE_AT` char(1) DEFAULT NULL COMMENT '게시여부' ; ALTER TABLE `COMTNNEWSINFO` CHANGE `NTCE_DE` `NTCE_DE` char(20) DEFAULT NULL COMMENT '게시일' ; ALTER TABLE `COMTNNOTE` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNNOTE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNOTE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNOTE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNOTE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNOTE` CHANGE `NOTE_CN` `NOTE_CN` varchar(4000) DEFAULT NULL COMMENT '쪽지내용' ; ALTER TABLE `COMTNNOTE` CHANGE `NOTE_ID` `NOTE_ID` char(20) NOT NULL COMMENT '쪽지ID' ; ALTER TABLE `COMTNNOTE` CHANGE `NOTE_SJ` `NOTE_SJ` varchar(255) DEFAULT NULL COMMENT '쪽지제목' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `NOTE_ID` `NOTE_ID` char(20) NOT NULL COMMENT '쪽지ID' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `NOTE_RECPTN_ID` `NOTE_RECPTN_ID` char(20) NOT NULL COMMENT '쪽지수신ID' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `NOTE_TRNSMIT_ID` `NOTE_TRNSMIT_ID` char(20) NOT NULL COMMENT '쪽지송신ID' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `OPEN_YN` `OPEN_YN` char(1) DEFAULT NULL COMMENT '개봉여부' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `RCVER_ID` `RCVER_ID` char(20) DEFAULT NULL COMMENT '수신자ID' ; ALTER TABLE `COMTNNOTERECPTN` CHANGE `RECPTN_SE` `RECPTN_SE` char(1) DEFAULT NULL COMMENT '수신구분' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `DELETE_AT` `DELETE_AT` char(8) DEFAULT NULL COMMENT '삭제여부' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `NOTE_ID` `NOTE_ID` char(20) NOT NULL COMMENT '쪽지ID' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `NOTE_TRNSMIT_ID` `NOTE_TRNSMIT_ID` char(20) NOT NULL COMMENT '쪽지송신ID' ; ALTER TABLE `COMTNNOTETRNSMIT` CHANGE `TRNSMITER_ID` `TRNSMITER_ID` char(20) DEFAULT NULL COMMENT '송신자ID' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `BH_NTCN_INTRVL` `BH_NTCN_INTRVL` varchar(20) NOT NULL COMMENT '사전알림간격' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `NTCN_CN` `NTCN_CN` varchar(100) NOT NULL COMMENT '알림내용' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `NTCN_NO` `NTCN_NO` decimal(20,0) NOT NULL DEFAULT '0' COMMENT '알림번호' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `NTCN_SJ` `NTCN_SJ` varchar(60) NOT NULL COMMENT '알림제목' ; ALTER TABLE `COMTNNTFCINFO` CHANGE `NTCN_TM` `NTCN_TM` varchar(14) NOT NULL COMMENT '알림시간' ; ALTER TABLE `COMTNNTTSTATS` CHANGE `AVRG_RDCNT` `AVRG_RDCNT` decimal(10,0) DEFAULT NULL COMMENT '평균조회수' ; ALTER TABLE `COMTNNTTSTATS` CHANGE `MUMM_RDCNT` `MUMM_RDCNT` decimal(10,0) DEFAULT NULL COMMENT '최소조회수' ; ALTER TABLE `COMTNNTTSTATS` CHANGE `NTCE_CO` `NTCE_CO` decimal(10,0) DEFAULT NULL COMMENT '게시개수' ; ALTER TABLE `COMTNNTTSTATS` CHANGE `STATS_ID` `STATS_ID` char(18) NOT NULL DEFAULT '' COMMENT '통계ID' ; ALTER TABLE `COMTNNTTSTATS` CHANGE `TOP_NTCR_ID` `TOP_NTCR_ID` varchar(20) DEFAULT NULL COMMENT '최고게시자ID' ; ALTER TABLE `COMTNNTTSTATS` CHANGE `TOP_RDCNT` `TOP_RDCNT` decimal(10,0) DEFAULT NULL COMMENT '최고조회수' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `DOMN_NM_SERVER` `DOMN_NM_SERVER` varchar(23) DEFAULT NULL COMMENT '도메인명서버' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `GTWY` `GTWY` varchar(23) DEFAULT NULL COMMENT '게이트웨이' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `MANAGE_IEM` `MANAGE_IEM` char(2) DEFAULT NULL COMMENT '관리항목' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `NTWRK_ID` `NTWRK_ID` char(20) NOT NULL COMMENT '네트워크ID' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `NTWRK_IP` `NTWRK_IP` varchar(23) DEFAULT NULL COMMENT '네트워크IP' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `RGSDE` `RGSDE` datetime DEFAULT NULL COMMENT '등록일' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `SUBNET` `SUBNET` varchar(23) DEFAULT NULL COMMENT '서브넷' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNNTWRKINFO` CHANGE `USER_NM` `USER_NM` varchar(60) DEFAULT NULL COMMENT '사용자명' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) NOT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `SYS_IP` `SYS_IP` varchar(23) NOT NULL COMMENT '시스템IP' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `SYS_NM` `SYS_NM` varchar(255) NOT NULL COMMENT '시스템명' ; ALTER TABLE `COMTNNTWRKSVCMNTRNG` CHANGE `SYS_PORT` `SYS_PORT` decimal(5,0) NOT NULL COMMENT '시스템포트' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) NOT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL DEFAULT '' COMMENT '로그ID' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `LOG_INFO` `LOG_INFO` varchar(2000) DEFAULT NULL COMMENT '로그정보' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `SYS_IP` `SYS_IP` varchar(23) NOT NULL COMMENT '시스템IP' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `SYS_NM` `SYS_NM` varchar(255) NOT NULL COMMENT '시스템명' ; ALTER TABLE `COMTNNTWRKSVCMNTRNGLOGINFO` CHANGE `SYS_PORT` `SYS_PORT` decimal(5,0) NOT NULL COMMENT '시스템포트' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `ONLINE_MNL_DC` `ONLINE_MNL_DC` mediumtext DEFAULT NULL COMMENT '온라인메뉴얼설명' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `ONLINE_MNL_DFN` `ONLINE_MNL_DFN` mediumtext DEFAULT NULL COMMENT '온라인메뉴얼정의' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `ONLINE_MNL_ID` `ONLINE_MNL_ID` char(20) NOT NULL DEFAULT '' COMMENT '온라인메뉴얼ID' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `ONLINE_MNL_NM` `ONLINE_MNL_NM` varchar(255) DEFAULT NULL COMMENT '온라인메뉴얼명' ; ALTER TABLE `COMTNONLINEMANUAL` CHANGE `ONLINE_MNL_SE_CODE` `ONLINE_MNL_SE_CODE` char(3) DEFAULT NULL COMMENT '온라인메뉴얼구분코드' ; ALTER TABLE `COMTNONLINEPOLLIEM` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNONLINEPOLLIEM` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNONLINEPOLLIEM` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNONLINEPOLLIEM` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNONLINEPOLLIEM` CHANGE `POLL_ID` `POLL_ID` char(20) NOT NULL COMMENT 'POLLID' ; ALTER TABLE `COMTNONLINEPOLLIEM` CHANGE `POLL_IEM_ID` `POLL_IEM_ID` char(20) NOT NULL COMMENT 'POLL항목ID' ; ALTER TABLE `COMTNONLINEPOLLIEM` CHANGE `POLL_IEM_NM` `POLL_IEM_NM` varchar(255) DEFAULT NULL COMMENT 'POLL항목명' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `POLL_ATMC_DSUSE_ENNC` `POLL_ATMC_DSUSE_ENNC` char(1) DEFAULT NULL COMMENT 'POLL자동폐기유무' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `POLL_BGNDE` `POLL_BGNDE` char(10) DEFAULT NULL COMMENT 'POLL시작일' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `POLL_DSUSE_ENNC` `POLL_DSUSE_ENNC` char(1) DEFAULT NULL COMMENT 'POLL폐기유무' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `POLL_ENDDE` `POLL_ENDDE` char(10) DEFAULT NULL COMMENT 'POLL종료일' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `POLL_ID` `POLL_ID` char(20) NOT NULL COMMENT 'POLLID' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `POLL_KND` `POLL_KND` char(3) DEFAULT NULL COMMENT 'POLL종류' ; ALTER TABLE `COMTNONLINEPOLLMANAGE` CHANGE `POLL_NM` `POLL_NM` varchar(255) DEFAULT NULL COMMENT 'POLL명' ; ALTER TABLE `COMTNONLINEPOLLRESULT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNONLINEPOLLRESULT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNONLINEPOLLRESULT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNONLINEPOLLRESULT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNONLINEPOLLRESULT` CHANGE `POLL_ID` `POLL_ID` char(20) NOT NULL COMMENT 'POLLID' ; ALTER TABLE `COMTNONLINEPOLLRESULT` CHANGE `POLL_IEM_ID` `POLL_IEM_ID` char(20) NOT NULL COMMENT 'POLL항목ID' ; ALTER TABLE `COMTNONLINEPOLLRESULT` CHANGE `POLL_RESULT_ID` `POLL_RESULT_ID` char(20) NOT NULL DEFAULT '' COMMENT 'POLL결과ID' ; ALTER TABLE `COMTNORGNZTINFO` CHANGE `ORGNZT_DC` `ORGNZT_DC` varchar(100) DEFAULT NULL COMMENT '조직설명' ; ALTER TABLE `COMTNORGNZTINFO` CHANGE `ORGNZT_ID` `ORGNZT_ID` char(20) NOT NULL DEFAULT '' COMMENT '조직ID' ; ALTER TABLE `COMTNORGNZTINFO` CHANGE `ORGNZT_NM` `ORGNZT_NM` varchar(20) NOT NULL COMMENT '조직명' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `FILE_URL` `FILE_URL` varchar(1024) DEFAULT NULL COMMENT '파일URL' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `NTCE_AT` `NTCE_AT` char(1) DEFAULT NULL COMMENT '게시여부' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `NTCE_BGNDE` `NTCE_BGNDE` char(20) DEFAULT NULL COMMENT '게시시작일' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `NTCE_ENDDE` `NTCE_ENDDE` char(20) DEFAULT NULL COMMENT '게시종료일' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `POPUP_ID` `POPUP_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '팝업ID' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `POPUP_SJ_NM` `POPUP_SJ_NM` varchar(1024) DEFAULT NULL COMMENT '팝업제목명' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `POPUP_VRTICL_LC` `POPUP_VRTICL_LC` varchar(20) DEFAULT NULL COMMENT '팝업세로위치' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `POPUP_VRTICL_SIZE` `POPUP_VRTICL_SIZE` decimal(10,0) DEFAULT NULL COMMENT '팝업세로사이즈' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `POPUP_WIDTH_LC` `POPUP_WIDTH_LC` varchar(20) DEFAULT NULL COMMENT '팝업가로위치' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `POPUP_WIDTH_SIZE` `POPUP_WIDTH_SIZE` decimal(10,0) DEFAULT NULL COMMENT '팝업가로사이즈' ; ALTER TABLE `COMTNPOPUPMANAGE` CHANGE `STOPVEW_SETUP_AT` `STOPVEW_SETUP_AT` char(1) DEFAULT NULL COMMENT '그만보기설정여부' ; ALTER TABLE `COMTNPRIVACYLOG` CHANGE `INQIRE_DT` `INQIRE_DT` datetime NOT NULL COMMENT '조회일시' ; ALTER TABLE `COMTNPRIVACYLOG` CHANGE `INQIRE_INFO` `INQIRE_INFO` varchar(100) DEFAULT NULL COMMENT '조회 정보 명' ; ALTER TABLE `COMTNPRIVACYLOG` CHANGE `REQUST_ID` `REQUST_ID` varchar(20) NOT NULL COMMENT '요청 ID' ; ALTER TABLE `COMTNPRIVACYLOG` CHANGE `RQESTER_ID` `RQESTER_ID` varchar(20) DEFAULT NULL COMMENT '요청자아이디' ; ALTER TABLE `COMTNPRIVACYLOG` CHANGE `RQESTER_IP` `RQESTER_IP` varchar(23) DEFAULT NULL COMMENT '요청아이피' ; ALTER TABLE `COMTNPRIVACYLOG` CHANGE `SRVC_NM` `SRVC_NM` varchar(500) DEFAULT NULL COMMENT '서비스 명' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `PROCS_ID` `PROCS_ID` char(20) NOT NULL COMMENT '프로세스ID' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `PROCS_NM` `PROCS_NM` varchar(60) DEFAULT NULL COMMENT '프로세스명' ; ALTER TABLE `COMTNPROCESSMON` CHANGE `PROCS_STTUS` `PROCS_STTUS` varchar(3) DEFAULT NULL COMMENT '프로세스상태' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL DEFAULT '' COMMENT '로그ID' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `LOG_INFO` `LOG_INFO` varchar(2000) DEFAULT NULL COMMENT '로그정보' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `PROCS_ID` `PROCS_ID` char(20) NOT NULL COMMENT '프로세스ID' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `PROCS_NM` `PROCS_NM` varchar(60) DEFAULT NULL COMMENT '프로세스명' ; ALTER TABLE `COMTNPROCESSMONLOGINFO` CHANGE `PROCS_STTUS` `PROCS_STTUS` varchar(3) DEFAULT NULL COMMENT '프로세스상태' ; ALTER TABLE `COMTNPROGRMLIST` CHANGE `PROGRM_DC` `PROGRM_DC` varchar(200) DEFAULT NULL COMMENT '프로그램설명' ; ALTER TABLE `COMTNPROGRMLIST` CHANGE `PROGRM_FILE_NM` `PROGRM_FILE_NM` varchar(60) NOT NULL DEFAULT '' COMMENT '프로그램파일명' ; ALTER TABLE `COMTNPROGRMLIST` CHANGE `PROGRM_KOREAN_NM` `PROGRM_KOREAN_NM` varchar(60) DEFAULT NULL COMMENT '프로그램한글명' ; ALTER TABLE `COMTNPROGRMLIST` CHANGE `PROGRM_STRE_PATH` `PROGRM_STRE_PATH` varchar(100) NOT NULL COMMENT '프로그램저장경로' ; ALTER TABLE `COMTNPROGRMLIST` CHANGE `URL` `URL` varchar(100) NOT NULL COMMENT 'URL' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `PROXY_ID` `PROXY_ID` char(20) NOT NULL COMMENT '프록시ID' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `PROXY_IP` `PROXY_IP` varchar(23) DEFAULT NULL COMMENT '프록시IP' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `PROXY_NM` `PROXY_NM` varchar(60) DEFAULT NULL COMMENT '프록시명' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `PROXY_PORT` `PROXY_PORT` varchar(10) DEFAULT NULL COMMENT '프록시포트' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `SVC_DC` `SVC_DC` varchar(2000) DEFAULT NULL COMMENT '서비스설명' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `SVC_IP` `SVC_IP` varchar(23) DEFAULT NULL COMMENT '서비스IP' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `SVC_PORT` `SVC_PORT` varchar(10) DEFAULT NULL COMMENT '서비스포트' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `SVC_STTUS` `SVC_STTUS` char(2) DEFAULT NULL COMMENT '서비스상태' ; ALTER TABLE `COMTNPROXYINFO` CHANGE `TRGET_SVC_NM` `TRGET_SVC_NM` varchar(255) DEFAULT NULL COMMENT '대상서비스명' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `CLNT_IP` `CLNT_IP` varchar(23) DEFAULT NULL COMMENT '클라이언트IP' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `CLNT_PORT` `CLNT_PORT` varchar(10) DEFAULT NULL COMMENT '클라이언트포트' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `CONECT_TIME` `CONECT_TIME` datetime DEFAULT NULL COMMENT '접속시간' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL DEFAULT '' COMMENT '로그ID' ; ALTER TABLE `COMTNPROXYLOGINFO` CHANGE `PROXY_ID` `PROXY_ID` char(20) NOT NULL COMMENT '프록시ID' ; ALTER TABLE `COMTNQAINFO` CHANGE `ANSWER_CN` `ANSWER_CN` varchar(2500) DEFAULT NULL COMMENT '답변내용' ; ALTER TABLE `COMTNQAINFO` CHANGE `ANSWER_DE` `ANSWER_DE` char(20) DEFAULT NULL COMMENT '답변일자' ; ALTER TABLE `COMTNQAINFO` CHANGE `AREA_NO` `AREA_NO` varchar(4) DEFAULT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNQAINFO` CHANGE `EMAIL_ADRES` `EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '이메일주소' ; ALTER TABLE `COMTNQAINFO` CHANGE `EMAIL_ANSWER_AT` `EMAIL_ANSWER_AT` char(1) DEFAULT NULL COMMENT '메일답변여부' ; ALTER TABLE `COMTNQAINFO` CHANGE `END_TELNO` `END_TELNO` varchar(4) DEFAULT NULL COMMENT '끝전화번호' ; ALTER TABLE `COMTNQAINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNQAINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNQAINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNQAINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNQAINFO` CHANGE `MIDDLE_TELNO` `MIDDLE_TELNO` varchar(4) DEFAULT NULL COMMENT '중간전화번호' ; ALTER TABLE `COMTNQAINFO` CHANGE `QA_ID` `QA_ID` char(20) NOT NULL COMMENT 'QAID' ; ALTER TABLE `COMTNQAINFO` CHANGE `QESTN_CN` `QESTN_CN` varchar(2500) DEFAULT NULL COMMENT '질문내용' ; ALTER TABLE `COMTNQAINFO` CHANGE `QESTN_SJ` `QESTN_SJ` varchar(255) DEFAULT NULL COMMENT '질문제목' ; ALTER TABLE `COMTNQAINFO` CHANGE `QNA_PROCESS_STTUS_CODE` `QNA_PROCESS_STTUS_CODE` char(1) DEFAULT NULL COMMENT '질의응답처리상태코드' ; ALTER TABLE `COMTNQAINFO` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTNQAINFO` CHANGE `WRITNG_DE` `WRITNG_DE` char(20) DEFAULT NULL COMMENT '작성일' ; ALTER TABLE `COMTNQAINFO` CHANGE `WRITNG_PASSWORD` `WRITNG_PASSWORD` varchar(20) DEFAULT NULL COMMENT '작성비밀번호' ; ALTER TABLE `COMTNQAINFO` CHANGE `WRTER_NM` `WRTER_NM` varchar(20) DEFAULT NULL COMMENT '작성자명' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QESTNR_ID` `QESTNR_ID` char(20) NOT NULL COMMENT '설문지ID' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QUSTNR_BGNDE` `QUSTNR_BGNDE` char(20) DEFAULT NULL COMMENT '설문시작일' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QUSTNR_ENDDE` `QUSTNR_ENDDE` char(20) DEFAULT NULL COMMENT '설문종료일' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QUSTNR_PURPS` `QUSTNR_PURPS` varchar(1000) DEFAULT NULL COMMENT '설문목적' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QUSTNR_SJ` `QUSTNR_SJ` varchar(255) DEFAULT NULL COMMENT '설문제목' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QUSTNR_TMPLAT_ID` `QUSTNR_TMPLAT_ID` char(20) NOT NULL COMMENT '설문템플릿ID' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QUSTNR_TRGET` `QUSTNR_TRGET` varchar(1000) DEFAULT NULL COMMENT '설문대상' ; ALTER TABLE `COMTNQESTNRINFO` CHANGE `QUSTNR_WRITNG_GUIDANCE_CN` `QUSTNR_WRITNG_GUIDANCE_CN` varchar(2000) DEFAULT NULL COMMENT '설문작성안내내용' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `ETC_ANSWER_AT` `ETC_ANSWER_AT` char(1) DEFAULT NULL COMMENT '기타답변여부' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `IEM_CN` `IEM_CN` varchar(1000) DEFAULT NULL COMMENT '항목내용' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `IEM_SN` `IEM_SN` decimal(5,0) DEFAULT NULL COMMENT '항목순번' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `QESTNR_ID` `QESTNR_ID` char(20) NOT NULL COMMENT '설문지ID' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `QUSTNR_IEM_ID` `QUSTNR_IEM_ID` varchar(20) NOT NULL COMMENT '설문항목ID' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `QUSTNR_QESITM_ID` `QUSTNR_QESITM_ID` char(20) NOT NULL COMMENT '설문문항ID' ; ALTER TABLE `COMTNQUSTNRIEM` CHANGE `QUSTNR_TMPLAT_ID` `QUSTNR_TMPLAT_ID` char(20) NOT NULL COMMENT '설문템플릿ID' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) NOT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `MXMM_CHOISE_CO` `MXMM_CHOISE_CO` decimal(5,0) DEFAULT NULL COMMENT '최대선택개수' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `QESTN_CN` `QESTN_CN` varchar(2500) DEFAULT NULL COMMENT '질문내용' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `QESTN_SN` `QESTN_SN` decimal(10,0) DEFAULT NULL COMMENT '질문순번' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `QESTN_TY_CODE` `QESTN_TY_CODE` char(1) DEFAULT NULL COMMENT '질문유형코드' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `QESTNR_ID` `QESTNR_ID` char(20) NOT NULL COMMENT '설문지ID' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `QUSTNR_QESITM_ID` `QUSTNR_QESITM_ID` char(20) NOT NULL COMMENT '설문문항ID' ; ALTER TABLE `COMTNQUSTNRQESITM` CHANGE `QUSTNR_TMPLAT_ID` `QUSTNR_TMPLAT_ID` char(20) NOT NULL COMMENT '설문템플릿ID' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `AREA_NO` `AREA_NO` varchar(4) DEFAULT NULL COMMENT '지역번호' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `BRTHDY` `BRTHDY` char(20) DEFAULT NULL COMMENT '생일' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `END_TELNO` `END_TELNO` varchar(4) DEFAULT NULL COMMENT '끝전화번호' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `MIDDLE_TELNO` `MIDDLE_TELNO` varchar(4) DEFAULT NULL COMMENT '중간전화번호' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `OCCP_TY_CODE` `OCCP_TY_CODE` char(1) DEFAULT NULL COMMENT '직업유형코드' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `QESTNR_ID` `QESTNR_ID` char(20) NOT NULL COMMENT '설문지ID' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `QUSTNR_RESPOND_ID` `QUSTNR_RESPOND_ID` char(20) NOT NULL COMMENT '설문응답자ID' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `QUSTNR_TMPLAT_ID` `QUSTNR_TMPLAT_ID` char(20) NOT NULL COMMENT '설문템플릿ID' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `RESPOND_NM` `RESPOND_NM` varchar(50) DEFAULT NULL COMMENT '응답자명' ; ALTER TABLE `COMTNQUSTNRRESPONDINFO` CHANGE `SEXDSTN_CODE` `SEXDSTN_CODE` char(1) DEFAULT NULL COMMENT '성별코드' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `ETC_ANSWER_CN` `ETC_ANSWER_CN` varchar(1000) DEFAULT NULL COMMENT '기타답변내용' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `QESTNR_ID` `QESTNR_ID` char(20) NOT NULL COMMENT '설문지ID' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `QUSTNR_IEM_ID` `QUSTNR_IEM_ID` varchar(20) DEFAULT NULL COMMENT '설문항목ID' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `QUSTNR_QESITM_ID` `QUSTNR_QESITM_ID` char(20) NOT NULL COMMENT '설문문항ID' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `QUSTNR_RSPNS_RESULT_ID` `QUSTNR_RSPNS_RESULT_ID` char(20) NOT NULL COMMENT '설문응답결과ID' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `QUSTNR_TMPLAT_ID` `QUSTNR_TMPLAT_ID` char(20) NOT NULL COMMENT '설문템플릿ID' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `RESPOND_ANSWER_CN` `RESPOND_ANSWER_CN` varchar(1000) DEFAULT NULL COMMENT '응답자답변내용' ; ALTER TABLE `COMTNQUSTNRRSPNSRESULT` CHANGE `RESPOND_NM` `RESPOND_NM` varchar(50) DEFAULT NULL COMMENT '응답자명' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `QUSTNR_TMPLAT_DC` `QUSTNR_TMPLAT_DC` varchar(2000) DEFAULT NULL COMMENT '설문템플릿설명' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `QUSTNR_TMPLAT_ID` `QUSTNR_TMPLAT_ID` char(20) NOT NULL COMMENT '설문템플릿ID' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `QUSTNR_TMPLAT_IMAGE_INFO` `QUSTNR_TMPLAT_IMAGE_INFO` blob DEFAULT NULL COMMENT '설문템플릿이미지정보' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `QUSTNR_TMPLAT_PATH_NM` `QUSTNR_TMPLAT_PATH_NM` varchar(100) DEFAULT NULL COMMENT '설문템플릿경로명' ; ALTER TABLE `COMTNQUSTNRTMPLAT` CHANGE `QUSTNR_TMPLAT_TY` `QUSTNR_TMPLAT_TY` varchar(100) DEFAULT NULL COMMENT '설문템플릿유형' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `RECENT_SRCHWRD_CO` `RECENT_SRCHWRD_CO` decimal(20,0) DEFAULT NULL COMMENT '최근검색어개수' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `RECENT_SRCHWRD_ID` `RECENT_SRCHWRD_ID` char(20) NOT NULL COMMENT '최근검색어ID' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `RECENT_SRCHWRD_NM` `RECENT_SRCHWRD_NM` varchar(255) DEFAULT NULL COMMENT '최근검색어명' ; ALTER TABLE `COMTNRECENTSRCHWRD` CHANGE `SRCHWRD_MANAGE_ID` `SRCHWRD_MANAGE_ID` char(20) NOT NULL COMMENT '검색어관리ID' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `SRCHWRD_CONECT_URL` `SRCHWRD_CONECT_URL` varchar(255) DEFAULT NULL COMMENT '검색어접속URL' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `SRCHWRD_MANAGE_ID` `SRCHWRD_MANAGE_ID` char(20) NOT NULL DEFAULT '' COMMENT '검색어관리ID' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `SRCHWRD_MANAGE_NM` `SRCHWRD_MANAGE_NM` varchar(255) DEFAULT NULL COMMENT '검색어관리명' ; ALTER TABLE `COMTNRECENTSRCHWRDMANAGE` CHANGE `USER_SEARCH_AT` `USER_SEARCH_AT` char(1) DEFAULT NULL COMMENT '사용자검색여부' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `CONFM_DE` `CONFM_DE` char(20) DEFAULT NULL COMMENT '승인일' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `RECOMEND_CONFM_AT` `RECOMEND_CONFM_AT` char(1) DEFAULT NULL COMMENT '추천승인여부' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `RECOMEND_RESN_CN` `RECOMEND_RESN_CN` varchar(1000) DEFAULT NULL COMMENT '추천사유내용' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `RECOMEND_SITE_DC` `RECOMEND_SITE_DC` varchar(1000) DEFAULT NULL COMMENT '추천사이트설명' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `RECOMEND_SITE_ID` `RECOMEND_SITE_ID` char(20) NOT NULL COMMENT '추천사이트ID' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `RECOMEND_SITE_NM` `RECOMEND_SITE_NM` varchar(100) DEFAULT NULL COMMENT '추천사이트명' ; ALTER TABLE `COMTNRECOMENDSITEINFO` CHANGE `RECOMEND_SITE_URL` `RECOMEND_SITE_URL` varchar(255) DEFAULT NULL COMMENT '추천사이트URL' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `REPRT_ID` `REPRT_ID` char(6) NOT NULL DEFAULT '' COMMENT '보고서ID' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `REPRT_NM` `REPRT_NM` varchar(20) NOT NULL COMMENT '보고서명' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `REPRT_STTUS` `REPRT_STTUS` char(2) NOT NULL COMMENT '보고서상태' ; ALTER TABLE `COMTNREPRTSTATS` CHANGE `REPRT_TY` `REPRT_TY` char(2) DEFAULT NULL COMMENT '보고서유형' ; ALTER TABLE `COMTNRESTDE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNRESTDE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNRESTDE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNRESTDE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNRESTDE` CHANGE `RESTDE_DC` `RESTDE_DC` varchar(200) DEFAULT NULL COMMENT '휴일설명' ; ALTER TABLE `COMTNRESTDE` CHANGE `RESTDE_NM` `RESTDE_NM` varchar(60) DEFAULT NULL COMMENT '휴일명' ; ALTER TABLE `COMTNRESTDE` CHANGE `RESTDE_NO` `RESTDE_NO` decimal(6,0) NOT NULL COMMENT '휴일번호' ; ALTER TABLE `COMTNRESTDE` CHANGE `RESTDE_SE_CODE` `RESTDE_SE_CODE` varchar(2) DEFAULT NULL COMMENT '휴일구분코드' ; ALTER TABLE `COMTNRESTDE` CHANGE `RESTDE` `RESTDE` char(8) DEFAULT NULL COMMENT '휴일' ; ALTER TABLE `COMTNROLEINFO` CHANGE `ROLE_CODE` `ROLE_CODE` varchar(50) NOT NULL DEFAULT '' COMMENT '롤코드' ; ALTER TABLE `COMTNROLEINFO` CHANGE `ROLE_CREAT_DE` `ROLE_CREAT_DE` char(20) NOT NULL COMMENT '롤생성일' ; ALTER TABLE `COMTNROLEINFO` CHANGE `ROLE_DC` `ROLE_DC` varchar(200) DEFAULT NULL COMMENT '롤설명' ; ALTER TABLE `COMTNROLEINFO` CHANGE `ROLE_NM` `ROLE_NM` varchar(60) NOT NULL COMMENT '롤명' ; ALTER TABLE `COMTNROLEINFO` CHANGE `ROLE_PTTRN` `ROLE_PTTRN` varchar(300) DEFAULT NULL COMMENT '롤패턴' ; ALTER TABLE `COMTNROLEINFO` CHANGE `ROLE_SORT` `ROLE_SORT` varchar(10) DEFAULT NULL COMMENT '롤정렬' ; ALTER TABLE `COMTNROLEINFO` CHANGE `ROLE_TY` `ROLE_TY` varchar(80) DEFAULT NULL COMMENT '롤유형' ; ALTER TABLE `COMTNROLES_HIERARCHY` CHANGE `CHLDRN_ROLE` `CHLDRN_ROLE` varchar(30) NOT NULL COMMENT '자식롤' ; ALTER TABLE `COMTNROLES_HIERARCHY` CHANGE `PARNTS_ROLE` `PARNTS_ROLE` varchar(30) NOT NULL COMMENT '부모롤' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `INFOWINDOW` `INFOWINDOW` varchar(20) DEFAULT NULL COMMENT '안내창 도움말' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `LA` `LA` varchar(48) DEFAULT NULL COMMENT '지도 위도' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `LO` `LO` varchar(48) DEFAULT NULL COMMENT '지도 경도' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `MARKERLA` `MARKERLA` varchar(48) DEFAULT NULL COMMENT '마커 위도' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `MARKERLO` `MARKERLO` varchar(48) DEFAULT NULL COMMENT '마커 경도' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `ROUGHMAP_ID` `ROUGHMAP_ID` varchar(75) NOT NULL COMMENT '약도 ID' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `ROUGHMAPADDRESS` `ROUGHMAPADDRESS` varchar(200) DEFAULT NULL COMMENT '약도상세주소' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `ROUGHMAPSJ` `ROUGHMAPSJ` varchar(75) NOT NULL COMMENT '약도 제목' ; ALTER TABLE `COMTNROUGHMAP` CHANGE `ZOOMLEVEL` `ZOOMLEVEL` varchar(10) DEFAULT NULL COMMENT '지도 확대수준' ; ALTER TABLE `COMTNRSS` CHANGE `BDT_DC` `BDT_DC` varchar(4000) DEFAULT NULL COMMENT '본문설명' ; ALTER TABLE `COMTNRSS` CHANGE `BDT_ETC_TAG` `BDT_ETC_TAG` varchar(255) DEFAULT NULL COMMENT '본문기타태그' ; ALTER TABLE `COMTNRSS` CHANGE `BDT_LINK` `BDT_LINK` varchar(255) DEFAULT NULL COMMENT '본문링크' ; ALTER TABLE `COMTNRSS` CHANGE `BDT_TAG` `BDT_TAG` varchar(255) DEFAULT NULL COMMENT '본문태그' ; ALTER TABLE `COMTNRSS` CHANGE `BDT_TITLE` `BDT_TITLE` varchar(255) DEFAULT NULL COMMENT '본문TITLE' ; ALTER TABLE `COMTNRSS` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNRSS` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNRSS` CHANGE `HDER_DC` `HDER_DC` varchar(4000) NOT NULL COMMENT '헤더설명' ; ALTER TABLE `COMTNRSS` CHANGE `HDER_ETC` `HDER_ETC` varchar(250) DEFAULT NULL COMMENT '헤더기타' ; ALTER TABLE `COMTNRSS` CHANGE `HDER_LINK` `HDER_LINK` varchar(255) NOT NULL COMMENT '헤더링크' ; ALTER TABLE `COMTNRSS` CHANGE `HDER_TAG` `HDER_TAG` varchar(255) DEFAULT NULL COMMENT '헤더태그' ; ALTER TABLE `COMTNRSS` CHANGE `HDER_TITLE` `HDER_TITLE` varchar(255) NOT NULL COMMENT '헤더TITLE' ; ALTER TABLE `COMTNRSS` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNRSS` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNRSS` CHANGE `RSS_ID` `RSS_ID` char(20) NOT NULL COMMENT 'RSSID' ; ALTER TABLE `COMTNRSS` CHANGE `TRGET_SVC_LIST_CO` `TRGET_SVC_LIST_CO` decimal(5,0) NOT NULL COMMENT '대상서비스목록개수' ; ALTER TABLE `COMTNRSS` CHANGE `TRGET_SVC_NM` `TRGET_SVC_NM` varchar(255) NOT NULL COMMENT '대상서비스명' ; ALTER TABLE `COMTNRSS` CHANGE `TRGET_SVC_TABLE` `TRGET_SVC_TABLE` varchar(255) NOT NULL COMMENT '대상서비스테이블' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `CONFM_AT` `CONFM_AT` char(1) DEFAULT NULL COMMENT '승인여부' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `INFRML_SANCTN_ID` `INFRML_SANCTN_ID` char(20) DEFAULT NULL COMMENT '약식결재ID' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `PBLEN_CN` `PBLEN_CN` varchar(1000) DEFAULT NULL COMMENT '공적내용' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `RETURN_RESN` `RETURN_RESN` varchar(1000) DEFAULT NULL COMMENT '반환사유' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `RWARD_CODE` `RWARD_CODE` char(2) NOT NULL COMMENT '포상코드' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `RWARD_DE` `RWARD_DE` char(20) NOT NULL COMMENT '포상일' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `RWARD_ID` `RWARD_ID` char(20) NOT NULL COMMENT '포상ID' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `RWARD_NM` `RWARD_NM` varchar(255) NOT NULL COMMENT '포상명' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `RWARDWNR_ID` `RWARDWNR_ID` varchar(20) NOT NULL COMMENT '포상자ID' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `SANCTN_DT` `SANCTN_DT` datetime DEFAULT NULL COMMENT '결재일시' ; ALTER TABLE `COMTNRWARDMANAGE` CHANGE `SANCTNER_ID` `SANCTNER_ID` varchar(20) NOT NULL COMMENT '결재자ID' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `REPTIT_SE_CODE` `REPTIT_SE_CODE` char(1) DEFAULT NULL COMMENT '반복구분코드' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_BGNDE` `SCHDUL_BGNDE` char(20) DEFAULT NULL COMMENT '일정시작일' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_CHARGER_ID` `SCHDUL_CHARGER_ID` varchar(20) DEFAULT NULL COMMENT '일정담당자ID' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_CN` `SCHDUL_CN` varchar(2500) DEFAULT NULL COMMENT '일정내용' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_DEPT_ID` `SCHDUL_DEPT_ID` varchar(20) DEFAULT NULL COMMENT '일정부서ID' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_ENDDE` `SCHDUL_ENDDE` char(20) DEFAULT NULL COMMENT '일정종료일' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_ID` `SCHDUL_ID` char(20) NOT NULL COMMENT '일정ID' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_IPCR_CODE` `SCHDUL_IPCR_CODE` char(1) DEFAULT NULL COMMENT '일정중요도코드' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_KND_CODE` `SCHDUL_KND_CODE` char(1) DEFAULT NULL COMMENT '일정종류코드' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_NM` `SCHDUL_NM` varchar(255) DEFAULT NULL COMMENT '일정명' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_PLACE` `SCHDUL_PLACE` varchar(255) DEFAULT NULL COMMENT '일정장소' ; ALTER TABLE `COMTNSCHDULINFO` CHANGE `SCHDUL_SE` `SCHDUL_SE` char(1) DEFAULT NULL COMMENT '일정구분' ; ALTER TABLE `COMTNSCRAP` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNSCRAP` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSCRAP` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSCRAP` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSCRAP` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSCRAP` CHANGE `NTT_ID` `NTT_ID` decimal(20,0) NOT NULL COMMENT '게시물ID' ; ALTER TABLE `COMTNSCRAP` CHANGE `SCRAP_ID` `SCRAP_ID` char(20) NOT NULL COMMENT '스크랩ID' ; ALTER TABLE `COMTNSCRAP` CHANGE `SCRAP_NM` `SCRAP_NM` varchar(100) NOT NULL COMMENT '스크랩명' ; ALTER TABLE `COMTNSCRAP` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `CPU_INFO` `CPU_INFO` varchar(2000) DEFAULT NULL COMMENT 'CPU정보' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `ETC_INFO` `ETC_INFO` varchar(250) DEFAULT NULL COMMENT '기타정보' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `HDDISK` `HDDISK` char(18) DEFAULT NULL COMMENT 'HDDISK' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `MORY_INFO` `MORY_INFO` varchar(2000) DEFAULT NULL COMMENT '메모리정보' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `OPERSYSM_INFO` `OPERSYSM_INFO` varchar(2000) DEFAULT NULL COMMENT '운영체제정보' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `RGSDE` `RGSDE` datetime DEFAULT NULL COMMENT '등록일' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `SERVER_EQPMN_ID` `SERVER_EQPMN_ID` varchar(20) NOT NULL COMMENT '서버장비ID' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `SERVER_EQPMN_IP` `SERVER_EQPMN_IP` varchar(23) DEFAULT NULL COMMENT '서버장비IP' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `SERVER_EQPMN_MNGR` `SERVER_EQPMN_MNGR` varchar(60) DEFAULT NULL COMMENT '서버장비관리자' ; ALTER TABLE `COMTNSERVEREQPMNINFO` CHANGE `SERVER_EQPMN_NM` `SERVER_EQPMN_NM` varchar(60) DEFAULT NULL COMMENT '서버장비명' ; ALTER TABLE `COMTNSERVEREQPMNRELATE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSERVEREQPMNRELATE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSERVEREQPMNRELATE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSERVEREQPMNRELATE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSERVEREQPMNRELATE` CHANGE `SERVER_EQPMN_ID` `SERVER_EQPMN_ID` varchar(20) NOT NULL COMMENT '서버장비ID' ; ALTER TABLE `COMTNSERVEREQPMNRELATE` CHANGE `SERVER_ID` `SERVER_ID` char(20) NOT NULL COMMENT '서버ID' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `RGSDE` `RGSDE` datetime DEFAULT NULL COMMENT '등록일' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `SERVER_ID` `SERVER_ID` char(20) NOT NULL COMMENT '서버ID' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `SERVER_KND` `SERVER_KND` char(2) DEFAULT NULL COMMENT '서버종류' ; ALTER TABLE `COMTNSERVERINFO` CHANGE `SERVER_NM` `SERVER_NM` varchar(60) DEFAULT NULL COMMENT '서버명' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `CPU_USE_RT` `CPU_USE_RT` decimal(3,0) DEFAULT NULL COMMENT 'CPU사용율' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `LOG_ID` `LOG_ID` char(20) NOT NULL DEFAULT '' COMMENT '로그ID' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `LOG_INFO` `LOG_INFO` varchar(2000) DEFAULT NULL COMMENT '로그정보' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `MORY_USE_RT` `MORY_USE_RT` decimal(3,0) DEFAULT NULL COMMENT '메모리사용율' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `SERVER_EQPMN_ID` `SERVER_EQPMN_ID` varchar(20) NOT NULL COMMENT '서버장비ID' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `SERVER_ID` `SERVER_ID` char(20) NOT NULL COMMENT '서버ID' ; ALTER TABLE `COMTNSERVERRESRCELOGINFO` CHANGE `SVC_STTUS` `SVC_STTUS` char(2) DEFAULT NULL COMMENT '서비스상태' ; ALTER TABLE `COMTNSITELIST` CHANGE `ACTVTY_AT` `ACTVTY_AT` char(1) DEFAULT NULL COMMENT '활성여부' ; ALTER TABLE `COMTNSITELIST` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSITELIST` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSITELIST` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSITELIST` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSITELIST` CHANGE `SITE_DC` `SITE_DC` varchar(1000) DEFAULT NULL COMMENT '사이트설명' ; ALTER TABLE `COMTNSITELIST` CHANGE `SITE_ID` `SITE_ID` char(20) NOT NULL COMMENT '사이트ID' ; ALTER TABLE `COMTNSITELIST` CHANGE `SITE_NM` `SITE_NM` varchar(100) DEFAULT NULL COMMENT '사이트명' ; ALTER TABLE `COMTNSITELIST` CHANGE `SITE_THEMA_CL_CODE` `SITE_THEMA_CL_CODE` varchar(2) DEFAULT NULL COMMENT '사이트주제분류코드' ; ALTER TABLE `COMTNSITELIST` CHANGE `SITE_URL` `SITE_URL` varchar(100) DEFAULT NULL COMMENT '사이트URL' ; ALTER TABLE `COMTNSITELIST` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNSITEMAP` CHANGE `CREATR_ID` `CREATR_ID` varchar(20) NOT NULL COMMENT '생성자ID' ; ALTER TABLE `COMTNSITEMAP` CHANGE `MAPNG_CREAT_ID` `MAPNG_CREAT_ID` varchar(30) NOT NULL COMMENT '매핑생성ID' ; ALTER TABLE `COMTNSITEMAP` CHANGE `MAPNG_FILE_NM` `MAPNG_FILE_NM` varchar(60) NOT NULL COMMENT '매핑파일명' ; ALTER TABLE `COMTNSITEMAP` CHANGE `MAPNG_FILE_PATH` `MAPNG_FILE_PATH` varchar(100) NOT NULL COMMENT '매핑파일경로' ; ALTER TABLE `COMTNSMS` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSMS` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSMS` CHANGE `SMS_ID` `SMS_ID` char(20) NOT NULL DEFAULT '' COMMENT '문자메시지ID' ; ALTER TABLE `COMTNSMS` CHANGE `TRNSMIS_CN` `TRNSMIS_CN` varchar(80) NOT NULL COMMENT '전송내용' ; ALTER TABLE `COMTNSMS` CHANGE `TRNSMIS_TELNO` `TRNSMIS_TELNO` varchar(12) NOT NULL COMMENT '전송전화번호' ; ALTER TABLE `COMTNSMSRECPTN` CHANGE `RECPTN_TELNO` `RECPTN_TELNO` varchar(12) NOT NULL DEFAULT '' COMMENT '수신전화번호' ; ALTER TABLE `COMTNSMSRECPTN` CHANGE `RESULT_CODE` `RESULT_CODE` varchar(4) DEFAULT NULL COMMENT '결과코드' ; ALTER TABLE `COMTNSMSRECPTN` CHANGE `RESULT_MSSAGE` `RESULT_MSSAGE` varchar(4000) DEFAULT NULL COMMENT '결과메시지' ; ALTER TABLE `COMTNSMSRECPTN` CHANGE `SMS_ID` `SMS_ID` char(20) NOT NULL COMMENT '문자메시지ID' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `INFO_PROVD_AGRE_CN` `INFO_PROVD_AGRE_CN` mediumtext DEFAULT NULL COMMENT '정보제공동의내용' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `USE_STPLAT_CN` `USE_STPLAT_CN` mediumtext DEFAULT NULL COMMENT '이용약관내용' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `USE_STPLAT_ID` `USE_STPLAT_ID` char(20) NOT NULL COMMENT '이용약관ID' ; ALTER TABLE `COMTNSTPLATINFO` CHANGE `USE_STPLAT_NM` `USE_STPLAT_NM` varchar(100) DEFAULT NULL COMMENT '이용약관명' ; ALTER TABLE `COMTNSTSFDG` CHANGE `BBS_ID` `BBS_ID` char(20) NOT NULL COMMENT '게시판ID' ; ALTER TABLE `COMTNSTSFDG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSTSFDG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSTSFDG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSTSFDG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSTSFDG` CHANGE `NTT_ID` `NTT_ID` decimal(20,0) NOT NULL COMMENT '게시물ID' ; ALTER TABLE `COMTNSTSFDG` CHANGE `PASSWORD` `PASSWORD` varchar(200) DEFAULT NULL COMMENT '비밀번호' ; ALTER TABLE `COMTNSTSFDG` CHANGE `STSFDG_CN` `STSFDG_CN` varchar(200) DEFAULT NULL COMMENT '만족도내용' ; ALTER TABLE `COMTNSTSFDG` CHANGE `STSFDG_NO` `STSFDG_NO` decimal(20,0) NOT NULL COMMENT '만족도번호' ; ALTER TABLE `COMTNSTSFDG` CHANGE `STSFDG` `STSFDG` decimal(1,0) NOT NULL COMMENT '만족도' ; ALTER TABLE `COMTNSTSFDG` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNSTSFDG` CHANGE `WRTER_ID` `WRTER_ID` varchar(20) DEFAULT NULL COMMENT '작성자ID' ; ALTER TABLE `COMTNSTSFDG` CHANGE `WRTER_NM` `WRTER_NM` varchar(20) DEFAULT NULL COMMENT '작성자명' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `FTP_ID` `FTP_ID` varchar(20) DEFAULT NULL COMMENT 'FTPID' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `FTP_PASSWORD` `FTP_PASSWORD` varchar(20) DEFAULT NULL COMMENT 'FTP비밀번호' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `REFLCT_AT` `REFLCT_AT` char(1) DEFAULT NULL COMMENT '반영여부' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `SERVER_ID` `SERVER_ID` char(20) NOT NULL COMMENT '서버ID' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `SERVER_IP` `SERVER_IP` varchar(23) DEFAULT NULL COMMENT '서버IP' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `SERVER_NM` `SERVER_NM` varchar(60) DEFAULT NULL COMMENT '서버명' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `SERVER_PORT` `SERVER_PORT` varchar(10) DEFAULT NULL COMMENT '서버포트' ; ALTER TABLE `COMTNSYNCHRNSERVERINFO` CHANGE `SYNCHRN_LC` `SYNCHRN_LC` varchar(255) DEFAULT NULL COMMENT '동기화위치' ; ALTER TABLE `COMTNSYSLOG` CHANGE `ERROR_CO` `ERROR_CO` decimal(10,0) DEFAULT NULL COMMENT '오류수' ; ALTER TABLE `COMTNSYSLOG` CHANGE `ERROR_CODE` `ERROR_CODE` char(3) DEFAULT NULL COMMENT '오류코드' ; ALTER TABLE `COMTNSYSLOG` CHANGE `ERROR_SE` `ERROR_SE` char(1) DEFAULT NULL COMMENT '오류구분' ; ALTER TABLE `COMTNSYSLOG` CHANGE `INSTT_CODE` `INSTT_CODE` char(7) DEFAULT NULL COMMENT '기관코드' ; ALTER TABLE `COMTNSYSLOG` CHANGE `JOB_SE_CODE` `JOB_SE_CODE` char(3) DEFAULT NULL COMMENT '업무구분코드' ; ALTER TABLE `COMTNSYSLOG` CHANGE `METHOD_NM` `METHOD_NM` varchar(60) DEFAULT NULL COMMENT '메서드명' ; ALTER TABLE `COMTNSYSLOG` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` datetime DEFAULT NULL COMMENT '발생일' ; ALTER TABLE `COMTNSYSLOG` CHANGE `PROCESS_CO` `PROCESS_CO` decimal(10,0) DEFAULT NULL COMMENT '처리수' ; ALTER TABLE `COMTNSYSLOG` CHANGE `PROCESS_SE_CODE` `PROCESS_SE_CODE` char(3) DEFAULT NULL COMMENT '처리구분코드' ; ALTER TABLE `COMTNSYSLOG` CHANGE `PROCESS_TIME` `PROCESS_TIME` varchar(14) DEFAULT NULL COMMENT '처리시간' ; ALTER TABLE `COMTNSYSLOG` CHANGE `REQUST_ID` `REQUST_ID` varchar(20) NOT NULL COMMENT '요청ID' ; ALTER TABLE `COMTNSYSLOG` CHANGE `RQESTER_ID` `RQESTER_ID` varchar(20) DEFAULT NULL COMMENT '요청자ID' ; ALTER TABLE `COMTNSYSLOG` CHANGE `RQESTER_IP` `RQESTER_IP` varchar(23) DEFAULT NULL COMMENT '요청자IP' ; ALTER TABLE `COMTNSYSLOG` CHANGE `RSPNS_CODE` `RSPNS_CODE` char(3) DEFAULT NULL COMMENT '응답코드' ; ALTER TABLE `COMTNSYSLOG` CHANGE `SVC_NM` `SVC_NM` varchar(255) DEFAULT NULL COMMENT '서비스명' ; ALTER TABLE `COMTNSYSLOG` CHANGE `TRGET_MENU_NM` `TRGET_MENU_NM` varchar(255) DEFAULT NULL COMMENT '대상메뉴명' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `CNTC_ID` `CNTC_ID` char(8) NOT NULL DEFAULT '' COMMENT '연계ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `CNTC_NM` `CNTC_NM` varchar(100) DEFAULT NULL COMMENT '연계명' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `CNTC_TY` `CNTC_TY` varchar(60) DEFAULT NULL COMMENT '연계유형' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `CONFM_AT` `CONFM_AT` char(1) DEFAULT NULL COMMENT '승인여부' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `PROVD_INSTT_ID` `PROVD_INSTT_ID` char(8) DEFAULT NULL COMMENT '제공기관ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `PROVD_SVC_ID` `PROVD_SVC_ID` char(8) DEFAULT NULL COMMENT '제공서비스ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `PROVD_SYS_ID` `PROVD_SYS_ID` char(8) DEFAULT NULL COMMENT '제공시스템ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `REQUST_INSTT_ID` `REQUST_INSTT_ID` char(8) DEFAULT NULL COMMENT '요청기관ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `REQUST_SYS_ID` `REQUST_SYS_ID` char(8) DEFAULT NULL COMMENT '요청시스템ID' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `VALID_BGNDE` `VALID_BGNDE` char(20) DEFAULT NULL COMMENT '유효시작일자' ; ALTER TABLE `COMTNSYSTEMCNTC` CHANGE `VALID_ENDDE` `VALID_ENDDE` char(20) DEFAULT NULL COMMENT '유효종료일자' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `TMPLAT_COURS` `TMPLAT_COURS` varchar(2000) DEFAULT NULL COMMENT '템플릿경로' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `TMPLAT_ID` `TMPLAT_ID` char(20) NOT NULL DEFAULT '' COMMENT '템플릿ID' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `TMPLAT_NM` `TMPLAT_NM` varchar(255) DEFAULT NULL COMMENT '템플릿명' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `TMPLAT_SE_CODE` `TMPLAT_SE_CODE` char(6) DEFAULT NULL COMMENT '템플릿구분코드' ; ALTER TABLE `COMTNTMPLATINFO` CHANGE `USE_AT` `USE_AT` char(1) DEFAULT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `PROCESS_STTUS` `PROCESS_STTUS` char(1) DEFAULT NULL COMMENT '처리상태' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_DC` `TROBL_DC` varchar(2000) DEFAULT NULL COMMENT '장애설명' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_ID` `TROBL_ID` char(20) NOT NULL COMMENT '장애ID' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_KND` `TROBL_KND` char(2) DEFAULT NULL COMMENT '장애종류' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_NM` `TROBL_NM` varchar(60) DEFAULT NULL COMMENT '장애명' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_OCCRRNC_TIME` `TROBL_OCCRRNC_TIME` varchar(14) DEFAULT NULL COMMENT '장애발생시간' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_OPETR_NM` `TROBL_OPETR_NM` varchar(60) DEFAULT NULL COMMENT '장애처리자명' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_PROCESS_RESULT` `TROBL_PROCESS_RESULT` varchar(2000) DEFAULT NULL COMMENT '장애처리결과' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_PROCESS_TIME` `TROBL_PROCESS_TIME` varchar(14) DEFAULT NULL COMMENT '장애처리시간' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_REQUST_TIME` `TROBL_REQUST_TIME` varchar(14) DEFAULT NULL COMMENT '장애요청시간' ; ALTER TABLE `COMTNTROBLINFO` CHANGE `TROBL_RQESTER_NM` `TROBL_RQESTER_NM` varchar(60) DEFAULT NULL COMMENT '장애요청자명' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `CNTC_ID` `CNTC_ID` char(8) DEFAULT NULL COMMENT '연계ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(20) DEFAULT NULL COMMENT '발생일' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `PROVD_INSTT_ID` `PROVD_INSTT_ID` char(8) DEFAULT NULL COMMENT '제공기관ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `PROVD_SVC_ID` `PROVD_SVC_ID` char(8) DEFAULT NULL COMMENT '제공서비스ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `PROVD_SYS_ID` `PROVD_SYS_ID` char(8) DEFAULT NULL COMMENT '제공시스템ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `REQUST_ID` `REQUST_ID` varchar(20) NOT NULL COMMENT '요청ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `REQUST_INSTT_ID` `REQUST_INSTT_ID` char(8) DEFAULT NULL COMMENT '요청기관ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `REQUST_RECPTN_TM` `REQUST_RECPTN_TM` varchar(14) DEFAULT NULL COMMENT '요청수신시각' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `REQUST_SYS_ID` `REQUST_SYS_ID` char(8) DEFAULT NULL COMMENT '요청시스템ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `REQUST_TRNSMIT_TM` `REQUST_TRNSMIT_TM` varchar(14) DEFAULT NULL COMMENT '요청송신시각' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `RESULT_CODE` `RESULT_CODE` varchar(4) DEFAULT NULL COMMENT '결과코드' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `RESULT_MSSAGE` `RESULT_MSSAGE` varchar(4000) DEFAULT NULL COMMENT '결과메시지' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `RQESTER_ID` `RQESTER_ID` varchar(20) DEFAULT NULL COMMENT '요청자ID' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `RSPNS_RECPTN_TM` `RSPNS_RECPTN_TM` varchar(14) DEFAULT NULL COMMENT '응답수신시각' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `RSPNS_TRNSMIT_TM` `RSPNS_TRNSMIT_TM` varchar(14) DEFAULT NULL COMMENT '응답송신시각' ; ALTER TABLE `COMTNTRSMRCVLOG` CHANGE `TRSMRCV_SE_CODE` `TRSMRCV_SE_CODE` char(3) DEFAULT NULL COMMENT '송수신구분코드' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `CNTC_ID` `CNTC_ID` char(8) NOT NULL COMMENT '연계ID' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `CREAT_DT` `CREAT_DT` datetime DEFAULT NULL COMMENT '생성일시' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NOT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `MNGR_EMAIL_ADRES` `MNGR_EMAIL_ADRES` varchar(50) DEFAULT NULL COMMENT '관리자이메일주소' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `MNGR_NM` `MNGR_NM` varchar(60) DEFAULT NULL COMMENT '관리자명' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `MNTRNG_STTUS` `MNTRNG_STTUS` char(2) DEFAULT NULL COMMENT '모니터링상태' ; ALTER TABLE `COMTNTRSMRCVMNTRNG` CHANGE `TEST_CLASS_NM` `TEST_CLASS_NM` varchar(255) DEFAULT NULL COMMENT '테스트클래스명' ; ALTER TABLE `COMTNTWITTER` CHANGE `CNSMR_KEY` `CNSMR_KEY` varchar(50) NOT NULL COMMENT '사용자열쇠' ; ALTER TABLE `COMTNTWITTER` CHANGE `CNSMR_SECRET` `CNSMR_SECRET` varchar(50) NOT NULL COMMENT '사용자비밀' ; ALTER TABLE `COMTNTWITTER` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNTWITTER` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNTWITTER` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNTWITTER` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNTWITTER` CHANGE `USER_ID` `USER_ID` varchar(20) NOT NULL COMMENT '사용자ID' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `UNITY_LINK_DC` `UNITY_LINK_DC` varchar(2500) DEFAULT NULL COMMENT '통합링크설명' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `UNITY_LINK_GROUP` `UNITY_LINK_GROUP` varchar(255) DEFAULT NULL COMMENT '통합링크그룹' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `UNITY_LINK_ID` `UNITY_LINK_ID` char(20) NOT NULL DEFAULT '' COMMENT '통합링크ID' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `UNITY_LINK_NM` `UNITY_LINK_NM` varchar(255) DEFAULT NULL COMMENT '통합링크명' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `UNITY_LINK_SE_CODE` `UNITY_LINK_SE_CODE` char(3) DEFAULT NULL COMMENT '통합링크구분코드' ; ALTER TABLE `COMTNUNITYLINK` CHANGE `UNITY_LINK_URL` `UNITY_LINK_URL` varchar(255) DEFAULT NULL COMMENT '통합링크URL' ; ALTER TABLE `COMTNUSERABSNCE` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '업무사용자ID' ; ALTER TABLE `COMTNUSERABSNCE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNUSERABSNCE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNUSERABSNCE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNUSERABSNCE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNUSERABSNCE` CHANGE `USER_ABSNCE_AT` `USER_ABSNCE_AT` char(1) NOT NULL COMMENT '사용자부재여부' ; ALTER TABLE `COMTNUSERLOG` CHANGE `CREAT_CO` `CREAT_CO` decimal(10,0) DEFAULT NULL COMMENT '생성수' ; ALTER TABLE `COMTNUSERLOG` CHANGE `DELETE_CO` `DELETE_CO` decimal(10,0) DEFAULT NULL COMMENT '삭제수' ; ALTER TABLE `COMTNUSERLOG` CHANGE `ERROR_CO` `ERROR_CO` decimal(10,0) DEFAULT NULL COMMENT '오류수' ; ALTER TABLE `COMTNUSERLOG` CHANGE `METHOD_NM` `METHOD_NM` varchar(60) NOT NULL DEFAULT '' COMMENT '메서드명' ; ALTER TABLE `COMTNUSERLOG` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(8) NOT NULL DEFAULT '' COMMENT '발생일' ; ALTER TABLE `COMTNUSERLOG` CHANGE `OUTPT_CO` `OUTPT_CO` decimal(10,0) DEFAULT NULL COMMENT '출력수' ; ALTER TABLE `COMTNUSERLOG` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTNUSERLOG` CHANGE `RQESTER_ID` `RQESTER_ID` varchar(20) NOT NULL DEFAULT '' COMMENT '요청자ID' ; ALTER TABLE `COMTNUSERLOG` CHANGE `SVC_NM` `SVC_NM` varchar(255) NOT NULL DEFAULT '' COMMENT '서비스명' ; ALTER TABLE `COMTNUSERLOG` CHANGE `UPDT_CO` `UPDT_CO` decimal(10,0) DEFAULT NULL COMMENT '수정수' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `APPLCNT_ID` `APPLCNT_ID` varchar(20) NOT NULL COMMENT '신청인ID' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `BGNDE` `BGNDE` char(8) NOT NULL COMMENT '시작일' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `CONFM_AT` `CONFM_AT` char(1) DEFAULT NULL COMMENT '승인여부' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `ENDDE` `ENDDE` char(8) NOT NULL COMMENT '종료일' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `INFRML_SANCTN_ID` `INFRML_SANCTN_ID` char(20) DEFAULT NULL COMMENT '약식결재ID' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `NOON_SE` `NOON_SE` char(1) DEFAULT NULL COMMENT '정오구분' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `OCCRRNC_YEAR` `OCCRRNC_YEAR` char(4) DEFAULT NULL COMMENT '발생년도' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `REQST_DE` `REQST_DE` char(20) NOT NULL COMMENT '신청일' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `RETURN_RESN` `RETURN_RESN` varchar(1000) DEFAULT NULL COMMENT '반환사유' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `SANCTN_DT` `SANCTN_DT` datetime DEFAULT NULL COMMENT '결재일시' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `SANCTNER_ID` `SANCTNER_ID` varchar(20) DEFAULT NULL COMMENT '결재자ID' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `VCATN_RESN` `VCATN_RESN` varchar(200) NOT NULL COMMENT '휴가사유' ; ALTER TABLE `COMTNVCATNMANAGE` CHANGE `VCATN_SE` `VCATN_SE` char(2) NOT NULL COMMENT '휴가구분' ; ALTER TABLE `COMTNWEBLOG` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` datetime DEFAULT NULL COMMENT '발생일' ; ALTER TABLE `COMTNWEBLOG` CHANGE `REQUST_ID` `REQUST_ID` varchar(20) NOT NULL COMMENT '요청ID' ; ALTER TABLE `COMTNWEBLOG` CHANGE `RQESTER_ID` `RQESTER_ID` varchar(20) DEFAULT NULL COMMENT '요청자ID' ; ALTER TABLE `COMTNWEBLOG` CHANGE `RQESTER_IP` `RQESTER_IP` varchar(23) DEFAULT NULL COMMENT '요청자IP' ; ALTER TABLE `COMTNWEBLOG` CHANGE `URL` `URL` varchar(200) DEFAULT NULL COMMENT 'URL' ; ALTER TABLE `COMTNWIKIBKMK` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNWIKIBKMK` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNWIKIBKMK` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNWIKIBKMK` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNWIKIBKMK` CHANGE `USER_ID` `USER_ID` varchar(20) NOT NULL COMMENT '사용자ID' ; ALTER TABLE `COMTNWIKIBKMK` CHANGE `WIKI_BKMK_ID` `WIKI_BKMK_ID` char(20) NOT NULL COMMENT 'Wiki즐겨찾기ID' ; ALTER TABLE `COMTNWIKIBKMK` CHANGE `WIKI_BKMK_NM` `WIKI_BKMK_NM` varchar(1000) NOT NULL COMMENT 'Wiki북마크명' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `ATCH_FILE_ID` `ATCH_FILE_ID` char(20) DEFAULT NULL COMMENT '첨부파일ID' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `CONFM_DT` `CONFM_DT` varchar(14) DEFAULT NULL COMMENT '승인일시' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `NEXTWIK_REPORT_CN` `NEXTWIK_REPORT_CN` mediumtext NOT NULL COMMENT '차주보고내용' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `PARTCLR_MATTER` `PARTCLR_MATTER` varchar(2500) DEFAULT NULL COMMENT '특이사항' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `REPORT_BGNDE` `REPORT_BGNDE` char(20) NOT NULL COMMENT '보고시작일' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `REPORT_DE` `REPORT_DE` char(20) NOT NULL COMMENT '보고일' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `REPORT_ENDDE` `REPORT_ENDDE` char(20) NOT NULL COMMENT '보고종료일' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `REPORTR_ID` `REPORTR_ID` varchar(20) NOT NULL COMMENT '보고자ID' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `REPRT_ID` `REPRT_ID` char(6) NOT NULL COMMENT '보고서ID' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `REPRT_SE` `REPRT_SE` char(1) NOT NULL COMMENT '보고서구분' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `REPRT_SJ` `REPRT_SJ` varchar(255) NOT NULL COMMENT '보고서제목' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `THSWIK_REPORT_CN` `THSWIK_REPORT_CN` mediumtext NOT NULL COMMENT '금주보고내용' ; ALTER TABLE `COMTNWIKMNTHNGREPRT` CHANGE `WRTER_ID` `WRTER_ID` varchar(20) NOT NULL COMMENT '작성자ID' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `ENG_NM` `ENG_NM` varchar(60) DEFAULT NULL COMMENT '영문명' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `SYNONM` `SYNONM` varchar(100) DEFAULT NULL COMMENT '동의어' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `WORD_DC` `WORD_DC` varchar(4000) DEFAULT NULL COMMENT '용어설명' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `WORD_ID` `WORD_ID` char(20) NOT NULL COMMENT '용어ID' ; ALTER TABLE `COMTNWORDDICARYINFO` CHANGE `WORD_NM` `WORD_NM` varchar(255) DEFAULT NULL COMMENT '용어명' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `BDNBR_MNNM` `BDNBR_MNNM` varchar(5) DEFAULT NULL COMMENT '건물번호본번' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `BDNBR_SLNO` `BDNBR_SLNO` varchar(5) DEFAULT NULL COMMENT '건물번호부번' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `BULD_NM` `BULD_NM` varchar(60) DEFAULT NULL COMMENT '건물명' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `CTPRVN_NM` `CTPRVN_NM` varchar(20) DEFAULT NULL COMMENT '시도명' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `DETAIL_BULD_NM` `DETAIL_BULD_NM` varchar(60) DEFAULT NULL COMMENT '상세건물명' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime DEFAULT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) DEFAULT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime DEFAULT NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) DEFAULT NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `RDMN_CODE` `RDMN_CODE` varchar(12) NOT NULL COMMENT '도로명코드' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `RDMN` `RDMN` varchar(60) DEFAULT NULL COMMENT '도로명' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `SIGNGU_NM` `SIGNGU_NM` varchar(20) DEFAULT NULL COMMENT '시군구명' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `SN` `SN` decimal(10,0) NOT NULL COMMENT '일련번호' ; ALTER TABLE `COMTRDNMADRZIP` CHANGE `ZIP` `ZIP` varchar(6) NOT NULL COMMENT '우편번호' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `AVRG_RDCNT` `AVRG_RDCNT` decimal(10,0) DEFAULT NULL COMMENT '평균조회수' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `CREAT_CO` `CREAT_CO` decimal(10,0) DEFAULT NULL COMMENT '생성수' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `DETAIL_STATS_SE` `DETAIL_STATS_SE` varchar(10) NOT NULL DEFAULT '' COMMENT '세부통계구분' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `MUMM_INQIRE_BBSCTT_ID` `MUMM_INQIRE_BBSCTT_ID` varchar(20) DEFAULT NULL COMMENT '최소조회게시글ID' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(20) NOT NULL DEFAULT '' COMMENT '발생일' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `STATS_SE` `STATS_SE` varchar(10) NOT NULL DEFAULT '' COMMENT '통계구분' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `TOP_INQIRE_BBSCTT_ID` `TOP_INQIRE_BBSCTT_ID` varchar(20) DEFAULT NULL COMMENT '최고조회게시글ID' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `TOP_NTCR_ID` `TOP_NTCR_ID` varchar(20) DEFAULT NULL COMMENT '최고게시자ID' ; ALTER TABLE `COMTSBBSSUMMARY` CHANGE `TOT_RDCNT` `TOT_RDCNT` decimal(10,0) DEFAULT NULL COMMENT '총조회수' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `CREAT_CO` `CREAT_CO` decimal(10,0) DEFAULT NULL COMMENT '생성수' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `DELETE_CO` `DELETE_CO` decimal(10,0) DEFAULT NULL COMMENT '삭제수' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `ERROR_CO` `ERROR_CO` decimal(10,0) DEFAULT NULL COMMENT '오류수' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `METHOD_NM` `METHOD_NM` varchar(60) NOT NULL COMMENT '메서드명' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(8) NOT NULL COMMENT '발생일' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `OUTPT_CO` `OUTPT_CO` decimal(10,0) DEFAULT NULL COMMENT '출력수' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `SVC_NM` `SVC_NM` varchar(255) NOT NULL COMMENT '서비스명' ; ALTER TABLE `COMTSSYSLOGSUMMARY` CHANGE `UPDT_CO` `UPDT_CO` decimal(10,0) DEFAULT NULL COMMENT '수정수' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `ERROR_CO` `ERROR_CO` decimal(10,0) DEFAULT NULL COMMENT '오류수' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(20) NOT NULL DEFAULT '' COMMENT '발생일' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `PROVD_INSTT_ID` `PROVD_INSTT_ID` char(8) NOT NULL DEFAULT '' COMMENT '제공기관ID' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `PROVD_SVC_ID` `PROVD_SVC_ID` char(8) NOT NULL DEFAULT '' COMMENT '제공서비스ID' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `PROVD_SYS_ID` `PROVD_SYS_ID` char(8) NOT NULL DEFAULT '' COMMENT '제공시스템ID' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `REQUST_INSTT_ID` `REQUST_INSTT_ID` char(8) NOT NULL DEFAULT '' COMMENT '요청기관ID' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `REQUST_SYS_ID` `REQUST_SYS_ID` char(8) NOT NULL DEFAULT '' COMMENT '요청시스템ID' ; ALTER TABLE `COMTSTRSMRCVLOGSUMMARY` CHANGE `TRSMRCV_SE_CODE` `TRSMRCV_SE_CODE` char(3) NOT NULL DEFAULT '' COMMENT '송수신구분코드' ; ALTER TABLE `COMTSUSERSUMMARY` CHANGE `DETAIL_STATS_SE` `DETAIL_STATS_SE` varchar(10) NOT NULL DEFAULT '' COMMENT '세부통계구분' ; ALTER TABLE `COMTSUSERSUMMARY` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(20) NOT NULL DEFAULT '' COMMENT '발생일' ; ALTER TABLE `COMTSUSERSUMMARY` CHANGE `STATS_SE` `STATS_SE` varchar(10) NOT NULL DEFAULT '' COMMENT '통계구분' ; ALTER TABLE `COMTSUSERSUMMARY` CHANGE `USER_CO` `USER_CO` decimal(10,0) DEFAULT NULL COMMENT '사용자수' ; ALTER TABLE `COMTSWEBLOGSUMMARY` CHANGE `OCCRRNC_DE` `OCCRRNC_DE` char(8) NOT NULL DEFAULT '' COMMENT '발생일' ; ALTER TABLE `COMTSWEBLOGSUMMARY` CHANGE `RDCNT` `RDCNT` decimal(10,0) DEFAULT NULL COMMENT '조회수' ; ALTER TABLE `COMTSWEBLOGSUMMARY` CHANGE `URL` `URL` varchar(200) NOT NULL DEFAULT '' COMMENT 'URL' ; ALTER TABLE `IDS` CHANGE `IDGEN_NEXT_ID` `IDGEN_NEXT_ID` decimal(30,0) NOT NULL COMMENT 'IDGEN다음ID' ; ALTER TABLE `IDS` CHANGE `IDGEN_TABLE_NM` `IDGEN_TABLE_NM` varchar(20) NOT NULL COMMENT 'IDGEN테이블명' ; ALTER TABLE `IMGTEMP` CHANGE `ERNCSL_SE` `ERNCSL_SE` varchar(2) NOT NULL COMMENT '전자관인구분' ; ALTER TABLE `IMGTEMP` CHANGE `IMAGE_INFO` `IMAGE_INFO` blob NOT NULL COMMENT '이미지정보' ; ALTER TABLE `IMGTEMP` CHANGE `IMAGE_TY` `IMAGE_TY` varchar(20) DEFAULT NULL COMMENT '이미지유형' ; ALTER TABLE `IMGTEMP` CHANGE `ORGNZT_CODE` `ORGNZT_CODE` varchar(10) NOT NULL COMMENT '조직코드' ; ALTER TABLE `J_ATTACHFILE` CHANGE `DELETE_YN` `DELETE_YN` varchar(1) DEFAULT NULL COMMENT '삭제 구분' ; ALTER TABLE `J_ATTACHFILE` CHANGE `DOWNLOAD_COUNT` `DOWNLOAD_COUNT` int(11) DEFAULT NULL COMMENT '다운로드 횟수' ; ALTER TABLE `J_ATTACHFILE` CHANGE `DOWNLOAD_EXPIRE_DATE` `DOWNLOAD_EXPIRE_DATE` varchar(8) DEFAULT NULL COMMENT '다운로드 만료일' ; ALTER TABLE `J_ATTACHFILE` CHANGE `DOWNLOAD_LIMIT_COUNT` `DOWNLOAD_LIMIT_COUNT` int(11) DEFAULT NULL COMMENT '다운로드 제한 횟수' ; ALTER TABLE `J_ATTACHFILE` CHANGE `FILE_ID` `FILE_ID` varchar(13) NOT NULL COMMENT '파일 아이디' ; ALTER TABLE `J_ATTACHFILE` CHANGE `FILE_MASK` `FILE_MASK` varchar(100) DEFAULT NULL COMMENT '파일 마스크' ; ALTER TABLE `J_ATTACHFILE` CHANGE `FILE_NAME` `FILE_NAME` varchar(100) NOT NULL COMMENT '파일명' ; ALTER TABLE `J_ATTACHFILE` CHANGE `FILE_SEQ` `FILE_SEQ` int(11) NOT NULL COMMENT '파일 순번' ; ALTER TABLE `J_ATTACHFILE` CHANGE `FILE_SIZE` `FILE_SIZE` int(11) DEFAULT NULL COMMENT '파일 사이즈' ; ALTER TABLE `J_ATTACHFILE` CHANGE `REG_DATE` `REG_DATE` datetime DEFAULT NULL COMMENT '등록일' ; ALTER TABLE `COMTNBLOG` CHANGE `BBS_ID` `BBS_ID` char(20) DEFAULT NULL COMMENT '게시판 ID' ; ALTER TABLE `COMTNBLOG` CHANGE `BLOG_AT` `BLOG_AT` char(2) DEFAULT NULL COMMENT '블로그 여부' ; ALTER TABLE `COMTNBLOG` CHANGE `BLOG_ID` `BLOG_ID` char(20) NOT NULL COMMENT '블로그 ID' ; ALTER TABLE `COMTNBLOG` CHANGE `BLOG_INTRCN` `BLOG_INTRCN` varchar(2400) NULL COMMENT '블로그 소개' ; ALTER TABLE `COMTNBLOG` CHANGE `BLOG_NM` `BLOG_NM` varchar(255) NOT NULL COMMENT '블로그 명' ; ALTER TABLE `COMTNBLOG` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자ID' ; ALTER TABLE `COMTNBLOG` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBLOG` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBLOG` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) NULL COMMENT '최종수정자ID' ; ALTER TABLE `COMTNBLOG` CHANGE `REGIST_SE_CODE` `REGIST_SE_CODE` char(6) NULL COMMENT '등록구분코드' ; ALTER TABLE `COMTNBLOG` CHANGE `TMPLAT_ID` `TMPLAT_ID` char(20) NULL COMMENT '템플릿 ID' ; ALTER TABLE `COMTNBLOG` CHANGE `USE_AT` `USE_AT` char(1) NOT NULL COMMENT '사용여부' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `BLOG_ID` `BLOG_ID` char(20) NOT NULL COMMENT '블로그 ID' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `EMPLYR_ID` `EMPLYR_ID` varchar(20) NOT NULL COMMENT '업무사용자ID' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `FRST_REGISTER_ID` `FRST_REGISTER_ID` varchar(20) NOT NULL COMMENT '최초등록자 ID' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `FRST_REGIST_PNTTM` `FRST_REGIST_PNTTM` datetime NOT NULL COMMENT '최초등록시점' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `LAST_UPDT_PNTTM` `LAST_UPDT_PNTTM` datetime NULL COMMENT '최종수정시점' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `LAST_UPDUSR_ID` `LAST_UPDUSR_ID` varchar(20) NULL COMMENT '최종수정자 ID' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `MBER_STTUS` `MBER_STTUS` varchar(15) NULL COMMENT '회원상태' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `MNGR_AT` `MNGR_AT` char(1) NOT NULL COMMENT '관리자여부' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `SBSCRB_DE` `SBSCRB_DE` datetime NULL COMMENT '가입일자' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `SECSN_DE` `SECSN_DE` char(2) NULL COMMENT '탈퇴일' ; ALTER TABLE `COMTNBLOGUSER` CHANGE `USE_AT` `USE_AT` char(1) NULL COMMENT '사용여부' ;