Commit @13 - jhleem/egov

Files
Commit

임종호 2022-02-08 @13

Index: base3.10/src/main/java/egovframework/com/cmm/interceptor/AuthenticInterceptor.java =================================================================== --- base3.10/src/main/java/egovframework/com/cmm/interceptor/AuthenticInterceptor.java (revision 12) +++ base3.10/src/main/java/egovframework/com/cmm/interceptor/AuthenticInterceptor.java (revision 13) @@ -63,17 +63,6 @@ /** log */ private static final Logger LOGGER = LoggerFactory.getLogger(AuthenticInterceptor.class); - - /** 관리자 접근 권한 패턴 목록 */ - private List<String> adminAuthPatternList; - - public List<String> getAdminAuthPatternList() { - return adminAuthPatternList; - } - - public void setAdminAuthPatternList(List<String> adminAuthPatternList) { - this.adminAuthPatternList = adminAuthPatternList; - } /** * 인증된 사용자 여부로 인증 여부를 체크한다. Index: base3.10/src/main/java/egovframework/com/sym/ccm/ccc/web/EgovCcmCmmnClCodeManageController.java =================================================================== --- base3.10/src/main/java/egovframework/com/sym/ccm/ccc/web/EgovCcmCmmnClCodeManageController.java (revision 12) +++ base3.10/src/main/java/egovframework/com/sym/ccm/ccc/web/EgovCcmCmmnClCodeManageController.java (revision 13) @@ -93,7 +93,8 @@ paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); - return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeList"; +// return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeList"; + return ".adminLayout/공통분류코드/com/sym/ccm/ccc/EgovCcmCmmnClCodeList"; } /** @@ -113,7 +114,7 @@ model.addAttribute("result", vo); - return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeDetail"; + return ".adminLayout/공통분류코드/com/sym/ccm/ccc/EgovCcmCmmnClCodeDetail"; } /** @@ -128,7 +129,7 @@ public String insertCmmnClCodeView(@ModelAttribute("searchVO")CmmnClCodeVO cmmnClCodeVO, ModelMap model) throws Exception { model.addAttribute("cmmnClCodeVO", new CmmnClCodeVO()); - return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist"; + return ".adminLayout/공통분류코드/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist"; } /** @@ -151,14 +152,14 @@ beanValidator.validate(cmmnClCodeVO, bindingResult); if (bindingResult.hasErrors()) { - return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist"; + return ".adminLayout/공통분류코드/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist"; } if(cmmnClCodeVO.getClCode() != null){ CmmnClCode vo = cmmnClCodeManageService.selectCmmnClCodeDetail(cmmnClCodeVO); if(vo != null){ model.addAttribute("message", egovMessageSource.getMessage("comSymCcmCcc.validate.codeCheck")); - return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist"; + return ".adminLayout/공통분류코드/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist"; } } @@ -205,7 +206,7 @@ model.addAttribute("cmmnClCodeVO", result); - return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeUpdt"; + return ".adminLayout/공통분류코드/com/sym/ccm/ccc/EgovCcmCmmnClCodeUpdt"; } /** @@ -229,7 +230,7 @@ CmmnClCode result = cmmnClCodeManageService.selectCmmnClCodeDetail(cmmnClCode); model.addAttribute("cmmnClCodeVO", result); - return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeUpdt"; + return ".adminLayout/공통분류코드/com/sym/ccm/ccc/EgovCcmCmmnClCodeUpdt"; } cmmnClCodeVO.setLastUpdusrId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist.jsp (revision 12) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeRegist.jsp (revision 13) @@ -25,25 +25,27 @@ <%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %> <%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator" %> <c:set var="pageTitle"><spring:message code="comSymCcmCcc.cmmnClCodeVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle} <spring:message code="title.create" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> <script type="text/javascript" src="<c:url value="/validator.do"/>"></script> <validator:javascript formName="cmmnClCodeVO" staticJavascript="false" xhtml="true" cdata="false"/> <script type="text/javascript"> /* ******************************************************** * 초기화 ******************************************************** */ +$(function() { + fn_egov_init(); fncShowMessg(); +}) function fn_egov_init(){ - // 첫 입력란에 포커스 document.getElementById("cmmnClCodeVO").clCode.focus(); } /* ******************************************************** + * 목록 으로 가기 + ******************************************************** */ +function fn_egov_list_CmmnClCode(){ + location.href = "<c:url value='/sym/ccm/ccc/SelectCcmCmmnClCodeList.do' />"; +} +/* ******************************************************** * 저장처리화면 ******************************************************** */ function fn_egov_regist_code(form){ @@ -56,7 +58,6 @@ } } } - /* ******************************************************** * 서버 처리 후 메세지 화면에 보여주기 ******************************************************** */ @@ -68,82 +69,88 @@ </script> -</head> -<body onLoad="fn_egov_init(); fncShowMessg();"> <form:form commandName="cmmnClCodeVO" action="${pageContext.request.contextPath}/sym/ccm/ccc/RegistCcmCmmnClCode.do" method="post" onSubmit="fn_egov_regist_code(document.forms[0]); return false;"> -<div class="wTableFrm">  - <h2>${pageTitle} <spring:message code="title.create" /></h2> + <div class="board_header"> + <h3>${pageTitle } + <spring:message code="title.create" /> + </h3> + </div>  - <table class="wTable" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> - <caption>${pageTitle } <spring:message code="title.create" /></caption> - <colgroup> - <col style="width: 20%;"><col style="width: ;"> - </colgroup> - <tbody> -  - <c:set var="inputTxt"><spring:message code="input.input" /></c:set> - <c:set var="inputYes"><spring:message code="input.yes" /></c:set> - <c:set var="inputNo"><spring:message code="input.no" /></c:set> - -  - <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCode"/> </c:set> - <tr> - <th><label for="clCode">${title} <span class="pilsu">*</span></label></th> - <td class="left"> - <form:input path="clCode" title="${title} ${inputTxt}" size="70" maxlength="70" /> - <div><form:errors path="clCode" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeNm"/> </c:set> - <tr> - <th><label for="clCodeNm">${title} <span class="pilsu">*</span></label></th> - <td class="left"> - <form:input path="clCodeNm" title="${title} ${inputTxt}" size="70" maxlength="70" /> - <div><form:errors path="clCodeNm" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeDc"/> </c:set> - <tr> - <th><label for="clCodeDc">${title } <span class="pilsu">*</span></label></th> - <td class="nopd"> - <form:textarea path="clCodeDc" title="${title} ${inputTxt}" cols="300" rows="20" /> - <div><form:errors path="clCodeDc" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.useAt"/> </c:set> - <tr> - <th>${title } <span class="pilsu">*</span></th> - <td class="left"> - <form:select path="useAt" title="${title} ${inputTxt}" cssClass="txt"> - <form:option value="Y" label=" ${inputYes}"/> - <form:option value="N" label=" ${inputNo}"/> - </form:select> - <div><form:errors path="useAt" cssClass="error" /></div> - </td> - </tr> - - </tbody> - </table> - + <div class="board_body"> +  + <p class="must_text"><em>＊</em>는 필수 입력사항입니다.</p> + <table class="table_write" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> + <caption>${pageTitle } <spring:message code="title.create" /></caption> + <caption>공통분류코드 관리 - 분류코드, 분류코드명, 분류코드설명, 사용여부로 구성</caption> + <colgroup> + <col style="width: 20%;"><col style="width: ;"> + </colgroup> + <tbody> +  + <c:set var="inputTxt"><spring:message code="input.input" /></c:set> + <c:set var="inputYes"><spring:message code="input.yes" /></c:set> + <c:set var="inputNo"><spring:message code="input.no" /></c:set> + +  + <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCode"/> </c:set> + <tr> + <th scope="row" class="must"><label for="clCode">${title}</label></th> + <td class="left"> + <form:input path="clCode" title="${title} ${inputTxt}" size="70" maxlength="70" cssClass="inputText width100p"/> + <div><form:errors path="clCode" cssClass="error" /></div> + </td> + </tr> + +  + <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeNm"/> </c:set> + <tr> + <th scope="row" class="must"><label for="clCodeNm">${title}</label></th> + <td class="left"> + <form:input path="clCodeNm" title="${title} ${inputTxt}" size="70" maxlength="70" cssClass="inputText width100p"/> + <div><form:errors path="clCodeNm" cssClass="error" /></div> + </td> + </tr> + +  + <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeDc"/> </c:set> + <tr> + <th scope="row"><label for="clCodeDc">${title }</label></th> + <td class="left"> + <form:textarea path="clCodeDc" title="${title} ${inputTxt}" cols="300" rows="20" cssClass="textArea width100p"/> + <div><form:errors path="clCodeDc" cssClass="error" /></div> + </td> + </tr> + +  + <c:set var="title"><spring:message code="comSymCcmCcc.cmmnClCodeVO.useAt"/> </c:set> + <tr> + <th scope="row" class="must">${title }</th> + <td class="left"> + <form:select path="useAt" title="${title} ${inputTxt}" cssClass="selectText"> + <form:option value="Y" label=" ${inputYes}"/> + <form:option value="N" label=" ${inputNo}"/> + </form:select> + <div><form:errors path="useAt" cssClass="error" /></div> + </td> + </tr> + </tbody> + </table> + </div>  - <div class="btn"> - <input type="submit" class="s_submit" value="<spring:message code="button.create" />" title="<spring:message code="button.create" /> <spring:message code="input.button" />" /> - <span class="btn_s"><a href="<c:url value='/sym/ccm/ccc/SelectCcmCmmnClCodeList.do' />" title="<spring:message code="button.list" /> <spring:message code="input.button" />"><spring:message code="button.list" /></a></span> - </div><div style="clear:both;"></div> - -</div> - -<input name="cmd" type="hidden" value="<c:out value='save'/>"> -</form:form> - -</body> -</html> + <div class="board_footer"> + <div class="fl bottom_wrap"> + <button class="btn_s" type="button" onclick="fn_egov_list_CmmnClCode();" title="<spring:message code="button.list" /> <spring:message code="input.button" />"> + <spring:message code="button.list" /> + </button> + </div> + <div class="fr bottom_wrap"> + <button class="btn_s" type="button" onclick="fn_egov_regist_code(document.forms[0]); return false;" title="<spring:message code="button.create" /> <spring:message code="input.button" />"> + <spring:message code="button.create" /> + </button> + </div> + </div> + <input name="cmd" type="hidden" value="<c:out value='save'/>"> +</form:form> \ No newline at end of file Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeList.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeList.jsp (revision 12) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeList.jsp (revision 13) @@ -21,13 +21,10 @@ <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> <%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> <c:set var="pageTitle"><spring:message code="comSymCcmCcc.cmmnClCodeVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle} <spring:message code="title.list" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> <script type="text/javascript"> +$(function() { + fn_egov_init(); +}); /********************************************************* * 초기화 ******************************************************** */ @@ -52,7 +49,7 @@ document.CcmClCodeForm.submit(); } /* ******************************************************** - * 상세회면 처리 함수 + * 상세화면 처리 함수 ******************************************************** */ function fn_egov_inquire_codedetail(clCode) { // 사이트 키값(siteId) 셋팅. @@ -60,82 +57,83 @@ document.CcmClCodeForm.action = "<c:url value='/sym/ccm/ccc/SelectCcmCmmnClCodeDetail.do'/>"; document.CcmClCodeForm.submit(); } +/* ******************************************************** + * 등록화면 처리 함수 + ******************************************************** */ +function fn_egov_regist_code(){ + document.CcmClCodeForm.action = "<c:url value='/sym/ccm/ccc/RegistCcmCmmnClCodeView.do'/>"; + document.CcmClCodeForm.submit(); +} </script> -</head> -<body onload="fn_egov_init()"> - <form name="CcmClCodeForm" action="<c:url value='/sym/ccm/ccc/SelectCcmCmmnClCodeList.do'/>" method="post" onSubmit="fn_egov_search_code(); return false;"> -<div class="board"> - <h1>${pageTitle} <spring:message code="title.list" /></h1> -  -  - <div class="search_box" title="<spring:message code="common.searchCondition.msg" />"> - <ul> - <li> - <select name="searchCondition" title="<spring:message code="title.searchCondition" />"> - - <%-- <option <c:if test="${searchVO.searchCondition == ''}">selected="selected"</c:if>><spring:message code="input.select" /></option> --%> - <option selected value=''><spring:message code="input.select" /></option> - <option value="1" <c:if test="${searchVO.searchCondition == '1'}">selected="selected"</c:if> ><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCode" /></option> - <option value="2" <c:if test="${searchVO.searchCondition == '2'}">selected="selected"</c:if> ><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeNm" /></option> - </select> - </li> + <div class="board_header"> + <h3>${pageTitle} <spring:message code="title.list" /></h3> +  + <div class="search_box" title="<spring:message code="common.searchCondition.msg" />">  - <li> - <input class="s_input" name="searchKeyword" type="text" size="35" title="<spring:message code="title.search" /> <spring:message code="input.input" />" value='<c:out value="${searchVO.searchKeyword}"/>' maxlength="155" > - <input type="submit" class="s_btn" value="<spring:message code="button.inquire" />" title="<spring:message code="title.inquire" /> <spring:message code="input.button" />" /> - <span class="btn_b"><a href="<c:url value='/sym/ccm/ccc/RegistCcmCmmnClCodeView.do' />" title="<spring:message code="button.create" /> <spring:message code="input.button" />"><spring:message code="button.create" /></a></span> - </li> - </ul> + <select class="select fl" name="searchCondition" title="<spring:message code="title.searchCondition" /> <spring:message code="input.cSelect" />"> + <option selected value='0'><spring:message code="title.all" /></option> + <option value='1' <c:if test="${searchVO.searchCondition == '1'}">selected="selected"</c:if>><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCode" /></option> + <option value='2' <c:if test="${searchVO.searchCondition == '2'}">selected="selected"</c:if>><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeNm" /></option> + </select> + <input class="inputText" name="searchKeyword" type="text" size="35" title="<spring:message code="title.search" /> <spring:message code="input.input" />" value='<c:out value="${searchVO.searchKeyword}"/>' maxlength="155" placeholder="그룹명을 입력하세요"> + <button type="button" class="btn_board" style="margin-left:3px;" onclick="fn_egov_search_code(); return false;"><spring:message code="button.inquire" /></button> + </div> </div>  - <table class="board_list" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> - <caption>${pageTitle}<spring:message code="title.list" /></caption> - <colgroup> - <col style="width: 9%;"> - <col style="width: 13%;"> - <col style="width: 40%;"> - <col style="width: 13%;"> - </colgroup> - <thead> - <tr> - <th><spring:message code="table.num" /></th> - <th><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCode" /></th> - <th class="board_th_link"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeNm" /></th> - <th><spring:message code="comSymCcmCcc.cmmnClCodeVO.useAt" /></th> - </tr> - </thead> - <tbody class="ov"> - <c:if test="${fn:length(resultList) == 0}"> - <tr> - <td colspan="4"><spring:message code="common.nodata.msg" /></td> - </tr> - </c:if> - <c:forEach items="${resultList}" var="resultInfo" varStatus="status"> - <tr> - <td><c:out value="${(searchVO.pageIndex-1) * searchVO.pageSize + status.count}"/></td> - <td><c:out value='${resultInfo.clCode}'/></td> - <td><a href="<c:url value='/sym/ccm/ccc/SelectCcmCmmnClCodeDetail.do'/>?clCode=${resultInfo.clCode}" onClick="fn_egov_inquire_codedetail('<c:out value="${resultInfo.clCode}"/>');return false;"><c:out value='${fn:substring(resultInfo.clCodeNm, 0, 40)}'/></a></td> - <td><c:out value='${resultInfo.useAt}'/></td> - </tr> - </c:forEach> - </tbody> - </table> + <div class="board_body"> + <div class="fl board_infomation"> + <p>총 : <span>${paginationInfo.totalRecordCount}</span>건, 쪽번호 : <span>${paginationInfo.currentPageNo }</span> / <span>${paginationInfo.totalPageCount }</span></p> + </div> + <table class="table_list" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> + <caption>${pageTitle}<spring:message code="title.list" /></caption> + <colgroup> + <col style="width: 9%;"> + <col style="width: 13%;"> + <col style="width: 40%;"> + <col style="width: 13%;"> + </colgroup> + <thead> + <tr> + <th><spring:message code="table.num" /></th> + <th><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCode" /></th> + <th class="board_th_link"><spring:message code="comSymCcmCcc.cmmnClCodeVO.clCodeNm" /></th> + <th><spring:message code="comSymCcmCcc.cmmnClCodeVO.useAt" /></th> + </tr> + </thead> + <tbody class="ov"> + <c:if test="${fn:length(resultList) == 0}"> + <tr> + <td colspan="4"><spring:message code="common.nodata.msg" /></td> + </tr> + </c:if> + <c:forEach items="${resultList}" var="resultInfo" varStatus="status"> + <tr> + <td><c:out value="${(searchVO.pageIndex-1) * searchVO.pageSize + status.count}"/></td> + <td><c:out value='${resultInfo.clCode}'/></td> + <td><a href="<c:url value='/sym/ccm/ccc/SelectCcmCmmnClCodeDetail.do'/>?clCode=${resultInfo.clCode}" onClick="fn_egov_inquire_codedetail('<c:out value="${resultInfo.clCode}"/>');return false;"><c:out value='${fn:substring(resultInfo.clCodeNm, 0, 40)}'/></a></td> + <td><c:out value='${resultInfo.useAt}'/></td> + </tr> + </c:forEach> + </tbody> + </table> + </div>  - <div class="pagination"> - <ul> - <ui:pagination paginationInfo="${paginationInfo}" type="image" jsFunction="fn_egov_select_linkPage"/> - </ul> + <div class="board_footer"> +  + <div class="page" role="group" aria-label="..."> + <ul> + <ui:pagination paginationInfo="${paginationInfo}" type="admin" jsFunction="linkPage" /> + </ul> + </div> + <div class="bottom_wrap fr"> + <button type="button" class="btn_s" onclick="fn_egov_regist_code(); return false;" title="<spring:message code="button.create" /> <spring:message code="input.button" />"><spring:message code="button.create" /></button> + </div> </div> - -</div> -<input name="clCode" type="hidden" value=""> -<input name="pageIndex" type="hidden" value="<c:out value='${searchVO.pageIndex}'/>"> + <input name="clCode" type="hidden" value=""> + <input name="pageIndex" type="hidden" value="<c:out value='${searchVO.pageIndex}'/>"> </form> - -</body> -</html> \ No newline at end of file Index: base3.10/script/postgres.erm =================================================================== --- base3.10/script/postgres.erm (revision 12) +++ base3.10/script/postgres.erm (revision 13) @@ -11,8 +11,8 @@ </page_setting> <category_index>0</category_index> <zoom>1.0</zoom> - <x>1826</x> - <y>902</y> + <x>1500</x> + <y>1384</y> <default_color> <r>255</r> <g>128</g> @@ -112,7 +112,7 @@ <show_referred_tables>false</show_referred_tables> <categories> <category> - <id>43</id> + <id>41</id> <height>167</height> <width>601</width> <font_name>맑은 고딕</font_name> @@ -128,11 +128,11 @@ </connections> <name>기타</name> <selected>true</selected> - <node_element>17</node_element> - <node_element>21</node_element> + <node_element>16</node_element> + <node_element>20</node_element> </category> <category> - <id>44</id> + <id>42</id> <height>400</height> <width>941</width> <font_name>맑은 고딕</font_name> @@ -148,12 +148,12 @@ </connections> <name>공통코드</name> <selected>true</selected> - <node_element>22</node_element> + <node_element>21</node_element> + <node_element>17</node_element> <node_element>18</node_element> - <node_element>19</node_element> </category> <category> - <id>45</id> + <id>43</id> <height>864</height> <width>1568</width> <font_name>맑은 고딕</font_name> @@ -169,20 +169,20 @@ </connections> <name>권한&메뉴</name> <selected>true</selected> - <node_element>27</node_element> - <node_element>16</node_element> + <node_element>26</node_element> + <node_element>15</node_element> <node_element>4</node_element> - <node_element>28</node_element> + <node_element>27</node_element> <node_element>7</node_element> - <node_element>14</node_element> - <node_element>6</node_element> - <node_element>26</node_element> <node_element>13</node_element> + <node_element>6</node_element> + <node_element>25</node_element> + <node_element>12</node_element> <node_element>3</node_element> - <node_element>39</node_element> + <node_element>37</node_element> </category> <category> - <id>46</id> + <id>44</id> <height>1185</height> <width>1592</width> <font_name>맑은 고딕</font_name> @@ -199,16 +199,16 @@ <name>사용자</name> <selected>true</selected> <node_element>0</node_element> - <node_element>15</node_element> - <node_element>23</node_element> - <node_element>29</node_element> + <node_element>14</node_element> + <node_element>22</node_element> + <node_element>28</node_element> <node_element>9</node_element> <node_element>5</node_element> <node_element>10</node_element> - <node_element>25</node_element> + <node_element>24</node_element> </category> <category> - <id>47</id> + <id>45</id> <height>440</height> <width>1404</width> <font_name>맑은 고딕</font_name> @@ -225,20 +225,20 @@ <name>로그</name> <selected>true</selected> <node_element>1</node_element> - <node_element>24</node_element> - <node_element>20</node_element> - <node_element>30</node_element> + <node_element>23</node_element> + <node_element>19</node_element> + <node_element>29</node_element> <node_element>2</node_element> - <node_element>33</node_element> + <node_element>32</node_element> </category> <category> - <id>48</id> + <id>46</id> <height>1041</height> <width>1020</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1857</x> - <y>755</y> + <x>1836</x> + <y>781</y> <color> <r>255</r> <g>128</g> @@ -248,14 +248,13 @@ </connections> <name>게시판</name> <selected>true</selected> - <node_element>42</node_element> + <node_element>39</node_element> + <node_element>40</node_element> + <node_element>30</node_element> + <node_element>34</node_element> + <node_element>8</node_element> <node_element>11</node_element> <node_element>31</node_element> - <node_element>36</node_element> - <node_element>8</node_element> - <node_element>12</node_element> - <node_element>32</node_element> - <node_element>35</node_element> </category> </categories> </category_settings> @@ -281,7 +280,7 @@ </connections> <display>false</display> <creation_date>2022-01-26 16:20:32</creation_date> - <updated_date>2022-02-08 15:47:10</updated_date> + <updated_date>2022-02-08 16:49:02</updated_date> <model_property> <name>프로젝트명</name> <value></value> @@ -1453,38 +1452,6 @@ </word> <word> <id>71</id> - <length>10</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>오류수</description> - <logical_name>오류수</logical_name> - <physical_name>error_co</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>72</id> - <length>3</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>오류코드</description> - <logical_name>오류코드</logical_name> - <physical_name>error_code</physical_name> - <type>character(n)</type> - </word> - <word> - <id>73</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -1500,7 +1467,7 @@ <type>character(n)</type> </word> <word> - <id>74</id> + <id>72</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1516,23 +1483,7 @@ <type>char</type> </word> <word> - <id>75</id> - <length>null</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>오류구분</description> - <logical_name>오류구분</logical_name> - <physical_name>error_se</physical_name> - <type>char</type> - </word> - <word> - <id>76</id> + <id>73</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1548,7 +1499,7 @@ <type>char</type> </word> <word> - <id>77</id> + <id>74</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1564,7 +1515,7 @@ <type>character(n)</type> </word> <word> - <id>78</id> + <id>75</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1580,7 +1531,7 @@ <type>character(n)</type> </word> <word> - <id>79</id> + <id>76</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1596,7 +1547,7 @@ <type>char</type> </word> <word> - <id>80</id> + <id>77</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1612,7 +1563,7 @@ <type>text</type> </word> <word> - <id>81</id> + <id>78</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1628,7 +1579,7 @@ <type>varchar(n)</type> </word> <word> - <id>82</id> + <id>79</id> <length>32</length> <decimal>null</decimal> <array>false</array> @@ -1644,7 +1595,7 @@ <type>varchar(n)</type> </word> <word> - <id>83</id> + <id>80</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1660,7 +1611,7 @@ <type>varchar(n)</type> </word> <word> - <id>84</id> + <id>81</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -1676,7 +1627,7 @@ <type>numeric(p)</type> </word> <word> - <id>85</id> + <id>82</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -1692,7 +1643,7 @@ <type>numeric(p)</type> </word> <word> - <id>86</id> + <id>83</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1708,7 +1659,7 @@ <type>numeric(p)</type> </word> <word> - <id>87</id> + <id>84</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -1724,7 +1675,7 @@ <type>varchar(n)</type> </word> <word> - <id>88</id> + <id>85</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1740,7 +1691,7 @@ <type>varchar(n)</type> </word> <word> - <id>89</id> + <id>86</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1756,7 +1707,7 @@ <type>varchar(n)</type> </word> <word> - <id>90</id> + <id>87</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1772,7 +1723,7 @@ <type>timestamp</type> </word> <word> - <id>91</id> + <id>88</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1788,7 +1739,7 @@ <type>timestamp</type> </word> <word> - <id>92</id> + <id>89</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1804,7 +1755,7 @@ <type>text</type> </word> <word> - <id>93</id> + <id>90</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1820,7 +1771,7 @@ <type>varchar(n)</type> </word> <word> - <id>94</id> + <id>91</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1836,7 +1787,7 @@ <type>timestamp</type> </word> <word> - <id>95</id> + <id>92</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1852,7 +1803,7 @@ <type>varchar(n)</type> </word> <word> - <id>96</id> + <id>93</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1868,7 +1819,7 @@ <type></type> </word> <word> - <id>97</id> + <id>94</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1884,7 +1835,7 @@ <type>character(n)</type> </word> <word> - <id>98</id> + <id>95</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -1900,7 +1851,7 @@ <type>varchar(n)</type> </word> <word> - <id>99</id> + <id>96</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1916,7 +1867,7 @@ <type>varchar(n)</type> </word> <word> - <id>100</id> + <id>97</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1932,7 +1883,7 @@ <type>varchar(n)</type> </word> <word> - <id>101</id> + <id>98</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1948,7 +1899,7 @@ <type>varchar(n)</type> </word> <word> - <id>102</id> + <id>99</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -1964,7 +1915,7 @@ <type>numeric(p)</type> </word> <word> - <id>103</id> + <id>100</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1980,7 +1931,7 @@ <type>varchar(n)</type> </word> <word> - <id>104</id> + <id>101</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -1996,7 +1947,7 @@ <type>varchar(n)</type> </word> <word> - <id>105</id> + <id>102</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2012,23 +1963,7 @@ <type>char</type> </word> <word> - <id>106</id> - <length>7</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>기관코드</description> - <logical_name>기관코드</logical_name> - <physical_name>instt_code</physical_name> - <type>character(n)</type> - </word> - <word> - <id>107</id> + <id>103</id> <length>7</length> <decimal>null</decimal> <array>false</array> @@ -2044,7 +1979,7 @@ <type>character(n)</type> </word> <word> - <id>108</id> + <id>104</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -2060,23 +1995,7 @@ <type>varchar(n)</type> </word> <word> - <id>109</id> - <length>3</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>업무구분코드</description> - <logical_name>업무구분코드</logical_name> - <physical_name>job_se_code</physical_name> - <type>character(n)</type> - </word> - <word> - <id>110</id> + <id>105</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2092,7 +2011,7 @@ <type>character(n)</type> </word> <word> - <id>111</id> + <id>106</id> <length>13</length> <decimal>null</decimal> <array>false</array> @@ -2108,7 +2027,7 @@ <type>varchar(n)</type> </word> <word> - <id>112</id> + <id>107</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2124,7 +2043,7 @@ <type>timestamp</type> </word> <word> - <id>113</id> + <id>108</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2140,7 +2059,7 @@ <type>timestamp</type> </word> <word> - <id>114</id> + <id>109</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2156,7 +2075,7 @@ <type>varchar(n)</type> </word> <word> - <id>115</id> + <id>110</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2172,7 +2091,7 @@ <type>varchar(n)</type> </word> <word> - <id>116</id> + <id>111</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2188,7 +2107,7 @@ <type>text</type> </word> <word> - <id>117</id> + <id>112</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2204,7 +2123,7 @@ <type>char</type> </word> <word> - <id>118</id> + <id>113</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2220,7 +2139,7 @@ <type>char</type> </word> <word> - <id>119</id> + <id>114</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2236,7 +2155,7 @@ <type>numeric(p)</type> </word> <word> - <id>120</id> + <id>115</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2252,7 +2171,7 @@ <type>timestamp</type> </word> <word> - <id>121</id> + <id>116</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2268,7 +2187,7 @@ <type>character(n)</type> </word> <word> - <id>122</id> + <id>117</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -2284,7 +2203,7 @@ <type>varchar(n)</type> </word> <word> - <id>123</id> + <id>118</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2300,7 +2219,7 @@ <type>varchar(n)</type> </word> <word> - <id>124</id> + <id>119</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2316,7 +2235,7 @@ <type>varchar(n)</type> </word> <word> - <id>125</id> + <id>120</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2332,7 +2251,7 @@ <type>varchar(n)</type> </word> <word> - <id>126</id> + <id>121</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2348,7 +2267,7 @@ <type>varchar(n)</type> </word> <word> - <id>127</id> + <id>122</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2364,7 +2283,7 @@ <type>varchar(n)</type> </word> <word> - <id>128</id> + <id>123</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2380,7 +2299,7 @@ <type>varchar(n)</type> </word> <word> - <id>129</id> + <id>124</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -2396,7 +2315,7 @@ <type>varchar(n)</type> </word> <word> - <id>130</id> + <id>125</id> <length>5</length> <decimal>null</decimal> <array>false</array> @@ -2412,7 +2331,7 @@ <type>character(n)</type> </word> <word> - <id>131</id> + <id>126</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2428,7 +2347,7 @@ <type>varchar(n)</type> </word> <word> - <id>132</id> + <id>127</id> <length>250</length> <decimal>null</decimal> <array>false</array> @@ -2444,7 +2363,7 @@ <type>varchar(n)</type> </word> <word> - <id>133</id> + <id>128</id> <length>250</length> <decimal>null</decimal> <array>false</array> @@ -2460,7 +2379,7 @@ <type>varchar(n)</type> </word> <word> - <id>134</id> + <id>129</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -2476,7 +2395,7 @@ <type>varchar(n)</type> </word> <word> - <id>135</id> + <id>130</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2492,7 +2411,7 @@ <type>numeric(p)</type> </word> <word> - <id>136</id> + <id>131</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2508,7 +2427,7 @@ <type>varchar(n)</type> </word> <word> - <id>137</id> + <id>132</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2524,7 +2443,7 @@ <type>varchar(n)</type> </word> <word> - <id>138</id> + <id>133</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2540,7 +2459,7 @@ <type>numeric(p)</type> </word> <word> - <id>139</id> + <id>134</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2556,7 +2475,7 @@ <type>varchar(n)</type> </word> <word> - <id>140</id> + <id>135</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2572,7 +2491,7 @@ <type>integer</type> </word> <word> - <id>141</id> + <id>136</id> <length>5</length> <decimal>null</decimal> <array>false</array> @@ -2588,23 +2507,7 @@ <type>numeric(p)</type> </word> <word> - <id>142</id> - <length>60</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>메서드명</description> - <logical_name>메서드명</logical_name> - <physical_name>method_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>143</id> + <id>137</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2620,7 +2523,7 @@ <type>varchar(n)</type> </word> <word> - <id>144</id> + <id>138</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2636,7 +2539,7 @@ <type>varchar(n)</type> </word> <word> - <id>145</id> + <id>139</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -2652,7 +2555,7 @@ <type>varchar(n)</type> </word> <word> - <id>146</id> + <id>140</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2668,7 +2571,7 @@ <type>text</type> </word> <word> - <id>147</id> + <id>141</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -2684,7 +2587,7 @@ <type>numeric(p)</type> </word> <word> - <id>148</id> + <id>142</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2700,7 +2603,7 @@ <type>char</type> </word> <word> - <id>149</id> + <id>143</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2716,7 +2619,7 @@ <type>character(n)</type> </word> <word> - <id>150</id> + <id>144</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2732,7 +2635,7 @@ <type>character(n)</type> </word> <word> - <id>151</id> + <id>145</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2748,7 +2651,7 @@ <type>varchar(n)</type> </word> <word> - <id>152</id> + <id>146</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2764,7 +2667,7 @@ <type>varchar(n)</type> </word> <word> - <id>153</id> + <id>147</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2780,7 +2683,7 @@ <type>text</type> </word> <word> - <id>154</id> + <id>148</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2796,7 +2699,7 @@ <type>numeric(p)</type> </word> <word> - <id>155</id> + <id>149</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2812,7 +2715,7 @@ <type>numeric(p)</type> </word> <word> - <id>156</id> + <id>150</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -2828,7 +2731,7 @@ <type>varchar(n)</type> </word> <word> - <id>157</id> + <id>151</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2844,7 +2747,7 @@ <type>character(n)</type> </word> <word> - <id>158</id> + <id>152</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2860,23 +2763,7 @@ <type>character(n)</type> </word> <word> - <id>159</id> - <length>null</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>발생일</description> - <logical_name>발생일</logical_name> - <physical_name>occrrnc_de</physical_name> - <type>timestamp</type> - </word> - <word> - <id>160</id> + <id>153</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2892,7 +2779,7 @@ <type>timestamp</type> </word> <word> - <id>161</id> + <id>154</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2908,7 +2795,7 @@ <type>varchar(n)</type> </word> <word> - <id>162</id> + <id>155</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2924,7 +2811,7 @@ <type>varchar(n)</type> </word> <word> - <id>163</id> + <id>156</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2940,7 +2827,7 @@ <type>varchar(n)</type> </word> <word> - <id>164</id> + <id>157</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2956,7 +2843,7 @@ <type>varchar(n)</type> </word> <word> - <id>165</id> + <id>158</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2972,7 +2859,7 @@ <type></type> </word> <word> - <id>166</id> + <id>159</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2988,7 +2875,7 @@ <type>character(n)</type> </word> <word> - <id>167</id> + <id>160</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3004,7 +2891,7 @@ <type>varchar(n)</type> </word> <word> - <id>168</id> + <id>161</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3020,7 +2907,7 @@ <type>text</type> </word> <word> - <id>169</id> + <id>162</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3036,7 +2923,7 @@ <type>varchar(n)</type> </word> <word> - <id>170</id> + <id>163</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3052,7 +2939,7 @@ <type>numeric(p)</type> </word> <word> - <id>171</id> + <id>164</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3068,7 +2955,7 @@ <type>numeric(p)</type> </word> <word> - <id>172</id> + <id>165</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3084,7 +2971,7 @@ <type>numeric(p)</type> </word> <word> - <id>173</id> + <id>166</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3100,7 +2987,7 @@ <type>varchar(n)</type> </word> <word> - <id>174</id> + <id>167</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3116,7 +3003,7 @@ <type>varchar(n)</type> </word> <word> - <id>175</id> + <id>168</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3132,7 +3019,7 @@ <type>varchar(n)</type> </word> <word> - <id>176</id> + <id>169</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3148,23 +3035,7 @@ <type>varchar(n)</type> </word> <word> - <id>177</id> - <length>10</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>처리수</description> - <logical_name>처리수</logical_name> - <physical_name>process_co</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>178</id> + <id>170</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3180,7 +3051,7 @@ <type>numeric(p)</type> </word> <word> - <id>179</id> + <id>171</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3196,23 +3067,7 @@ <type>character(n)</type> </word> <word> - <id>180</id> - <length>3</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>처리구분코드</description> - <logical_name>처리구분코드</logical_name> - <physical_name>process_se_code</physical_name> - <type>character(n)</type> - </word> - <word> - <id>181</id> + <id>172</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -3228,7 +3083,7 @@ <type>character(n)</type> </word> <word> - <id>182</id> + <id>173</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -3244,23 +3099,7 @@ <type>varchar(n)</type> </word> <word> - <id>183</id> - <length>14</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>처리시간</description> - <logical_name>처리시간</logical_name> - <physical_name>process_time</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>184</id> + <id>174</id> <length>14</length> <decimal>null</decimal> <array>false</array> @@ -3276,7 +3115,7 @@ <type>varchar(n)</type> </word> <word> - <id>185</id> + <id>175</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3292,7 +3131,7 @@ <type>varchar(n)</type> </word> <word> - <id>186</id> + <id>176</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3308,7 +3147,7 @@ <type>varchar(n)</type> </word> <word> - <id>187</id> + <id>177</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3324,7 +3163,7 @@ <type>varchar(n)</type> </word> <word> - <id>188</id> + <id>178</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3340,7 +3179,7 @@ <type>varchar(n)</type> </word> <word> - <id>189</id> + <id>179</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -3356,7 +3195,7 @@ <type>varchar(n)</type> </word> <word> - <id>190</id> + <id>180</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3372,7 +3211,7 @@ <type>varchar(n)</type> </word> <word> - <id>191</id> + <id>181</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3388,7 +3227,7 @@ <type>varchar(n)</type> </word> <word> - <id>192</id> + <id>182</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3404,7 +3243,7 @@ <type>character(n)</type> </word> <word> - <id>193</id> + <id>183</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3420,7 +3259,7 @@ <type>numeric(p)</type> </word> <word> - <id>194</id> + <id>184</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3436,7 +3275,7 @@ <type>numeric(p)</type> </word> <word> - <id>195</id> + <id>185</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3452,7 +3291,7 @@ <type>varchar(n)</type> </word> <word> - <id>196</id> + <id>186</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3468,7 +3307,7 @@ <type>timestamp</type> </word> <word> - <id>197</id> + <id>187</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3484,7 +3323,7 @@ <type>character(n)</type> </word> <word> - <id>198</id> + <id>188</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3500,7 +3339,7 @@ <type>varchar(n)</type> </word> <word> - <id>199</id> + <id>189</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3516,7 +3355,7 @@ <type>varchar(n)</type> </word> <word> - <id>200</id> + <id>190</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3532,7 +3371,7 @@ <type>varchar(n)</type> </word> <word> - <id>201</id> + <id>191</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3548,23 +3387,7 @@ <type>char</type> </word> <word> - <id>202</id> - <length>20</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>요청ID</description> - <logical_name>요청ID</logical_name> - <physical_name>requst_id</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>203</id> + <id>192</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3580,7 +3403,7 @@ <type>varchar(n)</type> </word> <word> - <id>204</id> + <id>193</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3596,7 +3419,7 @@ <type>numeric(p)</type> </word> <word> - <id>205</id> + <id>194</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3612,7 +3435,7 @@ <type>text</type> </word> <word> - <id>206</id> + <id>195</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3628,7 +3451,7 @@ <type>varchar(n)</type> </word> <word> - <id>207</id> + <id>196</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3644,7 +3467,7 @@ <type>varchar(n)</type> </word> <word> - <id>208</id> + <id>197</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3660,7 +3483,7 @@ <type>timestamp</type> </word> <word> - <id>209</id> + <id>198</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3676,7 +3499,7 @@ <type>varchar(n)</type> </word> <word> - <id>210</id> + <id>199</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3692,7 +3515,7 @@ <type>varchar(n)</type> </word> <word> - <id>211</id> + <id>200</id> <length>300</length> <decimal>null</decimal> <array>false</array> @@ -3708,7 +3531,7 @@ <type>varchar(n)</type> </word> <word> - <id>212</id> + <id>201</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3724,7 +3547,7 @@ <type>varchar(n)</type> </word> <word> - <id>213</id> + <id>202</id> <length>80</length> <decimal>null</decimal> <array>false</array> @@ -3740,7 +3563,7 @@ <type>varchar(n)</type> </word> <word> - <id>214</id> + <id>203</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3756,7 +3579,7 @@ <type>character(n)</type> </word> <word> - <id>215</id> + <id>204</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3772,7 +3595,7 @@ <type>varchar(n)</type> </word> <word> - <id>216</id> + <id>205</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3788,8 +3611,8 @@ <type>varchar(n)</type> </word> <word> - <id>217</id> - <length>20</length> + <id>206</id> + <length>23</length> <decimal>null</decimal> <array>false</array> <array_dimension>null</array_dimension> @@ -3798,62 +3621,14 @@ <binary>false</binary> <args></args> <char_semantics>true</char_semantics> - <description>요청자ID</description> - <logical_name>요청자ID</logical_name> - <physical_name>rqester_id</physical_name> + <description>요청자IP</description> + <logical_name>요청자IP</logical_name> + <physical_name>rqester_ip</physical_name> <type>varchar(n)</type> </word> <word> - <id>218</id> - <length>23</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>요청자IP</description> - <logical_name>요청자IP</logical_name> - <physical_name>rqester_ip</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>219</id> - <length>23</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>요청자IP</description> - <logical_name>요청자IP</logical_name> - <physical_name>rqester_ip</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>220</id> - <length>3</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>응답코드</description> - <logical_name>응답코드</logical_name> - <physical_name>rspns_code</physical_name> - <type>character(n)</type> - </word> - <word> - <id>221</id> - <length>3</length> + <id>207</id> + <length>3</length> <decimal>null</decimal> <array>false</array> <array_dimension>null</array_dimension> @@ -3868,7 +3643,7 @@ <type>character(n)</type> </word> <word> - <id>222</id> + <id>208</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3884,7 +3659,7 @@ <type>timestamp</type> </word> <word> - <id>223</id> + <id>209</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3900,7 +3675,7 @@ <type>varchar(n)</type> </word> <word> - <id>224</id> + <id>210</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3916,7 +3691,7 @@ <type>char</type> </word> <word> - <id>225</id> + <id>211</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3932,7 +3707,7 @@ <type>char</type> </word> <word> - <id>226</id> + <id>212</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3948,7 +3723,7 @@ <type>char</type> </word> <word> - <id>227</id> + <id>213</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3964,7 +3739,7 @@ <type>text</type> </word> <word> - <id>228</id> + <id>214</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3980,7 +3755,7 @@ <type>numeric(p)</type> </word> <word> - <id>229</id> + <id>215</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3996,7 +3771,7 @@ <type>varchar(n)</type> </word> <word> - <id>230</id> + <id>216</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4012,23 +3787,7 @@ <type>char</type> </word> <word> - <id>231</id> - <length>255</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>서비스명</description> - <logical_name>서비스명</logical_name> - <physical_name>svc_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>232</id> + <id>217</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -4044,7 +3803,7 @@ <type>varchar(n)</type> </word> <word> - <id>233</id> + <id>218</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -4060,7 +3819,7 @@ <type>varchar(n)</type> </word> <word> - <id>234</id> + <id>219</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4076,7 +3835,7 @@ <type>text</type> </word> <word> - <id>235</id> + <id>220</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4092,7 +3851,7 @@ <type>varchar(n)</type> </word> <word> - <id>236</id> + <id>221</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4108,23 +3867,7 @@ <type>character(n)</type> </word> <word> - <id>237</id> - <length>255</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>대상메뉴명</description> - <logical_name>대상메뉴명</logical_name> - <physical_name>trget_menu_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>238</id> + <id>222</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -4140,7 +3883,7 @@ <type>varchar(n)</type> </word> <word> - <id>239</id> + <id>223</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -4156,7 +3899,7 @@ <type>numeric(p)</type> </word> <word> - <id>240</id> + <id>224</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -4172,7 +3915,7 @@ <type>numeric(p)</type> </word> <word> - <id>241</id> + <id>225</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4188,7 +3931,7 @@ <type>timestamp</type> </word> <word> - <id>242</id> + <id>226</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4204,7 +3947,7 @@ <type>varchar(n)</type> </word> <word> - <id>243</id> + <id>227</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4220,7 +3963,7 @@ <type>text</type> </word> <word> - <id>244</id> + <id>228</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -4236,7 +3979,7 @@ <type>varchar(n)</type> </word> <word> - <id>245</id> + <id>229</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -4252,7 +3995,7 @@ <type>varchar(n)</type> </word> <word> - <id>246</id> + <id>230</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -4268,7 +4011,7 @@ <type>varchar(n)</type> </word> <word> - <id>247</id> + <id>231</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -4284,7 +4027,7 @@ <type>varchar(n)</type> </word> <word> - <id>248</id> + <id>232</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4300,7 +4043,7 @@ <type>varchar(n)</type> </word> <word> - <id>249</id> + <id>233</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4316,7 +4059,7 @@ <type>varchar(n)</type> </word> <word> - <id>250</id> + <id>234</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -4332,7 +4075,7 @@ <type>varchar(n)</type> </word> <word> - <id>251</id> + <id>235</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -4348,7 +4091,7 @@ <type>varchar(n)</type> </word> <word> - <id>252</id> + <id>236</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4364,7 +4107,7 @@ <type></type> </word> <word> - <id>253</id> + <id>237</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -4380,7 +4123,7 @@ <type>varchar(n)</type> </word> <word> - <id>254</id> + <id>238</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4396,7 +4139,7 @@ <type>char</type> </word> <word> - <id>255</id> + <id>239</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -4412,7 +4155,7 @@ <type>varchar(n)</type> </word> <word> - <id>256</id> + <id>240</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4428,7 +4171,7 @@ <type>varchar(n)</type> </word> <word> - <id>257</id> + <id>241</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4444,7 +4187,7 @@ <type>varchar(n)</type> </word> <word> - <id>258</id> + <id>242</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -4484,7 +4227,7 @@ <sql>SELECT comtngnrlmber.esntl_id,
 comtngnrlmber.mber_id AS user_id,
 comtngnrlmber.password,
 comtngnrlmber.mber_nm AS user_nm,
 comtngnrlmber.zip AS user_zip,
 comtngnrlmber.adres AS user_adres,
 comtngnrlmber.mber_email_adres AS user_email,
 ' '::bpchar AS group_id,
 'GNR'::text AS user_se,
 ' '::bpchar AS orgnzt_id
 FROM comtngnrlmber
UNION ALL
 SELECT comtnemplyrinfo.esntl_id,
 comtnemplyrinfo.emplyr_id AS user_id,
 comtnemplyrinfo.password,
 comtnemplyrinfo.user_nm,
 comtnemplyrinfo.zip AS user_zip,
 comtnemplyrinfo.house_adres AS user_adres,
 comtnemplyrinfo.email_adres AS user_email,
 comtnemplyrinfo.group_id,
 'USR'::text AS user_se,
 comtnemplyrinfo.orgnzt_id
 FROM comtnemplyrinfo
UNION ALL
 SELECT comtnentrprsmber.esntl_id,
 comtnentrprsmber.entrprs_mber_id AS user_id,
 comtnentrprsmber.entrprs_mber_password AS password,
 comtnentrprsmber.cmpny_nm AS user_nm,
 comtnentrprsmber.zip AS user_zip,
 comtnentrprsmber.adres AS user_adres,
 comtnentrprsmber.applcnt_email_adres AS user_email,
 ' '::bpchar AS group_id,
 'ENT'::text AS user_se,
 ' '::bpchar AS orgnzt_id
 FROM comtnentrprsmber
 ORDER BY 1;</sql> <columns> <normal_column> - <word_id>78</word_id> + <word_id>75</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4517,7 +4260,7 @@ </sequence> </normal_column> <normal_column> - <word_id>249</word_id> + <word_id>233</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4550,7 +4293,7 @@ </sequence> </normal_column> <normal_column> - <word_id>174</word_id> + <word_id>167</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4583,7 +4326,7 @@ </sequence> </normal_column> <normal_column> - <word_id>251</word_id> + <word_id>235</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4616,7 +4359,7 @@ </sequence> </normal_column> <normal_column> - <word_id>253</word_id> + <word_id>237</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4649,7 +4392,7 @@ </sequence> </normal_column> <normal_column> - <word_id>246</word_id> + <word_id>230</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4682,7 +4425,7 @@ </sequence> </normal_column> <normal_column> - <word_id>247</word_id> + <word_id>231</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4715,7 +4458,7 @@ </sequence> </normal_column> <normal_column> - <word_id>96</word_id> + <word_id>93</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4748,7 +4491,7 @@ </sequence> </normal_column> <normal_column> - <word_id>252</word_id> + <word_id>236</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4781,7 +4524,7 @@ </sequence> </normal_column> <normal_column> - <word_id>165</word_id> + <word_id>158</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4841,7 +4584,7 @@ <option></option> <columns> <normal_column> - <word_id>158</word_id> + <word_id>152</word_id> <id>0</id> <description></description> <unique_key_name></unique_key_name> @@ -4874,7 +4617,7 @@ </sequence> </normal_column> <normal_column> - <word_id>245</word_id> + <word_id>229</word_id> <id>1</id> <description></description> <unique_key_name></unique_key_name> @@ -4907,7 +4650,7 @@ </sequence> </normal_column> <normal_column> - <word_id>193</word_id> + <word_id>183</word_id> <id>2</id> <description></description> <unique_key_name></unique_key_name> @@ -4972,7 +4715,7 @@ <option></option> <columns> <normal_column> - <word_id>158</word_id> + <word_id>152</word_id> <id>3</id> <description></description> <unique_key_name></unique_key_name> @@ -5005,7 +4748,7 @@ </sequence> </normal_column> <normal_column> - <word_id>232</word_id> + <word_id>217</word_id> <id>4</id> <description></description> <unique_key_name></unique_key_name> @@ -5038,7 +4781,7 @@ </sequence> </normal_column> <normal_column> - <word_id>142</word_id> + <word_id>137</word_id> <id>5</id> <description></description> <unique_key_name></unique_key_name> @@ -5104,7 +4847,7 @@ </sequence> </normal_column> <normal_column> - <word_id>239</word_id> + <word_id>223</word_id> <id>7</id> <description></description> <unique_key_name></unique_key_name> @@ -5137,7 +4880,7 @@ </sequence> </normal_column> <normal_column> - <word_id>193</word_id> + <word_id>183</word_id> <id>8</id> <description></description> <unique_key_name></unique_key_name> @@ -5203,7 +4946,7 @@ </sequence> </normal_column> <normal_column> - <word_id>170</word_id> + <word_id>163</word_id> <id>10</id> <description></description> <unique_key_name></unique_key_name> @@ -5294,7 +5037,7 @@ <connections> <relation> <id>0</id> - <source>14</source> + <source>13</source> <target>3</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -5316,7 +5059,7 @@ </relation> <relation> <id>1</id> - <source>14</source> + <source>13</source> <target>3</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -5346,7 +5089,7 @@ <columns> <normal_column> <id>12</id> - <referenced_column>118</referenced_column> + <referenced_column>110</referenced_column> <relation>0</relation> <description>부모롤</description> <unique_key_name></unique_key_name> @@ -5380,7 +5123,7 @@ </normal_column> <normal_column> <id>13</id> - <referenced_column>118</referenced_column> + <referenced_column>110</referenced_column> <relation>1</relation> <description>자식롤</description> <unique_key_name></unique_key_name> @@ -5458,7 +5201,7 @@ <option></option> <columns> <normal_column> - <word_id>186</word_id> + <word_id>176</word_id> <id>14</id> <description></description> <unique_key_name></unique_key_name> @@ -5491,7 +5234,7 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> + <word_id>178</word_id> <id>15</id> <description></description> <unique_key_name></unique_key_name> @@ -5524,7 +5267,7 @@ </sequence> </normal_column> <normal_column> - <word_id>187</word_id> + <word_id>177</word_id> <id>16</id> <description></description> <unique_key_name></unique_key_name> @@ -5557,7 +5300,7 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> + <word_id>175</word_id> <id>17</id> <description></description> <unique_key_name></unique_key_name> @@ -5590,7 +5333,7 @@ </sequence> </normal_column> <normal_column> - <word_id>244</word_id> + <word_id>228</word_id> <id>18</id> <description></description> <unique_key_name></unique_key_name> @@ -5655,7 +5398,7 @@ <option></option> <columns> <normal_column> - <word_id>166</word_id> + <word_id>159</word_id> <id>19</id> <description></description> <unique_key_name></unique_key_name> @@ -5688,7 +5431,7 @@ </sequence> </normal_column> <normal_column> - <word_id>167</word_id> + <word_id>160</word_id> <id>20</id> <description></description> <unique_key_name></unique_key_name> @@ -5721,7 +5464,7 @@ </sequence> </normal_column> <normal_column> - <word_id>164</word_id> + <word_id>157</word_id> <id>21</id> <description></description> <unique_key_name></unique_key_name> @@ -5779,21 +5522,26 @@ <connections> <relation> <id>2</id> - <source>4</source> + <source>6</source> <target>6</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> + <source_xp>100</source_xp> + <source_yp>50</source_yp> + <target_xp>50</target_xp> + <target_yp>100</target_yp> + <bendpoint> + <relative>true</relative> + <x>100</x> + <y>100</y> + </bendpoint> <color> <r>0</r> <g>0</g> <b>0</b> </color> <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> + <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnmenuinfo_progrm_file_nm_fkey</name> + <name>comtnmenuinfo_upper_menu_no_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -5801,26 +5549,21 @@ </relation> <relation> <id>3</id> - <source>6</source> + <source>4</source> <target>6</target> - <source_xp>100</source_xp> - <source_yp>50</source_yp> - <target_xp>50</target_xp> - <target_yp>100</target_yp> - <bendpoint> - <relative>true</relative> - <x>100</x> - <y>100</y> - </bendpoint> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> <color> <r>0</r> <g>0</g> <b>0</b> </color> <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> + <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnmenuinfo_upper_menu_no_fkey</name> + <name>comtnmenuinfo_progrm_file_nm_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -5835,7 +5578,7 @@ <option></option> <columns> <normal_column> - <word_id>137</word_id> + <word_id>132</word_id> <id>22</id> <description></description> <unique_key_name></unique_key_name> @@ -5870,7 +5613,7 @@ <normal_column> <id>23</id> <referenced_column>14</referenced_column> - <relation>2</relation> + <relation>3</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5902,7 +5645,7 @@ </sequence> </normal_column> <normal_column> - <word_id>138</word_id> + <word_id>133</word_id> <id>24</id> <description></description> <unique_key_name></unique_key_name> @@ -5937,7 +5680,7 @@ <normal_column> <id>25</id> <referenced_column>24</referenced_column> - <relation>3</relation> + <relation>2</relation> <description>상위메뉴번호</description> <unique_key_name></unique_key_name> <logical_name>상위메뉴번호</logical_name> @@ -5969,7 +5712,7 @@ </sequence> </normal_column> <normal_column> - <word_id>141</word_id> + <word_id>136</word_id> <id>26</id> <description></description> <unique_key_name></unique_key_name> @@ -6002,7 +5745,7 @@ </sequence> </normal_column> <normal_column> - <word_id>132</word_id> + <word_id>127</word_id> <id>27</id> <description></description> <unique_key_name></unique_key_name> @@ -6035,7 +5778,7 @@ </sequence> </normal_column> <normal_column> - <word_id>200</word_id> + <word_id>190</word_id> <id>28</id> <description></description> <unique_key_name></unique_key_name> @@ -6068,7 +5811,7 @@ </sequence> </normal_column> <normal_column> - <word_id>199</word_id> + <word_id>189</word_id> <id>29</id> <description></description> <unique_key_name></unique_key_name> @@ -6139,7 +5882,7 @@ <connections> <relation> <id>4</id> - <source>28</source> + <source>13</source> <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -6151,17 +5894,17 @@ <b>0</b> </color> <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> + <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnmenucreatdtls_mapng_creat_id_fkey</name> - <on_delete_action>CASCADE</on_delete_action> + <name>comtnmenucreatdtls_author_code_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> <referenced_complex_unique_key>null</referenced_complex_unique_key> </relation> <relation> <id>5</id> - <source>14</source> + <source>6</source> <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -6175,15 +5918,15 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnmenucreatdtls_author_code_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> + <name>comtnmenucreatdtls_menu_no_fkey</name> + <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> <referenced_complex_unique_key>null</referenced_complex_unique_key> </relation> <relation> <id>6</id> - <source>6</source> + <source>27</source> <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -6195,9 +5938,9 @@ <b>0</b> </color> <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> + <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnmenucreatdtls_menu_no_fkey</name> + <name>comtnmenucreatdtls_mapng_creat_id_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -6214,7 +5957,7 @@ <normal_column> <id>30</id> <referenced_column>24</referenced_column> - <relation>6</relation> + <relation>5</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6247,8 +5990,8 @@ </normal_column> <normal_column> <id>31</id> - <referenced_column>118</referenced_column> - <relation>5</relation> + <referenced_column>110</referenced_column> + <relation>4</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6281,8 +6024,8 @@ </normal_column> <normal_column> <id>32</id> - <referenced_column>217</referenced_column> - <relation>4</relation> + <referenced_column>209</referenced_column> + <relation>6</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6368,8 +6111,8 @@ <width>133</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>2564</x> - <y>1567</y> + <x>2543</x> + <y>1593</y> <color> <r>128</r> <g>128</g> @@ -6378,7 +6121,7 @@ <connections> <relation> <id>7</id> - <source>32</source> + <source>31</source> <target>8</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -6408,7 +6151,7 @@ <columns> <normal_column> <id>33</id> - <referenced_column>269</referenced_column> + <referenced_column>261</referenced_column> <relation>7</relation> <description></description> <unique_key_name></unique_key_name> @@ -6441,7 +6184,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>83</word_id> <id>34</id> <description></description> <unique_key_name></unique_key_name> @@ -6474,7 +6217,7 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> + <word_id>84</word_id> <id>35</id> <description></description> <unique_key_name></unique_key_name> @@ -6507,7 +6250,7 @@ </sequence> </normal_column> <normal_column> - <word_id>229</word_id> + <word_id>215</word_id> <id>36</id> <description></description> <unique_key_name></unique_key_name> @@ -6540,7 +6283,7 @@ </sequence> </normal_column> <normal_column> - <word_id>169</word_id> + <word_id>162</word_id> <id>37</id> <description></description> <unique_key_name></unique_key_name> @@ -6573,7 +6316,7 @@ </sequence> </normal_column> <normal_column> - <word_id>81</word_id> + <word_id>78</word_id> <id>38</id> <description></description> <unique_key_name></unique_key_name> @@ -6606,7 +6349,7 @@ </sequence> </normal_column> <normal_column> - <word_id>80</word_id> + <word_id>77</word_id> <id>39</id> <description></description> <unique_key_name></unique_key_name> @@ -6639,7 +6382,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>81</word_id> <id>40</id> <description></description> <unique_key_name></unique_key_name> @@ -6710,7 +6453,7 @@ <connections> <relation> <id>8</id> - <source>15</source> + <source>14</source> <target>9</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -6838,7 +6581,7 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> + <word_id>106</word_id> <id>44</id> <description></description> <unique_key_name></unique_key_name> @@ -6937,7 +6680,7 @@ </sequence> </normal_column> <normal_column> - <word_id>258</word_id> + <word_id>242</word_id> <id>47</id> <description></description> <unique_key_name></unique_key_name> @@ -7036,7 +6779,7 @@ </sequence> </normal_column> <normal_column> - <word_id>93</word_id> + <word_id>90</word_id> <id>50</id> <description></description> <unique_key_name></unique_key_name> @@ -7069,7 +6812,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>102</word_id> <id>51</id> <description></description> <unique_key_name></unique_key_name> @@ -7168,7 +6911,7 @@ </sequence> </normal_column> <normal_column> - <word_id>222</word_id> + <word_id>208</word_id> <id>54</id> <description></description> <unique_key_name></unique_key_name> @@ -7334,7 +7077,7 @@ </normal_column> <normal_column> <id>59</id> - <referenced_column>122</referenced_column> + <referenced_column>114</referenced_column> <relation>8</relation> <description></description> <unique_key_name></unique_key_name> @@ -7499,7 +7242,7 @@ </sequence> </normal_column> <normal_column> - <word_id>77</word_id> + <word_id>74</word_id> <id>64</id> <description></description> <unique_key_name></unique_key_name> @@ -7532,7 +7275,7 @@ </sequence> </normal_column> <normal_column> - <word_id>118</word_id> + <word_id>113</word_id> <id>65</id> <description></description> <unique_key_name></unique_key_name> @@ -7565,7 +7308,7 @@ </sequence> </normal_column> <normal_column> - <word_id>119</word_id> + <word_id>114</word_id> <id>66</id> <description></description> <unique_key_name></unique_key_name> @@ -7598,7 +7341,7 @@ </sequence> </normal_column> <normal_column> - <word_id>120</word_id> + <word_id>115</word_id> <id>67</id> <description></description> <unique_key_name></unique_key_name> @@ -7702,7 +7445,7 @@ <connections> <relation> <id>9</id> - <source>5</source> + <source>14</source> <target>10</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -7716,7 +7459,7 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnemplyrinfo_orgnzt_id_fkey</name> + <name>comtnemplyrinfo_group_id_fkey</name> <on_delete_action>SET NULL</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -7724,7 +7467,7 @@ </relation> <relation> <id>10</id> - <source>15</source> + <source>5</source> <target>10</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -7738,7 +7481,7 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnemplyrinfo_group_id_fkey</name> + <name>comtnemplyrinfo_orgnzt_id_fkey</name> <on_delete_action>SET NULL</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -7788,7 +7531,7 @@ <normal_column> <id>70</id> <referenced_column>19</referenced_column> - <relation>9</relation> + <relation>10</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7820,7 +7563,7 @@ </sequence> </normal_column> <normal_column> - <word_id>250</word_id> + <word_id>234</word_id> <id>71</id> <description></description> <unique_key_name></unique_key_name> @@ -7853,7 +7596,7 @@ </sequence> </normal_column> <normal_column> - <word_id>173</word_id> + <word_id>166</word_id> <id>72</id> <description></description> <unique_key_name></unique_key_name> @@ -7919,7 +7662,7 @@ </sequence> </normal_column> <normal_column> - <word_id>104</word_id> + <word_id>101</word_id> <id>74</id> <description></description> <unique_key_name></unique_key_name> @@ -7952,7 +7695,7 @@ </sequence> </normal_column> <normal_column> - <word_id>225</word_id> + <word_id>211</word_id> <id>75</id> <description></description> <unique_key_name></unique_key_name> @@ -8018,7 +7761,7 @@ </sequence> </normal_column> <normal_column> - <word_id>93</word_id> + <word_id>90</word_id> <id>77</id> <description></description> <unique_key_name></unique_key_name> @@ -8051,7 +7794,7 @@ </sequence> </normal_column> <normal_column> - <word_id>99</word_id> + <word_id>96</word_id> <id>78</id> <description></description> <unique_key_name></unique_key_name> @@ -8084,7 +7827,7 @@ </sequence> </normal_column> <normal_column> - <word_id>176</word_id> + <word_id>169</word_id> <id>79</id> <description></description> <unique_key_name></unique_key_name> @@ -8117,7 +7860,7 @@ </sequence> </normal_column> <normal_column> - <word_id>175</word_id> + <word_id>168</word_id> <id>80</id> <description></description> <unique_key_name></unique_key_name> @@ -8150,7 +7893,7 @@ </sequence> </normal_column> <normal_column> - <word_id>100</word_id> + <word_id>97</word_id> <id>81</id> <description></description> <unique_key_name></unique_key_name> @@ -8249,7 +7992,7 @@ </sequence> </normal_column> <normal_column> - <word_id>258</word_id> + <word_id>242</word_id> <id>84</id> <description></description> <unique_key_name></unique_key_name> @@ -8282,7 +8025,7 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> + <word_id>155</word_id> <id>85</id> <description></description> <unique_key_name></unique_key_name> @@ -8315,7 +8058,7 @@ </sequence> </normal_column> <normal_column> - <word_id>131</word_id> + <word_id>126</word_id> <id>86</id> <description></description> <unique_key_name></unique_key_name> @@ -8381,7 +8124,7 @@ </sequence> </normal_column> <normal_column> - <word_id>161</word_id> + <word_id>154</word_id> <id>88</id> <description></description> <unique_key_name></unique_key_name> @@ -8414,7 +8157,7 @@ </sequence> </normal_column> <normal_column> - <word_id>101</word_id> + <word_id>98</word_id> <id>89</id> <description></description> <unique_key_name></unique_key_name> @@ -8448,8 +8191,8 @@ </normal_column> <normal_column> <id>90</id> - <referenced_column>122</referenced_column> - <relation>10</relation> + <referenced_column>114</referenced_column> + <relation>9</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8481,7 +8224,7 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> + <word_id>182</word_id> <id>91</id> <description></description> <unique_key_name></unique_key_name> @@ -8547,7 +8290,7 @@ </sequence> </normal_column> <normal_column> - <word_id>77</word_id> + <word_id>74</word_id> <id>93</id> <description></description> <unique_key_name></unique_key_name> @@ -8613,7 +8356,7 @@ </sequence> </normal_column> <normal_column> - <word_id>222</word_id> + <word_id>208</word_id> <id>95</id> <description></description> <unique_key_name></unique_key_name> @@ -8646,7 +8389,7 @@ </sequence> </normal_column> <normal_column> - <word_id>118</word_id> + <word_id>113</word_id> <id>96</id> <description></description> <unique_key_name></unique_key_name> @@ -8679,7 +8422,7 @@ </sequence> </normal_column> <normal_column> - <word_id>119</word_id> + <word_id>114</word_id> <id>97</id> <description></description> <unique_key_name></unique_key_name> @@ -8712,7 +8455,7 @@ </sequence> </normal_column> <normal_column> - <word_id>120</word_id> + <word_id>115</word_id> <id>98</id> <description></description> <unique_key_name></unique_key_name> @@ -8815,52 +8558,29 @@ </table> <table> <id>11</id> - <height>212</height> - <width>133</width> + <height>191</height> + <width>168</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>2012</x> - <y>1520</y> + <x>1980</x> + <y>824</y> <color> <r>128</r> <g>128</g> <b>192</b> </color> <connections> - <relation> - <id>11</id> - <source>42</source> - <target>11</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnbbsuse_bbs_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> </connections> - <physical_name>comtnbbsuse</physical_name> - <logical_name>게시판활용</logical_name> - <description>게시판활용</description> + <physical_name>comtnbbsmasteroptn</physical_name> + <logical_name>게시판마스터옵션</logical_name> + <description>게시판마스터옵션</description> <constraint></constraint> - <primary_key_name>comtnbbsuse_pkey</primary_key_name> + <primary_key_name>comtnbbsmasteroptn_pkey</primary_key_name> <option></option> <columns> <normal_column> + <word_id>20</word_id> <id>100</id> - <referenced_column>371</referenced_column> - <relation>11</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8869,7 +8589,7 @@ <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>false</foreign_key> <not_null>true</not_null> <primary_key>true</primary_key> <unique_key>false</unique_key> @@ -8892,19 +8612,19 @@ </sequence> </normal_column> <normal_column> - <word_id>236</word_id> + <word_id>2</word_id> <id>101</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -8925,7 +8645,7 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> + <word_id>216</word_id> <id>102</id> <description></description> <unique_key_name></unique_key_name> @@ -8958,18 +8678,18 @@ </sequence> </normal_column> <normal_column> - <word_id>197</word_id> + <word_id>87</word_id> <id>103</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8991,7 +8711,7 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> + <word_id>107</word_id> <id>104</id> <description></description> <unique_key_name></unique_key_name> @@ -9024,7 +8744,7 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> + <word_id>85</word_id> <id>105</id> <description></description> <unique_key_name></unique_key_name> @@ -9057,45 +8777,12 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> + <word_id>109</word_id> <id>106</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>114</word_id> - <id>107</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> @@ -9124,19 +8811,6 @@ </normal_column> </columns> <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnbbsuse_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>100</id> - <desc>false</desc> - </column> - </columns> - </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -9147,38 +8821,83 @@ </table> <table> <id>12</id> - <height>191</height> - <width>168</width> + <height>107</height> + <width>172</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>2001</x> - <y>798</y> + <x>279</x> + <y>2388</y> <color> <r>128</r> <g>128</g> <b>192</b> </color> <connections> + <relation> + <id>11</id> + <source>13</source> + <target>12</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnauthorrolerelate_author_code_fkey</name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + <relation> + <id>12</id> + <source>37</source> + <target>12</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnauthorrolerelate_role_code_fkey</name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> </connections> - <physical_name>comtnbbsmasteroptn</physical_name> - <logical_name>게시판마스터옵션</logical_name> - <description>게시판마스터옵션</description> + <physical_name>comtnauthorrolerelate</physical_name> + <logical_name>권한롤관계</logical_name> + <description>권한롤관계</description> <constraint></constraint> - <primary_key_name>comtnbbsmasteroptn_pkey</primary_key_name> + <primary_key_name>comtnauthorrolerelate_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>20</word_id> - <id>108</id> + <id>107</id> + <referenced_column>110</referenced_column> + <relation>11</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>true</not_null> <primary_key>true</primary_key> <unique_key>false</unique_key> @@ -9201,326 +8920,18 @@ </sequence> </normal_column> <normal_column> - <word_id>2</word_id> - <id>109</id> + <id>108</id> + <referenced_column>327</referenced_column> + <relation>12</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>230</word_id> - <id>110</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>char</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>90</word_id> - <id>111</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>timestamp</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>112</word_id> - <id>112</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>timestamp</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>88</word_id> - <id>113</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>114</word_id> - <id>114</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>13</id> - <height>107</height> - <width>172</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>279</x> - <y>2388</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>12</id> - <source>14</source> - <target>13</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnauthorrolerelate_author_code_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - <relation> - <id>13</id> - <source>39</source> - <target>13</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnauthorrolerelate_role_code_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnauthorrolerelate</physical_name> - <logical_name>권한롤관계</logical_name> - <description>권한롤관계</description> - <constraint></constraint> - <primary_key_name>comtnauthorrolerelate_pkey</primary_key_name> - <option></option> - <columns> - <normal_column> - <id>115</id> - <referenced_column>118</referenced_column> - <relation>12</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <id>116</id> - <referenced_column>335</referenced_column> - <relation>13</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>true</foreign_key> <not_null>true</not_null> <primary_key>true</primary_key> <unique_key>false</unique_key> @@ -9544,7 +8955,7 @@ </normal_column> <normal_column> <word_id>47</word_id> - <id>117</id> + <id>109</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9585,7 +8996,7 @@ <description></description> <columns> <column> - <id>115</id> + <id>107</id> <desc>false</desc> </column> </columns> @@ -9598,7 +9009,7 @@ <description></description> <columns> <column> - <id>116</id> + <id>108</id> <desc>false</desc> </column> </columns> @@ -9612,7 +9023,7 @@ </table_properties> </table> <table> - <id>14</id> + <id>13</id> <height>128</height> <width>144</width> <font_name>맑은 고딕</font_name> @@ -9635,7 +9046,7 @@ <columns> <normal_column> <word_id>13</word_id> - <id>118</id> + <id>110</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9668,7 +9079,7 @@ </normal_column> <normal_column> <word_id>17</word_id> - <id>119</id> + <id>111</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9701,7 +9112,7 @@ </normal_column> <normal_column> <word_id>16</word_id> - <id>120</id> + <id>112</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9734,7 +9145,7 @@ </normal_column> <normal_column> <word_id>15</word_id> - <id>121</id> + <id>113</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9776,7 +9187,7 @@ </table_properties> </table> <table> - <id>15</id> + <id>14</id> <height>128</height> <width>253</width> <font_name>맑은 고딕</font_name> @@ -9798,8 +9209,8 @@ <option></option> <columns> <normal_column> - <word_id>97</word_id> - <id>122</id> + <word_id>94</word_id> + <id>114</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9831,8 +9242,8 @@ </sequence> </normal_column> <normal_column> - <word_id>98</word_id> - <id>123</id> + <word_id>95</word_id> + <id>115</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9864,8 +9275,8 @@ </sequence> </normal_column> <normal_column> - <word_id>94</word_id> - <id>124</id> + <word_id>91</word_id> + <id>116</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9897,8 +9308,8 @@ </sequence> </normal_column> <normal_column> - <word_id>95</word_id> - <id>125</id> + <word_id>92</word_id> + <id>117</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9940,7 +9351,7 @@ </table_properties> </table> <table> - <id>16</id> + <id>15</id> <height>254</height> <width>186</width> <font_name>맑은 고딕</font_name> @@ -9954,9 +9365,9 @@ </color> <connections> <relation> - <id>14</id> + <id>13</id> <source>4</source> - <target>16</target> + <target>15</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -9984,9 +9395,9 @@ <option></option> <columns> <normal_column> - <id>126</id> + <id>118</id> <referenced_column>14</referenced_column> - <relation>14</relation> + <relation>13</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10018,8 +9429,8 @@ </sequence> </normal_column> <normal_column> - <word_id>204</word_id> - <id>127</id> + <word_id>193</word_id> + <id>119</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10051,8 +9462,8 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> - <id>128</id> + <word_id>205</word_id> + <id>120</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10085,7 +9496,7 @@ </normal_column> <normal_column> <word_id>29</word_id> - <id>129</id> + <id>121</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10117,8 +9528,8 @@ </sequence> </normal_column> <normal_column> - <word_id>205</word_id> - <id>130</id> + <word_id>194</word_id> + <id>122</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10150,8 +9561,8 @@ </sequence> </normal_column> <normal_column> - <word_id>163</word_id> - <id>131</id> + <word_id>156</word_id> + <id>123</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10183,8 +9594,8 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> - <id>132</id> + <word_id>173</word_id> + <id>124</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10216,8 +9627,8 @@ </sequence> </normal_column> <normal_column> - <word_id>179</word_id> - <id>133</id> + <word_id>171</word_id> + <id>125</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10249,8 +9660,8 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> - <id>134</id> + <word_id>203</word_id> + <id>126</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10282,8 +9693,8 @@ </sequence> </normal_column> <normal_column> - <word_id>206</word_id> - <id>135</id> + <word_id>195</word_id> + <id>127</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10324,7 +9735,7 @@ <description></description> <columns> <column> - <id>126</id> + <id>118</id> <desc>false</desc> </column> </columns> @@ -10338,7 +9749,7 @@ </table_properties> </table> <table> - <id>17</id> + <id>16</id> <height>86</height> <width>125</width> <font_name>맑은 고딕</font_name> @@ -10360,8 +9771,8 @@ <option></option> <columns> <normal_column> - <word_id>235</word_id> - <id>136</id> + <word_id>220</word_id> + <id>128</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10393,8 +9804,8 @@ </sequence> </normal_column> <normal_column> - <word_id>147</word_id> - <id>137</id> + <word_id>141</word_id> + <id>129</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10436,7 +9847,7 @@ </table_properties> </table> <table> - <id>18</id> + <id>17</id> <height>233</height> <width>254</width> <font_name>맑은 고딕</font_name> @@ -10450,9 +9861,9 @@ </color> <connections> <relation> - <id>15</id> - <source>19</source> - <target>18</target> + <id>14</id> + <source>18</source> + <target>17</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -10480,9 +9891,9 @@ <option></option> <columns> <normal_column> - <id>138</id> - <referenced_column>147</referenced_column> - <relation>15</relation> + <id>130</id> + <referenced_column>139</referenced_column> + <relation>14</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10515,7 +9926,7 @@ </normal_column> <normal_column> <word_id>35</word_id> - <id>139</id> + <id>131</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10548,7 +9959,7 @@ </normal_column> <normal_column> <word_id>40</word_id> - <id>140</id> + <id>132</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10581,7 +9992,7 @@ </normal_column> <normal_column> <word_id>36</word_id> - <id>141</id> + <id>133</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10613,8 +10024,8 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> - <id>142</id> + <word_id>238</word_id> + <id>134</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10646,8 +10057,8 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>143</id> + <word_id>87</word_id> + <id>135</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10679,8 +10090,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>144</id> + <word_id>85</word_id> + <id>136</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10712,8 +10123,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>145</id> + <word_id>107</word_id> + <id>137</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10745,8 +10156,8 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>146</id> + <word_id>109</word_id> + <id>138</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10787,7 +10198,7 @@ <description></description> <columns> <column> - <id>138</id> + <id>130</id> <desc>false</desc> </column> </columns> @@ -10801,7 +10212,7 @@ </table_properties> </table> <table> - <id>19</id> + <id>18</id> <height>233</height> <width>227</width> <font_name>맑은 고딕</font_name> @@ -10815,9 +10226,9 @@ </color> <connections> <relation> - <id>16</id> - <source>22</source> - <target>19</target> + <id>15</id> + <source>21</source> + <target>18</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -10846,7 +10257,7 @@ <columns> <normal_column> <word_id>37</word_id> - <id>147</id> + <id>139</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10879,7 +10290,7 @@ </normal_column> <normal_column> <word_id>39</word_id> - <id>148</id> + <id>140</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10912,7 +10323,7 @@ </normal_column> <normal_column> <word_id>38</word_id> - <id>149</id> + <id>141</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10944,8 +10355,8 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> - <id>150</id> + <word_id>238</word_id> + <id>142</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10977,9 +10388,9 @@ </sequence> </normal_column> <normal_column> - <id>151</id> - <referenced_column>163</referenced_column> - <relation>16</relation> + <id>143</id> + <referenced_column>155</referenced_column> + <relation>15</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11011,8 +10422,8 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>152</id> + <word_id>87</word_id> + <id>144</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11044,8 +10455,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>153</id> + <word_id>85</word_id> + <id>145</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11077,8 +10488,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>154</id> + <word_id>107</word_id> + <id>146</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11110,8 +10521,8 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>155</id> + <word_id>109</word_id> + <id>147</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11152,7 +10563,7 @@ <description></description> <columns> <column> - <id>151</id> + <id>143</id> <desc>false</desc> </column> </columns> @@ -11166,7 +10577,7 @@ </table_properties> </table> <table> - <id>20</id> + <id>19</id> <height>149</height> <width>127</width> <font_name>맑은 고딕</font_name> @@ -11188,8 +10599,8 @@ <option></option> <columns> <normal_column> - <word_id>202</word_id> - <id>156</id> + <word_id>192</word_id> + <id>148</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11221,8 +10632,8 @@ </sequence> </normal_column> <normal_column> - <word_id>159</word_id> - <id>157</id> + <word_id>153</word_id> + <id>149</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11254,8 +10665,8 @@ </sequence> </normal_column> <normal_column> - <word_id>245</word_id> - <id>158</id> + <word_id>229</word_id> + <id>150</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11287,8 +10698,8 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> - <id>159</id> + <word_id>205</word_id> + <id>151</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11320,8 +10731,8 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> - <id>160</id> + <word_id>206</word_id> + <id>152</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11363,7 +10774,7 @@ </table_properties> </table> <table> - <id>21</id> + <id>20</id> <height>86</height> <width>233</width> <font_name>맑은 고딕</font_name> @@ -11385,8 +10796,8 @@ <option></option> <columns> <normal_column> - <word_id>103</word_id> - <id>161</id> + <word_id>100</word_id> + <id>153</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11418,8 +10829,8 @@ </sequence> </normal_column> <normal_column> - <word_id>102</word_id> - <id>162</id> + <word_id>99</word_id> + <id>154</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11461,7 +10872,7 @@ </table_properties> </table> <table> - <id>22</id> + <id>21</id> <height>212</height> <width>157</width> <font_name>맑은 고딕</font_name> @@ -11484,7 +10895,7 @@ <columns> <normal_column> <word_id>31</word_id> - <id>163</id> + <id>155</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11517,7 +10928,7 @@ </normal_column> <normal_column> <word_id>33</word_id> - <id>164</id> + <id>156</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11550,7 +10961,7 @@ </normal_column> <normal_column> <word_id>32</word_id> - <id>165</id> + <id>157</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11582,8 +10993,8 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> - <id>166</id> + <word_id>238</word_id> + <id>158</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11615,8 +11026,8 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>167</id> + <word_id>87</word_id> + <id>159</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11648,8 +11059,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>168</id> + <word_id>85</word_id> + <id>160</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11681,8 +11092,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>169</id> + <word_id>107</word_id> + <id>161</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11714,8 +11125,8 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>170</id> + <word_id>109</word_id> + <id>162</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11757,7 +11168,7 @@ </table_properties> </table> <table> - <id>23</id> + <id>22</id> <height>548</height> <width>284</width> <font_name>맑은 고딕</font_name> @@ -11771,9 +11182,9 @@ </color> <connections> <relation> - <id>17</id> - <source>15</source> - <target>23</target> + <id>16</id> + <source>14</source> + <target>22</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -11801,206 +11212,8 @@ <option></option> <columns> <normal_column> - <word_id>127</word_id> - <id>171</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>173</word_id> - <id>172</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>176</word_id> - <id>173</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>175</word_id> - <id>174</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>104</word_id> - <id>175</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>128</word_id> - <id>176</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>258</word_id> - <id>177</id> + <word_id>122</word_id> + <id>163</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12011,7 +11224,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12032,8 +11245,8 @@ </sequence> </normal_column> <normal_column> - <word_id>0</word_id> - <id>178</id> + <word_id>166</word_id> + <id>164</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12065,8 +11278,8 @@ </sequence> </normal_column> <normal_column> - <word_id>9</word_id> - <id>179</id> + <word_id>169</word_id> + <id>165</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12076,7 +11289,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12098,8 +11311,8 @@ </sequence> </normal_column> <normal_column> - <word_id>129</word_id> - <id>180</id> + <word_id>168</word_id> + <id>166</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12131,8 +11344,8 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> - <id>181</id> + <word_id>101</word_id> + <id>167</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12164,8 +11377,8 @@ </sequence> </normal_column> <normal_column> - <word_id>60</word_id> - <id>182</id> + <word_id>123</word_id> + <id>168</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12197,8 +11410,8 @@ </sequence> </normal_column> <normal_column> - <word_id>131</word_id> - <id>183</id> + <word_id>242</word_id> + <id>169</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12230,42 +11443,8 @@ </sequence> </normal_column> <normal_column> - <id>184</id> - <referenced_column>122</referenced_column> - <relation>17</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>character(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>126</word_id> - <id>185</id> + <word_id>0</word_id> + <id>170</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12275,7 +11454,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12297,8 +11476,8 @@ </sequence> </normal_column> <normal_column> - <word_id>125</word_id> - <id>186</id> + <word_id>9</word_id> + <id>171</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12308,7 +11487,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12330,8 +11509,8 @@ </sequence> </normal_column> <normal_column> - <word_id>145</word_id> - <id>187</id> + <word_id>124</word_id> + <id>172</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12341,7 +11520,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12363,13 +11542,13 @@ </sequence> </normal_column> <normal_column> - <word_id>222</word_id> - <id>188</id> + <word_id>54</word_id> + <id>173</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12396,18 +11575,18 @@ </sequence> </normal_column> <normal_column> - <word_id>225</word_id> - <id>189</id> + <word_id>60</word_id> + <id>174</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12429,13 +11608,13 @@ </sequence> </normal_column> <normal_column> - <word_id>77</word_id> - <id>190</id> + <word_id>126</word_id> + <id>175</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12462,17 +11641,18 @@ </sequence> </normal_column> <normal_column> - <word_id>118</word_id> - <id>191</id> + <id>176</id> + <referenced_column>114</referenced_column> + <relation>16</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -12495,13 +11675,13 @@ </sequence> </normal_column> <normal_column> - <word_id>119</word_id> - <id>192</id> + <word_id>121</word_id> + <id>177</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12529,12 +11709,12 @@ </normal_column> <normal_column> <word_id>120</word_id> - <id>193</id> + <id>178</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12561,18 +11741,18 @@ </sequence> </normal_column> <normal_column> - <word_id>30</word_id> - <id>194</id> + <word_id>139</word_id> + <id>179</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12593,65 +11773,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtngnrlmber_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>184</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>24</id> - <height>191</height> - <width>223</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2292</x> - <y>114</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnloginlog</physical_name> - <logical_name>접속로그</logical_name> - <description>접속로그</description> - <constraint></constraint> - <primary_key_name>comtnloginlog_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>121</word_id> - <id>195</id> + <word_id>208</word_id> + <id>180</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12672,13 +11807,13 @@ </sequence> </normal_column> <normal_column> - <word_id>41</word_id> - <id>196</id> + <word_id>211</word_id> + <id>181</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12705,18 +11840,18 @@ </sequence> </normal_column> <normal_column> - <word_id>42</word_id> - <id>197</id> + <word_id>74</word_id> + <id>182</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12738,13 +11873,13 @@ </sequence> </normal_column> <normal_column> - <word_id>43</word_id> - <id>198</id> + <word_id>113</word_id> + <id>183</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12771,13 +11906,13 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> - <id>199</id> + <word_id>114</word_id> + <id>184</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12804,13 +11939,13 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> - <id>200</id> + <word_id>115</word_id> + <id>185</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12837,8 +11972,8 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> - <id>201</id> + <word_id>30</word_id> + <id>186</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12871,6 +12006,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtngnrlmber_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>176</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -12880,13 +12028,13 @@ </table_properties> </table> <table> - <id>25</id> - <height>212</height> - <width>147</width> + <id>23</id> + <height>191</height> + <width>223</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>180</x> - <y>1584</y> + <x>2292</x> + <y>114</y> <color> <r>128</r> <g>128</g> @@ -12894,60 +12042,27 @@ </color> <connections> </connections> - <physical_name>comtnloginpolicy</physical_name> - <logical_name>로그인정책</logical_name> - <description>로그인정책</description> + <physical_name>comtnloginlog</physical_name> + <logical_name>접속로그</logical_name> + <description>접속로그</description> <constraint></constraint> - <primary_key_name>comtnloginpolicy_pkey</primary_key_name> + <primary_key_name>comtnloginlog_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>57</word_id> - <id>202</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>108</word_id> - <id>203</id> + <word_id>116</word_id> + <id>187</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12968,18 +12083,18 @@ </sequence> </normal_column> <normal_column> - <word_id>55</word_id> - <id>204</id> + <word_id>41</word_id> + <id>188</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13001,18 +12116,18 @@ </sequence> </normal_column> <normal_column> - <word_id>117</word_id> - <id>205</id> + <word_id>42</word_id> + <id>189</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13034,13 +12149,13 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>206</id> + <word_id>43</word_id> + <id>190</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13067,13 +12182,13 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>207</id> + <word_id>72</word_id> + <id>191</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13100,13 +12215,13 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>208</id> + <word_id>71</word_id> + <id>192</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13133,8 +12248,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>209</id> + <word_id>47</word_id> + <id>193</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13176,13 +12291,13 @@ </table_properties> </table> <table> - <id>26</id> - <height>107</height> - <width>177</width> + <id>24</id> + <height>212</height> + <width>147</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>276</x> - <y>2751</y> + <x>180</x> + <y>1584</y> <color> <r>128</r> <g>128</g> @@ -13190,16 +12305,16 @@ </color> <connections> </connections> - <physical_name>comtnemplyrscrtyestbs</physical_name> - <logical_name>사용자보안설정</logical_name> - <description>사용자보안설정</description> + <physical_name>comtnloginpolicy</physical_name> + <logical_name>로그인정책</logical_name> + <description>로그인정책</description> <constraint></constraint> - <primary_key_name>comtnemplyrscrtyestbs_pkey</primary_key_name> + <primary_key_name>comtnloginpolicy_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>223</word_id> - <id>210</id> + <word_id>57</word_id> + <id>194</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13231,18 +12346,18 @@ </sequence> </normal_column> <normal_column> - <word_id>130</word_id> - <id>211</id> + <word_id>104</word_id> + <id>195</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13264,13 +12379,13 @@ </sequence> </normal_column> <normal_column> - <word_id>13</word_id> - <id>212</id> + <word_id>55</word_id> + <id>196</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13296,65 +12411,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnemplyrscrtyestbs_i04</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>212</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>27</id> - <height>128</height> - <width>330</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>262</x> - <y>2152</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnbkmkmenumanageresult</physical_name> - <logical_name>바로가기 메뉴 등록</logical_name> - <description>바로가기 메뉴 등록</description> - <constraint></constraint> - <primary_key_name>comtnbkmkmenumanageresult_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>135</word_id> - <id>213</id> + <word_id>112</word_id> + <id>197</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13375,8 +12445,8 @@ </sequence> </normal_column> <normal_column> - <word_id>57</word_id> - <id>214</id> + <word_id>85</word_id> + <id>198</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13386,8 +12456,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13408,18 +12478,18 @@ </sequence> </normal_column> <normal_column> - <word_id>137</word_id> - <id>215</id> + <word_id>87</word_id> + <id>199</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13441,8 +12511,8 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> - <id>216</id> + <word_id>109</word_id> + <id>200</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13452,7 +12522,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13473,52 +12543,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>28</id> - <height>128</height> - <width>133</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>657</x> - <y>2152</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnsitemap</physical_name> - <logical_name>사이트맵</logical_name> - <description>사이트맵</description> - <constraint></constraint> - <primary_key_name>comtnsitemap_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>122</word_id> - <id>217</id> + <word_id>107</word_id> + <id>201</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13536,11 +12574,43 @@ <description></description> <data_type></data_type> <decimal_size>0</decimal_size> - </sequence> - </normal_column> + </sequence> + </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>25</id> + <height>107</height> + <width>177</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>276</x> + <y>2751</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnemplyrscrtyestbs</physical_name> + <logical_name>사용자보안설정</logical_name> + <description>사용자보안설정</description> + <constraint></constraint> + <primary_key_name>comtnemplyrscrtyestbs_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>44</word_id> - <id>218</id> + <word_id>209</word_id> + <id>202</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13551,7 +12621,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13572,18 +12642,18 @@ </sequence> </normal_column> <normal_column> - <word_id>123</word_id> - <id>219</id> + <word_id>125</word_id> + <id>203</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13605,8 +12675,8 @@ </sequence> </normal_column> <normal_column> - <word_id>124</word_id> - <id>220</id> + <word_id>13</word_id> + <id>204</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13639,6 +12709,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnemplyrscrtyestbs_i04</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>204</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -13648,62 +12731,39 @@ </table_properties> </table> <table> - <id>29</id> - <height>464</height> - <width>204</width> + <id>26</id> + <height>128</height> + <width>330</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>66</x> - <y>818</y> + <x>262</x> + <y>2152</y> <color> <r>128</r> <g>128</g> <b>192</b> </color> <connections> - <relation> - <id>18</id> - <source>10</source> - <target>29</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comthemplyrinfochangedtls_emplyr_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> </connections> - <physical_name>comthemplyrinfochangedtls</physical_name> - <logical_name>업무사용자정보변경내역</logical_name> - <description>업무사용자정보변경내역</description> + <physical_name>comtnbkmkmenumanageresult</physical_name> + <logical_name>바로가기 메뉴 등록</logical_name> + <description>바로가기 메뉴 등록</description> <constraint></constraint> - <primary_key_name>comthemplyrinfochangedtls_pkey</primary_key_name> + <primary_key_name>comtnbkmkmenumanageresult_pkey</primary_key_name> <option></option> <columns> <normal_column> - <id>221</id> - <referenced_column>69</referenced_column> - <relation>18</relation> + <word_id>130</word_id> + <id>205</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>false</foreign_key> <not_null>true</not_null> <primary_key>true</primary_key> <unique_key>false</unique_key> @@ -13726,13 +12786,13 @@ </sequence> </normal_column> <normal_column> - <word_id>28</word_id> - <id>222</id> + <word_id>57</word_id> + <id>206</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13759,18 +12819,18 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> - <id>223</id> + <word_id>132</word_id> + <id>207</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13792,18 +12852,18 @@ </sequence> </normal_column> <normal_column> - <word_id>97</word_id> - <id>224</id> + <word_id>178</word_id> + <id>208</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13824,9 +12884,41 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>27</id> + <height>128</height> + <width>133</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>657</x> + <y>2152</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnsitemap</physical_name> + <logical_name>사이트맵</logical_name> + <description>사이트맵</description> + <constraint></constraint> + <primary_key_name>comtnsitemap_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>59</word_id> - <id>225</id> + <word_id>117</word_id> + <id>209</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13836,8 +12928,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13858,18 +12950,18 @@ </sequence> </normal_column> <normal_column> - <word_id>225</word_id> - <id>226</id> + <word_id>44</word_id> + <id>210</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13891,18 +12983,18 @@ </sequence> </normal_column> <normal_column> - <word_id>27</word_id> - <id>227</id> + <word_id>118</word_id> + <id>211</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13924,8 +13016,8 @@ </sequence> </normal_column> <normal_column> - <word_id>93</word_id> - <id>228</id> + <word_id>119</word_id> + <id>212</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13935,7 +13027,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13956,9 +13048,64 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>28</id> + <height>464</height> + <width>204</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>66</x> + <y>818</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>17</id> + <source>10</source> + <target>28</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comthemplyrinfochangedtls_emplyr_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comthemplyrinfochangedtls</physical_name> + <logical_name>업무사용자정보변경내역</logical_name> + <description>업무사용자정보변경내역</description> + <constraint></constraint> + <primary_key_name>comthemplyrinfochangedtls_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>99</word_id> - <id>229</id> + <id>213</id> + <referenced_column>69</referenced_column> + <relation>17</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13967,9 +13114,9 @@ <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13990,19 +13137,19 @@ </sequence> </normal_column> <normal_column> - <word_id>100</word_id> - <id>230</id> + <word_id>28</word_id> + <id>214</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14023,13 +13170,13 @@ </sequence> </normal_column> <normal_column> - <word_id>9</word_id> - <id>231</id> + <word_id>159</word_id> + <id>215</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14056,13 +13203,13 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> - <id>232</id> + <word_id>94</word_id> + <id>216</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14089,8 +13236,8 @@ </sequence> </normal_column> <normal_column> - <word_id>258</word_id> - <id>233</id> + <word_id>59</word_id> + <id>217</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14122,13 +13269,13 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> - <id>234</id> + <word_id>211</word_id> + <id>218</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14155,13 +13302,13 @@ </sequence> </normal_column> <normal_column> - <word_id>131</word_id> - <id>235</id> + <word_id>27</word_id> + <id>219</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14188,8 +13335,8 @@ </sequence> </normal_column> <normal_column> - <word_id>56</word_id> - <id>236</id> + <word_id>90</word_id> + <id>220</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14221,8 +13368,8 @@ </sequence> </normal_column> <normal_column> - <word_id>101</word_id> - <id>237</id> + <word_id>96</word_id> + <id>221</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14254,13 +13401,13 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> - <id>238</id> + <word_id>97</word_id> + <id>222</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14287,13 +13434,13 @@ </sequence> </normal_column> <normal_column> - <word_id>58</word_id> - <id>239</id> + <word_id>9</word_id> + <id>223</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14320,13 +13467,13 @@ </sequence> </normal_column> <normal_column> - <word_id>77</word_id> - <id>240</id> + <word_id>54</word_id> + <id>224</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14352,54 +13499,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comthemplyrinfochangedtls_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>221</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>30</id> - <height>380</height> - <width>225</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1668</x> - <y>114</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnsyslog</physical_name> - <logical_name>시스템로그</logical_name> - <description>시스템로그</description> - <constraint></constraint> - <primary_key_name>comtnsyslog_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>202</word_id> - <id>241</id> + <word_id>242</word_id> + <id>225</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14409,8 +13511,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14431,13 +13533,13 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>242</id> + <word_id>155</word_id> + <id>226</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14464,13 +13566,13 @@ </sequence> </normal_column> <normal_column> - <word_id>106</word_id> - <id>243</id> + <word_id>126</word_id> + <id>227</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14497,13 +13599,13 @@ </sequence> </normal_column> <normal_column> - <word_id>159</word_id> - <id>244</id> + <word_id>56</word_id> + <id>228</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14530,8 +13632,8 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> - <id>245</id> + <word_id>98</word_id> + <id>229</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14563,13 +13665,13 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> - <id>246</id> + <word_id>182</word_id> + <id>230</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14596,13 +13698,13 @@ </sequence> </normal_column> <normal_column> - <word_id>237</word_id> - <id>247</id> + <word_id>58</word_id> + <id>231</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14629,13 +13731,13 @@ </sequence> </normal_column> <normal_column> - <word_id>232</word_id> - <id>248</id> + <word_id>74</word_id> + <id>232</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14661,9 +13763,54 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comthemplyrinfochangedtls_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>213</id> + <desc>false</desc> + </column> + </columns> + </inidex> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>29</id> + <height>380</height> + <width>225</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1668</x> + <y>114</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnsyslog</physical_name> + <logical_name>시스템로그</logical_name> + <description>시스템로그</description> + <constraint></constraint> + <primary_key_name>comtnsyslog_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>142</word_id> - <id>249</id> + <word_id>192</word_id> + <id>233</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14673,8 +13820,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14695,8 +13842,8 @@ </sequence> </normal_column> <normal_column> - <word_id>180</word_id> - <id>250</id> + <word_id>105</word_id> + <id>234</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14728,13 +13875,13 @@ </sequence> </normal_column> <normal_column> - <word_id>177</word_id> - <id>251</id> + <word_id>103</word_id> + <id>235</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14761,13 +13908,13 @@ </sequence> </normal_column> <normal_column> - <word_id>183</word_id> - <id>252</id> + <word_id>153</word_id> + <id>236</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14794,13 +13941,13 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> - <id>253</id> + <word_id>206</word_id> + <id>237</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14827,13 +13974,13 @@ </sequence> </normal_column> <normal_column> - <word_id>75</word_id> - <id>254</id> + <word_id>205</word_id> + <id>238</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14860,13 +14007,13 @@ </sequence> </normal_column> <normal_column> - <word_id>70</word_id> - <id>255</id> + <word_id>222</word_id> + <id>239</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14893,13 +14040,13 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> - <id>256</id> + <word_id>217</word_id> + <id>240</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14925,75 +14072,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>31</id> - <height>296</height> - <width>140</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2588</x> - <y>1117</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>19</id> - <source>36</source> - <target>31</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtncomment_ntt_id_bbs_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtncomment</physical_name> - <logical_name>댓글</logical_name> - <description>댓글</description> - <constraint></constraint> - <primary_key_name>comtncomment_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <id>257</id> - <referenced_column>295</referenced_column> - <relation>19</relation> + <word_id>137</word_id> + <id>241</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15014,9 +14106,8 @@ </sequence> </normal_column> <normal_column> - <id>258</id> - <referenced_column>296</referenced_column> - <relation>19</relation> + <word_id>172</word_id> + <id>242</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15025,9 +14116,9 @@ <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15048,8 +14139,8 @@ </sequence> </normal_column> <normal_column> - <word_id>4</word_id> - <id>259</id> + <word_id>170</word_id> + <id>243</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15059,8 +14150,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15081,8 +14172,8 @@ </sequence> </normal_column> <normal_column> - <word_id>256</word_id> - <id>260</id> + <word_id>174</word_id> + <id>244</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15114,13 +14205,13 @@ </sequence> </normal_column> <normal_column> - <word_id>257</word_id> - <id>261</id> + <word_id>207</word_id> + <id>245</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15147,13 +14238,13 @@ </sequence> </normal_column> <normal_column> - <word_id>1</word_id> - <id>262</id> + <word_id>73</word_id> + <id>246</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15180,18 +14271,18 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> - <id>263</id> + <word_id>70</word_id> + <id>247</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15213,18 +14304,18 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>264</id> + <word_id>71</word_id> + <id>248</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15245,20 +14336,75 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>30</id> + <height>296</height> + <width>140</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>2567</x> + <y>1143</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>18</id> + <source>34</source> + <target>30</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtncomment_ntt_id_bbs_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtncomment</physical_name> + <logical_name>댓글</logical_name> + <description>댓글</description> + <constraint></constraint> + <primary_key_name>comtncomment_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>88</word_id> - <id>265</id> + <id>249</id> + <referenced_column>287</referenced_column> + <relation>18</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15279,19 +14425,20 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>266</id> + <id>250</id> + <referenced_column>288</referenced_column> + <relation>18</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15312,19 +14459,19 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>267</id> + <word_id>4</word_id> + <id>251</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15345,8 +14492,8 @@ </sequence> </normal_column> <normal_column> - <word_id>173</word_id> - <id>268</id> + <word_id>240</word_id> + <id>252</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15377,69 +14524,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtncomment_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>257</id> - <desc>false</desc> - </column> - <column> - <id>258</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>32</id> - <height>107</height> - <width>121</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2324</x> - <y>1619</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnfile</physical_name> - <logical_name>파일속성</logical_name> - <description>파일속성</description> - <constraint></constraint> - <primary_key_name>comtnfile_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>10</word_id> - <id>269</id> + <word_id>241</word_id> + <id>253</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15460,18 +14558,18 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> - <id>270</id> + <word_id>1</word_id> + <id>254</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15493,8 +14591,8 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> - <id>271</id> + <word_id>238</word_id> + <id>255</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15504,7 +14602,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15525,52 +14623,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>33</id> - <height>254</height> - <width>192</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1429</x> - <y>246</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnuserlog</physical_name> - <logical_name>사용자로그</logical_name> - <description>사용자로그</description> - <constraint></constraint> - <primary_key_name>comtnuserlog_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>157</word_id> - <id>272</id> + <word_id>87</word_id> + <id>256</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15591,8 +14657,8 @@ </sequence> </normal_column> <normal_column> - <word_id>215</word_id> - <id>273</id> + <word_id>85</word_id> + <id>257</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15603,7 +14669,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15624,19 +14690,19 @@ </sequence> </normal_column> <normal_column> - <word_id>233</word_id> - <id>274</id> + <word_id>107</word_id> + <id>258</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15657,8 +14723,8 @@ </sequence> </normal_column> <normal_column> - <word_id>144</word_id> - <id>275</id> + <word_id>109</word_id> + <id>259</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15668,8 +14734,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15690,13 +14756,13 @@ </sequence> </normal_column> <normal_column> - <word_id>45</word_id> - <id>276</id> + <word_id>166</word_id> + <id>260</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15722,20 +14788,69 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtncomment_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>249</id> + <desc>false</desc> + </column> + <column> + <id>250</id> + <desc>false</desc> + </column> + </columns> + </inidex> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>31</id> + <height>107</height> + <width>121</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>2303</x> + <y>1645</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnfile</physical_name> + <logical_name>파일속성</logical_name> + <description>파일속성</description> + <constraint></constraint> + <primary_key_name>comtnfile_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>240</word_id> - <id>277</id> + <word_id>10</word_id> + <id>261</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15756,18 +14871,18 @@ </sequence> </normal_column> <normal_column> - <word_id>194</word_id> - <id>278</id> + <word_id>47</word_id> + <id>262</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15789,13 +14904,13 @@ </sequence> </normal_column> <normal_column> - <word_id>53</word_id> - <id>279</id> + <word_id>238</word_id> + <id>263</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15821,20 +14936,85 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>32</id> + <height>254</height> + <width>192</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1429</x> + <y>246</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnuserlog</physical_name> + <logical_name>사용자로그</logical_name> + <description>사용자로그</description> + <constraint></constraint> + <primary_key_name>comtnuserlog_pkey</primary_key_name> + <option></option> + <columns> + <normal_column> + <word_id>151</word_id> + <id>264</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>character(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> <normal_column> - <word_id>171</word_id> - <id>280</id> + <word_id>204</word_id> + <id>265</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15855,19 +15035,19 @@ </sequence> </normal_column> <normal_column> - <word_id>69</word_id> - <id>281</id> + <word_id>218</word_id> + <id>266</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15887,41 +15067,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>34</id> - <height>317</height> - <width>136</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1668</x> - <y>1860</y> - <color> - <r>255</r> - <g>128</g> - <b>255</b> - </color> - <connections> - </connections> - <physical_name>tnfile</physical_name> - <logical_name>tnfile</logical_name> - <description></description> - <constraint></constraint> - <primary_key_name>tnfile_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>83</word_id> - <id>282</id> + <word_id>138</word_id> + <id>267</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15953,13 +15101,13 @@ </sequence> </normal_column> <normal_column> - <word_id>116</word_id> - <id>283</id> + <word_id>45</word_id> + <id>268</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15986,13 +15134,13 @@ </sequence> </normal_column> <normal_column> - <word_id>92</word_id> - <id>284</id> + <word_id>224</word_id> + <id>269</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16019,13 +15167,13 @@ </sequence> </normal_column> <normal_column> - <word_id>168</word_id> - <id>285</id> + <word_id>184</word_id> + <id>270</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16052,13 +15200,13 @@ </sequence> </normal_column> <normal_column> - <word_id>234</word_id> - <id>286</id> + <word_id>53</word_id> + <id>271</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16085,13 +15233,13 @@ </sequence> </normal_column> <normal_column> - <word_id>243</word_id> - <id>287</id> + <word_id>164</word_id> + <id>272</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16118,8 +15266,8 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> - <id>288</id> + <word_id>69</word_id> + <id>273</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16150,20 +15298,52 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>33</id> + <height>317</height> + <width>136</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1668</x> + <y>1860</y> + <color> + <r>255</r> + <g>128</g> + <b>255</b> + </color> + <connections> + </connections> + <physical_name>tnfile</physical_name> + <logical_name>첨부파일</logical_name> + <description>첨부파일</description> + <constraint></constraint> + <primary_key_name>tnfile_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>146</word_id> - <id>289</id> + <word_id>80</word_id> + <id>274</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16184,13 +15364,13 @@ </sequence> </normal_column> <normal_column> - <word_id>82</word_id> - <id>290</id> + <word_id>111</word_id> + <id>275</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16217,13 +15397,13 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> - <id>291</id> + <word_id>89</word_id> + <id>276</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16250,13 +15430,13 @@ </sequence> </normal_column> <normal_column> - <word_id>196</word_id> - <id>292</id> + <word_id>161</word_id> + <id>277</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16283,13 +15463,13 @@ </sequence> </normal_column> <normal_column> - <word_id>242</word_id> - <id>293</id> + <word_id>219</word_id> + <id>278</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16316,13 +15496,13 @@ </sequence> </normal_column> <normal_column> - <word_id>241</word_id> - <id>294</id> + <word_id>227</word_id> + <id>279</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16348,80 +15528,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <note> - <id>35</id> - <height>-1</height> - <width>-1</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1857</x> - <y>1253</y> - <color> - <r>255</r> - <g>255</g> - <b>0</b> - </color> - <connections> - </connections> - <text>tmplat_id 삭제
cmmnty_id 삭제
</text> - </note> - <table> - <id>36</id> - <height>569</height> - <width>133</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2324</x> - <y>980</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>20</id> - <source>42</source> - <target>36</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnbbs_bbs_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnbbs</physical_name> - <logical_name>게시판</logical_name> - <description>게시판</description> - <constraint></constraint> - <primary_key_name>comtnbbs_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>154</word_id> - <id>295</id> + <word_id>82</word_id> + <id>280</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16431,8 +15540,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16453,20 +15562,19 @@ </sequence> </normal_column> <normal_column> - <id>296</id> - <referenced_column>371</referenced_column> - <relation>20</relation> + <word_id>140</word_id> + <id>281</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16487,13 +15595,13 @@ </sequence> </normal_column> <normal_column> - <word_id>155</word_id> - <id>297</id> + <word_id>79</word_id> + <id>282</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16520,8 +15628,8 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> - <id>298</id> + <word_id>185</word_id> + <id>283</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16553,13 +15661,13 @@ </sequence> </normal_column> <normal_column> - <word_id>153</word_id> - <id>299</id> + <word_id>186</word_id> + <id>284</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16586,13 +15694,13 @@ </sequence> </normal_column> <normal_column> - <word_id>2</word_id> - <id>300</id> + <word_id>226</word_id> + <id>285</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16619,13 +15727,13 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> - <id>301</id> + <word_id>225</word_id> + <id>286</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16651,9 +15759,63 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>34</id> + <height>569</height> + <width>133</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>2303</x> + <y>1006</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>19</id> + <source>39</source> + <target>34</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnbbs_bbs_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtnbbs</physical_name> + <logical_name>게시판</logical_name> + <description>게시판</description> + <constraint></constraint> + <primary_key_name>comtnbbs_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>3</word_id> - <id>302</id> + <word_id>148</word_id> + <id>287</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16663,8 +15825,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16685,19 +15847,20 @@ </sequence> </normal_column> <normal_column> - <word_id>228</word_id> - <id>303</id> + <id>288</id> + <referenced_column>347</referenced_column> + <relation>19</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16718,8 +15881,8 @@ </sequence> </normal_column> <normal_column> - <word_id>193</word_id> - <id>304</id> + <word_id>149</word_id> + <id>289</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16751,18 +15914,18 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> - <id>305</id> + <word_id>150</word_id> + <id>290</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -16784,13 +15947,13 @@ </sequence> </normal_column> <normal_column> - <word_id>149</word_id> - <id>306</id> + <word_id>147</word_id> + <id>291</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16817,13 +15980,13 @@ </sequence> </normal_column> <normal_column> - <word_id>150</word_id> - <id>307</id> + <word_id>2</word_id> + <id>292</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16850,13 +16013,13 @@ </sequence> </normal_column> <normal_column> - <word_id>151</word_id> - <id>308</id> + <word_id>165</word_id> + <id>293</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16883,13 +16046,13 @@ </sequence> </normal_column> <normal_column> - <word_id>152</word_id> - <id>309</id> + <word_id>3</word_id> + <id>294</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16916,13 +16079,13 @@ </sequence> </normal_column> <normal_column> - <word_id>173</word_id> - <id>310</id> + <word_id>214</word_id> + <id>295</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16949,13 +16112,13 @@ </sequence> </normal_column> <normal_column> - <word_id>10</word_id> - <id>311</id> + <word_id>183</word_id> + <id>296</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16982,8 +16145,8 @@ </sequence> </normal_column> <normal_column> - <word_id>148</word_id> - <id>312</id> + <word_id>238</word_id> + <id>297</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16993,7 +16156,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17015,13 +16178,13 @@ </sequence> </normal_column> <normal_column> - <word_id>226</word_id> - <id>313</id> + <word_id>143</word_id> + <id>298</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17048,13 +16211,13 @@ </sequence> </normal_column> <normal_column> - <word_id>224</word_id> - <id>314</id> + <word_id>144</word_id> + <id>299</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17081,18 +16244,18 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>315</id> + <word_id>145</word_id> + <id>300</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17114,8 +16277,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>316</id> + <word_id>146</word_id> + <id>301</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17125,7 +16288,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17147,13 +16310,13 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>317</id> + <word_id>166</word_id> + <id>302</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17180,13 +16343,13 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>318</id> + <word_id>10</word_id> + <id>303</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17213,13 +16376,13 @@ </sequence> </normal_column> <normal_column> - <word_id>26</word_id> - <id>319</id> + <word_id>142</word_id> + <id>304</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17245,87 +16408,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnbbs_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>296</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>37</id> - <height>191</height> - <width>246</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2292</x> - <y>2639</y> - <color> - <r>255</r> - <g>128</g> - <b>255</b> - </color> - <connections> - <relation> - <id>21</id> - <source>38</source> - <target>37</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>FK_tnmenuprograminfo_TO_tnmenuauthoinfo</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>CASCADE</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>tnmenuauthoinfo</physical_name> - <logical_name>메뉴권한정보</logical_name> - <description>메뉴권한정보</description> - <constraint></constraint> - <primary_key_name>PK_tnmenuauthoinfo</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>18</word_id> - <id>320</id> + <word_id>212</word_id> + <id>305</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -17346,13 +16442,13 @@ </sequence> </normal_column> <normal_column> - <word_id>14</word_id> - <id>321</id> + <word_id>210</word_id> + <id>306</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17379,18 +16475,18 @@ </sequence> </normal_column> <normal_column> - <word_id>248</word_id> - <id>322</id> + <word_id>87</word_id> + <id>307</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17412,9 +16508,8 @@ </sequence> </normal_column> <normal_column> - <id>323</id> - <referenced_column>327</referenced_column> - <relation>21</relation> + <word_id>85</word_id> + <id>308</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17423,8 +16518,8 @@ <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> + <foreign_key>false</foreign_key> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17446,18 +16541,17 @@ </sequence> </normal_column> <normal_column> - <id>324</id> - <referenced_column>328</referenced_column> - <relation>21</relation> + <word_id>107</word_id> + <id>309</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>false</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -17480,13 +16574,13 @@ </sequence> </normal_column> <normal_column> - <word_id>91</word_id> - <id>325</id> + <word_id>109</word_id> + <id>310</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17513,13 +16607,13 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>326</id> + <word_id>26</word_id> + <id>311</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17547,6 +16641,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnbbs_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>288</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -17556,13 +16663,13 @@ </table_properties> </table> <table> - <id>38</id> - <height>212</height> - <width>276</width> + <id>35</id> + <height>191</height> + <width>246</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1956</x> - <y>2629</y> + <x>2292</x> + <y>2639</y> <color> <r>255</r> <g>128</g> @@ -17570,9 +16677,9 @@ </color> <connections> <relation> - <id>22</id> - <source>40</source> - <target>38</target> + <id>20</id> + <source>36</source> + <target>35</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -17583,65 +16690,25 @@ <b>0</b> </color> <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> + <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>FK_tnmenuinfo_TO_tnmenuprograminfo</name> + <name>FK_tnmenuprograminfo_TO_tnmenuauthoinfo</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>CASCADE</on_update_action> <referenced_column>null</referenced_column> <referenced_complex_unique_key>null</referenced_complex_unique_key> </relation> </connections> - <physical_name>tnmenuprograminfo</physical_name> - <logical_name>메뉴프로그램정보</logical_name> - <description>메뉴프로그램정보</description> + <physical_name>tnmenuauthoinfo</physical_name> + <logical_name>메뉴권한정보</logical_name> + <description>메뉴권한정보</description> <constraint></constraint> - <primary_key_name>PK_tnmenuprograminfo</primary_key_name> + <primary_key_name>PK_tnmenuauthoinfo</primary_key_name> <option></option> <columns> <normal_column> - <id>327</id> - <referenced_column>342</referenced_column> - <referenced_column>342</referenced_column> - <referenced_column>342</referenced_column> - <referenced_column>342</referenced_column> - <relation>22</relation> - <relation>22</relation> - <relation>22</relation> - <relation>22</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>190</word_id> - <id>328</id> + <word_id>18</word_id> + <id>312</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17673,8 +16740,8 @@ </sequence> </normal_column> <normal_column> - <word_id>191</word_id> - <id>329</id> + <word_id>14</word_id> + <id>313</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17706,15 +16773,15 @@ </sequence> </normal_column> <normal_column> - <word_id>50</word_id> - <id>330</id> + <word_id>232</word_id> + <id>314</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> <type>varchar(n)</type> <constraint></constraint> - <default_value>'Y'::character varying</default_value> + <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>false</not_null> @@ -17739,17 +16806,18 @@ </sequence> </normal_column> <normal_column> - <word_id>91</word_id> - <id>331</id> + <id>315</id> + <referenced_column>319</referenced_column> + <relation>20</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -17772,8 +16840,9 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>332</id> + <id>316</id> + <referenced_column>320</referenced_column> + <relation>20</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17782,7 +16851,7 @@ <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -17805,8 +16874,8 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> - <id>333</id> + <word_id>88</word_id> + <id>317</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17838,8 +16907,8 @@ </sequence> </normal_column> <normal_column> - <word_id>115</word_id> - <id>334</id> + <word_id>86</word_id> + <id>318</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17881,30 +16950,59 @@ </table_properties> </table> <table> - <id>39</id> - <height>191</height> - <width>129</width> + <id>36</id> + <height>212</height> + <width>276</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>80</x> - <y>2346</y> + <x>1956</x> + <y>2629</y> <color> - <r>128</r> + <r>255</r> <g>128</g> - <b>192</b> + <b>255</b> </color> <connections> + <relation> + <id>21</id> + <source>38</source> + <target>36</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>FK_tnmenuinfo_TO_tnmenuprograminfo</name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>CASCADE</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> </connections> - <physical_name>comtnroleinfo</physical_name> - <logical_name>롤정보</logical_name> - <description>롤정보</description> + <physical_name>tnmenuprograminfo</physical_name> + <logical_name>메뉴프로그램정보</logical_name> + <description>메뉴프로그램정보</description> <constraint></constraint> - <primary_key_name>comtnroleinfo_pkey</primary_key_name> + <primary_key_name>PK_tnmenuprograminfo</primary_key_name> <option></option> <columns> <normal_column> - <word_id>207</word_id> - <id>335</id> + <id>319</id> + <referenced_column>334</referenced_column> + <referenced_column>334</referenced_column> + <referenced_column>334</referenced_column> + <referenced_column>334</referenced_column> + <relation>21</relation> + <relation>21</relation> + <relation>21</relation> + <relation>21</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17913,7 +17011,7 @@ <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>true</not_null> <primary_key>true</primary_key> <unique_key>false</unique_key> @@ -17936,8 +17034,8 @@ </sequence> </normal_column> <normal_column> - <word_id>210</word_id> - <id>336</id> + <word_id>180</word_id> + <id>320</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17948,7 +17046,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -17969,8 +17067,8 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> - <id>337</id> + <word_id>181</word_id> + <id>321</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18002,15 +17100,15 @@ </sequence> </normal_column> <normal_column> - <word_id>209</word_id> - <id>338</id> + <word_id>50</word_id> + <id>322</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> <type>varchar(n)</type> <constraint></constraint> - <default_value></default_value> + <default_value>'Y'::character varying</default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>false</not_null> @@ -18035,13 +17133,13 @@ </sequence> </normal_column> <normal_column> - <word_id>213</word_id> - <id>339</id> + <word_id>88</word_id> + <id>323</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18068,8 +17166,8 @@ </sequence> </normal_column> <normal_column> - <word_id>212</word_id> - <id>340</id> + <word_id>86</word_id> + <id>324</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18101,8 +17199,8 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> - <id>341</id> + <word_id>108</word_id> + <id>325</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18112,7 +17210,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18133,68 +17231,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>40</id> - <height>317</height> - <width>389</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1920</x> - <y>2176</y> - <color> - <r>255</r> - <g>128</g> - <b>255</b> - </color> - <connections> - <relation> - <id>23</id> - <source>40</source> - <target>40</target> - <source_xp>100</source_xp> - <source_yp>84</source_yp> - <target_xp>73</target_xp> - <target_yp>100</target_yp> - <bendpoint> - <relative>true</relative> - <x>55</x> - <y>33</y> - </bendpoint> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name></name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>tnmenuinfo</physical_name> - <logical_name>메뉴정보</logical_name> - <description>메뉴정보</description> - <constraint></constraint> - <primary_key_name>PK_tnmenuinfo</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>139</word_id> - <id>342</id> + <word_id>110</word_id> + <id>326</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18204,8 +17243,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18225,21 +17264,52 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - <normal_column> - <id>343</id> - <referenced_column>342</referenced_column> - <relation>23</relation> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>37</id> + <height>191</height> + <width>129</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>80</x> + <y>2346</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnroleinfo</physical_name> + <logical_name>롤정보</logical_name> + <description>롤정보</description> + <constraint></constraint> + <primary_key_name>comtnroleinfo_pkey</primary_key_name> + <option></option> + <columns> + <normal_column> + <word_id>196</word_id> + <id>327</id> <description></description> <unique_key_name></unique_key_name> - <logical_name>상위메뉴번호</logical_name> - <physical_name>upper_menu_no</physical_name> + <logical_name></logical_name> + <physical_name></physical_name> <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>false</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18260,8 +17330,8 @@ </sequence> </normal_column> <normal_column> - <word_id>136</word_id> - <id>344</id> + <word_id>199</word_id> + <id>328</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18271,7 +17341,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18293,13 +17363,13 @@ </sequence> </normal_column> <normal_column> - <word_id>140</word_id> - <id>345</id> + <word_id>200</word_id> + <id>329</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>integer</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18326,8 +17396,8 @@ </sequence> </normal_column> <normal_column> - <word_id>133</word_id> - <id>346</id> + <word_id>198</word_id> + <id>330</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18359,8 +17429,8 @@ </sequence> </normal_column> <normal_column> - <word_id>198</word_id> - <id>347</id> + <word_id>202</word_id> + <id>331</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18392,8 +17462,8 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> - <id>348</id> + <word_id>201</word_id> + <id>332</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18425,18 +17495,18 @@ </sequence> </normal_column> <normal_column> - <word_id>134</word_id> - <id>349</id> + <word_id>197</word_id> + <id>333</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18457,9 +17527,68 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>38</id> + <height>317</height> + <width>389</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1920</x> + <y>2176</y> + <color> + <r>255</r> + <g>128</g> + <b>255</b> + </color> + <connections> + <relation> + <id>22</id> + <source>38</source> + <target>38</target> + <source_xp>100</source_xp> + <source_yp>84</source_yp> + <target_xp>73</target_xp> + <target_yp>100</target_yp> + <bendpoint> + <relative>true</relative> + <x>55</x> + <y>33</y> + </bendpoint> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>0..1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name></name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>tnmenuinfo</physical_name> + <logical_name>메뉴정보</logical_name> + <description>메뉴정보</description> + <constraint></constraint> + <primary_key_name>PK_tnmenuinfo</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>255</word_id> - <id>350</id> + <word_id>134</word_id> + <id>334</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18469,8 +17598,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18491,17 +17620,18 @@ </sequence> </normal_column> <normal_column> - <word_id>91</word_id> - <id>351</id> + <id>335</id> + <referenced_column>334</referenced_column> + <relation>22</relation> <description></description> <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>timestamp</type> + <logical_name>상위메뉴번호</logical_name> + <physical_name>upper_menu_no</physical_name> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -18524,8 +17654,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>352</id> + <word_id>131</word_id> + <id>336</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18557,13 +17687,13 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> - <id>353</id> + <word_id>135</word_id> + <id>337</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>integer</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18590,8 +17720,8 @@ </sequence> </normal_column> <normal_column> - <word_id>115</word_id> - <id>354</id> + <word_id>128</word_id> + <id>338</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18622,41 +17752,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>41</id> - <height>380</height> - <width>225</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2652</x> - <y>2436</y> - <color> - <r>255</r> - <g>128</g> - <b>255</b> - </color> - <connections> - </connections> - <physical_name>comtnsyslog</physical_name> - <logical_name>시스템정보</logical_name> - <description>시스템정보</description> - <constraint></constraint> - <primary_key_name>comtnsyslog_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>203</word_id> - <id>355</id> + <word_id>188</word_id> + <id>339</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18666,8 +17764,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18688,13 +17786,13 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> - <id>356</id> + <word_id>179</word_id> + <id>340</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18721,13 +17819,13 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> - <id>357</id> + <word_id>129</word_id> + <id>341</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18754,13 +17852,13 @@ </sequence> </normal_column> <normal_column> - <word_id>160</word_id> - <id>358</id> + <word_id>239</word_id> + <id>342</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18787,13 +17885,13 @@ </sequence> </normal_column> <normal_column> - <word_id>219</word_id> - <id>359</id> + <word_id>88</word_id> + <id>343</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18820,8 +17918,8 @@ </sequence> </normal_column> <normal_column> - <word_id>216</word_id> - <id>360</id> + <word_id>86</word_id> + <id>344</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18853,13 +17951,13 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>361</id> + <word_id>108</word_id> + <id>345</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18886,8 +17984,8 @@ </sequence> </normal_column> <normal_column> - <word_id>231</word_id> - <id>362</id> + <word_id>110</word_id> + <id>346</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18918,20 +18016,52 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>39</id> + <height>-1</height> + <width>-1</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1980</x> + <y>1040</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnbbsmaster</physical_name> + <logical_name>게시판마스터</logical_name> + <description>게시판마스터</description> + <constraint></constraint> + <primary_key_name>comtnbbsmaster_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>143</word_id> - <id>363</id> + <word_id>20</word_id> + <id>347</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18952,18 +18082,18 @@ </sequence> </normal_column> <normal_column> - <word_id>181</word_id> - <id>364</id> + <word_id>22</word_id> + <id>348</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18985,13 +18115,13 @@ </sequence> </normal_column> <normal_column> - <word_id>178</word_id> - <id>365</id> + <word_id>21</word_id> + <id>349</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19018,18 +18148,18 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> - <id>366</id> + <word_id>23</word_id> + <id>350</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19051,13 +18181,13 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> - <id>367</id> + <word_id>191</word_id> + <id>351</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19085,7 +18215,7 @@ </normal_column> <normal_column> <word_id>76</word_id> - <id>368</id> + <id>352</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -19095,7 +18225,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19117,8 +18247,8 @@ </sequence> </normal_column> <normal_column> - <word_id>71</word_id> - <id>369</id> + <word_id>11</word_id> + <id>353</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -19128,7 +18258,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19150,13 +18280,13 @@ </sequence> </normal_column> <normal_column> - <word_id>73</word_id> - <id>370</id> + <word_id>12</word_id> + <id>354</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19182,52 +18312,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>42</id> - <height>-1</height> - <width>-1</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2001</x> - <y>1014</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnbbsmaster</physical_name> - <logical_name>게시판마스터</logical_name> - <description>게시판마스터</description> - <constraint></constraint> - <primary_key_name>comtnbbsmaster_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>20</word_id> - <id>371</id> + <word_id>238</word_id> + <id>355</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -19248,8 +18346,8 @@ </sequence> </normal_column> <normal_column> - <word_id>22</word_id> - <id>372</id> + <word_id>85</word_id> + <id>356</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -19281,18 +18379,18 @@ </sequence> </normal_column> <normal_column> - <word_id>21</word_id> - <id>373</id> + <word_id>87</word_id> + <id>357</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19314,18 +18412,18 @@ </sequence> </normal_column> <normal_column> - <word_id>23</word_id> - <id>374</id> + <word_id>109</word_id> + <id>358</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19347,13 +18445,13 @@ </sequence> </normal_column> <normal_column> - <word_id>201</word_id> - <id>375</id> + <word_id>107</word_id> + <id>359</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19380,18 +18478,18 @@ </sequence> </normal_column> <normal_column> - <word_id>79</word_id> - <id>376</id> + <word_id>26</word_id> + <id>360</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19413,18 +18511,18 @@ </sequence> </normal_column> <normal_column> - <word_id>11</word_id> - <id>377</id> + <word_id>25</word_id> + <id>361</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19446,13 +18544,13 @@ </sequence> </normal_column> <normal_column> - <word_id>12</word_id> - <id>378</id> + <word_id>213</word_id> + <id>362</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19479,18 +18577,18 @@ </sequence> </normal_column> <normal_column> - <word_id>254</word_id> - <id>379</id> + <word_id>5</word_id> + <id>363</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19512,18 +18610,18 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>380</id> + <word_id>19</word_id> + <id>364</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19545,18 +18643,18 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>381</id> + <word_id>51</word_id> + <id>365</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19577,20 +18675,75 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>40</id> + <height>212</height> + <width>133</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1991</x> + <y>1546</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>23</id> + <source>39</source> + <target>40</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnbbsuse_bbs_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtnbbsuse</physical_name> + <logical_name>게시판활용</logical_name> + <description>게시판활용</description> + <constraint></constraint> + <primary_key_name>comtnbbsuse_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>114</word_id> - <id>382</id> + <id>366</id> + <referenced_column>347</referenced_column> + <relation>23</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -19611,19 +18764,19 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>383</id> + <word_id>221</word_id> + <id>367</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -19644,18 +18797,18 @@ </sequence> </normal_column> <normal_column> - <word_id>26</word_id> - <id>384</id> + <word_id>238</word_id> + <id>368</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19677,8 +18830,8 @@ </sequence> </normal_column> <normal_column> - <word_id>25</word_id> - <id>385</id> + <word_id>187</word_id> + <id>369</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -19710,13 +18863,13 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>386</id> + <word_id>87</word_id> + <id>370</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19743,18 +18896,18 @@ </sequence> </normal_column> <normal_column> - <word_id>5</word_id> - <id>387</id> + <word_id>85</word_id> + <id>371</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -19776,13 +18929,13 @@ </sequence> </normal_column> <normal_column> - <word_id>19</word_id> - <id>388</id> + <word_id>107</word_id> + <id>372</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19809,13 +18962,13 @@ </sequence> </normal_column> <normal_column> - <word_id>51</word_id> - <id>389</id> + <word_id>109</word_id> + <id>373</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -19843,6 +18996,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnbbsuse_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>366</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list>

Add a comment

List

Delete comment