jhleem / egov star

임종호 임종호 2022-02-17 @92 

배너 불필요 파일 삭제
Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_mysql.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_mysql.xml (revision 91) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_mysql.xml (nonexistent) @@ -1,161 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> - -<mapper namespace="bannerDAO"> - - <resultMap id="banner" type="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerId" column="BANNER_ID" /> - <result property="bannerNm" column="BANNER_NM" /> - <result property="linkUrl" column="LINK_URL" /> - <result property="bannerImage" column="BANNER_IMAGE" /> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> - <result property="bannerDc" column="BANNER_DC" /> - <result property="sortOrdr" column="SORT_ORDR" /> - <result property="reflctAt" column="REFLCT_AT" /> - <result property="userId" column="FRST_REGISTER_ID" /> - <result property="regDate" column="FRST_REGIST_PNTTM" /> - </resultMap> - - <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO"> - <result property="atchFileId" column="ATCH_FILE_ID" /> - <result property="fileCn" column="FILE_CN" /> - <result property="fileExtsn" column="FILE_EXTSN" /> - <result property="fileMg" column="FILE_SIZE" /> - <result property="fileSn" column="FILE_SN" /> - <result property="fileStreCours" column="FILE_STRE_COURS" /> - <result property="orignlFileNm" column="ORIGNL_FILE_NM" /> - <result property="streFileNm" column="STRE_FILE_NM" /> - <result property="creatDt" column="CREAT_DT" /> - </resultMap> - - <resultMap id="bannerImage" type="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> - <result property="linkUrl" column="LINK_URL" /> - <result property="bannerNm" column="BANNER_NM" /> - </resultMap> - - <resultMap id="bannerImageFile" type="egovframework.com.cmm.service.FileVO"> - <result property="fileStreCours" column="FILE_STRE_COURS" /> - <result property="streFileNm" column="STRE_FILE_NM" /> - </resultMap> - - <select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE 1=1 - ]]> - <if test="searchCondition != null and searchCondition == 1" > - AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') - </if> - <![CDATA[ - ORDER BY FRST_REGIST_PNTTM DESC - LIMIT #{recordCountPerPage} OFFSET #{firstIndex} - ]]> - </select> - - <select id="selectBannerListTotCnt" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultType="int"> - - SELECT COUNT(*) totcnt - FROM COMTNBANNER - WHERE 1=1 - <if test="searchCondition != null and searchCondition == 1" > - AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') - </if> - </select> - - <select id="selectBanner" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE BANNER_ID = #{bannerId} - ]]> - </select> - - <insert id="insertBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - <![CDATA[ - INSERT INTO COMTNBANNER - (BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM) - VALUES (#{bannerId}, - #{bannerNm}, - #{linkUrl}, - #{bannerImage}, - #{bannerImageFile}, - #{bannerDc}, - #{sortOrdr}, - #{reflctAt}, - #{userId}, - now()) - ]]> - </insert> - - <update id="updateBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - UPDATE COMTNBANNER - SET BANNER_NM = #{bannerNm}, - LINK_URL = #{linkUrl}, - BANNER_IMAGE = #{bannerImage}, - BANNER_IMAGE_FILE = #{bannerImageFile}, - BANNER_DC = #{bannerDc}, - SORT_ORDR = #{sortOrdr}, - REFLCT_AT = #{reflctAt}, - LAST_UPDUSR_ID = #{userId}, - LAST_UPDT_PNTTM = now() - WHERE BANNER_ID = #{bannerId} - </update> - - <delete id="deleteBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - <![CDATA[ - DELETE FROM COMTNBANNER - WHERE BANNER_ID = #{bannerId} - ]]> - </delete> - - <select id="selectBannerResult" resultMap="bannerImage"> - <![CDATA[ - SELECT BANNER_IMAGE_FILE, - LINK_URL - FROM COMTNBANNER - WHERE REFLCT_AT = 'Y' - ORDER BY SORT_ORDR - ]]> - </select> - - <select id="selectBannerFile" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="bannerImageFile"> - <![CDATA[ - SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, - B.STRE_FILE_NM AS STRE_FILE_NM - FROM COMTNBANNER A, - COMTNFILEDETAIL B - WHERE 1 = 1 - AND A.BANNER_ID = #{bannerId} - AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID - ]]> - </select> -</mapper> \ No newline at end of file Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_sqlite.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_sqlite.xml (revision 91) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_sqlite.xml (nonexistent) @@ -1,163 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> - -<mapper namespace="bannerDAO"> - - <resultMap id="banner" type="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerId" column="BANNER_ID" /> - <result property="bannerNm" column="BANNER_NM" /> - <result property="linkUrl" column="LINK_URL" /> - <result property="bannerImage" column="BANNER_IMAGE" /> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> - <result property="bannerDc" column="BANNER_DC" /> - <result property="sortOrdr" column="SORT_ORDR" /> - <result property="reflctAt" column="REFLCT_AT" /> - <result property="userId" column="FRST_REGISTER_ID" /> - <result property="regDate" column="FRST_REGIST_PNTTM" /> - </resultMap> - - <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO"> - <result property="atchFileId" column="ATCH_FILE_ID" /> - <result property="fileCn" column="FILE_CN" /> - <result property="fileExtsn" column="FILE_EXTSN" /> - <result property="fileMg" column="FILE_SIZE" /> - <result property="fileSn" column="FILE_SN" /> - <result property="fileStreCours" column="FILE_STRE_COURS" /> - <result property="orignlFileNm" column="ORIGNL_FILE_NM" /> - <result property="streFileNm" column="STRE_FILE_NM" /> - <result property="creatDt" column="CREAT_DT" /> - </resultMap> - - <resultMap id="bannerImage" type="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> - <result property="linkUrl" column="LINK_URL" /> - <result property="bannerNm" column="BANNER_NM" /> - </resultMap> - - <resultMap id="bannerImageFile" type="egovframework.com.cmm.service.FileVO"> - <result property="fileStreCours" column="FILE_STRE_COURS" /> - <result property="streFileNm" column="STRE_FILE_NM" /> - </resultMap> - - <select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE 1=1 - ]]> - <if test="searchCondition != null and searchCondition == 1" > - AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') - </if> - <![CDATA[ - ORDER BY FRST_REGIST_PNTTM DESC - LIMIT #{recordCountPerPage} OFFSET #{firstIndex} - ]]> - </select> - - <select id="selectBannerListTotCnt" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultType="int"> - - SELECT COUNT(*) totcnt - FROM COMTNBANNER - WHERE 1=1 - <if test="searchCondition != null and searchCondition == 1" > - AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') - </if> - </select> - - <select id="selectBanner" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE BANNER_ID = #{bannerId} - ]]> - </select> - - <insert id="insertBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - <![CDATA[ - INSERT INTO COMTNBANNER - (BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM) - VALUES (#{bannerId}, - #{bannerNm}, - #{linkUrl}, - #{bannerImage}, - #{bannerImageFile}, - #{bannerDc}, - #{sortOrdr}, - #{reflctAt}, - #{userId}, - now()) - ]]> - </insert> - - <update id="updateBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - UPDATE COMTNBANNER - SET BANNER_NM = #{bannerNm}, - LINK_URL = #{linkUrl}, - <if test="isAtchFile != null and isAtchFile == true"> - BANNER_IMAGE = #{bannerImage}, - BANNER_IMAGE_FILE = #{bannerImageFile}, - </if> - BANNER_DC = #{bannerDc}, - SORT_ORDR = #{sortOrdr}, - REFLCT_AT = #{reflctAt}, - LAST_UPDUSR_ID = #{userId}, - LAST_UPDT_PNTTM = now() - WHERE BANNER_ID = #{bannerId} - </update> - - <delete id="deleteBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - <![CDATA[ - DELETE FROM COMTNBANNER - WHERE BANNER_ID = #{bannerId} - ]]> - </delete> - - <select id="selectBannerResult" resultMap="bannerImage"> - <![CDATA[ - SELECT BANNER_IMAGE_FILE, - LINK_URL - FROM COMTNBANNER - WHERE REFLCT_AT = 'Y' - ORDER BY SORT_ORDR - ]]> - </select> - - <select id="selectBannerFile" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="bannerImageFile"> - <![CDATA[ - SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, - B.STRE_FILE_NM AS STRE_FILE_NM - FROM COMTNBANNER A, - COMTNFILEDETAIL B - WHERE 1 = 1 - AND A.BANNER_ID = #{bannerId} - AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID - ]]> - </select> -</mapper> \ No newline at end of file Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_cubrid.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_cubrid.xml (revision 91) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_cubrid.xml (nonexistent) @@ -1,174 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> - -<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> - -<sqlMap namespace="Banner"> - - <typeAlias alias="Banner" type="egovframework.com.uss.ion.bnr.service.Banner"/> - <typeAlias alias="BannerVO" type="egovframework.com.uss.ion.bnr.service.BannerVO"/> - - <resultMap id="banner" class="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerId" column="BANNER_ID" columnIndex="1"/> - <result property="bannerNm" column="BANNER_NM" columnIndex="2"/> - <result property="linkUrl" column="LINK_URL" columnIndex="3"/> - <result property="bannerImage" column="BANNER_IMAGE" columnIndex="4"/> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="5"/> - <result property="bannerDc" column="BANNER_DC" columnIndex="6"/> - <result property="sortOrdr" column="SORT_ORDR" columnIndex="7"/> - <result property="reflctAt" column="REFLCT_AT" columnIndex="8"/> - <result property="userId" column="FRST_REGISTER_ID" columnIndex="9"/> - <result property="regDate" column="FRST_REGIST_PNTTM" columnIndex="10"/> - </resultMap> - - <resultMap id="fileList" class="egovframework.com.cmm.service.FileVO"> - <result property="atchFileId" column="ATCH_FILE_ID" columnIndex="1"/> - <result property="fileCn" column="FILE_CN" columnIndex="2"/> - <result property="fileExtsn" column="FILE_EXTSN" columnIndex="3"/> - <result property="fileMg" column="FILE_SIZE" columnIndex="4"/> - <result property="fileSn" column="FILE_SN" columnIndex="5"/> - <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="6"/> - <result property="orignlFileNm" column="ORIGNL_FILE_NM" columnIndex="7"/> - <result property="streFileNm" column="STRE_FILE_NM" columnIndex="8"/> - <result property="creatDt" column="CREAT_DT" columnIndex="9"/> - </resultMap> - - <resultMap id="bannerImage" class="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="1"/> - <result property="linkUrl" column="LINK_URL" columnIndex="2"/> - </resultMap> - - <resultMap id="bannerImageFile" class="egovframework.com.cmm.service.FileVO"> - <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="1"/> - <result property="streFileNm" column="STRE_FILE_NM" columnIndex="2"/> - </resultMap> - - <select id="bannerDAO.selectBannerList" parameterClass="BannerVO" resultMap="banner"> - <![CDATA[ - SELECT * - FROM ( - SELECT ROWNUM RNUM, ALL_LIST.* - FROM ( - - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE 1=1 - ]]> - <isEqual prepend="AND" property="searchCondition" compareValue="1"> - BANNER_NM LIKE '%'||#searchKeyword#||'%' - </isEqual> - <![CDATA[ - ORDER BY FRST_REGIST_PNTTM DESC - ) ALL_LIST - ) Z - WHERE RNUM > #firstIndex# - AND RNUM <= #firstIndex# + #recordCountPerPage# - ]]> - </select> - - <select id="bannerDAO.selectBannerListTotCnt" parameterClass="BannerVO" resultClass="int"> - - SELECT COUNT(*) totcnt - FROM COMTNBANNER - WHERE 1=1 - <isEqual prepend="AND" property="searchCondition" compareValue="1"> - BANNER_NM LIKE '%'||#searchKeyword#||'%' - </isEqual> - </select> - - <select id="bannerDAO.selectBanner" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE BANNER_ID = #bannerId# - ]]> - </select> - - <insert id="bannerDAO.insertBanner" parameterClass="Banner"> - <![CDATA[ - INSERT INTO COMTNBANNER - (BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM) - VALUES (#bannerId#, - #bannerNm#, - #linkUrl#, - #bannerImage#, - #bannerImageFile#, - #bannerDc#, - #sortOrdr#, - #reflctAt#, - #userId#, - SYSDATETIME) - ]]> - </insert> - - <update id="bannerDAO.updateBanner" parameterClass="Banner"> - UPDATE COMTNBANNER - SET BANNER_NM = #bannerNm#, - LINK_URL = #linkUrl#, - <isEqual property="isAtchFile" compareValue="true"> - BANNER_IMAGE = #bannerImage#, - BANNER_IMAGE_FILE = #bannerImageFile#, - </isEqual> - BANNER_DC = #bannerDc#, - SORT_ORDR = #sortOrdr#, - REFLCT_AT = #reflctAt#, - LAST_UPDUSR_ID = #userId#, - LAST_UPDT_PNTTM = SYSDATETIME - WHERE BANNER_ID = #bannerId# - </update> - - <delete id="bannerDAO.deleteBanner" parameterClass="Banner"> - <![CDATA[ - DELETE FROM COMTNBANNER - WHERE BANNER_ID = #bannerId# - ]]> - </delete> - - <select id="bannerDAO.selectBannerResult" resultMap="bannerImage"> - <![CDATA[ - SELECT BANNER_IMAGE_FILE, - LINK_URL - FROM COMTNBANNER - WHERE REFLCT_AT = 'Y' - ORDER BY SORT_ORDR - ]]> - </select> - - <select id="bannerDAO.selectBannerFile" parameterClass="Banner" resultMap="bannerImageFile"> - <![CDATA[ - SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, - B.STRE_FILE_NM AS STRE_FILE_NM - FROM COMTNBANNER A, - COMTNFILEDETAIL B - WHERE 1 = 1 - AND A.BANNER_ID = #bannerId# - AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID - ]]> - </select> -</sqlMap> \ No newline at end of file Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_oracle.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_oracle.xml (revision 91) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_oracle.xml (nonexistent) @@ -1,170 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> - -<mapper namespace="bannerDAO"> - <resultMap id="banner" type="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerId" column="BANNER_ID" /> - <result property="bannerNm" column="BANNER_NM" /> - <result property="linkUrl" column="LINK_URL" /> - <result property="bannerImage" column="BANNER_IMAGE" /> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> - <result property="bannerDc" column="BANNER_DC" /> - <result property="sortOrdr" column="SORT_ORDR" /> - <result property="reflctAt" column="REFLCT_AT" /> - <result property="userId" column="FRST_REGISTER_ID" /> - <result property="regDate" column="FRST_REGIST_PNTTM" /> - </resultMap> - - <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO"> - <result property="atchFileId" column="ATCH_FILE_ID" /> - <result property="fileCn" column="FILE_CN" /> - <result property="fileExtsn" column="FILE_EXTSN" /> - <result property="fileMg" column="FILE_SIZE" /> - <result property="fileSn" column="FILE_SN" /> - <result property="fileStreCours" column="FILE_STRE_COURS" /> - <result property="orignlFileNm" column="ORIGNL_FILE_NM" /> - <result property="streFileNm" column="STRE_FILE_NM" /> - <result property="creatDt" column="CREAT_DT" /> - </resultMap> - - <resultMap id="bannerImage" type="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> - <result property="linkUrl" column="LINK_URL" /> - <result property="bannerNm" column="BANNER_NM" /> - </resultMap> - - <resultMap id="bannerImageFile" type="egovframework.com.cmm.service.FileVO"> - <result property="fileStreCours" column="FILE_STRE_COURS" /> - <result property="streFileNm" column="STRE_FILE_NM" /> - </resultMap> - - <select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner"> - <![CDATA[ - SELECT * - FROM ( - SELECT ROWNUM RNUM, ALL_LIST.* - FROM ( - - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE 1=1 - ]]> - <if test="searchCondition != null and searchCondition == 1" > - AND BANNER_NM LIKE '%'||#{searchKeyword}||'%' - </if> - <![CDATA[ - ORDER BY FRST_REGIST_PNTTM DESC - ) ALL_LIST - ) - WHERE RNUM > #{firstIndex} - AND RNUM <= #{firstIndex} + #{recordCountPerPage} - ]]> - </select> - - <select id="selectBannerListTotCnt" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultType="int"> - SELECT COUNT(*) totcnt - FROM COMTNBANNER - WHERE 1=1 - <if test="searchCondition != null and searchCondition == 1" > - AND BANNER_NM LIKE '%'||#{searchKeyword}||'%' - </if> - </select> - - <select id="selectBanner" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE BANNER_ID = #{bannerId} - ]]> - </select> - - <insert id="insertBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - <![CDATA[ - INSERT INTO COMTNBANNER - (BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM) - VALUES (#{bannerId}, - #{bannerNm}, - #{linkUrl}, - #{bannerImage}, - #{bannerImageFile}, - #{bannerDc}, - #{sortOrdr}, - #{reflctAt}, - #{userId}, - SYSDATE) - ]]> - </insert> - - <update id="updateBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - UPDATE COMTNBANNER - SET BANNER_NM = #{bannerNm}, - LINK_URL = #{linkUrl}, - <if test="isAtchFile != null and isAtchFile == true"> - BANNER_IMAGE = #{bannerImage}, - BANNER_IMAGE_FILE = #{bannerImageFile}, - </if> - BANNER_DC = #{bannerDc}, - SORT_ORDR = #{sortOrdr}, - REFLCT_AT = #{reflctAt}, - LAST_UPDUSR_ID = #{userId}, - LAST_UPDT_PNTTM = SYSDATE - WHERE BANNER_ID = #{bannerId} - </update> - - <delete id="deleteBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> - <![CDATA[ - DELETE FROM COMTNBANNER - WHERE BANNER_ID = #{bannerId} - ]]> - </delete> - - <select id="selectBannerResult" resultMap="bannerImage"> - <![CDATA[ - SELECT BANNER_IMAGE_FILE, - LINK_URL, - BANNER_NM - FROM COMTNBANNER - WHERE REFLCT_AT = 'Y' - ORDER BY SORT_ORDR - ]]> - </select> - - <select id="selectBannerFile" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="bannerImageFile"> - <![CDATA[ - SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, - B.STRE_FILE_NM AS STRE_FILE_NM - FROM COMTNBANNER A, - COMTNFILEDETAIL B - WHERE 1 = 1 - AND A.BANNER_ID = #{bannerId} - AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID - ]]> - </select> -</mapper> \ No newline at end of file Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_altibase.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_altibase.xml (revision 91) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_altibase.xml (nonexistent) @@ -1,174 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> - -<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> - -<sqlMap namespace="Banner"> - - <typeAlias alias="Banner" type="egovframework.com.uss.ion.bnr.service.Banner"/> - <typeAlias alias="BannerVO" type="egovframework.com.uss.ion.bnr.service.BannerVO"/> - - <resultMap id="banner" class="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerId" column="BANNER_ID" columnIndex="1"/> - <result property="bannerNm" column="BANNER_NM" columnIndex="2"/> - <result property="linkUrl" column="LINK_URL" columnIndex="3"/> - <result property="bannerImage" column="BANNER_IMAGE" columnIndex="4"/> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="5"/> - <result property="bannerDc" column="BANNER_DC" columnIndex="6"/> - <result property="sortOrdr" column="SORT_ORDR" columnIndex="7"/> - <result property="reflctAt" column="REFLCT_AT" columnIndex="8"/> - <result property="userId" column="FRST_REGISTER_ID" columnIndex="9"/> - <result property="regDate" column="FRST_REGIST_PNTTM" columnIndex="10"/> - </resultMap> - - <resultMap id="fileList" class="egovframework.com.cmm.service.FileVO"> - <result property="atchFileId" column="ATCH_FILE_ID" columnIndex="1"/> - <result property="fileCn" column="FILE_CN" columnIndex="2"/> - <result property="fileExtsn" column="FILE_EXTSN" columnIndex="3"/> - <result property="fileMg" column="FILE_SIZE" columnIndex="4"/> - <result property="fileSn" column="FILE_SN" columnIndex="5"/> - <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="6"/> - <result property="orignlFileNm" column="ORIGNL_FILE_NM" columnIndex="7"/> - <result property="streFileNm" column="STRE_FILE_NM" columnIndex="8"/> - <result property="creatDt" column="CREAT_DT" columnIndex="9"/> - </resultMap> - - <resultMap id="bannerImage" class="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="1"/> - <result property="linkUrl" column="LINK_URL" columnIndex="2"/> - </resultMap> - - <resultMap id="bannerImageFile" class="egovframework.com.cmm.service.FileVO"> - <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="1"/> - <result property="streFileNm" column="STRE_FILE_NM" columnIndex="2"/> - </resultMap> - - <select id="bannerDAO.selectBannerList" parameterClass="BannerVO" resultMap="banner"> - <![CDATA[ - SELECT * - FROM ( - SELECT ROWNUM RNUM, ALL_LIST.* - FROM ( - - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE 1=1 - ]]> - <isEqual prepend="AND" property="searchCondition" compareValue="1"> - BANNER_NM LIKE '%'||#searchKeyword#||'%' - </isEqual> - <![CDATA[ - ORDER BY FRST_REGIST_PNTTM DESC - ) ALL_LIST - ) - WHERE RNUM > #firstIndex# - AND RNUM <= #firstIndex# + #recordCountPerPage# - ]]> - </select> - - <select id="bannerDAO.selectBannerListTotCnt" parameterClass="BannerVO" resultClass="int"> - - SELECT COUNT(*) totcnt - FROM COMTNBANNER - WHERE 1=1 - <isEqual prepend="AND" property="searchCondition" compareValue="1"> - BANNER_NM LIKE '%'||#searchKeyword#||'%' - </isEqual> - </select> - - <select id="bannerDAO.selectBanner" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE BANNER_ID = #bannerId# - ]]> - </select> - - <insert id="bannerDAO.insertBanner" parameterClass="Banner"> - <![CDATA[ - INSERT INTO COMTNBANNER - (BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM) - VALUES (#bannerId#, - #bannerNm#, - #linkUrl#, - #bannerImage#, - #bannerImageFile#, - #bannerDc#, - #sortOrdr#, - #reflctAt#, - #userId#, - SYSDATE) - ]]> - </insert> - - <update id="bannerDAO.updateBanner" parameterClass="Banner"> - UPDATE COMTNBANNER - SET BANNER_NM = #bannerNm#, - LINK_URL = #linkUrl#, - <isEqual property="isAtchFile" compareValue="true"> - BANNER_IMAGE = #bannerImage#, - BANNER_IMAGE_FILE = #bannerImageFile#, - </isEqual> - BANNER_DC = #bannerDc#, - SORT_ORDR = #sortOrdr#, - REFLCT_AT = #reflctAt#, - LAST_UPDUSR_ID = #userId#, - LAST_UPDT_PNTTM = SYSDATE - WHERE BANNER_ID = #bannerId# - </update> - - <delete id="bannerDAO.deleteBanner" parameterClass="Banner"> - <![CDATA[ - DELETE FROM COMTNBANNER - WHERE BANNER_ID = #bannerId# - ]]> - </delete> - - <select id="bannerDAO.selectBannerResult" resultMap="bannerImage"> - <![CDATA[ - SELECT BANNER_IMAGE_FILE, - LINK_URL - FROM COMTNBANNER - WHERE REFLCT_AT = 'Y' - ORDER BY SORT_ORDR - ]]> - </select> - - <select id="bannerDAO.selectBannerFile" parameterClass="Banner" resultMap="bannerImageFile"> - <![CDATA[ - SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, - B.STRE_FILE_NM AS STRE_FILE_NM - FROM COMTNBANNER A, - COMTNFILEDETAIL B - WHERE 1 = 1 - AND A.BANNER_ID = #bannerId# - AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID - ]]> - </select> -</sqlMap> \ No newline at end of file Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_tibero.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_tibero.xml (revision 91) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_tibero.xml (nonexistent) @@ -1,174 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> - -<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> - -<sqlMap namespace="Banner"> - - <typeAlias alias="Banner" type="egovframework.com.uss.ion.bnr.service.Banner"/> - <typeAlias alias="BannerVO" type="egovframework.com.uss.ion.bnr.service.BannerVO"/> - - <resultMap id="banner" class="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerId" column="BANNER_ID" columnIndex="1"/> - <result property="bannerNm" column="BANNER_NM" columnIndex="2"/> - <result property="linkUrl" column="LINK_URL" columnIndex="3"/> - <result property="bannerImage" column="BANNER_IMAGE" columnIndex="4"/> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="5"/> - <result property="bannerDc" column="BANNER_DC" columnIndex="6"/> - <result property="sortOrdr" column="SORT_ORDR" columnIndex="7"/> - <result property="reflctAt" column="REFLCT_AT" columnIndex="8"/> - <result property="userId" column="FRST_REGISTER_ID" columnIndex="9"/> - <result property="regDate" column="FRST_REGIST_PNTTM" columnIndex="10"/> - </resultMap> - - <resultMap id="fileList" class="egovframework.com.cmm.service.FileVO"> - <result property="atchFileId" column="ATCH_FILE_ID" columnIndex="1"/> - <result property="fileCn" column="FILE_CN" columnIndex="2"/> - <result property="fileExtsn" column="FILE_EXTSN" columnIndex="3"/> - <result property="fileMg" column="FILE_SIZE" columnIndex="4"/> - <result property="fileSn" column="FILE_SN" columnIndex="5"/> - <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="6"/> - <result property="orignlFileNm" column="ORIGNL_FILE_NM" columnIndex="7"/> - <result property="streFileNm" column="STRE_FILE_NM" columnIndex="8"/> - <result property="creatDt" column="CREAT_DT" columnIndex="9"/> - </resultMap> - - <resultMap id="bannerImage" class="egovframework.com.uss.ion.bnr.service.BannerVO"> - <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="1"/> - <result property="linkUrl" column="LINK_URL" columnIndex="2"/> - </resultMap> - - <resultMap id="bannerImageFile" class="egovframework.com.cmm.service.FileVO"> - <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="1"/> - <result property="streFileNm" column="STRE_FILE_NM" columnIndex="2"/> - </resultMap> - - <select id="bannerDAO.selectBannerList" parameterClass="BannerVO" resultMap="banner"> - <![CDATA[ - SELECT * - FROM ( - SELECT ROWNUM RNUM, ALL_LIST.* - FROM ( - - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE 1=1 - ]]> - <isEqual prepend="AND" property="searchCondition" compareValue="1"> - BANNER_NM LIKE '%'||#searchKeyword#||'%' - </isEqual> - <![CDATA[ - ORDER BY FRST_REGIST_PNTTM DESC - ) ALL_LIST - ) - WHERE RNUM > #firstIndex# - AND RNUM <= #firstIndex# + #recordCountPerPage# - ]]> - </select> - - <select id="bannerDAO.selectBannerListTotCnt" parameterClass="BannerVO" resultClass="int"> - - SELECT COUNT(*) totcnt - FROM COMTNBANNER - WHERE 1=1 - <isEqual prepend="AND" property="searchCondition" compareValue="1"> - BANNER_NM LIKE '%'||#searchKeyword#||'%' - </isEqual> - </select> - - <select id="bannerDAO.selectBanner" resultMap="banner"> - <![CDATA[ - SELECT BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM - FROM COMTNBANNER - WHERE BANNER_ID = #bannerId# - ]]> - </select> - - <insert id="bannerDAO.insertBanner" parameterClass="Banner"> - <![CDATA[ - INSERT INTO COMTNBANNER - (BANNER_ID, - BANNER_NM, - LINK_URL, - BANNER_IMAGE, - BANNER_IMAGE_FILE, - BANNER_DC, - SORT_ORDR, - REFLCT_AT, - FRST_REGISTER_ID, - FRST_REGIST_PNTTM) - VALUES (#bannerId#, - #bannerNm#, - #linkUrl#, - #bannerImage#, - #bannerImageFile#, - #bannerDc#, - #sortOrdr#, - #reflctAt#, - #userId#, - SYSDATE) - ]]> - </insert> - - <update id="bannerDAO.updateBanner" parameterClass="Banner"> - UPDATE COMTNBANNER - SET BANNER_NM = #bannerNm#, - LINK_URL = #linkUrl#, - <isEqual property="isAtchFile" compareValue="true"> - BANNER_IMAGE = #bannerImage#, - BANNER_IMAGE_FILE = #bannerImageFile#, - </isEqual> - BANNER_DC = #bannerDc#, - SORT_ORDR = #sortOrdr#, - REFLCT_AT = #reflctAt#, - LAST_UPDUSR_ID = #userId#, - LAST_UPDT_PNTTM = SYSDATE - WHERE BANNER_ID = #bannerId# - </update> - - <delete id="bannerDAO.deleteBanner" parameterClass="Banner"> - <![CDATA[ - DELETE FROM COMTNBANNER - WHERE BANNER_ID = #bannerId# - ]]> - </delete> - - <select id="bannerDAO.selectBannerResult" resultMap="bannerImage"> - <![CDATA[ - SELECT BANNER_IMAGE_FILE, - LINK_URL - FROM COMTNBANNER - WHERE REFLCT_AT = 'Y' - ORDER BY SORT_ORDR - ]]> - </select> - - <select id="bannerDAO.selectBannerFile" parameterClass="Banner" resultMap="bannerImageFile"> - <![CDATA[ - SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, - B.STRE_FILE_NM AS STRE_FILE_NM - FROM COMTNBANNER A, - COMTNFILEDETAIL B - WHERE 1 = 1 - AND A.BANNER_ID = #bannerId# - AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID - ]]> - </select> -</sqlMap> \ No newline at end of file Index: base3.10/script/cross_dml.sql =================================================================== --- base3.10/script/cross_dml.sql (nonexistent) +++ base3.10/script/cross_dml.sql (revision 92) @@ -0,0 +1,563 @@ +-- 공통분류코드 +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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM',NOW(), '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', NOW(), 'SYSTEM',NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), '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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); + +-- 공통상세코드 +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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', NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM', NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); +INSERT 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',NOW(), 'SYSTEM',NOW(), 'SYSTEM'); + +-- 그룹 +INSERT INTO COMTNAUTHORGROUPINFO ( GROUP_ID, GROUP_NM, GROUP_CREAT_DE,GROUP_DC ) VALUES ( 'GROUP_00000000000000', '0번 그룹입니다', NOW(), '0번 그룹입니다'); + +-- 조직 COMTNORGNZTINFO +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','',NOW()); +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','',NOW()); + +-- 일반사용자정보 +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',NOW(),'F','USRCNFRM_00000000001'); + +-- 기업사용자정보 +INSERT INTO COMTNENTRPRSMBER (ENTRPRS_MBER_ID,ENTRPRS_SE_CODE,BIZRNO,JURIRNO,CMPNY_NM,CXFC,ZIP,ADRES,ENTRPRS_MIDDLE_TELNO,FXNUM,INDUTY_CODE,APPLCNT_NM,APPLCNT_IHIDNUM,SBSCRB_DE,ENTRPRS_MBER_STTUS,ENTRPRS_MBER_PASSWORD,ENTRPRS_MBER_PASSWORD_HINT,ENTRPRS_MBER_PASSWORD_CNSR,GROUP_ID,DETAIL_ADRES,ENTRPRS_END_TELNO,AREA_NO,APPLCNT_EMAIL_ADRES,ESNTL_ID) values ('ENTERPRISE','C0000001','1008360001','1000310000011','NIA','이가브','100775','서울특별시 중구 청계천로 14 - 0 한국정보사회진흥원','1566','1566-2059','O','관리자',null,NOW(),'P','ZQhr3oB5QWjBnBO0kbFF7bvQDLkk+Em0ExjTq5JtVTo=','P01','전자정부표준프레임워크센터','GROUP_00000000000000','표준프레임워크센터','2059','02','egovframesupport@gmail.com','USRCNFRM_00000000002'); + +-- 권한정보 +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 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 COMTNEMPLYRSCRTYESTBS (SCRTY_DTRMN_TRGET_ID, MBER_TY_CODE, AUTHOR_CODE) VALUES ('USRCNFRM_99999999999', 'USR03', '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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +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', NOW()); +INSERT INTO COMTNROLEINFO (ROLE_CODE, ROLE_NM, ROLE_PTTRN, ROLE_DC, ROLE_TY, ROLE_SORT, ROLE_CREAT_DE) VALUES('web-000012', 'Validator모듈','/validator.do','Validator에 대한 접근 제한 롤', 'url', '1', NOW()); + +-- 권한 롤 매핑 +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000001', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000002', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000004', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000005', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000006', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000007', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000008', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000009', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000010', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000011', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ANONYMOUS', 'web-000012', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_USER', 'web-000003', NOW()); +INSERT INTO COMTNAUTHORROLERELATE (AUTHOR_CODE, ROLE_CODE, CREAT_DT) VALUES ('ROLE_ADMIN', 'web-000003', NOW()); \ No newline at end of file Index: base3.10/script/function.sql =================================================================== --- base3.10/script/function.sql (nonexistent) +++ base3.10/script/function.sql (revision 92) @@ -0,0 +1,105 @@ +-- 권한코드로 권한명을 반환 +CREATE OR REPLACE FUNCTION fncauthorcodenm(param1 character varying) + RETURNS character varying + LANGUAGE plpgsql +AS $function$BEGIN +RETURN (SELECT array_to_string(array_agg(b.author_nm), ',') + FROM unnest(string_to_array(param1, ',')) as a + , comtnauthorinfo as b + WHERE a.a = b.author_code); + end; $function$ +; +COMMENT ON FUNCTION fncauthorcodenm(varchar) IS '권한코드 명을 반환한다. +fncauthorcodenm(author_code)'; + +-- 파일ID로 링크정보를 반환 +CREATE OR REPLACE FUNCTION fnconvertfileid(param character varying) + RETURNS character varying + LANGUAGE plpgsql +AS $function$BEGIN +RETURN ( +select array_to_string(array_agg(xx.link), ',') +from tnfile xx, ( +select unnest(string_to_array(param, ',')) as fileid +) yy +where xx.file_id = yy.fileid +); +end; $function$ +; +COMMENT ON FUNCTION fncmenudownurl(varchar) IS '파일아이디목록을 파일링크목록으로 변환한다. +fnconvertfileid(fileIdList)'; + +-- 메뉴ID, 사용자고유ID로 접속가능한 메뉴 반환(dir 제외) +CREATE OR REPLACE FUNCTION fncmenudownurl(param1 character varying, param2 character varying) + RETURNS character varying + LANGUAGE plpgsql +AS $function$BEGIN +RETURN ( + with recursive menuView as ( + select a.menu_no + , upper_menu_no + , b.progr_url + , 1 as depth + , array[b.progr_url::text] as path + , array[a.menu_ordr] as ordr + , false as cycle + from TNMENUINFO a + inner join TNMENUPROGRAMINFO b on a.menu_no = b.menu_no + where a.menu_no = param1 + and a.use_yn = 'Y' + and b.default_yn = 'Y' + union all + select b.menu_no + , b.upper_menu_no + , c.progr_url + , depth + 1 + , array_append(path, c.progr_url::text) + , array_append(ordr, b.menu_ordr) + , c.progr_url::text <> any(a.path) + from menuView a + inner join TNMENUINFO b on a.menu_no = b.upper_menu_no + inner join TNMENUPROGRAMINFO c on b.menu_no = c.menu_no + inner join TNMENUAUTHOINFO d on c.progr_url = d.progr_url + where b.use_yn = 'Y' + and c.default_yn = 'Y' + and a.upper_menu_no <> 'ROOT' + and not a.cycle + and ( + d.author_code IN + ( + select unnest(string_to_array(coalesce( + ( + select author_code + from comtnemplyrscrtyestbs c + where scrty_dtrmn_trget_id = param2 + ) + , 'ROLE_ANONYMOUS'), ',')) + ) + or d.USER_ID = param2 + ) + ) + select a.progr_url + from menuView a + order by a.cycle desc, a.ordr + limit 1 +); + end; $function$ +; +COMMENT ON FUNCTION fncmenudownurl(varchar,varchar) IS '하위 프로그램URL 을 반환한다. +fncmenudownurl(menu_no, estntl_id)'; + +-- 공통코드로 공통코드명을 반환 +CREATE OR REPLACE FUNCTION fnccomcodenm(param1 character varying, param2 character varying) + RETURNS character varying + LANGUAGE plpgsql +AS $function$BEGIN +RETURN (SELECT CODE_NM + FROM COMTCCMMNDETAILCODE + WHERE CODE = PARAM1 + AND CODE_ID = PARAM2); + end; $function$ +; + + +COMMENT ON FUNCTION fnccomcodenm(varchar,varchar) IS '공통코드 명을 반환한다. +fnccomcodenm(code, code_id)'; Index: base3.10/script/postgres.erm =================================================================== --- base3.10/script/postgres.erm (revision 91) +++ base3.10/script/postgres.erm (revision 92) @@ -11,8 +11,8 @@ </page_setting> <category_index>0</category_index> <zoom>1.0</zoom> - <x>1791</x> - <y>1296</y> + <x>0</x> + <y>854</y> <default_color> <r>255</r> <g>128</g> @@ -33,7 +33,7 @@ <notation_level>5</notation_level> <notation_expand_group>true</notation_expand_group> <view_mode>2</view_mode> - <outline_view_mode>1</outline_view_mode> + <outline_view_mode>2</outline_view_mode> <view_order_by>1</view_order_by> <auto_ime_change>false</auto_ime_change> <validate_physical_name>true</validate_physical_name> @@ -231,8 +231,8 @@ </category> <category> <id>39</id> - <height>1041</height> - <width>1296</width> + <height>1081</height> + <width>1044</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> <x>1836</x> @@ -277,7 +277,7 @@ </connections> <display>false</display> <creation_date>2022-01-26 16:20:32</creation_date> - <updated_date>2022-02-17 09:51:34</updated_date> + <updated_date>2022-02-17 11:34:49</updated_date> <model_property> <name>프로젝트명</name> <value></value>
Add a comment
List