Á¶Á÷À» »èÁ¦ÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
- Á¶Á÷ °ü¸® Äֿܼ¡¼ Á¶Á÷À» ÀÛ¼ºÇÑ °æ¿ì
´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
- ÀÛ¼ºÇÑ Á¶Á÷ÀÇ ORGENTITY.ORGENITY_ID¸¦ ãÀ¸½Ê½Ã¿À.
- ORGENTITY Å×À̺í Ç׸ñÀ» »èÁ¦ÇϽʽÿÀ.
- MEMBER.MEMBER_ID=ORGENTITY.ORGENTITY_IDÀÎ MEMBER ÇàÀ» »èÁ¦ÇϽʽÿÀ.
- MBRREL.DESCENDANT_ID=ORGENTITY.ORGENTITY_IDÀÎ ¸ðµç MBRREL ÇàÀ» »èÁ¦ÇϽʽÿÀ.
- ÀçÆÇ¸ÅÀÚ µî·Ï ¸í·ÉÀ» »ç¿ëÇÏ¿© Á¶Á÷À» ÀÛ¼ºÇÑ °æ¿ì
ä¿öÁø 1Â÷ ¹× 2Â÷ µ¥ÀÌÅͺ£À̽º Å×À̺íÀÌ ÀÖ½À´Ï´Ù.
MEMBER Å×À̺íÀº
1Â÷ Á¤º¸¸¦ Ãß°¡ÇÑ µ¥ÀÌÅͺ£À̽º Å×À̺íÀÔ´Ï´Ù. 2Â÷ Å×À̺íÀº ´ÙÀ½°ú °°½À´Ï´Ù.
MBRREL,
MBRROLE,
APRVSTATUS,
USERREG,
ADDRESS ¹×
ADDRBOOK. Á¶Á÷À» »èÁ¦ÇÏ·Á¸é SQL¿¡¼
´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
select users_id from userreg where logonId = <'User Name' entered during registration> delete from member where member_id = <users_id of the new user above><users_id of the new user above> select orgentity_id from orgentity where orgentityname = <'Your organization name' entered during registration> select mbrgrp_id from mbrgrp where owner_id = <orgentity_id above><orgentity_id above> delete from member where member_id = <mbrgrp_id of the mbrgrp above><mbrgrp_id of the mbrgrp above> delete from member where member_id = <orgentity_id from above><orgentity_id from above>
ÁÖ: Á¶Á÷À» »èÁ¦Çϱâ Àü¿¡ °¢ µ¥ÀÌÅͺ£À̽º Å×À̺íÀ» º¸°í »èÁ¦µÉ Á¤º¸¸¦ È®ÀÎÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.