/* Sequence 저장테이블 */ INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ADBKUSER_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ADBK_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ADMINIST_WORD_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ADMIN_CODE_OPERT', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ANN_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('BACKUP_OPERT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('BACKUP_RESULT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('BANNER_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('BATCH_OPERT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('BATCH_RESULT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('BATCH_SCHDUL_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('BBS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CLB_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CMMNTY_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CNSLT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CNTC_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CNTC_MESSAGE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CNTNTS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('COMTECOPSEQ', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CPYRHT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('CTSNN_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('DAM_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('DB_MNTRNG_LOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('DEPT_JOB_BX_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('DEPT_JOB_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('DIARY_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('DUS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('EVENTINFO_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('EVENT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('EXTRLHRINFO_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('FAQ_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('FILESYS_LOGID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('FILESYS_MNTRNG', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('FILE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('GROUP_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('HPCM_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('HTTL_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('HTTP_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('INDVDL_INFO_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('INFRML_SANCTN', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('INSTT_CODE_OPERT', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('INSTT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ISG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ITEM_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('KNO_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('KNO_ID2', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('LEADER_SCHDUL_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('LOGINLOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('LSI_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('MAILMSG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('MEMO_REPRT', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('MEMO_TODO_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('MSI_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('MTG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('MTG_PLACE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NCRD_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NEWS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NOTE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NOTE_RECPTN_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NOTE_TRNSMIT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NTWRKSVC_LOGID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NTWRK_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ONLINE_MUL_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('POLL_IEM_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('POLL_MGR_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('POLL_RUT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('POPUP_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('PROC_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('PROL_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('PROXYLOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('PROXYSVC_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('QA_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('QESITM_', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('QESRSPNS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('QESTNR_QESITM_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('QESTNR_RPD_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('QUSTNRQESTN_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('QUSTNRTMPLA_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('RECOMEND_SITE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('RESTDE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('RESVE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ROLE_ID', 20); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('RSS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('RS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('RWARD_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SCHDUL_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SCRAP_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SERVER_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SEVEQ_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SITE_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SMS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SRCHWRD_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SRCHWRD_MANAGEID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SRCHWRD_MANAGE_I', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SVCRESMONTLOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SVC_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SYNCHRNSERVER_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SYSLOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('SYS_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('TEST1', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('TMPLAT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('TROBL_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('TRSMRCVLOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('TR_MNTRNG_LOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('UNITY_LINK_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('USE_STPLAT_ID', 3); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('USRCNFRM_ID', 3); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('WEBLOG_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('WIKI_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('WIKMNTHNG_REPRT', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('WORD_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('NTT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ORGNZT_ID', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ANSWER_NO', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('STSFDG_NO', 1); INSERT INTO COMTECOPSEQ ( TABLE_NAME, NEXT_ID ) VALUES ('ROUGHMAP_ID', 1); /* 공통분류코드 */ INSERT INTO COMTCCMMNCLCODE(CL_CODE, CL_CODE_NM, CL_CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', '전자정부 프레임워크 공통서비스', '전자정부 프레임워크 공통서비스', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); /* 공통코드 */ INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM001', '등록구분', '게시판, 커뮤니티, 동호회 등록구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM002', '이력구분', '시스템이력등록구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM003', '업무구분', '업무구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM004', '게시판유형', '게시판유형구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM005', '템플릿유형', '템플릿유형구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM006', '승인유형', '동호회, 커뮤니티 승인 유형', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM007', '승인상태', '동호회, 커뮤니티 승인 상태', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM008', '처리상태', '송수신 요청의 처리상태', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM009', '게시판속성', '게시판 속성', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM010', '권한유형', '시스템을 사용하기 위한 권한 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM011', '롤유형', '시스템의 기능을 사용하기 위한 롤 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM012', '회원유형', '일반/기업/업무담당자를 구현하기 위한 사용자 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM013', '회원상태', '회원 가입 신청/승인/삭제를 위한 상태 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM014', '성별구분', '남녀 성별 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM015', '인증방식유형', '주민등록번호 인증, Gpin 인증과 같은 사용자 인증 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM016', '변경요청처리 상태', '프로그램 변경의 요청/처리 등의 변경요청 상태 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM017', '휴일구분', '휴일의 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM018', '질문유형', '질문유형 객관식/주관식 상태구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM019', '일정중요도', '일정중요도 낮음/보통/높음 상태구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM020', '일정구분', '일정구분 부서일지정보/일지정보 상태구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM021', '도움말구분', '도움말 설명 구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM022', '비밀번호 힌트', '비밀번호 힌트 구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM023', '사이트주제분류', '사이트주제분류 설명 구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM024', '발송결과구분', '발송메일 수신결과 구분 코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM025', '소속기관', '소속기관정보를 관리할때 사용하는 구분코드(시스템별로 재정의)', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM026', '기업구분', '기업구분정보를 관리할때 사용하는 구분코드(시스템별로 재정의)', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM027', '업종', '대표업종코드(시스템별로 재정의)', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM028', '질의응답처리상태', 'Q/A 처리상태코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM029', '롤유형코드', '', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM030', '일정구분', '일정구분 코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM031', '반복구분', '일정 반복구분 코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM032', '작업유형', '승인이력 작업유형', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM033', '시스템로그구분', '', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM034', '직업유형', '직업유형코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM035', '행사유형', '행사/이벤트/캠페인 구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM036', '보고서 진행상태코드', '보고서의 진행상태를 코드화 하여 관리한다.', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM038', '온라인POLL페기유무', '온라인POLL-온라인POLL페기유무', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM039', '온라인POLL구분', '온라인POLL-온온라인POLL구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM040', '보고서 종류코드', '보고서 종류코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM041', '온라인메뉴얼구분', '온라인메누얼-온라인메뉴얼구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM042', '보고서통계기간구분', '보고서통계기간구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM043', '기관코드변경구분', '기관코드변경구분', 'Y', SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM044', '기관코드수신처리구분', '기관코드수신처리구분', 'Y', SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM045', '사용여부', '사용여부', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM046', '모니터링상태구분', '모니터링상태구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM047', '실행주기구분', '실행주기구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM048', 'DBMS종류', 'DBMS종류', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM049', '압축구분', '압축구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM050', '수신구분', '쪽지관리', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM051', '승인여부', '승인여부구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM052', '달력구분', '달력구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM053', '행사구분', '행사구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM054', '경조구분', '경조구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM055', '포상구분', '포상구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM056', '휴가구분', '휴가구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM057', '일정구분', '일정구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM058', '반복구분코드', '반복구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM059', '우선순위', '우선순위', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM060', '보고서구분', '보고서구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM061', '간부상태', '간부상태', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM062', ' HTTP상태코드', 'HTTP상태코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM063', '상태관리', '상태관리', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM064', '서버종류코드', '서버종류코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM065', '장애종류코드', '장애종류코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM066', '서버자원종류', '서버자원종류', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM067', '네트워크관리항목', '네트워크관리항목', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM068', '처리상태코드', '처리상태코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM069', '기념일구분', '기념일구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM070', '위치구분', '회의실 위치구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM071', '당직체크구분', '당직체크구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM072', '서비스상태', '서비스상태', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM073', '가족관계', '가족관계', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM074', '요일구분', '요일구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM075', '업무구분코드', '업무구분코드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM076', '실행상태구분', '실행상태구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM101', '게시판유형', '게시판유형', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNCODE(CL_CODE, CODE_ID, CODE_ID_NM, CODE_ID_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID,LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('EFC', 'COM102', '단어구분', '단어구분', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); /* 공통상세코드 */ INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM001', 'REGC01', '단일 게시판 이용등록', '단일 게시판 이용등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM001', 'REGC02', '커뮤니티 등록', '커뮤니티 등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM001', 'REGC03', '동호회 등록', '동호회 등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM001', 'REGC04', '명함등록', '명함등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM001', 'REGC05', '동호회 게시판 등록', '동호회 게시판 등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM001', 'REGC06', '커뮤니티 게시판 등록', '커뮤니티 게시판 등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM001', 'REGC07', '게시판사용자등록', '게시판사용자등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM002', 'HIST01', '소프트웨어패치', '소프트웨어패치', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM002', 'HIST02', '소프트웨어설치', '소프트웨어설치', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM002', 'HIST03', '소프트웨어삭제', '소프트웨어삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM002', 'HIST04', '하드웨어업그레이드', '하드웨어업그레이드', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM002', 'HIST05', '하드웨어삭제', '하드웨어삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM003', 'BBS', '게시판', '게시판', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM003', 'CMY', '커뮤니티', '커뮤니티', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM003', 'CLB', '동호회', '동호회', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM003', 'NCD', '명함', '명함', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM004', 'BBST01', '일반게시판', '일반게시판', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM004', 'BBST02', '익명게시판', '익명게시판', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM004', 'BBST03', '공지게시판', '공지게시판', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM004', 'BBST04', '방명록', '방명록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM005', 'TMPT01', '게시판템플릿', '게시판템플릿', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM005', 'TMPT02', '커뮤니티템플릿', '커뮤니티템플릿', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM005', 'TMPT03', '동호회템플릿', '동호회템플릿', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF01', '커뮤니티등록', '커뮤니티등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF02', '커뮤니티삭제', '커뮤니티삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF03', '동호회등록', '동호회등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF04', '동호회삭제', '동호회삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF05', '커뮤니티운영자등록', '커뮤니티운영자등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF06', '커뮤니티운영자삭제', '커뮤니티운영자삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF07', '동호회운영자등록', '동호회운영자등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF08', '동호회운영자삭제', '동호회운영자삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF09', '게시판이용등록', '게시판이용등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF10', '게시판삭제', '게시판삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF11', '커뮤니티사용자등록', '커뮤니티사용자등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF12', '커뮤니티사용자탈퇴', '커뮤니티사용자탈퇴', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF13', '동호회사용자등록', '동호회사용자등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM006', 'CF14', '동호회사용자탈퇴', '동호회사용자탈퇴', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM007', 'AP01', '승인요청', '승인요청', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM007', 'AP02', '승인허가', '승인허가', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM007', 'AP03', '승인반려', '승인반려', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM008', 'S01', '전송요청', '전송요청', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM008', 'S02', '전송완료', '전송완료', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM008', 'S03', '전송실패', '전송실패', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM008', 'S04', '수신요청', '수신요청', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM008', 'S05', '수신완료', '수신완료', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM008', 'S06', '수신실패', '수신실패', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM009', 'BBSA01', '유효게시판', '유효게시판', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM009', 'BBSA02', '갤러리', '갤러리', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM009', 'BBSA03', '일반게시판', '일반게시판', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM010', 'PRVS001', '시스템 관련 권한(최상위 권한)', '시스템 관련 권한(최상위 권한)', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM010', 'PRVD001', '데이터베이스 관련 권한', '데이터베이스 관련 권한', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM010', 'PRVU001', '사용자 관련 권한', '사용자 관련 권한', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM010', 'PRVA001', '어플리케이션 관련 권한', '어플리케이션 관련 권한', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM010', 'PRVB001', '게시판 관련 권한', '게시판 관련 권한', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM010', 'PRVC001', '커뮤니티 관련 권한', '커뮤니티 관련 권한', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLS001', '시스템 관리 최상위 롤', '시스템 관리 최상위 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLS002', '시스템 접근(view) 롤', '시스템 접근(view) 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLS003', '시스템 설정 등록/변경 롤', '시스템 설정 등록/변경 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLS004', '시스템 파일 등록/변경 롤', '시스템 파일 등록/변경 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLD001', '데이터베이스 관련 최상위 롤', '데이터베이스 관련 최상위 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLD002', '데이터베이스 스키마 등록/변경 롤', '데이터베이스 스키마 등록/변경 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLD003', '데이터 조회 롤', '데이터 조회 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLD004', '데이터 등록/변경 롤', '데이터 등록/변경 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLU001', '사용자 관련 최상위 롤', '사용자 관련 최상위 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLU002', '업무 시스템 사용자 관리 롤', '업무 시스템 사용자 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLU003', '기업회원 시스템 사용자 관리 롤', '기업회원 시스템 사용자 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLU004', '일반회원 시스템 사용자 관리 롤', '일반회원 시스템 사용자 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLU005', '게시판 사용자 관리 롤', '게시판 사용자 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLU006', '커뮤니티 사용자 관리 롤', '커뮤니티 사용자 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA001', '어플리케이션 관련 최상위 롤', '어플리케이션 관련 최상위 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA002', '업무 어플리케이션 접근 롤', '업무 어플리케이션 접근 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA003', '업무 어플리케이션 관리 롤', '업무 어플리케이션 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA004', '일반 어플리케이션 접근 롤', '일반 어플리케이션 접근 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA005', '일반 어프리케이션 관리 롤', '일반 어프리케이션 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA006', '어플리케이션 약관 관리 롤', '어플리케이션 약관 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA007', '어플리케이션 저작권 관리 롤', '어플리케이션 저작권 관리 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLA008', '통계 및 보고서 접근 롤', '통계 및 보고서 접근 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLB001', '게시판 관련 최상위 롤', '게시판 관련 최상위 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLB002', '게시판 생성 롤', '게시판 생성 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLB003', '게시판 접근 롤', '게시판 접근 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLB004', '게시판 글쓰기 롤', '게시판 글쓰기 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLB005', '게시판 글 수정/삭제 롤', '게시판 글 수정/삭제 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLC001', '커뮤니티 관련 최상위 롤', '커뮤니티 관련 최상위 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLC002', '커뮤니티 생성 롤', '커뮤니티 생성 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLC003', '커뮤니티 접근 롤', '커뮤니티 접근 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLC004', '커뮤니티 글쓰기 롤', '커뮤니티 글쓰기 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLC005', '커뮤니티 글 수정/삭제 롤', '커뮤니티 글 수정/삭제 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM011', 'ROLC006', '파일 업로드 롤', '파일 업로드 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM012', 'USR01', '일반 회원 유형', '일반 회원 유형', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM012', 'USR02', '기업 회원 유형', '기업 회원 유형', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM012', 'USR03', '업무 담당자(사용자) 유형', '업무 담당자(사용자) 유형', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM012', 'USR99', '사용자 유형 최상위 롤', '사용자 유형 최상위 롤', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM013', 'A', '회원 가입 신청 상태', '회원 가입 신청 상태', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM013', 'P', '회원 가입 승인 상태', '회원 가입 승인 상태', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM013', 'D', '회원 가입 삭제 상태', '회원 가입 삭제 상태', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM014', 'M', '남자', '남자', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM014', 'F', '여자', '여자', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM015', 'ATH01', '주민등록번호 인증', '주민등록번호 인증', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM015', 'ATH02', 'GPIN 인증', 'GPIN 인증', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM016', 'PUR01', '프로그램 변경 요청 신청', '프로그램 변경 요청 신청', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM016', 'PUR02', '프로그램 변경 요청 수락', '프로그램 변경 요청 수락', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM016', 'PUR03', '프로그램 변경 진행', '프로그램 변경 진행', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM016', 'PUR04', '프로그램 변경 완료', '프로그램 변경 완료', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM016', 'PUR05', '프로그램 변경 이관', '프로그램 변경 이관', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM017', '01', '법정휴일', '법정휴일', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM017', '02', '법정공휴일', '법정공휴일', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM017', '03', '임시공휴일', '임시공휴일', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM018', '1', '객관식', '객관식', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM018', '2', '주관식', '주관식', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM019', 'A', '높음', '높음', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM019', 'B', '보통', '보통', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM019', 'C', '낮음', '낮음', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM020', '1', '부서일정관리', '부서일정관리', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM020', '2', '일정관리', '일정관리', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM021', '1', '기능설명', '기능설명', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM021', '2', '절차설명', '절차설명', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P01', '가장 기억에 남는 장소는?', '가장 기억에 남는 장소는?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P02', '나의 좌우명은?', '나의 좌우명은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P03', '나의 보물 제1호는?', '나의 보물 제1호는?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P04', '가장 기억에 남는 선생님 성함은?', '가장 기억에 남는 선생님 성함은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P05', '다른 사람은 모르는 나만의 신체비밀은?', '다른 사람은 모르는 나만의 신체비밀은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P06', '오래도록 기억하고 싶은 날짜는?', '오래도록 기억하고 싶은 날짜는?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P07', '받았던 선물 중 기억에 남는 독특한 선물은?', '받았던 선물 중 기억에 남는 독특한 선물은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P08', '가장 생각나는 친구 이름은?', '가장 생각나는 친구 이름은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P09', '인상 깊게 읽은 책 이름은?', '인상 깊게 읽은 책 이름은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P10', '내가 존경하는 인물은?', '내가 존경하는 인물은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P11', '나의 노래방 애창곡은?', '나의 노래방 애창곡은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P12', '가장 감명깊게 본 영화는?', '가장 감명깊게 본 영화는?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM022', ' P13', '좋아하는 스포츠팀 이름은?', '좋아하는 스포츠팀 이름은?', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM023', '01', '경제', '경제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM023', '02', '전산', '전산', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM023', '03', '행정', '행정', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM024', 'R', '요청', '요청', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM024', 'F', '실패', '실패', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM024', 'C', '완료', '완료', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM025', '00000001', '공공기관', '공공기관', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM025', '00000002', '금융기관', '금융기관', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM025', '00000003', '교육기관', '교육기관', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM025', '00000004', '의료기관', '의료기관', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM026', 'C0000001', '대기업', '대기업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM026', 'C0000002', '중소기업', '중소기업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM026', 'C0000003', '다국적기업', '다국적기업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'A', '축산업', '축산업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'B', '어업', '어업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'C', '광업', '광업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'D', '제조업', '제조업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'E', '전기,가스및수도사업', '전기,가스및수도사업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'F', '건설업', '건설업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'G', '도소매 및 소비자용품수리업', '도소매 및 소비자용품수리업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'H', '숙박및음식점', '숙박및음식점', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'I', '운수창고및통신업', '운수창고및통신업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'J', '금융및보험업', '금융및보험업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'K', '부동산,임대및사업서비스업', '부동산,임대및사업서비스업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'M', '교육서비스업', '교육서비스업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'N', '보건업', '보건업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'O', '기타공공,사회및개인서비스업', '기타공공,사회및개인서비스업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM027', 'P', '가사서비스업', '가사서비스업', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM028', '1', '접수대기', '접수대기', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM028', '2', '접수', '접수', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM028', '3', '완료', '완료', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM029', 'method', 'METHOD', 'METHOD', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM029', 'pointcut', 'POINTCUT', 'POINTCUT', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM029', 'url', 'URL', 'URL', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM030', '1', '회의', '회의', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM030', '2', '세미나', '세미나', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM030', '3', '강의', '강의', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM030', '4', '교육', '교육', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM030', '5', '기타', '기타', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM030', '6', '휴일', '휴일', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM031', '1', '당일', '당일', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM031', '2', '반복', '반복', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM031', '3', '연속', '연속', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM031', '4', '요일반복', '요일반복', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC01', '회원가입', '회원가입', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC02', '사용자등록', '사용자등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC03', '회원탈퇴', '회원탈퇴', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC04', '사용자삭제', '사용자삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC05', '커뮤니티등록', '커뮤니티등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC06', '동호회등록', '동호회등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC07', '커뮤니티폐쇄', '커뮤니티폐쇄', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC08', '동호회폐쇄', '동호회폐쇄', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC09', '게시판등록', '게시판등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM032', 'WC10', '게시판폐쇄', '게시판폐쇄', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM033', 'C', '생성', '생성', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM033', 'R', '조회', '조회', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM033', 'U', '수정', '수정', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM033', 'D', '삭제', '삭제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM034', '1', '학생', '학생', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM034', '2', '대학생', '대학생', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM034', '3', '군인', '군인', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM034', '4', '교사', '교사', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM034', '5', '기타', '기타', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM035', '1', '행사', '행사', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM035', '2', '이벤트', '이벤트', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM035', '3', '캠페인', '캠페인', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM036', '01', '작성', '작성', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM036', '02', '상신', '상신', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM036', '03', '반려', '반려', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM036', '04', '결재완료', '결재완료', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM038', 'N', 'N', '아니오', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM038', 'Y', 'Y', '예', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM039', '001', '사회', '사회', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM039', '002', '정치', '정치', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM039', '003', '경제', '경제', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM039', '004', '문화', '문화', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM039', '005', '인문', '인문', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM039', '006', '공학', '공학', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM039', '007', '기타', '기타', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM040', '01', '휴가계획서', '휴가계획서', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM040', '02', '출장보고서', '출장보고서', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM040', '03', '교육보고서', '교육보고서', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM040', '04', '판품요청서', '판품요청서', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM040', '05', '지원요청서', '지원요청서', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM041', '001', '절차설명', '절차설명', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM041', '002', '기능설명', '기능설명', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM041', '003', '기타설명', '기타설명', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM042', '%Y', '연도별', '연도별', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM042', '%Y-%m', '월별', '월별', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM042', '%Y-%m-%d', '일별', '일별', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM043', '01', '생성', '생성', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM043', '02', '변경', '변경', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM043', '03', '말소', '말소', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM044', '00', '수신처리', '수신처리', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM044', '01', '처리완료', '처리완료', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM044', '10', '기등록', '기등록', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM044', '11', '생성오류', '생성오류', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM044', '12', '변경오류', '변경오류', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM044', '13', '말소오류', '말소오류', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM046', '01', '정상', '정상', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM046', '02', '비정상', '비정상', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM047', '01', '매일', '매일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM047', '02', '매주', '매주', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM047', '03', '매월', '매월', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM047', '04', '매년', '매년', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM047', '05', '한번만', '한번만', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM048', '01', 'Oracle', 'Oracle', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM048', '02', 'Mysql', 'Mysql', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM048', '03', 'Tibero', 'Tibero', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM048', '04', 'Altibase', 'Altibase', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM049', '01', 'Tar', 'Tar', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM049', '02', 'ZIP', 'ZIP', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM050', '1', '수신', '수신', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM050', '2', '참조', '참조', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM051', '01', '신청중', '신청중', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM051', '02', '승인', '승인', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM051', '03', '반려', '반려', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM052', '01', '양력', '양력', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM052', '02', '음력', '음력', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM053', '01', '교육', '교육', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM053', '02', '세미나', '세미나', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM053', '03', '홍보', '홍보', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM053', '04', '단합', '단합', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM053', '05', '간담회', '간담회', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM053', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM054', '01', '결혼', '결혼', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM054', '02', '출생', '출생', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM054', '03', '회갑', '회갑', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM054', '04', '사망', '사망', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM054', '05', '출산', '출산', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM054', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM055', '01', '우수사원', '우수사원', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM055', '02', '우수팀', '우수팀', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM055', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM056', '01', '연차휴가', '연차휴가', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM056', '02', '반차휴가', '반차휴가', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM056', '03', '무급휴가', '무급휴가', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM056', '04', '유급휴가', '유급휴가', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM056', '05', '대체휴가', '대체휴가', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM056', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM057', '1', '회의', '회의', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM057', '2', '방문', '방문', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM057', '3', '세미나', '세미나', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM057', '4', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM058', '1', '반복없음', '당일', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM058', '2', '매일', '매일', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM058', '3', '매주', '매주', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM058', '4', '매월', '매월', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM059', '1', '높음', '높음', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM059', '2', '보통', '보통', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM059', '3', '낮음', '낮음', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM060', '1', '주간보고', '주간보고', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM060', '2', '월간보고', '월간보고', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM061', '1', '재실', '재실', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM061', '2', '자리비움', '자리비움', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM061', '3', '회의중', '회의중', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM061', '4', '출장중', '출장중', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM061', '5', '휴가중', '휴가중', 'Y', SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '100', 'Continue ', 'Continue ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '101', 'Switching Protocols ', 'Switching Protocols ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '200', 'OK ', 'OK ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '201', 'Created ', 'Created ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '202', 'Accepted ', 'Accepted ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '203', 'Non-Authoritative Information ', 'Non-Authoritative Information ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '204', 'No Content ', 'No Content ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '205', 'Reset Content ', 'Reset Content ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '206', 'Partial Content ', 'Partial Content ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '300', 'Multiple Choices ', 'Multiple Choices ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '301', 'Moved Permanently ', 'Moved Permanently ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '302', 'Found ', 'Found ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '303', 'See Other ', 'See Other ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '304', 'Not Modified ', 'Not Modified ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '305', 'Use Proxy ', 'Use Proxy ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '307', 'Temporary Redirect ', 'Temporary Redirect ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '400', 'Bad Request ', 'Bad Request ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '401', 'Unauthorized ', 'Unauthorized ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '403', 'Forbidden ', 'Forbidden ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '404', 'Not Found ', 'Not Found ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '405', 'Method Not Allowed ', 'Method Not Allowed ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '406', 'Not Acceptable ', 'Not Acceptable ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '407', 'Proxy Authentication Required ', 'Proxy Authentication Required ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '408', 'Request Timeout ', 'Request Timeout ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '409', 'Conflict ', 'Conflict ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '410', 'Gone ', 'Gone ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '411', 'Length Required ', 'Length Required ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '412', 'Precondition Failed ', 'Precondition Failed ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '413', 'Request Entity Too Large ', 'Request Entity Too Large ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '414', 'Request URI Too Long ', 'Request URI Too Long ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '415', 'Unsupported Media Type ', 'Unsupported Media Type ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '416', 'Requested Range Not Satisfiable ', 'Requested Range Not Satisfiable ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '417', 'Expectation Failed ', 'Expectation Failed ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '500', 'Internal Server Error ', 'Internal Server Error ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '501', 'Not Implemented ', 'Not Implemented ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '502', 'Bad Gateway ', 'Bad Gateway ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '503', 'Service Unavailable ', 'Service Unavailable ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '504', 'Gateway Timeout ', 'Gateway Timeout ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM062', '505', 'HTTP Version Not Supported ', 'HTTP Version Not Supported ', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM063', '100', 'Runnable', 'Runnable', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM063', '200', 'Sleeping', 'Sleeping', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM063', '300', 'Swapped', 'Swapped', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM063', '400', 'Zombie', 'Zombie', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM063', '500', 'Stopped', 'Stopped', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM064', '01', '웹 서버', '웹 서버', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM064', '02', 'WAS', 'WAS', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM064', '03', 'DB 서버', 'DB 서버', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM064', '04', 'Mail 서버', 'Mail 서버', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM064', '05', 'DNS 서버', 'DNS 서버', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM064', '99', '기타 서버', '기타 서버', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '01', '네트워크 장애', '네트워크 장애', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '02', '하드웨어 장애', '하드웨어 장애', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '03', '어플리케이션 장애', '어플리케이션 장애', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '04', '서비스 장애', '서비스 장애', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '05', '모니터링 장애', '모니터링 장애', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '06', '정전', '정전', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '07', '화재', '화재', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '08', '홍수', '홍수', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM065', '99', '기타 장애', '기타 장애', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM066', '01', 'CPU', 'CPU', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM066', '02', '메모리', '메모리', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM067', '01', '서버', '서버', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM067', '02', '라우터', '라우터', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM067', '03', '스위치', '스위치', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM067', '04', 'PC', 'PC', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM067', '05', '프린터', '프린터', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM067', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM068', 'A', '접수', '접수', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM068', 'C', '완료', '완료', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM068', 'R', '요청', '요청', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '01', '생일', '생일', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '02', '기념', '기념', 'N',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '03', '결혼', '결혼', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '04', '탄생', '탄생', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '05', '축하', '축하', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '06', '출장', '출장', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '07', '퇴원', '퇴원', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM069', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '01', '본관1층', '본관1층', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '02', '본관2층', '본관2층', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '03', '본관3층', '본관3층', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '04', '본관4층', '본관4층', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '05', '본관5층', '본관5층', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '06', '별관1층', '별관1층', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '07', '별관2층', '별관2층', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM070', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM', SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM071', '01', '전기시설', '전기시설', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM071', '02', '소등상태', '소등상태', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM071', '03', '방화요소', '방화요소', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM071', '04', '소방시설', '소방시설', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM071', '05', '비상 KEY', '비상 KEY', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM071', '06', '시건장치', '시건장치', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM071', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM072', '01', '정상', '정상', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM072', '02', '오류', '오류', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM072', '03', '중지', '중지', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM072', '09', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '01', '본인', '본인', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '02', '배우자', '배우자', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '03', '자녀', '자녀', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '04', '부친', '부친', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '05', '모친', '모친', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '06', '배우자부친', '배우자부친', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '07', '배우자모친', '배우자모친', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '08', '조부', '조부', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '09', '조모', '조모', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '10', '형제자매(본인)', '형제자매(본인)', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '11', '외조부', '외조부', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '12', '외조모', '외조모', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '13', '백숙부', '백숙부', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '14', '백숙모', '백숙모', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '15', '형제자매(배우자)', '형제자매(배우자)', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM073', '99', '기타', '기타', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM074', '1', '일요일', '일요일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM074', '2', '월요일', '월요일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM074', '3', '화요일', '화요일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM074', '4', '수요일', '수요일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM074', '5', '목요일', '목요일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM074', '6', '금요일', '금요일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM074', '7', '토요일', '토요일', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM075', '001', '경조신청', '경조신청', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM075', '002', '포상신청', '포상신청', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM075', '003', '휴가신청', '휴가신청', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM075', '004', '행사신청', '행사신청', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM076', '01', '정상', '정상', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM076', '02', '비정상', '비정상', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM076', '03', '수행중', '수행중', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM101', 'BBST01', '통합게시판', '통합게시판', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM101', 'BBST02', '블로그형게시판', '블로그형게시판', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM101', 'BBST03', '방명록', '방명록', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM102', '1', '표준어', '표준어', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); INSERT INTO COMTCCMMNDETAILCODE(CODE_ID, CODE, CODE_NM, CODE_DC, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID) VALUES ('COM102', '2', '동의어', '동의어', 'Y',SYSDATE(), 'SYSTEM',SYSDATE(), 'SYSTEM'); /* 권한그룹정보 */ INSERT INTO COMTNAUTHORGROUPINFO ( GROUP_ID, GROUP_NM, GROUP_CREAT_DE,GROUP_DC ) VALUES ( 'GROUP_00000000000000', '0번 그룹입니다', SYSDATE(), '0번 그룹입니다'); /* 일반회원 */ INSERT INTO COMTNGNRLMBER (MBER_ID,PASSWORD,PASSWORD_HINT,PASSWORD_CNSR,IHIDNUM,MBER_NM,ZIP,ADRES,AREA_NO,MBER_STTUS,DETAIL_ADRES,END_TELNO,MBTLNUM,GROUP_ID,MBER_FXNUM,MBER_EMAIL_ADRES,MIDDLE_TELNO,SBSCRB_DE,SEXDSTN_CODE,ESNTL_ID) values ('USER','6TAJYwhKCgkgzPXDb83ZUiHi2/TKHhD7t5Ba6RN2qoo=','P01','전자정부표준프레임워크센터',null,'일반회원','100775','서울 중구 무교동 한국정보화진흥원','02','P','전자정부표준프레임워크센터','2059','1566-2059','GROUP_00000000000000','1566-2059','egovframesupport@gmail.com','1566',SYSDATE(),'F','USRCNFRM_00000000001'); /* 조직정보 */ INSERT INTO COMTNORGNZTINFO ( ORGNZT_ID, ORGNZT_NM, ORGNZT_DC ) VALUES ( 'ORGNZT_0000000000000', '기본조직', '기본조직'); /* 업무사용자정보 */ INSERT INTO COMTNEMPLYRINFO (EMPLYR_ID, ORGNZT_ID, USER_NM, PASSWORD, EMPL_NO, IHIDNUM, SEXDSTN_CODE, BRTHDY, FXNUM, HOUSE_ADRES, PASSWORD_HINT, PASSWORD_CNSR, HOUSE_END_TELNO, AREA_NO, DETAIL_ADRES, ZIP, OFFM_TELNO, MBTLNUM, EMAIL_ADRES, OFCPS_NM, HOUSE_MIDDLE_TELNO, GROUP_ID, PSTINST_CODE, EMPLYR_STTUS_CODE, ESNTL_ID, CRTFC_DN_VALUE, SBSCRB_DE) VALUES ('TEST1','ORGNZT_0000000000000','테스트1', 'raHLBnHFcunwNzcDcfad4PhD11hHgXSUr7fc1Jk9uoQ=','20112059',null,'F','20111130','1566-2059','서울 중구 무교동 한국정보화진흥원','P01','전자정부표준프레임워크센터','2059','02','전자정부표준프레임워크센터','100775','1566-2059','1566-2059','egovframesupport@gmail.com','관리자','1566','GROUP_00000000000000','00000001','P','USRCNFRM_00000000000','',SYSDATE()); INSERT INTO COMTNEMPLYRINFO (EMPLYR_ID, ORGNZT_ID, USER_NM, PASSWORD, EMPL_NO, IHIDNUM, SEXDSTN_CODE, BRTHDY, FXNUM, HOUSE_ADRES, PASSWORD_HINT, PASSWORD_CNSR, HOUSE_END_TELNO, AREA_NO, DETAIL_ADRES, ZIP, OFFM_TELNO, MBTLNUM, EMAIL_ADRES, OFCPS_NM, HOUSE_MIDDLE_TELNO, GROUP_ID, PSTINST_CODE, EMPLYR_STTUS_CODE, ESNTL_ID, CRTFC_DN_VALUE, SBSCRB_DE) VALUES ('webmaster','ORGNZT_0000000000000','웹마스터','78gXjfDDMzepOP4QTiFMRFOT/msFgKkHIgGOU95PT94=','20112060',null,'F','20111130','1566-2059','서울특별시 중구 청계천로 14 - 0 한국정보사회진흥원','P01','전자정부표준프레임워크센터','2059','02','전자정부표준프레임워크센터','100775','1566-2059','1566-2059','egovframesupport@gmail.com','웹관리자','1566','GROUP_00000000000000','00000001','P','USRCNFRM_99999999999','',SYSDATE()); /* 사용자보안설정 */ INSERT INTO COMTNEMPLYRSCRTYESTBS (SCRTY_DTRMN_TRGET_ID, MBER_TY_CODE, AUTHOR_CODE) VALUES ('USRCNFRM_00000000000', 'USR03', 'ROLE_ADMIN'); INSERT INTO COMTNEMPLYRSCRTYESTBS (SCRTY_DTRMN_TRGET_ID, MBER_TY_CODE, AUTHOR_CODE) VALUES ('USRCNFRM_00000000001', 'USR01', 'ROLE_USER'); INSERT INTO COMTNEMPLYRSCRTYESTBS (SCRTY_DTRMN_TRGET_ID, MBER_TY_CODE, AUTHOR_CODE) VALUES ('USRCNFRM_00000000002', 'USR02', 'ROLE_USER'); /* 권한정보 */ INSERT INTO COMTNAUTHORINFO VALUES ('ROLE_ANONYMOUS' ,'익명 사용자' , '', NOW()); INSERT INTO COMTNAUTHORINFO VALUES ('IS_AUTHENTICATED_ANONYMOUSLY' ,'스프링시큐리티 내부사용(롤부여 금지)' , '', NOW()); INSERT INTO COMTNAUTHORINFO VALUES ('IS_AUTHENTICATED_REMEMBERED' ,'스프링시큐리티 내부사용(롤부여 금지)', '', NOW()); INSERT INTO COMTNAUTHORINFO VALUES ('IS_AUTHENTICATED_FULLY' ,'스프링시큐리티 내부사용(롤부여 금지)' , '', NOW()); INSERT INTO COMTNAUTHORINFO VALUES ('ROLE_USER' ,'일반 사용자' , '', NOW()); INSERT INTO COMTNAUTHORINFO VALUES ('ROLE_ADMIN' ,'관리자' , '', NOW()); /* 롤 계층구조 */ INSERT INTO COMTNROLES_HIERARCHY VALUES ('ROLE_ANONYMOUS' ,'IS_AUTHENTICATED_ANONYMOUSLY'); INSERT INTO COMTNROLES_HIERARCHY VALUES ('IS_AUTHENTICATED_ANONYMOUSLY' ,'IS_AUTHENTICATED_REMEMBERED'); INSERT INTO COMTNROLES_HIERARCHY VALUES ('IS_AUTHENTICATED_REMEMBERED' ,'IS_AUTHENTICATED_FULLY'); INSERT INTO COMTNROLES_HIERARCHY VALUES ('IS_AUTHENTICATED_FULLY' ,'ROLE_USER'); INSERT INTO COMTNROLES_HIERARCHY VALUES ('ROLE_USER' ,'ROLE_ADMIN'); /* 롤정보 */ INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000001', '로그인롤', '\\A/uat/uia/.*\\.do.*\\Z', '로그인허용을 위한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000002', '좌측메뉴', '/EgovLeft.do', '좌측 메뉴에 대한 접근 제한 롤', 'url', '2', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000003', '모든접근제한', '\\A/.*\\.do.*\\Z', '모든자원에 대한 접근 제한 롤', 'url', '3', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000004', '회원관리', '\\A/uss/umt/.*\\.do.*\\Z', '회원관리에 대한 접근 제한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000005', '실명확인', '\\A/sec/rnc/.*\\.do.*\\Z', '실명확인에 대한 접근 제한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000006', '우편번호', '\\A/sym/ccm/zip/.*\\.do.*\\Z', '우편번호관리에 대한 접근 제한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000007', '로그인이미지', '\\A/uss/ion/lsi/.*\\.do.*\\Z', '로그인이미지관리에 대한 접근 제한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000008', '파일다운로드', '\\A/sym/ccm/zip/.*\\.do.*\\Z', '파일다운로드에 대한 접근 제한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000009', '상단메뉴', '/EgovTop.do', '상단메뉴에 대한 접근 제한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000010', '하단메뉴', '/EgovBottom.do', '하단메뉴에 대한 접근 제한 롤', 'url', '1', SYSDATE()); INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000011', '왼쪽메뉴', '/EgovLeft.do', '왼쪽메뉴에 대한 접근 제한 롤', 'url', '1', SYSDATE()); /* 권한롤관계 */ INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000001', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000002', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000004', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000005', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000006', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000007', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000008', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000009', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000010', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000011', SYSDATE()); INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_USER', 'web-000003', SYSDATE()); /* 템플릿 */ INSERT INTO COMTNTMPLATINFO(TMPLAT_ID, TMPLAT_NM, TMPLAT_SE_CODE, TMPLAT_COURS, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM ) VALUES('TMPLAT_BOARD_DEFAULT', '게시판 기본템플릿', 'TMPT01', '/css/egovframework/com/cop/tpl/egovbbsTemplate.css', 'Y', 'SYSTEM', SYSDATE()); INSERT INTO COMTNTMPLATINFO(TMPLAT_ID, TMPLAT_NM, TMPLAT_SE_CODE, TMPLAT_COURS, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM ) VALUES('TMPLAT_CMNTY_DEFAULT', '커뮤니티 기본템플릿', 'TMPT02', 'egovframework/com/cop/tpl/EgovCmmntyBaseTmpl', 'Y', 'SYSTEM', SYSDATE()); INSERT INTO COMTNTMPLATINFO(TMPLAT_ID, TMPLAT_NM, TMPLAT_SE_CODE, TMPLAT_COURS, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM ) VALUES('TMPLAT_CLUB__DEFAULT', '동호회 기본템플릿', 'TMPT03', 'egovframework/com/cop/tpl/EgovClbBaseTmpl', 'Y', 'SYSTEM', SYSDATE()); /* 약관정보 */ INSERT INTO COMTNSTPLATINFO ( USE_STPLAT_ID, INFO_PROVD_AGRE_CN, USE_STPLAT_CN, FRST_REGIST_PNTTM,FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID, USE_STPLAT_NM ) VALUES ( 'STPLAT_0000000000001', '제1조(목적 등)-개인회원', '개인정보의 수집 및 이용목적-개인회원', SYSDATE(), 'USRCNFRM_00000000000', SYSDATE(), 'USRCNFRM_00000000000', '인터넷이용약관'); INSERT INTO COMTNSTPLATINFO ( USE_STPLAT_ID, INFO_PROVD_AGRE_CN, USE_STPLAT_CN, FRST_REGIST_PNTTM,FRST_REGISTER_ID, LAST_UPDT_PNTTM, LAST_UPDUSR_ID, USE_STPLAT_NM ) VALUES ( 'STPLAT_0000000000002', '제1조(목적 등)-기업회원', '개인정보의 수집 및 이용목적-기업회원', SYSDATE(), 'USRCNFRM_00000000000', SYSDATE(), 'USRCNFRM_00000000000', '인터넷이용약관');