{"id":2764,"date":"2018-02-02T22:52:59","date_gmt":"2018-02-02T13:52:59","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2764"},"modified":"2018-02-02T23:15:27","modified_gmt":"2018-02-02T14:15:27","slug":"db-%eb%aa%a8%eb%8d%b8-%ec%9e%91%eb%8f%84-%ed%91%9c%ec%a4%80","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2764","title":{"rendered":"DB \ubaa8\ub378 \uc791\ub3c4 \ud45c\uc900"},"content":{"rendered":"<div style=\"text-align: justify;\">\n<ol>\n<li><strong> <a href=\"#\ub17c\ub9ac\">\ub17c\ub9ac \ubaa8\ub378\uacfc \ubb3c\ub9ac \ubaa8\ub378\uc758 \uac1c\ub150<\/a><\/strong><\/li>\n<li><strong> <a href=\"#ER\">ER-Win \uad6c\uc870<\/a><\/strong><\/li>\n<li><strong> <a href=\"#TABLE\">TABLE(\ubb3c\ub9ac \ubaa8\ub378)\/ENTITY(\ub17c\ub9ac \ubaa8\ub378) \uc720\ud615\uacfc \ubd84\ub958<\/a><\/strong><\/li>\n<li><strong> <a href=\"#COLUMN\">COLUMN(\ubb3c\ub9ac \ubaa8\ub378)\/ATTRIBUTE(\ub17c\ub9ac \ubaa8\ub378) \uc720\ud615\uacfc \ubd84\ub958<\/a><\/strong><\/li>\n<li><strong><a href=\"#RELATION\">RELATION SHIP\uc758 \uc885\ub958\uc640 \uc720\ud615<\/a><\/strong><\/li>\n<li><strong><a href=\"#SUB\">SUBTYPE<\/a><\/strong><\/li>\n<li><strong><a href=\"#SUBTYPE\">SUBTYPE + TABLE RELATION SHIP<\/a><\/strong><\/li>\n<li><strong><a href=\"#\ud558\ub098\uc758\">\ud558\ub098\uc758 TABLE \ub0b4\uc758 SUBTYPE \uac04\uc758 RELATION SHIP<\/a><\/strong><\/li>\n<li><strong><a href=\"#\ub3d9\uc77c\ud55c\">\ub3d9\uc77c\ud55c \uc18d\uc131\uc744 \uc0c1\uc18d \ubc1b\uc740 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548<\/a><\/strong><\/li>\n<li><strong><a href=\"#\ubd80\ubaa8\uc758\">\ubd80\ubaa8\uc758 KEY\uc911 \uc77c\ubd80 COLUMN\uc744 \ube44\uc0c1\uc18d\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548<\/a><\/strong><\/li>\n<li><strong><a href=\"#PK\uc911\">PRIMARY KEY\uc911 \uc77c\ubd80 COLUMN\uc740 PRIMARY KEY\ub85c \uc0c1\uc18d, \uc77c\ubd80 COLUMN\uc740 \uc77c\ubc18<\/a><\/strong><\/li>\n<\/ol>\n<p><strong><a href=\"#PK\uc911\">COLUMN\uc73c\ub85c \uc0c1\uc18d\ud558\ub294 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548<\/a><\/strong><\/p>\n<ol start=\"12\">\n<li><strong><a href=\"#PK\uac00\">PRIMARY KEY\uac00 \uc544\ub2cc \uc77c\ubc18 COLUMN\uc774 \uc0c1\uc18d\ub418\ub294 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548<\/a><\/strong><\/li>\n<\/ol>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 12pt;\"><strong><br \/>\n<\/strong><\/span><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"\ub17c\ub9ac\"><\/a>\ub17c\ub9ac \ubaa8\ub378\uacfc \ubb3c\ub9ac \ubaa8\ub378\uc758 \uac1c\ub150<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">LOGICAL DATA MODEL<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 16pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">&#8211; \ub17c\ub9ac \ubaa8\ub378\uc740 \uc5c5\ubb34\ub97c \uc9c0\uc6d0\ud558\ub294\ub370 \ud544\uc694\ud55c \uc815\ubcf4\uc640 \uc5c5\ubb34\uaddc\uce59\uc744 \ud45c\ud604\ud55c \uac83\uc73c\ub85c\uc11c \ubb3c\ub9ac\uc801\uc778 \uc2a4\ud0a4\ub9c8 \uc124\uacc4\ub97c \ud558\uae30 \uc704\ud55c \uc804 \ub2e8\uacc4\uc758 \ub370\uc774\ud130 \ubaa8\ub378 \uc0c1\ud0dc\ub97c \uc758\ubbf8\ud558\uba70 \uadf8\uac83\uc740 DBMS\uc640\ub294 \ub3c5\ub9bd\uc801\uc73c\ub85c \ud45c\ud604\uc774 \uac00\ub2a5\ud558\ub2e4.<br \/>\n<\/span><\/p>\n<\/li>\n<\/ul>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">PHYSICAL DATA MODEL<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 19pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">&#8211; \ubb3c\ub9ac \ubaa8\ub378\uc740 \uc124\uacc4\uc640 \uad6c\ucd95 \uc0ac\uc774\uc5d0\uc11c \uc0dd\uc131\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130 \uad6c\uc870, \uc989 \ub17c\ub9ac \ubaa8\ub378\uc744 \ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc124\uacc4\ud568\uc73c\ub85c\uc368 \uc0dd\uc131\ub41c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \ubb3c\ub9ac\uc801\uc778 \uc2a4\ud0a4\ub9c8\ub97c \uc758\ubbf8\ud558\uba70 \uc704\uc758 \ub17c\ub9ac\uc801\uc778 \ub2e8\uacc4\uc5d0\uc11c \uc7a0\uc2dc \ubc30\uc81c\ud574 \ub450\uc5c8\ub358 \ubb3c\ub9ac\uc801(\ud604\uc2e4\uc801) \uc694\uac74\uc744 \uac10\uc548\uc2dc\ud0a4\ub294 \ubaa8\ub378\ub9c1 \ub2e8\uacc4\ub97c \ub9d0\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<\/li>\n<\/ul>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"ER\"><\/a>ER-Win \uad6c\uc870<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">LIBRARY -&gt; MODEL -&gt; SUBJECT AREAS<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">&#8211; MAIN SUBJECT AREA<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; \uc5c5\ubb34\uc601\uc5ed\uba85_MAIN(SUBTYPE\uc740 1 LEVEL\uae4c\uc9c0\ub9cc \ud45c\ud604\ud568)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; \uc77c\ubc18\ud654\uad00\uacc4(SUBTYPE\uc774 M LEVEL\uc778 \uac83\uc744 \ud45c\ud604\ud568)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; \uadf8 \uc678\uc758 \ud14c\uc774\ube14<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> \uc704\uc640 \uac19\uc740 \uc21c\uc11c\uc758 \uacc4\uce35\uad6c\uc870\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 44pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">2) WISE \uc2dc\uc2a4\ud15c\ub0b4\uc758 HC, MAF, GR\ub85c \uad6c\uc131\ub41c MPS\uc5c5\ubb34\ub85c \uc608\ub97c \ub4e0\ub2e4\uba74 \uad6c\uc870\ub3c4\ub294 \uc544\ub798\uc640 \uac19\ub2e4<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">EX) LIBRARY(WISE) -&gt; MODEL(MPS) -&gt; SUBJECT AREAS<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">&#8211; MAIN SUBJECT AREA(MPS \uc804\uccb4 ERD)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; HC_MAIN<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; MAFHC_MAIN<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; GR_MAIN<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; HC_SUBTYPE<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; MAF_SUBTYPE<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; GRHC_SUBTYPE<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 40pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> &#8211; \uadf8 \uc678\uc758 \ud14c\uc774\ube14<br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><span style=\"font-size: 12pt;\"><a name=\"TABLE\"><\/a>TABLE(\ubb3c\ub9ac \ubaa8\ub378)\/ENTITY(\ub17c\ub9ac \ubaa8\ub378) <\/span><span style=\"font-size: 14pt;\">\uc720\ud615\uacfc \ubd84\ub958<br \/>\n<\/span><\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">(1) \ub17c\ub9ac \ubaa8\ub378<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">1) NORMAL : \uc77c\ubc18. Normal\ud55c Entity\ub97c \uc758\ubbf8<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB1.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"> 2) PSEUDO : \uac00\uc0c1. \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 Entity\ub97c \ud544\uc694\uc5d0 \uc758\ud574\uc11c \uac00\uc0c1\uc73c\ub85c \uc0dd\uc131\ud55c Entity<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<span style=\"color: blue;\">TABLE\uba85 + [\uac00\uc0c1] \u2013 LOGICAL ONLY<br \/>\n<\/span><\/span><\/p>\n<p style=\"margin-left: 22pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB2.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">3) Additional : \ucd94\uac00. \ubbf8\ub798\uc5d0 \ubc1c\uc0dd\ud574\uc57c \ud560 Entity\ub97c \uac00\uc0c1\uc73c\ub85c \uc0dd\uc131\ud55c Entity<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"color: blue;\">TABLE\uba85 + [\ucd94\uac00] \u2013 LOGICAL ONLY<\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB3.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">4) External : \uc678\ubd80. \ud0c0 \uc2dc\uc2a4\ud15c\uc5d0 \uc874\uc7ac\ud558\ub294 Entity\ub97c \ucc38\uc870 \uc2dc\uc5d0 \uc0ac\uc6a9<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<span style=\"color: blue;\">TABLE\uba85 + [\uc678\ubd80]<\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB4.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">5) \ubbf8\uc0ac\uc6a9 : \uc81c\uac70. \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 Entity.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<span style=\"color: blue;\">TABLE\uba85 + [\ubbf8\uc0ac\uc6a9]<br \/>\n<\/span><\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB5.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">6) \ud604\ud589\ud654 \uc548\ub428: Conversion \ub300\uc0c1\uc5d0\ub294 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc9c0\ub9cc Relation Ship\uc744 \uac16\ub294 Entity<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"color: blue;\">TABLE\uba85 + [\ud604\ud589\ud654\uc548\ub428]<\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB6.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">7) \ubcf5\uc0ac : \ubcf5\uc0ac. \ud0c0\uc5c5\ubb34\uc601\uc5ed\uc774 Owner Ship\uc744 \uac00\uc9c0\uace0 \uc788\uc73c\ub098 \ub04c\uc5b4\ub2e4 \uc0ac\uc6a9\ud568.<span style=\"color: blue;\"><br \/>\n<\/span><\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"color: blue; font-family: \uad74\ub9bc\uccb4;\">TABLE\uba85 + [\uc5c5\ubb34\uc601\uc5ed \uba85 + \ubcf5\uc0ac]<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB7.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">8) \ubcf5\uc0ac : \ubcf5\uc81c\uc758 \uc758\ubbf8. ERD\uac00 \ubcf5\uc7a1\ud558\uc5ec \ub3d9\uc77c \uc5c5\ubb34\uc601\uc5ed\ub0b4\uc758 \ub3d9\uc77c Entity\ub97c \ubcf5\uc81c\ud558\uc5ec \uc0ac\uc6a9<span style=\"color: blue;\"><br \/>\n<\/span><\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"color: blue; font-family: \uad74\ub9bc\uccb4;\">TABLE\uba85 + [\ubcf5\uc0ac]<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB8.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-family: \uad74\ub9bc;\">\u203b<\/span><span style=\"font-family: \uad74\ub9bc\uccb4;\"> Entity\uc758 \ubd84\ub958 \ubc0f \uc720\ud615 \uc124\uc815\ud558\uae30<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 110pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">-&gt; ER-Win \ubaa8\ub378\uc758 Entity\ub97c \uc9c0\uc815\ud558\uace0 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba70 Entity Properties\ub97c \uc120\ud0dd\ud558\uc5ec UDP \uae30\ub2a5(LIST BOX)\uc744 \ud65c\uc6a9\ud558\uc5ec Entity\uc758 \ubd84\ub958 \ubc0f \uc720\ud615\uc744 \uc544\ub798\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 \uc124\uc815\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB9.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB10.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"> (2) \ubb3c\ub9ac \ubaa8\ub378<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">1) NORMAL : \uc77c\ubc18. Normal\ud55c TABLE\uc744 \uc758\ubbf8<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB11.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"> 2) External : \uc678\ubd80. \ud0c0 \uc2dc\uc2a4\ud15c\uc5d0 \uc874\uc7ac\ud558\ub294 Entity\ub97c \ucc38\uc870 \uc2dc\uc5d0 \uc0ac\uc6a9<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<span style=\"color: blue;\">TABLE\uba85 + _\uc678\ubd80_<\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB12.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">3) \ubcf5\uc0ac : \ubcf5\uc0ac. \ud0c0 \uc5c5\ubb34\uc601\uc5ed\uc774 OWNER SHIP\uc744 \uac00\uc9c0\uace0 \uc788\uc73c\ub098 \ub04c\uc5b4\ub2e4 \uc0ac\uc6a9\ud568.<span style=\"color: blue;\"><br \/>\n<\/span><\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"color: blue; font-family: \uad74\ub9bc\uccb4;\">TABLE\uba85 + _\uc5c5\ubb34\uc601\uc5ed \uba85 + \ubcf5\uc0ac_<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB13.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">4) \ubcf5\uc0ac : \ubcf5\uc81c\uc758 \uc758\ubbf8. ERD\uac00 \ubcf5\uc7a1\ud558\uc5ec \ub3d9\uc77c \uc5c5\ubb34\uc601\uc5ed\ub0b4\uc758 \ub3d9\uc77c TABLE\uc744 \ubcf5\uc81c\ud558\uc5ec \uc0ac\uc6a9<span style=\"color: blue;\"><br \/>\n<\/span><\/span><\/p>\n<p style=\"margin-left: 22pt;\"><span style=\"color: blue; font-family: \uad74\ub9bc\uccb4;\">TABLE\uba85 + _\ubcf5\uc0ac_<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 66pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB14.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u203b TABLE\uc758 \uc720\ud615<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 88pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">-&gt; UDP\ub97c \ud65c\uc6a9\ud558\uc5ec \uc720\ud615\uc744 \uc124\uc815\ud558\uc9c0 \uc54a\uace0 TABLE\uba85\uc5d0 \uc704\uc758 \uaddc\uce59\uc73c\ub85c\ub9cc \ud45c\ud604\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u203b I\/F TYPE<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 88pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">-&gt; \uc11c\ub85c \ub2e4\ub978 \uc8fc\uc81c\uc601\uc5ed\uc758 RELATION SHIP\uc5d0\uc11c TABLE\uc744 \uac00\uc838\ub2e4 \uc0ac\uc6a9\ud560 \uacbd\uc6b0\uc5d0 \ud574\ub2f9 TABLE\uc758<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"> \uc8fc\uc81c\uc601\uc5ed\uc744 \uba85\uc2dc\ud558\uae30 \uc704\ud55c \uae30\ub2a5\uc73c\ub85c UDP\uc5d0 I\/F TYPE\uc774\ub77c\ub294 \ud56d\ubaa9\uba85\uc73c\ub85c MASTER\uc778\uc9c0<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 88pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> \uc544\ub2cc\uc9c0\ub97c \uad6c\ubd84\ud55c\ub2e4. <span style=\"background-color: silver;\">(PHYSICAL ONLY)<\/span><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><span style=\"font-size: 12pt;\"><a name=\"COLUMN\"><\/a>COLUMN(\ubb3c\ub9ac \ubaa8\ub378)\/ATTRIBUTE(\ub17c\ub9ac \ubaa8\ub378)<\/span><span style=\"font-size: 14pt;\"> \uc720\ud615<br \/>\n<\/span><\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p style=\"margin-left: 18pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> (1) \ub17c\ub9ac \ubaa8\ub378<br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc77c\ubc18 Primary Key<br \/>\n<\/span><\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">Primary Key \uc911 \ube44\uc0c1\uc18d \uc18d\uc131 : \ub17c\ub9ac \ubaa8\ub378\uc5d0\uc11c\ub294 \uc18d\uc131\uba85 + &#8216;*$&#8217;\uc73c\ub85c \ud45c\ud604\ud55c\ub2e4<br \/>\n<\/span><\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">Not Null \uc18d\uc131<br \/>\n<\/span><\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc18d\uc131\uc720\ud615<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 1pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2460 Normal : \uc77c\ubc18<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 1pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2461 Derived : \ucd94\ucd9c\uc18d\uc131(source \ud14c\uc774\ube14\uacfc \uc18d\uc131\uc744 \uba85\uae30\ud55c\ub2e4.)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 1pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2462 Pseudo : \uac00\uc0c1\uc18d\uc131(\uc2e4\uc81c\ub85c \uc18d\uc131\uc774 \uc874\uc7ac\ud558\uc9c0\ub294 \uc54a\ub294\ub2e4.)<span style=\"background-color: silver;\">(LOGIAL ONLY)<\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 1pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2463 Additional : \ucd94\uac00\uc18d\uc131(\ubbf8\ub798\uc5d0 \uc608\uc0c1\ub418\ub294 \ucd94\uac00 \uc18d\uc131\uc774\ub2e4.) <span style=\"background-color: silver;\">(LOGIAL ONLY)<\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 1pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2464 Drop : \ubbf8\uc0ac\uc6a9\uc73c\ub85c DROP \uc608\uc0c1\uc18d\uc131\uc774\uba70 \uc18c\ubb38\uc790 &#8216;x&#8217;\ub85c \ud45c\ud604\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 1pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2465 System : WISE SYSTEM\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc18d\uc131\uc73c\ub85c \ubaa8\ub4e0 ENTITY\uc5d0 \uc874\uc7ac\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\ub17c\ub9ac \ubaa8\ub378\uc758 \uc18d\uc131\uc720\ud615\uc740 Attribute + * + \uc18c\ubb38\uc790 \uc601\ubb38<br \/>\n<\/span><\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB15.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<\/strong><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc;\">\u203b<\/span><span style=\"font-family: \uad74\ub9bc\uccb4;\"> \uc18d\uc131\uc758 \uc720\ud615 \uc124\uc815\ud558\uae30<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 92pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">-&gt; ER-Win \ubaa8\ub378\uc758 \uc18d\uc131\uc744 \uc9c0\uc815\ud558\uace0 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba70 ATTRIBUTES\uc758 UDP \uae30\ub2a5(LIST BOX)\uc744 \ud65c\uc6a9\ud558\uc5ec \uc18d\uc131\uc758 \uc720\ud615\uc744 \uc544\ub798\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 \uc124\uc815\ud55c\ub2e4<br \/>\n<\/span><\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB16.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB17.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">(2) \ubb3c\ub9ac \ubaa8\ub378<span style=\"color: red;\"><strong><br \/>\n<\/strong><\/span><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc;\">\u203b<\/span><span style=\"font-family: \uad74\ub9bc\uccb4;\"> COLUMN\uc758 \uc720\ud615 \ubc0f \ube44\uc0c1\uc18d\uc5ec\ubd80 \uc124\uc815\ud558\uae30<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 92pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">-&gt; \uac01\uac01\uc758 \uc720\ud615\ubcc4\ub85c \uc0c9\uc0c1\uc744 \uc9c0\uc815\ud558\uc5ec \uad6c\ubd84\ud558\uba70 \ube44\uc0c1\uc18d\uc758 \uacbd\uc6b0\uc640 COLUMN\uc758 \uc720\ud615\uc740 ER-Win<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 92pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\ubaa8\ub378\uc758 \uc18d\uc131\uc744 \uc9c0\uc815\ud558\uace0 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba70 COLUMNS\uc758 UDP \uae30\ub2a5(LIST BOX)\uc744 \ud65c\uc6a9(\ube44\uc0c1\uc18d\uc5ec\ubd80\uc640 \uc18d\uc131\uc720\ud615)\ud558\uc5ec \uc544\ub798\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 \uc124\uc815\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">1) \uc720\ud615<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 60pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2460 Normal : \uc77c\ubc18\uc801\uc778 TABLE<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 60pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2461 Derived : \ucd94\ucd9c\uc18d\uc131(source TABLE\uacfc COLUMN\uc744 \uba85\uae30\ud55c\ub2e4.)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 60pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2462 Drop : \ubbf8\uc0ac\uc6a9\uc73c\ub85c \uc778\ud558\uc5ec \ucd94\ud6c4\uc5d0 \uc81c\uac70\uac00 \uc608\uc0c1\ub418\ub294 COLUMN\uc774\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 60pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2463 System : WISE SYSTEM\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 COLUMN\uc73c\ub85c \ubaa8\ub4e0 TABLE\uc5d0 \uc874\uc7ac\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB18.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB19.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<\/strong><\/span><\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"RELATION\"><\/a>RELATION SHIP\uc758 \uc885\ub958\uc640 \uc720\ud615<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong>\uc885\ub958<br \/>\n<\/strong><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">(1) \ub17c\ub9ac \ubaa8\ub378<br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">1:1 \uad00\uacc4 -&gt; \ubd80\ubaa8\uc758 PK\uac00 \uc790\uc2dd\uc758 PK\ub85c \uc0c1\uc18d\ub418\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB20.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">1:1 \uad00\uacc4 -&gt; \ubd80\ubaa8\uc758 PK\uac00 \uc790\uc2dd\uc758 \uc77c\ubc18\uc18d\uc131\uc73c\ub85c \uc0c1\uc18d\ub418\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB21.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">1:M \uad00\uacc4 -&gt; \ubd80\ubaa8\uc758 PK\uac00 \uc790\uc2dd\uc758 PK\ub85c \uc0c1\uc18d\ub418\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB22.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">1:M \uad00\uacc4 -&gt; \ubd80\ubaa8\uc758 PK\uac00 \uc790\uc2dd\uc758 \uc77c\ubc18\uc18d\uc131\uc73c\ub85c \uc0c1\uc18d\ub418\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB23.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">M:M \uad00\uacc4<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB24.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">Exclusive : arc \uad00\uacc4\ub294 \uadf8\ub9bc\uc73c\ub85c \ud45c\ud604<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB25.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB26.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB27.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 88pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong>\uc720\ud615 : <\/strong>UDP \ud56d\ubaa9\uc73c\ub85c \uad00\ub9ac\ud558\uba70 \uad00\uacc4\uc758 UDP \ud56d\ubaa9 \uc911 \uad00\uacc4 \uc720\ud615\uc5d0 \ud45c\uae30<strong><br \/>\n<\/strong>\uad00\uacc4\uc120 \uc704\uc5d0 \ub300\ubb38\uc790 \uccab\uc790\ub9ac \ud45c\uae30, \uc0c9\uc0c1\uc740 \ud30c\ub780\uc0c9, FONT\ub294 \uad75\uac8c \ud45c\ud604\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"background-color: silver;\">\u2460<\/span> NORMAL : \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 RELATION SHIP\uc758 \ud45c\ud604<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">EX)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"background-color: silver;\">\u2461<\/span> BETWEEN : \ud55c \uac1c\uccb4\uc640 \uadf8 \uac1c\uccb4\ub97c \ud3ec\ud568\ud558\ub294 \uadf8\ub8f9\uac04\uc758 RELATION SHIP\uc758 \ud45c\ud604<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 66pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB28.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 176pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"background-color: silver;\">\u2462<\/span> LIKE : \uc18d\uc131\uc774 \uc6d0\uc790\uc801\uc778 \ud2b9\uc131\uc744 \uac16\uc9c0 \ubabb\ud558\uace0 \ud63c\ud569\ub41c \ud615\ud0dc\ub77c \ud560\uc9c0\ub77c\ub3c4 \uc758\ubbf8\uc801\uc73c\ub85c \ub610\ub294 \uac00\uacf5\uc744 \ud1b5\ud574\uc11c \uc5f0\uacb0\uc774 \uac00\ub2a5\ud55c RELATION SHIP\uc758 \ud45c\ud604<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 66pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"> EX) <img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB29.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 181pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"background-color: silver;\">\u2463<\/span> PSEUDO : UID\uac00 \uc544\ub2cc \uc77c\ubc18\uc18d\uc131\uacfc\uc758 \ub17c\uc758\uc801\uc778 \uc5f0\uacb0 \ub610\ub294 \uac00\uc0c1 ENTITY\uc640\uc758 \uc5f0\uacb0\uc744 \ud45c\ud604<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 66pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB30.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 187pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"background-color: silver;\">\u2464<\/span> DERIVED : \uc2e4\uc81c\ub85c\ub294 1\ucd0c \uc774\uc0c1 \ub5a8\uc5b4\uc838 \uc788\ub294 \uac04\uc811\uc801\uc778 \uad00\uacc4\ub97c \ub9c8\uce58 \uc9c1\uc811\uc801\uc778 \uad00\uacc4\uc778 \uac83\ucc98\ub7fc \ud45c\ud604<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">EX) <img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB31.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">(2) \ubb3c\ub9ac \ubaa8\ub378<span style=\"color: red;\"><strong><br \/>\n<\/strong><\/span><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc;\">\u203b<\/span><span style=\"font-family: \uad74\ub9bc\uccb4;\"> \ubb3c\ub9ac \ubaa8\ub378\uc758 \uacbd\uc6b0\ub294 NORMAL\uc744 \uc81c\uc678\ud55c \ubaa8\ub4e0 CASE\ub294 \ud45c\ud604\ud558\uc9c0 \uc54a\ub294\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u203b COLUMN ORDER<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">-&gt; ER-Win\uc5d0 \ud45c\ud604\ub418\uc5b4 \uc788\ub294 PK \uad6c\uc131\uceec\ub7fc\uc758 \uc21c\uc11c\uc640 \uc2e4\uc81c\uc758 DBMS\uc0c1\uc758 PK \uad6c\uc131\uceec\ub7fc\uc758 \uc21c\uc11c\uac00<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"> \ub2e4\ub97c \uc218 \uc788\uc73c\ubbc0\ub85c DBMS\ub97c \uae30\uc900\uc73c\ub85c UDP\ub97c \ud65c\uc6a9\ud558\uc5ec \uc21c\uc11c\ub97c \uc9c0\uc815\ud55c\ub2e4. <span style=\"background-color: silver;\">(PHYSICAL ONLY)<\/span><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"SUB\"><\/a>SUBTYPE<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uac04\ub2e8\ud55c Subtype<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"> MAIN\uc5d0\ub294 1LEVLE SUBTYPE\ub9cc \ud45c\ud604\ud558\uace0, M LEVEL SUBTYPE\uc740 SUBTYPE SUBJECT AREA\uc5d0 \ud45c\ud604<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 44pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB32.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 58pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\ubcf5\uc7a1\ud55c Subtype<br \/>\n<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">2 LEVEL \uc774\uc0c1 DEPTH\uc758 SUBTYPE\uacfc \ud0c0 \ud14c\uc774\ube14\uacfc\uc758 RELATION SHIP\uc774 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\ub294 1 LEVEL<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 58pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\ubd80\ud130 \uadf8 \uc0ac\uc774 LEVEL\uc758 SUBTYPE\uc740 \uc0dd\ub7b5\uc744 \ud55c \ucc44 MAIN SUBJECT AREA\uc5d0 \ud45c\ud604\ud558\uba70 \uc804\uccb4\uc5d0 \ub300\ud55c \uadf8\ub9bc\uc740 \uc704\uc5d0\uc11c \ud45c\ud604\ud55c \ubc14\uc640 \uac19\uc774 SUBTYPE SUBJECT AREA\uc5d0 \uadf8\ub9b0\ub2e4.<br \/>\n<\/span><\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB33.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"SUBTYPE\"><\/a>SUBTYPE\uacfc ENTITY\uac04\uc758 RELATION SHIP<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB34.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB35.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"\ud558\ub098\uc758\"><\/a>\ud558\ub098\uc758 ENTITY\ub0b4\uc758 SUBTYPE\uac04 RELATION SHIP<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB36.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB37.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB38.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><br \/>\n<\/strong><\/span><\/p>\n<ul style=\"margin-left: 40pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"\ub3d9\uc77c\ud55c\"><\/a>\ub3d9\uc77c\ud55c \uc18d\uc131\uc744 \uc0c1\uc18d\ud558\ub294 \uacbd\uc6b0\uc758 \ucc98\ub9ac \ubc29\uc548<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB39.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB40.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB41.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 20pt;\"><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong>\ucc98\ub9ac\ubc29\uc548<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 20pt;\"><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong>Alternate Key(\ub300\uccb4\ud0a4)\uc640 Role Name\uc744 \ud65c\uc6a9\ud558\uc5ec \ucc98\ub9ac\ud568<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc704\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 \ud14c\uc774\ube14, SEGMENT_DEFINITION\uc758 \uc77c\ubc18\uc18d\uc131, SEGMENT_NO\ub97c \ud14c\uc774\ube14, PERIOD\uac00 \uae30\uc874<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc758 \uc18d\uc131\uba85\uce6d\uc774 \uc544\ub2cc \uc77c\ubc18\uc18d\uc131\uc73c\ub85c \uc0c1\uc18d\uc744 \ubc1b\uace0\uc790 \ud560 \uacbd\uc6b0\uc5d0\ub294 \ud14c\uc774\ube14, SEGMENT_DEFINITION\uc758<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc77c\ubc18\uc18d\uc131, SEGMENT_NO\ub97c \ub300\uccb4\ud0a4(Alternate Key)\ub85c \uc120\uc5b8\ud55c \ud6c4\uc5d0 Relation Ship\uc744 \uac16\ub294\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong>Alternate Key<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 18pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB42.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"color: red;\"><strong>Role Name<\/strong><\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB43.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong>10. <a name=\"\ubd80\ubaa8\uc758\"><\/a>\ubd80\ubaa8\uc758 \ud0a4 \uc911 \uc77c\ubd80 \uc18d\uc131\uc740 \ube44\uc0c1\uc18d\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548<br \/>\n<\/strong><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2460 PERIOD_SET\uc758 PK \uad6c\uc131\uc18d\uc131\uc774\uba74\uc11c \ube44\uc0c1\uc18d \uc18d\uc131\uc774 \uc874\uc7ac\ud568<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2461 1:M \uad00\uacc4\ub97c \uac16\uace0, PERIOD_SET_CODE\ub9cc \uc0c1\uc18d\ud558\uba70 EFFECTIVE_DATE\ub294 \uc0c1\uc18d\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2462 PERIOD_NAME\uc758 PK\ub294 PERIOD_SET_CODE + PERIOD_VALUE_CODE + EFFECTIVE_DATE\ub85c \uad6c\uc131<br \/>\n<\/span><\/p>\n<p><span style=\"color: blue; font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB44.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong>\ucc98\ub9ac\ubc29\uc548<br \/>\n<\/strong><\/span><\/p>\n<p><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong>Alternate Key(\ub300\uccb4\ud0a4)\ub97c \ud65c\uc6a9\ud558\uc5ec \ucc98\ub9ac\ud568<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc704\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 \ud14c\uc774\ube14, PERIOD SET\uc758 PK \uad6c\uc131\uc18d\uc131 \uc911\uc5d0 \uc720\ud6a8\uc77c\uc790\ub294 \ube44\uc0c1\uc18d \uc18d\uc131\uc774\ubbc0\ub85c \ubcf8 \uc18d<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc131\uc744 \uc81c\uc678\ud55c PK \uad6c\uc131\uc18d\uc131\uc73c\ub85c \ub300\uccb4\ud0a4(Alternate Key)\ub97c \uc120\uc5b8\ud55c \ud6c4\uc5d0 Relation Ship\uc744 \ub9fa\uc73c\uba70 \uc774<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\ub54c Relation\uc740 UID\uc758 \uc0c1\uc18d\uc774 \uc544\ub2cc \uc77c\ubc18\uc18d\uc131\uc758 \uc0c1\uc18d\uc73c\ub85c \uc5f0\uad00\uc744 \ub9fa\ub294\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc704\uc758 \uc791\uc5c5 \ud6c4\uc5d0 M\ucabd \ud14c\uc774\ube14\uc758 PK\ub85c \uc0c1\uc18d\ud558\ub294 \uc18d\uc131\uc740 \uc778\uc704\uc801\uc73c\ub85c \ud574\ub2f9 \uc18d\uc131\uc744 PK\ub808\ubca8\ub85c \uc62c\ub824\uc900\ub2e4.<br \/>\n<\/span><\/p>\n<ol style=\"margin-left: 41pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><a name=\"PK\uc911\"><\/a> PK\uc911 \uc77c\ubd80\uc18d\uc131\uc740 PK\ub85c, \uc77c\ubd80\uc18d\uc131\uc740 \uc77c\ubc18\uc18d\uc131\uc73c\ub85c \uc0c1\uc18d\ud558\ub294 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ol>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2460 PERIOD_NAME\uc758 PK\ub294 PERIOD_SET_CODE + EFFECTIVE_DATE<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2461 1:M \uad00\uacc4, \uc0c1\uc18d\uc740 PERIOD_SET_CODE\ub294 PK\ub85c EFFECTIVE_DATE\ub294 \uc77c\ubc18\uc18d\uc131\uc73c\ub85c \ud45c\ud604<span style=\"color: blue;\"><br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2462 PERIOD\uc758 PK\ub294 PERIOD_SET_CODE + DAY_NUMBER + FROM_HOUR\ub85c \uad6c\uc131<br \/>\n<\/span><\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB45.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<\/strong><\/span><\/p>\n<p><span style=\"color: red; font-family: \uad74\ub9bc\uccb4;\"><strong>\ucc98\ub9ac\ubc29\uc548<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc704\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 \ud14c\uc774\ube14, PERIOD NAME\uc758 PK \uad6c\uc131\uc18d\uc131 \uc911\uc5d0 PERIOD_SET_CODE\ub294 PK\ub85c,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">EFFECTIVE_DATE\ub294 \uc77c\ubc18\uc18d\uc131\uc73c\ub85c \uc0c1\uc18d\ub418\ub294 \uacbd\uc6b0\uc774\uba70 \uc774 \ub54c Relation Ship\uc740 UID\uc758 \uc0c1\uc18d\uc774 \uc544\ub2cc<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc77c\ubc18\uc18d\uc131\uc758 \uc0c1\uc18d\uc73c\ub85c \uc5f0\uad00\uc744 \ub9fa\ub294\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 33pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc704\uc758 \uc791\uc5c5 \ud6c4\uc5d0 M\ucabd \ud14c\uc774\ube14\uc758 PK\ub85c \uc0c1\uc18d\ud558\ub294 \uc18d\uc131\uc740 \uc778\uc704\uc801\uc73c\ub85c \ud574\ub2f9 \uc18d\uc131\uc744 PK\ub808\ubca8\ub85c \uc62c\ub824\uc900\ub2e4.<br \/>\n<\/span><\/p>\n<ol style=\"margin-left: 41pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \uad74\ub9bc\uccb4; font-size: 14pt;\"><strong><br \/>\n<a name=\"PK\uac00\"><\/a>PK\uac00 \uc544\ub2cc \uc77c\ubc18\uc18d\uc131\uc774 \uc0c1\uc18d\ub418\ub294 \uacbd\uc6b0 \ucc98\ub9ac\ubc29\uc548<br \/>\n<\/strong><\/span><\/div>\n<\/li>\n<\/ol>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\u2460 \uc77c\ubc18\uc18d\uc131\uc73c\ub85c \uc0c1\uc18d\uc744 \ubc1b\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB46.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<span style=\"color: red;\">\ucc98\ub9ac\ubc29\uc548<br \/>\n<\/span><\/strong><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<span style=\"color: red;\">Alternate Key(\ub300\uccb4\ud0a4)\ub97c \ud65c\uc6a9\ud558\uc5ec \ucc98\ub9ac\ud568<br \/>\n<\/span><\/strong><\/span><\/p>\n<p style=\"margin-left: 66pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc704\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 TABLE01\uc758 \uc77c\ubc18\uc18d\uc131, PERIOD_CODE\ub97c \ub300\uccb4\ud0a4(Alternate Key)\ub85c \uc120\uc5b8\ud55c \ud6c4\uc5d0 Relation Ship\uc744 \ub9fa\uc73c\uba70 \uc774\ub54c Relation Ship\uc740 UID\uc758 \uc0c1\uc18d\uc774 \uc544\ub2cc \uc77c\ubc18\uc18d\uc131\uc758 \uc0c1\uc18d<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 66pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc73c\ub85c \uc5f0\uad00\uc744 \ub9fa\ub294\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><span style=\"font-size: 9pt;\"><strong><br \/>\n<\/strong><\/span>\u2461 PK\ub85c \uc0c1\uc18d\uc744 \ubc1b\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020218_1347_DB47.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 18pt;\"><span style=\"font-family: \uad74\ub9bc\uccb4;\"><br \/>\n<span style=\"color: red;\"><strong>\ucc98\ub9ac\ubc29\uc548<br \/>\n<\/strong><\/span><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\"><strong><br \/>\n<span style=\"color: red;\">Alternate Key(\ub300\uccb4\ud0a4)\ub97c \ud65c\uc6a9\ud558\uc5ec \ucc98\ub9ac\ud568<br \/>\n<\/span><\/strong><\/span><\/p>\n<p><span style=\"font-family: \uad74\ub9bc\uccb4;\">\uc704\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 TABLE01\uc758 \uc77c\ubc18\uc18d\uc131, PERIOD_CODE\ub97c \ub300\uccb4\ud0a4(Alternate Key)\ub85c \uc120\uc5b8\ud55c \ud6c4\uc5d0 Relation Ship\uc744 \ub9fa\uc73c\uba70 \uc774\ub54c Relation Ship\uc740 UID\uc758 \uc0c1\uc18d\uc73c\ub85c \uc5f0\uad00\uc744 \ub9fa\ub294\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub17c\ub9ac \ubaa8\ub378\uacfc \ubb3c\ub9ac \ubaa8\ub378\uc758 \uac1c\ub150 ER-Win \uad6c\uc870 TABLE(\ubb3c\ub9ac \ubaa8\ub378)\/ENTITY(\ub17c\ub9ac \ubaa8\ub378) \uc720\ud615\uacfc \ubd84\ub958 COLUMN(\ubb3c\ub9ac \ubaa8\ub378)\/ATTRIBUTE(\ub17c\ub9ac \ubaa8\ub378) \uc720\ud615\uacfc \ubd84\ub958 RELATION SHIP\uc758 \uc885\ub958\uc640 \uc720\ud615 SUBTYPE SUBTYPE + TABLE RELATION SHIP \ud558\ub098\uc758 TABLE \ub0b4\uc758 SUBTYPE \uac04\uc758 RELATION SHIP \ub3d9\uc77c\ud55c \uc18d\uc131\uc744 \uc0c1\uc18d \ubc1b\uc740 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548 \ubd80\ubaa8\uc758 KEY\uc911 \uc77c\ubd80 COLUMN\uc744 \ube44\uc0c1\uc18d\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uacbd\uc6b0\uc758 \ucc98\ub9ac\ubc29\uc548 PRIMARY KEY\uc911 \uc77c\ubd80 COLUMN\uc740 PRIMARY KEY\ub85c \uc0c1\uc18d, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2499,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[219],"tags":[904,905],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/digital4-300x241.jpg?fit=300%2C241","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2764"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2764"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2764\/revisions"}],"predecessor-version":[{"id":2772,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2764\/revisions\/2772"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2499"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2764"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}