Index: base3.10/script/postgres.erm =================================================================== --- base3.10/script/postgres.erm (revision 132) +++ base3.10/script/postgres.erm (revision 133) @@ -10,9 +10,9 @@ <right_margin>30</right_margin> </page_setting> <category_index>0</category_index> - <zoom>1.5</zoom> - <x>1757</x> - <y>0</y> + <zoom>0.8</zoom> + <x>634</x> + <y>1</y> <default_color> <r>128</r> <g>128</g> @@ -229,7 +229,6 @@ <node_element>1</node_element> <node_element>23</node_element> <node_element>34</node_element> - <node_element>35</node_element> </category> <category> <id>41</id> @@ -279,7 +278,7 @@ </connections> <display>false</display> <creation_date>2022-01-26 16:20:32</creation_date> - <updated_date>2022-02-21 15:24:27</updated_date> + <updated_date>2022-02-22 13:10:00</updated_date> <model_property> <name>프로젝트명</name> <value></value> @@ -2571,6 +2570,38 @@ </word> <word> <id>141</id> + <length>100</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>국가명</description> + <logical_name>국가명</logical_name> + <physical_name>ntn_nm</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>142</id> + <length>100</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>국가명</description> + <logical_name>국가명</logical_name> + <physical_name>ntn_nm</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>143</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2586,7 +2617,23 @@ <type>text</type> </word> <word> - <id>142</id> + <id>144</id> + <length>20</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>게시글ID</description> + <logical_name>게시글ID</logical_name> + <physical_name>ntt_id</physical_name> + <type>numeric(p)</type> + </word> + <word> + <id>145</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2602,7 +2649,7 @@ <type>numeric(p)</type> </word> <word> - <id>143</id> + <id>146</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2618,7 +2665,7 @@ <type>numeric(p)</type> </word> <word> - <id>144</id> + <id>147</id> <length>2000</length> <decimal>null</decimal> <array>false</array> @@ -2634,7 +2681,7 @@ <type>varchar(n)</type> </word> <word> - <id>145</id> + <id>148</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2650,7 +2697,7 @@ <type>character(n)</type> </word> <word> - <id>146</id> + <id>149</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -2666,7 +2713,7 @@ <type>character(n)</type> </word> <word> - <id>147</id> + <id>150</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2682,7 +2729,39 @@ <type>timestamp</type> </word> <word> - <id>148</id> + <id>151</id> + <length>null</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>발생일</description> + <logical_name>발생일</logical_name> + <physical_name>occrrnc_de</physical_name> + <type>timestamp</type> + </word> + <word> + <id>152</id> + <length>8</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>발행일</description> + <logical_name>발행일</logical_name> + <physical_name>occrrnc_de</physical_name> + <type>character(n)</type> + </word> + <word> + <id>153</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2698,7 +2777,7 @@ <type>varchar(n)</type> </word> <word> - <id>149</id> + <id>154</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2714,7 +2793,7 @@ <type>varchar(n)</type> </word> <word> - <id>150</id> + <id>155</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2730,7 +2809,7 @@ <type>varchar(n)</type> </word> <word> - <id>151</id> + <id>156</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2746,7 +2825,7 @@ <type></type> </word> <word> - <id>152</id> + <id>157</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2762,7 +2841,7 @@ <type>character(n)</type> </word> <word> - <id>153</id> + <id>158</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -2778,7 +2857,7 @@ <type>varchar(n)</type> </word> <word> - <id>154</id> + <id>159</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -2794,7 +2873,7 @@ <type>text</type> </word> <word> - <id>155</id> + <id>160</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2810,7 +2889,7 @@ <type>numeric(p)</type> </word> <word> - <id>156</id> + <id>161</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2826,7 +2905,7 @@ <type>numeric(p)</type> </word> <word> - <id>157</id> + <id>162</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2842,7 +2921,7 @@ <type>numeric(p)</type> </word> <word> - <id>158</id> + <id>163</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -2858,7 +2937,7 @@ <type>varchar(n)</type> </word> <word> - <id>159</id> + <id>164</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -2874,7 +2953,7 @@ <type>varchar(n)</type> </word> <word> - <id>160</id> + <id>165</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2890,7 +2969,7 @@ <type>varchar(n)</type> </word> <word> - <id>161</id> + <id>166</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -2906,7 +2985,7 @@ <type>varchar(n)</type> </word> <word> - <id>162</id> + <id>167</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -2922,7 +3001,7 @@ <type>numeric(p)</type> </word> <word> - <id>163</id> + <id>168</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -2938,7 +3017,7 @@ <type>character(n)</type> </word> <word> - <id>164</id> + <id>169</id> <length>14</length> <decimal>null</decimal> <array>false</array> @@ -2954,7 +3033,7 @@ <type>varchar(n)</type> </word> <word> - <id>165</id> + <id>170</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -2970,7 +3049,7 @@ <type>varchar(n)</type> </word> <word> - <id>166</id> + <id>171</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -2986,7 +3065,7 @@ <type>varchar(n)</type> </word> <word> - <id>167</id> + <id>172</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3002,7 +3081,7 @@ <type>varchar(n)</type> </word> <word> - <id>168</id> + <id>173</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3018,7 +3097,7 @@ <type>character(n)</type> </word> <word> - <id>169</id> + <id>174</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3034,7 +3113,7 @@ <type>numeric(p)</type> </word> <word> - <id>170</id> + <id>175</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3050,7 +3129,23 @@ <type>numeric(p)</type> </word> <word> - <id>171</id> + <id>176</id> + <length>10</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>조회수</description> + <logical_name>조회수</logical_name> + <physical_name>rdcnt</physical_name> + <type>numeric(p)</type> + </word> + <word> + <id>177</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3066,7 +3161,7 @@ <type>varchar(n)</type> </word> <word> - <id>172</id> + <id>178</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3082,7 +3177,7 @@ <type>timestamp</type> </word> <word> - <id>173</id> + <id>179</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3098,7 +3193,7 @@ <type>character(n)</type> </word> <word> - <id>174</id> + <id>180</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3114,7 +3209,7 @@ <type>varchar(n)</type> </word> <word> - <id>175</id> + <id>181</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3130,7 +3225,23 @@ <type>char</type> </word> <word> - <id>176</id> + <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>requst_id</physical_name> + <type>varchar</type> + </word> + <word> + <id>183</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3146,7 +3257,7 @@ <type>varchar(n)</type> </word> <word> - <id>177</id> + <id>184</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3162,7 +3273,7 @@ <type>varchar(n)</type> </word> <word> - <id>178</id> + <id>185</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3178,7 +3289,7 @@ <type>timestamp</type> </word> <word> - <id>179</id> + <id>186</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3194,7 +3305,7 @@ <type>varchar(n)</type> </word> <word> - <id>180</id> + <id>187</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3210,7 +3321,7 @@ <type>varchar(n)</type> </word> <word> - <id>181</id> + <id>188</id> <length>300</length> <decimal>null</decimal> <array>false</array> @@ -3226,7 +3337,7 @@ <type>varchar(n)</type> </word> <word> - <id>182</id> + <id>189</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3242,7 +3353,7 @@ <type>varchar(n)</type> </word> <word> - <id>183</id> + <id>190</id> <length>80</length> <decimal>null</decimal> <array>false</array> @@ -3258,7 +3369,7 @@ <type>varchar(n)</type> </word> <word> - <id>184</id> + <id>191</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3274,7 +3385,7 @@ <type>text</type> </word> <word> - <id>185</id> + <id>192</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3290,7 +3401,7 @@ <type>varchar(n)</type> </word> <word> - <id>186</id> + <id>193</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3306,7 +3417,7 @@ <type>varchar(n)</type> </word> <word> - <id>187</id> + <id>194</id> <length>23</length> <decimal>null</decimal> <array>false</array> @@ -3322,7 +3433,23 @@ <type>varchar(n)</type> </word> <word> - <id>188</id> + <id>195</id> + <length>23</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>요청자IP</description> + <logical_name>요청자IP</logical_name> + <physical_name>rqester_ip</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>196</id> <length>3</length> <decimal>null</decimal> <array>false</array> @@ -3338,7 +3465,7 @@ <type>character(n)</type> </word> <word> - <id>189</id> + <id>197</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3354,7 +3481,7 @@ <type>timestamp</type> </word> <word> - <id>190</id> + <id>198</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3370,7 +3497,7 @@ <type>varchar(n)</type> </word> <word> - <id>191</id> + <id>199</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3386,7 +3513,7 @@ <type>char</type> </word> <word> - <id>192</id> + <id>200</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3402,7 +3529,7 @@ <type>char</type> </word> <word> - <id>193</id> + <id>201</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3418,7 +3545,7 @@ <type>char</type> </word> <word> - <id>194</id> + <id>202</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3434,7 +3561,7 @@ <type>text</type> </word> <word> - <id>195</id> + <id>203</id> <length>8</length> <decimal>null</decimal> <array>false</array> @@ -3450,7 +3577,7 @@ <type>numeric(p)</type> </word> <word> - <id>196</id> + <id>204</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3466,7 +3593,7 @@ <type>char</type> </word> <word> - <id>197</id> + <id>205</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3482,7 +3609,7 @@ <type>varchar(n)</type> </word> <word> - <id>198</id> + <id>206</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3498,7 +3625,7 @@ <type>varchar(n)</type> </word> <word> - <id>199</id> + <id>207</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3514,7 +3641,7 @@ <type>text</type> </word> <word> - <id>200</id> + <id>208</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3530,7 +3657,7 @@ <type>text</type> </word> <word> - <id>201</id> + <id>209</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3546,7 +3673,7 @@ <type>numeric(p)</type> </word> <word> - <id>202</id> + <id>210</id> <length>30</length> <decimal>null</decimal> <array>false</array> @@ -3562,7 +3689,7 @@ <type>varchar(n)</type> </word> <word> - <id>203</id> + <id>211</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3578,7 +3705,7 @@ <type>varchar(n)</type> </word> <word> - <id>204</id> + <id>212</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3594,7 +3721,7 @@ <type>character(n)</type> </word> <word> - <id>205</id> + <id>213</id> <length>255</length> <decimal>null</decimal> <array>false</array> @@ -3610,7 +3737,7 @@ <type>varchar(n)</type> </word> <word> - <id>206</id> + <id>214</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3626,7 +3753,7 @@ <type>numeric(p)</type> </word> <word> - <id>207</id> + <id>215</id> <length>10</length> <decimal>null</decimal> <array>false</array> @@ -3642,7 +3769,7 @@ <type>numeric(p)</type> </word> <word> - <id>208</id> + <id>216</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3658,7 +3785,7 @@ <type>timestamp</type> </word> <word> - <id>209</id> + <id>217</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3674,7 +3801,7 @@ <type>varchar(n)</type> </word> <word> - <id>210</id> + <id>218</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3690,7 +3817,7 @@ <type>text</type> </word> <word> - <id>211</id> + <id>219</id> <length>200</length> <decimal>null</decimal> <array>false</array> @@ -3706,7 +3833,23 @@ <type>varchar(n)</type> </word> <word> - <id>212</id> + <id>220</id> + <length>200</length> + <decimal>null</decimal> + <array>false</array> + <array_dimension>null</array_dimension> + <unsigned>false</unsigned> + <zerofill>false</zerofill> + <binary>false</binary> + <args></args> + <char_semantics>false</char_semantics> + <description>url</description> + <logical_name>url</logical_name> + <physical_name>url</physical_name> + <type>varchar(n)</type> + </word> + <word> + <id>221</id> <length>100</length> <decimal>null</decimal> <array>false</array> @@ -3722,7 +3865,7 @@ <type>varchar(n)</type> </word> <word> - <id>213</id> + <id>222</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3738,7 +3881,7 @@ <type>varchar(n)</type> </word> <word> - <id>214</id> + <id>223</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3754,7 +3897,7 @@ <type>varchar(n)</type> </word> <word> - <id>215</id> + <id>224</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3770,7 +3913,7 @@ <type>varchar(n)</type> </word> <word> - <id>216</id> + <id>225</id> <length>60</length> <decimal>null</decimal> <array>false</array> @@ -3786,7 +3929,7 @@ <type>varchar(n)</type> </word> <word> - <id>217</id> + <id>226</id> <length>50</length> <decimal>null</decimal> <array>false</array> @@ -3802,7 +3945,7 @@ <type>varchar(n)</type> </word> <word> - <id>218</id> + <id>227</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3818,7 +3961,7 @@ <type></type> </word> <word> - <id>219</id> + <id>228</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3834,7 +3977,7 @@ <type>varchar(n)</type> </word> <word> - <id>220</id> + <id>229</id> <length>null</length> <decimal>null</decimal> <array>false</array> @@ -3850,7 +3993,7 @@ <type>char</type> </word> <word> - <id>221</id> + <id>230</id> <length>1</length> <decimal>null</decimal> <array>false</array> @@ -3866,7 +4009,7 @@ <type>varchar(n)</type> </word> <word> - <id>222</id> + <id>231</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3882,7 +4025,7 @@ <type>varchar(n)</type> </word> <word> - <id>223</id> + <id>232</id> <length>20</length> <decimal>null</decimal> <array>false</array> @@ -3898,7 +4041,7 @@ <type>varchar(n)</type> </word> <word> - <id>224</id> + <id>233</id> <length>6</length> <decimal>null</decimal> <array>false</array> @@ -3971,7 +4114,7 @@ </sequence> </normal_column> <normal_column> - <word_id>215</word_id> + <word_id>224</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4004,7 +4147,7 @@ </sequence> </normal_column> <normal_column> - <word_id>159</word_id> + <word_id>163</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4037,7 +4180,7 @@ </sequence> </normal_column> <normal_column> - <word_id>217</word_id> + <word_id>226</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4070,7 +4213,7 @@ </sequence> </normal_column> <normal_column> - <word_id>219</word_id> + <word_id>228</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4103,7 +4246,7 @@ </sequence> </normal_column> <normal_column> - <word_id>212</word_id> + <word_id>221</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4136,7 +4279,7 @@ </sequence> </normal_column> <normal_column> - <word_id>213</word_id> + <word_id>222</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4202,7 +4345,7 @@ </sequence> </normal_column> <normal_column> - <word_id>218</word_id> + <word_id>227</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4235,7 +4378,7 @@ </sequence> </normal_column> <normal_column> - <word_id>151</word_id> + <word_id>156</word_id> <id>null</id> <description></description> <unique_key_name></unique_key_name> @@ -4295,7 +4438,7 @@ <option></option> <columns> <normal_column> - <word_id>145</word_id> + <word_id>149</word_id> <id>0</id> <description></description> <unique_key_name></unique_key_name> @@ -4328,7 +4471,7 @@ </sequence> </normal_column> <normal_column> - <word_id>197</word_id> + <word_id>206</word_id> <id>1</id> <description></description> <unique_key_name></unique_key_name> @@ -4394,7 +4537,7 @@ </sequence> </normal_column> <normal_column> - <word_id>50</word_id> + <word_id>49</word_id> <id>3</id> <description></description> <unique_key_name></unique_key_name> @@ -4427,7 +4570,7 @@ </sequence> </normal_column> <normal_column> - <word_id>206</word_id> + <word_id>214</word_id> <id>4</id> <description></description> <unique_key_name></unique_key_name> @@ -4460,7 +4603,7 @@ </sequence> </normal_column> <normal_column> - <word_id>170</word_id> + <word_id>174</word_id> <id>5</id> <description></description> <unique_key_name></unique_key_name> @@ -4493,7 +4636,7 @@ </sequence> </normal_column> <normal_column> - <word_id>56</word_id> + <word_id>57</word_id> <id>6</id> <description></description> <unique_key_name></unique_key_name> @@ -4526,7 +4669,7 @@ </sequence> </normal_column> <normal_column> - <word_id>156</word_id> + <word_id>161</word_id> <id>7</id> <description></description> <unique_key_name></unique_key_name> @@ -4559,7 +4702,7 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> + <word_id>73</word_id> <id>8</id> <description></description> <unique_key_name></unique_key_name> @@ -4781,7 +4924,7 @@ <option></option> <columns> <normal_column> - <word_id>152</word_id> + <word_id>157</word_id> <id>11</id> <description></description> <unique_key_name></unique_key_name> @@ -4814,7 +4957,7 @@ </sequence> </normal_column> <normal_column> - <word_id>153</word_id> + <word_id>158</word_id> <id>12</id> <description></description> <unique_key_name></unique_key_name> @@ -4847,7 +4990,7 @@ </sequence> </normal_column> <normal_column> - <word_id>150</word_id> + <word_id>155</word_id> <id>13</id> <description></description> <unique_key_name></unique_key_name> @@ -5132,7 +5275,7 @@ </sequence> </normal_column> <normal_column> - <word_id>224</word_id> + <word_id>233</word_id> <id>20</id> <description></description> <unique_key_name></unique_key_name> @@ -5363,7 +5506,7 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> + <word_id>197</word_id> <id>27</id> <description></description> <unique_key_name></unique_key_name> @@ -6015,7 +6158,7 @@ </sequence> </normal_column> <normal_column> - <word_id>216</word_id> + <word_id>225</word_id> <id>44</id> <description></description> <unique_key_name></unique_key_name> @@ -6048,7 +6191,7 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> + <word_id>164</word_id> <id>45</id> <description></description> <unique_key_name></unique_key_name> @@ -6147,7 +6290,7 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> + <word_id>200</word_id> <id>48</id> <description></description> <unique_key_name></unique_key_name> @@ -6279,7 +6422,7 @@ </sequence> </normal_column> <normal_column> - <word_id>161</word_id> + <word_id>166</word_id> <id>52</id> <description></description> <unique_key_name></unique_key_name> @@ -6312,7 +6455,7 @@ </sequence> </normal_column> <normal_column> - <word_id>160</word_id> + <word_id>165</word_id> <id>53</id> <description></description> <unique_key_name></unique_key_name> @@ -6444,7 +6587,7 @@ </sequence> </normal_column> <normal_column> - <word_id>224</word_id> + <word_id>233</word_id> <id>57</id> <description></description> <unique_key_name></unique_key_name> @@ -6477,7 +6620,7 @@ </sequence> </normal_column> <normal_column> - <word_id>149</word_id> + <word_id>154</word_id> <id>58</id> <description></description> <unique_key_name></unique_key_name> @@ -6576,7 +6719,7 @@ </sequence> </normal_column> <normal_column> - <word_id>148</word_id> + <word_id>153</word_id> <id>61</id> <description></description> <unique_key_name></unique_key_name> @@ -6676,7 +6819,7 @@ </sequence> </normal_column> <normal_column> - <word_id>168</word_id> + <word_id>173</word_id> <id>64</id> <description></description> <unique_key_name></unique_key_name> @@ -6808,7 +6951,7 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> + <word_id>197</word_id> <id>68</id> <description></description> <unique_key_name></unique_key_name> @@ -7097,7 +7240,7 @@ </sequence> </normal_column> <normal_column> - <word_id>196</word_id> + <word_id>204</word_id> <id>75</id> <description></description> <unique_key_name></unique_key_name> @@ -7163,7 +7306,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>77</id> <description></description> <unique_key_name></unique_key_name> @@ -7287,7 +7430,7 @@ <connections> <relation> <id>5</id> - <source>27</source> + <source>8</source> <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -7301,7 +7444,7 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnauthorrolerelate_role_code_fkey</name> + <name>comtnauthorrolerelate_author_code_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -7309,7 +7452,7 @@ </relation> <relation> <id>6</id> - <source>8</source> + <source>27</source> <target>7</target> <source_xp>-1</source_xp> <source_yp>-1</source_yp> @@ -7323,7 +7466,7 @@ <child_cardinality>1..n</child_cardinality> <parent_cardinality>1</parent_cardinality> <reference_for_pk>true</reference_for_pk> - <name>comtnauthorrolerelate_author_code_fkey</name> + <name>comtnauthorrolerelate_role_code_fkey</name> <on_delete_action>CASCADE</on_delete_action> <on_update_action>NO ACTION</on_update_action> <referenced_column>null</referenced_column> @@ -7340,7 +7483,7 @@ <normal_column> <id>80</id> <referenced_column>83</referenced_column> - <relation>6</relation> + <relation>5</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7374,7 +7517,7 @@ <normal_column> <id>81</id> <referenced_column>255</referenced_column> - <relation>5</relation> + <relation>6</relation> <description></description> <unique_key_name></unique_key_name> <logical_name></logical_name> @@ -7497,7 +7640,7 @@ <option></option> <columns> <normal_column> - <word_id>14</word_id> + <word_id>13</word_id> <id>83</id> <description></description> <unique_key_name></unique_key_name> @@ -7825,7 +7968,7 @@ <option></option> <columns> <normal_column> - <word_id>203</word_id> + <word_id>211</word_id> <id>91</id> <description></description> <unique_key_name></unique_key_name> @@ -8078,7 +8221,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>229</word_id> <id>97</id> <description></description> <unique_key_name></unique_key_name> @@ -8177,7 +8320,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>100</id> <description></description> <unique_key_name></unique_key_name> @@ -8409,7 +8552,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>229</word_id> <id>105</id> <description></description> <unique_key_name></unique_key_name> @@ -8542,7 +8685,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>109</id> <description></description> <unique_key_name></unique_key_name> @@ -8653,7 +8796,7 @@ <option></option> <columns> <normal_column> - <word_id>176</word_id> + <word_id>183</word_id> <id>111</id> <description></description> <unique_key_name></unique_key_name> @@ -8686,7 +8829,7 @@ </sequence> </normal_column> <normal_column> - <word_id>147</word_id> + <word_id>150</word_id> <id>112</id> <description></description> <unique_key_name></unique_key_name> @@ -8719,7 +8862,7 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> + <word_id>219</word_id> <id>113</id> <description></description> <unique_key_name></unique_key_name> @@ -8752,7 +8895,7 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> + <word_id>192</word_id> <id>114</id> <description></description> <unique_key_name></unique_key_name> @@ -8785,7 +8928,7 @@ </sequence> </normal_column> <normal_column> - <word_id>187</word_id> + <word_id>194</word_id> <id>115</id> <description></description> <unique_key_name></unique_key_name> @@ -8818,7 +8961,7 @@ </sequence> </normal_column> <normal_column> - <word_id>140</word_id> + <word_id>139</word_id> <id>116</id> <description></description> <unique_key_name></unique_key_name> @@ -9080,7 +9223,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>229</word_id> <id>122</id> <description></description> <unique_key_name></unique_key_name> @@ -9179,7 +9322,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>125</id> <description></description> <unique_key_name></unique_key_name> @@ -9332,7 +9475,7 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> + <word_id>164</word_id> <id>128</id> <description></description> <unique_key_name></unique_key_name> @@ -9365,7 +9508,7 @@ </sequence> </normal_column> <normal_column> - <word_id>161</word_id> + <word_id>166</word_id> <id>129</id> <description></description> <unique_key_name></unique_key_name> @@ -9398,7 +9541,7 @@ </sequence> </normal_column> <normal_column> - <word_id>160</word_id> + <word_id>165</word_id> <id>130</id> <description></description> <unique_key_name></unique_key_name> @@ -9497,7 +9640,7 @@ </sequence> </normal_column> <normal_column> - <word_id>224</word_id> + <word_id>233</word_id> <id>133</id> <description></description> <unique_key_name></unique_key_name> @@ -9861,7 +10004,7 @@ </sequence> </normal_column> <normal_column> - <word_id>189</word_id> + <word_id>197</word_id> <id>144</id> <description></description> <unique_key_name></unique_key_name> @@ -9894,7 +10037,7 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> + <word_id>200</word_id> <id>145</id> <description></description> <unique_key_name></unique_key_name> @@ -10631,7 +10774,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>165</id> <description></description> <unique_key_name></unique_key_name> @@ -10696,7 +10839,7 @@ <option></option> <columns> <normal_column> - <word_id>190</word_id> + <word_id>198</word_id> <id>166</id> <description></description> <unique_key_name></unique_key_name> @@ -10762,7 +10905,7 @@ </sequence> </normal_column> <normal_column> - <word_id>14</word_id> + <word_id>13</word_id> <id>168</id> <description></description> <unique_key_name></unique_key_name> @@ -10929,7 +11072,7 @@ </sequence> </normal_column> <normal_column> - <word_id>152</word_id> + <word_id>157</word_id> <id>171</id> <description></description> <unique_key_name></unique_key_name> @@ -11028,7 +11171,7 @@ </sequence> </normal_column> <normal_column> - <word_id>192</word_id> + <word_id>200</word_id> <id>174</id> <description></description> <unique_key_name></unique_key_name> @@ -11259,7 +11402,7 @@ </sequence> </normal_column> <normal_column> - <word_id>224</word_id> + <word_id>233</word_id> <id>181</id> <description></description> <unique_key_name></unique_key_name> @@ -11292,7 +11435,7 @@ </sequence> </normal_column> <normal_column> - <word_id>149</word_id> + <word_id>154</word_id> <id>182</id> <description></description> <unique_key_name></unique_key_name> @@ -11424,7 +11567,7 @@ </sequence> </normal_column> <normal_column> - <word_id>168</word_id> + <word_id>173</word_id> <id>186</id> <description></description> <unique_key_name></unique_key_name> @@ -11568,7 +11711,7 @@ <option></option> <columns> <normal_column> - <word_id>176</word_id> + <word_id>183</word_id> <id>189</id> <description></description> <unique_key_name></unique_key_name> @@ -11667,7 +11810,7 @@ </sequence> </normal_column> <normal_column> - <word_id>147</word_id> + <word_id>150</word_id> <id>192</id> <description></description> <unique_key_name></unique_key_name> @@ -11700,7 +11843,7 @@ </sequence> </normal_column> <normal_column> - <word_id>187</word_id> + <word_id>194</word_id> <id>193</id> <description></description> <unique_key_name></unique_key_name> @@ -11733,7 +11876,7 @@ </sequence> </normal_column> <normal_column> - <word_id>185</word_id> + <word_id>192</word_id> <id>194</id> <description></description> <unique_key_name></unique_key_name> @@ -11766,7 +11909,7 @@ </sequence> </normal_column> <normal_column> - <word_id>205</word_id> + <word_id>213</word_id> <id>195</id> <description></description> <unique_key_name></unique_key_name> @@ -11799,7 +11942,7 @@ </sequence> </normal_column> <normal_column> - <word_id>197</word_id> + <word_id>206</word_id> <id>196</id> <description></description> <unique_key_name></unique_key_name> @@ -11865,7 +12008,7 @@ </sequence> </normal_column> <normal_column> - <word_id>163</word_id> + <word_id>168</word_id> <id>198</id> <description></description> <unique_key_name></unique_key_name> @@ -11898,7 +12041,7 @@ </sequence> </normal_column> <normal_column> - <word_id>162</word_id> + <word_id>167</word_id> <id>199</id> <description></description> <unique_key_name></unique_key_name> @@ -11931,7 +12074,7 @@ </sequence> </normal_column> <normal_column> - <word_id>164</word_id> + <word_id>169</word_id> <id>200</id> <description></description> <unique_key_name></unique_key_name> @@ -11964,7 +12107,7 @@ </sequence> </normal_column> <normal_column> - <word_id>188</word_id> + <word_id>196</word_id> <id>201</id> <description></description> <unique_key_name></unique_key_name> @@ -12030,7 +12173,7 @@ </sequence> </normal_column> <normal_column> - <word_id>74</word_id> + <word_id>73</word_id> <id>203</id> <description></description> <unique_key_name></unique_key_name> @@ -12251,7 +12394,7 @@ </sequence> </normal_column> <normal_column> - <word_id>222</word_id> + <word_id>231</word_id> <id>208</id> <description></description> <unique_key_name></unique_key_name> @@ -12284,7 +12427,7 @@ </sequence> </normal_column> <normal_column> - <word_id>223</word_id> + <word_id>232</word_id> <id>209</id> <description></description> <unique_key_name></unique_key_name> @@ -12350,7 +12493,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>229</word_id> <id>211</id> <description></description> <unique_key_name></unique_key_name> @@ -12449,7 +12592,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>214</id> <description></description> <unique_key_name></unique_key_name> @@ -12515,7 +12658,7 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> + <word_id>164</word_id> <id>216</id> <description></description> <unique_key_name></unique_key_name> @@ -12597,7 +12740,7 @@ <option></option> <columns> <normal_column> - <word_id>146</word_id> + <word_id>148</word_id> <id>217</id> <description></description> <unique_key_name></unique_key_name> @@ -12630,7 +12773,7 @@ </sequence> </normal_column> <normal_column> - <word_id>186</word_id> + <word_id>193</word_id> <id>218</id> <description></description> <unique_key_name></unique_key_name> @@ -12663,7 +12806,7 @@ </sequence> </normal_column> <normal_column> - <word_id>198</word_id> + <word_id>205</word_id> <id>219</id> <description></description> <unique_key_name></unique_key_name> @@ -12729,7 +12872,7 @@ </sequence> </normal_column> <normal_column> - <word_id>49</word_id> + <word_id>50</word_id> <id>221</id> <description></description> <unique_key_name></unique_key_name> @@ -12762,7 +12905,7 @@ </sequence> </normal_column> <normal_column> - <word_id>207</word_id> + <word_id>215</word_id> <id>222</id> <description></description> <unique_key_name></unique_key_name> @@ -12795,7 +12938,7 @@ </sequence> </normal_column> <normal_column> - <word_id>169</word_id> + <word_id>175</word_id> <id>223</id> <description></description> <unique_key_name></unique_key_name> @@ -12828,7 +12971,7 @@ </sequence> </normal_column> <normal_column> - <word_id>57</word_id> + <word_id>56</word_id> <id>224</id> <description></description> <unique_key_name></unique_key_name> @@ -12861,7 +13004,7 @@ </sequence> </normal_column> <normal_column> - <word_id>155</word_id> + <word_id>160</word_id> <id>225</id> <description></description> <unique_key_name></unique_key_name> @@ -12894,7 +13037,7 @@ </sequence> </normal_column> <normal_column> - <word_id>73</word_id> + <word_id>74</word_id> <id>226</id> <description></description> <unique_key_name></unique_key_name> @@ -13058,7 +13201,7 @@ </sequence> </normal_column> <normal_column> - <word_id>154</word_id> + <word_id>159</word_id> <id>230</id> <description></description> <unique_key_name></unique_key_name> @@ -13091,7 +13234,7 @@ </sequence> </normal_column> <normal_column> - <word_id>200</word_id> + <word_id>208</word_id> <id>231</id> <description></description> <unique_key_name></unique_key_name> @@ -13124,7 +13267,7 @@ </sequence> </normal_column> <normal_column> - <word_id>210</word_id> + <word_id>218</word_id> <id>232</id> <description></description> <unique_key_name></unique_key_name> @@ -13256,7 +13399,7 @@ </sequence> </normal_column> <normal_column> - <word_id>171</word_id> + <word_id>177</word_id> <id>236</id> <description></description> <unique_key_name></unique_key_name> @@ -13289,7 +13432,7 @@ </sequence> </normal_column> <normal_column> - <word_id>172</word_id> + <word_id>178</word_id> <id>237</id> <description></description> <unique_key_name></unique_key_name> @@ -13322,7 +13465,7 @@ </sequence> </normal_column> <normal_column> - <word_id>209</word_id> + <word_id>217</word_id> <id>238</id> <description></description> <unique_key_name></unique_key_name> @@ -13355,7 +13498,7 @@ </sequence> </normal_column> <normal_column> - <word_id>208</word_id> + <word_id>216</word_id> <id>239</id> <description></description> <unique_key_name></unique_key_name> @@ -13475,7 +13618,7 @@ </sequence> </normal_column> <normal_column> - <word_id>13</word_id> + <word_id>14</word_id> <id>241</id> <description></description> <unique_key_name></unique_key_name> @@ -13508,7 +13651,7 @@ </sequence> </normal_column> <normal_column> - <word_id>214</word_id> + <word_id>223</word_id> <id>242</id> <description></description> <unique_key_name></unique_key_name> @@ -14017,7 +14160,7 @@ </sequence> </normal_column> <normal_column> - <word_id>166</word_id> + <word_id>171</word_id> <id>248</id> <description></description> <unique_key_name></unique_key_name> @@ -14050,7 +14193,7 @@ </sequence> </normal_column> <normal_column> - <word_id>167</word_id> + <word_id>172</word_id> <id>249</id> <description></description> <unique_key_name></unique_key_name> @@ -14182,7 +14325,7 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> + <word_id>108</word_id> <id>253</id> <description></description> <unique_key_name></unique_key_name> @@ -14280,7 +14423,7 @@ <option></option> <columns> <normal_column> - <word_id>177</word_id> + <word_id>184</word_id> <id>255</id> <description></description> <unique_key_name></unique_key_name> @@ -14313,7 +14456,7 @@ </sequence> </normal_column> <normal_column> - <word_id>180</word_id> + <word_id>187</word_id> <id>256</id> <description></description> <unique_key_name></unique_key_name> @@ -14346,7 +14489,7 @@ </sequence> </normal_column> <normal_column> - <word_id>181</word_id> + <word_id>188</word_id> <id>257</id> <description></description> <unique_key_name></unique_key_name> @@ -14379,7 +14522,7 @@ </sequence> </normal_column> <normal_column> - <word_id>179</word_id> + <word_id>186</word_id> <id>258</id> <description></description> <unique_key_name></unique_key_name> @@ -14412,7 +14555,7 @@ </sequence> </normal_column> <normal_column> - <word_id>183</word_id> + <word_id>190</word_id> <id>259</id> <description></description> <unique_key_name></unique_key_name> @@ -14445,7 +14588,7 @@ </sequence> </normal_column> <normal_column> - <word_id>182</word_id> + <word_id>189</word_id> <id>260</id> <description></description> <unique_key_name></unique_key_name> @@ -14478,7 +14621,7 @@ </sequence> </normal_column> <normal_column> - <word_id>178</word_id> + <word_id>185</word_id> <id>261</id> <description></description> <unique_key_name></unique_key_name> @@ -14675,7 +14818,7 @@ </sequence> </normal_column> <normal_column> - <word_id>175</word_id> + <word_id>181</word_id> <id>266</id> <description></description> <unique_key_name></unique_key_name> @@ -14807,7 +14950,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>229</word_id> <id>270</id> <description></description> <unique_key_name></unique_key_name> @@ -14939,7 +15082,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>274</id> <description></description> <unique_key_name></unique_key_name> @@ -15038,7 +15181,7 @@ </sequence> </normal_column> <normal_column> - <word_id>194</word_id> + <word_id>202</word_id> <id>277</id> <description></description> <unique_key_name></unique_key_name> @@ -15258,7 +15401,7 @@ </sequence> </normal_column> <normal_column> - <word_id>204</word_id> + <word_id>212</word_id> <id>282</id> <description></description> <unique_key_name></unique_key_name> @@ -15291,7 +15434,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>229</word_id> <id>283</id> <description></description> <unique_key_name></unique_key_name> @@ -15324,7 +15467,7 @@ </sequence> </normal_column> <normal_column> - <word_id>173</word_id> + <word_id>179</word_id> <id>284</id> <description></description> <unique_key_name></unique_key_name> @@ -15423,7 +15566,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>287</id> <description></description> <unique_key_name></unique_key_name> @@ -15727,7 +15870,7 @@ </sequence> </normal_column> <normal_column> - <word_id>174</word_id> + <word_id>180</word_id> <id>294</id> <description></description> <unique_key_name></unique_key_name> @@ -15760,7 +15903,7 @@ </sequence> </normal_column> <normal_column> - <word_id>165</word_id> + <word_id>170</word_id> <id>295</id> <description></description> <unique_key_name></unique_key_name> @@ -15826,7 +15969,7 @@ </sequence> </normal_column> <normal_column> - <word_id>221</word_id> + <word_id>230</word_id> <id>297</id> <description></description> <unique_key_name></unique_key_name> @@ -15925,7 +16068,7 @@ </sequence> </normal_column> <normal_column> - <word_id>107</word_id> + <word_id>108</word_id> <id>300</id> <description></description> <unique_key_name></unique_key_name> @@ -16023,7 +16166,7 @@ <option></option> <columns> <normal_column> - <word_id>201</word_id> + <word_id>209</word_id> <id>302</id> <description></description> <unique_key_name></unique_key_name> @@ -16056,7 +16199,7 @@ </sequence> </normal_column> <normal_column> - <word_id>202</word_id> + <word_id>210</word_id> <id>303</id> <description></description> <unique_key_name></unique_key_name> @@ -16320,7 +16463,7 @@ </sequence> </normal_column> <normal_column> - <word_id>199</word_id> + <word_id>207</word_id> <id>311</id> <description></description> <unique_key_name></unique_key_name> @@ -16407,7 +16550,7 @@ <option></option> <columns> <normal_column> - <word_id>142</word_id> + <word_id>145</word_id> <id>312</id> <description></description> <unique_key_name></unique_key_name> @@ -16505,6 +16648,134 @@ <referenced_column>262</referenced_column> <referenced_column>262</referenced_column> <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <referenced_column>262</referenced_column> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <relation>16</relation> + <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> @@ -16600,7 +16871,7 @@ </sequence> </normal_column> <normal_column> - <word_id>143</word_id> + <word_id>146</word_id> <id>314</id> <description></description> <unique_key_name></unique_key_name> @@ -16633,7 +16904,7 @@ </sequence> </normal_column> <normal_column> - <word_id>144</word_id> + <word_id>147</word_id> <id>315</id> <description></description> <unique_key_name></unique_key_name> @@ -16666,7 +16937,7 @@ </sequence> </normal_column> <normal_column> - <word_id>141</word_id> + <word_id>143</word_id> <id>316</id> <description></description> <unique_key_name></unique_key_name> @@ -16732,7 +17003,7 @@ </sequence> </normal_column> <normal_column> - <word_id>157</word_id> + <word_id>162</word_id> <id>318</id> <description></description> <unique_key_name></unique_key_name> @@ -16798,7 +17069,7 @@ </sequence> </normal_column> <normal_column> - <word_id>195</word_id> + <word_id>203</word_id> <id>320</id> <description></description> <unique_key_name></unique_key_name> @@ -16831,7 +17102,7 @@ </sequence> </normal_column> <normal_column> - <word_id>170</word_id> + <word_id>174</word_id> <id>321</id> <description></description> <unique_key_name></unique_key_name> @@ -16864,7 +17135,7 @@ </sequence> </normal_column> <normal_column> - <word_id>220</word_id> + <word_id>229</word_id> <id>322</id> <description></description> <unique_key_name></unique_key_name> @@ -17029,7 +17300,7 @@ </sequence> </normal_column> <normal_column> - <word_id>158</word_id> + <word_id>164</word_id> <id>327</id> <description></description> <unique_key_name></unique_key_name> @@ -17128,7 +17399,7 @@ </sequence> </normal_column> <normal_column> - <word_id>193</word_id> + <word_id>201</word_id> <id>330</id> <description></description> <unique_key_name></unique_key_name> @@ -17161,7 +17432,7 @@ </sequence> </normal_column> <normal_column> - <word_id>191</word_id> + <word_id>199</word_id> <id>331</id> <description></description> <unique_key_name></unique_key_name> @@ -17260,7 +17531,7 @@ </sequence> </normal_column> <normal_column> - <word_id>108</word_id> + <word_id>107</word_id> <id>334</id> <description></description> <unique_key_name></unique_key_name> @@ -17359,7 +17630,7 @@ </sequence> </normal_column> <normal_column> - <word_id>184</word_id> + <word_id>191</word_id> <id>337</id> <description></description> <unique_key_name></unique_key_name> @@ -17437,7 +17708,7 @@ <option></option> <columns> <normal_column> - <word_id>145</word_id> + <word_id>149</word_id> <id>338</id> <description></description> <unique_key_name></unique_key_name> @@ -17470,7 +17741,7 @@ </sequence> </normal_column> <normal_column> - <word_id>211</word_id> + <word_id>219</word_id> <id>339</id> <description></description> <unique_key_name></unique_key_name> @@ -17503,7 +17774,7 @@ </sequence> </normal_column> <normal_column> - <word_id>139</word_id> + <word_id>140</word_id> <id>340</id> <description></description> <unique_key_name></unique_key_name> @@ -17536,7 +17807,7 @@ </sequence> </normal_column> <normal_column> - <word_id>170</word_id> + <word_id>174</word_id> <id>341</id> <description></description> <unique_key_name></unique_key_name> @@ -17580,12 +17851,12 @@ </table> <table> <id>34</id> - <height>75</height> - <width>174</width> + <height>149</height> + <width>200</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1212</x> - <y>346</y> + <x>1194</x> + <y>298</y> <color> <r>128</r> <g>128</g> @@ -17594,30 +17865,195 @@ <connections> </connections> <physical_name>comtnbbslog</physical_name> - <logical_name>게시글로그</logical_name> + <logical_name>게시글 로그</logical_name> <description></description> <constraint></constraint> - <primary_key_name></primary_key_name> + <primary_key_name>comtnbbslog_pk</primary_key_name> <option></option> <columns> + <normal_column> + <word_id>182</word_id> + <id>342</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>144</word_id> + <id>343</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>numeric(p)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>151</word_id> + <id>344</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>timestamp</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>141</word_id> + <id>345</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>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>195</word_id> + <id>346</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> </columns> <indexes> </indexes> <complex_unique_key_list> </complex_unique_key_list> <table_properties> - <schema></schema> + <schema>public</schema> <without_oids>true</without_oids> </table_properties> </table> <table> <id>35</id> - <height>75</height> - <width>267</width> + <height>128</height> + <width>243</width> <font_name>맑은 고딕</font_name> <font_size>9</font_size> - <x>1194</x> - <y>449</y> + <x>1176</x> + <y>458</y> <color> <r>128</r> <g>128</g> @@ -17629,16 +18065,148 @@ <logical_name>게시글 요약</logical_name> <description></description> <constraint></constraint> - <primary_key_name></primary_key_name> + <primary_key_name>comtnbbslogsummary_pk</primary_key_name> <option></option> <columns> + <normal_column> + <word_id>152</word_id> + <id>347</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>character(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>220</word_id> + <id>348</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>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>142</word_id> + <id>349</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>varchar(n)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>true</not_null> + <primary_key>true</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> + <normal_column> + <word_id>176</word_id> + <id>350</id> + <description></description> + <unique_key_name></unique_key_name> + <logical_name></logical_name> + <physical_name></physical_name> + <type>numeric(p)</type> + <constraint></constraint> + <default_value></default_value> + <auto_increment>false</auto_increment> + <foreign_key>false</foreign_key> + <not_null>false</not_null> + <primary_key>false</primary_key> + <unique_key>false</unique_key> + <character_set></character_set> + <collation></collation> + <sequence> + <name></name> + <schema></schema> + <increment></increment> + <min_value></min_value> + <max_value></max_value> + <start></start> + <cache></cache> + <nocache>false</nocache> + <cycle>false</cycle> + <order>false</order> + <description></description> + <data_type></data_type> + <decimal_size>0</decimal_size> + </sequence> + </normal_column> </columns> <indexes> </indexes> <complex_unique_key_list> </complex_unique_key_list> <table_properties> - <schema></schema> + <schema>public</schema> <without_oids>true</without_oids> </table_properties> </table>