»ç¿ëÀÚ ±×·ì ÀÛ¼º

»ç¿ëÀÚ ±×·ìÀ» ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. 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);

    ¿©±â¼­,
  2. member_id
    »õ »ç¿ëÀÚ ±×·ìÀÇ ±¸¼º¿ø IDÀÔ´Ï´Ù.
    type
    ±¸¼º¿ø À¯ÇüÀÔ´Ï´Ù. ±¸¼º¿ø ±×·ìÀ» ÀÛ¼ºÇϹǷΠÀ¯ÇüÀº 'G'ÀÔ´Ï´Ù
    mbrgrp_id
    ±¸¼º¿ø ±×·ì IDÀÔ´Ï´Ù. À§ÀÇ member_id¿Í µ¿ÀÏÇÕ´Ï´Ù.
    mbrgrpname
    ±¸¼º¿ø ±×·ì À̸§ÀÔ´Ï´Ù.
    owner_id
    ±×·ìÀ» ¼ÒÀ¯ÇÏ´Â ±¸¼º¿øÀÇ À̸§ÀÔ´Ï´Ù. »ç¿ëÀÚ ±×·ìÀÌ »çÀÌÆ® ¼öÁØÀ¸·Î Àû¿ëµÇ¸é ÀÌ °ªÀ» 0À¸·Î ¼³Á¤ÇϽʽÿÀ. ±×·¸Áö ¾ÊÀ¸¸é, ÀÌ »ç¿ëÀÚ ±×·ìÀÌ »ç¿ëµÉ Á¶Á÷ÀÇ orgentity_id·Î ID¸¦ ¼³Á¤ÇØ º¸½Ê½Ã¿À.
    mbrgrptype_id
    ±¸¼º¿ø ±×·ì À¯Çü IDÀÔ´Ï´Ù. »ç¿ëÀÚ ±×·ìÀÇ °æ¿ì, ID À¯ÇüÀº -1ÀÔ´Ï´Ù.
  3. ¸í·É¹®À» È®¾àÇϽʽÿÀ.

°ü·Ã °³³ä

°ü·Ã ŽºÅ©

IBM copyright