Commit @77 - jhleem/egov

Files
Commit

임종호 2022-02-16 @77

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 76) +++ base3.10/src/main/webapp/resource/editor/js/froala_editor_script_custom.js (revision 77) @@ -90,35 +90,8 @@ }) // uploaded -> inserted -> loaded .on('froalaEditor.image.uploaded', function (e, ed, html) { - // Do something here. //console.log("uploaded", e, ed, html); - if( editor.options.inputFileId != '' ) { - var link = JSON.parse(html); - - var dom = ''; - if(options.authorType != 'user'){ - dom = defaultsDom(link); - }else{ - dom = defaultsDomUser(link); - } - - $('#'+editor.options.fileListDivId).append(dom); - // 업로드시 div 표시 - $('#' + editor.options.fileListDivId).removeAttr('style'); - - // 이벤트 추가 - fncFileTrigger(link); - - var atch_id = $('input[name="'+editor.options.hiddenFileName+'"]').val(); - - if (atch_id.length == 0) { - atch_id = link.fileId; - } else { - atch_id = atch_id + "," + link.fileId; - } - - $('input[name="'+editor.options.hiddenFileName+'"]').val(atch_id); - } + syncFile(editor, html); }) .on('froalaEditor.image.loaded', function (e, editor, $img) { // Do something here. @@ -154,34 +127,7 @@ }) .on('froalaEditor.file.uploaded', function (e, ed, html) { // console.log(e, ed, html); - if( editor.options.inputFileId != '' ) { - var link = JSON.parse(html); - - var dom = ''; - if(options.authorType != 'user'){ - dom = defaultsDom(link); - }else{ - dom = defaultsDomUser(link); - } - - $('#'+editor.options.fileListDivId).append(dom); - // 업로드시 div 표시 - $('#' + editor.options.fileListDivId).removeAttr('style'); - - // 이벤트 추가 - fncFileTrigger(link); - - var atch_id = $('input[name="'+editor.options.hiddenFileName+'"]').val(); - - if (atch_id.length == 0) { - atch_id = link.fileId; - } else { - atch_id = atch_id + "," + link.fileId; - } - - $('input[name="'+editor.options.hiddenFileName+'"]').val(atch_id); - } - + syncFile(editor, html); }) .on('froalaEditor.file.error', function(e, ed, error) { // 파일 업로드 시 에러 메시지 @@ -405,6 +351,36 @@ //console.log ('file delete problem: ' + JSON.stringify(err)); }) } + + // 에디터와 첨부파일 싱크 + function syncFile(editor, html) { + if( editor.options.inputFileId != '' ) { + var link = JSON.parse(html); + var dom = ''; + if(editor.options.authorType != 'user'){ + dom = defaultsDom(link); + }else{ + dom = defaultsDomUser(link); + } + + $('#'+editor.options.fileListDivId).append(dom); + // 업로드시 div 표시 + $('#' + editor.options.fileListDivId).removeAttr('style'); + + // 이벤트 추가 + fncFileTrigger(link); + + var atch_id = $('input[name="'+editor.options.hiddenFileName+'"]').val(); + + if (atch_id.length == 0) { + atch_id = link.fileId; + } else { + atch_id = atch_id + "," + link.fileId; + } + + $('input[name="'+editor.options.hiddenFileName+'"]').val(atch_id); + } + } }; // 파일 목록 생성(관리자 게시판) var defaultsDom = function(html) { @@ -413,9 +389,13 @@ var dom = '<li class="' + fileIcon + '" id ="' + html.fileId + '">' + '<div class="file_wrap">' + "<p class='filename'>" + html.originFileNm + "<em class='fileSize'>[" + fileSize + "]</em></p>" - + "<button type='button' class='btn_ss bg_basic' title='파일 본문에 넣기'>본문에 넣기</button>" - + "<button type='button' class='btn_delete btn_sq_s ml2' title='파일 삭제'>삭제</button>" - + "</div>"; + + "<button type='button' class='btn_ss bg_basic' title='파일 본문에 넣기'>본문에 넣기</button>"; + // 이미지 여부 확인 +// if (fileSizeConvert(html.originFileNm)) { +// dom += "<a href=" + html.link.replace('/download.do', '/imageview.do') + " target='_blank' class='btn_ss bg_basic' title='이미지 미리보기'>미리보기</a>"; +// } + dom += "<button type='button' class='btn_delete btn_sq_s ml2' title='파일 삭제'>삭제</button>" + + "</div>" + "</li>"; return dom; } Index: base3.10/script/postgres.erm =================================================================== --- base3.10/script/postgres.erm (revision 76) +++ base3.10/script/postgres.erm (revision 77) @@ -12,11 +12,11 @@ <category_index>0</category_index> <zoom>1.0</zoom> <x>0</x> - <y>813</y> + <y>162</y> <default_color> <r>255</r> - <g>0</g> - <b>0</b> + <g>128</g> + <b>255</b> </default_color> <color> <r>255</r> @@ -112,13 +112,13 @@ <show_referred_tables>false</show_referred_tables> <categories> <category> - <id>35</id> - <height>167</height> - <width>601</width> + <id>36</id> + <height>277</height> + <width>841</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>12</x> - <y>432</y> + <x>8</x> + <y>433</y> <color> <r>255</r> <g>128</g> @@ -130,9 +130,10 @@ <selected>true</selected> <node_element>12</node_element> <node_element>16</node_element> + <node_element>35</node_element> </category> <category> - <id>36</id> + <id>37</id> <height>400</height> <width>941</width> <font_name>맑은 고딕</font_name> @@ -153,7 +154,7 @@ <node_element>14</node_element> </category> <category> - <id>37</id> + <id>38</id> <height>864</height> <width>1632</width> <font_name>맑은 고딕</font_name> @@ -179,7 +180,7 @@ <node_element>29</node_element> </category> <category> - <id>38</id> + <id>39</id> <height>1185</height> <width>1592</width> <font_name>맑은 고딕</font_name> @@ -205,7 +206,7 @@ <node_element>20</node_element> </category> <category> - <id>39</id> + <id>40</id> <height>440</height> <width>1404</width> <font_name>맑은 고딕</font_name> @@ -229,7 +230,7 @@ <node_element>26</node_element> </category> <category> - <id>40</id> + <id>41</id> <height>1041</height> <width>1296</width> <font_name>맑은 고딕</font_name> @@ -278,7 +279,7 @@ </connections> <display>false</display> <creation_date>2022-01-26 16:20:32</creation_date> - <updated_date>2022-02-16 17:35:01</updated_date> + <updated_date>2022-02-16 18:02:06</updated_date> <model_property> <name>프로젝트명</name> <value></value> @@ -1002,6 +1003,102 @@ </word> <word> <id>43</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>copyright</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>44</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>co_addr</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>45</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>favicon</description> + <logical_name>favicon</logical_name> + <physical_name>co_favicon</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>46</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>팩스</description> + <logical_name>팩스</logical_name> + <physical_name>co_fax</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>47</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>co_logo</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>48</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>전화번호</description> + <logical_name>전화번호</logical_name> + <physical_name>co_tel</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>49</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1017,7 +1114,7 @@ <type>numeric(p)</type> </word> <word> - <id>44</id> + <id>50</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1033,7 +1130,7 @@ <type>numeric(p)</type> </word> <word> - <id>45</id> + <id>51</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1049,7 +1146,7 @@ <type>timestamp</type> </word> <word> - <id>46</id> + <id>52</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1065,7 +1162,7 @@ <type>varchar(n)</type> </word> <word> - <id>47</id> + <id>53</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -1081,7 +1178,7 @@ <type>varchar(n)</type> </word> <word> - <id>48</id> + <id>54</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -1097,7 +1194,7 @@ <type>varchar(n)</type> </word> <word> - <id>49</id> + <id>55</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -1113,7 +1210,7 @@ <type>character(n)</type> </word> <word> - <id>50</id> + <id>56</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1129,7 +1226,7 @@ <type>numeric(p)</type> </word> <word> - <id>51</id> + <id>57</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1145,7 +1242,7 @@ <type>numeric(p)</type> </word> <word> - <id>52</id> + <id>58</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1161,7 +1258,7 @@ <type>varchar(n)</type> </word> <word> - <id>53</id> + <id>59</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1177,7 +1274,7 @@ <type>char</type> </word> <word> - <id>54</id> + <id>60</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -1193,7 +1290,7 @@ <type>varchar(n)</type> </word> <word> - <id>55</id> + <id>61</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1209,7 +1306,7 @@ <type>varchar(n)</type> </word> <word> - <id>56</id> + <id>62</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1225,7 +1322,7 @@ <type>char</type> </word> <word> - <id>57</id> + <id>63</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1241,7 +1338,7 @@ <type>varchar(n)</type> </word> <word> - <id>58</id> + <id>64</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1257,7 +1354,7 @@ <type>varchar(n)</type> </word> <word> - <id>59</id> + <id>65</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1273,7 +1370,7 @@ <type>varchar(n)</type> </word> <word> - <id>60</id> + <id>66</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1289,7 +1386,7 @@ <type>varchar(n)</type> </word> <word> - <id>61</id> + <id>67</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -1305,7 +1402,7 @@ <type>varchar(n)</type> </word> <word> - <id>62</id> + <id>68</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1321,7 +1418,7 @@ <type>varchar(n)</type> </word> <word> - <id>63</id> + <id>69</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1337,7 +1434,7 @@ <type>varchar(n)</type> </word> <word> - <id>64</id> + <id>70</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -1353,7 +1450,7 @@ <type>varchar(n)</type> </word> <word> - <id>65</id> + <id>71</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1369,7 +1466,7 @@ <type>varchar(n)</type> </word> <word> - <id>66</id> + <id>72</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -1385,7 +1482,7 @@ <type>character(n)</type> </word> <word> - <id>67</id> + <id>73</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1401,7 +1498,7 @@ <type>numeric(p)</type> </word> <word> - <id>68</id> + <id>74</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1417,7 +1514,7 @@ <type>numeric(p)</type> </word> <word> - <id>69</id> + <id>75</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -1433,7 +1530,7 @@ <type>character(n)</type> </word> <word> - <id>70</id> + <id>76</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1449,7 +1546,7 @@ <type>char</type> </word> <word> - <id>71</id> + <id>77</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1465,7 +1562,7 @@ <type>char</type> </word> <word> - <id>72</id> + <id>78</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1481,7 +1578,7 @@ <type>character(n)</type> </word> <word> - <id>73</id> + <id>79</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1497,7 +1594,7 @@ <type>character(n)</type> </word> <word> - <id>74</id> + <id>80</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1513,7 +1610,7 @@ <type>char</type> </word> <word> - <id>75</id> + <id>81</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1529,7 +1626,7 @@ <type>text</type> </word> <word> - <id>76</id> + <id>82</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1545,7 +1642,7 @@ <type>varchar(n)</type> </word> <word> - <id>77</id> + <id>83</id> <length>32</length> <decimal>null</decimal> <array>false</array> @@ -1561,7 +1658,7 @@ <type>varchar(n)</type> </word> <word> - <id>78</id> + <id>84</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1577,7 +1674,7 @@ <type>varchar(n)</type> </word> <word> - <id>79</id> + <id>85</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -1593,7 +1690,7 @@ <type>numeric(p)</type> </word> <word> - <id>80</id> + <id>86</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -1609,7 +1706,7 @@ <type>numeric(p)</type> </word> <word> - <id>81</id> + <id>87</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -1625,7 +1722,7 @@ <type>numeric(p)</type> </word> <word> - <id>82</id> + <id>88</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -1641,7 +1738,7 @@ <type>varchar(n)</type> </word> <word> - <id>83</id> + <id>89</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1657,7 +1754,7 @@ <type>varchar(n)</type> </word> <word> - <id>84</id> + <id>90</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1673,7 +1770,7 @@ <type>varchar(n)</type> </word> <word> - <id>85</id> + <id>91</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1689,7 +1786,7 @@ <type>timestamp</type> </word> <word> - <id>86</id> + <id>92</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1705,7 +1802,7 @@ <type>timestamp</type> </word> <word> - <id>87</id> + <id>93</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1721,7 +1818,7 @@ <type>text</type> </word> <word> - <id>88</id> + <id>94</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1737,7 +1834,7 @@ <type>varchar(n)</type> </word> <word> - <id>89</id> + <id>95</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1753,7 +1850,7 @@ <type>timestamp</type> </word> <word> - <id>90</id> + <id>96</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1769,7 +1866,7 @@ <type>varchar(n)</type> </word> <word> - <id>91</id> + <id>97</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1785,7 +1882,7 @@ <type></type> </word> <word> - <id>92</id> + <id>98</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1801,7 +1898,7 @@ <type>character(n)</type> </word> <word> - <id>93</id> + <id>99</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -1817,7 +1914,7 @@ <type>varchar(n)</type> </word> <word> - <id>94</id> + <id>100</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -1833,7 +1930,7 @@ <type>varchar(n)</type> </word> <word> - <id>95</id> + <id>101</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1849,7 +1946,7 @@ <type>varchar(n)</type> </word> <word> - <id>96</id> + <id>102</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -1865,7 +1962,7 @@ <type>varchar(n)</type> </word> <word> - <id>97</id> + <id>103</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -1881,7 +1978,7 @@ <type>numeric(p)</type> </word> <word> - <id>98</id> + <id>104</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -1897,7 +1994,7 @@ <type>varchar(n)</type> </word> <word> - <id>99</id> + <id>105</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -1913,7 +2010,7 @@ <type>varchar(n)</type> </word> <word> - <id>100</id> + <id>106</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -1929,7 +2026,23 @@ <type>char</type> </word> <word> - <id>101</id> + <id>107</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>inspect_at</physical_name> + <type>char</type> + </word> + <word> + <id>108</id> <length>7</length> <decimal>null</decimal> <array>false</array> @@ -1945,7 +2058,7 @@ <type>character(n)</type> </word> <word> - <id>102</id> + <id>109</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -1961,7 +2074,7 @@ <type>varchar(n)</type> </word> <word> - <id>103</id> + <id>110</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -1977,7 +2090,7 @@ <type>character(n)</type> </word> <word> - <id>104</id> + <id>111</id> <length>13</length> <decimal>null</decimal> <array>false</array> @@ -1993,7 +2106,7 @@ <type>varchar(n)</type> </word> <word> - <id>105</id> + <id>112</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2009,7 +2122,7 @@ <type>timestamp</type> </word> <word> - <id>106</id> + <id>113</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2025,7 +2138,7 @@ <type>timestamp</type> </word> <word> - <id>107</id> + <id>114</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2041,7 +2154,7 @@ <type>varchar(n)</type> </word> <word> - <id>108</id> + <id>115</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2057,7 +2170,7 @@ <type>varchar(n)</type> </word> <word> - <id>109</id> + <id>116</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2073,7 +2186,7 @@ <type>text</type> </word> <word> - <id>110</id> + <id>117</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2089,7 +2202,7 @@ <type>char</type> </word> <word> - <id>111</id> + <id>118</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2105,7 +2218,7 @@ <type>char</type> </word> <word> - <id>112</id> + <id>119</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2121,7 +2234,7 @@ <type>numeric(p)</type> </word> <word> - <id>113</id> + <id>120</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2137,7 +2250,7 @@ <type>timestamp</type> </word> <word> - <id>114</id> + <id>121</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2153,7 +2266,7 @@ <type>character(n)</type> </word> <word> - <id>115</id> + <id>122</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2169,7 +2282,7 @@ <type>varchar(n)</type> </word> <word> - <id>116</id> + <id>123</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2185,7 +2298,7 @@ <type>varchar(n)</type> </word> <word> - <id>117</id> + <id>124</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2201,7 +2314,7 @@ <type>varchar(n)</type> </word> <word> - <id>118</id> + <id>125</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -2217,7 +2330,7 @@ <type>varchar(n)</type> </word> <word> - <id>119</id> + <id>126</id> <length>15</length> <decimal>null</decimal> <array>false</array> @@ -2233,7 +2346,7 @@ <type>varchar(n)</type> </word> <word> - <id>120</id> + <id>127</id> <length>5</length> <decimal>null</decimal> <array>false</array> @@ -2249,7 +2362,7 @@ <type>character(n)</type> </word> <word> - <id>121</id> + <id>128</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2265,7 +2378,7 @@ <type>varchar(n)</type> </word> <word> - <id>122</id> + <id>129</id> <length>250</length> <decimal>null</decimal> <array>false</array> @@ -2281,7 +2394,7 @@ <type>varchar(n)</type> </word> <word> - <id>123</id> + <id>130</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -2297,7 +2410,7 @@ <type>varchar(n)</type> </word> <word> - <id>124</id> + <id>131</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2313,7 +2426,7 @@ <type>varchar(n)</type> </word> <word> - <id>125</id> + <id>132</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2329,7 +2442,7 @@ <type>varchar(n)</type> </word> <word> - <id>126</id> + <id>133</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2345,7 +2458,7 @@ <type>integer</type> </word> <word> - <id>127</id> + <id>134</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2361,7 +2474,7 @@ <type>varchar(n)</type> </word> <word> - <id>128</id> + <id>135</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2377,7 +2490,7 @@ <type>varchar(n)</type> </word> <word> - <id>129</id> + <id>136</id> <length>4</length> <decimal>null</decimal> <array>false</array> @@ -2393,7 +2506,7 @@ <type>varchar(n)</type> </word> <word> - <id>130</id> + <id>137</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2409,7 +2522,7 @@ <type>text</type> </word> <word> - <id>131</id> + <id>138</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -2425,7 +2538,7 @@ <type>numeric(p)</type> </word> <word> - <id>132</id> + <id>139</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2441,7 +2554,7 @@ <type>char</type> </word> <word> - <id>133</id> + <id>140</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2457,7 +2570,7 @@ <type>character(n)</type> </word> <word> - <id>134</id> + <id>141</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2473,7 +2586,7 @@ <type>character(n)</type> </word> <word> - <id>135</id> + <id>142</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2489,7 +2602,7 @@ <type>varchar(n)</type> </word> <word> - <id>136</id> + <id>143</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2505,7 +2618,7 @@ <type>varchar(n)</type> </word> <word> - <id>137</id> + <id>144</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2521,7 +2634,7 @@ <type>text</type> </word> <word> - <id>138</id> + <id>145</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2537,7 +2650,7 @@ <type>numeric(p)</type> </word> <word> - <id>139</id> + <id>146</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2553,7 +2666,7 @@ <type>numeric(p)</type> </word> <word> - <id>140</id> + <id>147</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -2569,7 +2682,7 @@ <type>varchar(n)</type> </word> <word> - <id>141</id> + <id>148</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2585,7 +2698,7 @@ <type>character(n)</type> </word> <word> - <id>142</id> + <id>149</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2601,7 +2714,7 @@ <type>character(n)</type> </word> <word> - <id>143</id> + <id>150</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2617,7 +2730,7 @@ <type>timestamp</type> </word> <word> - <id>144</id> + <id>151</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2633,7 +2746,7 @@ <type>varchar(n)</type> </word> <word> - <id>145</id> + <id>152</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2649,7 +2762,7 @@ <type>varchar(n)</type> </word> <word> - <id>146</id> + <id>153</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2665,7 +2778,7 @@ <type>varchar(n)</type> </word> <word> - <id>147</id> + <id>154</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2681,7 +2794,7 @@ <type></type> </word> <word> - <id>148</id> + <id>155</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2697,7 +2810,7 @@ <type>character(n)</type> </word> <word> - <id>149</id> + <id>156</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2713,7 +2826,7 @@ <type>varchar(n)</type> </word> <word> - <id>150</id> + <id>157</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2729,7 +2842,7 @@ <type>text</type> </word> <word> - <id>151</id> + <id>158</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -2745,7 +2858,7 @@ <type>varchar(n)</type> </word> <word> - <id>152</id> + <id>159</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2761,7 +2874,7 @@ <type>numeric(p)</type> </word> <word> - <id>153</id> + <id>160</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2777,7 +2890,7 @@ <type>numeric(p)</type> </word> <word> - <id>154</id> + <id>161</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2793,7 +2906,7 @@ <type>numeric(p)</type> </word> <word> - <id>155</id> + <id>162</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -2809,7 +2922,7 @@ <type>varchar(n)</type> </word> <word> - <id>156</id> + <id>163</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -2825,7 +2938,7 @@ <type>varchar(n)</type> </word> <word> - <id>157</id> + <id>164</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2841,7 +2954,7 @@ <type>varchar(n)</type> </word> <word> - <id>158</id> + <id>165</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2857,7 +2970,7 @@ <type>varchar(n)</type> </word> <word> - <id>159</id> + <id>166</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2873,7 +2986,7 @@ <type>numeric(p)</type> </word> <word> - <id>160</id> + <id>167</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2889,7 +3002,7 @@ <type>character(n)</type> </word> <word> - <id>161</id> + <id>168</id> <length>14</length> <decimal>null</decimal> <array>false</array> @@ -2905,7 +3018,7 @@ <type>varchar(n)</type> </word> <word> - <id>162</id> + <id>169</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -2921,7 +3034,7 @@ <type>varchar(n)</type> </word> <word> - <id>163</id> + <id>170</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2937,7 +3050,7 @@ <type>varchar(n)</type> </word> <word> - <id>164</id> + <id>171</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2953,7 +3066,7 @@ <type>varchar(n)</type> </word> <word> - <id>165</id> + <id>172</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2969,7 +3082,7 @@ <type>character(n)</type> </word> <word> - <id>166</id> + <id>173</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2985,7 +3098,7 @@ <type>numeric(p)</type> </word> <word> - <id>167</id> + <id>174</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3001,7 +3114,7 @@ <type>numeric(p)</type> </word> <word> - <id>168</id> + <id>175</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3017,7 +3130,7 @@ <type>varchar(n)</type> </word> <word> - <id>169</id> + <id>176</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3033,7 +3146,7 @@ <type>timestamp</type> </word> <word> - <id>170</id> + <id>177</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3049,7 +3162,7 @@ <type>character(n)</type> </word> <word> - <id>171</id> + <id>178</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3065,7 +3178,7 @@ <type>varchar(n)</type> </word> <word> - <id>172</id> + <id>179</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3081,7 +3194,7 @@ <type>char</type> </word> <word> - <id>173</id> + <id>180</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3097,7 +3210,7 @@ <type>varchar(n)</type> </word> <word> - <id>174</id> + <id>181</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3113,7 +3226,7 @@ <type>varchar(n)</type> </word> <word> - <id>175</id> + <id>182</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3129,7 +3242,7 @@ <type>timestamp</type> </word> <word> - <id>176</id> + <id>183</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3145,7 +3258,7 @@ <type>varchar(n)</type> </word> <word> - <id>177</id> + <id>184</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3161,7 +3274,7 @@ <type>varchar(n)</type> </word> <word> - <id>178</id> + <id>185</id> <length>300</length> <decimal>null</decimal> <array>false</array> @@ -3177,7 +3290,7 @@ <type>varchar(n)</type> </word> <word> - <id>179</id> + <id>186</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3193,7 +3306,7 @@ <type>varchar(n)</type> </word> <word> - <id>180</id> + <id>187</id> <length>80</length> <decimal>null</decimal> <array>false</array> @@ -3209,7 +3322,7 @@ <type>varchar(n)</type> </word> <word> - <id>181</id> + <id>188</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3225,7 +3338,7 @@ <type>varchar(n)</type> </word> <word> - <id>182</id> + <id>189</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3241,7 +3354,7 @@ <type>varchar(n)</type> </word> <word> - <id>183</id> + <id>190</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -3257,7 +3370,7 @@ <type>varchar(n)</type> </word> <word> - <id>184</id> + <id>191</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -3273,7 +3386,7 @@ <type>character(n)</type> </word> <word> - <id>185</id> + <id>192</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3289,7 +3402,7 @@ <type>timestamp</type> </word> <word> - <id>186</id> + <id>193</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3305,7 +3418,7 @@ <type>varchar(n)</type> </word> <word> - <id>187</id> + <id>194</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3321,7 +3434,7 @@ <type>char</type> </word> <word> - <id>188</id> + <id>195</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3337,7 +3450,7 @@ <type>char</type> </word> <word> - <id>189</id> + <id>196</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3353,7 +3466,7 @@ <type>char</type> </word> <word> - <id>190</id> + <id>197</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3369,7 +3482,7 @@ <type>text</type> </word> <word> - <id>191</id> + <id>198</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3385,7 +3498,7 @@ <type>numeric(p)</type> </word> <word> - <id>192</id> + <id>199</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3401,7 +3514,7 @@ <type>varchar(n)</type> </word> <word> - <id>193</id> + <id>200</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3417,7 +3530,7 @@ <type>char</type> </word> <word> - <id>194</id> + <id>201</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3433,7 +3546,7 @@ <type>varchar(n)</type> </word> <word> - <id>195</id> + <id>202</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3449,7 +3562,23 @@ <type>varchar(n)</type> </word> <word> - <id>196</id> + <id>203</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>false</char_semantics> + <description>시스템 설명</description> + <logical_name>시스템 설명</logical_name> + <physical_name>sys_dc</physical_name> + <type>text</type> + </word> + <word> + <id>204</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3465,7 +3594,39 @@ <type>text</type> </word> <word> - <id>197</id> + <id>205</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>sys_id</physical_name> + <type>numeric(p)</type> + </word> + <word> + <id>206</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>시스템명</description> + <logical_name>시스템명</logical_name> + <physical_name>sys_nm</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>207</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3481,7 +3642,7 @@ <type>varchar(n)</type> </word> <word> - <id>198</id> + <id>208</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3497,7 +3658,7 @@ <type>character(n)</type> </word> <word> - <id>199</id> + <id>209</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3513,7 +3674,7 @@ <type>varchar(n)</type> </word> <word> - <id>200</id> + <id>210</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3529,7 +3690,7 @@ <type>numeric(p)</type> </word> <word> - <id>201</id> + <id>211</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3545,7 +3706,7 @@ <type>numeric(p)</type> </word> <word> - <id>202</id> + <id>212</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3561,7 +3722,7 @@ <type>timestamp</type> </word> <word> - <id>203</id> + <id>213</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3577,7 +3738,7 @@ <type>varchar(n)</type> </word> <word> - <id>204</id> + <id>214</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3593,7 +3754,7 @@ <type>text</type> </word> <word> - <id>205</id> + <id>215</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3609,7 +3770,7 @@ <type>varchar(n)</type> </word> <word> - <id>206</id> + <id>216</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3625,7 +3786,7 @@ <type>varchar(n)</type> </word> <word> - <id>207</id> + <id>217</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3641,7 +3802,7 @@ <type>varchar(n)</type> </word> <word> - <id>208</id> + <id>218</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3657,7 +3818,7 @@ <type>varchar(n)</type> </word> <word> - <id>209</id> + <id>219</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3673,7 +3834,7 @@ <type>varchar(n)</type> </word> <word> - <id>210</id> + <id>220</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3689,7 +3850,7 @@ <type>varchar(n)</type> </word> <word> - <id>211</id> + <id>221</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3705,7 +3866,7 @@ <type>varchar(n)</type> </word> <word> - <id>212</id> + <id>222</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3721,7 +3882,7 @@ <type></type> </word> <word> - <id>213</id> + <id>223</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3737,7 +3898,7 @@ <type>varchar(n)</type> </word> <word> - <id>214</id> + <id>224</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3753,7 +3914,7 @@ <type>char</type> </word> <word> - <id>215</id> + <id>225</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -3769,7 +3930,7 @@ <type>varchar(n)</type> </word> <word> - <id>216</id> + <id>226</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3785,7 +3946,7 @@ <type>varchar(n)</type> </word> <word> - <id>217</id> + <id>227</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3801,7 +3962,7 @@ <type>varchar(n)</type> </word> <word> - <id>218</id> + <id>228</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3841,7 +4002,7 @@ <sql>SELECT comtngnrlmber.esntl_id,
 comtngnrlmber.mber_id AS user_id,
 comtngnrlmber.password,
 comtngnrlmber.mber_nm AS user_nm,
 comtngnrlmber.zip AS user_zip,
 comtngnrlmber.adres AS user_adres,
 comtngnrlmber.mber_email_adres AS user_email,
 ' '::bpchar AS group_id,
 'GNR'::text AS user_se,
 ' '::bpchar AS orgnzt_id
 FROM comtngnrlmber
