Index: base3.10/src/main/webapp/resource/editor/js/froala_editor_script_custom.js =================================================================== --- base3.10/src/main/webapp/resource/editor/js/froala_editor_script_custom.js (revision 71) +++ base3.10/src/main/webapp/resource/editor/js/froala_editor_script_custom.js (revision 72) @@ -40,9 +40,13 @@ var editor = {}; editor.options = $.extend({}, defaults, options); // 파일, 이미지, 비디오 사이즈 - editor.options.fileMaxSize = editor.options.fileMaxSize * 1024 * 1024; - editor.options.imageMaxSize = editor.options.imageMaxSize * 1024 * 1024; - editor.options.videoMaxSize = editor.options.fileMaxSize * 1024 * 1024; + const maxSize = parseInt(editor.options.fileMaxSize); + editor.options.fileMaxSize = maxSize * 1024 * 1024; + editor.options.imageMaxSize = maxSize * 1024 * 1024; + editor.options.videoMaxSize = maxSize * 1024 * 1024; + +// editor.options.imageMaxSize = editor.options.imageMaxSize * 1024 * 1024; +// editor.options.videoMaxSize = editor.options.fileMaxSize * 1024 * 1024; // 신규 파일선택 이벤트 $('#'+editor.options.inputFileId).on('change', function() { Index: base3.10/script/postgres.erm =================================================================== --- base3.10/script/postgres.erm (revision 71) +++ base3.10/script/postgres.erm (revision 72) @@ -10,9 +10,9 @@ <right_margin>30</right_margin> </page_setting> <category_index>0</category_index> - <zoom>1.0</zoom> + <zoom>0.25</zoom> <x>0</x> - <y>2172</y> + <y>162</y> <default_color> <r>255</r> <g>0</g> @@ -112,7 +112,7 @@ <show_referred_tables>false</show_referred_tables> <categories> <category> - <id>41</id> + <id>35</id> <height>167</height> <width>601</width> <font_name>맑은 고딕</font_name> @@ -128,11 +128,11 @@ </connections> <name>기타</name> <selected>true</selected> + <node_element>12</node_element> <node_element>16</node_element> - <node_element>20</node_element> </category> <category> - <id>42</id> + <id>36</id> <height>400</height> <width>941</width> <font_name>맑은 고딕</font_name> @@ -148,14 +148,14 @@ </connections> <name>공통코드</name> <selected>true</selected> - <node_element>21</node_element> <node_element>17</node_element> - <node_element>18</node_element> + <node_element>13</node_element> + <node_element>14</node_element> </category> <category> - <id>43</id> + <id>37</id> <height>864</height> - <width>1568</width> + <width>1632</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> <x>4</x> @@ -169,20 +169,17 @@ </connections> <name>권한&amp;메뉴</name> <selected>true</selected> - <node_element>26</node_element> - <node_element>15</node_element> - <node_element>4</node_element> - <node_element>27</node_element> - <node_element>7</node_element> - <node_element>13</node_element> - <node_element>6</node_element> - <node_element>25</node_element> - <node_element>12</node_element> + <node_element>10</node_element> + <node_element>21</node_element> + <node_element>9</node_element> <node_element>3</node_element> - <node_element>37</node_element> + <node_element>31</node_element> + <node_element>30</node_element> + <node_element>34</node_element> + <node_element>29</node_element> </category> <category> - <id>44</id> + <id>38</id> <height>1185</height> <width>1592</width> <font_name>맑은 고딕</font_name> @@ -199,16 +196,16 @@ <name>사용자</name> <selected>true</selected> <node_element>0</node_element> - <node_element>14</node_element> + <node_element>11</node_element> + <node_element>18</node_element> <node_element>22</node_element> - <node_element>28</node_element> - <node_element>9</node_element> - <node_element>5</node_element> - <node_element>10</node_element> - <node_element>24</node_element> + <node_element>6</node_element> + <node_element>4</node_element> + <node_element>7</node_element> + <node_element>20</node_element> </category> <category> - <id>45</id> + <id>39</id> <height>440</height> <width>1404</width> <font_name>맑은 고딕</font_name> @@ -225,16 +222,16 @@ <name>로그</name> <selected>true</selected> <node_element>1</node_element> - <node_element>23</node_element> <node_element>19</node_element> - <node_element>29</node_element> + <node_element>15</node_element> + <node_element>23</node_element> <node_element>2</node_element> - <node_element>32</node_element> + <node_element>26</node_element> </category> <category> - <id>46</id> + <id>40</id> <height>1041</height> - <width>1020</width> + <width>1296</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> <x>1836</x> @@ -248,13 +245,14 @@ </connections> <name>게시판</name> <selected>true</selected> - <node_element>39</node_element> - <node_element>40</node_element> - <node_element>30</node_element> - <node_element>34</node_element> + <node_element>32</node_element> + <node_element>33</node_element> + <node_element>24</node_element> + <node_element>28</node_element> + <node_element>5</node_element> <node_element>8</node_element> - <node_element>11</node_element> - <node_element>31</node_element> + <node_element>25</node_element> + <node_element>27</node_element> </category> </categories> </category_settings> @@ -280,7 +278,7 @@ </connections> <display>false</display> <creation_date>2022-01-26 16:20:32</creation_date> - <updated_date>2022-02-14 13:51:34</updated_date> + <updated_date>2022-02-16 16:40:38</updated_date> <model_property> <name>프로젝트명</name> <value></value> @@ -780,22 +778,6 @@ </word> <word> <id>29</id> - <length>1000</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>change_requst_cn</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>30</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -811,7 +793,7 @@ <type>timestamp</type> </word> <word> - <id>31</id> + <id>30</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -827,7 +809,7 @@ <type>character(n)</type> </word> <word> - <id>32</id> + <id>31</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -843,7 +825,7 @@ <type>varchar(n)</type> </word> <word> - <id>33</id> + <id>32</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -859,7 +841,7 @@ <type>varchar(n)</type> </word> <word> - <id>34</id> + <id>33</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -875,7 +857,7 @@ <type>varchar(n)</type> </word> <word> - <id>35</id> + <id>34</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -891,7 +873,7 @@ <type>varchar(n)</type> </word> <word> - <id>36</id> + <id>35</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -907,7 +889,7 @@ <type>varchar(n)</type> </word> <word> - <id>37</id> + <id>36</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -923,7 +905,7 @@ <type>varchar(n)</type> </word> <word> - <id>38</id> + <id>37</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -939,7 +921,7 @@ <type>varchar(n)</type> </word> <word> - <id>39</id> + <id>38</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -955,7 +937,7 @@ <type>varchar(n)</type> </word> <word> - <id>40</id> + <id>39</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -971,7 +953,7 @@ <type>varchar(n)</type> </word> <word> - <id>41</id> + <id>40</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -987,7 +969,7 @@ <type>varchar(n)</type> </word> <word> - <id>42</id> + <id>41</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -1003,7 +985,7 @@ <type>varchar(n)</type> </word> <word> - <id>43</id> + <id>42</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1019,23 +1001,7 @@ <type>character(n)</type> </word> <word> - <id>44</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>creatr_id</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>45</id> + <id>43</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1051,7 +1017,7 @@ <type>numeric(p)</type> </word> <word> - <id>46</id> + <id>44</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1067,7 +1033,7 @@ <type>numeric(p)</type> </word> <word> - <id>47</id> + <id>45</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1083,7 +1049,7 @@ <type>timestamp</type> </word> <word> - <id>48</id> + <id>46</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1099,7 +1065,7 @@ <type>varchar(n)</type> </word> <word> - <id>49</id> + <id>47</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -1115,7 +1081,7 @@ <type>varchar(n)</type> </word> <word> - <id>50</id> + <id>48</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -1131,7 +1097,7 @@ <type>varchar(n)</type> </word> <word> - <id>51</id> + <id>49</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -1147,7 +1113,7 @@ <type>character(n)</type> </word> <word> - <id>52</id> + <id>50</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1163,7 +1129,7 @@ <type>numeric(p)</type> </word> <word> - <id>53</id> + <id>51</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1179,7 +1145,7 @@ <type>numeric(p)</type> </word> <word> - <id>54</id> + <id>52</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1195,7 +1161,7 @@ <type>varchar(n)</type> </word> <word> - <id>55</id> + <id>53</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1211,7 +1177,7 @@ <type>char</type> </word> <word> - <id>56</id> + <id>54</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -1227,7 +1193,7 @@ <type>varchar(n)</type> </word> <word> - <id>57</id> + <id>55</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1243,7 +1209,7 @@ <type>varchar(n)</type> </word> <word> - <id>58</id> + <id>56</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1259,7 +1225,7 @@ <type>char</type> </word> <word> - <id>59</id> + <id>57</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1275,7 +1241,7 @@ <type>varchar(n)</type> </word> <word> - <id>60</id> + <id>58</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1291,7 +1257,7 @@ <type>varchar(n)</type> </word> <word> - <id>61</id> + <id>59</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1307,7 +1273,7 @@ <type>varchar(n)</type> </word> <word> - <id>62</id> + <id>60</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1323,7 +1289,7 @@ <type>varchar(n)</type> </word> <word> - <id>63</id> + <id>61</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -1339,7 +1305,7 @@ <type>varchar(n)</type> </word> <word> - <id>64</id> + <id>62</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1355,7 +1321,7 @@ <type>varchar(n)</type> </word> <word> - <id>65</id> + <id>63</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1371,7 +1337,7 @@ <type>varchar(n)</type> </word> <word> - <id>66</id> + <id>64</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -1387,7 +1353,7 @@ <type>varchar(n)</type> </word> <word> - <id>67</id> + <id>65</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1403,7 +1369,7 @@ <type>varchar(n)</type> </word> <word> - <id>68</id> + <id>66</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -1419,7 +1385,7 @@ <type>character(n)</type> </word> <word> - <id>69</id> + <id>67</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1435,7 +1401,7 @@ <type>numeric(p)</type> </word> <word> - <id>70</id> + <id>68</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1451,7 +1417,7 @@ <type>numeric(p)</type> </word> <word> - <id>71</id> + <id>69</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -1467,7 +1433,7 @@ <type>character(n)</type> </word> <word> - <id>72</id> + <id>70</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1483,7 +1449,7 @@ <type>char</type> </word> <word> - <id>73</id> + <id>71</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1499,7 +1465,7 @@ <type>char</type> </word> <word> - <id>74</id> + <id>72</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1515,7 +1481,7 @@ <type>character(n)</type> </word> <word> - <id>75</id> + <id>73</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1531,7 +1497,7 @@ <type>character(n)</type> </word> <word> - <id>76</id> + <id>74</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1547,7 +1513,7 @@ <type>char</type> </word> <word> - <id>77</id> + <id>75</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1563,7 +1529,7 @@ <type>text</type> </word> <word> - <id>78</id> + <id>76</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1579,7 +1545,7 @@ <type>varchar(n)</type> </word> <word> - <id>79</id> + <id>77</id> <length>32</length> <decimal>null</decimal> <array>false</array> @@ -1595,7 +1561,7 @@ <type>varchar(n)</type> </word> <word> - <id>80</id> + <id>78</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1611,7 +1577,7 @@ <type>varchar(n)</type> </word> <word> - <id>81</id> + <id>79</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -1627,7 +1593,7 @@ <type>numeric(p)</type> </word> <word> - <id>82</id> + <id>80</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -1643,7 +1609,7 @@ <type>numeric(p)</type> </word> <word> - <id>83</id> + <id>81</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1659,7 +1625,7 @@ <type>numeric(p)</type> </word> <word> - <id>84</id> + <id>82</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -1675,7 +1641,7 @@ <type>varchar(n)</type> </word> <word> - <id>85</id> + <id>83</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1691,7 +1657,7 @@ <type>varchar(n)</type> </word> <word> - <id>86</id> + <id>84</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1707,7 +1673,7 @@ <type>varchar(n)</type> </word> <word> - <id>87</id> + <id>85</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1723,7 +1689,7 @@ <type>timestamp</type> </word> <word> - <id>88</id> + <id>86</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1739,7 +1705,7 @@ <type>timestamp</type> </word> <word> - <id>89</id> + <id>87</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1755,7 +1721,7 @@ <type>text</type> </word> <word> - <id>90</id> + <id>88</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1771,7 +1737,7 @@ <type>varchar(n)</type> </word> <word> - <id>91</id> + <id>89</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1787,7 +1753,7 @@ <type>timestamp</type> </word> <word> - <id>92</id> + <id>90</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1803,7 +1769,7 @@ <type>varchar(n)</type> </word> <word> - <id>93</id> + <id>91</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1819,7 +1785,7 @@ <type></type> </word> <word> - <id>94</id> + <id>92</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1835,7 +1801,7 @@ <type>character(n)</type> </word> <word> - <id>95</id> + <id>93</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -1851,7 +1817,7 @@ <type>varchar(n)</type> </word> <word> - <id>96</id> + <id>94</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1867,7 +1833,7 @@ <type>varchar(n)</type> </word> <word> - <id>97</id> + <id>95</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1883,7 +1849,7 @@ <type>varchar(n)</type> </word> <word> - <id>98</id> + <id>96</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1899,7 +1865,7 @@ <type>varchar(n)</type> </word> <word> - <id>99</id> + <id>97</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -1915,7 +1881,7 @@ <type>numeric(p)</type> </word> <word> - <id>100</id> + <id>98</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1931,7 +1897,7 @@ <type>varchar(n)</type> </word> <word> - <id>101</id> + <id>99</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -1947,7 +1913,7 @@ <type>varchar(n)</type> </word> <word> - <id>102</id> + <id>100</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1963,7 +1929,7 @@ <type>char</type> </word> <word> - <id>103</id> + <id>101</id> <length>7</length> <decimal>null</decimal> <array>false</array> @@ -1979,7 +1945,7 @@ <type>character(n)</type> </word> <word> - <id>104</id> + <id>102</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -1995,7 +1961,7 @@ <type>varchar(n)</type> </word> <word> - <id>105</id> + <id>103</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2011,7 +1977,7 @@ <type>character(n)</type> </word> <word> - <id>106</id> + <id>104</id> <length>13</length> <decimal>null</decimal> <array>false</array> @@ -2027,7 +1993,7 @@ <type>varchar(n)</type> </word> <word> - <id>107</id> + <id>105</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2043,7 +2009,7 @@ <type>timestamp</type> </word> <word> - <id>108</id> + <id>106</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2059,7 +2025,7 @@ <type>timestamp</type> </word> <word> - <id>109</id> + <id>107</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2075,7 +2041,7 @@ <type>varchar(n)</type> </word> <word> - <id>110</id> + <id>108</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2091,7 +2057,7 @@ <type>varchar(n)</type> </word> <word> - <id>111</id> + <id>109</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2107,7 +2073,7 @@ <type>text</type> </word> <word> - <id>112</id> + <id>110</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2123,7 +2089,7 @@ <type>char</type> </word> <word> - <id>113</id> + <id>111</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2139,7 +2105,7 @@ <type>char</type> </word> <word> - <id>114</id> + <id>112</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2155,7 +2121,7 @@ <type>numeric(p)</type> </word> <word> - <id>115</id> + <id>113</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2171,7 +2137,7 @@ <type>timestamp</type> </word> <word> - <id>116</id> + <id>114</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2187,55 +2153,7 @@ <type>character(n)</type> </word> <word> - <id>117</id> - <length>30</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>mapng_creat_id</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>118</id> - <length>60</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>매핑파일명</description> - <logical_name>매핑파일명</logical_name> - <physical_name>mapng_file_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>119</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>true</char_semantics> - <description>매핑파일경로</description> - <logical_name>매핑파일경로</logical_name> - <physical_name>mapng_file_path</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>120</id> + <id>115</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2251,7 +2169,7 @@ <type>varchar(n)</type> </word> <word> - <id>121</id> + <id>116</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2267,7 +2185,7 @@ <type>varchar(n)</type> </word> <word> - <id>122</id> + <id>117</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2283,7 +2201,7 @@ <type>varchar(n)</type> </word> <word> - <id>123</id> + <id>118</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2299,7 +2217,7 @@ <type>varchar(n)</type> </word> <word> - <id>124</id> + <id>119</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -2315,7 +2233,7 @@ <type>varchar(n)</type> </word> <word> - <id>125</id> + <id>120</id> <length>5</length> <decimal>null</decimal> <array>false</array> @@ -2331,7 +2249,7 @@ <type>character(n)</type> </word> <word> - <id>126</id> + <id>121</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2347,23 +2265,7 @@ <type>varchar(n)</type> </word> <word> - <id>127</id> - <length>250</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>menu_dc</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>128</id> + <id>122</id> <length>250</length> <decimal>null</decimal> <array>false</array> @@ -2379,7 +2281,7 @@ <type>varchar(n)</type> </word> <word> - <id>129</id> + <id>123</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -2395,39 +2297,7 @@ <type>varchar(n)</type> </word> <word> - <id>130</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>menu_id</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>131</id> - <length>60</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>메뉴명</description> - <logical_name>메뉴명</logical_name> - <physical_name>menu_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>132</id> + <id>124</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2443,23 +2313,7 @@ <type>varchar(n)</type> </word> <word> - <id>133</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>menu_no</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>134</id> + <id>125</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2475,7 +2329,7 @@ <type>varchar(n)</type> </word> <word> - <id>135</id> + <id>126</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2491,23 +2345,7 @@ <type>integer</type> </word> <word> - <id>136</id> - <length>5</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>menu_ordr</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>137</id> + <id>127</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2523,7 +2361,7 @@ <type>varchar(n)</type> </word> <word> - <id>138</id> + <id>128</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2539,7 +2377,7 @@ <type>varchar(n)</type> </word> <word> - <id>139</id> + <id>129</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -2555,7 +2393,7 @@ <type>varchar(n)</type> </word> <word> - <id>140</id> + <id>130</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2571,7 +2409,7 @@ <type>text</type> </word> <word> - <id>141</id> + <id>131</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -2587,7 +2425,7 @@ <type>numeric(p)</type> </word> <word> - <id>142</id> + <id>132</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2603,7 +2441,7 @@ <type>char</type> </word> <word> - <id>143</id> + <id>133</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2619,7 +2457,7 @@ <type>character(n)</type> </word> <word> - <id>144</id> + <id>134</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2635,7 +2473,7 @@ <type>character(n)</type> </word> <word> - <id>145</id> + <id>135</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2651,7 +2489,7 @@ <type>varchar(n)</type> </word> <word> - <id>146</id> + <id>136</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2667,7 +2505,7 @@ <type>varchar(n)</type> </word> <word> - <id>147</id> + <id>137</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2683,7 +2521,7 @@ <type>text</type> </word> <word> - <id>148</id> + <id>138</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2699,7 +2537,7 @@ <type>numeric(p)</type> </word> <word> - <id>149</id> + <id>139</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2715,7 +2553,7 @@ <type>numeric(p)</type> </word> <word> - <id>150</id> + <id>140</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -2731,7 +2569,7 @@ <type>varchar(n)</type> </word> <word> - <id>151</id> + <id>141</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2747,7 +2585,7 @@ <type>character(n)</type> </word> <word> - <id>152</id> + <id>142</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2763,7 +2601,7 @@ <type>character(n)</type> </word> <word> - <id>153</id> + <id>143</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2779,7 +2617,7 @@ <type>timestamp</type> </word> <word> - <id>154</id> + <id>144</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2795,7 +2633,7 @@ <type>varchar(n)</type> </word> <word> - <id>155</id> + <id>145</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2811,23 +2649,7 @@ <type>varchar(n)</type> </word> <word> - <id>156</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>opetr_id</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>157</id> + <id>146</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2843,7 +2665,7 @@ <type>varchar(n)</type> </word> <word> - <id>158</id> + <id>147</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2859,7 +2681,7 @@ <type></type> </word> <word> - <id>159</id> + <id>148</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2875,7 +2697,7 @@ <type>character(n)</type> </word> <word> - <id>160</id> + <id>149</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2891,7 +2713,7 @@ <type>varchar(n)</type> </word> <word> - <id>161</id> + <id>150</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2907,7 +2729,7 @@ <type>text</type> </word> <word> - <id>162</id> + <id>151</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -2923,7 +2745,7 @@ <type>varchar(n)</type> </word> <word> - <id>163</id> + <id>152</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2939,7 +2761,7 @@ <type>numeric(p)</type> </word> <word> - <id>164</id> + <id>153</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2955,7 +2777,7 @@ <type>numeric(p)</type> </word> <word> - <id>165</id> + <id>154</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2971,7 +2793,7 @@ <type>numeric(p)</type> </word> <word> - <id>166</id> + <id>155</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -2987,7 +2809,7 @@ <type>varchar(n)</type> </word> <word> - <id>167</id> + <id>156</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3003,7 +2825,7 @@ <type>varchar(n)</type> </word> <word> - <id>168</id> + <id>157</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3019,7 +2841,7 @@ <type>varchar(n)</type> </word> <word> - <id>169</id> + <id>158</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3035,7 +2857,7 @@ <type>varchar(n)</type> </word> <word> - <id>170</id> + <id>159</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3051,23 +2873,7 @@ <type>numeric(p)</type> </word> <word> - <id>171</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>process_de</physical_name> - <type>character(n)</type> - </word> - <word> - <id>172</id> + <id>160</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -3083,8 +2889,8 @@ <type>character(n)</type> </word> <word> - <id>173</id> - <length>15</length> + <id>161</id> + <length>14</length> <decimal>null</decimal> <array>false</array> <array_dimension>null</array_dimension> @@ -3093,14 +2899,14 @@ <binary>false</binary> <args></args> <char_semantics>true</char_semantics> - <description>처리상태코드</description> - <logical_name>처리상태코드</logical_name> - <physical_name>process_sttus_code</physical_name> + <description>처리시간</description> + <logical_name>처리시간</logical_name> + <physical_name>process_time</physical_name> <type>varchar(n)</type> </word> <word> - <id>174</id> - <length>14</length> + <id>162</id> + <length>1</length> <decimal>null</decimal> <array>false</array> <array_dimension>null</array_dimension> @@ -3109,94 +2915,14 @@ <binary>false</binary> <args></args> <char_semantics>true</char_semantics> - <description>처리시간</description> - <logical_name>처리시간</logical_name> - <physical_name>process_time</physical_name> + <description>프로그램구분 C:컨텐츠 P:프로그램 B:게시판 D:폴더</description> + <logical_name>프로그램구분 C:컨텐츠 P:프로그램 B:게시판 D:폴더</logical_name> + <physical_name>progr_gb</physical_name> <type>varchar(n)</type> </word> <word> - <id>175</id> - <length>200</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>progrm_dc</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>176</id> - <length>60</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>프로그램파일명</description> - <logical_name>프로그램파일명</logical_name> - <physical_name>progrm_file_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>177</id> - <length>60</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>프로그램한글명</description> - <logical_name>프로그램한글명</logical_name> - <physical_name>progrm_korean_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>178</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>true</char_semantics> - <description>프로그램저장경로</description> - <logical_name>프로그램저장경로</logical_name> - <physical_name>progrm_stre_path</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>179</id> - <length>1</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>프로그램구분 C:컨텐츠 P:프로그램 B:게시판 D:폴더</description> - <logical_name>프로그램구분 C:컨텐츠 P:프로그램 B:게시판 D:폴더</logical_name> - <physical_name>progr_gb</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>180</id> - <length>60</length> + <id>163</id> + <length>60</length> <decimal>null</decimal> <array>false</array> <array_dimension>null</array_dimension> @@ -3211,7 +2937,7 @@ <type>varchar(n)</type> </word> <word> - <id>181</id> + <id>164</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3227,7 +2953,7 @@ <type>varchar(n)</type> </word> <word> - <id>182</id> + <id>165</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3243,7 +2969,7 @@ <type>character(n)</type> </word> <word> - <id>183</id> + <id>166</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3259,7 +2985,7 @@ <type>numeric(p)</type> </word> <word> - <id>184</id> + <id>167</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3275,7 +3001,7 @@ <type>numeric(p)</type> </word> <word> - <id>185</id> + <id>168</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3291,7 +3017,7 @@ <type>varchar(n)</type> </word> <word> - <id>186</id> + <id>169</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3307,7 +3033,7 @@ <type>timestamp</type> </word> <word> - <id>187</id> + <id>170</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3323,7 +3049,7 @@ <type>character(n)</type> </word> <word> - <id>188</id> + <id>171</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3339,39 +3065,7 @@ <type>varchar(n)</type> </word> <word> - <id>189</id> - <length>60</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>관계이미지명</description> - <logical_name>관계이미지명</logical_name> - <physical_name>relate_image_nm</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>190</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>true</char_semantics> - <description>관계이미지경로</description> - <logical_name>관계이미지경로</logical_name> - <physical_name>relate_image_path</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>191</id> + <id>172</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3387,7 +3081,7 @@ <type>char</type> </word> <word> - <id>192</id> + <id>173</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3403,55 +3097,7 @@ <type>varchar(n)</type> </word> <word> - <id>193</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>requst_no</physical_name> - <type>numeric(p)</type> - </word> - <word> - <id>194</id> - <length>null</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>요청처리내용</description> - <logical_name>요청처리내용</logical_name> - <physical_name>requst_process_cn</physical_name> - <type>text</type> - </word> - <word> - <id>195</id> - <length>60</length> - <decimal>null</decimal> - <array>false</array> - <array_dimension>null</array_dimension> - <unsigned>false</unsigned> - <zerofill>false</zerofill> - <binary>false</binary> - <args></args> - <char_semantics>true</char_semantics> - <description>요청제목</description> - <logical_name>요청제목</logical_name> - <physical_name>requst_sj</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>196</id> + <id>174</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3467,7 +3113,7 @@ <type>varchar(n)</type> </word> <word> - <id>197</id> + <id>175</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3483,7 +3129,7 @@ <type>timestamp</type> </word> <word> - <id>198</id> + <id>176</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3499,7 +3145,7 @@ <type>varchar(n)</type> </word> <word> - <id>199</id> + <id>177</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3515,7 +3161,7 @@ <type>varchar(n)</type> </word> <word> - <id>200</id> + <id>178</id> <length>300</length> <decimal>null</decimal> <array>false</array> @@ -3531,7 +3177,7 @@ <type>varchar(n)</type> </word> <word> - <id>201</id> + <id>179</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3547,7 +3193,7 @@ <type>varchar(n)</type> </word> <word> - <id>202</id> + <id>180</id> <length>80</length> <decimal>null</decimal> <array>false</array> @@ -3563,23 +3209,7 @@ <type>varchar(n)</type> </word> <word> - <id>203</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>rqestde</physical_name> - <type>character(n)</type> - </word> - <word> - <id>204</id> + <id>181</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3595,7 +3225,7 @@ <type>varchar(n)</type> </word> <word> - <id>205</id> + <id>182</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3611,7 +3241,7 @@ <type>varchar(n)</type> </word> <word> - <id>206</id> + <id>183</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -3627,7 +3257,7 @@ <type>varchar(n)</type> </word> <word> - <id>207</id> + <id>184</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -3643,7 +3273,7 @@ <type>character(n)</type> </word> <word> - <id>208</id> + <id>185</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3659,7 +3289,7 @@ <type>timestamp</type> </word> <word> - <id>209</id> + <id>186</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3675,7 +3305,7 @@ <type>varchar(n)</type> </word> <word> - <id>210</id> + <id>187</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3691,7 +3321,7 @@ <type>char</type> </word> <word> - <id>211</id> + <id>188</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3707,7 +3337,7 @@ <type>char</type> </word> <word> - <id>212</id> + <id>189</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3723,7 +3353,7 @@ <type>char</type> </word> <word> - <id>213</id> + <id>190</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3739,7 +3369,7 @@ <type>text</type> </word> <word> - <id>214</id> + <id>191</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3755,7 +3385,7 @@ <type>numeric(p)</type> </word> <word> - <id>215</id> + <id>192</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3771,7 +3401,7 @@ <type>varchar(n)</type> </word> <word> - <id>216</id> + <id>193</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3787,7 +3417,7 @@ <type>char</type> </word> <word> - <id>217</id> + <id>194</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3803,7 +3433,7 @@ <type>varchar(n)</type> </word> <word> - <id>218</id> + <id>195</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3819,7 +3449,7 @@ <type>varchar(n)</type> </word> <word> - <id>219</id> + <id>196</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3835,7 +3465,7 @@ <type>text</type> </word> <word> - <id>220</id> + <id>197</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3851,7 +3481,7 @@ <type>varchar(n)</type> </word> <word> - <id>221</id> + <id>198</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3867,7 +3497,7 @@ <type>character(n)</type> </word> <word> - <id>222</id> + <id>199</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3883,7 +3513,7 @@ <type>varchar(n)</type> </word> <word> - <id>223</id> + <id>200</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3899,7 +3529,7 @@ <type>numeric(p)</type> </word> <word> - <id>224</id> + <id>201</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3915,7 +3545,7 @@ <type>numeric(p)</type> </word> <word> - <id>225</id> + <id>202</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3931,7 +3561,7 @@ <type>timestamp</type> </word> <word> - <id>226</id> + <id>203</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3947,7 +3577,7 @@ <type>varchar(n)</type> </word> <word> - <id>227</id> + <id>204</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3963,23 +3593,7 @@ <type>text</type> </word> <word> - <id>228</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>true</char_semantics> - <description>URL</description> - <logical_name>URL</logical_name> - <physical_name>url</physical_name> - <type>varchar(n)</type> - </word> - <word> - <id>229</id> + <id>205</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3995,7 +3609,7 @@ <type>varchar(n)</type> </word> <word> - <id>230</id> + <id>206</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -4011,7 +3625,7 @@ <type>varchar(n)</type> </word> <word> - <id>231</id> + <id>207</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -4027,7 +3641,7 @@ <type>varchar(n)</type> </word> <word> - <id>232</id> + <id>208</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4043,7 +3657,7 @@ <type>varchar(n)</type> </word> <word> - <id>233</id> + <id>209</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4059,7 +3673,7 @@ <type>varchar(n)</type> </word> <word> - <id>234</id> + <id>210</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -4075,7 +3689,7 @@ <type>varchar(n)</type> </word> <word> - <id>235</id> + <id>211</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -4091,7 +3705,7 @@ <type>varchar(n)</type> </word> <word> - <id>236</id> + <id>212</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4107,7 +3721,7 @@ <type></type> </word> <word> - <id>237</id> + <id>213</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -4123,7 +3737,7 @@ <type>varchar(n)</type> </word> <word> - <id>238</id> + <id>214</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -4139,7 +3753,7 @@ <type>char</type> </word> <word> - <id>239</id> + <id>215</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -4155,7 +3769,7 @@ <type>varchar(n)</type> </word> <word> - <id>240</id> + <id>216</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4171,7 +3785,7 @@ <type>varchar(n)</type> </word> <word> - <id>241</id> + <id>217</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -4187,7 +3801,7 @@ <type>varchar(n)</type> </word> <word> - <id>242</id> + <id>218</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -4227,7 +3841,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>75</word_id> + <word_id>72</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4260,7 +3874,7 @@ </sequence> </normal_column> <normal_column> - <word_id>233</word_id> + <word_id>209</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4293,7 +3907,7 @@ </sequence> </normal_column> <normal_column> - <word_id>167</word_id> + <word_id>155</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4326,7 +3940,7 @@ </sequence> </normal_column> <normal_column> - <word_id>235</word_id> + <word_id>211</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4359,7 +3973,7 @@ </sequence> </normal_column> <normal_column> - <word_id>237</word_id> + <word_id>213</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4392,7 +4006,7 @@ </sequence> </normal_column> <normal_column> - <word_id>230</word_id> + <word_id>206</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4425,7 +4039,7 @@ </sequence> </normal_column> <normal_column> - <word_id>231</word_id> + <word_id>207</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4458,7 +4072,7 @@ </sequence> </normal_column> <normal_column> - <word_id>93</word_id> + <word_id>91</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4491,7 +4105,7 @@ </sequence> </normal_column> <normal_column> - <word_id>236</word_id> + <word_id>212</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4524,7 +4138,7 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> + <word_id>147</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4584,7 +4198,7 @@ <option></option> <columns> <normal_column> - <word_id>151</word_id> + <word_id>141</word_id> <id>0</id> <description></description> <unique_key_name></unique_key_name> @@ -4617,7 +4231,7 @@ </sequence> </normal_column> <normal_column> - <word_id>229</word_id> + <word_id>205</word_id> <id>1</id> <description></description> <unique_key_name></unique_key_name> @@ -4650,7 +4264,7 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> + <word_id>166</word_id> <id>2</id> <description></description> <unique_key_name></unique_key_name> @@ -4715,7 +4329,7 @@ <option></option> <columns> <normal_column> - <word_id>151</word_id> + <word_id>141</word_id> <id>3</id> <description></description> <unique_key_name></unique_key_name> @@ -4748,7 +4362,7 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> + <word_id>195</word_id> <id>4</id> <description></description> <unique_key_name></unique_key_name> @@ -4781,7 +4395,7 @@ </sequence> </normal_column> <normal_column> - <word_id>138</word_id> + <word_id>128</word_id> <id>5</id> <description></description> <unique_key_name></unique_key_name> @@ -4814,7 +4428,7 @@ </sequence> </normal_column> <normal_column> - <word_id>45</word_id> + <word_id>43</word_id> <id>6</id> <description></description> <unique_key_name></unique_key_name> @@ -4847,7 +4461,7 @@ </sequence> </normal_column> <normal_column> - <word_id>223</word_id> + <word_id>200</word_id> <id>7</id> <description></description> <unique_key_name></unique_key_name> @@ -4880,7 +4494,7 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> + <word_id>166</word_id> <id>8</id> <description></description> <unique_key_name></unique_key_name> @@ -4913,7 +4527,7 @@ </sequence> </normal_column> <normal_column> - <word_id>52</word_id> + <word_id>50</word_id> <id>9</id> <description></description> <unique_key_name></unique_key_name> @@ -4946,7 +4560,7 @@ </sequence> </normal_column> <normal_column> - <word_id>164</word_id> + <word_id>152</word_id> <id>10</id> <description></description> <unique_key_name></unique_key_name> @@ -4979,7 +4593,7 @@ </sequence> </normal_column> <normal_column> - <word_id>70</word_id> + <word_id>67</word_id> <id>11</id> <description></description> <unique_key_name></unique_key_name> @@ -5037,7 +4651,7 @@ <connections> <relation> <id>0</id> - <source>13</source> + <source>10</source> <target>3</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -5048,10 +4662,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> @@ -5059,7 +4673,7 @@ </relation> <relation> <id>1</id> - <source>13</source> + <source>10</source> <target>3</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -5070,10 +4684,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> @@ -5089,8 +4703,8 @@ <columns> <normal_column> <id>12</id> - <referenced_column>110</referenced_column> - <relation>1</relation> + <referenced_column>94</referenced_column> + <relation>0</relation> <description>부모롤</description> <unique_key_name></unique_key_name> <logical_name>부모롤</logical_name> @@ -5123,8 +4737,8 @@ </normal_column> <normal_column> <id>13</id> - <referenced_column>110</referenced_column> - <relation>0</relation> + <referenced_column>94</referenced_column> + <relation>1</relation> <description>자식롤</description> <unique_key_name></unique_key_name> <logical_name>자식롤</logical_name> @@ -5180,34 +4794,34 @@ </table> <table> <id>4</id> - <height>149</height> - <width>157</width> + <height>107</height> + <width>144</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>906</x> - <y>2131</y> + <x>96</x> + <y>1390</y> <color> - <r>255</r> - <g>0</g> - <b>0</b> + <r>128</r> + <g>128</g> + <b>192</b> </color> <connections> </connections> - <physical_name>comtnprogrmlist</physical_name> - <logical_name>프로그램목록</logical_name> - <description>프로그램목록</description> + <physical_name>comtnorgnztinfo</physical_name> + <logical_name>조직정보</logical_name> + <description>조직정보</description> <constraint></constraint> - <primary_key_name>comtnprogrmlist_pkey</primary_key_name> + <primary_key_name>comtnorgnztinfo_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>176</word_id> + <word_id>148</word_id> <id>14</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -5234,7 +4848,7 @@ </sequence> </normal_column> <normal_column> - <word_id>178</word_id> + <word_id>149</word_id> <id>15</id> <description></description> <unique_key_name></unique_key_name> @@ -5267,7 +4881,7 @@ </sequence> </normal_column> <normal_column> - <word_id>177</word_id> + <word_id>146</word_id> <id>16</id> <description></description> <unique_key_name></unique_key_name> @@ -5299,20 +4913,75 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>5</id> + <height>212</height> + <width>133</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>2543</x> + <y>1593</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>2</id> + <source>25</source> + <target>5</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnfiledetail_atch_file_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtnfiledetail</physical_name> + <logical_name>파일상세정보</logical_name> + <description>파일상세정보</description> + <constraint></constraint> + <primary_key_name>comtnfiledetail_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>175</word_id> <id>17</id> + <referenced_column>227</referenced_column> + <relation>2</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -5333,19 +5002,19 @@ </sequence> </normal_column> <normal_column> - <word_id>228</word_id> + <word_id>81</word_id> <id>18</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>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -5365,52 +5034,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>5</id> - <height>107</height> - <width>144</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>96</x> - <y>1390</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnorgnztinfo</physical_name> - <logical_name>조직정보</logical_name> - <description>조직정보</description> - <constraint></constraint> - <primary_key_name>comtnorgnztinfo_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>159</word_id> + <word_id>82</word_id> <id>19</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -5431,7 +5068,7 @@ </sequence> </normal_column> <normal_column> - <word_id>160</word_id> + <word_id>192</word_id> <id>20</id> <description></description> <unique_key_name></unique_key_name> @@ -5464,7 +5101,7 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> + <word_id>151</word_id> <id>21</id> <description></description> <unique_key_name></unique_key_name> @@ -5496,89 +5133,8 @@ <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>6</id> - <height>212</height> - <width>145</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>906</x> - <y>2340</y> - <color> - <r>255</r> - <g>0</g> - <b>0</b> - </color> - <connections> - <relation> - <id>2</id> - <source>4</source> - <target>6</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnmenuinfo_progrm_file_nm_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - <relation> - <id>3</id> - <source>6</source> - <target>6</target> - <source_xp>100</source_xp> - <source_yp>50</source_yp> - <target_xp>50</target_xp> - <target_yp>100</target_yp> - <bendpoint> - <relative>true</relative> - <x>100</x> - <y>100</y> - </bendpoint> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnmenuinfo_upper_menu_no_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnmenuinfo</physical_name> - <logical_name>메뉴정보</logical_name> - <description>메뉴정보</description> - <constraint></constraint> - <primary_key_name>comtnmenuinfo_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>131</word_id> + <word_id>76</word_id> <id>22</id> <description></description> <unique_key_name></unique_key_name> @@ -5611,19 +5167,18 @@ </sequence> </normal_column> <normal_column> + <word_id>75</word_id> <id>23</id> - <referenced_column>14</referenced_column> - <relation>2</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> + <foreign_key>false</foreign_key> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -5645,7 +5200,7 @@ </sequence> </normal_column> <normal_column> - <word_id>133</word_id> + <word_id>79</word_id> <id>24</id> <description></description> <unique_key_name></unique_key_name> @@ -5656,1140 +5211,6 @@ <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> - <id>25</id> - <referenced_column>24</referenced_column> - <relation>3</relation> - <description>상위메뉴번호</description> - <unique_key_name></unique_key_name> - <logical_name>상위메뉴번호</logical_name> - <physical_name>upper_menu_no</physical_name> - <type>numeric(p)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>136</word_id> - <id>26</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>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>128</word_id> - <id>27</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>190</word_id> - <id>28</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>189</word_id> - <id>29</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> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnmenuinfo_i02</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>25</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>7</id> - <height>107</height> - <width>164</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>642</x> - <y>2392</y> - <color> - <r>255</r> - <g>0</g> - <b>0</b> - </color> - <connections> - <relation> - <id>4</id> - <source>6</source> - <target>7</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnmenucreatdtls_menu_no_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - <relation> - <id>5</id> - <source>13</source> - <target>7</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnmenucreatdtls_author_code_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - <relation> - <id>6</id> - <source>27</source> - <target>7</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnmenucreatdtls_mapng_creat_id_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnmenucreatdtls</physical_name> - <logical_name>메뉴생성내역</logical_name> - <description>메뉴생성내역</description> - <constraint></constraint> - <primary_key_name>comtnmenucreatdtls_pkey</primary_key_name> - <option></option> - <columns> - <normal_column> - <id>30</id> - <referenced_column>24</referenced_column> - <relation>4</relation> - <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>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <id>31</id> - <referenced_column>110</referenced_column> - <relation>5</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <id>32</id> - <referenced_column>209</referenced_column> - <relation>6</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>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> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnmenucreatdtls_i02</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>30</id> - <desc>false</desc> - </column> - </columns> - </inidex> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnmenucreatdtls_i03</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>32</id> - <desc>false</desc> - </column> - </columns> - </inidex> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnmenucreatdtls_i04</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>31</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>8</id> - <height>212</height> - <width>133</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2543</x> - <y>1593</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>7</id> - <source>31</source> - <target>8</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnfiledetail_atch_file_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnfiledetail</physical_name> - <logical_name>파일상세정보</logical_name> - <description>파일상세정보</description> - <constraint></constraint> - <primary_key_name>comtnfiledetail_pkey</primary_key_name> - <option></option> - <columns> - <normal_column> - <id>33</id> - <referenced_column>261</referenced_column> - <relation>7</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>text</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <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>83</word_id> - <id>34</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>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>84</word_id> - <id>35</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>215</word_id> - <id>36</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>162</word_id> - <id>37</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>78</word_id> - <id>38</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>77</word_id> - <id>39</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>text</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <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>81</word_id> - <id>40</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> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnfiledetail_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>33</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>9</id> - <height>632</height> - <width>338</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1176</x> - <y>828</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>8</id> - <source>14</source> - <target>9</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnentrprsmber_group_id_fkey</name> - <on_delete_action>SET NULL</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnentrprsmber</physical_name> - <logical_name>기업회원</logical_name> - <description>기업회원</description> - <constraint></constraint> - <primary_key_name>comtnentrprsmber_pkey</primary_key_name> - <option></option> - <columns> - <normal_column> - <word_id>62</word_id> - <id>41</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>68</word_id> - <id>42</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>character(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>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>24</word_id> - <id>43</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>106</word_id> - <id>44</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>34</word_id> - <id>45</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>49</word_id> - <id>46</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>242</word_id> - <id>47</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>0</word_id> - <id>48</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>67</word_id> - <id>49</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>90</word_id> - <id>50</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> @@ -6811,42 +5232,76 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - <normal_column> - <word_id>102</word_id> - <id>51</id> + </columns> + <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnfiledetail_i01</name> + <type>BTREE</type> <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>char</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>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> + <column> + <id>17</id> + <desc>false</desc> + </column> + </columns> + </inidex> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>6</id> + <height>632</height> + <width>338</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1176</x> + <y>828</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>3</id> + <source>11</source> + <target>6</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>0..1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnentrprsmber_group_id_fkey</name> + <on_delete_action>SET NULL</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtnentrprsmber</physical_name> + <logical_name>기업회원</logical_name> + <description>기업회원</description> + <constraint></constraint> + <primary_key_name>comtnentrprsmber_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>8</word_id> - <id>52</id> + <word_id>60</word_id> + <id>25</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6857,7 +5312,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -6878,13 +5333,13 @@ </sequence> </normal_column> <normal_column> - <word_id>7</word_id> - <id>53</id> + <word_id>66</word_id> + <id>26</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -6911,13 +5366,13 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> - <id>54</id> + <word_id>24</word_id> + <id>27</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -6944,8 +5399,8 @@ </sequence> </normal_column> <normal_column> - <word_id>66</word_id> - <id>55</id> + <word_id>104</word_id> + <id>28</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6977,8 +5432,8 @@ </sequence> </normal_column> <normal_column> - <word_id>63</word_id> - <id>56</id> + <word_id>33</word_id> + <id>29</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6988,7 +5443,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7010,8 +5465,8 @@ </sequence> </normal_column> <normal_column> - <word_id>65</word_id> - <id>57</id> + <word_id>47</word_id> + <id>30</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7021,7 +5476,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7043,8 +5498,8 @@ </sequence> </normal_column> <normal_column> - <word_id>64</word_id> - <id>58</id> + <word_id>218</word_id> + <id>31</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7076,19 +5531,18 @@ </sequence> </normal_column> <normal_column> - <id>59</id> - <referenced_column>114</referenced_column> - <relation>8</relation> + <word_id>0</word_id> + <id>32</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> + <foreign_key>false</foreign_key> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7110,8 +5564,8 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> - <id>60</id> + <word_id>65</word_id> + <id>33</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7121,7 +5575,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7143,8 +5597,8 @@ </sequence> </normal_column> <normal_column> - <word_id>61</word_id> - <id>61</id> + <word_id>88</word_id> + <id>34</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7154,7 +5608,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7176,18 +5630,18 @@ </sequence> </normal_column> <normal_column> - <word_id>9</word_id> - <id>62</id> + <word_id>100</word_id> + <id>35</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7209,8 +5663,8 @@ </sequence> </normal_column> <normal_column> - <word_id>6</word_id> - <id>63</id> + <word_id>8</word_id> + <id>36</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7242,18 +5696,18 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> - <id>64</id> + <word_id>7</word_id> + <id>37</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7275,13 +5729,13 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> - <id>65</id> + <word_id>185</word_id> + <id>38</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -7308,13 +5762,13 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>66</id> + <word_id>64</word_id> + <id>39</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> @@ -7341,13 +5795,13 @@ </sequence> </normal_column> <normal_column> - <word_id>115</word_id> - <id>67</id> + <word_id>61</word_id> + <id>40</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -7374,18 +5828,18 @@ </sequence> </normal_column> <normal_column> - <word_id>30</word_id> - <id>68</id> + <word_id>63</word_id> + <id>41</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7406,98 +5860,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnentrprsmber_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>59</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>10</id> - <height>695</height> - <width>284</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>468</x> - <y>818</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>9</id> - <source>14</source> - <target>10</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnemplyrinfo_group_id_fkey</name> - <on_delete_action>SET NULL</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - <relation> - <id>10</id> - <source>5</source> - <target>10</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnemplyrinfo_orgnzt_id_fkey</name> - <on_delete_action>SET NULL</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnemplyrinfo</physical_name> - <logical_name>업무사용자정보</logical_name> - <description>업무사용자정보</description> - <constraint></constraint> - <primary_key_name>comtnemplyrinfo_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>57</word_id> - <id>69</id> + <word_id>62</word_id> + <id>42</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7508,7 +5873,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -7529,9 +5894,9 @@ </sequence> </normal_column> <normal_column> - <id>70</id> - <referenced_column>19</referenced_column> - <relation>10</relation> + <id>43</id> + <referenced_column>98</referenced_column> + <relation>3</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7563,8 +5928,8 @@ </sequence> </normal_column> <normal_column> - <word_id>234</word_id> - <id>71</id> + <word_id>52</word_id> + <id>44</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7574,7 +5939,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7596,8 +5961,8 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> - <id>72</id> + <word_id>59</word_id> + <id>45</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7629,8 +5994,8 @@ </sequence> </normal_column> <normal_column> - <word_id>59</word_id> - <id>73</id> + <word_id>9</word_id> + <id>46</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7640,7 +6005,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7662,8 +6027,8 @@ </sequence> </normal_column> <normal_column> - <word_id>101</word_id> - <id>74</id> + <word_id>6</word_id> + <id>47</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7673,7 +6038,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7695,18 +6060,18 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> - <id>75</id> + <word_id>73</word_id> + <id>48</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7728,13 +6093,13 @@ </sequence> </normal_column> <normal_column> - <word_id>27</word_id> - <id>76</id> + <word_id>111</word_id> + <id>49</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -7761,13 +6126,13 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>77</id> + <word_id>112</word_id> + <id>50</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> @@ -7794,18 +6159,18 @@ </sequence> </normal_column> <normal_column> - <word_id>96</word_id> - <id>78</id> + <word_id>113</word_id> + <id>51</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7827,18 +6192,18 @@ </sequence> </normal_column> <normal_column> - <word_id>169</word_id> - <id>79</id> + <word_id>29</word_id> + <id>52</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7859,9 +6224,98 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnentrprsmber_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>43</id> + <desc>false</desc> + </column> + </columns> + </inidex> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>7</id> + <height>695</height> + <width>284</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>468</x> + <y>818</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>4</id> + <source>11</source> + <target>7</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>0..1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnemplyrinfo_group_id_fkey</name> + <on_delete_action>SET NULL</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + <relation> + <id>5</id> + <source>4</source> + <target>7</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>0..1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnemplyrinfo_orgnzt_id_fkey</name> + <on_delete_action>SET NULL</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtnemplyrinfo</physical_name> + <logical_name>업무사용자정보</logical_name> + <description>업무사용자정보</description> + <constraint></constraint> + <primary_key_name>comtnemplyrinfo_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>168</word_id> - <id>80</id> + <word_id>55</word_id> + <id>53</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7872,6 +6326,40 @@ <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> + <id>54</id> + <referenced_column>14</referenced_column> + <relation>5</relation> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>character(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>true</foreign_key> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -7893,8 +6381,8 @@ </sequence> </normal_column> <normal_column> - <word_id>97</word_id> - <id>81</id> + <word_id>210</word_id> + <id>55</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7926,8 +6414,8 @@ </sequence> </normal_column> <normal_column> - <word_id>9</word_id> - <id>82</id> + <word_id>156</word_id> + <id>56</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7959,8 +6447,8 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> - <id>83</id> + <word_id>57</word_id> + <id>57</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7992,8 +6480,8 @@ </sequence> </normal_column> <normal_column> - <word_id>242</word_id> - <id>84</id> + <word_id>99</word_id> + <id>58</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8003,7 +6491,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8025,13 +6513,13 @@ </sequence> </normal_column> <normal_column> - <word_id>155</word_id> - <id>85</id> + <word_id>188</word_id> + <id>59</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8058,13 +6546,13 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> - <id>86</id> + <word_id>27</word_id> + <id>60</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8091,8 +6579,8 @@ </sequence> </normal_column> <normal_column> - <word_id>56</word_id> - <id>87</id> + <word_id>88</word_id> + <id>61</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8124,8 +6612,8 @@ </sequence> </normal_column> <normal_column> - <word_id>154</word_id> - <id>88</id> + <word_id>94</word_id> + <id>62</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8135,7 +6623,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8157,8 +6645,8 @@ </sequence> </normal_column> <normal_column> - <word_id>98</word_id> - <id>89</id> + <word_id>158</word_id> + <id>63</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8190,19 +6678,18 @@ </sequence> </normal_column> <normal_column> - <id>90</id> - <referenced_column>114</referenced_column> - <relation>9</relation> + <word_id>157</word_id> + <id>64</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> + <foreign_key>false</foreign_key> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8224,18 +6711,18 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> - <id>91</id> + <word_id>95</word_id> + <id>65</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8257,13 +6744,13 @@ </sequence> </normal_column> <normal_column> - <word_id>58</word_id> - <id>92</id> + <word_id>9</word_id> + <id>66</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8290,18 +6777,18 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> - <id>93</id> + <word_id>52</word_id> + <id>67</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8323,8 +6810,8 @@ </sequence> </normal_column> <normal_column> - <word_id>48</word_id> - <id>94</id> + <word_id>218</word_id> + <id>68</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8334,7 +6821,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8356,13 +6843,13 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> - <id>95</id> + <word_id>145</word_id> + <id>69</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8389,13 +6876,13 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> - <id>96</id> + <word_id>121</word_id> + <id>70</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8422,13 +6909,13 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>97</id> + <word_id>54</word_id> + <id>71</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> @@ -8455,13 +6942,13 @@ </sequence> </normal_column> <normal_column> - <word_id>115</word_id> - <id>98</id> + <word_id>144</word_id> + <id>72</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8488,18 +6975,18 @@ </sequence> </normal_column> <normal_column> - <word_id>30</word_id> - <id>99</id> + <word_id>96</word_id> + <id>73</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8520,67 +7007,10 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnemplyrinfo_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>70</id> - <desc>false</desc> - </column> - </columns> - </inidex> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnemplyrinfo_i02</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>90</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>11</id> - <height>191</height> - <width>168</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1980</x> - <y>824</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnbbsmasteroptn</physical_name> - <logical_name>게시판마스터옵션</logical_name> - <description>게시판마스터옵션</description> - <constraint></constraint> - <primary_key_name>comtnbbsmasteroptn_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>20</word_id> - <id>100</id> + <id>74</id> + <referenced_column>98</referenced_column> + <relation>4</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8589,9 +7019,9 @@ <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> + <foreign_key>true</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -8612,18 +7042,18 @@ </sequence> </normal_column> <normal_column> - <word_id>2</word_id> - <id>101</id> + <word_id>165</word_id> + <id>75</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8645,8 +7075,8 @@ </sequence> </normal_column> <normal_column> - <word_id>216</word_id> - <id>102</id> + <word_id>56</word_id> + <id>76</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8678,13 +7108,13 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>103</id> + <word_id>73</word_id> + <id>77</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8711,13 +7141,13 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>104</id> + <word_id>46</word_id> + <id>78</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8744,18 +7174,18 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>105</id> + <word_id>185</word_id> + <id>79</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -8777,13 +7207,13 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>106</id> + <word_id>111</word_id> + <id>80</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -8809,97 +7239,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>12</id> - <height>107</height> - <width>172</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>279</x> - <y>2388</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>11</id> - <source>13</source> - <target>12</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnauthorrolerelate_author_code_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - <relation> - <id>12</id> - <source>37</source> - <target>12</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnauthorrolerelate_role_code_fkey</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnauthorrolerelate</physical_name> - <logical_name>권한롤관계</logical_name> - <description>권한롤관계</description> - <constraint></constraint> - <primary_key_name>comtnauthorrolerelate_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <id>107</id> - <referenced_column>110</referenced_column> - <relation>11</relation> + <word_id>112</word_id> + <id>81</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -8920,20 +7273,19 @@ </sequence> </normal_column> <normal_column> - <id>108</id> - <referenced_column>327</referenced_column> - <relation>12</relation> + <word_id>113</word_id> + <id>82</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -8954,8 +7306,8 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> - <id>109</id> + <word_id>29</word_id> + <id>83</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -8991,12 +7343,12 @@ <inidex> <full_text>false</full_text> <non_unique>true</non_unique> - <name>comtnauthorrolerelate_i01</name> + <name>comtnemplyrinfo_i01</name> <type>BTREE</type> <description></description> <columns> <column> - <id>107</id> + <id>54</id> <desc>false</desc> </column> </columns> @@ -9004,12 +7356,12 @@ <inidex> <full_text>false</full_text> <non_unique>true</non_unique> - <name>comtnauthorrolerelate_i02</name> + <name>comtnemplyrinfo_i02</name> <type>BTREE</type> <description></description> <columns> <column> - <id>108</id> + <id>74</id> <desc>false</desc> </column> </columns> @@ -9023,13 +7375,13 @@ </table_properties> </table> <table> - <id>13</id> - <height>128</height> - <width>144</width> + <id>8</id> + <height>191</height> + <width>168</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>293</x> - <y>2583</y> + <x>1980</x> + <y>824</y> <color> <r>128</r> <g>128</g> @@ -9037,21 +7389,21 @@ </color> <connections> </connections> - <physical_name>comtnauthorinfo</physical_name> - <logical_name>권한정보</logical_name> - <description>권한정보</description> + <physical_name>comtnbbsmasteroptn</physical_name> + <logical_name>게시판마스터옵션</logical_name> + <description>게시판마스터옵션</description> <constraint></constraint> - <primary_key_name>comtnauthorinfo_pkey</primary_key_name> + <primary_key_name>comtnbbsmasteroptn_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>14</word_id> - <id>110</id> + <word_id>20</word_id> + <id>84</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -9078,13 +7430,13 @@ </sequence> </normal_column> <normal_column> - <word_id>17</word_id> - <id>111</id> + <word_id>2</word_id> + <id>85</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -9111,18 +7463,18 @@ </sequence> </normal_column> <normal_column> - <word_id>16</word_id> - <id>112</id> + <word_id>193</word_id> + <id>86</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -9144,8 +7496,8 @@ </sequence> </normal_column> <normal_column> - <word_id>15</word_id> - <id>113</id> + <word_id>85</word_id> + <id>87</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9176,84 +7528,19 @@ <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>14</id> - <height>128</height> - <width>253</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>840</x> - <y>1140</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnauthorgroupinfo</physical_name> - <logical_name>권한그룹정보</logical_name> - <description>권한그룹정보</description> - <constraint></constraint> - <primary_key_name>comtnauthorgroupinfo_pkey</primary_key_name> - <option></option> - <columns> - <normal_column> - <word_id>94</word_id> - <id>114</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>character(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> <normal_column> - <word_id>95</word_id> - <id>115</id> + <word_id>106</word_id> + <id>88</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -9275,13 +7562,13 @@ </sequence> </normal_column> <normal_column> - <word_id>91</word_id> - <id>116</id> + <word_id>84</word_id> + <id>89</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -9308,8 +7595,8 @@ </sequence> </normal_column> <normal_column> - <word_id>92</word_id> - <id>117</id> + <word_id>108</word_id> + <id>90</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9351,23 +7638,45 @@ </table_properties> </table> <table> - <id>15</id> - <height>254</height> - <width>186</width> + <id>9</id> + <height>107</height> + <width>172</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1182</x> - <y>2079</y> + <x>279</x> + <y>2388</y> <color> - <r>255</r> - <g>0</g> - <b>0</b> + <r>128</r> + <g>128</g> + <b>192</b> </color> <connections> <relation> - <id>13</id> - <source>4</source> - <target>15</target> + <id>6</id> + <source>31</source> + <target>9</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnauthorrolerelate_role_code_fkey</name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + <relation> + <id>7</id> + <source>10</source> + <target>9</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -9380,24 +7689,58 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comthprogrmchangedtls_progrm_file_nm_fkey</name> + <name>comtnauthorrolerelate_author_code_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> <referenced_complex_unique_key>null</referenced_complex_unique_key> </relation> </connections> - <physical_name>comthprogrmchangedtls</physical_name> - <logical_name>프로그램변경내역</logical_name> - <description>프로그램변경내역</description> + <physical_name>comtnauthorrolerelate</physical_name> + <logical_name>권한롤관계</logical_name> + <description>권한롤관계</description> <constraint></constraint> - <primary_key_name>comthprogrmchangedtls_pkey</primary_key_name> + <primary_key_name>comtnauthorrolerelate_pkey</primary_key_name> <option></option> <columns> <normal_column> - <id>118</id> - <referenced_column>14</referenced_column> - <relation>13</relation> + <id>91</id> + <referenced_column>94</referenced_column> + <relation>7</relation> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <id>92</id> + <referenced_column>293</referenced_column> + <relation>6</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9429,19 +7772,19 @@ </sequence> </normal_column> <normal_column> - <word_id>193</word_id> - <id>119</id> + <word_id>45</word_id> + <id>93</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>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> @@ -9461,9 +7804,67 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnauthorrolerelate_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>91</id> + <desc>false</desc> + </column> + </columns> + </inidex> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnauthorrolerelate_i02</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>92</id> + <desc>false</desc> + </column> + </columns> + </inidex> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>10</id> + <height>128</height> + <width>144</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>293</x> + <y>2583</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnauthorinfo</physical_name> + <logical_name>권한정보</logical_name> + <description>권한정보</description> + <constraint></constraint> + <primary_key_name>comtnauthorinfo_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>205</word_id> - <id>120</id> + <word_id>14</word_id> + <id>94</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9474,7 +7875,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -9495,8 +7896,8 @@ </sequence> </normal_column> <normal_column> - <word_id>29</word_id> - <id>121</id> + <word_id>17</word_id> + <id>95</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9506,7 +7907,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -9528,13 +7929,13 @@ </sequence> </normal_column> <normal_column> - <word_id>194</word_id> - <id>122</id> + <word_id>16</word_id> + <id>96</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -9561,18 +7962,18 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> - <id>123</id> + <word_id>15</word_id> + <id>97</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -9593,20 +7994,52 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>11</id> + <height>128</height> + <width>253</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>840</x> + <y>1140</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnauthorgroupinfo</physical_name> + <logical_name>권한그룹정보</logical_name> + <description>권한그룹정보</description> + <constraint></constraint> + <primary_key_name>comtnauthorgroupinfo_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>173</word_id> - <id>124</id> + <word_id>92</word_id> + <id>98</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -9627,18 +8060,18 @@ </sequence> </normal_column> <normal_column> - <word_id>171</word_id> - <id>125</id> + <word_id>93</word_id> + <id>99</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -9660,18 +8093,18 @@ </sequence> </normal_column> <normal_column> - <word_id>203</word_id> - <id>126</id> + <word_id>89</word_id> + <id>100</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -9693,8 +8126,8 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> - <id>127</id> + <word_id>90</word_id> + <id>101</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9704,7 +8137,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -9727,19 +8160,6 @@ </normal_column> </columns> <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comthprogrmchangedtls_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>118</id> - <desc>false</desc> - </column> - </columns> - </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -9749,7 +8169,7 @@ </table_properties> </table> <table> - <id>16</id> + <id>12</id> <height>86</height> <width>125</width> <font_name>맑은 고딕</font_name> @@ -9771,8 +8191,8 @@ <option></option> <columns> <normal_column> - <word_id>220</word_id> - <id>128</id> + <word_id>197</word_id> + <id>102</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9804,8 +8224,8 @@ </sequence> </normal_column> <normal_column> - <word_id>141</word_id> - <id>129</id> + <word_id>131</word_id> + <id>103</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9847,7 +8267,7 @@ </table_properties> </table> <table> - <id>17</id> + <id>13</id> <height>233</height> <width>254</width> <font_name>맑은 고딕</font_name> @@ -9861,9 +8281,9 @@ </color> <connections> <relation> - <id>14</id> - <source>18</source> - <target>17</target> + <id>8</id> + <source>14</source> + <target>13</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -9891,9 +8311,9 @@ <option></option> <columns> <normal_column> - <id>130</id> - <referenced_column>139</referenced_column> - <relation>14</relation> + <id>104</id> + <referenced_column>113</referenced_column> + <relation>8</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9925,8 +8345,8 @@ </sequence> </normal_column> <normal_column> - <word_id>35</word_id> - <id>131</id> + <word_id>34</word_id> + <id>105</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9958,8 +8378,8 @@ </sequence> </normal_column> <normal_column> - <word_id>40</word_id> - <id>132</id> + <word_id>39</word_id> + <id>106</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -9991,8 +8411,8 @@ </sequence> </normal_column> <normal_column> - <word_id>36</word_id> - <id>133</id> + <word_id>35</word_id> + <id>107</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10024,8 +8444,8 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>134</id> + <word_id>214</word_id> + <id>108</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10057,8 +8477,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>135</id> + <word_id>85</word_id> + <id>109</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10090,8 +8510,8 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>136</id> + <word_id>84</word_id> + <id>110</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10123,8 +8543,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>137</id> + <word_id>106</word_id> + <id>111</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10156,8 +8576,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>138</id> + <word_id>108</word_id> + <id>112</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10198,7 +8618,7 @@ <description></description> <columns> <column> - <id>130</id> + <id>104</id> <desc>false</desc> </column> </columns> @@ -10212,7 +8632,7 @@ </table_properties> </table> <table> - <id>18</id> + <id>14</id> <height>233</height> <width>227</width> <font_name>맑은 고딕</font_name> @@ -10226,9 +8646,9 @@ </color> <connections> <relation> - <id>15</id> - <source>21</source> - <target>18</target> + <id>9</id> + <source>17</source> + <target>14</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -10256,8 +8676,8 @@ <option></option> <columns> <normal_column> - <word_id>37</word_id> - <id>139</id> + <word_id>36</word_id> + <id>113</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10289,8 +8709,8 @@ </sequence> </normal_column> <normal_column> - <word_id>39</word_id> - <id>140</id> + <word_id>38</word_id> + <id>114</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10322,8 +8742,8 @@ </sequence> </normal_column> <normal_column> - <word_id>38</word_id> - <id>141</id> + <word_id>37</word_id> + <id>115</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10355,8 +8775,8 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>142</id> + <word_id>214</word_id> + <id>116</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10388,9 +8808,9 @@ </sequence> </normal_column> <normal_column> - <id>143</id> - <referenced_column>155</referenced_column> - <relation>15</relation> + <id>117</id> + <referenced_column>129</referenced_column> + <relation>9</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10422,8 +8842,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>144</id> + <word_id>85</word_id> + <id>118</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10455,8 +8875,8 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>145</id> + <word_id>84</word_id> + <id>119</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10488,8 +8908,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>146</id> + <word_id>106</word_id> + <id>120</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10521,8 +8941,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>147</id> + <word_id>108</word_id> + <id>121</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10563,7 +8983,7 @@ <description></description> <columns> <column> - <id>143</id> + <id>117</id> <desc>false</desc> </column> </columns> @@ -10577,7 +8997,7 @@ </table_properties> </table> <table> - <id>19</id> + <id>15</id> <height>149</height> <width>127</width> <font_name>맑은 고딕</font_name> @@ -10599,8 +9019,8 @@ <option></option> <columns> <normal_column> - <word_id>192</word_id> - <id>148</id> + <word_id>173</word_id> + <id>122</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10632,8 +9052,8 @@ </sequence> </normal_column> <normal_column> - <word_id>153</word_id> - <id>149</id> + <word_id>143</word_id> + <id>123</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10665,8 +9085,8 @@ </sequence> </normal_column> <normal_column> - <word_id>229</word_id> - <id>150</id> + <word_id>205</word_id> + <id>124</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10698,8 +9118,8 @@ </sequence> </normal_column> <normal_column> - <word_id>205</word_id> - <id>151</id> + <word_id>181</word_id> + <id>125</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10731,8 +9151,8 @@ </sequence> </normal_column> <normal_column> - <word_id>206</word_id> - <id>152</id> + <word_id>183</word_id> + <id>126</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10774,7 +9194,7 @@ </table_properties> </table> <table> - <id>20</id> + <id>16</id> <height>86</height> <width>233</width> <font_name>맑은 고딕</font_name> @@ -10796,8 +9216,8 @@ <option></option> <columns> <normal_column> - <word_id>100</word_id> - <id>153</id> + <word_id>98</word_id> + <id>127</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10829,8 +9249,8 @@ </sequence> </normal_column> <normal_column> - <word_id>99</word_id> - <id>154</id> + <word_id>97</word_id> + <id>128</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10872,7 +9292,7 @@ </table_properties> </table> <table> - <id>21</id> + <id>17</id> <height>212</height> <width>157</width> <font_name>맑은 고딕</font_name> @@ -10894,8 +9314,8 @@ <option></option> <columns> <normal_column> - <word_id>31</word_id> - <id>155</id> + <word_id>30</word_id> + <id>129</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10927,8 +9347,8 @@ </sequence> </normal_column> <normal_column> - <word_id>33</word_id> - <id>156</id> + <word_id>32</word_id> + <id>130</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10960,8 +9380,8 @@ </sequence> </normal_column> <normal_column> - <word_id>32</word_id> - <id>157</id> + <word_id>31</word_id> + <id>131</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -10993,8 +9413,8 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>158</id> + <word_id>214</word_id> + <id>132</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11026,8 +9446,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>159</id> + <word_id>85</word_id> + <id>133</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11059,8 +9479,8 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>160</id> + <word_id>84</word_id> + <id>134</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11092,8 +9512,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>161</id> + <word_id>106</word_id> + <id>135</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11125,8 +9545,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>162</id> + <word_id>108</word_id> + <id>136</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11168,7 +9588,7 @@ </table_properties> </table> <table> - <id>22</id> + <id>18</id> <height>548</height> <width>284</width> <font_name>맑은 고딕</font_name> @@ -11182,9 +9602,9 @@ </color> <connections> <relation> - <id>16</id> - <source>14</source> - <target>22</target> + <id>10</id> + <source>11</source> + <target>18</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -11212,206 +9632,8 @@ <option></option> <columns> <normal_column> - <word_id>122</word_id> - <id>163</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>166</word_id> - <id>164</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>169</word_id> - <id>165</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>168</word_id> - <id>166</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>101</word_id> - <id>167</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>123</word_id> - <id>168</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>varchar(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>242</word_id> - <id>169</id> + <word_id>117</word_id> + <id>137</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11422,7 +9644,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -11443,8 +9665,8 @@ </sequence> </normal_column> <normal_column> - <word_id>0</word_id> - <id>170</id> + <word_id>156</word_id> + <id>138</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11476,8 +9698,8 @@ </sequence> </normal_column> <normal_column> - <word_id>9</word_id> - <id>171</id> + <word_id>158</word_id> + <id>139</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11487,7 +9709,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -11509,8 +9731,8 @@ </sequence> </normal_column> <normal_column> - <word_id>124</word_id> - <id>172</id> + <word_id>157</word_id> + <id>140</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11542,8 +9764,8 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> - <id>173</id> + <word_id>99</word_id> + <id>141</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11575,8 +9797,8 @@ </sequence> </normal_column> <normal_column> - <word_id>60</word_id> - <id>174</id> + <word_id>118</word_id> + <id>142</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11608,8 +9830,8 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> - <id>175</id> + <word_id>218</word_id> + <id>143</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11641,42 +9863,8 @@ </sequence> </normal_column> <normal_column> - <id>176</id> - <referenced_column>114</referenced_column> - <relation>16</relation> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>character(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>121</word_id> - <id>177</id> + <word_id>0</word_id> + <id>144</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11686,7 +9874,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -11708,8 +9896,8 @@ </sequence> </normal_column> <normal_column> - <word_id>120</word_id> - <id>178</id> + <word_id>9</word_id> + <id>145</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11719,7 +9907,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -11741,8 +9929,8 @@ </sequence> </normal_column> <normal_column> - <word_id>139</word_id> - <id>179</id> + <word_id>119</word_id> + <id>146</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -11752,7 +9940,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -11774,13 +9962,13 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> - <id>180</id> + <word_id>52</word_id> + <id>147</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -11807,18 +9995,18 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> - <id>181</id> + <word_id>58</word_id> + <id>148</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -11840,13 +10028,13 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> - <id>182</id> + <word_id>121</word_id> + <id>149</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -11873,17 +10061,18 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> - <id>183</id> + <id>150</id> + <referenced_column>98</referenced_column> + <relation>10</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -11906,13 +10095,13 @@ </sequence> </normal_column> <normal_column> - <word_id>114</word_id> - <id>184</id> + <word_id>116</word_id> + <id>151</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> @@ -11940,12 +10129,12 @@ </normal_column> <normal_column> <word_id>115</word_id> - <id>185</id> + <id>152</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -11972,18 +10161,18 @@ </sequence> </normal_column> <normal_column> - <word_id>30</word_id> - <id>186</id> + <word_id>129</word_id> + <id>153</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12004,65 +10193,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtngnrlmber_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>176</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>23</id> - <height>191</height> - <width>223</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>2292</x> - <y>114</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnloginlog</physical_name> - <logical_name>접속로그</logical_name> - <description>접속로그</description> - <constraint></constraint> - <primary_key_name>comtnloginlog_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>116</word_id> - <id>187</id> + <word_id>185</word_id> + <id>154</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12083,13 +10227,13 @@ </sequence> </normal_column> <normal_column> - <word_id>41</word_id> - <id>188</id> + <word_id>188</word_id> + <id>155</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12116,18 +10260,18 @@ </sequence> </normal_column> <normal_column> - <word_id>42</word_id> - <id>189</id> + <word_id>73</word_id> + <id>156</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12149,13 +10293,13 @@ </sequence> </normal_column> <normal_column> - <word_id>43</word_id> - <id>190</id> + <word_id>111</word_id> + <id>157</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12182,13 +10326,13 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> - <id>191</id> + <word_id>112</word_id> + <id>158</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12215,13 +10359,13 @@ </sequence> </normal_column> <normal_column> - <word_id>71</word_id> - <id>192</id> + <word_id>113</word_id> + <id>159</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12248,8 +10392,8 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> - <id>193</id> + <word_id>29</word_id> + <id>160</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12282,6 +10426,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtngnrlmber_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>150</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -12291,13 +10448,13 @@ </table_properties> </table> <table> - <id>24</id> - <height>212</height> - <width>147</width> + <id>19</id> + <height>191</height> + <width>223</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>180</x> - <y>1584</y> + <x>2292</x> + <y>114</y> <color> <r>128</r> <g>128</g> @@ -12305,21 +10462,21 @@ </color> <connections> </connections> - <physical_name>comtnloginpolicy</physical_name> - <logical_name>로그인정책</logical_name> - <description>로그인정책</description> + <physical_name>comtnloginlog</physical_name> + <logical_name>접속로그</logical_name> + <description>접속로그</description> <constraint></constraint> - <primary_key_name>comtnloginpolicy_pkey</primary_key_name> + <primary_key_name>comtnloginlog_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>57</word_id> - <id>194</id> + <word_id>114</word_id> + <id>161</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12346,8 +10503,8 @@ </sequence> </normal_column> <normal_column> - <word_id>104</word_id> - <id>195</id> + <word_id>40</word_id> + <id>162</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12357,40 +10514,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>false</primary_key> - <unique_key>false</unique_key> - <character_set></character_set> - <collation></collation> - <sequence> - <name></name> - <schema></schema> - <increment></increment> - <min_value></min_value> - <max_value></max_value> - <start></start> - <cache></cache> - <nocache>false</nocache> - <cycle>false</cycle> - <order>false</order> - <description></description> - <data_type></data_type> - <decimal_size>0</decimal_size> - </sequence> - </normal_column> - <normal_column> - <word_id>55</word_id> - <id>196</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>char</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12412,18 +10536,18 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> - <id>197</id> + <word_id>41</word_id> + <id>163</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12445,13 +10569,13 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>198</id> + <word_id>42</word_id> + <id>164</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12478,13 +10602,13 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>199</id> + <word_id>70</word_id> + <id>165</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12511,13 +10635,13 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>200</id> + <word_id>69</word_id> + <id>166</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12544,8 +10668,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>201</id> + <word_id>45</word_id> + <id>167</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12587,13 +10711,13 @@ </table_properties> </table> <table> - <id>25</id> - <height>107</height> - <width>177</width> + <id>20</id> + <height>212</height> + <width>147</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>276</x> - <y>2751</y> + <x>180</x> + <y>1584</y> <color> <r>128</r> <g>128</g> @@ -12601,16 +10725,16 @@ </color> <connections> </connections> - <physical_name>comtnemplyrscrtyestbs</physical_name> - <logical_name>사용자보안설정</logical_name> - <description>사용자보안설정</description> + <physical_name>comtnloginpolicy</physical_name> + <logical_name>로그인정책</logical_name> + <description>로그인정책</description> <constraint></constraint> - <primary_key_name>comtnemplyrscrtyestbs_pkey</primary_key_name> + <primary_key_name>comtnloginpolicy_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>209</word_id> - <id>202</id> + <word_id>55</word_id> + <id>168</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12642,18 +10766,18 @@ </sequence> </normal_column> <normal_column> - <word_id>125</word_id> - <id>203</id> + <word_id>102</word_id> + <id>169</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12675,13 +10799,13 @@ </sequence> </normal_column> <normal_column> - <word_id>14</word_id> - <id>204</id> + <word_id>53</word_id> + <id>170</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -12707,65 +10831,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnemplyrscrtyestbs_i04</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>204</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>26</id> - <height>128</height> - <width>330</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>262</x> - <y>2152</y> - <color> - <r>255</r> - <g>0</g> - <b>0</b> - </color> - <connections> - </connections> - <physical_name>comtnbkmkmenumanageresult</physical_name> - <logical_name>바로가기 메뉴 등록</logical_name> - <description>바로가기 메뉴 등록</description> - <constraint></constraint> - <primary_key_name>comtnbkmkmenumanageresult_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>130</word_id> - <id>205</id> + <word_id>110</word_id> + <id>171</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12786,8 +10865,8 @@ </sequence> </normal_column> <normal_column> - <word_id>57</word_id> - <id>206</id> + <word_id>84</word_id> + <id>172</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12797,8 +10876,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12819,18 +10898,18 @@ </sequence> </normal_column> <normal_column> - <word_id>131</word_id> - <id>207</id> + <word_id>85</word_id> + <id>173</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12852,8 +10931,8 @@ </sequence> </normal_column> <normal_column> - <word_id>178</word_id> - <id>208</id> + <word_id>108</word_id> + <id>174</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12863,7 +10942,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -12884,52 +10963,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>27</id> - <height>128</height> - <width>133</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>657</x> - <y>2152</y> - <color> - <r>255</r> - <g>0</g> - <b>0</b> - </color> - <connections> - </connections> - <physical_name>comtnsitemap</physical_name> - <logical_name>사이트맵</logical_name> - <description>사이트맵</description> - <constraint></constraint> - <primary_key_name>comtnsitemap_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>117</word_id> - <id>209</id> + <word_id>106</word_id> + <id>175</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12949,9 +10996,41 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>21</id> + <height>107</height> + <width>177</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>276</x> + <y>2751</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnemplyrscrtyestbs</physical_name> + <logical_name>사용자보안설정</logical_name> + <description>사용자보안설정</description> + <constraint></constraint> + <primary_key_name>comtnemplyrscrtyestbs_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>44</word_id> - <id>210</id> + <word_id>186</word_id> + <id>176</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -12962,7 +11041,7 @@ <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -12982,19 +11061,19 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - <normal_column> - <word_id>118</word_id> - <id>211</id> + <normal_column> + <word_id>120</word_id> + <id>177</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13016,8 +11095,8 @@ </sequence> </normal_column> <normal_column> - <word_id>119</word_id> - <id>212</id> + <word_id>14</word_id> + <id>178</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13050,6 +11129,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnemplyrscrtyestbs_i04</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>178</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -13059,7 +11151,7 @@ </table_properties> </table> <table> - <id>28</id> + <id>22</id> <height>464</height> <width>204</width> <font_name>맑은 고딕</font_name> @@ -13073,9 +11165,9 @@ </color> <connections> <relation> - <id>17</id> - <source>10</source> - <target>28</target> + <id>11</id> + <source>7</source> + <target>22</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -13103,9 +11195,9 @@ <option></option> <columns> <normal_column> - <id>213</id> - <referenced_column>69</referenced_column> - <relation>17</relation> + <id>179</id> + <referenced_column>53</referenced_column> + <relation>11</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13138,7 +11230,7 @@ </normal_column> <normal_column> <word_id>28</word_id> - <id>214</id> + <id>180</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13170,8 +11262,8 @@ </sequence> </normal_column> <normal_column> - <word_id>159</word_id> - <id>215</id> + <word_id>148</word_id> + <id>181</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13203,8 +11295,8 @@ </sequence> </normal_column> <normal_column> - <word_id>94</word_id> - <id>216</id> + <word_id>92</word_id> + <id>182</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13236,8 +11328,8 @@ </sequence> </normal_column> <normal_column> - <word_id>59</word_id> - <id>217</id> + <word_id>57</word_id> + <id>183</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13269,8 +11361,8 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> - <id>218</id> + <word_id>188</word_id> + <id>184</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13303,7 +11395,7 @@ </normal_column> <normal_column> <word_id>27</word_id> - <id>219</id> + <id>185</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13335,8 +11427,8 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> - <id>220</id> + <word_id>88</word_id> + <id>186</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13368,8 +11460,8 @@ </sequence> </normal_column> <normal_column> - <word_id>96</word_id> - <id>221</id> + <word_id>94</word_id> + <id>187</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13401,8 +11493,8 @@ </sequence> </normal_column> <normal_column> - <word_id>97</word_id> - <id>222</id> + <word_id>95</word_id> + <id>188</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13435,7 +11527,7 @@ </normal_column> <normal_column> <word_id>9</word_id> - <id>223</id> + <id>189</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13467,8 +11559,8 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> - <id>224</id> + <word_id>52</word_id> + <id>190</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13500,8 +11592,8 @@ </sequence> </normal_column> <normal_column> - <word_id>242</word_id> - <id>225</id> + <word_id>218</word_id> + <id>191</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13533,8 +11625,8 @@ </sequence> </normal_column> <normal_column> - <word_id>155</word_id> - <id>226</id> + <word_id>145</word_id> + <id>192</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13566,8 +11658,8 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> - <id>227</id> + <word_id>121</word_id> + <id>193</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13599,8 +11691,8 @@ </sequence> </normal_column> <normal_column> - <word_id>56</word_id> - <id>228</id> + <word_id>54</word_id> + <id>194</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13632,8 +11724,8 @@ </sequence> </normal_column> <normal_column> - <word_id>98</word_id> - <id>229</id> + <word_id>96</word_id> + <id>195</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13665,8 +11757,8 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> - <id>230</id> + <word_id>165</word_id> + <id>196</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13698,8 +11790,8 @@ </sequence> </normal_column> <normal_column> - <word_id>58</word_id> - <id>231</id> + <word_id>56</word_id> + <id>197</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13731,8 +11823,8 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> - <id>232</id> + <word_id>73</word_id> + <id>198</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13773,7 +11865,7 @@ <description></description> <columns> <column> - <id>213</id> + <id>179</id> <desc>false</desc> </column> </columns> @@ -13787,7 +11879,7 @@ </table_properties> </table> <table> - <id>29</id> + <id>23</id> <height>380</height> <width>225</width> <font_name>맑은 고딕</font_name> @@ -13809,8 +11901,8 @@ <option></option> <columns> <normal_column> - <word_id>192</word_id> - <id>233</id> + <word_id>173</word_id> + <id>199</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13842,8 +11934,8 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> - <id>234</id> + <word_id>103</word_id> + <id>200</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13875,8 +11967,8 @@ </sequence> </normal_column> <normal_column> - <word_id>103</word_id> - <id>235</id> + <word_id>101</word_id> + <id>201</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13908,8 +12000,8 @@ </sequence> </normal_column> <normal_column> - <word_id>153</word_id> - <id>236</id> + <word_id>143</word_id> + <id>202</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13941,8 +12033,8 @@ </sequence> </normal_column> <normal_column> - <word_id>206</word_id> - <id>237</id> + <word_id>183</word_id> + <id>203</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13974,8 +12066,8 @@ </sequence> </normal_column> <normal_column> - <word_id>205</word_id> - <id>238</id> + <word_id>181</word_id> + <id>204</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14007,8 +12099,8 @@ </sequence> </normal_column> <normal_column> - <word_id>222</word_id> - <id>239</id> + <word_id>199</word_id> + <id>205</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14040,8 +12132,8 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> - <id>240</id> + <word_id>195</word_id> + <id>206</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14073,8 +12165,8 @@ </sequence> </normal_column> <normal_column> - <word_id>138</word_id> - <id>241</id> + <word_id>128</word_id> + <id>207</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14106,8 +12198,8 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> - <id>242</id> + <word_id>160</word_id> + <id>208</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14139,8 +12231,8 @@ </sequence> </normal_column> <normal_column> - <word_id>170</word_id> - <id>243</id> + <word_id>159</word_id> + <id>209</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14172,8 +12264,8 @@ </sequence> </normal_column> <normal_column> - <word_id>174</word_id> - <id>244</id> + <word_id>161</word_id> + <id>210</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14205,8 +12297,8 @@ </sequence> </normal_column> <normal_column> - <word_id>207</word_id> - <id>245</id> + <word_id>184</word_id> + <id>211</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14238,8 +12330,8 @@ </sequence> </normal_column> <normal_column> - <word_id>73</word_id> - <id>246</id> + <word_id>71</word_id> + <id>212</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14271,8 +12363,8 @@ </sequence> </normal_column> <normal_column> - <word_id>70</word_id> - <id>247</id> + <word_id>67</word_id> + <id>213</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14304,8 +12396,8 @@ </sequence> </normal_column> <normal_column> - <word_id>71</word_id> - <id>248</id> + <word_id>69</word_id> + <id>214</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14347,7 +12439,7 @@ </table_properties> </table> <table> - <id>30</id> + <id>24</id> <height>296</height> <width>140</width> <font_name>맑은 고딕</font_name> @@ -14361,9 +12453,9 @@ </color> <connections> <relation> - <id>18</id> - <source>34</source> - <target>30</target> + <id>12</id> + <source>28</source> + <target>24</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -14391,9 +12483,9 @@ <option></option> <columns> <normal_column> - <id>249</id> - <referenced_column>287</referenced_column> - <relation>18</relation> + <id>215</id> + <referenced_column>253</referenced_column> + <relation>12</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14425,9 +12517,9 @@ </sequence> </normal_column> <normal_column> - <id>250</id> - <referenced_column>288</referenced_column> - <relation>18</relation> + <id>216</id> + <referenced_column>254</referenced_column> + <relation>12</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14460,7 +12552,7 @@ </normal_column> <normal_column> <word_id>4</word_id> - <id>251</id> + <id>217</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14492,8 +12584,8 @@ </sequence> </normal_column> <normal_column> - <word_id>240</word_id> - <id>252</id> + <word_id>216</word_id> + <id>218</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14525,8 +12617,8 @@ </sequence> </normal_column> <normal_column> - <word_id>241</word_id> - <id>253</id> + <word_id>217</word_id> + <id>219</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14559,7 +12651,7 @@ </normal_column> <normal_column> <word_id>1</word_id> - <id>254</id> + <id>220</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14591,8 +12683,8 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>255</id> + <word_id>214</word_id> + <id>221</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14624,8 +12716,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>256</id> + <word_id>85</word_id> + <id>222</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14657,8 +12749,8 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>257</id> + <word_id>84</word_id> + <id>223</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14690,8 +12782,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>258</id> + <word_id>106</word_id> + <id>224</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14723,8 +12815,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>259</id> + <word_id>108</word_id> + <id>225</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14756,8 +12848,8 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> - <id>260</id> + <word_id>156</word_id> + <id>226</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14798,11 +12890,11 @@ <description></description> <columns> <column> - <id>249</id> + <id>215</id> <desc>false</desc> </column> <column> - <id>250</id> + <id>216</id> <desc>false</desc> </column> </columns> @@ -14816,7 +12908,7 @@ </table_properties> </table> <table> - <id>31</id> + <id>25</id> <height>107</height> <width>121</width> <font_name>맑은 고딕</font_name> @@ -14839,7 +12931,7 @@ <columns> <normal_column> <word_id>10</word_id> - <id>261</id> + <id>227</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14871,8 +12963,8 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> - <id>262</id> + <word_id>45</word_id> + <id>228</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14904,8 +12996,8 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>263</id> + <word_id>214</word_id> + <id>229</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -14947,7 +13039,7 @@ </table_properties> </table> <table> - <id>32</id> + <id>26</id> <height>254</height> <width>192</width> <font_name>맑은 고딕</font_name> @@ -14969,8 +13061,8 @@ <option></option> <columns> <normal_column> - <word_id>152</word_id> - <id>264</id> + <word_id>142</word_id> + <id>230</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15002,8 +13094,8 @@ </sequence> </normal_column> <normal_column> - <word_id>204</word_id> - <id>265</id> + <word_id>182</word_id> + <id>231</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15035,8 +13127,8 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> - <id>266</id> + <word_id>194</word_id> + <id>232</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15068,8 +13160,8 @@ </sequence> </normal_column> <normal_column> - <word_id>137</word_id> - <id>267</id> + <word_id>127</word_id> + <id>233</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15101,8 +13193,8 @@ </sequence> </normal_column> <normal_column> - <word_id>46</word_id> - <id>268</id> + <word_id>44</word_id> + <id>234</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15134,8 +13226,8 @@ </sequence> </normal_column> <normal_column> - <word_id>224</word_id> - <id>269</id> + <word_id>201</word_id> + <id>235</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15167,8 +13259,8 @@ </sequence> </normal_column> <normal_column> - <word_id>183</word_id> - <id>270</id> + <word_id>167</word_id> + <id>236</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15200,8 +13292,8 @@ </sequence> </normal_column> <normal_column> - <word_id>53</word_id> - <id>271</id> + <word_id>51</word_id> + <id>237</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15233,8 +13325,8 @@ </sequence> </normal_column> <normal_column> - <word_id>163</word_id> - <id>272</id> + <word_id>153</word_id> + <id>238</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15266,8 +13358,8 @@ </sequence> </normal_column> <normal_column> - <word_id>69</word_id> - <id>273</id> + <word_id>68</word_id> + <id>239</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15309,13 +13401,13 @@ </table_properties> </table> <table> - <id>33</id> + <id>27</id> <height>317</height> - <width>136</width> + <width>201</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1668</x> - <y>1860</y> + <x>2832</x> + <y>1464</y> <color> <r>255</r> <g>128</g> @@ -15331,8 +13423,8 @@ <option></option> <columns> <normal_column> - <word_id>80</word_id> - <id>274</id> + <word_id>78</word_id> + <id>240</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15364,8 +13456,8 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> - <id>275</id> + <word_id>109</word_id> + <id>241</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15397,8 +13489,8 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> - <id>276</id> + <word_id>87</word_id> + <id>242</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15430,8 +13522,8 @@ </sequence> </normal_column> <normal_column> - <word_id>161</word_id> - <id>277</id> + <word_id>150</word_id> + <id>243</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15463,8 +13555,8 @@ </sequence> </normal_column> <normal_column> - <word_id>219</word_id> - <id>278</id> + <word_id>196</word_id> + <id>244</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15496,8 +13588,8 @@ </sequence> </normal_column> <normal_column> - <word_id>227</word_id> - <id>279</id> + <word_id>204</word_id> + <id>245</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15529,8 +13621,8 @@ </sequence> </normal_column> <normal_column> - <word_id>82</word_id> - <id>280</id> + <word_id>80</word_id> + <id>246</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15562,8 +13654,8 @@ </sequence> </normal_column> <normal_column> - <word_id>140</word_id> - <id>281</id> + <word_id>130</word_id> + <id>247</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15595,8 +13687,8 @@ </sequence> </normal_column> <normal_column> - <word_id>79</word_id> - <id>282</id> + <word_id>77</word_id> + <id>248</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15628,8 +13720,8 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> - <id>283</id> + <word_id>168</word_id> + <id>249</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15661,8 +13753,8 @@ </sequence> </normal_column> <normal_column> - <word_id>186</word_id> - <id>284</id> + <word_id>169</word_id> + <id>250</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15694,8 +13786,8 @@ </sequence> </normal_column> <normal_column> - <word_id>226</word_id> - <id>285</id> + <word_id>203</word_id> + <id>251</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15727,8 +13819,8 @@ </sequence> </normal_column> <normal_column> - <word_id>225</word_id> - <id>286</id> + <word_id>202</word_id> + <id>252</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15770,7 +13862,7 @@ </table_properties> </table> <table> - <id>34</id> + <id>28</id> <height>569</height> <width>133</width> <font_name>맑은 고딕</font_name> @@ -15784,9 +13876,9 @@ </color> <connections> <relation> - <id>19</id> - <source>39</source> - <target>34</target> + <id>13</id> + <source>32</source> + <target>28</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -15814,8 +13906,8 @@ <option></option> <columns> <normal_column> - <word_id>148</word_id> - <id>287</id> + <word_id>138</word_id> + <id>253</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15847,11 +13939,11 @@ </sequence> </normal_column> <normal_column> - <id>288</id> - <referenced_column>347</referenced_column> - <referenced_column>347</referenced_column> - <relation>19</relation> - <relation>19</relation> + <id>254</id> + <referenced_column>300</referenced_column> + <referenced_column>300</referenced_column> + <relation>13</relation> + <relation>13</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15883,8 +13975,8 @@ </sequence> </normal_column> <normal_column> - <word_id>149</word_id> - <id>289</id> + <word_id>139</word_id> + <id>255</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15916,8 +14008,8 @@ </sequence> </normal_column> <normal_column> - <word_id>150</word_id> - <id>290</id> + <word_id>140</word_id> + <id>256</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15949,8 +14041,8 @@ </sequence> </normal_column> <normal_column> - <word_id>147</word_id> - <id>291</id> + <word_id>137</word_id> + <id>257</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15983,7 +14075,7 @@ </normal_column> <normal_column> <word_id>2</word_id> - <id>292</id> + <id>258</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16015,8 +14107,8 @@ </sequence> </normal_column> <normal_column> - <word_id>165</word_id> - <id>293</id> + <word_id>154</word_id> + <id>259</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16049,7 +14141,7 @@ </normal_column> <normal_column> <word_id>3</word_id> - <id>294</id> + <id>260</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16081,8 +14173,8 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> - <id>295</id> + <word_id>191</word_id> + <id>261</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16114,8 +14206,8 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> - <id>296</id> + <word_id>166</word_id> + <id>262</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16147,8 +14239,8 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>297</id> + <word_id>214</word_id> + <id>263</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16180,8 +14272,8 @@ </sequence> </normal_column> <normal_column> - <word_id>143</word_id> - <id>298</id> + <word_id>133</word_id> + <id>264</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16213,8 +14305,8 @@ </sequence> </normal_column> <normal_column> - <word_id>144</word_id> - <id>299</id> + <word_id>134</word_id> + <id>265</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16246,8 +14338,8 @@ </sequence> </normal_column> <normal_column> - <word_id>145</word_id> - <id>300</id> + <word_id>135</word_id> + <id>266</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16279,8 +14371,8 @@ </sequence> </normal_column> <normal_column> - <word_id>146</word_id> - <id>301</id> + <word_id>136</word_id> + <id>267</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16312,8 +14404,8 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> - <id>302</id> + <word_id>156</word_id> + <id>268</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16346,7 +14438,7 @@ </normal_column> <normal_column> <word_id>10</word_id> - <id>303</id> + <id>269</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16378,8 +14470,8 @@ </sequence> </normal_column> <normal_column> - <word_id>142</word_id> - <id>304</id> + <word_id>132</word_id> + <id>270</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16411,8 +14503,8 @@ </sequence> </normal_column> <normal_column> - <word_id>212</word_id> - <id>305</id> + <word_id>189</word_id> + <id>271</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16444,8 +14536,8 @@ </sequence> </normal_column> <normal_column> - <word_id>210</word_id> - <id>306</id> + <word_id>187</word_id> + <id>272</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16477,8 +14569,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>307</id> + <word_id>85</word_id> + <id>273</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16510,8 +14602,8 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>308</id> + <word_id>84</word_id> + <id>274</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16543,8 +14635,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>309</id> + <word_id>106</word_id> + <id>275</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16576,8 +14668,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>310</id> + <word_id>108</word_id> + <id>276</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16610,7 +14702,7 @@ </normal_column> <normal_column> <word_id>26</word_id> - <id>311</id> + <id>277</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16651,7 +14743,7 @@ <description></description> <columns> <column> - <id>288</id> + <id>254</id> <desc>false</desc> </column> </columns> @@ -16665,13 +14757,13 @@ </table_properties> </table> <table> - <id>35</id> + <id>29</id> <height>191</height> <width>246</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>2292</x> - <y>2639</y> + <x>1248</x> + <y>2659</y> <color> <r>255</r> <g>128</g> @@ -16679,9 +14771,9 @@ </color> <connections> <relation> - <id>20</id> - <source>36</source> - <target>35</target> + <id>14</id> + <source>30</source> + <target>29</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -16710,7 +14802,7 @@ <columns> <normal_column> <word_id>18</word_id> - <id>312</id> + <id>278</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16743,7 +14835,7 @@ </normal_column> <normal_column> <word_id>13</word_id> - <id>313</id> + <id>279</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16775,8 +14867,8 @@ </sequence> </normal_column> <normal_column> - <word_id>232</word_id> - <id>314</id> + <word_id>208</word_id> + <id>280</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16808,9 +14900,9 @@ </sequence> </normal_column> <normal_column> - <id>315</id> - <referenced_column>319</referenced_column> - <relation>20</relation> + <id>281</id> + <referenced_column>285</referenced_column> + <relation>14</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16842,9 +14934,9 @@ </sequence> </normal_column> <normal_column> - <id>316</id> - <referenced_column>320</referenced_column> - <relation>20</relation> + <id>282</id> + <referenced_column>286</referenced_column> + <relation>14</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16876,8 +14968,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>317</id> + <word_id>86</word_id> + <id>283</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16909,8 +15001,8 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> - <id>318</id> + <word_id>83</word_id> + <id>284</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -16952,13 +15044,13 @@ </table_properties> </table> <table> - <id>36</id> + <id>30</id> <height>212</height> <width>276</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1956</x> - <y>2629</y> + <x>912</x> + <y>2649</y> <color> <r>255</r> <g>128</g> @@ -16966,9 +15058,9 @@ </color> <connections> <relation> - <id>21</id> - <source>38</source> - <target>36</target> + <id>15</id> + <source>34</source> + <target>30</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> <target_xp>-1</target_xp> @@ -16996,15 +15088,15 @@ <option></option> <columns> <normal_column> - <id>319</id> - <referenced_column>334</referenced_column> - <referenced_column>334</referenced_column> - <referenced_column>334</referenced_column> - <referenced_column>334</referenced_column> - <relation>21</relation> - <relation>21</relation> - <relation>21</relation> - <relation>21</relation> + <id>285</id> + <referenced_column>327</referenced_column> + <referenced_column>327</referenced_column> + <referenced_column>327</referenced_column> + <referenced_column>327</referenced_column> + <relation>15</relation> + <relation>15</relation> + <relation>15</relation> + <relation>15</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17036,8 +15128,8 @@ </sequence> </normal_column> <normal_column> - <word_id>180</word_id> - <id>320</id> + <word_id>163</word_id> + <id>286</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17069,8 +15161,8 @@ </sequence> </normal_column> <normal_column> - <word_id>181</word_id> - <id>321</id> + <word_id>164</word_id> + <id>287</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17102,8 +15194,8 @@ </sequence> </normal_column> <normal_column> - <word_id>50</word_id> - <id>322</id> + <word_id>48</word_id> + <id>288</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17135,8 +15227,8 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>323</id> + <word_id>86</word_id> + <id>289</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17168,8 +15260,8 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> - <id>324</id> + <word_id>83</word_id> + <id>290</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17201,8 +15293,8 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> - <id>325</id> + <word_id>105</word_id> + <id>291</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17234,8 +15326,8 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> - <id>326</id> + <word_id>107</word_id> + <id>292</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17277,7 +15369,7 @@ </table_properties> </table> <table> - <id>37</id> + <id>31</id> <height>191</height> <width>129</width> <font_name>맑은 고딕</font_name> @@ -17299,8 +15391,8 @@ <option></option> <columns> <normal_column> - <word_id>196</word_id> - <id>327</id> + <word_id>174</word_id> + <id>293</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17332,8 +15424,8 @@ </sequence> </normal_column> <normal_column> - <word_id>199</word_id> - <id>328</id> + <word_id>177</word_id> + <id>294</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17365,8 +15457,8 @@ </sequence> </normal_column> <normal_column> - <word_id>200</word_id> - <id>329</id> + <word_id>178</word_id> + <id>295</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17398,8 +15490,8 @@ </sequence> </normal_column> <normal_column> - <word_id>198</word_id> - <id>330</id> + <word_id>176</word_id> + <id>296</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17431,8 +15523,8 @@ </sequence> </normal_column> <normal_column> - <word_id>202</word_id> - <id>331</id> + <word_id>180</word_id> + <id>297</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17464,8 +15556,8 @@ </sequence> </normal_column> <normal_column> - <word_id>201</word_id> - <id>332</id> + <word_id>179</word_id> + <id>298</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17496,9 +15588,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - <normal_column> - <word_id>197</word_id> - <id>333</id> + <normal_column> + <word_id>175</word_id> + <id>299</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17540,62 +15632,35 @@ </table_properties> </table> <table> - <id>38</id> - <height>317</height> - <width>389</width> + <id>32</id> + <height>-1</height> + <width>-1</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1920</x> - <y>2176</y> + <x>1980</x> + <y>1040</y> <color> - <r>255</r> + <r>128</r> <g>128</g> - <b>255</b> + <b>192</b> </color> <connections> - <relation> - <id>22</id> - <source>38</source> - <target>38</target> - <source_xp>100</source_xp> - <source_yp>84</source_yp> - <target_xp>73</target_xp> - <target_yp>100</target_yp> - <bendpoint> - <relative>true</relative> - <x>55</x> - <y>33</y> - </bendpoint> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name></name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> </connections> - <physical_name>tnmenuinfo</physical_name> - <logical_name>메뉴정보</logical_name> - <description>메뉴정보</description> + <physical_name>comtnbbsmaster</physical_name> + <logical_name>게시판마스터</logical_name> + <description>게시판마스터</description> <constraint></constraint> - <primary_key_name>PK_tnmenuinfo</primary_key_name> + <primary_key_name>comtnbbsmaster_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>134</word_id> - <id>334</id> + <word_id>20</word_id> + <id>300</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17622,19 +15687,18 @@ </sequence> </normal_column> <normal_column> - <id>335</id> - <referenced_column>334</referenced_column> - <relation>22</relation> + <word_id>22</word_id> + <id>301</id> <description></description> <unique_key_name></unique_key_name> - <logical_name>상위메뉴번호</logical_name> - <physical_name>upper_menu_no</physical_name> + <logical_name></logical_name> + <physical_name></physical_name> <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> + <foreign_key>false</foreign_key> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17656,8 +15720,8 @@ </sequence> </normal_column> <normal_column> - <word_id>132</word_id> - <id>336</id> + <word_id>21</word_id> + <id>302</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -17689,18 +15753,18 @@ </sequence> </normal_column> <normal_column> - <word_id>135</word_id> - <id>337</id> + <word_id>23</word_id> + <id>303</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>integer</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17722,13 +15786,13 @@ </sequence> </normal_column> <normal_column> - <word_id>127</word_id> - <id>338</id> + <word_id>172</word_id> + <id>304</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17755,18 +15819,18 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> - <id>339</id> + <word_id>74</word_id> + <id>305</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17788,18 +15852,18 @@ </sequence> </normal_column> <normal_column> - <word_id>179</word_id> - <id>340</id> + <word_id>11</word_id> + <id>306</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17821,13 +15885,13 @@ </sequence> </normal_column> <normal_column> - <word_id>129</word_id> - <id>341</id> + <word_id>12</word_id> + <id>307</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17854,18 +15918,18 @@ </sequence> </normal_column> <normal_column> - <word_id>239</word_id> - <id>342</id> + <word_id>214</word_id> + <id>308</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17887,18 +15951,18 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> - <id>343</id> + <word_id>84</word_id> + <id>309</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17921,17 +15985,17 @@ </normal_column> <normal_column> <word_id>85</word_id> - <id>344</id> + <id>310</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17953,13 +16017,13 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> - <id>345</id> + <word_id>108</word_id> + <id>311</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17986,13 +16050,13 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> - <id>346</id> + <word_id>106</word_id> + <id>312</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18018,41 +16082,9 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>39</id> - <height>-1</height> - <width>-1</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1980</x> - <y>1040</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - </connections> - <physical_name>comtnbbsmaster</physical_name> - <logical_name>게시판마스터</logical_name> - <description>게시판마스터</description> - <constraint></constraint> - <primary_key_name>comtnbbsmaster_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>20</word_id> - <id>347</id> + <word_id>26</word_id> + <id>313</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18062,8 +16094,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18084,18 +16116,18 @@ </sequence> </normal_column> <normal_column> - <word_id>22</word_id> - <id>348</id> + <word_id>25</word_id> + <id>314</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18117,13 +16149,13 @@ </sequence> </normal_column> <normal_column> - <word_id>21</word_id> - <id>349</id> + <word_id>190</word_id> + <id>315</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18150,18 +16182,18 @@ </sequence> </normal_column> <normal_column> - <word_id>23</word_id> - <id>350</id> + <word_id>5</word_id> + <id>316</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18183,13 +16215,13 @@ </sequence> </normal_column> <normal_column> - <word_id>191</word_id> - <id>351</id> + <word_id>19</word_id> + <id>317</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18216,18 +16248,18 @@ </sequence> </normal_column> <normal_column> - <word_id>76</word_id> - <id>352</id> + <word_id>49</word_id> + <id>318</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18248,20 +16280,75 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - <normal_column> - <word_id>11</word_id> - <id>353</id> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>33</id> + <height>212</height> + <width>133</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1991</x> + <y>1546</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>16</id> + <source>32</source> + <target>33</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnbbsuse_bbs_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtnbbsuse</physical_name> + <logical_name>게시판활용</logical_name> + <description>게시판활용</description> + <constraint></constraint> + <primary_key_name>comtnbbsuse_pkey</primary_key_name> + <option></option> + <columns> + <normal_column> + <id>319</id> + <referenced_column>300</referenced_column> + <relation>16</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>true</not_null> - <primary_key>false</primary_key> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18282,19 +16369,19 @@ </sequence> </normal_column> <normal_column> - <word_id>12</word_id> - <id>354</id> + <word_id>198</word_id> + <id>320</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>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> @@ -18315,8 +16402,8 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>355</id> + <word_id>214</word_id> + <id>321</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18348,18 +16435,18 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>356</id> + <word_id>170</word_id> + <id>322</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18381,8 +16468,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>357</id> + <word_id>85</word_id> + <id>323</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18392,7 +16479,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18414,8 +16501,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>358</id> + <word_id>84</word_id> + <id>324</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18425,7 +16512,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18447,8 +16534,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>359</id> + <word_id>106</word_id> + <id>325</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18480,13 +16567,13 @@ </sequence> </normal_column> <normal_column> - <word_id>26</word_id> - <id>360</id> + <word_id>108</word_id> + <id>326</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18512,20 +16599,92 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnbbsuse_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>319</id> + <desc>false</desc> + </column> + </columns> + </inidex> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>34</id> + <height>317</height> + <width>389</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>876</x> + <y>2196</y> + <color> + <r>255</r> + <g>128</g> + <b>255</b> + </color> + <connections> + <relation> + <id>17</id> + <source>34</source> + <target>34</target> + <source_xp>100</source_xp> + <source_yp>84</source_yp> + <target_xp>73</target_xp> + <target_yp>100</target_yp> + <bendpoint> + <relative>true</relative> + <x>55</x> + <y>33</y> + </bendpoint> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>0..1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name></name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>tnmenuinfo</physical_name> + <logical_name>메뉴정보</logical_name> + <description>메뉴정보</description> + <constraint></constraint> + <primary_key_name>PK_tnmenuinfo</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>25</word_id> - <id>361</id> + <word_id>125</word_id> + <id>327</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <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> @@ -18546,17 +16705,18 @@ </sequence> </normal_column> <normal_column> - <word_id>213</word_id> - <id>362</id> + <id>328</id> + <referenced_column>327</referenced_column> + <relation>17</relation> <description></description> <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>text</type> + <logical_name>상위메뉴번호</logical_name> + <physical_name>upper_menu_no</physical_name> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -18579,13 +16739,13 @@ </sequence> </normal_column> <normal_column> - <word_id>5</word_id> - <id>363</id> + <word_id>124</word_id> + <id>329</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18612,13 +16772,13 @@ </sequence> </normal_column> <normal_column> - <word_id>19</word_id> - <id>364</id> + <word_id>126</word_id> + <id>330</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>integer</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18645,13 +16805,13 @@ </sequence> </normal_column> <normal_column> - <word_id>51</word_id> - <id>365</id> + <word_id>122</word_id> + <id>331</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18677,75 +16837,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>40</id> - <height>212</height> - <width>133</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1991</x> - <y>1546</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>23</id> - <source>39</source> - <target>40</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnbbsuse_bbs_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnbbsuse</physical_name> - <logical_name>게시판활용</logical_name> - <description>게시판활용</description> - <constraint></constraint> - <primary_key_name>comtnbbsuse_pkey</primary_key_name> - <option></option> - <columns> <normal_column> - <id>366</id> - <referenced_column>347</referenced_column> - <relation>23</relation> + <word_id>171</word_id> + <id>332</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -18766,19 +16871,19 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> - <id>367</id> + <word_id>162</word_id> + <id>333</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <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> @@ -18799,18 +16904,18 @@ </sequence> </normal_column> <normal_column> - <word_id>238</word_id> - <id>368</id> + <word_id>123</word_id> + <id>334</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18832,13 +16937,13 @@ </sequence> </normal_column> <normal_column> - <word_id>187</word_id> - <id>369</id> + <word_id>215</word_id> + <id>335</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -18865,8 +16970,8 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> - <id>370</id> + <word_id>86</word_id> + <id>336</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18898,8 +17003,8 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> - <id>371</id> + <word_id>83</word_id> + <id>337</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18909,7 +17014,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -18931,8 +17036,8 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> - <id>372</id> + <word_id>105</word_id> + <id>338</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18964,8 +17069,8 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> - <id>373</id> + <word_id>107</word_id> + <id>339</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -18998,19 +17103,6 @@ </normal_column> </columns> <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnbbsuse_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>366</id> - <desc>false</desc> - </column> - </columns> - </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list>