»ç¿ëÀÚ ±×·ì ÀÛ¼º
»ç¿ëÀÚ ±×·ìÀ» ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
- DB2¸¦ »ç¿ëÇÑ´Ù¸é, DB2 ¸í·ÉâÀ» ¿©½Ê½Ã¿À. OracleÀ» »ç¿ëÇÑ´Ù¸é,
SQLPlus âÀ» ¿©½Ê½Ã¿À. ´ÙÀ½ SQL ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇϽʽÿÀ.
insert into member (member_id, type) values (500, 'G');
insert into mbrgrp (mbrgrp_id, mbrgrpname, owner_id) values (500, 'NewName', 0);
insert into mbrgrpusg (mbrgrp_id, mbrgrptype_id) values (500, -1);
¿©±â¼,
- member_id
- »õ »ç¿ëÀÚ ±×·ìÀÇ ±¸¼º¿ø IDÀÔ´Ï´Ù.
- type
- ±¸¼º¿ø À¯ÇüÀÔ´Ï´Ù. ±¸¼º¿ø ±×·ìÀ» ÀÛ¼ºÇϹǷΠÀ¯ÇüÀº 'G'ÀÔ´Ï´Ù
- mbrgrp_id
- ±¸¼º¿ø ±×·ì IDÀÔ´Ï´Ù. À§ÀÇ member_id¿Í µ¿ÀÏÇÕ´Ï´Ù.
- mbrgrpname
- ±¸¼º¿ø ±×·ì À̸§ÀÔ´Ï´Ù.
- owner_id
- ±×·ìÀ» ¼ÒÀ¯ÇÏ´Â ±¸¼º¿øÀÇ À̸§ÀÔ´Ï´Ù. »ç¿ëÀÚ ±×·ìÀÌ »çÀÌÆ® ¼öÁØÀ¸·Î Àû¿ëµÇ¸é ÀÌ °ªÀ» 0À¸·Î ¼³Á¤ÇϽʽÿÀ. ±×·¸Áö ¾ÊÀ¸¸é, ÀÌ »ç¿ëÀÚ ±×·ìÀÌ »ç¿ëµÉ Á¶Á÷ÀÇ orgentity_id·Î ID¸¦ ¼³Á¤ÇØ º¸½Ê½Ã¿À.
- mbrgrptype_id
- ±¸¼º¿ø ±×·ì À¯Çü IDÀÔ´Ï´Ù. »ç¿ëÀÚ ±×·ìÀÇ °æ¿ì, ID À¯ÇüÀº -1ÀÔ´Ï´Ù.
- ¸í·É¹®À» È®¾àÇϽʽÿÀ.