You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2156 lines
227 KiB
SQL
2156 lines
227 KiB
SQL
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 = '비품관리';
|
|
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 COMTCMOBILEIDSERVICE COMMENT = 'SP 서비스';
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO COMMENT = 'SP 거래정보';
|
|
|
|
|
|
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(30) 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(30) 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(30) 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(30) 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(30) 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(30) 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(30) 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 DELETE_AT DELETE_AT char(1) DEFAULT NULL COMMENT '삭제여부' ;
|
|
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(30) 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(30) 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(30) 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 '사용여부' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE SVCCODE SVCCODE VARCHAR(50) NOT NULL COMMENT '서비스코드' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE PRESENTTYPE PRESENTTYPE INTEGER NOT NULL DEFAULT 1 COMMENT '현재타입' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE ENCRYPTTYPE ENCRYPTTYPE INTEGER NOT NULL DEFAULT 2 COMMENT '암호화타입' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE KEYTYPE KEYTYPE INTEGER NOT NULL DEFAULT 2 COMMENT '키타입' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE AUTHTYPE AUTHTYPE VARCHAR(50) DEFAULT NULL COMMENT '인증타입' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE SPNAME SPNAME VARCHAR(100) NOT NULL COMMENT 'SP명' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE SERVICENAME SERVICENAME VARCHAR(100) NOT NULL COMMENT '서비스명' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE ATTRLIST ATTRLIST VARCHAR(100) DEFAULT NULL COMMENT '고정속성목록' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE PREDLIST PREDLIST VARCHAR(100) DEFAULT NULL COMMENT '비교속성목록' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE CALLBACKURL CALLBACKURL VARCHAR(100) DEFAULT NULL COMMENT '콜백URL' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE REGDT REGDT TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() COMMENT '등록일' ;
|
|
ALTER TABLE COMTCMOBILEIDSERVICE CHANGE UDTDT UDTDT TIMESTAMP NULL DEFAULT NULL COMMENT '수정일' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE TRXCODE TRXCODE VARCHAR(50) NOT NULL COMMENT '거래코드' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE SVCCODE SVCCODE VARCHAR(50) NOT NULL COMMENT '서비스코드' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE OPMODE OPMODE VARCHAR(50) NOT NULL COMMENT '모드' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE DEVICEID DEVICEID VARCHAR(100) DEFAULT NULL COMMENT '키오스크 ID' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE BRANCHNAME BRANCHNAME VARCHAR(100) DEFAULT NULL COMMENT '지점명' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE NONCE NONCE VARCHAR(100) DEFAULT NULL COMMENT 'DID해시' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE ZKPNONCE ZKPNONCE VARCHAR(100) DEFAULT NULL COMMENT '영지식해시' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE VPVERIFYRESULT VPVERIFYRESULT VARCHAR(1) NOT NULL DEFAULT 'N' COMMENT 'VP검증결과' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE TRXSTSCODE TRXSTSCODE VARCHAR(4) NOT NULL DEFAULT '0001' COMMENT '거래상태코드' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE PROFILESENDDT PROFILESENDDT TIMESTAMP NULL DEFAULT NULL COMMENT '프로파일전송일' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE IMGSENDDT IMGSENDDT TIMESTAMP NULL DEFAULT NULL COMMENT '이미지전송일' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE VPRECEPTDT VPRECEPTDT TIMESTAMP NULL DEFAULT NULL COMMENT 'VP수신일' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE ERRORCN ERRORCN VARCHAR(4000) DEFAULT NULL COMMENT '오류상세' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE REGDT REGDT TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() COMMENT '등록일' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE UDTDT UDTDT TIMESTAMP NULL DEFAULT NULL COMMENT '수정일' ;
|
|
ALTER TABLE COMTSMOBILEIDTRXINFO CHANGE VPNAME VPNAME VARCHAR(50) COMMENT '검증자이름' ; |