jhleem / egov star

임종호 임종호 2022-02-21 @128


            
Index: base3.10/src/main/java/egovframework/com/cmm/interceptor/AuthenticInterceptor.java =================================================================== --- base3.10/src/main/java/egovframework/com/cmm/interceptor/AuthenticInterceptor.java (revision 127) +++ base3.10/src/main/java/egovframework/com/cmm/interceptor/AuthenticInterceptor.java (revision 128) @@ -80,10 +80,10 @@ // 지역 확인(통계에 사용) // ip, 일자로 국가 카운트 - Locale locale = request.getLocale(); - LOGGER.error("ip : {}", EgovClntInfo.getClntIP(request)); - LOGGER.error("한글 국가명 : {}", locale.getDisplayCountry(new Locale("ko"))); - LOGGER.error("영문 국가명 : {}", locale.getDisplayCountry(new Locale("en"))); +// Locale locale = request.getLocale(); +// LOGGER.error("ip : {}", EgovClntInfo.getClntIP(request)); +// LOGGER.error("한글 국가명 : {}", locale.getDisplayCountry(new Locale("ko"))); +// LOGGER.error("영문 국가명 : {}", locale.getDisplayCountry(new Locale("en"))); // submit 요청인지 ajax 요청인지 구분 String header = request.getHeader("x-requested-with"); Index: base3.10/src/main/resources/egovframework/mapper/com/sym/log/wlg/EgovWebLog_SQL_postgres.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/sym/log/wlg/EgovWebLog_SQL_postgres.xml (revision 127) +++ base3.10/src/main/resources/egovframework/mapper/com/sym/log/wlg/EgovWebLog_SQL_postgres.xml (revision 128) @@ -62,7 +62,7 @@ , a.URL , a.RQESTER_IP , a.RQESTER_ID - , b.USER_NM AS RQESTER_NM + , COALESCE(b.USER_NM, '비로그인') AS RQESTER_NM FROM COMTNWEBLOG a LEFT OUTER JOIN COMVNUSERMASTER b @@ -110,19 +110,21 @@ <!-- 웹 로그 전날 로그 요약 등록 --> <insert id="logInsertWebLogSummary"> <![CDATA[ - INSERT INTO COMTSWEBLOGSUMMARY + INSERT INTO COMTSWEBLOGSUMMARY(occrrnc_de, url, rdcnt, ntn_nm) SELECT TO_CHAR(b.OCCRRNC_DE, 'YYYYmmdd' ) , b.URL , COUNT(TO_CHAR(b.OCCRRNC_DE, 'YYYYmmdd' )) AS RDCNT + , b.ntn_nm FROM COMTNWEBLOG b WHERE NOT EXISTS (SELECT c.OCCRRNC_DE FROM COMTSWEBLOGSUMMARY c WHERE c.OCCRRNC_DE = TO_CHAR(now() - interval '1 day', 'YYYYmmdd') ) AND TO_CHAR(b.OCCRRNC_DE, 'YYYYmmdd' ) = TO_CHAR(now() - interval '1 day', 'YYYYmmdd') + AND ntn_nm IS NOT NULL GROUP BY TO_CHAR(b.OCCRRNC_DE, 'YYYYmmdd' ) , b.URL - + , b.ntn_nm ]]> </insert> Index: base3.10/script/postgres.erm =================================================================== --- base3.10/script/postgres.erm (revision 127) +++ base3.10/script/postgres.erm (revision 128) @@ -10,8 +10,8 @@ <right_margin>30</right_margin> </page_setting> <category_index>0</category_index> - <zoom>0.75</zoom> - <x>1105</x> + <zoom>1.5</zoom> + <x>1757</x> <y>0</y> <default_color> <r>128</r> @@ -112,7 +112,7 @@ <show_referred_tables>false</show_referred_tables> <categories> <category> - <id>35</id> + <id>36</id> <height>277</height> <width>841</width> <font_name>맑은 고딕</font_name> @@ -128,12 +128,12 @@ </connections> <name>기타</name> <selected>true</selected> - <node_element>11</node_element> - <node_element>15</node_element> - <node_element>32</node_element> + <node_element>10</node_element> + <node_element>14</node_element> + <node_element>31</node_element> </category> <category> - <id>36</id> + <id>37</id> <height>400</height> <width>941</width> <font_name>맑은 고딕</font_name> @@ -149,12 +149,12 @@ </connections> <name>공통코드</name> <selected>true</selected> - <node_element>16</node_element> + <node_element>15</node_element> + <node_element>11</node_element> <node_element>12</node_element> - <node_element>13</node_element> </category> <category> - <id>37</id> + <id>38</id> <height>864</height> <width>1632</width> <font_name>맑은 고딕</font_name> @@ -170,17 +170,17 @@ </connections> <name>권한&amp;메뉴</name> <selected>true</selected> - <node_element>9</node_element> - <node_element>20</node_element> <node_element>8</node_element> - <node_element>3</node_element> - <node_element>28</node_element> + <node_element>19</node_element> + <node_element>7</node_element> + <node_element>2</node_element> <node_element>27</node_element> - <node_element>31</node_element> <node_element>26</node_element> + <node_element>30</node_element> + <node_element>25</node_element> </category> <category> - <id>38</id> + <id>39</id> <height>1185</height> <width>1592</width> <font_name>맑은 고딕</font_name> @@ -197,18 +197,18 @@ <name>사용자</name> <selected>true</selected> <node_element>0</node_element> - <node_element>10</node_element> - <node_element>17</node_element> - <node_element>21</node_element> - <node_element>5</node_element> + <node_element>9</node_element> + <node_element>16</node_element> + <node_element>20</node_element> <node_element>4</node_element> - <node_element>6</node_element> - <node_element>19</node_element> + <node_element>3</node_element> + <node_element>5</node_element> + <node_element>18</node_element> </category> <category> - <id>39</id> + <id>40</id> <height>440</height> - <width>1788</width> + <width>1380</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> <x>1164</x> @@ -222,16 +222,17 @@ </connections> <name>로그</name> <selected>true</selected> + <node_element>33</node_element> + <node_element>17</node_element> + <node_element>13</node_element> + <node_element>21</node_element> <node_element>1</node_element> - <node_element>18</node_element> - <node_element>14</node_element> - <node_element>22</node_element> - <node_element>2</node_element> - <node_element>24</node_element> + <node_element>23</node_element> <node_element>34</node_element> + <node_element>35</node_element> </category> <category> - <id>40</id> + <id>41</id> <height>1041</height> <width>1296</width> <font_name>맑은 고딕</font_name> @@ -247,12 +248,12 @@ </connections> <name>게시판</name> <selected>true</selected> + <node_element>28</node_element> <node_element>29</node_element> - <node_element>30</node_element> - <node_element>23</node_element> - <node_element>33</node_element> - <node_element>7</node_element> - <node_element>25</node_element> + <node_element>22</node_element> + <node_element>32</node_element> + <node_element>6</node_element> + <node_element>24</node_element> </category> </categories> </category_settings> @@ -278,7 +279,7 @@ </connections> <display>false</display> <creation_date>2022-01-26 16:20:32</creation_date> - <updated_date>2022-02-21 09:36:36</updated_date> + <updated_date>2022-02-21 15:24:27</updated_date> <model_property> <name>프로젝트명</name> <value></value> @@ -618,22 +619,6 @@ </word> <word> <id>19</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>avrg_rdcnt</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>20</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -649,7 +634,7 @@ <type>text</type> </word> <word> - <id>21</id> + <id>20</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -665,7 +650,7 @@ <type>character(n)</type> </word> <word> - <id>22</id> + <id>21</id> <length>2400</length> <decimal>null</decimal> <array>false</array> @@ -681,7 +666,7 @@ <type>varchar(n)</type> </word> <word> - <id>23</id> + <id>22</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -697,7 +682,7 @@ <type>varchar(n)</type> </word> <word> - <id>24</id> + <id>23</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -713,7 +698,7 @@ <type>character(n)</type> </word> <word> - <id>25</id> + <id>24</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -729,7 +714,7 @@ <type>varchar(n)</type> </word> <word> - <id>26</id> + <id>25</id> <length>2</length> <decimal>null</decimal> <array>false</array> @@ -745,7 +730,7 @@ <type>character(n)</type> </word> <word> - <id>27</id> + <id>26</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -761,7 +746,7 @@ <type>character(n)</type> </word> <word> - <id>28</id> + <id>27</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -777,7 +762,7 @@ <type>character(n)</type> </word> <word> - <id>29</id> + <id>28</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -793,7 +778,7 @@ <type>character(n)</type> </word> <word> - <id>30</id> + <id>29</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -809,7 +794,7 @@ <type>timestamp</type> </word> <word> - <id>31</id> + <id>30</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -825,7 +810,7 @@ <type>character(n)</type> </word> <word> - <id>32</id> + <id>31</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -841,7 +826,7 @@ <type>varchar(n)</type> </word> <word> - <id>33</id> + <id>32</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -857,7 +842,7 @@ <type>varchar(n)</type> </word> <word> - <id>34</id> + <id>33</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -873,7 +858,7 @@ <type>varchar(n)</type> </word> <word> - <id>35</id> + <id>34</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -889,7 +874,7 @@ <type>varchar(n)</type> </word> <word> - <id>36</id> + <id>35</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -905,7 +890,7 @@ <type>varchar(n)</type> </word> <word> - <id>37</id> + <id>36</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -921,7 +906,7 @@ <type>varchar(n)</type> </word> <word> - <id>38</id> + <id>37</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -937,7 +922,7 @@ <type>varchar(n)</type> </word> <word> - <id>39</id> + <id>38</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -953,7 +938,7 @@ <type>varchar(n)</type> </word> <word> - <id>40</id> + <id>39</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -969,7 +954,7 @@ <type>varchar(n)</type> </word> <word> - <id>41</id> + <id>40</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -985,7 +970,7 @@ <type>varchar(n)</type> </word> <word> - <id>42</id> + <id>41</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -1001,7 +986,7 @@ <type>varchar(n)</type> </word> <word> - <id>43</id> + <id>42</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1017,7 +1002,7 @@ <type>character(n)</type> </word> <word> - <id>44</id> + <id>43</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1033,7 +1018,7 @@ <type>varchar(n)</type> </word> <word> - <id>45</id> + <id>44</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1049,7 +1034,7 @@ <type>varchar(n)</type> </word> <word> - <id>46</id> + <id>45</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1065,7 +1050,7 @@ <type>varchar(n)</type> </word> <word> - <id>47</id> + <id>46</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -1081,7 +1066,7 @@ <type>varchar(n)</type> </word> <word> - <id>48</id> + <id>47</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1097,7 +1082,7 @@ <type>varchar(n)</type> </word> <word> - <id>49</id> + <id>48</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -1113,23 +1098,7 @@ <type>varchar(n)</type> </word> <word> - <id>50</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>creat_co</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>51</id> + <id>49</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1145,7 +1114,7 @@ <type>numeric(p)</type> </word> <word> - <id>52</id> + <id>50</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1161,7 +1130,7 @@ <type>numeric(p)</type> </word> <word> - <id>53</id> + <id>51</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1177,7 +1146,7 @@ <type>timestamp</type> </word> <word> - <id>54</id> + <id>52</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1193,7 +1162,7 @@ <type>varchar(n)</type> </word> <word> - <id>55</id> + <id>53</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -1209,7 +1178,7 @@ <type>varchar(n)</type> </word> <word> - <id>56</id> + <id>54</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -1225,7 +1194,7 @@ <type>varchar(n)</type> </word> <word> - <id>57</id> + <id>55</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -1241,7 +1210,7 @@ <type>character(n)</type> </word> <word> - <id>58</id> + <id>56</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1257,7 +1226,7 @@ <type>numeric(p)</type> </word> <word> - <id>59</id> + <id>57</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1273,7 +1242,7 @@ <type>numeric(p)</type> </word> <word> - <id>60</id> + <id>58</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1289,23 +1258,7 @@ <type>varchar(n)</type> </word> <word> - <id>61</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>detail_stats_se</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>62</id> + <id>59</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1321,7 +1274,7 @@ <type>char</type> </word> <word> - <id>63</id> + <id>60</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -1337,7 +1290,7 @@ <type>varchar(n)</type> </word> <word> - <id>64</id> + <id>61</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1353,7 +1306,7 @@ <type>varchar(n)</type> </word> <word> - <id>65</id> + <id>62</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1369,7 +1322,7 @@ <type>char</type> </word> <word> - <id>66</id> + <id>63</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1385,7 +1338,7 @@ <type>varchar(n)</type> </word> <word> - <id>67</id> + <id>64</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1401,7 +1354,7 @@ <type>varchar(n)</type> </word> <word> - <id>68</id> + <id>65</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1417,7 +1370,7 @@ <type>varchar(n)</type> </word> <word> - <id>69</id> + <id>66</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1433,7 +1386,7 @@ <type>varchar(n)</type> </word> <word> - <id>70</id> + <id>67</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -1449,7 +1402,7 @@ <type>varchar(n)</type> </word> <word> - <id>71</id> + <id>68</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1465,7 +1418,7 @@ <type>varchar(n)</type> </word> <word> - <id>72</id> + <id>69</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1481,7 +1434,7 @@ <type>varchar(n)</type> </word> <word> - <id>73</id> + <id>70</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -1497,7 +1450,7 @@ <type>varchar(n)</type> </word> <word> - <id>74</id> + <id>71</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1513,7 +1466,7 @@ <type>varchar(n)</type> </word> <word> - <id>75</id> + <id>72</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -1529,7 +1482,7 @@ <type>character(n)</type> </word> <word> - <id>76</id> + <id>73</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1545,7 +1498,7 @@ <type>numeric(p)</type> </word> <word> - <id>77</id> + <id>74</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1561,7 +1514,7 @@ <type>numeric(p)</type> </word> <word> - <id>78</id> + <id>75</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -1577,7 +1530,7 @@ <type>character(n)</type> </word> <word> - <id>79</id> + <id>76</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1593,7 +1546,7 @@ <type>char</type> </word> <word> - <id>80</id> + <id>77</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1609,7 +1562,7 @@ <type>char</type> </word> <word> - <id>81</id> + <id>78</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1625,7 +1578,7 @@ <type>character(n)</type> </word> <word> - <id>82</id> + <id>79</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1641,7 +1594,7 @@ <type>character(n)</type> </word> <word> - <id>83</id> + <id>80</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1657,7 +1610,7 @@ <type>char</type> </word> <word> - <id>84</id> + <id>81</id> <length>32</length> <decimal>null</decimal> <array>false</array> @@ -1673,7 +1626,7 @@ <type>varchar(n)</type> </word> <word> - <id>85</id> + <id>82</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1689,7 +1642,7 @@ <type>varchar(n)</type> </word> <word> - <id>86</id> + <id>83</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -1705,7 +1658,7 @@ <type>numeric(p)</type> </word> <word> - <id>87</id> + <id>84</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1721,7 +1674,7 @@ <type>varchar(n)</type> </word> <word> - <id>88</id> + <id>85</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1737,7 +1690,7 @@ <type>varchar(n)</type> </word> <word> - <id>89</id> + <id>86</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1753,7 +1706,7 @@ <type>timestamp</type> </word> <word> - <id>90</id> + <id>87</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1769,7 +1722,7 @@ <type>timestamp</type> </word> <word> - <id>91</id> + <id>88</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1785,7 +1738,7 @@ <type>text</type> </word> <word> - <id>92</id> + <id>89</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1801,7 +1754,7 @@ <type>varchar(n)</type> </word> <word> - <id>93</id> + <id>90</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1817,7 +1770,7 @@ <type>timestamp</type> </word> <word> - <id>94</id> + <id>91</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1833,7 +1786,7 @@ <type>varchar(n)</type> </word> <word> - <id>95</id> + <id>92</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1849,7 +1802,7 @@ <type></type> </word> <word> - <id>96</id> + <id>93</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1865,7 +1818,7 @@ <type>character(n)</type> </word> <word> - <id>97</id> + <id>94</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -1881,7 +1834,7 @@ <type>varchar(n)</type> </word> <word> - <id>98</id> + <id>95</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1897,7 +1850,7 @@ <type>varchar(n)</type> </word> <word> - <id>99</id> + <id>96</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1913,7 +1866,7 @@ <type>varchar(n)</type> </word> <word> - <id>100</id> + <id>97</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1929,7 +1882,7 @@ <type>varchar(n)</type> </word> <word> - <id>101</id> + <id>98</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -1945,7 +1898,7 @@ <type>numeric(p)</type> </word> <word> - <id>102</id> + <id>99</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1961,7 +1914,7 @@ <type>varchar(n)</type> </word> <word> - <id>103</id> + <id>100</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -1977,7 +1930,7 @@ <type>varchar(n)</type> </word> <word> - <id>104</id> + <id>101</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1993,7 +1946,7 @@ <type>char</type> </word> <word> - <id>105</id> + <id>102</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2009,7 +1962,7 @@ <type>char</type> </word> <word> - <id>106</id> + <id>103</id> <length>7</length> <decimal>null</decimal> <array>false</array> @@ -2025,7 +1978,7 @@ <type>character(n)</type> </word> <word> - <id>107</id> + <id>104</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -2041,7 +1994,7 @@ <type>varchar(n)</type> </word> <word> - <id>108</id> + <id>105</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2057,7 +2010,7 @@ <type>character(n)</type> </word> <word> - <id>109</id> + <id>106</id> <length>13</length> <decimal>null</decimal> <array>false</array> @@ -2073,7 +2026,7 @@ <type>varchar(n)</type> </word> <word> - <id>110</id> + <id>107</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2089,7 +2042,7 @@ <type>timestamp</type> </word> <word> - <id>111</id> + <id>108</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2105,7 +2058,7 @@ <type>timestamp</type> </word> <word> - <id>112</id> + <id>109</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2121,7 +2074,7 @@ <type>varchar(n)</type> </word> <word> - <id>113</id> + <id>110</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2137,7 +2090,7 @@ <type>varchar(n)</type> </word> <word> - <id>114</id> + <id>111</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2153,7 +2106,7 @@ <type>text</type> </word> <word> - <id>115</id> + <id>112</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2169,7 +2122,7 @@ <type>char</type> </word> <word> - <id>116</id> + <id>113</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2185,7 +2138,7 @@ <type>char</type> </word> <word> - <id>117</id> + <id>114</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2201,7 +2154,7 @@ <type>numeric(p)</type> </word> <word> - <id>118</id> + <id>115</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2217,7 +2170,7 @@ <type>timestamp</type> </word> <word> - <id>119</id> + <id>116</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2233,7 +2186,7 @@ <type>character(n)</type> </word> <word> - <id>120</id> + <id>117</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2249,7 +2202,7 @@ <type>varchar(n)</type> </word> <word> - <id>121</id> + <id>118</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2265,7 +2218,7 @@ <type>varchar(n)</type> </word> <word> - <id>122</id> + <id>119</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2281,7 +2234,7 @@ <type>varchar(n)</type> </word> <word> - <id>123</id> + <id>120</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2297,7 +2250,7 @@ <type>varchar(n)</type> </word> <word> - <id>124</id> + <id>121</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -2313,7 +2266,7 @@ <type>varchar(n)</type> </word> <word> - <id>125</id> + <id>122</id> <length>5</length> <decimal>null</decimal> <array>false</array> @@ -2329,7 +2282,7 @@ <type>character(n)</type> </word> <word> - <id>126</id> + <id>123</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2345,7 +2298,7 @@ <type>varchar(n)</type> </word> <word> - <id>127</id> + <id>124</id> <length>250</length> <decimal>null</decimal> <array>false</array> @@ -2361,7 +2314,7 @@ <type>varchar(n)</type> </word> <word> - <id>128</id> + <id>125</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -2377,7 +2330,7 @@ <type>varchar(n)</type> </word> <word> - <id>129</id> + <id>126</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2393,7 +2346,7 @@ <type>varchar(n)</type> </word> <word> - <id>130</id> + <id>127</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2409,7 +2362,7 @@ <type>varchar(n)</type> </word> <word> - <id>131</id> + <id>128</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2425,7 +2378,7 @@ <type>integer</type> </word> <word> - <id>132</id> + <id>129</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2441,7 +2394,7 @@ <type>varchar(n)</type> </word> <word> - <id>133</id> + <id>130</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2457,7 +2410,7 @@ <type>varchar(n)</type> </word> <word> - <id>134</id> + <id>131</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -2473,7 +2426,7 @@ <type>varchar(n)</type> </word> <word> - <id>135</id> + <id>132</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2489,23 +2442,7 @@ <type>text</type> </word> <word> - <id>136</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>mumm_inqire_bbsctt_id</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>137</id> + <id>133</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -2521,7 +2458,7 @@ <type>numeric(p)</type> </word> <word> - <id>138</id> + <id>134</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2537,7 +2474,7 @@ <type>char</type> </word> <word> - <id>139</id> + <id>135</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2553,7 +2490,7 @@ <type>character(n)</type> </word> <word> - <id>140</id> + <id>136</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2569,7 +2506,7 @@ <type>character(n)</type> </word> <word> - <id>141</id> + <id>137</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2585,7 +2522,7 @@ <type>varchar(n)</type> </word> <word> - <id>142</id> + <id>138</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2601,7 +2538,39 @@ <type>varchar(n)</type> </word> <word> - <id>143</id> + <id>139</id> + <length>100</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>false</char_semantics> + <description>국가명</description> + <logical_name>국가명</logical_name> + <physical_name>ntn_nm</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>140</id> + <length>100</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>false</char_semantics> + <description>국가명</description> + <logical_name>국가명</logical_name> + <physical_name>ntn_nm</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>141</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2617,7 +2586,7 @@ <type>text</type> </word> <word> - <id>144</id> + <id>142</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2633,7 +2602,7 @@ <type>numeric(p)</type> </word> <word> - <id>145</id> + <id>143</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2649,7 +2618,7 @@ <type>numeric(p)</type> </word> <word> - <id>146</id> + <id>144</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -2665,7 +2634,7 @@ <type>varchar(n)</type> </word> <word> - <id>147</id> + <id>145</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2681,7 +2650,7 @@ <type>character(n)</type> </word> <word> - <id>148</id> + <id>146</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2697,23 +2666,7 @@ <type>character(n)</type> </word> <word> - <id>149</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>발생일</description> - <logical_name>발생일</logical_name> - <physical_name>occrrnc_de</physical_name> - <type>character(n)</type> - </word> - <word> - <id>150</id> + <id>147</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2729,7 +2682,7 @@ <type>timestamp</type> </word> <word> - <id>151</id> + <id>148</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2745,7 +2698,7 @@ <type>varchar(n)</type> </word> <word> - <id>152</id> + <id>149</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2761,7 +2714,7 @@ <type>varchar(n)</type> </word> <word> - <id>153</id> + <id>150</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2777,7 +2730,7 @@ <type>varchar(n)</type> </word> <word> - <id>154</id> + <id>151</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2793,7 +2746,7 @@ <type></type> </word> <word> - <id>155</id> + <id>152</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2809,7 +2762,7 @@ <type>character(n)</type> </word> <word> - <id>156</id> + <id>153</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2825,7 +2778,7 @@ <type>varchar(n)</type> </word> <word> - <id>157</id> + <id>154</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2841,7 +2794,7 @@ <type>text</type> </word> <word> - <id>158</id> + <id>155</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2857,7 +2810,7 @@ <type>numeric(p)</type> </word> <word> - <id>159</id> + <id>156</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2873,7 +2826,7 @@ <type>numeric(p)</type> </word> <word> - <id>160</id> + <id>157</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2889,7 +2842,7 @@ <type>numeric(p)</type> </word> <word> - <id>161</id> + <id>158</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -2905,7 +2858,7 @@ <type>varchar(n)</type> </word> <word> - <id>162</id> + <id>159</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -2921,7 +2874,7 @@ <type>varchar(n)</type> </word> <word> - <id>163</id> + <id>160</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2937,7 +2890,7 @@ <type>varchar(n)</type> </word> <word> - <id>164</id> + <id>161</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2953,7 +2906,7 @@ <type>varchar(n)</type> </word> <word> - <id>165</id> + <id>162</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2969,7 +2922,7 @@ <type>numeric(p)</type> </word> <word> - <id>166</id> + <id>163</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2985,7 +2938,7 @@ <type>character(n)</type> </word> <word> - <id>167</id> + <id>164</id> <length>14</length> <decimal>null</decimal> <array>false</array> @@ -3001,7 +2954,7 @@ <type>varchar(n)</type> </word> <word> - <id>168</id> + <id>165</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -3017,7 +2970,7 @@ <type>varchar(n)</type> </word> <word> - <id>169</id> + <id>166</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3033,7 +2986,7 @@ <type>varchar(n)</type> </word> <word> - <id>170</id> + <id>167</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3049,7 +3002,7 @@ <type>varchar(n)</type> </word> <word> - <id>171</id> + <id>168</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3065,7 +3018,7 @@ <type>character(n)</type> </word> <word> - <id>172</id> + <id>169</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3081,7 +3034,7 @@ <type>numeric(p)</type> </word> <word> - <id>173</id> + <id>170</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3097,7 +3050,7 @@ <type>numeric(p)</type> </word> <word> - <id>174</id> + <id>171</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3113,7 +3066,7 @@ <type>varchar(n)</type> </word> <word> - <id>175</id> + <id>172</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3129,7 +3082,7 @@ <type>timestamp</type> </word> <word> - <id>176</id> + <id>173</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3145,7 +3098,7 @@ <type>character(n)</type> </word> <word> - <id>177</id> + <id>174</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3161,7 +3114,7 @@ <type>varchar(n)</type> </word> <word> - <id>178</id> + <id>175</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3177,7 +3130,7 @@ <type>char</type> </word> <word> - <id>179</id> + <id>176</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3193,7 +3146,7 @@ <type>varchar(n)</type> </word> <word> - <id>180</id> + <id>177</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3209,7 +3162,7 @@ <type>varchar(n)</type> </word> <word> - <id>181</id> + <id>178</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3225,7 +3178,7 @@ <type>timestamp</type> </word> <word> - <id>182</id> + <id>179</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3241,7 +3194,7 @@ <type>varchar(n)</type> </word> <word> - <id>183</id> + <id>180</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3257,7 +3210,7 @@ <type>varchar(n)</type> </word> <word> - <id>184</id> + <id>181</id> <length>300</length> <decimal>null</decimal> <array>false</array> @@ -3273,7 +3226,7 @@ <type>varchar(n)</type> </word> <word> - <id>185</id> + <id>182</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3289,7 +3242,7 @@ <type>varchar(n)</type> </word> <word> - <id>186</id> + <id>183</id> <length>80</length> <decimal>null</decimal> <array>false</array> @@ -3305,7 +3258,7 @@ <type>varchar(n)</type> </word> <word> - <id>187</id> + <id>184</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3321,7 +3274,7 @@ <type>text</type> </word> <word> - <id>188</id> + <id>185</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3337,7 +3290,7 @@ <type>varchar(n)</type> </word> <word> - <id>189</id> + <id>186</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3353,7 +3306,7 @@ <type>varchar(n)</type> </word> <word> - <id>190</id> + <id>187</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -3369,7 +3322,7 @@ <type>varchar(n)</type> </word> <word> - <id>191</id> + <id>188</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -3385,7 +3338,7 @@ <type>character(n)</type> </word> <word> - <id>192</id> + <id>189</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3401,7 +3354,7 @@ <type>timestamp</type> </word> <word> - <id>193</id> + <id>190</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3417,7 +3370,7 @@ <type>varchar(n)</type> </word> <word> - <id>194</id> + <id>191</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3433,7 +3386,7 @@ <type>char</type> </word> <word> - <id>195</id> + <id>192</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3449,7 +3402,7 @@ <type>char</type> </word> <word> - <id>196</id> + <id>193</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3465,7 +3418,7 @@ <type>char</type> </word> <word> - <id>197</id> + <id>194</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3481,7 +3434,7 @@ <type>text</type> </word> <word> - <id>198</id> + <id>195</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3497,23 +3450,7 @@ <type>numeric(p)</type> </word> <word> - <id>199</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>stats_se</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>200</id> + <id>196</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3529,7 +3466,7 @@ <type>char</type> </word> <word> - <id>201</id> + <id>197</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3545,7 +3482,7 @@ <type>varchar(n)</type> </word> <word> - <id>202</id> + <id>198</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3561,7 +3498,7 @@ <type>varchar(n)</type> </word> <word> - <id>203</id> + <id>199</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3577,7 +3514,7 @@ <type>text</type> </word> <word> - <id>204</id> + <id>200</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3593,7 +3530,7 @@ <type>text</type> </word> <word> - <id>205</id> + <id>201</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3609,7 +3546,7 @@ <type>numeric(p)</type> </word> <word> - <id>206</id> + <id>202</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -3625,7 +3562,7 @@ <type>varchar(n)</type> </word> <word> - <id>207</id> + <id>203</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3641,55 +3578,7 @@ <type>varchar(n)</type> </word> <word> - <id>208</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>top_inqire_bbsctt_id</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>209</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>top_ntcr_id</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>210</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>tot_rdcnt</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>211</id> + <id>204</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3705,7 +3594,7 @@ <type>character(n)</type> </word> <word> - <id>212</id> + <id>205</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3721,7 +3610,7 @@ <type>varchar(n)</type> </word> <word> - <id>213</id> + <id>206</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3737,7 +3626,7 @@ <type>numeric(p)</type> </word> <word> - <id>214</id> + <id>207</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3753,7 +3642,7 @@ <type>numeric(p)</type> </word> <word> - <id>215</id> + <id>208</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3769,7 +3658,7 @@ <type>timestamp</type> </word> <word> - <id>216</id> + <id>209</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3785,7 +3674,7 @@ <type>varchar(n)</type> </word> <word> - <id>217</id> + <id>210</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3801,7 +3690,7 @@ <type>text</type> </word> <word> - <id>218</id> + <id>211</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3817,7 +3706,7 @@ <type>varchar(n)</type> </word> <word> - <id>219</id> + <id>212</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3833,7 +3722,7 @@ <type>varchar(n)</type> </word> <word> - <id>220</id> + <id>213</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3849,7 +3738,7 @@ <type>varchar(n)</type> </word> <word> - <id>221</id> + <id>214</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3865,7 +3754,7 @@ <type>varchar(n)</type> </word> <word> - <id>222</id> + <id>215</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3881,7 +3770,7 @@ <type>varchar(n)</type> </word> <word> - <id>223</id> + <id>216</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3897,7 +3786,7 @@ <type>varchar(n)</type> </word> <word> - <id>224</id> + <id>217</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3913,7 +3802,7 @@ <type>varchar(n)</type> </word> <word> - <id>225</id> + <id>218</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3929,7 +3818,7 @@ <type></type> </word> <word> - <id>226</id> + <id>219</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3945,7 +3834,7 @@ <type>varchar(n)</type> </word> <word> - <id>227</id> + <id>220</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3961,7 +3850,7 @@ <type>char</type> </word> <word> - <id>228</id> + <id>221</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -3977,7 +3866,7 @@ <type>varchar(n)</type> </word> <word> - <id>229</id> + <id>222</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3993,7 +3882,7 @@ <type>varchar(n)</type> </word> <word> - <id>230</id> + <id>223</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4009,7 +3898,7 @@ <type>varchar(n)</type> </word> <word> - <id>231</id> + <id>224</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -4049,7 +3938,7 @@ <sql>SELECT comtngnrlmber.esntl_id,&#x0D;&#x0A; comtngnrlmber.mber_id AS user_id,&#x0D;&#x0A; comtngnrlmber.password,&#x0D;&#x0A; comtngnrlmber.mber_nm AS user_nm,&#x0D;&#x0A; comtngnrlmber.zip AS user_zip,&#x0D;&#x0A; comtngnrlmber.adres AS user_adres,&#x0D;&#x0A; comtngnrlmber.mber_email_adres AS user_email,&#x0D;&#x0A; &apos; &apos;::bpchar AS group_id,&#x0D;&#x0A; &apos;GNR&apos;::text AS user_se,&#x0D;&#x0A; &apos; &apos;::bpchar AS orgnzt_id&#x0D;&#x0A; FROM comtngnrlmber&#x0D;&#x0A;UNION ALL&#x0D;&#x0A; SELECT comtnemplyrinfo.esntl_id,&#x0D;&#x0A; comtnemplyrinfo.emplyr_id AS user_id,&#x0D;&#x0A; comtnemplyrinfo.password,&#x0D;&#x0A; comtnemplyrinfo.user_nm,&#x0D;&#x0A; comtnemplyrinfo.zip AS user_zip,&#x0D;&#x0A; comtnemplyrinfo.house_adres AS user_adres,&#x0D;&#x0A; comtnemplyrinfo.email_adres AS user_email,&#x0D;&#x0A; comtnemplyrinfo.group_id,&#x0D;&#x0A; &apos;USR&apos;::text AS user_se,&#x0D;&#x0A; comtnemplyrinfo.orgnzt_id&#x0D;&#x0A; FROM comtnemplyrinfo&#x0D;&#x0A;UNION ALL&#x0D;&#x0A; SELECT comtnentrprsmber.esntl_id,&#x0D;&#x0A; comtnentrprsmber.entrprs_mber_id AS user_id,&#x0D;&#x0A; comtnentrprsmber.entrprs_mber_password AS password,&#x0D;&#x0A; comtnentrprsmber.cmpny_nm AS user_nm,&#x0D;&#x0A; comtnentrprsmber.zip AS user_zip,&#x0D;&#x0A; comtnentrprsmber.adres AS user_adres,&#x0D;&#x0A; comtnentrprsmber.applcnt_email_adres AS user_email,&#x0D;&#x0A; &apos; &apos;::bpchar AS group_id,&#x0D;&#x0A; &apos;ENT&apos;::text AS user_se,&#x0D;&#x0A; &apos; &apos;::bpchar AS orgnzt_id&#x0D;&#x0A; FROM comtnentrprsmber&#x0D;&#x0A; ORDER BY 1;</sql> <columns> <normal_column> - <word_id>82</word_id> + <word_id>79</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4082,7 +3971,7 @@ </sequence> </normal_column> <normal_column> - <word_id>222</word_id> + <word_id>215</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4115,7 +4004,7 @@ </sequence> </normal_column> <normal_column> - <word_id>161</word_id> + <word_id>159</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4148,7 +4037,7 @@ </sequence> </normal_column> <normal_column> - <word_id>224</word_id> + <word_id>217</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4181,7 +4070,7 @@ </sequence> </normal_column> <normal_column> - <word_id>226</word_id> + <word_id>219</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4214,7 +4103,7 @@ </sequence> </normal_column> <normal_column> - <word_id>219</word_id> + <word_id>212</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4247,7 +4136,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>213</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4280,7 +4169,7 @@ </sequence> </normal_column> <normal_column> - <word_id>95</word_id> + <word_id>92</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4313,7 +4202,7 @@ </sequence> </normal_column> <normal_column> - <word_id>225</word_id> + <word_id>218</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4346,7 +4235,7 @@ </sequence> </normal_column> <normal_column> - <word_id>154</word_id> + <word_id>151</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4385,11 +4274,11 @@ </view> <table> <id>1</id> - <height>107</height> - <width>244</width> + <height>233</height> + <width>258</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1392</x> + <x>1974</x> <y>114</y> <color> <r>128</r> @@ -4398,15 +4287,15 @@ </color> <connections> </connections> - <physical_name>comtsweblogsummary</physical_name> - <logical_name>웹로그 요약</logical_name> - <description>웹로그 요약</description> + <physical_name>comtssyslogsummary</physical_name> + <logical_name>시스템로그요약</logical_name> + <description>시스템로그요약</description> <constraint></constraint> - <primary_key_name>comtsweblogsummary_pkey</primary_key_name> + <primary_key_name>comtssyslogsummary_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>147</word_id> + <word_id>145</word_id> <id>0</id> <description></description> <unique_key_name></unique_key_name> @@ -4439,7 +4328,7 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> + <word_id>197</word_id> <id>1</id> <description></description> <unique_key_name></unique_key_name> @@ -4472,19 +4361,19 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> + <word_id>129</word_id> <id>2</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> @@ -4504,52 +4393,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>2</id> - <height>233</height> - <width>258</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1974</x> - <y>114</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtssyslogsummary</physical_name> - <logical_name>시스템로그요약</logical_name> - <description>시스템로그요약</description> - <constraint></constraint> - <primary_key_name>comtssyslogsummary_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>147</word_id> + <word_id>50</word_id> <id>3</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> <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> @@ -4570,19 +4427,19 @@ </sequence> </normal_column> <normal_column> - <word_id>201</word_id> + <word_id>206</word_id> <id>4</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>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> @@ -4603,45 +4460,12 @@ </sequence> </normal_column> <normal_column> - <word_id>133</word_id> + <word_id>170</word_id> <id>5</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>51</word_id> - <id>6</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> @@ -4669,8 +4493,8 @@ </sequence> </normal_column> <normal_column> - <word_id>213</word_id> - <id>7</id> + <word_id>56</word_id> + <id>6</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -4702,8 +4526,8 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> - <id>8</id> + <word_id>156</word_id> + <id>7</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -4735,74 +4559,8 @@ </sequence> </normal_column> <normal_column> - <word_id>59</word_id> - <id>9</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <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> - <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>159</word_id> - <id>10</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <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> - <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>77</word_id> - <id>11</id> + <word_id>74</word_id> + <id>8</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -4844,7 +4602,7 @@ </table_properties> </table> <table> - <id>3</id> + <id>2</id> <height>86</height> <width>167</width> <font_name>맑은 고딕</font_name> @@ -4859,8 +4617,8 @@ <connections> <relation> <id>0</id> - <source>9</source> - <target>3</target> + <source>8</source> + <target>2</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -4870,10 +4628,10 @@ <g>0</g> <b>0</b> </color> - <child_cardinality>1</child_cardinality> + <child_cardinality>1..n</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnroles_hierarchy_parnts_role_fkey</name> + <name>comtnroles_hierarchy_chldrn_role_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -4881,8 +4639,8 @@ </relation> <relation> <id>1</id> - <source>9</source> - <target>3</target> + <source>8</source> + <target>2</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -4892,10 +4650,10 @@ <g>0</g> <b>0</b> </color> - <child_cardinality>1..n</child_cardinality> + <child_cardinality>1</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnroles_hierarchy_chldrn_role_fkey</name> + <name>comtnroles_hierarchy_parnts_role_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -4910,9 +4668,9 @@ <option></option> <columns> <normal_column> - <id>12</id> - <referenced_column>86</referenced_column> - <relation>0</relation> + <id>9</id> + <referenced_column>83</referenced_column> + <relation>1</relation> <description>부모롤</description> <unique_key_name></unique_key_name> <logical_name>부모롤</logical_name> @@ -4944,9 +4702,9 @@ </sequence> </normal_column> <normal_column> - <id>13</id> - <referenced_column>86</referenced_column> - <relation>1</relation> + <id>10</id> + <referenced_column>83</referenced_column> + <relation>0</relation> <description>자식롤</description> <unique_key_name></unique_key_name> <logical_name>자식롤</logical_name> @@ -4987,7 +4745,7 @@ <description></description> <columns> <column> - <id>13</id> + <id>10</id> <desc>false</desc> </column> </columns> @@ -5001,7 +4759,7 @@ </table_properties> </table> <table> - <id>4</id> + <id>3</id> <height>107</height> <width>144</width> <font_name>맑은 고딕</font_name> @@ -5023,8 +4781,8 @@ <option></option> <columns> <normal_column> - <word_id>155</word_id> - <id>14</id> + <word_id>152</word_id> + <id>11</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5056,8 +4814,8 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> - <id>15</id> + <word_id>153</word_id> + <id>12</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5089,8 +4847,8 @@ </sequence> </normal_column> <normal_column> - <word_id>153</word_id> - <id>16</id> + <word_id>150</word_id> + <id>13</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5132,7 +4890,7 @@ </table_properties> </table> <table> - <id>5</id> + <id>4</id> <height>632</height> <width>338</width> <font_name>맑은 고딕</font_name> @@ -5147,8 +4905,8 @@ <connections> <relation> <id>2</id> - <source>10</source> - <target>5</target> + <source>9</source> + <target>4</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -5176,8 +4934,8 @@ <option></option> <columns> <normal_column> - <word_id>69</word_id> - <id>17</id> + <word_id>66</word_id> + <id>14</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5209,8 +4967,8 @@ </sequence> </normal_column> <normal_column> - <word_id>75</word_id> - <id>18</id> + <word_id>72</word_id> + <id>15</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5242,8 +5000,8 @@ </sequence> </normal_column> <normal_column> - <word_id>25</word_id> - <id>19</id> + <word_id>24</word_id> + <id>16</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5275,8 +5033,8 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> - <id>20</id> + <word_id>106</word_id> + <id>17</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5308,8 +5066,8 @@ </sequence> </normal_column> <normal_column> - <word_id>34</word_id> - <id>21</id> + <word_id>33</word_id> + <id>18</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5341,8 +5099,8 @@ </sequence> </normal_column> <normal_column> - <word_id>55</word_id> - <id>22</id> + <word_id>53</word_id> + <id>19</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5374,8 +5132,8 @@ </sequence> </normal_column> <normal_column> - <word_id>231</word_id> - <id>23</id> + <word_id>224</word_id> + <id>20</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5408,7 +5166,7 @@ </normal_column> <normal_column> <word_id>0</word_id> - <id>24</id> + <id>21</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5440,8 +5198,8 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> - <id>25</id> + <word_id>71</word_id> + <id>22</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5473,8 +5231,8 @@ </sequence> </normal_column> <normal_column> - <word_id>92</word_id> - <id>26</id> + <word_id>89</word_id> + <id>23</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5506,8 +5264,8 @@ </sequence> </normal_column> <normal_column> - <word_id>104</word_id> - <id>27</id> + <word_id>101</word_id> + <id>24</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5540,7 +5298,7 @@ </normal_column> <normal_column> <word_id>8</word_id> - <id>28</id> + <id>25</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5573,7 +5331,7 @@ </normal_column> <normal_column> <word_id>7</word_id> - <id>29</id> + <id>26</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5605,8 +5363,8 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> - <id>30</id> + <word_id>189</word_id> + <id>27</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5638,8 +5396,8 @@ </sequence> </normal_column> <normal_column> - <word_id>73</word_id> - <id>31</id> + <word_id>70</word_id> + <id>28</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5671,8 +5429,8 @@ </sequence> </normal_column> <normal_column> - <word_id>70</word_id> - <id>32</id> + <word_id>67</word_id> + <id>29</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5704,8 +5462,8 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> - <id>33</id> + <word_id>69</word_id> + <id>30</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5737,8 +5495,8 @@ </sequence> </normal_column> <normal_column> - <word_id>71</word_id> - <id>34</id> + <word_id>68</word_id> + <id>31</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5770,8 +5528,8 @@ </sequence> </normal_column> <normal_column> - <id>35</id> - <referenced_column>90</referenced_column> + <id>32</id> + <referenced_column>87</referenced_column> <relation>2</relation> <description></description> <unique_key_name></unique_key_name> @@ -5804,8 +5562,8 @@ </sequence> </normal_column> <normal_column> - <word_id>60</word_id> - <id>36</id> + <word_id>58</word_id> + <id>33</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5837,8 +5595,8 @@ </sequence> </normal_column> <normal_column> - <word_id>68</word_id> - <id>37</id> + <word_id>65</word_id> + <id>34</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5871,7 +5629,7 @@ </normal_column> <normal_column> <word_id>9</word_id> - <id>38</id> + <id>35</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5904,7 +5662,7 @@ </normal_column> <normal_column> <word_id>6</word_id> - <id>39</id> + <id>36</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5936,8 +5694,8 @@ </sequence> </normal_column> <normal_column> - <word_id>81</word_id> - <id>40</id> + <word_id>78</word_id> + <id>37</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -5969,8 +5727,8 @@ </sequence> </normal_column> <normal_column> - <word_id>116</word_id> - <id>41</id> + <word_id>113</word_id> + <id>38</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6002,8 +5760,8 @@ </sequence> </normal_column> <normal_column> - <word_id>117</word_id> - <id>42</id> + <word_id>114</word_id> + <id>39</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6035,8 +5793,8 @@ </sequence> </normal_column> <normal_column> - <word_id>118</word_id> - <id>43</id> + <word_id>115</word_id> + <id>40</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6068,8 +5826,8 @@ </sequence> </normal_column> <normal_column> - <word_id>30</word_id> - <id>44</id> + <word_id>29</word_id> + <id>41</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6110,7 +5868,7 @@ <description></description> <columns> <column> - <id>35</id> + <id>32</id> <desc>false</desc> </column> </columns> @@ -6124,7 +5882,7 @@ </table_properties> </table> <table> - <id>6</id> + <id>5</id> <height>695</height> <width>284</width> <font_name>맑은 고딕</font_name> @@ -6139,8 +5897,8 @@ <connections> <relation> <id>3</id> - <source>10</source> - <target>6</target> + <source>9</source> + <target>5</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -6161,8 +5919,8 @@ </relation> <relation> <id>4</id> - <source>4</source> - <target>6</target> + <source>3</source> + <target>5</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -6190,8 +5948,8 @@ <option></option> <columns> <normal_column> - <word_id>64</word_id> - <id>45</id> + <word_id>61</word_id> + <id>42</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6223,8 +5981,8 @@ </sequence> </normal_column> <normal_column> - <id>46</id> - <referenced_column>14</referenced_column> + <id>43</id> + <referenced_column>11</referenced_column> <relation>4</relation> <description></description> <unique_key_name></unique_key_name> @@ -6257,8 +6015,8 @@ </sequence> </normal_column> <normal_column> - <word_id>223</word_id> - <id>47</id> + <word_id>216</word_id> + <id>44</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6290,8 +6048,8 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> - <id>48</id> + <word_id>158</word_id> + <id>45</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6323,8 +6081,8 @@ </sequence> </normal_column> <normal_column> - <word_id>66</word_id> - <id>49</id> + <word_id>63</word_id> + <id>46</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6356,8 +6114,8 @@ </sequence> </normal_column> <normal_column> - <word_id>103</word_id> - <id>50</id> + <word_id>100</word_id> + <id>47</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6389,8 +6147,8 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> - <id>51</id> + <word_id>192</word_id> + <id>48</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6422,8 +6180,8 @@ </sequence> </normal_column> <normal_column> - <word_id>28</word_id> - <id>52</id> + <word_id>27</word_id> + <id>49</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6455,8 +6213,8 @@ </sequence> </normal_column> <normal_column> - <word_id>92</word_id> - <id>53</id> + <word_id>89</word_id> + <id>50</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6488,8 +6246,8 @@ </sequence> </normal_column> <normal_column> - <word_id>98</word_id> - <id>54</id> + <word_id>95</word_id> + <id>51</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6521,8 +6279,8 @@ </sequence> </normal_column> <normal_column> - <word_id>164</word_id> - <id>55</id> + <word_id>161</word_id> + <id>52</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6554,8 +6312,8 @@ </sequence> </normal_column> <normal_column> - <word_id>163</word_id> - <id>56</id> + <word_id>160</word_id> + <id>53</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6587,8 +6345,8 @@ </sequence> </normal_column> <normal_column> - <word_id>99</word_id> - <id>57</id> + <word_id>96</word_id> + <id>54</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6621,7 +6379,7 @@ </normal_column> <normal_column> <word_id>9</word_id> - <id>58</id> + <id>55</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6653,8 +6411,8 @@ </sequence> </normal_column> <normal_column> - <word_id>60</word_id> - <id>59</id> + <word_id>58</word_id> + <id>56</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6686,8 +6444,8 @@ </sequence> </normal_column> <normal_column> - <word_id>231</word_id> - <id>60</id> + <word_id>224</word_id> + <id>57</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6719,8 +6477,8 @@ </sequence> </normal_column> <normal_column> - <word_id>152</word_id> - <id>61</id> + <word_id>149</word_id> + <id>58</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6752,8 +6510,8 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> - <id>62</id> + <word_id>123</word_id> + <id>59</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6785,8 +6543,8 @@ </sequence> </normal_column> <normal_column> - <word_id>63</word_id> - <id>63</id> + <word_id>60</word_id> + <id>60</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6818,8 +6576,8 @@ </sequence> </normal_column> <normal_column> - <word_id>151</word_id> - <id>64</id> + <word_id>148</word_id> + <id>61</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6851,8 +6609,8 @@ </sequence> </normal_column> <normal_column> - <word_id>100</word_id> - <id>65</id> + <word_id>97</word_id> + <id>62</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6884,8 +6642,8 @@ </sequence> </normal_column> <normal_column> - <id>66</id> - <referenced_column>90</referenced_column> + <id>63</id> + <referenced_column>87</referenced_column> <relation>3</relation> <description></description> <unique_key_name></unique_key_name> @@ -6918,8 +6676,8 @@ </sequence> </normal_column> <normal_column> - <word_id>171</word_id> - <id>67</id> + <word_id>168</word_id> + <id>64</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6951,8 +6709,8 @@ </sequence> </normal_column> <normal_column> - <word_id>65</word_id> - <id>68</id> + <word_id>62</word_id> + <id>65</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6984,8 +6742,8 @@ </sequence> </normal_column> <normal_column> - <word_id>81</word_id> - <id>69</id> + <word_id>78</word_id> + <id>66</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7017,8 +6775,8 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> - <id>70</id> + <word_id>52</word_id> + <id>67</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7050,8 +6808,8 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> - <id>71</id> + <word_id>189</word_id> + <id>68</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7083,8 +6841,8 @@ </sequence> </normal_column> <normal_column> - <word_id>116</word_id> - <id>72</id> + <word_id>113</word_id> + <id>69</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7116,8 +6874,8 @@ </sequence> </normal_column> <normal_column> - <word_id>117</word_id> - <id>73</id> + <word_id>114</word_id> + <id>70</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7149,8 +6907,8 @@ </sequence> </normal_column> <normal_column> - <word_id>118</word_id> - <id>74</id> + <word_id>115</word_id> + <id>71</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7182,8 +6940,8 @@ </sequence> </normal_column> <normal_column> - <word_id>30</word_id> - <id>75</id> + <word_id>29</word_id> + <id>72</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7224,7 +6982,7 @@ <description></description> <columns> <column> - <id>46</id> + <id>43</id> <desc>false</desc> </column> </columns> @@ -7237,7 +6995,7 @@ <description></description> <columns> <column> - <id>66</id> + <id>63</id> <desc>false</desc> </column> </columns> @@ -7251,7 +7009,7 @@ </table_properties> </table> <table> - <id>7</id> + <id>6</id> <height>191</height> <width>168</width> <font_name>맑은 고딕</font_name> @@ -7273,8 +7031,8 @@ <option></option> <columns> <normal_column> - <word_id>21</word_id> - <id>76</id> + <word_id>20</word_id> + <id>73</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7307,7 +7065,7 @@ </normal_column> <normal_column> <word_id>2</word_id> - <id>77</id> + <id>74</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7339,8 +7097,8 @@ </sequence> </normal_column> <normal_column> - <word_id>200</word_id> - <id>78</id> + <word_id>196</word_id> + <id>75</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7372,8 +7130,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>79</id> + <word_id>87</word_id> + <id>76</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7405,8 +7163,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>80</id> + <word_id>108</word_id> + <id>77</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7438,8 +7196,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>81</id> + <word_id>84</word_id> + <id>78</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7471,8 +7229,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>82</id> + <word_id>109</word_id> + <id>79</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7514,7 +7272,7 @@ </table_properties> </table> <table> - <id>8</id> + <id>7</id> <height>107</height> <width>172</width> <font_name>맑은 고딕</font_name> @@ -7529,8 +7287,8 @@ <connections> <relation> <id>5</id> - <source>28</source> - <target>8</target> + <source>27</source> + <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -7551,8 +7309,8 @@ </relation> <relation> <id>6</id> - <source>9</source> - <target>8</target> + <source>8</source> + <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -7580,8 +7338,8 @@ <option></option> <columns> <normal_column> - <id>83</id> - <referenced_column>86</referenced_column> + <id>80</id> + <referenced_column>83</referenced_column> <relation>6</relation> <description></description> <unique_key_name></unique_key_name> @@ -7614,8 +7372,8 @@ </sequence> </normal_column> <normal_column> - <id>84</id> - <referenced_column>257</referenced_column> + <id>81</id> + <referenced_column>255</referenced_column> <relation>5</relation> <description></description> <unique_key_name></unique_key_name> @@ -7648,8 +7406,8 @@ </sequence> </normal_column> <normal_column> - <word_id>53</word_id> - <id>85</id> + <word_id>51</word_id> + <id>82</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7690,7 +7448,7 @@ <description></description> <columns> <column> - <id>83</id> + <id>80</id> <desc>false</desc> </column> </columns> @@ -7703,7 +7461,7 @@ <description></description> <columns> <column> - <id>84</id> + <id>81</id> <desc>false</desc> </column> </columns> @@ -7717,7 +7475,7 @@ </table_properties> </table> <table> - <id>9</id> + <id>8</id> <height>128</height> <width>144</width> <font_name>맑은 고딕</font_name> @@ -7740,7 +7498,7 @@ <columns> <normal_column> <word_id>14</word_id> - <id>86</id> + <id>83</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7773,7 +7531,7 @@ </normal_column> <normal_column> <word_id>17</word_id> - <id>87</id> + <id>84</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7806,7 +7564,7 @@ </normal_column> <normal_column> <word_id>16</word_id> - <id>88</id> + <id>85</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7839,7 +7597,7 @@ </normal_column> <normal_column> <word_id>15</word_id> - <id>89</id> + <id>86</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7881,7 +7639,7 @@ </table_properties> </table> <table> - <id>10</id> + <id>9</id> <height>128</height> <width>253</width> <font_name>맑은 고딕</font_name> @@ -7903,8 +7661,8 @@ <option></option> <columns> <normal_column> - <word_id>96</word_id> - <id>90</id> + <word_id>93</word_id> + <id>87</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7936,8 +7694,8 @@ </sequence> </normal_column> <normal_column> - <word_id>97</word_id> - <id>91</id> + <word_id>94</word_id> + <id>88</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7969,8 +7727,8 @@ </sequence> </normal_column> <normal_column> - <word_id>93</word_id> - <id>92</id> + <word_id>90</word_id> + <id>89</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8002,8 +7760,8 @@ </sequence> </normal_column> <normal_column> - <word_id>94</word_id> - <id>93</id> + <word_id>91</word_id> + <id>90</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8045,7 +7803,7 @@ </table_properties> </table> <table> - <id>11</id> + <id>10</id> <height>86</height> <width>125</width> <font_name>맑은 고딕</font_name> @@ -8067,8 +7825,8 @@ <option></option> <columns> <normal_column> - <word_id>207</word_id> - <id>94</id> + <word_id>203</word_id> + <id>91</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8100,8 +7858,8 @@ </sequence> </normal_column> <normal_column> - <word_id>137</word_id> - <id>95</id> + <word_id>133</word_id> + <id>92</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8143,7 +7901,7 @@ </table_properties> </table> <table> - <id>12</id> + <id>11</id> <height>233</height> <width>254</width> <font_name>맑은 고딕</font_name> @@ -8158,8 +7916,8 @@ <connections> <relation> <id>7</id> - <source>13</source> - <target>12</target> + <source>12</source> + <target>11</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -8187,8 +7945,8 @@ <option></option> <columns> <normal_column> - <id>96</id> - <referenced_column>105</referenced_column> + <id>93</id> + <referenced_column>102</referenced_column> <relation>7</relation> <description></description> <unique_key_name></unique_key_name> @@ -8221,8 +7979,8 @@ </sequence> </normal_column> <normal_column> - <word_id>35</word_id> - <id>97</id> + <word_id>34</word_id> + <id>94</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8254,8 +8012,8 @@ </sequence> </normal_column> <normal_column> - <word_id>40</word_id> - <id>98</id> + <word_id>39</word_id> + <id>95</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8287,8 +8045,8 @@ </sequence> </normal_column> <normal_column> - <word_id>36</word_id> - <id>99</id> + <word_id>35</word_id> + <id>96</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8320,8 +8078,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>100</id> + <word_id>220</word_id> + <id>97</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8353,8 +8111,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>101</id> + <word_id>87</word_id> + <id>98</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8386,8 +8144,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>102</id> + <word_id>84</word_id> + <id>99</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8419,8 +8177,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>103</id> + <word_id>108</word_id> + <id>100</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8452,8 +8210,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>104</id> + <word_id>109</word_id> + <id>101</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8494,7 +8252,7 @@ <description></description> <columns> <column> - <id>96</id> + <id>93</id> <desc>false</desc> </column> </columns> @@ -8508,7 +8266,7 @@ </table_properties> </table> <table> - <id>13</id> + <id>12</id> <height>233</height> <width>227</width> <font_name>맑은 고딕</font_name> @@ -8523,8 +8281,8 @@ <connections> <relation> <id>8</id> - <source>16</source> - <target>13</target> + <source>15</source> + <target>12</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -8552,8 +8310,8 @@ <option></option> <columns> <normal_column> - <word_id>37</word_id> - <id>105</id> + <word_id>36</word_id> + <id>102</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8585,8 +8343,8 @@ </sequence> </normal_column> <normal_column> - <word_id>39</word_id> - <id>106</id> + <word_id>38</word_id> + <id>103</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8618,8 +8376,8 @@ </sequence> </normal_column> <normal_column> - <word_id>38</word_id> - <id>107</id> + <word_id>37</word_id> + <id>104</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8651,8 +8409,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>108</id> + <word_id>220</word_id> + <id>105</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8684,8 +8442,8 @@ </sequence> </normal_column> <normal_column> - <id>109</id> - <referenced_column>121</referenced_column> + <id>106</id> + <referenced_column>119</referenced_column> <relation>8</relation> <description></description> <unique_key_name></unique_key_name> @@ -8718,8 +8476,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>110</id> + <word_id>87</word_id> + <id>107</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8751,8 +8509,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>111</id> + <word_id>84</word_id> + <id>108</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8784,8 +8542,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>112</id> + <word_id>108</word_id> + <id>109</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8817,8 +8575,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>113</id> + <word_id>109</word_id> + <id>110</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8859,7 +8617,7 @@ <description></description> <columns> <column> - <id>109</id> + <id>106</id> <desc>false</desc> </column> </columns> @@ -8873,7 +8631,7 @@ </table_properties> </table> <table> - <id>14</id> + <id>13</id> <height>149</height> <width>127</width> <font_name>맑은 고딕</font_name> @@ -8895,8 +8653,8 @@ <option></option> <columns> <normal_column> - <word_id>179</word_id> - <id>114</id> + <word_id>176</word_id> + <id>111</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8928,8 +8686,8 @@ </sequence> </normal_column> <normal_column> - <word_id>150</word_id> - <id>115</id> + <word_id>147</word_id> + <id>112</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8961,8 +8719,8 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> - <id>116</id> + <word_id>211</word_id> + <id>113</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8994,8 +8752,8 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> - <id>117</id> + <word_id>185</word_id> + <id>114</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9027,8 +8785,41 @@ </sequence> </normal_column> <normal_column> - <word_id>190</word_id> - <id>118</id> + <word_id>187</word_id> + <id>115</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>140</word_id> + <id>116</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9070,7 +8861,7 @@ </table_properties> </table> <table> - <id>15</id> + <id>14</id> <height>86</height> <width>233</width> <font_name>맑은 고딕</font_name> @@ -9092,8 +8883,8 @@ <option></option> <columns> <normal_column> - <word_id>102</word_id> - <id>119</id> + <word_id>99</word_id> + <id>117</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9125,8 +8916,8 @@ </sequence> </normal_column> <normal_column> - <word_id>101</word_id> - <id>120</id> + <word_id>98</word_id> + <id>118</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9168,7 +8959,7 @@ </table_properties> </table> <table> - <id>16</id> + <id>15</id> <height>212</height> <width>157</width> <font_name>맑은 고딕</font_name> @@ -9190,8 +8981,8 @@ <option></option> <columns> <normal_column> - <word_id>31</word_id> - <id>121</id> + <word_id>30</word_id> + <id>119</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9223,8 +9014,8 @@ </sequence> </normal_column> <normal_column> - <word_id>33</word_id> - <id>122</id> + <word_id>32</word_id> + <id>120</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9256,8 +9047,8 @@ </sequence> </normal_column> <normal_column> - <word_id>32</word_id> - <id>123</id> + <word_id>31</word_id> + <id>121</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9289,8 +9080,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>124</id> + <word_id>220</word_id> + <id>122</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9322,8 +9113,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>125</id> + <word_id>87</word_id> + <id>123</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9355,8 +9146,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>126</id> + <word_id>84</word_id> + <id>124</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9388,8 +9179,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>127</id> + <word_id>108</word_id> + <id>125</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9421,8 +9212,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>128</id> + <word_id>109</word_id> + <id>126</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9464,7 +9255,7 @@ </table_properties> </table> <table> - <id>17</id> + <id>16</id> <height>548</height> <width>284</width> <font_name>맑은 고딕</font_name> @@ -9479,8 +9270,8 @@ <connections> <relation> <id>9</id> - <source>10</source> - <target>17</target> + <source>9</source> + <target>16</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -9508,8 +9299,8 @@ <option></option> <columns> <normal_column> - <word_id>122</word_id> - <id>129</id> + <word_id>119</word_id> + <id>127</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9541,8 +9332,8 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> - <id>130</id> + <word_id>158</word_id> + <id>128</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9574,8 +9365,8 @@ </sequence> </normal_column> <normal_column> - <word_id>164</word_id> - <id>131</id> + <word_id>161</word_id> + <id>129</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9607,8 +9398,8 @@ </sequence> </normal_column> <normal_column> - <word_id>163</word_id> - <id>132</id> + <word_id>160</word_id> + <id>130</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9640,8 +9431,8 @@ </sequence> </normal_column> <normal_column> - <word_id>103</word_id> - <id>133</id> + <word_id>100</word_id> + <id>131</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9673,8 +9464,8 @@ </sequence> </normal_column> <normal_column> - <word_id>123</word_id> - <id>134</id> + <word_id>120</word_id> + <id>132</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9706,8 +9497,8 @@ </sequence> </normal_column> <normal_column> - <word_id>231</word_id> - <id>135</id> + <word_id>224</word_id> + <id>133</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9740,7 +9531,7 @@ </normal_column> <normal_column> <word_id>0</word_id> - <id>136</id> + <id>134</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9773,7 +9564,7 @@ </normal_column> <normal_column> <word_id>9</word_id> - <id>137</id> + <id>135</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9805,8 +9596,8 @@ </sequence> </normal_column> <normal_column> - <word_id>124</word_id> - <id>138</id> + <word_id>121</word_id> + <id>136</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9838,8 +9629,8 @@ </sequence> </normal_column> <normal_column> - <word_id>60</word_id> - <id>139</id> + <word_id>58</word_id> + <id>137</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9871,8 +9662,8 @@ </sequence> </normal_column> <normal_column> - <word_id>67</word_id> - <id>140</id> + <word_id>64</word_id> + <id>138</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9904,8 +9695,8 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> - <id>141</id> + <word_id>123</word_id> + <id>139</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9937,8 +9728,8 @@ </sequence> </normal_column> <normal_column> - <id>142</id> - <referenced_column>90</referenced_column> + <id>140</id> + <referenced_column>87</referenced_column> <relation>9</relation> <description></description> <unique_key_name></unique_key_name> @@ -9971,8 +9762,8 @@ </sequence> </normal_column> <normal_column> - <word_id>121</word_id> - <id>143</id> + <word_id>118</word_id> + <id>141</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10004,8 +9795,8 @@ </sequence> </normal_column> <normal_column> - <word_id>120</word_id> - <id>144</id> + <word_id>117</word_id> + <id>142</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10037,8 +9828,8 @@ </sequence> </normal_column> <normal_column> - <word_id>134</word_id> - <id>145</id> + <word_id>131</word_id> + <id>143</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10070,8 +9861,8 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> - <id>146</id> + <word_id>189</word_id> + <id>144</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10103,8 +9894,8 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> - <id>147</id> + <word_id>192</word_id> + <id>145</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10136,8 +9927,8 @@ </sequence> </normal_column> <normal_column> - <word_id>81</word_id> - <id>148</id> + <word_id>78</word_id> + <id>146</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10169,8 +9960,8 @@ </sequence> </normal_column> <normal_column> - <word_id>116</word_id> - <id>149</id> + <word_id>113</word_id> + <id>147</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10202,8 +9993,8 @@ </sequence> </normal_column> <normal_column> - <word_id>117</word_id> - <id>150</id> + <word_id>114</word_id> + <id>148</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10235,8 +10026,8 @@ </sequence> </normal_column> <normal_column> - <word_id>118</word_id> - <id>151</id> + <word_id>115</word_id> + <id>149</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10268,8 +10059,8 @@ </sequence> </normal_column> <normal_column> - <word_id>30</word_id> - <id>152</id> + <word_id>29</word_id> + <id>150</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10310,7 +10101,7 @@ <description></description> <columns> <column> - <id>142</id> + <id>140</id> <desc>false</desc> </column> </columns> @@ -10324,7 +10115,7 @@ </table_properties> </table> <table> - <id>18</id> + <id>17</id> <height>191</height> <width>223</width> <font_name>맑은 고딕</font_name> @@ -10346,8 +10137,8 @@ <option></option> <columns> <normal_column> - <word_id>119</word_id> - <id>153</id> + <word_id>116</word_id> + <id>151</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10379,8 +10170,8 @@ </sequence> </normal_column> <normal_column> - <word_id>41</word_id> - <id>154</id> + <word_id>40</word_id> + <id>152</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10412,8 +10203,8 @@ </sequence> </normal_column> <normal_column> - <word_id>42</word_id> - <id>155</id> + <word_id>41</word_id> + <id>153</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10445,8 +10236,8 @@ </sequence> </normal_column> <normal_column> - <word_id>43</word_id> - <id>156</id> + <word_id>42</word_id> + <id>154</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10478,8 +10269,8 @@ </sequence> </normal_column> <normal_column> - <word_id>79</word_id> - <id>157</id> + <word_id>76</word_id> + <id>155</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10511,8 +10302,8 @@ </sequence> </normal_column> <normal_column> - <word_id>78</word_id> - <id>158</id> + <word_id>75</word_id> + <id>156</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10544,8 +10335,8 @@ </sequence> </normal_column> <normal_column> - <word_id>53</word_id> - <id>159</id> + <word_id>51</word_id> + <id>157</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10587,7 +10378,7 @@ </table_properties> </table> <table> - <id>19</id> + <id>18</id> <height>212</height> <width>147</width> <font_name>맑은 고딕</font_name> @@ -10609,8 +10400,8 @@ <option></option> <columns> <normal_column> - <word_id>64</word_id> - <id>160</id> + <word_id>61</word_id> + <id>158</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10642,8 +10433,8 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> - <id>161</id> + <word_id>104</word_id> + <id>159</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10675,8 +10466,8 @@ </sequence> </normal_column> <normal_column> - <word_id>62</word_id> - <id>162</id> + <word_id>59</word_id> + <id>160</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10708,8 +10499,8 @@ </sequence> </normal_column> <normal_column> - <word_id>115</word_id> - <id>163</id> + <word_id>112</word_id> + <id>161</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10741,8 +10532,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>164</id> + <word_id>84</word_id> + <id>162</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10774,8 +10565,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>165</id> + <word_id>87</word_id> + <id>163</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10807,8 +10598,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>166</id> + <word_id>109</word_id> + <id>164</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10840,8 +10631,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>167</id> + <word_id>108</word_id> + <id>165</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10883,7 +10674,7 @@ </table_properties> </table> <table> - <id>20</id> + <id>19</id> <height>107</height> <width>177</width> <font_name>맑은 고딕</font_name> @@ -10905,8 +10696,8 @@ <option></option> <columns> <normal_column> - <word_id>193</word_id> - <id>168</id> + <word_id>190</word_id> + <id>166</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10938,8 +10729,8 @@ </sequence> </normal_column> <normal_column> - <word_id>125</word_id> - <id>169</id> + <word_id>122</word_id> + <id>167</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10972,7 +10763,7 @@ </normal_column> <normal_column> <word_id>14</word_id> - <id>170</id> + <id>168</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11013,7 +10804,7 @@ <description></description> <columns> <column> - <id>170</id> + <id>168</id> <desc>false</desc> </column> </columns> @@ -11027,7 +10818,7 @@ </table_properties> </table> <table> - <id>21</id> + <id>20</id> <height>464</height> <width>204</width> <font_name>맑은 고딕</font_name> @@ -11042,8 +10833,8 @@ <connections> <relation> <id>10</id> - <source>6</source> - <target>21</target> + <source>5</source> + <target>20</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -11071,8 +10862,8 @@ <option></option> <columns> <normal_column> - <id>171</id> - <referenced_column>45</referenced_column> + <id>169</id> + <referenced_column>42</referenced_column> <relation>10</relation> <description></description> <unique_key_name></unique_key_name> @@ -11105,8 +10896,8 @@ </sequence> </normal_column> <normal_column> - <word_id>29</word_id> - <id>172</id> + <word_id>28</word_id> + <id>170</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11138,8 +10929,8 @@ </sequence> </normal_column> <normal_column> - <word_id>155</word_id> - <id>173</id> + <word_id>152</word_id> + <id>171</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11171,8 +10962,8 @@ </sequence> </normal_column> <normal_column> - <word_id>96</word_id> - <id>174</id> + <word_id>93</word_id> + <id>172</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11204,8 +10995,8 @@ </sequence> </normal_column> <normal_column> - <word_id>66</word_id> - <id>175</id> + <word_id>63</word_id> + <id>173</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11237,8 +11028,8 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> - <id>176</id> + <word_id>192</word_id> + <id>174</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11270,8 +11061,8 @@ </sequence> </normal_column> <normal_column> - <word_id>28</word_id> - <id>177</id> + <word_id>27</word_id> + <id>175</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11303,8 +11094,8 @@ </sequence> </normal_column> <normal_column> - <word_id>92</word_id> - <id>178</id> + <word_id>89</word_id> + <id>176</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11336,8 +11127,8 @@ </sequence> </normal_column> <normal_column> - <word_id>98</word_id> - <id>179</id> + <word_id>95</word_id> + <id>177</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11369,8 +11160,8 @@ </sequence> </normal_column> <normal_column> - <word_id>99</word_id> - <id>180</id> + <word_id>96</word_id> + <id>178</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11403,7 +11194,7 @@ </normal_column> <normal_column> <word_id>9</word_id> - <id>181</id> + <id>179</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11435,8 +11226,8 @@ </sequence> </normal_column> <normal_column> - <word_id>60</word_id> - <id>182</id> + <word_id>58</word_id> + <id>180</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11468,8 +11259,8 @@ </sequence> </normal_column> <normal_column> - <word_id>231</word_id> - <id>183</id> + <word_id>224</word_id> + <id>181</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11501,8 +11292,8 @@ </sequence> </normal_column> <normal_column> - <word_id>152</word_id> - <id>184</id> + <word_id>149</word_id> + <id>182</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11534,8 +11325,8 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> - <id>185</id> + <word_id>123</word_id> + <id>183</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11567,8 +11358,8 @@ </sequence> </normal_column> <normal_column> - <word_id>63</word_id> - <id>186</id> + <word_id>60</word_id> + <id>184</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11600,8 +11391,8 @@ </sequence> </normal_column> <normal_column> - <word_id>100</word_id> - <id>187</id> + <word_id>97</word_id> + <id>185</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11633,8 +11424,8 @@ </sequence> </normal_column> <normal_column> - <word_id>171</word_id> - <id>188</id> + <word_id>168</word_id> + <id>186</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11666,8 +11457,8 @@ </sequence> </normal_column> <normal_column> - <word_id>65</word_id> - <id>189</id> + <word_id>62</word_id> + <id>187</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11699,8 +11490,8 @@ </sequence> </normal_column> <normal_column> - <word_id>81</word_id> - <id>190</id> + <word_id>78</word_id> + <id>188</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11741,7 +11532,7 @@ <description></description> <columns> <column> - <id>171</id> + <id>169</id> <desc>false</desc> </column> </columns> @@ -11755,7 +11546,7 @@ </table_properties> </table> <table> - <id>22</id> + <id>21</id> <height>380</height> <width>225</width> <font_name>맑은 고딕</font_name> @@ -11777,8 +11568,8 @@ <option></option> <columns> <normal_column> - <word_id>179</word_id> - <id>191</id> + <word_id>176</word_id> + <id>189</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11810,8 +11601,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>192</id> + <word_id>105</word_id> + <id>190</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11843,8 +11634,8 @@ </sequence> </normal_column> <normal_column> - <word_id>106</word_id> - <id>193</id> + <word_id>103</word_id> + <id>191</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11876,8 +11667,8 @@ </sequence> </normal_column> <normal_column> - <word_id>150</word_id> - <id>194</id> + <word_id>147</word_id> + <id>192</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11909,8 +11700,8 @@ </sequence> </normal_column> <normal_column> - <word_id>190</word_id> - <id>195</id> + <word_id>187</word_id> + <id>193</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11942,8 +11733,8 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> - <id>196</id> + <word_id>185</word_id> + <id>194</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11975,8 +11766,8 @@ </sequence> </normal_column> <normal_column> - <word_id>212</word_id> - <id>197</id> + <word_id>205</word_id> + <id>195</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12008,8 +11799,8 @@ </sequence> </normal_column> <normal_column> - <word_id>201</word_id> - <id>198</id> + <word_id>197</word_id> + <id>196</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12041,8 +11832,8 @@ </sequence> </normal_column> <normal_column> - <word_id>133</word_id> - <id>199</id> + <word_id>129</word_id> + <id>197</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12074,8 +11865,8 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> - <id>200</id> + <word_id>163</word_id> + <id>198</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12107,8 +11898,8 @@ </sequence> </normal_column> <normal_column> - <word_id>165</word_id> - <id>201</id> + <word_id>162</word_id> + <id>199</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12140,8 +11931,8 @@ </sequence> </normal_column> <normal_column> - <word_id>167</word_id> - <id>202</id> + <word_id>164</word_id> + <id>200</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12173,8 +11964,8 @@ </sequence> </normal_column> <normal_column> - <word_id>191</word_id> - <id>203</id> + <word_id>188</word_id> + <id>201</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12206,8 +11997,8 @@ </sequence> </normal_column> <normal_column> - <word_id>80</word_id> - <id>204</id> + <word_id>77</word_id> + <id>202</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12239,8 +12030,8 @@ </sequence> </normal_column> <normal_column> - <word_id>77</word_id> - <id>205</id> + <word_id>74</word_id> + <id>203</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12272,8 +12063,8 @@ </sequence> </normal_column> <normal_column> - <word_id>78</word_id> - <id>206</id> + <word_id>75</word_id> + <id>204</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12315,7 +12106,7 @@ </table_properties> </table> <table> - <id>23</id> + <id>22</id> <height>296</height> <width>140</width> <font_name>맑은 고딕</font_name> @@ -12330,8 +12121,8 @@ <connections> <relation> <id>11</id> - <source>33</source> - <target>23</target> + <source>32</source> + <target>22</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -12359,8 +12150,8 @@ <option></option> <columns> <normal_column> - <id>207</id> - <referenced_column>314</referenced_column> + <id>205</id> + <referenced_column>312</referenced_column> <relation>11</relation> <description></description> <unique_key_name></unique_key_name> @@ -12393,8 +12184,8 @@ </sequence> </normal_column> <normal_column> - <id>208</id> - <referenced_column>315</referenced_column> + <id>206</id> + <referenced_column>313</referenced_column> <relation>11</relation> <description></description> <unique_key_name></unique_key_name> @@ -12428,7 +12219,7 @@ </normal_column> <normal_column> <word_id>4</word_id> - <id>209</id> + <id>207</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12460,8 +12251,8 @@ </sequence> </normal_column> <normal_column> - <word_id>229</word_id> - <id>210</id> + <word_id>222</word_id> + <id>208</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12493,8 +12284,8 @@ </sequence> </normal_column> <normal_column> - <word_id>230</word_id> - <id>211</id> + <word_id>223</word_id> + <id>209</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12527,7 +12318,7 @@ </normal_column> <normal_column> <word_id>1</word_id> - <id>212</id> + <id>210</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12559,8 +12350,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>213</id> + <word_id>220</word_id> + <id>211</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12592,8 +12383,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>214</id> + <word_id>87</word_id> + <id>212</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12625,8 +12416,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>215</id> + <word_id>84</word_id> + <id>213</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12658,8 +12449,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>216</id> + <word_id>108</word_id> + <id>214</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12691,8 +12482,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>217</id> + <word_id>109</word_id> + <id>215</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12724,8 +12515,8 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> - <id>218</id> + <word_id>158</word_id> + <id>216</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12766,11 +12557,11 @@ <description></description> <columns> <column> - <id>207</id> + <id>205</id> <desc>false</desc> </column> <column> - <id>208</id> + <id>206</id> <desc>false</desc> </column> </columns> @@ -12784,7 +12575,7 @@ </table_properties> </table> <table> - <id>24</id> + <id>23</id> <height>254</height> <width>192</width> <font_name>맑은 고딕</font_name> @@ -12806,8 +12597,8 @@ <option></option> <columns> <normal_column> - <word_id>148</word_id> - <id>219</id> + <word_id>146</word_id> + <id>217</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12839,8 +12630,8 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> - <id>220</id> + <word_id>186</word_id> + <id>218</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12872,8 +12663,8 @@ </sequence> </normal_column> <normal_column> - <word_id>202</word_id> - <id>221</id> + <word_id>198</word_id> + <id>219</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12905,8 +12696,8 @@ </sequence> </normal_column> <normal_column> - <word_id>132</word_id> - <id>222</id> + <word_id>130</word_id> + <id>220</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12938,8 +12729,8 @@ </sequence> </normal_column> <normal_column> - <word_id>50</word_id> - <id>223</id> + <word_id>49</word_id> + <id>221</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12971,8 +12762,8 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> - <id>224</id> + <word_id>207</word_id> + <id>222</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13004,8 +12795,8 @@ </sequence> </normal_column> <normal_column> - <word_id>173</word_id> - <id>225</id> + <word_id>169</word_id> + <id>223</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13037,8 +12828,8 @@ </sequence> </normal_column> <normal_column> - <word_id>58</word_id> - <id>226</id> + <word_id>57</word_id> + <id>224</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13070,8 +12861,8 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> - <id>227</id> + <word_id>155</word_id> + <id>225</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13103,8 +12894,8 @@ </sequence> </normal_column> <normal_column> - <word_id>76</word_id> - <id>228</id> + <word_id>73</word_id> + <id>226</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13146,7 +12937,7 @@ </table_properties> </table> <table> - <id>25</id> + <id>24</id> <height>317</height> <width>201</width> <font_name>맑은 고딕</font_name> @@ -13168,8 +12959,8 @@ <option></option> <columns> <normal_column> - <word_id>85</word_id> - <id>229</id> + <word_id>82</word_id> + <id>227</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13201,8 +12992,8 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>230</id> + <word_id>111</word_id> + <id>228</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13234,8 +13025,8 @@ </sequence> </normal_column> <normal_column> - <word_id>91</word_id> - <id>231</id> + <word_id>88</word_id> + <id>229</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13267,8 +13058,8 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> - <id>232</id> + <word_id>154</word_id> + <id>230</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13300,8 +13091,8 @@ </sequence> </normal_column> <normal_column> - <word_id>204</word_id> - <id>233</id> + <word_id>200</word_id> + <id>231</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13333,8 +13124,8 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> - <id>234</id> + <word_id>210</word_id> + <id>232</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13366,8 +13157,8 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>235</id> + <word_id>83</word_id> + <id>233</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13399,8 +13190,8 @@ </sequence> </normal_column> <normal_column> - <word_id>135</word_id> - <id>236</id> + <word_id>132</word_id> + <id>234</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13432,8 +13223,8 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> - <id>237</id> + <word_id>81</word_id> + <id>235</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13465,8 +13256,8 @@ </sequence> </normal_column> <normal_column> - <word_id>174</word_id> - <id>238</id> + <word_id>171</word_id> + <id>236</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13498,8 +13289,8 @@ </sequence> </normal_column> <normal_column> - <word_id>175</word_id> - <id>239</id> + <word_id>172</word_id> + <id>237</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13531,8 +13322,8 @@ </sequence> </normal_column> <normal_column> - <word_id>216</word_id> - <id>240</id> + <word_id>209</word_id> + <id>238</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13564,8 +13355,8 @@ </sequence> </normal_column> <normal_column> - <word_id>215</word_id> - <id>241</id> + <word_id>208</word_id> + <id>239</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13607,7 +13398,7 @@ </table_properties> </table> <table> - <id>26</id> + <id>25</id> <height>191</height> <width>246</width> <font_name>맑은 고딕</font_name> @@ -13622,8 +13413,8 @@ <connections> <relation> <id>12</id> - <source>27</source> - <target>26</target> + <source>26</source> + <target>25</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -13652,7 +13443,7 @@ <columns> <normal_column> <word_id>18</word_id> - <id>242</id> + <id>240</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13685,7 +13476,7 @@ </normal_column> <normal_column> <word_id>13</word_id> - <id>243</id> + <id>241</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13717,8 +13508,8 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> - <id>244</id> + <word_id>214</word_id> + <id>242</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13750,8 +13541,8 @@ </sequence> </normal_column> <normal_column> - <id>245</id> - <referenced_column>249</referenced_column> + <id>243</id> + <referenced_column>247</referenced_column> <relation>12</relation> <description></description> <unique_key_name></unique_key_name> @@ -13784,8 +13575,8 @@ </sequence> </normal_column> <normal_column> - <id>246</id> - <referenced_column>250</referenced_column> + <id>244</id> + <referenced_column>248</referenced_column> <relation>12</relation> <description></description> <unique_key_name></unique_key_name> @@ -13818,8 +13609,8 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>247</id> + <word_id>86</word_id> + <id>245</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13851,8 +13642,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>248</id> + <word_id>85</word_id> + <id>246</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13894,7 +13685,7 @@ </table_properties> </table> <table> - <id>27</id> + <id>26</id> <height>212</height> <width>276</width> <font_name>맑은 고딕</font_name> @@ -13909,8 +13700,8 @@ <connections> <relation> <id>13</id> - <source>31</source> - <target>27</target> + <source>30</source> + <target>26</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -13938,71 +13729,199 @@ <option></option> <columns> <normal_column> - <id>249</id> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> - <referenced_column>291</referenced_column> + <id>247</id> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <referenced_column>289</referenced_column> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> <relation>13</relation> <relation>13</relation> <relation>13</relation> @@ -14098,8 +14017,8 @@ </sequence> </normal_column> <normal_column> - <word_id>169</word_id> - <id>250</id> + <word_id>166</word_id> + <id>248</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14131,8 +14050,8 @@ </sequence> </normal_column> <normal_column> - <word_id>170</word_id> - <id>251</id> + <word_id>167</word_id> + <id>249</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14164,8 +14083,8 @@ </sequence> </normal_column> <normal_column> - <word_id>56</word_id> - <id>252</id> + <word_id>54</word_id> + <id>250</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14197,8 +14116,8 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>253</id> + <word_id>86</word_id> + <id>251</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14230,8 +14149,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>254</id> + <word_id>85</word_id> + <id>252</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14263,8 +14182,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>255</id> + <word_id>107</word_id> + <id>253</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14296,8 +14215,8 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> - <id>256</id> + <word_id>110</word_id> + <id>254</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14339,7 +14258,7 @@ </table_properties> </table> <table> - <id>28</id> + <id>27</id> <height>191</height> <width>129</width> <font_name>맑은 고딕</font_name> @@ -14361,8 +14280,8 @@ <option></option> <columns> <normal_column> - <word_id>180</word_id> - <id>257</id> + <word_id>177</word_id> + <id>255</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14394,8 +14313,8 @@ </sequence> </normal_column> <normal_column> - <word_id>183</word_id> - <id>258</id> + <word_id>180</word_id> + <id>256</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14427,8 +14346,8 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> - <id>259</id> + <word_id>181</word_id> + <id>257</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14460,8 +14379,8 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> - <id>260</id> + <word_id>179</word_id> + <id>258</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14493,8 +14412,8 @@ </sequence> </normal_column> <normal_column> - <word_id>186</word_id> - <id>261</id> + <word_id>183</word_id> + <id>259</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14526,8 +14445,8 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> - <id>262</id> + <word_id>182</word_id> + <id>260</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14559,8 +14478,8 @@ </sequence> </normal_column> <normal_column> - <word_id>181</word_id> - <id>263</id> + <word_id>178</word_id> + <id>261</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14602,7 +14521,7 @@ </table_properties> </table> <table> - <id>29</id> + <id>28</id> <height>-1</height> <width>-1</width> <font_name>맑은 고딕</font_name> @@ -14624,8 +14543,8 @@ <option></option> <columns> <normal_column> - <word_id>21</word_id> - <id>264</id> + <word_id>20</word_id> + <id>262</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14657,8 +14576,8 @@ </sequence> </normal_column> <normal_column> - <word_id>23</word_id> - <id>265</id> + <word_id>22</word_id> + <id>263</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14690,8 +14609,8 @@ </sequence> </normal_column> <normal_column> - <word_id>22</word_id> - <id>266</id> + <word_id>21</word_id> + <id>264</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14723,8 +14642,8 @@ </sequence> </normal_column> <normal_column> - <word_id>24</word_id> - <id>267</id> + <word_id>23</word_id> + <id>265</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14756,8 +14675,8 @@ </sequence> </normal_column> <normal_column> - <word_id>178</word_id> - <id>268</id> + <word_id>175</word_id> + <id>266</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14789,8 +14708,8 @@ </sequence> </normal_column> <normal_column> - <word_id>83</word_id> - <id>269</id> + <word_id>80</word_id> + <id>267</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14823,7 +14742,7 @@ </normal_column> <normal_column> <word_id>11</word_id> - <id>270</id> + <id>268</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14856,7 +14775,7 @@ </normal_column> <normal_column> <word_id>12</word_id> - <id>271</id> + <id>269</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14888,8 +14807,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>272</id> + <word_id>220</word_id> + <id>270</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14921,8 +14840,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>273</id> + <word_id>84</word_id> + <id>271</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14954,8 +14873,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>274</id> + <word_id>87</word_id> + <id>272</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14987,8 +14906,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>275</id> + <word_id>109</word_id> + <id>273</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15020,8 +14939,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>276</id> + <word_id>108</word_id> + <id>274</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15053,8 +14972,8 @@ </sequence> </normal_column> <normal_column> - <word_id>27</word_id> - <id>277</id> + <word_id>26</word_id> + <id>275</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15086,8 +15005,8 @@ </sequence> </normal_column> <normal_column> - <word_id>26</word_id> - <id>278</id> + <word_id>25</word_id> + <id>276</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15119,8 +15038,8 @@ </sequence> </normal_column> <normal_column> - <word_id>197</word_id> - <id>279</id> + <word_id>194</word_id> + <id>277</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15153,7 +15072,7 @@ </normal_column> <normal_column> <word_id>5</word_id> - <id>280</id> + <id>278</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15185,8 +15104,8 @@ </sequence> </normal_column> <normal_column> - <word_id>20</word_id> - <id>281</id> + <word_id>19</word_id> + <id>279</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15218,8 +15137,8 @@ </sequence> </normal_column> <normal_column> - <word_id>57</word_id> - <id>282</id> + <word_id>55</word_id> + <id>280</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15261,7 +15180,7 @@ </table_properties> </table> <table> - <id>30</id> + <id>29</id> <height>212</height> <width>133</width> <font_name>맑은 고딕</font_name> @@ -15276,8 +15195,8 @@ <connections> <relation> <id>14</id> - <source>29</source> - <target>30</target> + <source>28</source> + <target>29</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -15305,8 +15224,8 @@ <option></option> <columns> <normal_column> - <id>283</id> - <referenced_column>264</referenced_column> + <id>281</id> + <referenced_column>262</referenced_column> <relation>14</relation> <description></description> <unique_key_name></unique_key_name> @@ -15339,8 +15258,8 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> - <id>284</id> + <word_id>204</word_id> + <id>282</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15372,8 +15291,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>285</id> + <word_id>220</word_id> + <id>283</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15405,8 +15324,8 @@ </sequence> </normal_column> <normal_column> - <word_id>176</word_id> - <id>286</id> + <word_id>173</word_id> + <id>284</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15438,8 +15357,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>287</id> + <word_id>87</word_id> + <id>285</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15471,8 +15390,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>288</id> + <word_id>84</word_id> + <id>286</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15504,8 +15423,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>289</id> + <word_id>108</word_id> + <id>287</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15537,8 +15456,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>290</id> + <word_id>109</word_id> + <id>288</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15579,7 +15498,7 @@ <description></description> <columns> <column> - <id>283</id> + <id>281</id> <desc>false</desc> </column> </columns> @@ -15593,7 +15512,7 @@ </table_properties> </table> <table> - <id>31</id> + <id>30</id> <height>317</height> <width>389</width> <font_name>맑은 고딕</font_name> @@ -15608,8 +15527,8 @@ <connections> <relation> <id>15</id> - <source>31</source> - <target>31</target> + <source>30</source> + <target>30</target> <source_xp>100</source_xp> <source_yp>84</source_yp> <target_xp>73</target_xp> @@ -15642,8 +15561,8 @@ <option></option> <columns> <normal_column> - <word_id>130</word_id> - <id>291</id> + <word_id>127</word_id> + <id>289</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15675,8 +15594,8 @@ </sequence> </normal_column> <normal_column> - <id>292</id> - <referenced_column>291</referenced_column> + <id>290</id> + <referenced_column>289</referenced_column> <relation>15</relation> <description></description> <unique_key_name></unique_key_name> @@ -15709,8 +15628,8 @@ </sequence> </normal_column> <normal_column> - <word_id>129</word_id> - <id>293</id> + <word_id>126</word_id> + <id>291</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15742,8 +15661,8 @@ </sequence> </normal_column> <normal_column> - <word_id>131</word_id> - <id>294</id> + <word_id>128</word_id> + <id>292</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15775,8 +15694,8 @@ </sequence> </normal_column> <normal_column> - <word_id>127</word_id> - <id>295</id> + <word_id>124</word_id> + <id>293</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15808,8 +15727,8 @@ </sequence> </normal_column> <normal_column> - <word_id>177</word_id> - <id>296</id> + <word_id>174</word_id> + <id>294</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15841,8 +15760,8 @@ </sequence> </normal_column> <normal_column> - <word_id>168</word_id> - <id>297</id> + <word_id>165</word_id> + <id>295</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15874,8 +15793,8 @@ </sequence> </normal_column> <normal_column> - <word_id>128</word_id> - <id>298</id> + <word_id>125</word_id> + <id>296</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15907,8 +15826,8 @@ </sequence> </normal_column> <normal_column> - <word_id>228</word_id> - <id>299</id> + <word_id>221</word_id> + <id>297</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15940,8 +15859,8 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>300</id> + <word_id>86</word_id> + <id>298</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15973,8 +15892,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>301</id> + <word_id>85</word_id> + <id>299</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16006,8 +15925,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>302</id> + <word_id>107</word_id> + <id>300</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16039,8 +15958,8 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> - <id>303</id> + <word_id>110</word_id> + <id>301</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16082,7 +16001,7 @@ </table_properties> </table> <table> - <id>32</id> + <id>31</id> <height>254</height> <width>244</width> <font_name>맑은 고딕</font_name> @@ -16104,8 +16023,8 @@ <option></option> <columns> <normal_column> - <word_id>205</word_id> - <id>304</id> + <word_id>201</word_id> + <id>302</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16137,8 +16056,8 @@ </sequence> </normal_column> <normal_column> - <word_id>206</word_id> - <id>305</id> + <word_id>202</word_id> + <id>303</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16170,8 +16089,8 @@ </sequence> </normal_column> <normal_column> - <word_id>48</word_id> - <id>306</id> + <word_id>47</word_id> + <id>304</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16203,8 +16122,8 @@ </sequence> </normal_column> <normal_column> - <word_id>45</word_id> - <id>307</id> + <word_id>44</word_id> + <id>305</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16236,8 +16155,8 @@ </sequence> </normal_column> <normal_column> - <word_id>49</word_id> - <id>308</id> + <word_id>48</word_id> + <id>306</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16269,8 +16188,8 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> - <id>309</id> + <word_id>46</word_id> + <id>307</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16302,8 +16221,8 @@ </sequence> </normal_column> <normal_column> - <word_id>44</word_id> - <id>310</id> + <word_id>43</word_id> + <id>308</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16335,8 +16254,8 @@ </sequence> </normal_column> <normal_column> - <word_id>46</word_id> - <id>311</id> + <word_id>45</word_id> + <id>309</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16368,8 +16287,8 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> - <id>312</id> + <word_id>102</word_id> + <id>310</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16401,8 +16320,8 @@ </sequence> </normal_column> <normal_column> - <word_id>203</word_id> - <id>313</id> + <word_id>199</word_id> + <id>311</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16444,7 +16363,7 @@ </table_properties> </table> <table> - <id>33</id> + <id>32</id> <height>569</height> <width>133</width> <font_name>맑은 고딕</font_name> @@ -16459,8 +16378,8 @@ <connections> <relation> <id>16</id> - <source>29</source> - <target>33</target> + <source>28</source> + <target>32</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -16488,8 +16407,8 @@ <option></option> <columns> <normal_column> - <word_id>144</word_id> - <id>314</id> + <word_id>142</word_id> + <id>312</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16521,39 +16440,103 @@ </sequence> </normal_column> <normal_column> - <id>315</id> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> - <referenced_column>264</referenced_column> + <id>313</id> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> <relation>16</relation> <relation>16</relation> <relation>16</relation> @@ -16617,8 +16600,8 @@ </sequence> </normal_column> <normal_column> - <word_id>145</word_id> - <id>316</id> + <word_id>143</word_id> + <id>314</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16650,8 +16633,8 @@ </sequence> </normal_column> <normal_column> - <word_id>146</word_id> - <id>317</id> + <word_id>144</word_id> + <id>315</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16683,8 +16666,8 @@ </sequence> </normal_column> <normal_column> - <word_id>143</word_id> - <id>318</id> + <word_id>141</word_id> + <id>316</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16717,7 +16700,7 @@ </normal_column> <normal_column> <word_id>2</word_id> - <id>319</id> + <id>317</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16749,8 +16732,8 @@ </sequence> </normal_column> <normal_column> - <word_id>160</word_id> - <id>320</id> + <word_id>157</word_id> + <id>318</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16783,7 +16766,7 @@ </normal_column> <normal_column> <word_id>3</word_id> - <id>321</id> + <id>319</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16815,8 +16798,8 @@ </sequence> </normal_column> <normal_column> - <word_id>198</word_id> - <id>322</id> + <word_id>195</word_id> + <id>320</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16848,8 +16831,8 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> - <id>323</id> + <word_id>170</word_id> + <id>321</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16881,8 +16864,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>324</id> + <word_id>220</word_id> + <id>322</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16914,8 +16897,8 @@ </sequence> </normal_column> <normal_column> - <word_id>139</word_id> - <id>325</id> + <word_id>135</word_id> + <id>323</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16947,8 +16930,8 @@ </sequence> </normal_column> <normal_column> - <word_id>140</word_id> - <id>326</id> + <word_id>136</word_id> + <id>324</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16980,8 +16963,8 @@ </sequence> </normal_column> <normal_column> - <word_id>141</word_id> - <id>327</id> + <word_id>137</word_id> + <id>325</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17013,8 +16996,8 @@ </sequence> </normal_column> <normal_column> - <word_id>142</word_id> - <id>328</id> + <word_id>138</word_id> + <id>326</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17046,8 +17029,8 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> - <id>329</id> + <word_id>158</word_id> + <id>327</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17080,7 +17063,7 @@ </normal_column> <normal_column> <word_id>10</word_id> - <id>330</id> + <id>328</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17112,8 +17095,8 @@ </sequence> </normal_column> <normal_column> - <word_id>138</word_id> - <id>331</id> + <word_id>134</word_id> + <id>329</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17145,8 +17128,8 @@ </sequence> </normal_column> <normal_column> - <word_id>196</word_id> - <id>332</id> + <word_id>193</word_id> + <id>330</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17178,8 +17161,8 @@ </sequence> </normal_column> <normal_column> - <word_id>194</word_id> - <id>333</id> + <word_id>191</word_id> + <id>331</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17211,8 +17194,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>334</id> + <word_id>87</word_id> + <id>332</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17244,8 +17227,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>335</id> + <word_id>84</word_id> + <id>333</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17277,8 +17260,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>336</id> + <word_id>108</word_id> + <id>334</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17310,8 +17293,8 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>337</id> + <word_id>109</word_id> + <id>335</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17343,8 +17326,8 @@ </sequence> </normal_column> <normal_column> - <word_id>27</word_id> - <id>338</id> + <word_id>26</word_id> + <id>336</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17376,8 +17359,8 @@ </sequence> </normal_column> <normal_column> - <word_id>187</word_id> - <id>339</id> + <word_id>184</word_id> + <id>337</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17418,7 +17401,7 @@ <description></description> <columns> <column> - <id>315</id> + <id>313</id> <desc>false</desc> </column> </columns> @@ -17432,12 +17415,12 @@ </table_properties> </table> <table> - <id>34</id> - <height>233</height> - <width>290</width> + <id>33</id> + <height>107</height> + <width>244</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>2592</x> + <x>1392</x> <y>114</y> <color> <r>128</r> @@ -17446,16 +17429,16 @@ </color> <connections> </connections> - <physical_name>comtsbbssummary</physical_name> - <logical_name>게시물통계요약</logical_name> - <description>게시물통계요약</description> + <physical_name>comtsweblogsummary</physical_name> + <logical_name>웹로그 요약</logical_name> + <description>웹로그 요약</description> <constraint></constraint> - <primary_key_name>comtsbbssummary_pkey</primary_key_name> + <primary_key_name>comtsweblogsummary_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>149</word_id> - <id>340</id> + <word_id>145</word_id> + <id>338</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17487,8 +17470,8 @@ </sequence> </normal_column> <normal_column> - <word_id>199</word_id> - <id>341</id> + <word_id>211</word_id> + <id>339</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17520,8 +17503,8 @@ </sequence> </normal_column> <normal_column> - <word_id>61</word_id> - <id>342</id> + <word_id>139</word_id> + <id>340</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17553,74 +17536,8 @@ </sequence> </normal_column> <normal_column> - <word_id>52</word_id> - <id>343</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <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> - <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>210</word_id> - <id>344</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <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> - <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>19</word_id> - <id>345</id> + <word_id>170</word_id> + <id>341</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17651,105 +17568,6 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - <normal_column> - <word_id>208</word_id> - <id>346</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>136</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> - <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>209</word_id> - <id>348</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> @@ -17760,6 +17578,70 @@ <without_oids>true</without_oids> </table_properties> </table> + <table> + <id>34</id> + <height>75</height> + <width>174</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1212</x> + <y>346</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnbbslog</physical_name> + <logical_name>게시글로그</logical_name> + <description></description> + <constraint></constraint> + <primary_key_name></primary_key_name> + <option></option> + <columns> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema></schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>35</id> + <height>75</height> + <width>267</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1194</x> + <y>449</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnbbslogsummary</physical_name> + <logical_name>게시글 요약</logical_name> + <description></description> + <constraint></constraint> + <primary_key_name></primary_key_name> + <option></option> + <columns> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema></schema> + <without_oids>true</without_oids> + </table_properties> + </table> </contents> <column_groups> </column_groups>
Add a comment
List