임종호
2022-02-16
@75
Index: base3.10/script/postgres.erm
===================================================================
--- base3.10/script/postgres.erm (revision 74)
+++ base3.10/script/postgres.erm (revision 75)
@@ -10,9 +10,9 @@
<right_margin>30</right_margin>
</page_setting>
<category_index>0</category_index>
- <zoom>0.25</zoom>
+ <zoom>1.0</zoom>
<x>0</x>
- <y>162</y>
+ <y>813</y>
<default_color>
<r>255</r>
<g>0</g>
@@ -278,7 +278,7 @@
</connections>
<display>false</display>
<creation_date>2022-01-26 16:20:32</creation_date>
- <updated_date>2022-02-16 16:40:38</updated_date>
+ <updated_date>2022-02-16 17:35:01</updated_date>
<model_property>
<name>프로젝트명</name>
<value></value>
@@ -3841,7 +3841,7 @@
<sql>SELECT comtngnrlmber.esntl_id,
 comtngnrlmber.mber_id AS user_id,
 comtngnrlmber.password,
 comtngnrlmber.mber_nm AS user_nm,
 comtngnrlmber.zip AS user_zip,
 comtngnrlmber.adres AS user_adres,
 comtngnrlmber.mber_email_adres AS user_email,
 ' '::bpchar AS group_id,
 'GNR'::text AS user_se,
 ' '::bpchar AS orgnzt_id
 FROM comtngnrlmber
UNION ALL
 SELECT comtnemplyrinfo.esntl_id,
 comtnemplyrinfo.emplyr_id AS user_id,
 comtnemplyrinfo.password,
 comtnemplyrinfo.user_nm,
 comtnemplyrinfo.zip AS user_zip,
 comtnemplyrinfo.house_adres AS user_adres,
 comtnemplyrinfo.email_adres AS user_email,
 comtnemplyrinfo.group_id,
 'USR'::text AS user_se,
 comtnemplyrinfo.orgnzt_id
 FROM comtnemplyrinfo
UNION ALL
 SELECT comtnentrprsmber.esntl_id,
 comtnentrprsmber.entrprs_mber_id AS user_id,
 comtnentrprsmber.entrprs_mber_password AS password,
 comtnentrprsmber.cmpny_nm AS user_nm,
 comtnentrprsmber.zip AS user_zip,
 comtnentrprsmber.adres AS user_adres,
 comtnentrprsmber.applcnt_email_adres AS user_email,
 ' '::bpchar AS group_id,
 'ENT'::text AS user_se,
 ' '::bpchar AS orgnzt_id
 FROM comtnentrprsmber
 ORDER BY 1;</sql>
<columns>
<normal_column>
- <word_id>72</word_id>
+ <word_id>73</word_id>
<id>null</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -4198,7 +4198,7 @@
<option></option>
<columns>
<normal_column>
- <word_id>141</word_id>
+ <word_id>142</word_id>
<id>0</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -4329,7 +4329,7 @@
<option></option>
<columns>
<normal_column>
- <word_id>141</word_id>
+ <word_id>142</word_id>
<id>3</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -4395,7 +4395,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>128</word_id>
+ <word_id>127</word_id>
<id>5</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -4662,10 +4662,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>
@@ -4684,10 +4684,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>
@@ -4704,7 +4704,7 @@
<normal_column>
<id>12</id>
<referenced_column>94</referenced_column>
- <relation>0</relation>
+ <relation>1</relation>
<description>부모롤</description>
<unique_key_name></unique_key_name>
<logical_name>부모롤</logical_name>
@@ -4738,7 +4738,7 @@
<normal_column>
<id>13</id>
<referenced_column>94</referenced_column>
- <relation>1</relation>
+ <relation>0</relation>
<description>자식롤</description>
<unique_key_name></unique_key_name>
<logical_name>자식롤</logical_name>
@@ -6060,7 +6060,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>73</word_id>
+ <word_id>72</word_id>
<id>48</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -7108,7 +7108,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>73</word_id>
+ <word_id>72</word_id>
<id>77</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -7529,7 +7529,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>88</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -8543,7 +8543,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>111</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -8908,7 +8908,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>120</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -9512,7 +9512,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>135</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -10260,7 +10260,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>73</word_id>
+ <word_id>72</word_id>
<id>156</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -10964,7 +10964,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>175</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -11181,7 +11181,7 @@
<parent_cardinality>1</parent_cardinality>
<reference_for_pk>true</reference_for_pk>
<name>comthemplyrinfochangedtls_emplyr_id_fkey</name>
- <on_delete_action>NO ACTION</on_delete_action>
+ <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>
@@ -11823,7 +11823,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>73</word_id>
+ <word_id>72</word_id>
<id>198</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -12165,7 +12165,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>128</word_id>
+ <word_id>127</word_id>
<id>207</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -12782,7 +12782,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>224</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -13061,7 +13061,7 @@
<option></option>
<columns>
<normal_column>
- <word_id>142</word_id>
+ <word_id>141</word_id>
<id>230</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -13160,7 +13160,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>127</word_id>
+ <word_id>128</word_id>
<id>233</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -13942,6 +13942,10 @@
<id>254</id>
<referenced_column>300</referenced_column>
<referenced_column>300</referenced_column>
+ <referenced_column>300</referenced_column>
+ <referenced_column>300</referenced_column>
+ <relation>13</relation>
+ <relation>13</relation>
<relation>13</relation>
<relation>13</relation>
<description></description>
@@ -14635,7 +14639,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>275</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -15293,7 +15297,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>105</word_id>
+ <word_id>106</word_id>
<id>291</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -16050,7 +16054,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>312</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -16534,7 +16538,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>106</word_id>
+ <word_id>105</word_id>
<id>325</id>
<description></description>
<unique_key_name></unique_key_name>
@@ -17036,7 +17040,7 @@
</sequence>
</normal_column>
<normal_column>
- <word_id>105</word_id>
+ <word_id>106</word_id>
<id>338</id>
<description></description>
<unique_key_name></unique_key_name>
Add a comment
Delete comment
Once you delete this comment, you won't be able to recover it. Are you sure you want to delete this comment?