-- PostgreSQL Initial Data for incheon
-- Converted from HSQL insert statements

-- 기존 전자정부 프레임워크 기초 데이터
INSERT INTO iccom.TCCMMNCLCODE
VALUES ('LET', '전자정부 프레임워크 경량환경 템플릿', '전자정부 프레임워크 경량환경 템플릿', 'Y', '2011-08-31 00:00:00', 'SYSTEM',
        '2011-08-31 00:00:00', 'SYSTEM');

INSERT INTO iccom.TCCMMNCODE
VALUES ('COM001', '등록구분', '게시판, 커뮤니티, 동호회 등록구분코드', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00',
        'SYSTEM');
INSERT INTO iccom.TCCMMNCODE
VALUES ('COM003', '업무구분', '업무구분코드', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNCODE
VALUES ('COM004', '게시판유형', '게시판유형구분코드', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNCODE
VALUES ('COM005', '템플릿유형', '템플릿유형구분코드', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNCODE
VALUES ('COM009', '게시판속성', '게시판 속성', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNCODE
VALUES ('COM019', '일정중요도', '일정중요도 낮음/보통/높음 상태구분', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00',
        'SYSTEM');
INSERT INTO iccom.TCCMMNCODE
VALUES ('COM030', '일정구분', '일정구분 코드', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNCODE
VALUES ('COM031', '반복구분', '일정 반복구분 코드', 'Y', 'LET', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');

-- 공통 상세코드
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM001', 'REGC01', '단일 게시판 이용등록', '단일 게시판 이용등록', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00',
        'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM001', 'REGC07', '게시판사용자등록', '게시판사용자등록', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00',
        'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM003', 'BBS', '게시판', '게시판', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM004', 'BBST01', '일반게시판', '일반게시판', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM004', 'BBST02', '익명게시판', '익명게시판', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM004', 'BBST03', '공지게시판', '공지게시판', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM004', 'BBST04', '방명록', '방명록', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM005', 'TMPT01', '게시판템플릿', '게시판템플릿', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM009', 'BBSA01', '유효게시판', '유효게시판', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM009', 'BBSA02', '갤러리', '갤러리', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM009', 'BBSA03', '일반게시판', '일반게시판', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM019', 'A', '높음', '높음', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM019', 'B', '보통', '보통', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM019', 'C', '낮음', '낮음', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM030', '1', '회의', '회의', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM030', '2', '세미나', '세미나', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM030', '3', '강의', '강의', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM030', '4', '교육', '교육', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM030', '5', '기타', '기타', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM031', '1', '당일', '당일', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM031', '2', '반복', '반복', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM031', '3', '연속', '연속', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');
INSERT INTO iccom.TCCMMNDETAILCODE
VALUES ('COM031', '4', '요일반복', '요일반복', 'Y', '2011-08-31 00:00:00', 'SYSTEM', '2011-08-31 00:00:00', 'SYSTEM');

-- 조직 및 권한 정보
INSERT INTO iccom.TNORGNZTINFO
VALUES ('ORGNZT_0000000000000', '기본조직', '기본조직');
INSERT INTO iccom.TNAUTHORGROUPINFO
VALUES ('GROUP_00000000000000', 'ROLE_ADMIN', '2024-07-31', '관리자 그룹입니다');
INSERT INTO iccom.TNAUTHORGROUPINFO
VALUES ('GROUP_00000000000001', 'ROLE_USER', '2024-07-31', '사용자 그룹입니다');

-- 게시판 설정
INSERT INTO iccom.TNBBSMASTER
VALUES ('BBSMSTR_AAAAAAAAAAAA', '공지사항', '공지사항게시판', 'BBST03', 'BBSA03', 'Y', 'Y', 2, 5242880, 'Y',
        'TMPLAT_BOARD_DEFAULT', 'USRCNFRM_00000000000', '2011-08-31 12:00:00', 'USRCNFRM_00000000000',
        '2011-08-31 12:00:00');
INSERT INTO iccom.TNBBSMASTER
VALUES ('BBSMSTR_BBBBBBBBBBBB', '갤러리', '갤러리게시판', 'BBST01', 'BBSA02', 'Y', 'Y', 2, 5242880, 'Y', 'TMPLAT_BOARD_DEFAULT',
        'USRCNFRM_00000000000', '2011-08-31 12:00:00', 'USRCNFRM_00000000000', '2011-08-31 12:00:00');

INSERT INTO iccom.TNBBSUSE
VALUES ('BBSMSTR_AAAAAAAAAAAA', 'SYSTEM_DEFAULT_BOARD', 'Y', 'REGC01', '2011-08-31 12:00:00', 'USRCNFRM_00000000000',
        '2011-08-31 12:00:00', 'USRCNFRM_00000000000');
INSERT INTO iccom.TNBBSUSE
VALUES ('BBSMSTR_BBBBBBBBBBBB', 'SYSTEM_DEFAULT_BOARD', 'Y', 'REGC01', '2011-08-31 12:00:00', 'USRCNFRM_00000000000',
        '2011-08-31 12:00:00', 'USRCNFRM_00000000000');

-- 사용자 정보 (기본 관리자/사용자)
INSERT INTO iccom.TNEMPLYRINFO
VALUES ('admin', 'ORGNZT_0000000000000', '관리자', 'JfQ7FIatlaE5jj7rPYO8QBABX8yb7bNbQy4AKY1QIfc=', '', '', 'F', '', '',
        '관리자 주소', '', '', '', '', '', '', '', '', '', '', '', 'GROUP_00000000000000', '00000000', 'P',
        'USRCNFRM_00000000000', '', '2011-08-31 00:00:00');
INSERT INTO iccom.TNEMPLYRINFO
VALUES ('user', 'ORGNZT_0000000000000', '사용자', 'CgQblGLKpKMbrDVn4Lbm/ZEAeH2yq0M9lvbReMq/zpA=', '', '', 'F', '', '',
        '사용자 주소', '', '', '', '', '', '', '', '', '', '', '', 'GROUP_00000000000001', '00000000', 'P',
        'USRCNFRM_00000000001', '', '2011-08-31 00:00:00');

-- 샘플 게시물 (공지사항)
INSERT INTO iccom.TNBBS
VALUES (1, 'BBSMSTR_AAAAAAAAAAAA', 1, '환영합니다! 공지사항입니다.',
        '안녕하세요, 여러분! 전자정부 표준프레임워크 게시판에 오신 것을 환영합니다. 이 게시판은 공지사항을 전달하는 용도로 사용됩니다.', 'N', NULL, NULL, 1, 0, 'Y', NULL,
        NULL, 'admin', '관리자', NULL, NULL, NOW(), 'admin', NOW(), 'admin');
INSERT INTO iccom.TNBBS
VALUES (2, 'BBSMSTR_AAAAAAAAAAAA', 2, '2025년 시스템 업데이트 안내', '2025년 1월부터 새로운 버전의 시스템으로 업데이트될 예정입니다. 자세한 내용은 추후 공지하겠습니다.',
        'N', NULL, NULL, 2, 0, 'Y', NULL, NULL, 'admin', '관리자', NULL, NULL, NOW(), 'admin', NOW(), 'admin');
INSERT INTO iccom.TNBBS
VALUES (3, 'BBSMSTR_AAAAAAAAAAAA', 3, '게시판 이용 방법 안내', '게시판 이용 방법에 대한 안내입니다. 자유롭게 질문이나 의견을 남겨주세요.', 'N', NULL, NULL, 3,
        0, 'Y', NULL, NULL, 'admin', '관리자', NULL, NULL, NOW(), 'admin', NOW(), 'admin');

-- 샘플 게시물 (갤러리)
INSERT INTO iccom.TNBBS
VALUES (4, 'BBSMSTR_BBBBBBBBBBBB', 1, '갤러리 게시판 첫 번째 사진', '아름다운 자연 풍경 사진입니다. 함께 감상해 보세요.', 'N', NULL, NULL, 1, 0, 'Y',
        NULL, NULL, 'user', '사용자', NULL, NULL, NOW(), 'user', NOW(), 'user');
INSERT INTO iccom.TNBBS
VALUES (5, 'BBSMSTR_BBBBBBBBBBBB', 2, '갤러리 게시판 두 번째 사진', '도시의 야경 사진입니다. 멋진 불빛이 인상적입니다.', 'N', NULL, NULL, 2, 0, 'Y',
        NULL, NULL, 'user', '사용자', NULL, NULL, NOW(), 'user', NOW(), 'user');
INSERT INTO iccom.TNBBS
VALUES (6, 'BBSMSTR_BBBBBBBBBBBB', 3, '갤러리 게시판 세 번째 사진', '가을 단풍 풍경입니다. 아름다운 색감을 느껴보세요.', 'N', NULL, NULL, 3, 0, 'Y',
        NULL, NULL, 'user', '사용자', NULL, NULL, NOW(), 'user', NOW(), 'user');

-- ID 생성 테이블 초기값
INSERT INTO iccom.IDS
VALUES ('BBS_ID', 7);
INSERT INTO iccom.IDS
VALUES ('FILE_ID', 1);
INSERT INTO iccom.IDS
VALUES ('SAMPLE', 1);
INSERT INTO iccom.IDS
VALUES ('SCHDUL_ID', 1);
INSERT INTO iccom.IDS
VALUES ('TMPLAT_ID', 1);
INSERT INTO iccom.COMTECOPSEQ
VALUES ('USRCNFRM_ID', 20);


-- 통합관리자시스템 코드 그룹
INSERT INTO iccom.COM_GROUP_CD (CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('MENU_TYPE', '메뉴 타입', '메뉴의 속성을 정의하는 코드 그룹', 'Y', 1, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('MENU01', 'MENU_TYPE', '메인메뉴', '시스템의 메인 메뉴', 'Y', 1, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('MENU02', 'MENU_TYPE', '서브메뉴', '메인메뉴의 서브 메뉴', 'Y', 2, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('MENU03', 'MENU_TYPE', '하위메뉴', '서브 메뉴의 하위 메뉴', 'Y', 3, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('MENU04', 'MENU_TYPE', '사이드메뉴', '웹페이지의 사이드바 메뉴', 'N', 4, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('MENU05', 'MENU_TYPE', '에어커맨드메뉴', '지도상의 에어커맨드 메뉴', 'N', 5, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_GROUP_CD (CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('USER_ROLE', '사용자 역할', '사용자의 권한을 정의하는 코드 그룹', 'Y', 2, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ADMIN', 'USER_ROLE', '관리자', '시스템 관리자 권한', 'Y', 1, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('USER', 'USER_ROLE', '일반 사용자', '일반 사용자 권한', 'Y', 2, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_GROUP_CD (CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('STATUS', '상태 코드', '사용자의 상태를 정의하는 코드 그룹', 'Y', 3, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ONLINE', 'STATUS', '온라인', '현재 접속중인 상태', 'Y', 1, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('OFFLINE', 'STATUS', '로그아웃', '현재 접속중이 아닌 상태', 'Y', 2, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_GROUP_CD (CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('SURVEY_TARGET', '설문 대상 코드', '설문 조사 대상을 정의하는 코드 그룹', 'Y', 4, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_ALL', 'SURVEY_TARGET', '전체', '설문 조사를 모든 시스템 대상으로 배포', 'Y', 1, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_LINK', 'SURVEY_TARGET', '링크', '설문 조사를 링크로 배포', 'Y', 2, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_POPUP', 'SURVEY_TARGET', '팝업', '설문 조사를 팝업으로 배포', 'Y', 3, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_ADMIN', 'SURVEY_TARGET', '통합관리', '설문 조사를 통합관리 대상으로 배포', 'Y', 4, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_MAP', 'SURVEY_TARGET', '대민지도포털', '설문 조사를 대민지도포털 대상으로 배포', 'Y', 5, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_WORK', 'SURVEY_TARGET', '행정업무포털', '설문 조사를 행정업무포털 대상으로 배포', 'Y', 6, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_PORTAL', 'SURVEY_TARGET', '시민포털', '설문 조사를 시민포털 대상으로 배포', 'Y', 7, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_ADMIN_MAP', 'SURVEY_TARGET', '통합관리, 대민지도', '설문 조사를 통합관리, 대민지도포털 대상으로 배포', 'Y', 8, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_ADMIN_WORK', 'SURVEY_TARGET', '통합관리, 업무포털', '설문 조사를 통합관리, 행정업무포털 대상으로 배포', 'Y', 9, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_ADMIN_PORTAL', 'SURVEY_TARGET', '통합관리, 시민포털', '설문 조사를 통합관리, 시민포털 대상으로 배포', 'Y', 10, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_MAP_WORK', 'SURVEY_TARGET', '대민지도, 업무포털', '설문 조사를 대민지도포털, 행정업무포털 대상으로 배포', 'Y', 11, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_MAP_PORTAL', 'SURVEY_TARGET', '대민지도, 시민포털', '설문 조사를 대민지도포털, 시민포털 대상으로 배포', 'Y', 12, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_WORK_PORTAL', 'SURVEY_TARGET', '행정포털, 시민포털', '설문 조사를 행정업무포털, 시민포털 대상으로 배포', 'Y', 13, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_ADMIN_MAP_WORK', 'SURVEY_TARGET', '통합관리, 대민지도, 행정포털', '설문 조사를 통합관리, 대민지도, 행정포털 대상으로 배포', 'Y', 14, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_ADMIN_MAP_PORTAL', 'SURVEY_TARGET', '통합관리, 대민지도, 시민포털', '설문 조사를 통합관리, 대민지도, 시민포털 대상으로 배포', 'Y', 15, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

INSERT INTO iccom.COM_CD (CD, GROUP_CD, CD_NM, CD_EXPLN, USE_YN, CD_SORT_SEQ, CD_CRT_DT, CD_CRT_USER_ID, CD_CHG_DT, CD_CHG_USER_ID)
VALUES ('ST_MAP_WORK_PORTAL', 'SURVEY_TARGET', '대민지도, 행정업무, 시민포털', '설문 조사를 대민지도, 행정업무, 시민포털 대상으로 배포', 'Y', 16, CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, 'admin');

-- 메뉴 정보
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU030100','권한 코드 관리',NULL,'MENU030000',1,'/images/authrtMng.png','/ags/ias/authrt/authrtList.do','N','Y','admin','2025-09-29 10:13:39.928044','system','2025-09-29 10:57:25.690198','/ags/ias/authrt/authrtList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU030200','권한 신청 사용 관리',NULL,'MENU030000',2,'/images/authrtReqMng.png','/ags/ias/authrt/authrtReqMngList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/authrt/authrtReqMngList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU030300','권한 신청 이력',NULL,'MENU030000',3,'/images/authrtReqHistory.png','/ags/ias/authrt/authrtReqHisList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/authrt/authrtReqHisList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU030400','사용자 권한 관리',NULL,'MENU030000',4,'/images/userAuthrt.png','/ags/ias/authrt/userAuthrtList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/authrt/userAuthrtList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU030500','사용자 임시 권한 관리',NULL,'MENU030000',5,'/images/userAuthrtTemp.png','/ags/ias/authrt/userAuthrtTempList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/authrt/userAuthrtTempList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU040100','접속 현황 조회',NULL,'MENU040000',1,'/images/accessStatus.png','/ags/ias/stat/accessStatusList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/stat/accessStatusList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU040000','통계 정보',NULL,'MENIAS010000',4,'/images/stat.png','/ags/ias/stat/accessStatusList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/stat/accessStatusList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU030000','권한 관리',NULL,'MENIAS010000',3,'/images/authrt.png','/ags/ias/authrt/authrtReqMngList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/authrt/authrtReqMngList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MNURPS010000','도로굴착',NULL,NULL,1,'','/res/RdmDdCouncilL050.do','N','Y','superadmin','2025-10-02 14:48:36.694618','superadmin','2025-10-02 15:10:42.553017','');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010500','메뉴 권한 관리',NULL,'MENU010000',6,'/images/menuAuth.png','/ags/ias/sysMenuAuthrt/sysMenuAuthrtList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/sysMenuAuthrt/sysMenuAuthrtList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU040200','접속 통계 조회',NULL,'MENU040000',2,'/images/accessStat.png','/ags/ias/stat/accessStatList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/stat/accessStatList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU050100','설문 조사 관리',NULL,'MENU050000',2,'/images/survey.png','/ags/ias/srvy/srvyList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/srvy/srvyList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010600','약관 관리',NULL,'MENU010000',7,'/images/terms.png','/ags/ias/trms/trmsList.do','N','Y','admin','2025-09-29 10:13:39.928044','system','2025-09-29 11:01:35.806624','/ags/ias/sysSet/termsList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010700','자료 연계 설정 관리',NULL,'MENU010000',8,'/images/dataLink.png','/ags/ias/sysSet/dataLink.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/sysSet/dataLink.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU020100','사용자 관리',NULL,'MENU020000',1,'/images/user.png','/ags/ias/user/userList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/user/userList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU020200','부서 관리',NULL,'MENU020000',2,'/images/dept.png','/ags/ias/dept/deptList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/dept/deptList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU050200','설문 항목 관리',NULL,'MENU050000',3,'/images/survey.png','/ags/ias/srvyQitem/srvyQitemList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/srvyQitem/srvyQitemList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU050300','설문 항목 문항 관리',NULL,'MENU050000',4,'/images/survey.png','/ags/ias/srvyQitemArtcl/srvyQitemArtclList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/srvyQitemArtcl/srvyQitemArtclList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU050400','설문 답변 관리',NULL,'MENU050000',5,'/images/survey.png','/ags/ias/srvyRspdnt/srvyRspdntList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/srvyRspdnt/srvyRspdntList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010400','메뉴 관리',NULL,'MENU010000',4,'/images/menuMng.png','/ags/ias/menu/menuList.do','N','Y','admin','2025-09-29 10:13:39.928044','superadmin','2025-10-02 14:09:55.909104','/ags/ias/menu/menuRegist.do,/ags/ias/menu/menuModify.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENRES010000','도로굴착관리',NULL,NULL,2,NULL,'/res/tmp/publ/main.do','N','Y','superadmin','2025-10-01 16:15:54.523504','superadmin','2025-10-01 16:15:54.523504','');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU050500','설문 링크 관리',NULL,'MENU050000',6,'/images/survey.png','/survey/participate','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/survey/participate');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010100','접수전협의상태',NULL,'MENU010000',1,NULL,'/res/RdmDdCouncilL050.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdCouncilL050.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010200','사업계획서접수',NULL,'MENU010000',2,NULL,'/res/RdmDdAcceptL020.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdAcceptL020.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU050000','설문 관리',NULL,'MENIAS010000',5,'/images/survey.png','/ags/ias/srvy/srvyList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/srvy/srvyList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010100','시스템 관리',NULL,'MENU010000',1,'/images/sysMng.png','/ags/ias/sys/sysList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/sys/sysList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010200','코드 관리',NULL,'MENU010000',2,'/images/codeMng.png','/ags/ias/comCd/groupList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/comCd/groupList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010300','역할 관리',NULL,'MENU010000',3,'/images/role.png','/ags/ias/role/roleList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/role/roleList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU010000','시스템 설정',NULL,'MENIAS010000',1,'/images/sysSetting.png','/ags/ias/sys/sysList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/sys/sysList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENU020000','사용자 및 부서 관리',NULL,'MENIAS010000',2,'/images/user.png','/ags/ias/user/userList.do','N','Y','admin','2025-09-29 10:13:39.928044','admin','2025-09-29 10:13:39.928044','/ags/ias/user/userList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENIAS010000','통합관리',NULL,NULL,999,NULL,'/ags/ias/sys/sysList.do','N','Y','superadmin','2025-10-01 16:15:54.523504','superadmin','2025-10-01 16:15:54.523504','/ags/ias/sys/sysList.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENMRB010000','나만의지도관리',NULL,NULL,1,NULL,'','N','Y','superadmin','2025-10-01 16:15:54.523504','superadmin','2025-10-01 16:15:54.523504','');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('AGS','MENUIS010000','UIS관리',NULL,NULL,3,NULL,'','N','Y','superadmin','2025-10-01 16:15:54.523504','superadmin','2025-10-01 16:15:54.523504','');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010300','보완요청관리',NULL,'MENU010000',3,NULL,'/res/RdmDdPjtplanL010.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdPjtplanL010.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010400','심의조정관리',NULL,'MENU010000',4,NULL,'/res/RdmDdCouncilL010.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdCouncilL010.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010401','사업계획서',NULL,'MENU010400',1,NULL,'/res/RdmDdCouncilL010.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdCouncilL010.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010402','사업예정지',NULL,'MENU010400',2,NULL,'/res/RdmDdUnitcstL010.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdUnitcstL010.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010500','심의조정완료',NULL,'MENU010000',5,NULL,'/res/RdmDdCouncilL040.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdCouncilL040.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010501','사업계획서',NULL,'MENU010500',1,NULL,'/res/RdmDdCouncilL040.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdCouncilL040.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010502','사업예정지',NULL,'MENU010500',2,NULL,'/res/RdmDdUnitcstL030.do','N','Y','superadmin','2025-10-02 16:20:01.512075','superadmin','2025-10-02 16:20:01.512075','/res/RdmDdUnitcstL030.do');
INSERT INTO iccom.MENU (SYS_CD,MENU_CD,MENU_NM,MENU_EXPLN,UP_MENU_CD,MENU_SORT_SEQ,ICON_PATH_NM,MENU_URL_ADDR,POPUP_YN,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT,MENU_ETC_URL_ADDR) VALUES
    ('RPS','MENU010000','굴착심의관리',NULL,'MENRES010000',1,NULL,'/res/RdmDdCouncilL050.do','N','Y','superadmin','2025-10-02 16:19:27.005111','superadmin','2025-10-02 16:19:27.005111','/res/RdmDdCouncilL050.do');
INSERT INTO iccom.MENU (SYS_CD, MENU_CD, MENU_NM, MENU_EXPLN, UP_MENU_CD, MENU_SORT_SEQ, ICON_PATH_NM, MENU_URL_ADDR, POPUP_YN, USE_YN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT, MENU_ETC_URL_ADDR) VALUES
    ('AGS', 'MENMY010000', '마이페이지', NULL, NULL, 9999, NULL, '/ags/ias/sys/myPge.do', 'N', 'Y', 'superadmin', '2025-10-01 16:15:54.523504', 'superadmin', '2025-10-01 16:15:54.523504', '/ags/ias/sys/myPge.do');



-- 약관 정보
INSERT INTO iccom.TRMS (TRMS_ID, TRGT_SYS_CD, TRMS_TTL, TRMS_TYPE, VER, TRMS_EXPLN, BNGN_DATE, END_DATE, AGRE_YN, RE_AGRE_YN, STTS, TRMS_CN, CHG_RSN_CN, RELATE_STT, ACS_CNPL, ATCHMNFL_PATH, RMRK_CN, TRMS_CRT_DT, TRMS_CRT_USER_ID, TRMS_CHG_DT, TRMS_CHG_USER_ID)
VALUES ('T001', 'SYS001', '서비스 이용약관', 'service', 'v1.0', '서비스 이용에 관한 기본 약관', '2025-07-01', NULL, 'Y', NULL, 'A', '<h1>제1조 목적</h1><p>이 약관은 ...</p>', NULL, '전자상거래법', '고객센터 02-1234-5678', '/files/t001_v1.pdf', NULL, NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.TRMS (TRMS_ID, TRGT_SYS_CD, TRMS_TTL, TRMS_TYPE, VER, TRMS_EXPLN, BNGN_DATE, END_DATE, AGRE_YN, RE_AGRE_YN, STTS, TRMS_CN, CHG_RSN_CN, RELATE_STT, ACS_CNPL, ATCHMNFL_PATH, RMRK_CN, TRMS_CRT_DT, TRMS_CRT_USER_ID, TRMS_CHG_DT, TRMS_CHG_USER_ID)
VALUES ('T002', 'SYS001', '개인정보처리방침', 'privacy', 'v2.0', '회원 개인정보 수집 및 처리 방침', '2025-08-01', NULL, 'Y', NULL, 'A', '<h2>수집 항목</h2><ul><li>이름</li><li>이메일</li></ul>', '개인정보 항목 추가로 인한 개정', '개인정보보호법', '보안팀 02-2345-6789', NULL, '관련 법령 개정 반영', NOW(), 'admin', NOW(), 'admin');

-- 약관 이력
INSERT INTO iccom.TRMS_HSTRY (TRMS_HSTRY_ID, TRMS_ID, VER, CHG_RSN_CN, TRMS_CN, TRMS_HSTRY_CRT_DT, TRMS_HSTRY_CRT_USER_ID, TRMS_HSTRY_CHG_DT, TRMS_HSTRY_CHG_USER_ID)
VALUES ('H001', 'T001', 'v1.0', NULL, '<h1>제1조 목적</h1><p>이 약관은 최초 등록된 내용입니다.</p>', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.TRMS_HSTRY (TRMS_HSTRY_ID, TRMS_ID, VER, CHG_RSN_CN, TRMS_CN, TRMS_HSTRY_CRT_DT, TRMS_HSTRY_CRT_USER_ID, TRMS_HSTRY_CHG_DT, TRMS_HSTRY_CHG_USER_ID)
VALUES ('H002', 'T002', 'v2.0', '수집 항목 및 제공 범위 변경', '<h2>수정된 수집 항목</h2><ul><li>이름</li><li>이메일</li><li>휴대전화</li></ul>', NOW(), 'admin', NOW(), 'admin');

-- 부서 정보
INSERT INTO iccom.DEPT (DEPT_CD, DEPT_STCD, DEPT_NM, DEPT_WHOL_NM, DEPT_ENG_NM, HGHRK_INST_CD, SHGHRK_INST_CD, SFRND_SE_CD, CYCL, RANK_NO, RPRS_TELNO, ADDR, DADDR, HMPG_URL_ADDR, FXNO, EML_ADDR, TMPR_OGNZ_YN, VR_OGNZ_TR_YN, VR_OGNZ_TR_UP_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('DEPT001', 'ACTIVE', '정보화담당', '인천광역시 정보화담당', 'Information Technology Department', 'INST001', 'INST001', 'METRO', 1, 100, '03244025500', '인천광역시 남동구 정각로 29', '시청 본관 5층', 'http://www.incheon.go.kr/it', '03244025501', 'it@incheon.go.kr', 'N', 'N', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.DEPT (DEPT_CD, DEPT_STCD, DEPT_NM, DEPT_WHOL_NM, DEPT_ENG_NM, HGHRK_INST_CD, SHGHRK_INST_CD, SFRND_SE_CD, CYCL, RANK_NO, RPRS_TELNO, ADDR, DADDR, HMPG_URL_ADDR, FXNO, EML_ADDR, TMPR_OGNZ_YN, VR_OGNZ_TR_YN, VR_OGNZ_TR_UP_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('DEPT002', 'ACTIVE', '행정지원과', '인천광역시 행정지원과', 'Administrative Support Department', 'INST001', 'INST001', 'METRO', 1, 200, '03244021000', '인천광역시 남동구 정각로 29', '시청 본관 3층', 'http://www.incheon.go.kr/admin', '03244021010', 'admin@incheon.go.kr', 'N', 'N', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.DEPT (DEPT_CD, DEPT_STCD, DEPT_NM, DEPT_WHOL_NM, DEPT_ENG_NM, HGHRK_INST_CD, SHGHRK_INST_CD, SFRND_SE_CD, CYCL, RANK_NO, RPRS_TELNO, ADDR, DADDR, HMPG_URL_ADDR, FXNO, EML_ADDR, TMPR_OGNZ_YN, VR_OGNZ_TR_YN, VR_OGNZ_TR_UP_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('DEPT003', 'ACTIVE', '도시계획과', '인천광역시 도시계획과', 'Urban Planning Department', 'INST001', 'INST001', 'METRO', 1, 300, '03244031000', '인천광역시 남동구 정각로 29', '시청 별관 2층', 'http://www.incheon.go.kr/planning', '03244031010', 'planning@incheon.go.kr', 'N', 'N', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.DEPT (DEPT_CD, DEPT_STCD, DEPT_NM, DEPT_WHOL_NM, DEPT_ENG_NM, HGHRK_INST_CD, SHGHRK_INST_CD, SFRND_SE_CD, CYCL, RANK_NO, RPRS_TELNO, ADDR, DADDR, HMPG_URL_ADDR, FXNO, EML_ADDR, TMPR_OGNZ_YN, VR_OGNZ_TR_YN, VR_OGNZ_TR_UP_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('DEPT004', 'ACTIVE', '지적과', '인천광역시 지적과', 'Cadastral Department', 'INST001', 'INST001', 'METRO', 1, 400, '03244041000', '인천광역시 남동구 정각로 29', '시청 별관 1층', 'http://www.incheon.go.kr/cadastral', '03244041010', 'cadastral@incheon.go.kr', 'N', 'N', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.DEPT (DEPT_CD, DEPT_STCD, DEPT_NM, DEPT_WHOL_NM, DEPT_ENG_NM, HGHRK_INST_CD, SHGHRK_INST_CD, SFRND_SE_CD, CYCL, RANK_NO, RPRS_TELNO, ADDR, DADDR, HMPG_URL_ADDR, FXNO, EML_ADDR, TMPR_OGNZ_YN, VR_OGNZ_TR_YN, VR_OGNZ_TR_UP_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('DEPT005', 'ACTIVE', '기획예산과', '인천광역시 기획예산과', 'Planning and Budget Department', 'INST001', 'INST001', 'METRO', 1, 500, '03244011000', '인천광역시 남동구 정각로 29', '시청 본관 4층', 'http://www.incheon.go.kr/budget', '03244011010', 'budget@incheon.go.kr', 'N', 'N', NULL, 'admin', NOW(), 'admin', NOW());
-- 직급 정보
INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS999', '의장', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS000', '대표이사', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS001', '전무이사', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS002', '상무이사', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS003', '이사', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS004', '수석부장', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS005', '부장', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS006', '차장', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS007', '과장', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS008', '대리', NOW(), 'admin', NOW(), 'admin');

INSERT INTO iccom.JBGD (JBGD_CD, JBGD_NM, JBGD_REG_DT, JBGD_REG_USER_ID, JBGD_MDFCN_DT, JBGD_MDFCN_USER_ID)
VALUES ('POS009', '사원', NOW(), 'admin', NOW(), 'admin');
-- 사용자 정보
INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('1','superadmin','C','통합관',NULL,'인천광역시 통합관리부 통합관',NULL,'1000000','통합관리부','인천광역시 통합관리부','1000','통합관리주사','100',NULL,'주무관','M','19901231',1,'1000000','1000000','0',NULL,NULL,NULL,'100통합관001',NULL,'0321001000','0321001000',' ○ 통합관리자','superadmin@incheon.dev','superadmin@korea.dev','01010001000',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('2','geoadmin','C','지도관',NULL,'인천광역시 지도관리부 지도관',NULL,'2000000','지도관리부','인천광역시 지도관리부','2000','지도관리주사','200',NULL,'주무관','M','19901231',1,'2000000','2000000','0',NULL,NULL,NULL,'100지도관001',NULL,'0322002000','0322002000',' ○ 지도관리자','geoadmin@incheon.dev','geoadmin@korea.dev','01020002000',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('3','resadmin','C','도로관',NULL,'인천광역시 도로관리부 도로관',NULL,'3000000','도로관리부','인천광역시 도로관리부','3000','도로관리주사','300',NULL,'주무관','M','19901231',1,'3000000','3000000','0',NULL,NULL,NULL,'100도로관001',NULL,'0323003000','0323003000',' ○ 도로관리자','resadmin@incheon.dev','resadmin@korea.dev','01030003000',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('4','uisadmin','C','도시관',NULL,'인천광역시 도시관리부 도시관',NULL,'4000000','도시관리부','인천광역시 도시관리부','4000','도시관리주사','400',NULL,'주무관','M','19901231',1,'4000000','4000000','0',NULL,NULL,NULL,'100도시관001',NULL,'0324004000','0324004000',' ○ 도시관리자','uisadmin@incheon.dev','uisadmin@korea.dev','01040004000',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('5','pandokadmin','C','판독관',NULL,'인천광역시 판독관리부 판독관',NULL,'5000000','판독관리부','인천광역시 판독관리부','5000','판독관리주사','500',NULL,'주무관','M','19901231',1,'5000000','5000000','0',NULL,NULL,NULL,'100판독관001',NULL,'0325005000','0325005000',' ○ 판독관리자','pandokadmin@incheon.dev','pandokadmin@korea.dev','01050005000',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('6','geouser01','C','지도일',NULL,'인천광역시 지도관리부 지도일',NULL,'2000000','지도관리부','인천광역시 지도관리부','2001','지도관리사','201',NULL,'사원','M','19950315',2,'2000000','2000000','0',NULL,NULL,NULL,'200지도일001',NULL,'0322002001','0322002001',' ○ 지도관리 담당','geouser01@incheon.dev','geouser01@korea.dev','01020012001',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('7','geouser02','C','지도이',NULL,'인천광역시 지도관리부 지도이',NULL,'2000000','지도관리부','인천광역시 지도관리부','2002','지도관리사','202',NULL,'사원','F','19930722',2,'2000000','2000000','0',NULL,NULL,NULL,'200지도이002',NULL,'0322002002','0322002002',' ○ 지도관리 담당','geouser02@incheon.dev','geouser02@korea.dev','01020022002',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('8','geouser03','C','지도삼',NULL,'인천광역시 지도관리부 지도삼',NULL,'2000000','지도관리부','인천광역시 지도관리부','2003','지도관리사','203',NULL,'사원','M','19920108',2,'2000000','2000000','0',NULL,NULL,NULL,'200지도삼003',NULL,'0322002003','0322002003',' ○ 지도관리 담당','geouser03@incheon.dev','geouser03@korea.dev','01020032003',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('9','resuser01','C','도로일',NULL,'인천광역시 도로관리부 도로일',NULL,'3000000','도로관리부','인천광역시 도로관리부','3001','도로관리사','301',NULL,'사원','M','19940520',2,'3000000','3000000','0',NULL,NULL,NULL,'300도로일001',NULL,'0323003001','0323003001',' ○ 도로관리 담당','resuser01@incheon.dev','resuser01@korea.dev','01030013001',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('10','resuser02','C','도로이',NULL,'인천광역시 도로관리부 도로이',NULL,'3000000','도로관리부','인천광역시 도로관리부','3002','도로관리사','302',NULL,'사원','F','19960912',2,'3000000','3000000','0',NULL,NULL,NULL,'300도로이002',NULL,'0323003002','0323003002',' ○ 도로관리 담당','resuser02@incheon.dev','resuser02@korea.dev','01030023002',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('11','resuser03','C','도로삼',NULL,'인천광역시 도로관리부 도로삼',NULL,'3000000','도로관리부','인천광역시 도로관리부','3003','도로관리사','303',NULL,'사원','M','19911203',2,'3000000','3000000','0',NULL,NULL,NULL,'300도로삼003',NULL,'0323003003','0323003003',' ○ 도로관리 담당','resuser03@incheon.dev','resuser03@korea.dev','01030033003',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('12','uisuser01','C','도시일',NULL,'인천광역시 도시관리부 도시일',NULL,'4000000','도시관리부','인천광역시 도시관리부','4001','도시관리사','401',NULL,'사원','F','19930825',2,'4000000','4000000','0',NULL,NULL,NULL,'400도시일001',NULL,'0324004001','0324004001',' ○ 도시관리 담당','uisuser01@incheon.dev','uisuser01@korea.dev','01040014001',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('13','uisuser02','C','도시이',NULL,'인천광역시 도시관리부 도시이',NULL,'4000000','도시관리부','인천광역시 도시관리부','4002','도시관리사','402',NULL,'사원','M','19950417',2,'4000000','4000000','0',NULL,NULL,NULL,'400도시이002',NULL,'0324004002','0324004002',' ○ 도시관리 담당','uisuser02@incheon.dev','uisuser02@korea.dev','01040024002',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('14','uisuser03','C','도시삼',NULL,'인천광역시 도시관리부 도시삼',NULL,'4000000','도시관리부','인천광역시 도시관리부','4003','도시관리사','403',NULL,'사원','F','19920630',2,'4000000','4000000','0',NULL,NULL,NULL,'400도시삼003',NULL,'0324004003','0324004003',' ○ 도시관리 담당','uisuser03@incheon.dev','uisuser03@korea.dev','01040034003',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('15','pandokuser01','C','판독일',NULL,'인천광역시 판독관리부 판독일',NULL,'5000000','판독관리부','인천광역시 판독관리부','5001','판독관리사','501',NULL,'사원','M','19940210',2,'5000000','5000000','0',NULL,NULL,NULL,'500판독일001',NULL,'0325005001','0325005001',' ○ 판독관리 담당','pandokuser01@incheon.dev','pandokuser01@korea.dev','01050015001',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('16','pandokuser02','C','판독이',NULL,'인천광역시 판독관리부 판독이',NULL,'5000000','판독관리부','인천광역시 판독관리부','5002','판독관리사','502',NULL,'사원','F','19960804',2,'5000000','5000000','0',NULL,NULL,NULL,'500판독이002',NULL,'0325005002','0325005002',' ○ 판독관리 담당','pandokuser02@incheon.dev','pandokuser02@korea.dev','01050025002',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

INSERT INTO iccom.USER (USER_UNQ_ID, USER_ID, USER_STCD, USER_NM, USER_ENG_NM, USER_WHOL_NM, EMP_NO, DEPT_CD, DEPT_NM, DEPT_WHOL_NM, JBGD_CD, JBGD_NM, JBPS_CD, JBPS_NM, JBTTL_NM, GNDR_CD, BRDT, RANK_NO, HGHRK_INST_CD, SHGHRK_INST_CD, WORK_TYPE_CD, ETC_DEPT_NM, ETC_DEPT_CD, VHRNO, CN, PHOTO_PATH_NM, OFC_TELNO, OFC_FXNO, TKCG_TASK_CN, EML_ADDR, OTSD_EML_ADDR, MBL_TELNO, HMPG_URL_ADDR, HOUSE_TELNO, HOUSE_ADDR, HOUSE_DADDR, MRG_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('17','pandokuser03','C','판독삼',NULL,'인천광역시 판독관리부 판독삼',NULL,'5000000','판독관리부','인천광역시 판독관리부','5003','판독관리사','503',NULL,'사원','M','19910918',2,'5000000','5000000','0',NULL,NULL,NULL,'500판독삼003',NULL,'0325005003','0325005003',' ○ 판독관리 담당','pandokuser03@incheon.dev','pandokuser03@korea.dev','01050035003',NULL,NULL,NULL,NULL,NULL,'system','2025-09-26 05:55:47.096914','system','2025-09-26 05:55:47.096914');

-- ROLE 테이블 INSERT
INSERT INTO iccom.ROLE (ROLE_CD, ROLE_NM, ROLE_EXPLN, ROLE_TYPE_CD, UP_ROLE_CD, ROLE_SORT_SEQ, SYS_CD, USE_YN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('ROLE_INTG_ADMIN', '통합관리자', '전체 시스템 통합 관리자', 'ROLTYP001', NULL, 1, NULL, 'Y', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.ROLE (ROLE_CD, ROLE_NM, ROLE_EXPLN, ROLE_TYPE_CD, UP_ROLE_CD, ROLE_SORT_SEQ, SYS_CD, USE_YN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('ROLE_BIZ_ADMIN', '업무관리자', '업무 시스템 관리자', 'ROLTYP002', 'ROLE_INTG_ADMIN', 2, 'SYS001', 'Y', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.ROLE (ROLE_CD, ROLE_NM, ROLE_EXPLN, ROLE_TYPE_CD, UP_ROLE_CD, ROLE_SORT_SEQ, SYS_CD, USE_YN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('ROLE_BIZ_USER', '업무사용자', '일반 업무 사용자', 'ROLTYP003', 'ROLE_BIZ_ADMIN', 3, 'SYS001', 'Y', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.ROLE (ROLE_CD, ROLE_NM, ROLE_EXPLN, ROLE_TYPE_CD, UP_ROLE_CD, ROLE_SORT_SEQ, SYS_CD, USE_YN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('ROLE_SYS_TMPR', '임시역할', '임시 부여 역할', 'ROLETY999', NULL, 99, 'SYS001', 'Y', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.ROLE (ROLE_CD, ROLE_NM, ROLE_EXPLN, ROLE_TYPE_CD, UP_ROLE_CD, ROLE_SORT_SEQ, SYS_CD, USE_YN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('ROLE_GEO_ADMIN', 'GEO관리자', 'GEO 시스템 관리자', 'ROLTYP002', 'ROLE_INTG_ADMIN', 4, 'SYS002', 'Y', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);


-- AUTHRT 테이블 INSERT
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_UPDATE','데이터 수정 권한','데이터 수정 권한','PERMTY002','SGP','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_PROCESS','업무 처리 기능','업무 처리 기능','PERMTY001','SGP','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_RECEIVE','RES_신청서 접수 기능','신청서 접수 기능','PERMTY001','RES','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_READ','데이터 읽기 권한','데이터 읽기 권한','PERMTY002','SGP','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_READ','RES_데이터 읽기 권한','데이터 읽기 권한','PERMTY002','RES','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_SYSTEM','시스템 설정 도구','시스템 설정 도구','PERMTY003','SGP','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_SYSTEM','RES_시스템 설정 도구','시스템 설정 도구','PERMTY003','RES','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_EXPORT','RES_데이터 내보내기 도구','데이터 내보내기 도구','PERMTY003','RES','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_APPROVE','RES_승인 처리 기능','승인 처리 기능','PERMTY001','RES','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_UPDATE','RES_데이터 수정 권한','데이터 수정 권한','PERMTY002','RES','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_PROCESS','RES_업무 처리 기능','업무 처리 기능','PERMTY001','RES','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_RECEIVE','AGS_신청서 접수 기능','신청서 접수 기능','PERMTY001','AGS','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_READ','AGS_데이터 읽기 권한','데이터 읽기 권한','PERMTY002','AGS','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_SYSTEM','AGS_시스템 설정 도구','시스템 설정 도구','PERMTY003','AGS','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_EXPORT','AGS_데이터 내보내기 도구','데이터 내보내기 도구','PERMTY003','AGS','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_APPROVE','AGS_승인 처리 기능','승인 처리 기능','PERMTY001','AGS','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_UPDATE','AGS_데이터 수정 권한','데이터 수정 권한','PERMTY002','AGS','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_DELETE','데이터 삭제 권한','데이터 삭제 권한','PERMTY002','RES','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_DELETE','데이터 삭제 권한','데이터 삭제 권한','PERMTY002','SGP','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_PROCESS','AGS_업무 처리 기능','업무 처리 기능','PERMTY001','AGS','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_DATA_DELETE','AGS_데이터 삭제 권한','데이터 삭제 권한','PERMTY002','AGS','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_MENU_ACCESS','AGS_메뉴 접근 권한','메뉴 접근 권한','PERMTY001','AGS','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696073');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_MENU_ACCESS','RES_메뉴 접근 권한','메뉴 접근 권한','PERMTY001','RES','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696073');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_REPORT','RES_보고서 생성 도구','보고서 생성 도구','PERMTY003','RES','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_REPORT','AGS_보고서 생성 도구','보고서 생성 도구','PERMTY003','AGS','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_EXPORT','데이터 내보내기 도구','데이터 내보내기 도구','PERMTY003','SGP','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_APPROVE','승인 처리 기능','승인 처리 기능','PERMTY001','SGP','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_MENU_ACCESS','메뉴 접근 권한','메뉴 접근 권한','PERMTY001','SGP','Y','superadmin','2025-10-01 13:51:34.696073','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_TOOL_REPORT','보고서 생성 도구','보고서 생성 도구','PERMTY003','SGP','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');
INSERT INTO iccom.AUTHRT (AUTHRT_CD,AUTHRT_NM,AUTHRT_EXPLN,AUTHRT_TYPE_CD,SYS_CD,USE_YN,FRST_REG_ID,FRST_REG_DT,LAST_MDFCN_ID,LAST_MDFCN_DT) VALUES
    ('PERM_FUNC_RECEIVE','신청서 접수 기능','신청서 접수 기능','PERMTY001','SGP','Y','superadmin','2025-10-01 13:51:34.696','superadmin','2025-10-01 13:51:34.696');


-- USER_ROLE_MPNG 테이블 INSERT
INSERT INTO iccom.USER_ROLE_MPNG (USER_ID, ROLE_CD, ROLE_BGNG_YMD, ROLE_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('USER001', 'ROLE_INTG_ADMIN', '2025-01-01', '2025-12-31', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_MPNG (USER_ID, ROLE_CD, ROLE_BGNG_YMD, ROLE_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('USER002', 'ROLE_BIZ_ADMIN', '2025-01-01', '2025-12-31', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_MPNG (USER_ID, ROLE_CD, ROLE_BGNG_YMD, ROLE_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('USER003', 'ROLE_BIZ_USER', '2025-01-01', '2025-12-31', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_MPNG (USER_ID, ROLE_CD, ROLE_BGNG_YMD, ROLE_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('USER004', 'ROLE_GEO_ADMIN', '2025-03-01', '2025-06-30', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_MPNG (USER_ID, ROLE_CD, ROLE_BGNG_YMD, ROLE_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('USER005', 'ROLE_BIZ_USER', '2025-02-01', NULL, 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);


-- SYS_ROLE_AUTHRT_MPNG 테이블 INSERT
INSERT INTO iccom.SYS_ROLE_AUTHRT_MPNG (SYS_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('SYS001', 'ROLE_BIZ_ADMIN', 'PERM_SYS_ADMIN', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.SYS_ROLE_AUTHRT_MPNG (SYS_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('SYS001', 'ROLE_BIZ_ADMIN', 'PERM_MENU_ACCESS', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.SYS_ROLE_AUTHRT_MPNG (SYS_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('SYS001', 'ROLE_BIZ_USER', 'PERM_MENU_ACCESS', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.SYS_ROLE_AUTHRT_MPNG (SYS_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('SYS001', 'ROLE_BIZ_USER', 'PERM_DATA_READ', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.SYS_ROLE_AUTHRT_MPNG (SYS_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('SYS002', 'ROLE_GEO_ADMIN', 'PERM_SYS_ADMIN', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);


-- MENU_ROLE_AUTHRT_MPNG 테이블 INSERT
INSERT INTO iccom.MENU_ROLE_AUTHRT_MPNG (MENU_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('MENU001', 'ROLE_BIZ_ADMIN', 'PERM_MENU_ACCESS', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.MENU_ROLE_AUTHRT_MPNG (MENU_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('MENU001', 'ROLE_BIZ_ADMIN', 'PERM_FUNC_WRITE', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.MENU_ROLE_AUTHRT_MPNG (MENU_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('MENU002', 'ROLE_BIZ_USER', 'PERM_MENU_ACCESS', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.MENU_ROLE_AUTHRT_MPNG (MENU_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('MENU002', 'ROLE_BIZ_USER', 'PERM_DATA_READ', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);

INSERT INTO iccom.MENU_ROLE_AUTHRT_MPNG (MENU_CD, ROLE_CD, AUTHRT_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES ('MENU003', 'ROLE_GEO_ADMIN', 'PERM_MENU_ACCESS', 'ADMIN', CURRENT_TIMESTAMP, 'ADMIN', CURRENT_TIMESTAMP);


-- USER_ROLE_APLY_MST 테이블 INSERT
INSERT INTO iccom.USER_ROLE_APLY_MST (APLY_SN, APLY_STCD, SYS_CD, APLCN_USER_ID, APRV_USER_ID, GRNT_TYPE_CD, ATCH_FILE_ID, APLY_DT, APRV_DT, APLY_RSN, RVW_OPNN_CN, APLY_BGNG_YMD, APLY_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 'WAIT', 'SYS001', 'USER006', NULL, 'GRNT001', NULL, CURRENT_TIMESTAMP, NULL, '업무 수행을 위한 권한 신청', NULL, '2025-08-01', '2025-12-31', 'USER006', CURRENT_TIMESTAMP, 'USER006', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_MST (APLY_SN, APLY_STCD, SYS_CD, APLCN_USER_ID, APRV_USER_ID, GRNT_TYPE_CD, ATCH_FILE_ID, APLY_DT, APRV_DT, APLY_RSN, RVW_OPNN_CN, APLY_BGNG_YMD, APLY_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (2, 'APRV', 'SYS001', 'USER007', 'USER001', 'GRNT002', 'FILE001', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '프로젝트 참여', '승인함', '2025-09-01', '2025-11-30', 'USER007', CURRENT_TIMESTAMP, 'USER001', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_MST (APLY_SN, APLY_STCD, SYS_CD, APLCN_USER_ID, APRV_USER_ID, GRNT_TYPE_CD, ATCH_FILE_ID, APLY_DT, APRV_DT, APLY_RSN, RVW_OPNN_CN, APLY_BGNG_YMD, APLY_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (3, 'RJCT', 'SYS002', 'USER008', 'USER002', 'GRNT001', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '시스템 접근 권한 요청', '권한 범위 초과로 반려', '2025-10-01', '2025-12-31', 'USER008', CURRENT_TIMESTAMP, 'USER002', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_MST (APLY_SN, APLY_STCD, SYS_CD, APLCN_USER_ID, APRV_USER_ID, GRNT_TYPE_CD, ATCH_FILE_ID, APLY_DT, APRV_DT, APLY_RSN, RVW_OPNN_CN, APLY_BGNG_YMD, APLY_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (4, 'ASGN', 'SYS001', 'USER009', 'USER001', 'GRNT003', 'FILE002', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '데이터 분석 업무', '승인 및 할당 완료', '2025-11-01', '2026-01-31', 'USER009', CURRENT_TIMESTAMP, 'USER001', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_MST (APLY_SN, APLY_STCD, SYS_CD, APLCN_USER_ID, APRV_USER_ID, GRNT_TYPE_CD, ATCH_FILE_ID, APLY_DT, APRV_DT, APLY_RSN, RVW_OPNN_CN, APLY_BGNG_YMD, APLY_END_YMD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (5, 'EXPR', 'SYS001', 'USER010', 'USER001', 'GRNT001', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '단기 프로젝트 참여', '기간 만료', '2025-06-01', '2025-06-30', 'USER010', CURRENT_TIMESTAMP, 'USER001', CURRENT_TIMESTAMP);


-- USER_ROLE_APLY_DTL 테이블 INSERT
INSERT INTO iccom.USER_ROLE_APLY_DTL (APLY_DTL_SN, APLY_SN, APLCN_USER_ID, SYS_CD, ROLE_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 1, 'USER006', 'SYS001', 'ROLE_BIZ_USER', 'USER006', CURRENT_TIMESTAMP, 'USER006', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_DTL (APLY_DTL_SN, APLY_SN, APLCN_USER_ID, SYS_CD, ROLE_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 2, 'USER007', 'SYS001', 'ROLE_BIZ_ADMIN', 'USER007', CURRENT_TIMESTAMP, 'USER007', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_DTL (APLY_DTL_SN, APLY_SN, APLCN_USER_ID, SYS_CD, ROLE_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 3, 'USER008', 'SYS002', 'ROLE_GEO_ADMIN', 'USER008', CURRENT_TIMESTAMP, 'USER008', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_DTL (APLY_DTL_SN, APLY_SN, APLCN_USER_ID, SYS_CD, ROLE_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 4, 'USER009', 'SYS001', 'ROLE_BIZ_USER', 'USER009', CURRENT_TIMESTAMP, 'USER009', CURRENT_TIMESTAMP);

INSERT INTO iccom.USER_ROLE_APLY_DTL (APLY_DTL_SN, APLY_SN, APLCN_USER_ID, SYS_CD, ROLE_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (2, 4, 'USER009', 'SYS001', 'ROLE_SYS_TMPR', 'USER009', CURRENT_TIMESTAMP, 'USER009', CURRENT_TIMESTAMP);




-- 설문조사 정보
INSERT INTO iccom.SRVY (SRVY_SN, SRVY_TTL, SRVY_PRPS, GD_CN, TRGT_TYPE, SRVY_BGNG_YMD, SRVY_END_YMD, SRVY_URL_ADDR, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, '만족도 조사1', '서비스 만족도 조사', '자세히 작성', 'ST_ALL', '20250801', '20250810', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY (SRVY_SN, SRVY_TTL, SRVY_PRPS, GD_CN, TRGT_TYPE, SRVY_BGNG_YMD, SRVY_END_YMD, SRVY_URL_ADDR, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (2, '만족도 조사2', '서비스 만족도 조사', '정확하게 입력', 'ST_WORK', '20250802', '20250811', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY (SRVY_SN, SRVY_TTL, SRVY_PRPS, GD_CN, TRGT_TYPE, SRVY_BGNG_YMD, SRVY_END_YMD, SRVY_URL_ADDR, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (3, '의견 조사1', '시민 의견 수렴', '성실히 작성', 'ST_PORTAL', '20250803', '20250812', NULL, 'admin', NOW(), 'admin', NOW());

-- 설문조사 문항
INSERT INTO iccom.SRVY_QITEM (QITEM_SN, SRVY_SN, ESNTL_YN, SORT_SEQ, QITEM_TYPE_CD, QITEM_CN, MAX_CHC_CO, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 1, 'N', 1, '1', '서비스에 만족하십니까?', 1, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_QITEM (QITEM_SN, SRVY_SN, ESNTL_YN, SORT_SEQ, QITEM_TYPE_CD, QITEM_CN, MAX_CHC_CO, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (2, 2, 'N', 1, '2', '개선이 필요한 부분은?', 1, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_QITEM (QITEM_SN, SRVY_SN, ESNTL_YN, SORT_SEQ, QITEM_TYPE_CD, QITEM_CN, MAX_CHC_CO, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (3, 3, 'N', 1, '1', '이용 빈도는?', 1, 'admin', NOW(), 'admin', NOW());

-- 설문조사 문항 항목
INSERT INTO iccom.SRVY_QITEM_ARTCL (SRVY_QITEM_ARTCL_SN, SRVY_SN, QITEM_SN, ETC_ANS_YN, SORT_SEQ, ARTCL_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 1, 1, 'N', 1, '매우 그렇다', 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_QITEM_ARTCL (SRVY_QITEM_ARTCL_SN, SRVY_SN, QITEM_SN, ETC_ANS_YN, SORT_SEQ, ARTCL_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (2, 1, 1, 'N', 2, '그렇다', 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_QITEM_ARTCL (SRVY_QITEM_ARTCL_SN, SRVY_SN, QITEM_SN, ETC_ANS_YN, SORT_SEQ, ARTCL_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (3, 1, 1, 'N', 3, '보통이다', 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_QITEM_ARTCL (SRVY_QITEM_ARTCL_SN, SRVY_SN, QITEM_SN, ETC_ANS_YN, SORT_SEQ, ARTCL_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (4, 1, 1, 'N', 4, '그렇지 않다', 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_QITEM_ARTCL (SRVY_QITEM_ARTCL_SN, SRVY_SN, QITEM_SN, ETC_ANS_YN, SORT_SEQ, ARTCL_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (5, 1, 1, 'Y', 5, '전혀 그렇지 않다', 'admin', NOW(), 'admin', NOW());

-- 설문조사 응답자
INSERT INTO iccom.SRVY_RSPDNT (SRVY_RSPDNT_SN, SRVY_SN, RSPDNT_ID, RSPDNT_NM, GNDR_CD, AGE_GRP_CD, DEPT_CD, JBGD_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 1, 'RESP001', '홍길동', 'M', '30', 'DEPT001', 'POS007', 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_RSPDNT (SRVY_RSPDNT_SN, SRVY_SN, RSPDNT_ID, RSPDNT_NM, GNDR_CD, AGE_GRP_CD, DEPT_CD, JBGD_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (2, 1, 'RESP002', '김영희', 'F', '30', 'DEPT002', 'POS007', 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_RSPDNT (SRVY_RSPDNT_SN, SRVY_SN, RSPDNT_ID, RSPDNT_NM, GNDR_CD, AGE_GRP_CD, DEPT_CD, JBGD_CD, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (3, 1, 'RESP003', '이철수', 'M', '30', 'DEPT003', 'POS007', 'admin', NOW(), 'admin', NOW());

-- 설문조사 응답
INSERT INTO iccom.SRVY_RSPNS (SRVY_RSPNS_SN, SRVY_SN, QITEM_SN, SRVY_RSPDNT_SN, SRVY_QITEM_ARTCL_SN, RSPNS_CN, ETC_RSPNS_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (1, 1, 1, 1, 1, '매우 그렇다', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_RSPNS (SRVY_RSPNS_SN, SRVY_SN, QITEM_SN, SRVY_RSPDNT_SN, SRVY_QITEM_ARTCL_SN, RSPNS_CN, ETC_RSPNS_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (2, 1, 1, 2, 2, '그렇다', NULL, 'admin', NOW(), 'admin', NOW());

INSERT INTO iccom.SRVY_RSPNS (SRVY_RSPNS_SN, SRVY_SN, QITEM_SN, SRVY_RSPDNT_SN, SRVY_QITEM_ARTCL_SN, RSPNS_CN, ETC_RSPNS_CN, FRST_REG_ID, FRST_REG_DT, LAST_MDFCN_ID, LAST_MDFCN_DT)
VALUES (3, 1, 1, 3, 3, '보통이다', NULL, 'admin', NOW(), 'admin', NOW());