UNION ALL
 SELECT comtnemplyrinfo.esntl_id,
 comtnemplyrinfo.emplyr_id AS user_id,
 comtnemplyrinfo.password,
 comtnemplyrinfo.user_nm,
 comtnemplyrinfo.zip AS user_zip,
 comtnemplyrinfo.house_adres AS user_adres,
 comtnemplyrinfo.email_adres AS user_email,
 comtnemplyrinfo.group_id,
 'USR'::text AS user_se,
 comtnemplyrinfo.orgnzt_id
 FROM comtnemplyrinfo
UNION ALL
 SELECT comtnentrprsmber.esntl_id,
 comtnentrprsmber.entrprs_mber_id AS user_id,
 comtnentrprsmber.entrprs_mber_password AS password,
 comtnentrprsmber.cmpny_nm AS user_nm,
 comtnentrprsmber.zip AS user_zip,
 comtnentrprsmber.adres AS user_adres,
 comtnentrprsmber.applcnt_email_adres AS user_email,
 ' '::bpchar AS group_id,
 'ENT'::text AS user_se,
 ' '::bpchar AS orgnzt_id
 FROM comtnentrprsmber
 ORDER BY 1;</sql> <columns> <normal_column> - <word_id>73</word_id> + <word_id>78</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -3874,7 +4035,7 @@ </sequence> </normal_column> <normal_column> - <word_id>209</word_id> + <word_id>219</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -3907,7 +4068,7 @@ </sequence> </normal_column> <normal_column> - <word_id>155</word_id> + <word_id>162</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -3940,7 +4101,7 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> + <word_id>221</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -3973,7 +4134,7 @@ </sequence> </normal_column> <normal_column> - <word_id>213</word_id> + <word_id>223</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4006,7 +4167,7 @@ </sequence> </normal_column> <normal_column> - <word_id>206</word_id> + <word_id>216</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4039,7 +4200,7 @@ </sequence> </normal_column> <normal_column> - <word_id>207</word_id> + <word_id>217</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4072,7 +4233,7 @@ </sequence> </normal_column> <normal_column> - <word_id>91</word_id> + <word_id>97</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4105,7 +4266,7 @@ </sequence> </normal_column> <normal_column> - <word_id>212</word_id> + <word_id>222</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4138,7 +4299,7 @@ </sequence> </normal_column> <normal_column> - <word_id>147</word_id> + <word_id>154</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4198,7 +4359,7 @@ <option></option> <columns> <normal_column> - <word_id>142</word_id> + <word_id>149</word_id> <id>0</id> <description></description> <unique_key_name></unique_key_name> @@ -4231,7 +4392,7 @@ </sequence> </normal_column> <normal_column> - <word_id>205</word_id> + <word_id>215</word_id> <id>1</id> <description></description> <unique_key_name></unique_key_name> @@ -4264,7 +4425,7 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> + <word_id>174</word_id> <id>2</id> <description></description> <unique_key_name></unique_key_name> @@ -4329,7 +4490,7 @@ <option></option> <columns> <normal_column> - <word_id>142</word_id> + <word_id>149</word_id> <id>3</id> <description></description> <unique_key_name></unique_key_name> @@ -4362,7 +4523,7 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> + <word_id>201</word_id> <id>4</id> <description></description> <unique_key_name></unique_key_name> @@ -4395,7 +4556,7 @@ </sequence> </normal_column> <normal_column> - <word_id>127</word_id> + <word_id>134</word_id> <id>5</id> <description></description> <unique_key_name></unique_key_name> @@ -4428,7 +4589,7 @@ </sequence> </normal_column> <normal_column> - <word_id>43</word_id> + <word_id>49</word_id> <id>6</id> <description></description> <unique_key_name></unique_key_name> @@ -4461,7 +4622,7 @@ </sequence> </normal_column> <normal_column> - <word_id>200</word_id> + <word_id>210</word_id> <id>7</id> <description></description> <unique_key_name></unique_key_name> @@ -4494,7 +4655,7 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> + <word_id>174</word_id> <id>8</id> <description></description> <unique_key_name></unique_key_name> @@ -4527,7 +4688,7 @@ </sequence> </normal_column> <normal_column> - <word_id>50</word_id> + <word_id>56</word_id> <id>9</id> <description></description> <unique_key_name></unique_key_name> @@ -4560,7 +4721,7 @@ </sequence> </normal_column> <normal_column> - <word_id>152</word_id> + <word_id>160</word_id> <id>10</id> <description></description> <unique_key_name></unique_key_name> @@ -4593,7 +4754,7 @@ </sequence> </normal_column> <normal_column> - <word_id>67</word_id> + <word_id>73</word_id> <id>11</id> <description></description> <unique_key_name></unique_key_name> @@ -4815,7 +4976,7 @@ <option></option> <columns> <normal_column> - <word_id>148</word_id> + <word_id>155</word_id> <id>14</id> <description></description> <unique_key_name></unique_key_name> @@ -4848,7 +5009,7 @@ </sequence> </normal_column> <normal_column> - <word_id>149</word_id> + <word_id>156</word_id> <id>15</id> <description></description> <unique_key_name></unique_key_name> @@ -4881,7 +5042,7 @@ </sequence> </normal_column> <normal_column> - <word_id>146</word_id> + <word_id>153</word_id> <id>16</id> <description></description> <unique_key_name></unique_key_name> @@ -5002,7 +5163,7 @@ </sequence> </normal_column> <normal_column> - <word_id>81</word_id> + <word_id>87</word_id> <id>18</id> <description></description> <unique_key_name></unique_key_name> @@ -5035,7 +5196,7 @@ </sequence> </normal_column> <normal_column> - <word_id>82</word_id> + <word_id>88</word_id> <id>19</id> <description></description> <unique_key_name></unique_key_name> @@ -5068,7 +5229,7 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> + <word_id>199</word_id> <id>20</id> <description></description> <unique_key_name></unique_key_name> @@ -5101,7 +5262,7 @@ </sequence> </normal_column> <normal_column> - <word_id>151</word_id> + <word_id>158</word_id> <id>21</id> <description></description> <unique_key_name></unique_key_name> @@ -5134,7 +5295,7 @@ </sequence> </normal_column> <normal_column> - <word_id>76</word_id> + <word_id>82</word_id> <id>22</id> <description></description> <unique_key_name></unique_key_name> @@ -5167,7 +5328,7 @@ </sequence> </normal_column> <normal_column> - <word_id>75</word_id> + <word_id>81</word_id> <id>23</id> <description></description> <unique_key_name></unique_key_name> @@ -5200,7 +5361,7 @@ </sequence> </normal_column> <normal_column> - <word_id>79</word_id> + <word_id>85</word_id> <id>24</id> <description></description> <unique_key_name></unique_key_name> @@ -5300,7 +5461,7 @@ <option></option> <columns> <normal_column> - <word_id>60</word_id> + <word_id>66</word_id> <id>25</id> <description></description> <unique_key_name></unique_key_name> @@ -5333,7 +5494,7 @@ </sequence> </normal_column> <normal_column> - <word_id>66</word_id> + <word_id>72</word_id> <id>26</id> <description></description> <unique_key_name></unique_key_name> @@ -5399,7 +5560,7 @@ </sequence> </normal_column> <normal_column> - <word_id>104</word_id> + <word_id>111</word_id> <id>28</id> <description></description> <unique_key_name></unique_key_name> @@ -5465,7 +5626,7 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> + <word_id>53</word_id> <id>30</id> <description></description> <unique_key_name></unique_key_name> @@ -5498,7 +5659,7 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> + <word_id>228</word_id> <id>31</id> <description></description> <unique_key_name></unique_key_name> @@ -5564,7 +5725,7 @@ </sequence> </normal_column> <normal_column> - <word_id>65</word_id> + <word_id>71</word_id> <id>33</id> <description></description> <unique_key_name></unique_key_name> @@ -5597,7 +5758,7 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> + <word_id>94</word_id> <id>34</id> <description></description> <unique_key_name></unique_key_name> @@ -5630,7 +5791,7 @@ </sequence> </normal_column> <normal_column> - <word_id>100</word_id> + <word_id>106</word_id> <id>35</id> <description></description> <unique_key_name></unique_key_name> @@ -5729,7 +5890,7 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> + <word_id>192</word_id> <id>38</id> <description></description> <unique_key_name></unique_key_name> @@ -5762,7 +5923,7 @@ </sequence> </normal_column> <normal_column> - <word_id>64</word_id> + <word_id>70</word_id> <id>39</id> <description></description> <unique_key_name></unique_key_name> @@ -5795,7 +5956,7 @@ </sequence> </normal_column> <normal_column> - <word_id>61</word_id> + <word_id>67</word_id> <id>40</id> <description></description> <unique_key_name></unique_key_name> @@ -5828,7 +5989,7 @@ </sequence> </normal_column> <normal_column> - <word_id>63</word_id> + <word_id>69</word_id> <id>41</id> <description></description> <unique_key_name></unique_key_name> @@ -5861,7 +6022,7 @@ </sequence> </normal_column> <normal_column> - <word_id>62</word_id> + <word_id>68</word_id> <id>42</id> <description></description> <unique_key_name></unique_key_name> @@ -5928,7 +6089,7 @@ </sequence> </normal_column> <normal_column> - <word_id>52</word_id> + <word_id>58</word_id> <id>44</id> <description></description> <unique_key_name></unique_key_name> @@ -5961,7 +6122,7 @@ </sequence> </normal_column> <normal_column> - <word_id>59</word_id> + <word_id>65</word_id> <id>45</id> <description></description> <unique_key_name></unique_key_name> @@ -6060,7 +6221,7 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> + <word_id>79</word_id> <id>48</id> <description></description> <unique_key_name></unique_key_name> @@ -6093,7 +6254,7 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> + <word_id>118</word_id> <id>49</id> <description></description> <unique_key_name></unique_key_name> @@ -6126,7 +6287,7 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> + <word_id>119</word_id> <id>50</id> <description></description> <unique_key_name></unique_key_name> @@ -6159,7 +6320,7 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> + <word_id>120</word_id> <id>51</id> <description></description> <unique_key_name></unique_key_name> @@ -6263,7 +6424,7 @@ <connections> <relation> <id>4</id> - <source>11</source> + <source>4</source> <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -6277,7 +6438,7 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnemplyrinfo_group_id_fkey</name> + <name>comtnemplyrinfo_orgnzt_id_fkey</name> <on_delete_action>SET NULL</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -6285,7 +6446,7 @@ </relation> <relation> <id>5</id> - <source>4</source> + <source>11</source> <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -6299,7 +6460,7 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnemplyrinfo_orgnzt_id_fkey</name> + <name>comtnemplyrinfo_group_id_fkey</name> <on_delete_action>SET NULL</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -6314,7 +6475,7 @@ <option></option> <columns> <normal_column> - <word_id>55</word_id> + <word_id>61</word_id> <id>53</id> <description></description> <unique_key_name></unique_key_name> @@ -6349,7 +6510,7 @@ <normal_column> <id>54</id> <referenced_column>14</referenced_column> - <relation>5</relation> + <relation>4</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -6381,7 +6542,7 @@ </sequence> </normal_column> <normal_column> - <word_id>210</word_id> + <word_id>220</word_id> <id>55</id> <description></description> <unique_key_name></unique_key_name> @@ -6414,7 +6575,7 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> + <word_id>163</word_id> <id>56</id> <description></description> <unique_key_name></unique_key_name> @@ -6447,7 +6608,7 @@ </sequence> </normal_column> <normal_column> - <word_id>57</word_id> + <word_id>63</word_id> <id>57</id> <description></description> <unique_key_name></unique_key_name> @@ -6480,7 +6641,7 @@ </sequence> </normal_column> <normal_column> - <word_id>99</word_id> + <word_id>105</word_id> <id>58</id> <description></description> <unique_key_name></unique_key_name> @@ -6513,7 +6674,7 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> + <word_id>195</word_id> <id>59</id> <description></description> <unique_key_name></unique_key_name> @@ -6579,7 +6740,7 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> + <word_id>94</word_id> <id>61</id> <description></description> <unique_key_name></unique_key_name> @@ -6612,7 +6773,7 @@ </sequence> </normal_column> <normal_column> - <word_id>94</word_id> + <word_id>100</word_id> <id>62</id> <description></description> <unique_key_name></unique_key_name> @@ -6645,7 +6806,7 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> + <word_id>165</word_id> <id>63</id> <description></description> <unique_key_name></unique_key_name> @@ -6678,7 +6839,7 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> + <word_id>164</word_id> <id>64</id> <description></description> <unique_key_name></unique_key_name> @@ -6711,7 +6872,7 @@ </sequence> </normal_column> <normal_column> - <word_id>95</word_id> + <word_id>101</word_id> <id>65</id> <description></description> <unique_key_name></unique_key_name> @@ -6777,7 +6938,7 @@ </sequence> </normal_column> <normal_column> - <word_id>52</word_id> + <word_id>58</word_id> <id>67</id> <description></description> <unique_key_name></unique_key_name> @@ -6810,7 +6971,7 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> + <word_id>228</word_id> <id>68</id> <description></description> <unique_key_name></unique_key_name> @@ -6843,7 +7004,7 @@ </sequence> </normal_column> <normal_column> - <word_id>145</word_id> + <word_id>152</word_id> <id>69</id> <description></description> <unique_key_name></unique_key_name> @@ -6876,7 +7037,7 @@ </sequence> </normal_column> <normal_column> - <word_id>121</word_id> + <word_id>128</word_id> <id>70</id> <description></description> <unique_key_name></unique_key_name> @@ -6909,7 +7070,7 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> + <word_id>60</word_id> <id>71</id> <description></description> <unique_key_name></unique_key_name> @@ -6942,7 +7103,7 @@ </sequence> </normal_column> <normal_column> - <word_id>144</word_id> + <word_id>151</word_id> <id>72</id> <description></description> <unique_key_name></unique_key_name> @@ -6975,7 +7136,7 @@ </sequence> </normal_column> <normal_column> - <word_id>96</word_id> + <word_id>102</word_id> <id>73</id> <description></description> <unique_key_name></unique_key_name> @@ -7010,7 +7171,7 @@ <normal_column> <id>74</id> <referenced_column>98</referenced_column> - <relation>4</relation> + <relation>5</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7042,7 +7203,7 @@ </sequence> </normal_column> <normal_column> - <word_id>165</word_id> + <word_id>172</word_id> <id>75</id> <description></description> <unique_key_name></unique_key_name> @@ -7075,7 +7236,7 @@ </sequence> </normal_column> <normal_column> - <word_id>56</word_id> + <word_id>62</word_id> <id>76</id> <description></description> <unique_key_name></unique_key_name> @@ -7108,7 +7269,7 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> + <word_id>79</word_id> <id>77</id> <description></description> <unique_key_name></unique_key_name> @@ -7141,7 +7302,7 @@ </sequence> </normal_column> <normal_column> - <word_id>46</word_id> + <word_id>52</word_id> <id>78</id> <description></description> <unique_key_name></unique_key_name> @@ -7174,7 +7335,7 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> + <word_id>192</word_id> <id>79</id> <description></description> <unique_key_name></unique_key_name> @@ -7207,7 +7368,7 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> + <word_id>118</word_id> <id>80</id> <description></description> <unique_key_name></unique_key_name> @@ -7240,7 +7401,7 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> + <word_id>119</word_id> <id>81</id> <description></description> <unique_key_name></unique_key_name> @@ -7273,7 +7434,7 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> + <word_id>120</word_id> <id>82</id> <description></description> <unique_key_name></unique_key_name> @@ -7463,7 +7624,7 @@ </sequence> </normal_column> <normal_column> - <word_id>193</word_id> + <word_id>200</word_id> <id>86</id> <description></description> <unique_key_name></unique_key_name> @@ -7496,7 +7657,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>87</id> <description></description> <unique_key_name></unique_key_name> @@ -7529,7 +7690,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>88</id> <description></description> <unique_key_name></unique_key_name> @@ -7562,7 +7723,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>89</id> <description></description> <unique_key_name></unique_key_name> @@ -7595,7 +7756,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>90</id> <description></description> <unique_key_name></unique_key_name> @@ -7772,7 +7933,7 @@ </sequence> </normal_column> <normal_column> - <word_id>45</word_id> + <word_id>51</word_id> <id>93</id> <description></description> <unique_key_name></unique_key_name> @@ -7863,7 +8024,7 @@ <option></option> <columns> <normal_column> - <word_id>14</word_id> + <word_id>13</word_id> <id>94</id> <description></description> <unique_key_name></unique_key_name> @@ -8027,7 +8188,7 @@ <option></option> <columns> <normal_column> - <word_id>92</word_id> + <word_id>98</word_id> <id>98</id> <description></description> <unique_key_name></unique_key_name> @@ -8060,7 +8221,7 @@ </sequence> </normal_column> <normal_column> - <word_id>93</word_id> + <word_id>99</word_id> <id>99</id> <description></description> <unique_key_name></unique_key_name> @@ -8093,7 +8254,7 @@ </sequence> </normal_column> <normal_column> - <word_id>89</word_id> + <word_id>95</word_id> <id>100</id> <description></description> <unique_key_name></unique_key_name> @@ -8126,7 +8287,7 @@ </sequence> </normal_column> <normal_column> - <word_id>90</word_id> + <word_id>96</word_id> <id>101</id> <description></description> <unique_key_name></unique_key_name> @@ -8174,8 +8335,8 @@ <width>125</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>40</x> - <y>499</y> + <x>36</x> + <y>500</y> <color> <r>128</r> <g>128</g> @@ -8191,7 +8352,7 @@ <option></option> <columns> <normal_column> - <word_id>197</word_id> + <word_id>207</word_id> <id>102</id> <description></description> <unique_key_name></unique_key_name> @@ -8224,7 +8385,7 @@ </sequence> </normal_column> <normal_column> - <word_id>131</word_id> + <word_id>138</word_id> <id>103</id> <description></description> <unique_key_name></unique_key_name> @@ -8444,7 +8605,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>108</id> <description></description> <unique_key_name></unique_key_name> @@ -8477,7 +8638,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>109</id> <description></description> <unique_key_name></unique_key_name> @@ -8510,7 +8671,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>110</id> <description></description> <unique_key_name></unique_key_name> @@ -8543,7 +8704,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>111</id> <description></description> <unique_key_name></unique_key_name> @@ -8576,7 +8737,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>112</id> <description></description> <unique_key_name></unique_key_name> @@ -8775,7 +8936,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>116</id> <description></description> <unique_key_name></unique_key_name> @@ -8842,7 +9003,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>118</id> <description></description> <unique_key_name></unique_key_name> @@ -8875,7 +9036,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>119</id> <description></description> <unique_key_name></unique_key_name> @@ -8908,7 +9069,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>120</id> <description></description> <unique_key_name></unique_key_name> @@ -8941,7 +9102,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>121</id> <description></description> <unique_key_name></unique_key_name> @@ -9019,7 +9180,7 @@ <option></option> <columns> <normal_column> - <word_id>173</word_id> + <word_id>180</word_id> <id>122</id> <description></description> <unique_key_name></unique_key_name> @@ -9052,7 +9213,7 @@ </sequence> </normal_column> <normal_column> - <word_id>143</word_id> + <word_id>150</word_id> <id>123</id> <description></description> <unique_key_name></unique_key_name> @@ -9085,7 +9246,7 @@ </sequence> </normal_column> <normal_column> - <word_id>205</word_id> + <word_id>215</word_id> <id>124</id> <description></description> <unique_key_name></unique_key_name> @@ -9118,7 +9279,7 @@ </sequence> </normal_column> <normal_column> - <word_id>181</word_id> + <word_id>188</word_id> <id>125</id> <description></description> <unique_key_name></unique_key_name> @@ -9151,7 +9312,7 @@ </sequence> </normal_column> <normal_column> - <word_id>183</word_id> + <word_id>190</word_id> <id>126</id> <description></description> <unique_key_name></unique_key_name> @@ -9199,8 +9360,8 @@ <width>233</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>338</x> - <y>499</y> + <x>334</x> + <y>500</y> <color> <r>128</r> <g>128</g> @@ -9216,7 +9377,7 @@ <option></option> <columns> <normal_column> - <word_id>98</word_id> + <word_id>104</word_id> <id>127</id> <description></description> <unique_key_name></unique_key_name> @@ -9249,7 +9410,7 @@ </sequence> </normal_column> <normal_column> - <word_id>97</word_id> + <word_id>103</word_id> <id>128</id> <description></description> <unique_key_name></unique_key_name> @@ -9413,7 +9574,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>132</id> <description></description> <unique_key_name></unique_key_name> @@ -9446,7 +9607,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>133</id> <description></description> <unique_key_name></unique_key_name> @@ -9479,7 +9640,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>134</id> <description></description> <unique_key_name></unique_key_name> @@ -9512,7 +9673,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>135</id> <description></description> <unique_key_name></unique_key_name> @@ -9545,7 +9706,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>136</id> <description></description> <unique_key_name></unique_key_name> @@ -9632,7 +9793,7 @@ <option></option> <columns> <normal_column> - <word_id>117</word_id> + <word_id>124</word_id> <id>137</id> <description></description> <unique_key_name></unique_key_name> @@ -9665,7 +9826,7 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> + <word_id>163</word_id> <id>138</id> <description></description> <unique_key_name></unique_key_name> @@ -9698,7 +9859,7 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> + <word_id>165</word_id> <id>139</id> <description></description> <unique_key_name></unique_key_name> @@ -9731,7 +9892,7 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> + <word_id>164</word_id> <id>140</id> <description></description> <unique_key_name></unique_key_name> @@ -9764,7 +9925,7 @@ </sequence> </normal_column> <normal_column> - <word_id>99</word_id> + <word_id>105</word_id> <id>141</id> <description></description> <unique_key_name></unique_key_name> @@ -9797,7 +9958,7 @@ </sequence> </normal_column> <normal_column> - <word_id>118</word_id> + <word_id>125</word_id> <id>142</id> <description></description> <unique_key_name></unique_key_name> @@ -9830,7 +9991,7 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> + <word_id>228</word_id> <id>143</id> <description></description> <unique_key_name></unique_key_name> @@ -9929,7 +10090,7 @@ </sequence> </normal_column> <normal_column> - <word_id>119</word_id> + <word_id>126</word_id> <id>146</id> <description></description> <unique_key_name></unique_key_name> @@ -9962,7 +10123,7 @@ </sequence> </normal_column> <normal_column> - <word_id>52</word_id> + <word_id>58</word_id> <id>147</id> <description></description> <unique_key_name></unique_key_name> @@ -9995,7 +10156,7 @@ </sequence> </normal_column> <normal_column> - <word_id>58</word_id> + <word_id>64</word_id> <id>148</id> <description></description> <unique_key_name></unique_key_name> @@ -10028,7 +10189,7 @@ </sequence> </normal_column> <normal_column> - <word_id>121</word_id> + <word_id>128</word_id> <id>149</id> <description></description> <unique_key_name></unique_key_name> @@ -10095,7 +10256,7 @@ </sequence> </normal_column> <normal_column> - <word_id>116</word_id> + <word_id>123</word_id> <id>151</id> <description></description> <unique_key_name></unique_key_name> @@ -10128,7 +10289,7 @@ </sequence> </normal_column> <normal_column> - <word_id>115</word_id> + <word_id>122</word_id> <id>152</id> <description></description> <unique_key_name></unique_key_name> @@ -10161,7 +10322,7 @@ </sequence> </normal_column> <normal_column> - <word_id>129</word_id> + <word_id>136</word_id> <id>153</id> <description></description> <unique_key_name></unique_key_name> @@ -10194,7 +10355,7 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> + <word_id>192</word_id> <id>154</id> <description></description> <unique_key_name></unique_key_name> @@ -10227,7 +10388,7 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> + <word_id>195</word_id> <id>155</id> <description></description> <unique_key_name></unique_key_name> @@ -10260,7 +10421,7 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> + <word_id>79</word_id> <id>156</id> <description></description> <unique_key_name></unique_key_name> @@ -10293,7 +10454,7 @@ </sequence> </normal_column> <normal_column> - <word_id>111</word_id> + <word_id>118</word_id> <id>157</id> <description></description> <unique_key_name></unique_key_name> @@ -10326,7 +10487,7 @@ </sequence> </normal_column> <normal_column> - <word_id>112</word_id> + <word_id>119</word_id> <id>158</id> <description></description> <unique_key_name></unique_key_name> @@ -10359,7 +10520,7 @@ </sequence> </normal_column> <normal_column> - <word_id>113</word_id> + <word_id>120</word_id> <id>159</id> <description></description> <unique_key_name></unique_key_name> @@ -10470,7 +10631,7 @@ <option></option> <columns> <normal_column> - <word_id>114</word_id> + <word_id>121</word_id> <id>161</id> <description></description> <unique_key_name></unique_key_name> @@ -10602,7 +10763,7 @@ </sequence> </normal_column> <normal_column> - <word_id>70</word_id> + <word_id>76</word_id> <id>165</id> <description></description> <unique_key_name></unique_key_name> @@ -10635,7 +10796,7 @@ </sequence> </normal_column> <normal_column> - <word_id>69</word_id> + <word_id>75</word_id> <id>166</id> <description></description> <unique_key_name></unique_key_name> @@ -10668,7 +10829,7 @@ </sequence> </normal_column> <normal_column> - <word_id>45</word_id> + <word_id>51</word_id> <id>167</id> <description></description> <unique_key_name></unique_key_name> @@ -10733,7 +10894,7 @@ <option></option> <columns> <normal_column> - <word_id>55</word_id> + <word_id>61</word_id> <id>168</id> <description></description> <unique_key_name></unique_key_name> @@ -10766,7 +10927,7 @@ </sequence> </normal_column> <normal_column> - <word_id>102</word_id> + <word_id>109</word_id> <id>169</id> <description></description> <unique_key_name></unique_key_name> @@ -10799,7 +10960,7 @@ </sequence> </normal_column> <normal_column> - <word_id>53</word_id> + <word_id>59</word_id> <id>170</id> <description></description> <unique_key_name></unique_key_name> @@ -10832,7 +10993,7 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> + <word_id>117</word_id> <id>171</id> <description></description> <unique_key_name></unique_key_name> @@ -10865,7 +11026,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>172</id> <description></description> <unique_key_name></unique_key_name> @@ -10898,7 +11059,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>173</id> <description></description> <unique_key_name></unique_key_name> @@ -10931,7 +11092,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>174</id> <description></description> <unique_key_name></unique_key_name> @@ -10964,7 +11125,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>175</id> <description></description> <unique_key_name></unique_key_name> @@ -11029,7 +11190,7 @@ <option></option> <columns> <normal_column> - <word_id>186</word_id> + <word_id>193</word_id> <id>176</id> <description></description> <unique_key_name></unique_key_name> @@ -11062,7 +11223,7 @@ </sequence> </normal_column> <normal_column> - <word_id>120</word_id> + <word_id>127</word_id> <id>177</id> <description></description> <unique_key_name></unique_key_name> @@ -11095,7 +11256,7 @@ </sequence> </normal_column> <normal_column> - <word_id>14</word_id> + <word_id>13</word_id> <id>178</id> <description></description> <unique_key_name></unique_key_name> @@ -11262,7 +11423,7 @@ </sequence> </normal_column> <normal_column> - <word_id>148</word_id> + <word_id>155</word_id> <id>181</id> <description></description> <unique_key_name></unique_key_name> @@ -11295,7 +11456,7 @@ </sequence> </normal_column> <normal_column> - <word_id>92</word_id> + <word_id>98</word_id> <id>182</id> <description></description> <unique_key_name></unique_key_name> @@ -11328,7 +11489,7 @@ </sequence> </normal_column> <normal_column> - <word_id>57</word_id> + <word_id>63</word_id> <id>183</id> <description></description> <unique_key_name></unique_key_name> @@ -11361,7 +11522,7 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> + <word_id>195</word_id> <id>184</id> <description></description> <unique_key_name></unique_key_name> @@ -11427,7 +11588,7 @@ </sequence> </normal_column> <normal_column> - <word_id>88</word_id> + <word_id>94</word_id> <id>186</id> <description></description> <unique_key_name></unique_key_name> @@ -11460,7 +11621,7 @@ </sequence> </normal_column> <normal_column> - <word_id>94</word_id> + <word_id>100</word_id> <id>187</id> <description></description> <unique_key_name></unique_key_name> @@ -11493,7 +11654,7 @@ </sequence> </normal_column> <normal_column> - <word_id>95</word_id> + <word_id>101</word_id> <id>188</id> <description></description> <unique_key_name></unique_key_name> @@ -11559,7 +11720,7 @@ </sequence> </normal_column> <normal_column> - <word_id>52</word_id> + <word_id>58</word_id> <id>190</id> <description></description> <unique_key_name></unique_key_name> @@ -11592,7 +11753,7 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> + <word_id>228</word_id> <id>191</id> <description></description> <unique_key_name></unique_key_name> @@ -11625,7 +11786,7 @@ </sequence> </normal_column> <normal_column> - <word_id>145</word_id> + <word_id>152</word_id> <id>192</id> <description></description> <unique_key_name></unique_key_name> @@ -11658,7 +11819,7 @@ </sequence> </normal_column> <normal_column> - <word_id>121</word_id> + <word_id>128</word_id> <id>193</id> <description></description> <unique_key_name></unique_key_name> @@ -11691,7 +11852,7 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> + <word_id>60</word_id> <id>194</id> <description></description> <unique_key_name></unique_key_name> @@ -11724,7 +11885,7 @@ </sequence> </normal_column> <normal_column> - <word_id>96</word_id> + <word_id>102</word_id> <id>195</id> <description></description> <unique_key_name></unique_key_name> @@ -11757,7 +11918,7 @@ </sequence> </normal_column> <normal_column> - <word_id>165</word_id> + <word_id>172</word_id> <id>196</id> <description></description> <unique_key_name></unique_key_name> @@ -11790,7 +11951,7 @@ </sequence> </normal_column> <normal_column> - <word_id>56</word_id> + <word_id>62</word_id> <id>197</id> <description></description> <unique_key_name></unique_key_name> @@ -11823,7 +11984,7 @@ </sequence> </normal_column> <normal_column> - <word_id>72</word_id> + <word_id>79</word_id> <id>198</id> <description></description> <unique_key_name></unique_key_name> @@ -11901,7 +12062,7 @@ <option></option> <columns> <normal_column> - <word_id>173</word_id> + <word_id>180</word_id> <id>199</id> <description></description> <unique_key_name></unique_key_name> @@ -11934,7 +12095,7 @@ </sequence> </normal_column> <normal_column> - <word_id>103</word_id> + <word_id>110</word_id> <id>200</id> <description></description> <unique_key_name></unique_key_name> @@ -11967,7 +12128,7 @@ </sequence> </normal_column> <normal_column> - <word_id>101</word_id> + <word_id>108</word_id> <id>201</id> <description></description> <unique_key_name></unique_key_name> @@ -12000,7 +12161,7 @@ </sequence> </normal_column> <normal_column> - <word_id>143</word_id> + <word_id>150</word_id> <id>202</id> <description></description> <unique_key_name></unique_key_name> @@ -12033,7 +12194,7 @@ </sequence> </normal_column> <normal_column> - <word_id>183</word_id> + <word_id>190</word_id> <id>203</id> <description></description> <unique_key_name></unique_key_name> @@ -12066,7 +12227,7 @@ </sequence> </normal_column> <normal_column> - <word_id>181</word_id> + <word_id>188</word_id> <id>204</id> <description></description> <unique_key_name></unique_key_name> @@ -12099,7 +12260,7 @@ </sequence> </normal_column> <normal_column> - <word_id>199</word_id> + <word_id>209</word_id> <id>205</id> <description></description> <unique_key_name></unique_key_name> @@ -12132,7 +12293,7 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> + <word_id>201</word_id> <id>206</id> <description></description> <unique_key_name></unique_key_name> @@ -12165,7 +12326,7 @@ </sequence> </normal_column> <normal_column> - <word_id>127</word_id> + <word_id>134</word_id> <id>207</id> <description></description> <unique_key_name></unique_key_name> @@ -12198,7 +12359,7 @@ </sequence> </normal_column> <normal_column> - <word_id>160</word_id> + <word_id>167</word_id> <id>208</id> <description></description> <unique_key_name></unique_key_name> @@ -12231,7 +12392,7 @@ </sequence> </normal_column> <normal_column> - <word_id>159</word_id> + <word_id>166</word_id> <id>209</id> <description></description> <unique_key_name></unique_key_name> @@ -12264,7 +12425,7 @@ </sequence> </normal_column> <normal_column> - <word_id>161</word_id> + <word_id>168</word_id> <id>210</id> <description></description> <unique_key_name></unique_key_name> @@ -12297,7 +12458,7 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> + <word_id>191</word_id> <id>211</id> <description></description> <unique_key_name></unique_key_name> @@ -12330,7 +12491,7 @@ </sequence> </normal_column> <normal_column> - <word_id>71</word_id> + <word_id>77</word_id> <id>212</id> <description></description> <unique_key_name></unique_key_name> @@ -12363,7 +12524,7 @@ </sequence> </normal_column> <normal_column> - <word_id>67</word_id> + <word_id>73</word_id> <id>213</id> <description></description> <unique_key_name></unique_key_name> @@ -12396,7 +12557,7 @@ </sequence> </normal_column> <normal_column> - <word_id>69</word_id> + <word_id>75</word_id> <id>214</id> <description></description> <unique_key_name></unique_key_name> @@ -12584,7 +12745,7 @@ </sequence> </normal_column> <normal_column> - <word_id>216</word_id> + <word_id>226</word_id> <id>218</id> <description></description> <unique_key_name></unique_key_name> @@ -12617,7 +12778,7 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>227</word_id> <id>219</id> <description></description> <unique_key_name></unique_key_name> @@ -12683,7 +12844,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>221</id> <description></description> <unique_key_name></unique_key_name> @@ -12716,7 +12877,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>222</id> <description></description> <unique_key_name></unique_key_name> @@ -12749,7 +12910,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>223</id> <description></description> <unique_key_name></unique_key_name> @@ -12782,7 +12943,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>224</id> <description></description> <unique_key_name></unique_key_name> @@ -12815,7 +12976,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>225</id> <description></description> <unique_key_name></unique_key_name> @@ -12848,7 +13009,7 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> + <word_id>163</word_id> <id>226</id> <description></description> <unique_key_name></unique_key_name> @@ -12963,7 +13124,7 @@ </sequence> </normal_column> <normal_column> - <word_id>45</word_id> + <word_id>51</word_id> <id>228</id> <description></description> <unique_key_name></unique_key_name> @@ -12996,7 +13157,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>229</id> <description></description> <unique_key_name></unique_key_name> @@ -13061,7 +13222,7 @@ <option></option> <columns> <normal_column> - <word_id>141</word_id> + <word_id>148</word_id> <id>230</id> <description></description> <unique_key_name></unique_key_name> @@ -13094,7 +13255,7 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> + <word_id>189</word_id> <id>231</id> <description></description> <unique_key_name></unique_key_name> @@ -13127,7 +13288,7 @@ </sequence> </normal_column> <normal_column> - <word_id>194</word_id> + <word_id>202</word_id> <id>232</id> <description></description> <unique_key_name></unique_key_name> @@ -13160,7 +13321,7 @@ </sequence> </normal_column> <normal_column> - <word_id>128</word_id> + <word_id>135</word_id> <id>233</id> <description></description> <unique_key_name></unique_key_name> @@ -13193,7 +13354,7 @@ </sequence> </normal_column> <normal_column> - <word_id>44</word_id> + <word_id>50</word_id> <id>234</id> <description></description> <unique_key_name></unique_key_name> @@ -13226,7 +13387,7 @@ </sequence> </normal_column> <normal_column> - <word_id>201</word_id> + <word_id>211</word_id> <id>235</id> <description></description> <unique_key_name></unique_key_name> @@ -13259,7 +13420,7 @@ </sequence> </normal_column> <normal_column> - <word_id>167</word_id> + <word_id>173</word_id> <id>236</id> <description></description> <unique_key_name></unique_key_name> @@ -13292,7 +13453,7 @@ </sequence> </normal_column> <normal_column> - <word_id>51</word_id> + <word_id>57</word_id> <id>237</id> <description></description> <unique_key_name></unique_key_name> @@ -13325,7 +13486,7 @@ </sequence> </normal_column> <normal_column> - <word_id>153</word_id> + <word_id>159</word_id> <id>238</id> <description></description> <unique_key_name></unique_key_name> @@ -13358,7 +13519,7 @@ </sequence> </normal_column> <normal_column> - <word_id>68</word_id> + <word_id>74</word_id> <id>239</id> <description></description> <unique_key_name></unique_key_name> @@ -13423,7 +13584,7 @@ <option></option> <columns> <normal_column> - <word_id>78</word_id> + <word_id>84</word_id> <id>240</id> <description></description> <unique_key_name></unique_key_name> @@ -13456,7 +13617,7 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> + <word_id>116</word_id> <id>241</id> <description></description> <unique_key_name></unique_key_name> @@ -13489,7 +13650,7 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> + <word_id>93</word_id> <id>242</id> <description></description> <unique_key_name></unique_key_name> @@ -13522,7 +13683,7 @@ </sequence> </normal_column> <normal_column> - <word_id>150</word_id> + <word_id>157</word_id> <id>243</id> <description></description> <unique_key_name></unique_key_name> @@ -13555,7 +13716,7 @@ </sequence> </normal_column> <normal_column> - <word_id>196</word_id> + <word_id>204</word_id> <id>244</id> <description></description> <unique_key_name></unique_key_name> @@ -13588,7 +13749,7 @@ </sequence> </normal_column> <normal_column> - <word_id>204</word_id> + <word_id>214</word_id> <id>245</id> <description></description> <unique_key_name></unique_key_name> @@ -13621,7 +13782,7 @@ </sequence> </normal_column> <normal_column> - <word_id>80</word_id> + <word_id>86</word_id> <id>246</id> <description></description> <unique_key_name></unique_key_name> @@ -13654,7 +13815,7 @@ </sequence> </normal_column> <normal_column> - <word_id>130</word_id> + <word_id>137</word_id> <id>247</id> <description></description> <unique_key_name></unique_key_name> @@ -13687,7 +13848,7 @@ </sequence> </normal_column> <normal_column> - <word_id>77</word_id> + <word_id>83</word_id> <id>248</id> <description></description> <unique_key_name></unique_key_name> @@ -13720,7 +13881,7 @@ </sequence> </normal_column> <normal_column> - <word_id>168</word_id> + <word_id>175</word_id> <id>249</id> <description></description> <unique_key_name></unique_key_name> @@ -13753,7 +13914,7 @@ </sequence> </normal_column> <normal_column> - <word_id>169</word_id> + <word_id>176</word_id> <id>250</id> <description></description> <unique_key_name></unique_key_name> @@ -13786,7 +13947,7 @@ </sequence> </normal_column> <normal_column> - <word_id>203</word_id> + <word_id>213</word_id> <id>251</id> <description></description> <unique_key_name></unique_key_name> @@ -13819,7 +13980,7 @@ </sequence> </normal_column> <normal_column> - <word_id>202</word_id> + <word_id>212</word_id> <id>252</id> <description></description> <unique_key_name></unique_key_name> @@ -13906,7 +14067,7 @@ <option></option> <columns> <normal_column> - <word_id>138</word_id> + <word_id>145</word_id> <id>253</id> <description></description> <unique_key_name></unique_key_name> @@ -13944,6 +14105,14 @@ <referenced_column>300</referenced_column> <referenced_column>300</referenced_column> <referenced_column>300</referenced_column> + <referenced_column>300</referenced_column> + <referenced_column>300</referenced_column> + <referenced_column>300</referenced_column> + <referenced_column>300</referenced_column> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> <relation>13</relation> <relation>13</relation> <relation>13</relation> @@ -13979,7 +14148,7 @@ </sequence> </normal_column> <normal_column> - <word_id>139</word_id> + <word_id>146</word_id> <id>255</id> <description></description> <unique_key_name></unique_key_name> @@ -14012,7 +14181,7 @@ </sequence> </normal_column> <normal_column> - <word_id>140</word_id> + <word_id>147</word_id> <id>256</id> <description></description> <unique_key_name></unique_key_name> @@ -14045,7 +14214,7 @@ </sequence> </normal_column> <normal_column> - <word_id>137</word_id> + <word_id>144</word_id> <id>257</id> <description></description> <unique_key_name></unique_key_name> @@ -14111,7 +14280,7 @@ </sequence> </normal_column> <normal_column> - <word_id>154</word_id> + <word_id>161</word_id> <id>259</id> <description></description> <unique_key_name></unique_key_name> @@ -14177,7 +14346,7 @@ </sequence> </normal_column> <normal_column> - <word_id>191</word_id> + <word_id>198</word_id> <id>261</id> <description></description> <unique_key_name></unique_key_name> @@ -14210,7 +14379,7 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> + <word_id>174</word_id> <id>262</id> <description></description> <unique_key_name></unique_key_name> @@ -14243,7 +14412,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>263</id> <description></description> <unique_key_name></unique_key_name> @@ -14276,7 +14445,7 @@ </sequence> </normal_column> <normal_column> - <word_id>133</word_id> + <word_id>140</word_id> <id>264</id> <description></description> <unique_key_name></unique_key_name> @@ -14309,7 +14478,7 @@ </sequence> </normal_column> <normal_column> - <word_id>134</word_id> + <word_id>141</word_id> <id>265</id> <description></description> <unique_key_name></unique_key_name> @@ -14342,7 +14511,7 @@ </sequence> </normal_column> <normal_column> - <word_id>135</word_id> + <word_id>142</word_id> <id>266</id> <description></description> <unique_key_name></unique_key_name> @@ -14375,7 +14544,7 @@ </sequence> </normal_column> <normal_column> - <word_id>136</word_id> + <word_id>143</word_id> <id>267</id> <description></description> <unique_key_name></unique_key_name> @@ -14408,7 +14577,7 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> + <word_id>163</word_id> <id>268</id> <description></description> <unique_key_name></unique_key_name> @@ -14474,7 +14643,7 @@ </sequence> </normal_column> <normal_column> - <word_id>132</word_id> + <word_id>139</word_id> <id>270</id> <description></description> <unique_key_name></unique_key_name> @@ -14507,7 +14676,7 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> + <word_id>196</word_id> <id>271</id> <description></description> <unique_key_name></unique_key_name> @@ -14540,7 +14709,7 @@ </sequence> </normal_column> <normal_column> - <word_id>187</word_id> + <word_id>194</word_id> <id>272</id> <description></description> <unique_key_name></unique_key_name> @@ -14573,7 +14742,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>273</id> <description></description> <unique_key_name></unique_key_name> @@ -14606,7 +14775,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>274</id> <description></description> <unique_key_name></unique_key_name> @@ -14639,7 +14808,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>275</id> <description></description> <unique_key_name></unique_key_name> @@ -14672,7 +14841,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>276</id> <description></description> <unique_key_name></unique_key_name> @@ -14838,7 +15007,7 @@ </sequence> </normal_column> <normal_column> - <word_id>13</word_id> + <word_id>14</word_id> <id>279</id> <description></description> <unique_key_name></unique_key_name> @@ -14871,7 +15040,7 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> + <word_id>218</word_id> <id>280</id> <description></description> <unique_key_name></unique_key_name> @@ -14972,7 +15141,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>91</word_id> <id>283</id> <description></description> <unique_key_name></unique_key_name> @@ -15005,7 +15174,7 @@ </sequence> </normal_column> <normal_column> - <word_id>83</word_id> + <word_id>89</word_id> <id>284</id> <description></description> <unique_key_name></unique_key_name> @@ -15097,6 +15266,14 @@ <referenced_column>327</referenced_column> <referenced_column>327</referenced_column> <referenced_column>327</referenced_column> + <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> <relation>15</relation> <relation>15</relation> <relation>15</relation> @@ -15132,7 +15309,7 @@ </sequence> </normal_column> <normal_column> - <word_id>163</word_id> + <word_id>170</word_id> <id>286</id> <description></description> <unique_key_name></unique_key_name> @@ -15165,7 +15342,7 @@ </sequence> </normal_column> <normal_column> - <word_id>164</word_id> + <word_id>171</word_id> <id>287</id> <description></description> <unique_key_name></unique_key_name> @@ -15198,7 +15375,7 @@ </sequence> </normal_column> <normal_column> - <word_id>48</word_id> + <word_id>54</word_id> <id>288</id> <description></description> <unique_key_name></unique_key_name> @@ -15231,7 +15408,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>91</word_id> <id>289</id> <description></description> <unique_key_name></unique_key_name> @@ -15264,7 +15441,7 @@ </sequence> </normal_column> <normal_column> - <word_id>83</word_id> + <word_id>89</word_id> <id>290</id> <description></description> <unique_key_name></unique_key_name> @@ -15297,7 +15474,7 @@ </sequence> </normal_column> <normal_column> - <word_id>106</word_id> + <word_id>112</word_id> <id>291</id> <description></description> <unique_key_name></unique_key_name> @@ -15330,7 +15507,7 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> + <word_id>114</word_id> <id>292</id> <description></description> <unique_key_name></unique_key_name> @@ -15395,7 +15572,7 @@ <option></option> <columns> <normal_column> - <word_id>174</word_id> + <word_id>181</word_id> <id>293</id> <description></description> <unique_key_name></unique_key_name> @@ -15428,7 +15605,7 @@ </sequence> </normal_column> <normal_column> - <word_id>177</word_id> + <word_id>184</word_id> <id>294</id> <description></description> <unique_key_name></unique_key_name> @@ -15461,7 +15638,7 @@ </sequence> </normal_column> <normal_column> - <word_id>178</word_id> + <word_id>185</word_id> <id>295</id> <description></description> <unique_key_name></unique_key_name> @@ -15494,7 +15671,7 @@ </sequence> </normal_column> <normal_column> - <word_id>176</word_id> + <word_id>183</word_id> <id>296</id> <description></description> <unique_key_name></unique_key_name> @@ -15527,7 +15704,7 @@ </sequence> </normal_column> <normal_column> - <word_id>180</word_id> + <word_id>187</word_id> <id>297</id> <description></description> <unique_key_name></unique_key_name> @@ -15560,7 +15737,7 @@ </sequence> </normal_column> <normal_column> - <word_id>179</word_id> + <word_id>186</word_id> <id>298</id> <description></description> <unique_key_name></unique_key_name> @@ -15593,7 +15770,7 @@ </sequence> </normal_column> <normal_column> - <word_id>175</word_id> + <word_id>182</word_id> <id>299</id> <description></description> <unique_key_name></unique_key_name> @@ -15790,7 +15967,7 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> + <word_id>179</word_id> <id>304</id> <description></description> <unique_key_name></unique_key_name> @@ -15823,7 +16000,7 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> + <word_id>80</word_id> <id>305</id> <description></description> <unique_key_name></unique_key_name> @@ -15922,7 +16099,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>308</id> <description></description> <unique_key_name></unique_key_name> @@ -15955,7 +16132,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>309</id> <description></description> <unique_key_name></unique_key_name> @@ -15988,7 +16165,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>310</id> <description></description> <unique_key_name></unique_key_name> @@ -16021,7 +16198,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>311</id> <description></description> <unique_key_name></unique_key_name> @@ -16054,7 +16231,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>312</id> <description></description> <unique_key_name></unique_key_name> @@ -16153,7 +16330,7 @@ </sequence> </normal_column> <normal_column> - <word_id>190</word_id> + <word_id>197</word_id> <id>315</id> <description></description> <unique_key_name></unique_key_name> @@ -16252,7 +16429,7 @@ </sequence> </normal_column> <normal_column> - <word_id>49</word_id> + <word_id>55</word_id> <id>318</id> <description></description> <unique_key_name></unique_key_name> @@ -16373,7 +16550,7 @@ </sequence> </normal_column> <normal_column> - <word_id>198</word_id> + <word_id>208</word_id> <id>320</id> <description></description> <unique_key_name></unique_key_name> @@ -16406,7 +16583,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>224</word_id> <id>321</id> <description></description> <unique_key_name></unique_key_name> @@ -16439,7 +16616,7 @@ </sequence> </normal_column> <normal_column> - <word_id>170</word_id> + <word_id>177</word_id> <id>322</id> <description></description> <unique_key_name></unique_key_name> @@ -16472,7 +16649,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>92</word_id> <id>323</id> <description></description> <unique_key_name></unique_key_name> @@ -16505,7 +16682,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>90</word_id> <id>324</id> <description></description> <unique_key_name></unique_key_name> @@ -16538,7 +16715,7 @@ </sequence> </normal_column> <normal_column> - <word_id>105</word_id> + <word_id>113</word_id> <id>325</id> <description></description> <unique_key_name></unique_key_name> @@ -16571,7 +16748,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>115</word_id> <id>326</id> <description></description> <unique_key_name></unique_key_name> @@ -16676,7 +16853,7 @@ <option></option> <columns> <normal_column> - <word_id>125</word_id> + <word_id>132</word_id> <id>327</id> <description></description> <unique_key_name></unique_key_name> @@ -16743,7 +16920,7 @@ </sequence> </normal_column> <normal_column> - <word_id>124</word_id> + <word_id>131</word_id> <id>329</id> <description></description> <unique_key_name></unique_key_name> @@ -16776,7 +16953,7 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> + <word_id>133</word_id> <id>330</id> <description></description> <unique_key_name></unique_key_name> @@ -16809,7 +16986,7 @@ </sequence> </normal_column> <normal_column> - <word_id>122</word_id> + <word_id>129</word_id> <id>331</id> <description></description> <unique_key_name></unique_key_name> @@ -16842,7 +17019,7 @@ </sequence> </normal_column> <normal_column> - <word_id>171</word_id> + <word_id>178</word_id> <id>332</id> <description></description> <unique_key_name></unique_key_name> @@ -16875,7 +17052,7 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> + <word_id>169</word_id> <id>333</id> <description></description> <unique_key_name></unique_key_name> @@ -16908,7 +17085,7 @@ </sequence> </normal_column> <normal_column> - <word_id>123</word_id> + <word_id>130</word_id> <id>334</id> <description></description> <unique_key_name></unique_key_name> @@ -16941,7 +17118,7 @@ </sequence> </normal_column> <normal_column> - <word_id>215</word_id> + <word_id>225</word_id> <id>335</id> <description></description> <unique_key_name></unique_key_name> @@ -16974,7 +17151,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>91</word_id> <id>336</id> <description></description> <unique_key_name></unique_key_name> @@ -17007,7 +17184,7 @@ </sequence> </normal_column> <normal_column> - <word_id>83</word_id> + <word_id>89</word_id> <id>337</id> <description></description> <unique_key_name></unique_key_name> @@ -17040,7 +17217,7 @@ </sequence> </normal_column> <normal_column> - <word_id>106</word_id> + <word_id>112</word_id> <id>338</id> <description></description> <unique_key_name></unique_key_name> @@ -17073,7 +17250,7 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> + <word_id>114</word_id> <id>339</id> <description></description> <unique_key_name></unique_key_name> @@ -17115,6 +17292,368 @@ <without_oids>true</without_oids> </table_properties> </table> + <table> + <id>35</id> + <height>254</height> + <width>244</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>584</x> + <y>445</y> + <color> + <r>255</r> + <g>128</g> + <b>255</b> + </color> + <connections> + </connections> + <physical_name>comtnsysteminfo</physical_name> + <logical_name>시스템정보</logical_name> + <description></description> + <constraint></constraint> + <primary_key_name>PK_comtnsysteminfo</primary_key_name> + <option></option> + <columns> + <normal_column> + <word_id>205</word_id> + <id>340</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>206</word_id> + <id>341</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>47</word_id> + <id>342</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>44</word_id> + <id>343</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <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>48</word_id> + <id>344</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>46</word_id> + <id>345</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <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>43</word_id> + <id>346</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>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>45</word_id> + <id>347</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>107</word_id> + <id>348</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>char</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>true</not_null> + <primary_key>false</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>203</word_id> + <id>349</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> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> </contents> <column_groups> </column_groups>

Add a comment

List

Delete comment