ID ºÐ¼®±â´Â ½Ã½ºÅÛ¿¡¼ Å×À̺í¿ëÀ¸·Î »ý¼ºÇÑ ½Äº°ÀÚ¸¦ °®´Â Å×ÀÌºí¿¡ ´ëÇÑ ºÐ¼®À» ó¸®ÇÕ´Ï´Ù. ¿©±â¿¡´Â KEYS ¶Ç´Â SUBKEYS Å×ÀÌºí¿¡ µî·ÏµÈ ¸ðµç Å×ÀÌºí ¹× ¿ÀÌ Æ÷ÇԵ˴ϴÙ. ºÐ¼®¿¡´Â µÎ °¡Áö ±¸¼º¿ä¼Ò°¡ ÀÖ½À´Ï´Ù.
ÀÌ ºÐ¼®Àº °íÀ¯ »öÀÎ ºÐ¼® ¶Ç´Â Ư¼º ÆÄÀÏ ½ºÆåÀ» »ç¿ëÇÏ¿© ÇØ´ç ¿ä¼Ò¿¡ ´ëÇÑ XML µ¥ÀÌÅÍÀÇ ÄÁÅÙÃ÷¸¦ ±âº»À¸·Î ÇÕ´Ï´Ù.
ÀÌ´Â °ü·Ã Å×À̺íÀÇ foreign key ¼Ó¼º¿¡ ÀÖ´Â ºÐ¼® ½ºÆåÀ» »ç¿ëÇÏ¿© ¼öÇàµË´Ï´Ù.
MEMBER Å×À̺íÀº ORGENTITY, MBRGRP ¹× USER Å×ÀÌºí¿¡ ´ëÇÑ "½´ÆÛ Ŭ·¡½º"·Î »ç¿ëµË´Ï´Ù. ÀÌ´Â Å×ÀÌºí¿¡ MEMBER Å×À̺íÀÇ ºÎ¼Ó À¯Çü¿¡ ´ëÇÑ foreign key Á¦ÇÑÀÚ°¡ ÀÖÀ» °æ¿ì¿¡ ÂüÁ¶ ¹«°á¼ºÀ» À¯Áöº¸¼öÇÏ´Â µ¥ À¯¿ëÇÑ "is-a" ÆÐÅÏÀ» ÀÛ¼ºÇÕ´Ï´Ù. ±×·¯³ª ¸ðµç MEMBER ºÎ¼Ó À¯ÇüÀÌ °øÅë ±âº» À¯ÇüÀ» °øÀ¯Çϱ⠶§¹®¿¡ ½Äº°ÀÚ´Â ºÎ¼Ó À¯Çü °£¿¡ °íÀ¯ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ´Â ORGENTITY_ID°¡ MBRGRP_ID ¹× USER_ID ¼¼Æ® ³»¿¡¼ °íÀ¯ÇØ¾ß ÇÔÀ» ÀǹÌÇÕ´Ï´Ù. KEYS Å×À̺íÀº ORGENTITY, MBRGRP ¹× USER Å×ÀÌºí¸¸À» ÂüÁ¶ÇÏ¿© À̸¦ ¼öÇàÇÏ¸ç ½Äº°ÀÚ¿¡ ´ëÇØ µ¶Á¡ÀûÀÎ ¹üÀ§¸¦ ÁöÁ¤ÇÕ´Ï´Ù. °¢ ºÎ¼Ó À¯Çü¿¡´Â 1Â÷ ۰¡ ÀÖÀ¸¸ç, °¢°¢ÀÇ 1Â÷ Ű´Â MEMBER Å×À̺í 1Â÷ Ű¿¡ ´ëÇÑ foreign keyÀ̱⵵ ÇÕ´Ï´Ù.
MEMBER ¹× ºÎ¼Ó À¯Çü °£ÀÇ Á¦ÇÑÀÚ·Î ÀÎÇØ MEMBER¿Í ºÎ¼Ó À¯ÇüÀÌ µ¿±âÈµÈ ID¸¦ °¡Áú ¼ö ¾ø´Â »óȲÀÌ ¹ß»ýÇÕ´Ï´Ù. ·Î´õ ÆÐŰÁö¸¦ »ç¿ëÇÏ¿© ORGENTITY, MBRGRP ¹× USER Å×À̺íÀ» ½Ã½ºÅÛÀ¸·Î ·ÎµåÇϱâ À§ÇØ ID ºÐ¼®±â´Â "is-a" ÆÐÅÏÀ» ÀνÄÇϰí À̸¦ ÀûÀýÇÏ°Ô Ã³¸®ÇÕ´Ï´Ù. ´ÙÀ½Àº ID ºÐ¼®±â¿¡ ´ëÇÑ XML ±¸¹®ÀÔ´Ï´Ù.
<ORGENTITY ORGENTITY_ID="@orgAlias" ORGENTITYNAME="Test Org" ORGENTITYTYPE="O"> <ISA> <MEMBER TYPE="O" STATE="1" /> </ISA> </ORGENTITY>
¿©±â¼ ´ÙÀ½°ú °°Àº ±¸¹®ÀÌ »ý¼ºµË´Ï´Ù.
<MEMBER MEMBER_ID="12345" TYPE="O" STATE="1" /> <ORGENTITY ORGENTITY_ID="12345" member ¿ä¼Ò¿Í µ¿±âÈ ORGENTITYNAME="Test Org" ORGENTITYTYPE="O" />
ÀÌ ¹æ¹ýÀ¸·Î ID ºÐ¼®±â´Â <isa> ºÎ¼Ó ¿ä¼Ò¸¦ ó¸®ÇÏ°í µ¿±âÈµÈ ½Äº°ÀÚ¸¦ ÀÛ¼ºÇÕ´Ï´Ù
![]() |