Index: base3.10/script/postgres.erm =================================================================== --- base3.10/script/postgres.erm (revision 95) +++ base3.10/script/postgres.erm (revision 96) @@ -11,8 +11,8 @@ </page_setting> <category_index>0</category_index> <zoom>1.0</zoom> - <x>0</x> - <y>854</y> + <x>1831</x> + <y>635</y> <default_color> <r>255</r> <g>128</g> @@ -33,7 +33,7 @@ <notation_level>5</notation_level> <notation_expand_group>true</notation_expand_group> <view_mode>2</view_mode> - <outline_view_mode>2</outline_view_mode> + <outline_view_mode>1</outline_view_mode> <view_order_by>1</view_order_by> <auto_ime_change>false</auto_ime_change> <validate_physical_name>true</validate_physical_name> @@ -130,7 +130,7 @@ <selected>true</selected> <node_element>11</node_element> <node_element>15</node_element> - <node_element>33</node_element> + <node_element>32</node_element> </category> <category> <id>35</id> @@ -174,10 +174,10 @@ <node_element>20</node_element> <node_element>8</node_element> <node_element>3</node_element> - <node_element>29</node_element> <node_element>28</node_element> - <node_element>32</node_element> <node_element>27</node_element> + <node_element>31</node_element> + <node_element>26</node_element> </category> <category> <id>37</id> @@ -231,8 +231,8 @@ </category> <category> <id>39</id> - <height>1081</height> - <width>1044</width> + <height>1041</height> + <width>1296</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> <x>1836</x> @@ -246,10 +246,10 @@ </connections> <name>게시판</name> <selected>true</selected> + <node_element>29</node_element> <node_element>30</node_element> - <node_element>31</node_element> <node_element>23</node_element> - <node_element>26</node_element> + <node_element>33</node_element> <node_element>7</node_element> <node_element>25</node_element> </category> @@ -277,7 +277,7 @@ </connections> <display>false</display> <creation_date>2022-01-26 16:20:32</creation_date> - <updated_date>2022-02-17 11:34:49</updated_date> + <updated_date>2022-02-17 17:11:20</updated_date> <model_property> <name>프로젝트명</name> <value></value> @@ -3225,6 +3225,22 @@ </word> <word> <id>182</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>대표 첨부파일ID</description> + <logical_name>대표 첨부파일ID</logical_name> + <physical_name>rprs_atch_file_id</physical_name> + <type>text</type> + </word> + <word> + <id>183</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3240,7 +3256,7 @@ <type>varchar(n)</type> </word> <word> - <id>183</id> + <id>184</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3256,7 +3272,7 @@ <type>varchar(n)</type> </word> <word> - <id>184</id> + <id>185</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -3272,7 +3288,7 @@ <type>varchar(n)</type> </word> <word> - <id>185</id> + <id>186</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -3288,7 +3304,7 @@ <type>character(n)</type> </word> <word> - <id>186</id> + <id>187</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3304,7 +3320,7 @@ <type>timestamp</type> </word> <word> - <id>187</id> + <id>188</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3320,7 +3336,7 @@ <type>varchar(n)</type> </word> <word> - <id>188</id> + <id>189</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3336,7 +3352,7 @@ <type>char</type> </word> <word> - <id>189</id> + <id>190</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3352,7 +3368,7 @@ <type>char</type> </word> <word> - <id>190</id> + <id>191</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3368,7 +3384,7 @@ <type>char</type> </word> <word> - <id>191</id> + <id>192</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3384,7 +3400,7 @@ <type>text</type> </word> <word> - <id>192</id> + <id>193</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3400,7 +3416,7 @@ <type>numeric(p)</type> </word> <word> - <id>193</id> + <id>194</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3416,7 +3432,7 @@ <type>char</type> </word> <word> - <id>194</id> + <id>195</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3432,7 +3448,7 @@ <type>varchar(n)</type> </word> <word> - <id>195</id> + <id>196</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3448,7 +3464,7 @@ <type>varchar(n)</type> </word> <word> - <id>196</id> + <id>197</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3464,7 +3480,7 @@ <type>text</type> </word> <word> - <id>197</id> + <id>198</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3480,7 +3496,7 @@ <type>text</type> </word> <word> - <id>198</id> + <id>199</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3496,7 +3512,7 @@ <type>numeric(p)</type> </word> <word> - <id>199</id> + <id>200</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -3512,7 +3528,7 @@ <type>varchar(n)</type> </word> <word> - <id>200</id> + <id>201</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3528,7 +3544,7 @@ <type>varchar(n)</type> </word> <word> - <id>201</id> + <id>202</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3544,7 +3560,7 @@ <type>character(n)</type> </word> <word> - <id>202</id> + <id>203</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3560,7 +3576,7 @@ <type>varchar(n)</type> </word> <word> - <id>203</id> + <id>204</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3576,7 +3592,7 @@ <type>numeric(p)</type> </word> <word> - <id>204</id> + <id>205</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3592,7 +3608,7 @@ <type>numeric(p)</type> </word> <word> - <id>205</id> + <id>206</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3608,7 +3624,7 @@ <type>timestamp</type> </word> <word> - <id>206</id> + <id>207</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3624,7 +3640,7 @@ <type>varchar(n)</type> </word> <word> - <id>207</id> + <id>208</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3640,7 +3656,7 @@ <type>text</type> </word> <word> - <id>208</id> + <id>209</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3656,7 +3672,7 @@ <type>varchar(n)</type> </word> <word> - <id>209</id> + <id>210</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3672,7 +3688,7 @@ <type>varchar(n)</type> </word> <word> - <id>210</id> + <id>211</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3688,7 +3704,7 @@ <type>varchar(n)</type> </word> <word> - <id>211</id> + <id>212</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3704,7 +3720,7 @@ <type>varchar(n)</type> </word> <word> - <id>212</id> + <id>213</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3720,7 +3736,7 @@ <type>varchar(n)</type> </word> <word> - <id>213</id> + <id>214</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3736,7 +3752,7 @@ <type>varchar(n)</type> </word> <word> - <id>214</id> + <id>215</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3752,7 +3768,7 @@ <type>varchar(n)</type> </word> <word> - <id>215</id> + <id>216</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3768,7 +3784,7 @@ <type></type> </word> <word> - <id>216</id> + <id>217</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3784,7 +3800,7 @@ <type>varchar(n)</type> </word> <word> - <id>217</id> + <id>218</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3800,7 +3816,7 @@ <type>char</type> </word> <word> - <id>218</id> + <id>219</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -3816,7 +3832,7 @@ <type>varchar(n)</type> </word> <word> - <id>219</id> + <id>220</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3832,7 +3848,7 @@ <type>varchar(n)</type> </word> <word> - <id>220</id> + <id>221</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3848,7 +3864,7 @@ <type>varchar(n)</type> </word> <word> - <id>221</id> + <id>222</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3888,7 +3904,7 @@ <sql>SELECT comtngnrlmber.esntl_id,&#x0D;&#x0A; comtngnrlmber.mber_id AS user_id,&#x0D;&#x0A; comtngnrlmber.password,&#x0D;&#x0A; comtngnrlmber.mber_nm AS user_nm,&#x0D;&#x0A; comtngnrlmber.zip AS user_zip,&#x0D;&#x0A; comtngnrlmber.adres AS user_adres,&#x0D;&#x0A; comtngnrlmber.mber_email_adres AS user_email,&#x0D;&#x0A; &apos; &apos;::bpchar AS group_id,&#x0D;&#x0A; &apos;GNR&apos;::text AS user_se,&#x0D;&#x0A; &apos; &apos;::bpchar AS orgnzt_id&#x0D;&#x0A; FROM comtngnrlmber&#x0D;&#x0A;UNION ALL&#x0D;&#x0A; SELECT comtnemplyrinfo.esntl_id,&#x0D;&#x0A; comtnemplyrinfo.emplyr_id AS user_id,&#x0D;&#x0A; comtnemplyrinfo.password,&#x0D;&#x0A; comtnemplyrinfo.user_nm,&#x0D;&#x0A; comtnemplyrinfo.zip AS user_zip,&#x0D;&#x0A; comtnemplyrinfo.house_adres AS user_adres,&#x0D;&#x0A; comtnemplyrinfo.email_adres AS user_email,&#x0D;&#x0A; comtnemplyrinfo.group_id,&#x0D;&#x0A; &apos;USR&apos;::text AS user_se,&#x0D;&#x0A; comtnemplyrinfo.orgnzt_id&#x0D;&#x0A; FROM comtnemplyrinfo&#x0D;&#x0A;UNION ALL&#x0D;&#x0A; SELECT comtnentrprsmber.esntl_id,&#x0D;&#x0A; comtnentrprsmber.entrprs_mber_id AS user_id,&#x0D;&#x0A; comtnentrprsmber.entrprs_mber_password AS password,&#x0D;&#x0A; comtnentrprsmber.cmpny_nm AS user_nm,&#x0D;&#x0A; comtnentrprsmber.zip AS user_zip,&#x0D;&#x0A; comtnentrprsmber.adres AS user_adres,&#x0D;&#x0A; comtnentrprsmber.applcnt_email_adres AS user_email,&#x0D;&#x0A; &apos; &apos;::bpchar AS group_id,&#x0D;&#x0A; &apos;ENT&apos;::text AS user_se,&#x0D;&#x0A; &apos; &apos;::bpchar AS orgnzt_id&#x0D;&#x0A; FROM comtnentrprsmber&#x0D;&#x0A; ORDER BY 1;</sql> <columns> <normal_column> - <word_id>79</word_id> + <word_id>78</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -3921,7 +3937,7 @@ </sequence> </normal_column> <normal_column> - <word_id>212</word_id> + <word_id>213</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -3954,7 +3970,7 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> + <word_id>157</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -3987,7 +4003,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>215</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4020,7 +4036,7 @@ </sequence> </normal_column> <normal_column> - <word_id>216</word_id> + <word_id>217</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4053,7 +4069,7 @@ </sequence> </normal_column> <normal_column> - <word_id>209</word_id> + <word_id>210</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4086,7 +4102,7 @@ </sequence> </normal_column> <normal_column> - <word_id>210</word_id> + <word_id>211</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4152,7 +4168,7 @@ </sequence> </normal_column> <normal_column> - <word_id>215</word_id> + <word_id>216</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4245,7 +4261,7 @@ <option></option> <columns> <normal_column> - <word_id>143</word_id> + <word_id>144</word_id> <id>0</id> <description></description> <unique_key_name></unique_key_name> @@ -4278,7 +4294,7 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> + <word_id>209</word_id> <id>1</id> <description></description> <unique_key_name></unique_key_name> @@ -4376,7 +4392,7 @@ <option></option> <columns> <normal_column> - <word_id>143</word_id> + <word_id>144</word_id> <id>3</id> <description></description> <unique_key_name></unique_key_name> @@ -4409,7 +4425,7 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> + <word_id>196</word_id> <id>4</id> <description></description> <unique_key_name></unique_key_name> @@ -4508,7 +4524,7 @@ </sequence> </normal_column> <normal_column> - <word_id>204</word_id> + <word_id>205</word_id> <id>7</id> <description></description> <unique_key_name></unique_key_name> @@ -4607,7 +4623,7 @@ </sequence> </normal_column> <normal_column> - <word_id>154</word_id> + <word_id>153</word_id> <id>10</id> <description></description> <unique_key_name></unique_key_name> @@ -4709,10 +4725,10 @@ <g>0</g> <b>0</b> </color> - <child_cardinality>1..n</child_cardinality> + <child_cardinality>1</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnroles_hierarchy_chldrn_role_fkey</name> + <name>comtnroles_hierarchy_parnts_role_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -4731,10 +4747,10 @@ <g>0</g> <b>0</b> </color> - <child_cardinality>1</child_cardinality> + <child_cardinality>1..n</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnroles_hierarchy_parnts_role_fkey</name> + <name>comtnroles_hierarchy_chldrn_role_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -4751,7 +4767,7 @@ <normal_column> <id>12</id> <referenced_column>86</referenced_column> - <relation>1</relation> + <relation>0</relation> <description>부모롤</description> <unique_key_name></unique_key_name> <logical_name>부모롤</logical_name> @@ -4785,7 +4801,7 @@ <normal_column> <id>13</id> <referenced_column>86</referenced_column> - <relation>0</relation> + <relation>1</relation> <description>자식롤</description> <unique_key_name></unique_key_name> <logical_name>자식롤</logical_name> @@ -5213,7 +5229,7 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> + <word_id>222</word_id> <id>23</id> <description></description> <unique_key_name></unique_key_name> @@ -5444,7 +5460,7 @@ </sequence> </normal_column> <normal_column> - <word_id>186</word_id> + <word_id>187</word_id> <id>30</id> <description></description> <unique_key_name></unique_key_name> @@ -5775,7 +5791,7 @@ </sequence> </normal_column> <normal_column> - <word_id>78</word_id> + <word_id>79</word_id> <id>40</id> <description></description> <unique_key_name></unique_key_name> @@ -6096,7 +6112,7 @@ </sequence> </normal_column> <normal_column> - <word_id>213</word_id> + <word_id>214</word_id> <id>47</id> <description></description> <unique_key_name></unique_key_name> @@ -6129,7 +6145,7 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> + <word_id>156</word_id> <id>48</id> <description></description> <unique_key_name></unique_key_name> @@ -6228,7 +6244,7 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> + <word_id>190</word_id> <id>51</id> <description></description> <unique_key_name></unique_key_name> @@ -6525,7 +6541,7 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> + <word_id>222</word_id> <id>60</id> <description></description> <unique_key_name></unique_key_name> @@ -6823,7 +6839,7 @@ </sequence> </normal_column> <normal_column> - <word_id>78</word_id> + <word_id>79</word_id> <id>69</id> <description></description> <unique_key_name></unique_key_name> @@ -6889,7 +6905,7 @@ </sequence> </normal_column> <normal_column> - <word_id>186</word_id> + <word_id>187</word_id> <id>71</id> <description></description> <unique_key_name></unique_key_name> @@ -7178,7 +7194,7 @@ </sequence> </normal_column> <normal_column> - <word_id>193</word_id> + <word_id>194</word_id> <id>78</id> <description></description> <unique_key_name></unique_key_name> @@ -7211,7 +7227,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>87</word_id> <id>79</id> <description></description> <unique_key_name></unique_key_name> @@ -7244,7 +7260,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>80</id> <description></description> <unique_key_name></unique_key_name> @@ -7368,7 +7384,7 @@ <connections> <relation> <id>5</id> - <source>29</source> + <source>28</source> <target>8</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -7454,7 +7470,7 @@ </normal_column> <normal_column> <id>84</id> - <referenced_column>282</referenced_column> + <referenced_column>257</referenced_column> <relation>5</relation> <description></description> <unique_key_name></unique_key_name> @@ -7578,7 +7594,7 @@ <option></option> <columns> <normal_column> - <word_id>13</word_id> + <word_id>14</word_id> <id>86</id> <description></description> <unique_key_name></unique_key_name> @@ -7906,7 +7922,7 @@ <option></option> <columns> <normal_column> - <word_id>200</word_id> + <word_id>201</word_id> <id>94</id> <description></description> <unique_key_name></unique_key_name> @@ -8159,7 +8175,7 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>218</word_id> <id>100</id> <description></description> <unique_key_name></unique_key_name> @@ -8192,7 +8208,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>87</word_id> <id>101</id> <description></description> <unique_key_name></unique_key_name> @@ -8258,7 +8274,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>103</id> <description></description> <unique_key_name></unique_key_name> @@ -8490,7 +8506,7 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>218</word_id> <id>108</id> <description></description> <unique_key_name></unique_key_name> @@ -8557,7 +8573,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>87</word_id> <id>110</id> <description></description> <unique_key_name></unique_key_name> @@ -8623,7 +8639,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>112</id> <description></description> <unique_key_name></unique_key_name> @@ -8800,7 +8816,7 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> + <word_id>209</word_id> <id>116</id> <description></description> <unique_key_name></unique_key_name> @@ -8833,7 +8849,7 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> + <word_id>183</word_id> <id>117</id> <description></description> <unique_key_name></unique_key_name> @@ -8866,7 +8882,7 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> + <word_id>185</word_id> <id>118</id> <description></description> <unique_key_name></unique_key_name> @@ -9128,7 +9144,7 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>218</word_id> <id>124</id> <description></description> <unique_key_name></unique_key_name> @@ -9161,7 +9177,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>87</word_id> <id>125</id> <description></description> <unique_key_name></unique_key_name> @@ -9227,7 +9243,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>127</id> <description></description> <unique_key_name></unique_key_name> @@ -9380,7 +9396,7 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> + <word_id>156</word_id> <id>130</id> <description></description> <unique_key_name></unique_key_name> @@ -9545,7 +9561,7 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> + <word_id>222</word_id> <id>135</id> <description></description> <unique_key_name></unique_key_name> @@ -9909,7 +9925,7 @@ </sequence> </normal_column> <normal_column> - <word_id>186</word_id> + <word_id>187</word_id> <id>146</id> <description></description> <unique_key_name></unique_key_name> @@ -9942,7 +9958,7 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> + <word_id>190</word_id> <id>147</id> <description></description> <unique_key_name></unique_key_name> @@ -9975,7 +9991,7 @@ </sequence> </normal_column> <normal_column> - <word_id>78</word_id> + <word_id>79</word_id> <id>148</id> <description></description> <unique_key_name></unique_key_name> @@ -10613,7 +10629,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>87</word_id> <id>165</id> <description></description> <unique_key_name></unique_key_name> @@ -10679,7 +10695,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>167</id> <description></description> <unique_key_name></unique_key_name> @@ -10744,7 +10760,7 @@ <option></option> <columns> <normal_column> - <word_id>187</word_id> + <word_id>188</word_id> <id>168</id> <description></description> <unique_key_name></unique_key_name> @@ -10810,7 +10826,7 @@ </sequence> </normal_column> <normal_column> - <word_id>13</word_id> + <word_id>14</word_id> <id>170</id> <description></description> <unique_key_name></unique_key_name> @@ -11076,7 +11092,7 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> + <word_id>190</word_id> <id>176</id> <description></description> <unique_key_name></unique_key_name> @@ -11307,7 +11323,7 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> + <word_id>222</word_id> <id>183</id> <description></description> <unique_key_name></unique_key_name> @@ -11538,7 +11554,7 @@ </sequence> </normal_column> <normal_column> - <word_id>78</word_id> + <word_id>79</word_id> <id>190</id> <description></description> <unique_key_name></unique_key_name> @@ -11748,7 +11764,7 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> + <word_id>185</word_id> <id>195</id> <description></description> <unique_key_name></unique_key_name> @@ -11781,7 +11797,7 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> + <word_id>183</word_id> <id>196</id> <description></description> <unique_key_name></unique_key_name> @@ -11814,7 +11830,7 @@ </sequence> </normal_column> <normal_column> - <word_id>202</word_id> + <word_id>203</word_id> <id>197</id> <description></description> <unique_key_name></unique_key_name> @@ -11847,7 +11863,7 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> + <word_id>196</word_id> <id>198</id> <description></description> <unique_key_name></unique_key_name> @@ -12012,7 +12028,7 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> + <word_id>186</word_id> <id>203</id> <description></description> <unique_key_name></unique_key_name> @@ -12169,7 +12185,7 @@ <connections> <relation> <id>11</id> - <source>26</source> + <source>33</source> <target>23</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -12199,7 +12215,7 @@ <columns> <normal_column> <id>207</id> - <referenced_column>242</referenced_column> + <referenced_column>314</referenced_column> <relation>11</relation> <description></description> <unique_key_name></unique_key_name> @@ -12233,7 +12249,7 @@ </normal_column> <normal_column> <id>208</id> - <referenced_column>243</referenced_column> + <referenced_column>315</referenced_column> <relation>11</relation> <description></description> <unique_key_name></unique_key_name> @@ -12299,7 +12315,7 @@ </sequence> </normal_column> <normal_column> - <word_id>219</word_id> + <word_id>220</word_id> <id>210</id> <description></description> <unique_key_name></unique_key_name> @@ -12332,7 +12348,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>221</word_id> <id>211</id> <description></description> <unique_key_name></unique_key_name> @@ -12398,7 +12414,7 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>218</word_id> <id>213</id> <description></description> <unique_key_name></unique_key_name> @@ -12431,7 +12447,7 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>87</word_id> <id>214</id> <description></description> <unique_key_name></unique_key_name> @@ -12497,7 +12513,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>216</id> <description></description> <unique_key_name></unique_key_name> @@ -12563,7 +12579,7 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> + <word_id>156</word_id> <id>218</id> <description></description> <unique_key_name></unique_key_name> @@ -12645,7 +12661,7 @@ <option></option> <columns> <normal_column> - <word_id>144</word_id> + <word_id>143</word_id> <id>219</id> <description></description> <unique_key_name></unique_key_name> @@ -12678,7 +12694,7 @@ </sequence> </normal_column> <normal_column> - <word_id>183</word_id> + <word_id>184</word_id> <id>220</id> <description></description> <unique_key_name></unique_key_name> @@ -12711,7 +12727,7 @@ </sequence> </normal_column> <normal_column> - <word_id>194</word_id> + <word_id>195</word_id> <id>221</id> <description></description> <unique_key_name></unique_key_name> @@ -12810,7 +12826,7 @@ </sequence> </normal_column> <normal_column> - <word_id>203</word_id> + <word_id>204</word_id> <id>224</id> <description></description> <unique_key_name></unique_key_name> @@ -12909,7 +12925,7 @@ </sequence> </normal_column> <normal_column> - <word_id>153</word_id> + <word_id>154</word_id> <id>227</id> <description></description> <unique_key_name></unique_key_name> @@ -13139,7 +13155,7 @@ </sequence> </normal_column> <normal_column> - <word_id>197</word_id> + <word_id>198</word_id> <id>233</id> <description></description> <unique_key_name></unique_key_name> @@ -13172,7 +13188,7 @@ </sequence> </normal_column> <normal_column> - <word_id>207</word_id> + <word_id>208</word_id> <id>234</id> <description></description> <unique_key_name></unique_key_name> @@ -13370,7 +13386,7 @@ </sequence> </normal_column> <normal_column> - <word_id>206</word_id> + <word_id>207</word_id> <id>240</id> <description></description> <unique_key_name></unique_key_name> @@ -13403,7 +13419,7 @@ </sequence> </normal_column> <normal_column> - <word_id>205</word_id> + <word_id>206</word_id> <id>241</id> <description></description> <unique_key_name></unique_key_name> @@ -13447,21 +13463,21 @@ </table> <table> <id>26</id> - <height>569</height> - <width>133</width> + <height>191</height> + <width>246</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>2303</x> - <y>1006</y> + <x>1248</x> + <y>2659</y> <color> - <r>128</r> + <r>255</r> <g>128</g> - <b>192</b> + <b>255</b> </color> <connections> <relation> <id>12</id> - <source>30</source> + <source>27</source> <target>26</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -13473,30 +13489,30 @@ <b>0</b> </color> <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> + <parent_cardinality>0..1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnbbs_bbs_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> + <name>FK_tnmenuprograminfo_TO_tnmenuauthoinfo</name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>CASCADE</on_update_action> <referenced_column>null</referenced_column> <referenced_complex_unique_key>null</referenced_complex_unique_key> </relation> </connections> - <physical_name>comtnbbs</physical_name> - <logical_name>게시판</logical_name> - <description>게시판</description> + <physical_name>tnmenuauthoinfo</physical_name> + <logical_name>메뉴권한정보</logical_name> + <description>메뉴권한정보</description> <constraint></constraint> - <primary_key_name>comtnbbs_pkey</primary_key_name> + <primary_key_name>PK_tnmenuauthoinfo</primary_key_name> <option></option> <columns> <normal_column> - <word_id>140</word_id> + <word_id>18</word_id> <id>242</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13523,50 +13539,19 @@ </sequence> </normal_column> <normal_column> + <word_id>13</word_id> <id>243</id> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <referenced_column>289</referenced_column> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> - <relation>12</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13587,13 +13572,13 @@ </sequence> </normal_column> <normal_column> - <word_id>141</word_id> + <word_id>212</word_id> <id>244</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13620,8 +13605,9 @@ </sequence> </normal_column> <normal_column> - <word_id>142</word_id> <id>245</id> + <referenced_column>249</referenced_column> + <relation>12</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -13630,7 +13616,7 @@ <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -13653,17 +13639,18 @@ </sequence> </normal_column> <normal_column> - <word_id>139</word_id> <id>246</id> + <referenced_column>250</referenced_column> + <relation>12</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> + <foreign_key>true</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -13686,13 +13673,13 @@ </sequence> </normal_column> <normal_column> - <word_id>2</word_id> + <word_id>86</word_id> <id>247</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13719,13 +13706,13 @@ </sequence> </normal_column> <normal_column> - <word_id>155</word_id> + <word_id>84</word_id> <id>248</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13751,20 +13738,137 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>27</id> + <height>212</height> + <width>276</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>912</x> + <y>2649</y> + <color> + <r>255</r> + <g>128</g> + <b>255</b> + </color> + <connections> + <relation> + <id>13</id> + <source>31</source> + <target>27</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>FK_tnmenuinfo_TO_tnmenuprograminfo</name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>CASCADE</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>tnmenuprograminfo</physical_name> + <logical_name>메뉴프로그램정보</logical_name> + <description>메뉴프로그램정보</description> + <constraint></constraint> + <primary_key_name>PK_tnmenuprograminfo</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>3</word_id> <id>249</id> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <referenced_column>291</referenced_column> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> + <relation>13</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13785,19 +13889,19 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> + <word_id>164</word_id> <id>250</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -13818,13 +13922,13 @@ </sequence> </normal_column> <normal_column> - <word_id>167</word_id> + <word_id>165</word_id> <id>251</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13851,18 +13955,18 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>54</word_id> <id>252</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> - <default_value></default_value> + <default_value>&apos;Y&apos;::character varying</default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -13884,13 +13988,13 @@ </sequence> </normal_column> <normal_column> - <word_id>135</word_id> + <word_id>86</word_id> <id>253</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13917,13 +14021,13 @@ </sequence> </normal_column> <normal_column> - <word_id>136</word_id> + <word_id>84</word_id> <id>254</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13950,13 +14054,13 @@ </sequence> </normal_column> <normal_column> - <word_id>137</word_id> + <word_id>108</word_id> <id>255</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -13983,7 +14087,7 @@ </sequence> </normal_column> <normal_column> - <word_id>138</word_id> + <word_id>110</word_id> <id>256</id> <description></description> <unique_key_name></unique_key_name> @@ -14015,8 +14119,40 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>28</id> + <height>191</height> + <width>129</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>80</x> + <y>2346</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnroleinfo</physical_name> + <logical_name>롤정보</logical_name> + <description>롤정보</description> + <constraint></constraint> + <primary_key_name>comtnroleinfo_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>157</word_id> + <word_id>175</word_id> <id>257</id> <description></description> <unique_key_name></unique_key_name> @@ -14027,8 +14163,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14049,18 +14185,18 @@ </sequence> </normal_column> <normal_column> - <word_id>10</word_id> + <word_id>178</word_id> <id>258</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -14082,13 +14218,13 @@ </sequence> </normal_column> <normal_column> - <word_id>134</word_id> + <word_id>179</word_id> <id>259</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14115,13 +14251,13 @@ </sequence> </normal_column> <normal_column> - <word_id>190</word_id> + <word_id>177</word_id> <id>260</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14148,13 +14284,13 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> + <word_id>181</word_id> <id>261</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14181,18 +14317,18 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>180</word_id> <id>262</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -14214,13 +14350,13 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>176</word_id> <id>263</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14246,20 +14382,52 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>29</id> + <height>-1</height> + <width>-1</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>1980</x> + <y>1040</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + </connections> + <physical_name>comtnbbsmaster</physical_name> + <logical_name>게시판마스터</logical_name> + <description>게시판마스터</description> + <constraint></constraint> + <primary_key_name>comtnbbsmaster_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>108</word_id> + <word_id>20</word_id> <id>264</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14280,7 +14448,7 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> + <word_id>22</word_id> <id>265</id> <description></description> <unique_key_name></unique_key_name> @@ -14291,7 +14459,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -14313,13 +14481,13 @@ </sequence> </normal_column> <normal_column> - <word_id>26</word_id> + <word_id>21</word_id> <id>266</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14345,87 +14513,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnbbs_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>243</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>27</id> - <height>191</height> - <width>246</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1248</x> - <y>2659</y> - <color> - <r>255</r> - <g>128</g> - <b>255</b> - </color> - <connections> - <relation> - <id>13</id> - <source>28</source> - <target>27</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>FK_tnmenuprograminfo_TO_tnmenuauthoinfo</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>CASCADE</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>tnmenuauthoinfo</physical_name> - <logical_name>메뉴권한정보</logical_name> - <description>메뉴권한정보</description> - <constraint></constraint> - <primary_key_name>PK_tnmenuauthoinfo</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>18</word_id> + <word_id>23</word_id> <id>267</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14446,13 +14547,13 @@ </sequence> </normal_column> <normal_column> - <word_id>14</word_id> + <word_id>173</word_id> <id>268</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14479,18 +14580,18 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> + <word_id>80</word_id> <id>269</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -14512,19 +14613,18 @@ </sequence> </normal_column> <normal_column> + <word_id>11</word_id> <id>270</id> - <referenced_column>274</referenced_column> - <relation>13</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> - <not_null>false</not_null> + <foreign_key>false</foreign_key> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -14546,18 +14646,17 @@ </sequence> </normal_column> <normal_column> + <word_id>12</word_id> <id>271</id> - <referenced_column>275</referenced_column> - <relation>13</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>false</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -14580,18 +14679,18 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> + <word_id>218</word_id> <id>272</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -14613,7 +14712,7 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>85</word_id> <id>273</id> <description></description> <unique_key_name></unique_key_name> @@ -14624,7 +14723,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -14645,105 +14744,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>28</id> - <height>212</height> - <width>276</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>912</x> - <y>2649</y> - <color> - <r>255</r> - <g>128</g> - <b>255</b> - </color> - <connections> - <relation> - <id>14</id> - <source>32</source> - <target>28</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>FK_tnmenuinfo_TO_tnmenuprograminfo</name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>CASCADE</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>tnmenuprograminfo</physical_name> - <logical_name>메뉴프로그램정보</logical_name> - <description>메뉴프로그램정보</description> - <constraint></constraint> - <primary_key_name>PK_tnmenuprograminfo</primary_key_name> - <option></option> - <columns> <normal_column> + <word_id>87</word_id> <id>274</id> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <referenced_column>316</referenced_column> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> - <relation>14</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14764,7 +14778,7 @@ </sequence> </normal_column> <normal_column> - <word_id>164</word_id> + <word_id>109</word_id> <id>275</id> <description></description> <unique_key_name></unique_key_name> @@ -14775,8 +14789,8 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -14797,13 +14811,13 @@ </sequence> </normal_column> <normal_column> - <word_id>165</word_id> + <word_id>107</word_id> <id>276</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14830,15 +14844,15 @@ </sequence> </normal_column> <normal_column> - <word_id>54</word_id> + <word_id>26</word_id> <id>277</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> - <default_value>&apos;Y&apos;::character varying</default_value> + <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>false</not_null> @@ -14863,13 +14877,13 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> + <word_id>25</word_id> <id>278</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14896,13 +14910,13 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>192</word_id> <id>279</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14929,13 +14943,13 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> + <word_id>5</word_id> <id>280</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -14962,13 +14976,46 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> + <word_id>19</word_id> <id>281</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>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>55</word_id> + <id>282</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15005,35 +15052,91 @@ </table_properties> </table> <table> - <id>29</id> - <height>191</height> - <width>129</width> + <id>30</id> + <height>212</height> + <width>133</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>80</x> - <y>2346</y> + <x>1991</x> + <y>1546</y> <color> <r>128</r> <g>128</g> <b>192</b> </color> <connections> + <relation> + <id>14</id> + <source>29</source> + <target>30</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnbbsuse_bbs_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> </connections> - <physical_name>comtnroleinfo</physical_name> - <logical_name>롤정보</logical_name> - <description>롤정보</description> + <physical_name>comtnbbsuse</physical_name> + <logical_name>게시판활용</logical_name> + <description>게시판활용</description> <constraint></constraint> - <primary_key_name>comtnroleinfo_pkey</primary_key_name> + <primary_key_name>comtnbbsuse_pkey</primary_key_name> <option></option> <columns> <normal_column> - <word_id>175</word_id> - <id>282</id> + <id>283</id> + <referenced_column>264</referenced_column> + <relation>14</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>202</word_id> + <id>284</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15060,13 +15163,13 @@ </sequence> </normal_column> <normal_column> - <word_id>178</word_id> - <id>283</id> + <word_id>218</word_id> + <id>285</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15093,13 +15196,13 @@ </sequence> </normal_column> <normal_column> - <word_id>179</word_id> - <id>284</id> + <word_id>171</word_id> + <id>286</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15126,13 +15229,13 @@ </sequence> </normal_column> <normal_column> - <word_id>177</word_id> - <id>285</id> + <word_id>87</word_id> + <id>287</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15159,8 +15262,8 @@ </sequence> </normal_column> <normal_column> - <word_id>181</word_id> - <id>286</id> + <word_id>85</word_id> + <id>288</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15170,7 +15273,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15192,13 +15295,13 @@ </sequence> </normal_column> <normal_column> - <word_id>180</word_id> - <id>287</id> + <word_id>107</word_id> + <id>289</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15225,18 +15328,18 @@ </sequence> </normal_column> <normal_column> - <word_id>176</word_id> - <id>288</id> + <word_id>109</word_id> + <id>290</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15259,6 +15362,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnbbsuse_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>283</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list> @@ -15268,35 +15384,62 @@ </table_properties> </table> <table> - <id>30</id> - <height>-1</height> - <width>-1</width> + <id>31</id> + <height>317</height> + <width>389</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1980</x> - <y>1040</y> + <x>876</x> + <y>2196</y> <color> - <r>128</r> + <r>255</r> <g>128</g> - <b>192</b> + <b>255</b> </color> <connections> + <relation> + <id>15</id> + <source>31</source> + <target>31</target> + <source_xp>100</source_xp> + <source_yp>84</source_yp> + <target_xp>73</target_xp> + <target_yp>100</target_yp> + <bendpoint> + <relative>true</relative> + <x>55</x> + <y>33</y> + </bendpoint> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>0..1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name></name> + <on_delete_action>CASCADE</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> </connections> - <physical_name>comtnbbsmaster</physical_name> - <logical_name>게시판마스터</logical_name> - <description>게시판마스터</description> + <physical_name>tnmenuinfo</physical_name> + <logical_name>메뉴정보</logical_name> + <description>메뉴정보</description> <constraint></constraint> - <primary_key_name>comtnbbsmaster_pkey</primary_key_name> + <primary_key_name>PK_tnmenuinfo</primary_key_name> <option></option> <columns> <normal_column> - <word_id>20</word_id> - <id>289</id> + <word_id>127</word_id> + <id>291</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15323,18 +15466,19 @@ </sequence> </normal_column> <normal_column> - <word_id>22</word_id> - <id>290</id> + <id>292</id> + <referenced_column>291</referenced_column> + <relation>15</relation> <description></description> <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> + <logical_name>상위메뉴번호</logical_name> + <physical_name>upper_menu_no</physical_name> <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> + <foreign_key>true</foreign_key> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15356,8 +15500,8 @@ </sequence> </normal_column> <normal_column> - <word_id>21</word_id> - <id>291</id> + <word_id>126</word_id> + <id>293</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -15389,46 +15533,13 @@ </sequence> </normal_column> <normal_column> - <word_id>23</word_id> - <id>292</id> + <word_id>128</word_id> + <id>294</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> - <constraint></constraint> - <default_value></default_value> - <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>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>173</word_id> - <id>293</id> - <description></description> - <unique_key_name></unique_key_name> - <logical_name></logical_name> - <physical_name></physical_name> - <type>char</type> + <type>integer</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15455,51 +15566,18 @@ </sequence> </normal_column> <normal_column> - <word_id>80</word_id> - <id>294</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>11</word_id> + <word_id>124</word_id> <id>295</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15521,13 +15599,13 @@ </sequence> </normal_column> <normal_column> - <word_id>12</word_id> + <word_id>172</word_id> <id>296</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15554,18 +15632,18 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>163</word_id> <id>297</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15587,7 +15665,7 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>125</word_id> <id>298</id> <description></description> <unique_key_name></unique_key_name> @@ -15598,7 +15676,7 @@ <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15620,18 +15698,18 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>219</word_id> <id>299</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15653,13 +15731,13 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> + <word_id>86</word_id> <id>300</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15686,13 +15764,13 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>84</word_id> <id>301</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15719,13 +15797,13 @@ </sequence> </normal_column> <normal_column> - <word_id>26</word_id> + <word_id>108</word_id> <id>302</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15752,13 +15830,13 @@ </sequence> </normal_column> <normal_column> - <word_id>25</word_id> + <word_id>110</word_id> <id>303</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15784,20 +15862,52 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>32</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>191</word_id> + <word_id>199</word_id> <id>304</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -15818,13 +15928,13 @@ </sequence> </normal_column> <normal_column> - <word_id>5</word_id> + <word_id>200</word_id> <id>305</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15851,13 +15961,13 @@ </sequence> </normal_column> <normal_column> - <word_id>19</word_id> + <word_id>47</word_id> <id>306</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>text</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -15884,18 +15994,18 @@ </sequence> </normal_column> <normal_column> - <word_id>55</word_id> + <word_id>44</word_id> <id>307</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -15916,75 +16026,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>31</id> - <height>212</height> - <width>133</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>1991</x> - <y>1546</y> - <color> - <r>128</r> - <g>128</g> - <b>192</b> - </color> - <connections> - <relation> - <id>15</id> - <source>30</source> - <target>31</target> - <source_xp>-1</source_xp> - <source_yp>-1</source_yp> - <target_xp>-1</target_xp> - <target_yp>-1</target_yp> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name>comtnbbsuse_bbs_id_fkey</name> - <on_delete_action>NO ACTION</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>comtnbbsuse</physical_name> - <logical_name>게시판활용</logical_name> - <description>게시판활용</description> - <constraint></constraint> - <primary_key_name>comtnbbsuse_pkey</primary_key_name> - <option></option> - <columns> <normal_column> + <word_id>48</word_id> <id>308</id> - <referenced_column>289</referenced_column> - <relation>15</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16005,19 +16060,19 @@ </sequence> </normal_column> <normal_column> - <word_id>201</word_id> + <word_id>46</word_id> <id>309</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> <not_null>true</not_null> - <primary_key>true</primary_key> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16038,13 +16093,13 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>43</word_id> <id>310</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16071,13 +16126,13 @@ </sequence> </normal_column> <normal_column> - <word_id>171</word_id> + <word_id>45</word_id> <id>311</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>character(n)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16104,18 +16159,18 @@ </sequence> </normal_column> <normal_column> - <word_id>86</word_id> + <word_id>102</word_id> <id>312</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -16137,18 +16192,18 @@ </sequence> </normal_column> <normal_column> - <word_id>85</word_id> + <word_id>197</word_id> <id>313</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -16169,20 +16224,74 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> + </columns> + <indexes> + </indexes> + <complex_unique_key_list> + </complex_unique_key_list> + <table_properties> + <schema>public</schema> + <without_oids>true</without_oids> + </table_properties> + </table> + <table> + <id>33</id> + <height>569</height> + <width>133</width> + <font_name>맑은 고딕</font_name> + <font_size>9</font_size> + <x>2303</x> + <y>1006</y> + <color> + <r>128</r> + <g>128</g> + <b>192</b> + </color> + <connections> + <relation> + <id>16</id> + <source>29</source> + <target>33</target> + <source_xp>-1</source_xp> + <source_yp>-1</source_yp> + <target_xp>-1</target_xp> + <target_yp>-1</target_yp> + <color> + <r>0</r> + <g>0</g> + <b>0</b> + </color> + <child_cardinality>1..n</child_cardinality> + <parent_cardinality>1</parent_cardinality> + <reference_for_pk>true</reference_for_pk> + <name>comtnbbs_bbs_id_fkey</name> + <on_delete_action>NO ACTION</on_delete_action> + <on_update_action>NO ACTION</on_update_action> + <referenced_column>null</referenced_column> + <referenced_complex_unique_key>null</referenced_complex_unique_key> + </relation> + </connections> + <physical_name>comtnbbs</physical_name> + <logical_name>게시판</logical_name> + <description>게시판</description> + <constraint></constraint> + <primary_key_name>comtnbbs_pkey</primary_key_name> + <option></option> + <columns> <normal_column> - <word_id>108</word_id> + <word_id>140</word_id> <id>314</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16203,19 +16312,82 @@ </sequence> </normal_column> <normal_column> - <word_id>109</word_id> <id>315</id> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <referenced_column>264</referenced_column> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>false</foreign_key> - <not_null>false</not_null> - <primary_key>false</primary_key> + <foreign_key>true</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16235,92 +16407,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - <inidex> - <full_text>false</full_text> - <non_unique>true</non_unique> - <name>comtnbbsuse_i01</name> - <type>BTREE</type> - <description></description> - <columns> - <column> - <id>308</id> - <desc>false</desc> - </column> - </columns> - </inidex> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>32</id> - <height>317</height> - <width>389</width> - <font_name>맑은 고딕</font_name> - <font_size>9</font_size> - <x>876</x> - <y>2196</y> - <color> - <r>255</r> - <g>128</g> - <b>255</b> - </color> - <connections> - <relation> - <id>16</id> - <source>32</source> - <target>32</target> - <source_xp>100</source_xp> - <source_yp>84</source_yp> - <target_xp>73</target_xp> - <target_yp>100</target_yp> - <bendpoint> - <relative>true</relative> - <x>55</x> - <y>33</y> - </bendpoint> - <color> - <r>0</r> - <g>0</g> - <b>0</b> - </color> - <child_cardinality>1..n</child_cardinality> - <parent_cardinality>0..1</parent_cardinality> - <reference_for_pk>true</reference_for_pk> - <name></name> - <on_delete_action>CASCADE</on_delete_action> - <on_update_action>NO ACTION</on_update_action> - <referenced_column>null</referenced_column> - <referenced_complex_unique_key>null</referenced_complex_unique_key> - </relation> - </connections> - <physical_name>tnmenuinfo</physical_name> - <logical_name>메뉴정보</logical_name> - <description>메뉴정보</description> - <constraint></constraint> - <primary_key_name>PK_tnmenuinfo</primary_key_name> - <option></option> - <columns> <normal_column> - <word_id>127</word_id> + <word_id>141</word_id> <id>316</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16341,18 +16441,17 @@ </sequence> </normal_column> <normal_column> + <word_id>142</word_id> <id>317</id> - <referenced_column>316</referenced_column> - <relation>16</relation> <description></description> <unique_key_name></unique_key_name> - <logical_name>상위메뉴번호</logical_name> - <physical_name>upper_menu_no</physical_name> + <logical_name></logical_name> + <physical_name></physical_name> <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> - <foreign_key>true</foreign_key> + <foreign_key>false</foreign_key> <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> @@ -16375,13 +16474,13 @@ </sequence> </normal_column> <normal_column> - <word_id>126</word_id> + <word_id>139</word_id> <id>318</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16408,13 +16507,13 @@ </sequence> </normal_column> <normal_column> - <word_id>128</word_id> + <word_id>2</word_id> <id>319</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>integer</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16441,13 +16540,13 @@ </sequence> </normal_column> <normal_column> - <word_id>124</word_id> + <word_id>155</word_id> <id>320</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16474,13 +16573,13 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> + <word_id>3</word_id> <id>321</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16507,13 +16606,13 @@ </sequence> </normal_column> <normal_column> - <word_id>163</word_id> + <word_id>193</word_id> <id>322</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16540,13 +16639,13 @@ </sequence> </normal_column> <normal_column> - <word_id>125</word_id> + <word_id>167</word_id> <id>323</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>numeric(p)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16579,12 +16678,12 @@ <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>false</not_null> + <not_null>true</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -16606,13 +16705,13 @@ </sequence> </normal_column> <normal_column> - <word_id>87</word_id> + <word_id>135</word_id> <id>325</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16639,13 +16738,13 @@ </sequence> </normal_column> <normal_column> - <word_id>84</word_id> + <word_id>136</word_id> <id>326</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>character(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16672,13 +16771,13 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> + <word_id>137</word_id> <id>327</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>timestamp</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16705,7 +16804,7 @@ </sequence> </normal_column> <normal_column> - <word_id>110</word_id> + <word_id>138</word_id> <id>328</id> <description></description> <unique_key_name></unique_key_name> @@ -16737,52 +16836,20 @@ <decimal_size>0</decimal_size> </sequence> </normal_column> - </columns> - <indexes> - </indexes> - <complex_unique_key_list> - </complex_unique_key_list> - <table_properties> - <schema>public</schema> - <without_oids>true</without_oids> - </table_properties> - </table> - <table> - <id>33</id> - <height>254</height> - <width>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>198</word_id> + <word_id>156</word_id> <id>329</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>numeric(p)</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> - <primary_key>true</primary_key> + <not_null>false</not_null> + <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> <collation></collation> @@ -16803,13 +16870,13 @@ </sequence> </normal_column> <normal_column> - <word_id>199</word_id> + <word_id>10</word_id> <id>330</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>text</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16836,13 +16903,13 @@ </sequence> </normal_column> <normal_column> - <word_id>47</word_id> + <word_id>134</word_id> <id>331</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16869,18 +16936,18 @@ </sequence> </normal_column> <normal_column> - <word_id>44</word_id> + <word_id>191</word_id> <id>332</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -16902,18 +16969,18 @@ </sequence> </normal_column> <normal_column> - <word_id>48</word_id> + <word_id>189</word_id> <id>333</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>char</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -16935,13 +17002,13 @@ </sequence> </normal_column> <normal_column> - <word_id>46</word_id> + <word_id>87</word_id> <id>334</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -16968,7 +17035,7 @@ </sequence> </normal_column> <normal_column> - <word_id>43</word_id> + <word_id>85</word_id> <id>335</id> <description></description> <unique_key_name></unique_key_name> @@ -17001,13 +17068,13 @@ </sequence> </normal_column> <normal_column> - <word_id>45</word_id> + <word_id>107</word_id> <id>336</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>varchar(n)</type> + <type>timestamp</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> @@ -17034,18 +17101,18 @@ </sequence> </normal_column> <normal_column> - <word_id>102</word_id> + <word_id>109</word_id> <id>337</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> - <type>char</type> + <type>varchar(n)</type> <constraint></constraint> <default_value></default_value> <auto_increment>false</auto_increment> <foreign_key>false</foreign_key> - <not_null>true</not_null> + <not_null>false</not_null> <primary_key>false</primary_key> <unique_key>false</unique_key> <character_set></character_set> @@ -17067,12 +17134,45 @@ </sequence> </normal_column> <normal_column> - <word_id>196</word_id> + <word_id>26</word_id> <id>338</id> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> <physical_name></physical_name> + <type>character(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>182</word_id> + <id>339</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> @@ -17101,6 +17201,19 @@ </normal_column> </columns> <indexes> + <inidex> + <full_text>false</full_text> + <non_unique>true</non_unique> + <name>comtnbbs_i01</name> + <type>BTREE</type> + <description></description> + <columns> + <column> + <id>315</id> + <desc>false</desc> + </column> + </columns> + </inidex> </indexes> <complex_unique_key_list> </complex_unique_key_list>