Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡´Â Á¶Á÷ ¿£Æ¼Æ¼¿¡ ´ëÇÑ Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù. Á¶Á÷ ¿£Æ¼Æ¼´Â Á¶Á÷ ¶Ç´Â Á¶Á÷ ºÎ¼ÀÔ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ADMINFIRSTNAME |
VARCHAR (128)
NULL |
ÀÌ orgEntity ¿î¿µÀÚÀÇ À̸§ |
ADMINLASTNAME |
VARCHAR (128)
NULL |
ÀÌ orgEntity ¿î¿µÀÚÀÇ ¼º |
ADMINMIDDLENAME |
VARCHAR (128)
NULL |
ÀÌ orgEntity ¿î¿µÀÚÀÇ Áß°£ À̸§ |
BUSINESSCATEGORY |
VARCHAR (128)
NULL |
ºñÁî´Ï½º Ä«Å×°í¸®. orgentity°¡ ¼öÇàÇÏ´Â ºñÁî´Ï½º Á¾·ù¸¦ ³ªÅ¸³À´Ï´Ù. |
DESCRIPTION |
VARCHAR (512)
NULL |
Á¶Á÷ ¿£Æ¼Æ¼¿¡ ´ëÇÑ ¼³¸í |
DN |
VARCHAR (1000)
NULL |
orgEntityÀÇ ÀÎ½Ä À̸§(DN). LDAP°¡ »ç¿ëµÈ °æ¿ì, LDAP ¼¹öÀÇ DNÀÌ µé¾î ÀÖ½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º°¡ ±¸¼º¿ø ÀúÀå¼Ò·Î »ç¿ëµÈ °æ¿ì, ¸â¹ö½± °èÃþÀÌ Á¤ÀÇÇÑ °íÀ¯ À̸§ÀÌ µé¾î ÀÖ½À´Ï´Ù. ¸ðµç orgEntitiyÀÇ DNÀº °íÀ¯ÇÕ´Ï´Ù. |
FIELD1 |
VARCHAR (64)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD2 |
VARCHAR (64)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD3 |
VARCHAR (64)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
LEGALID |
VARCHAR (128)
NULL |
Á¶Á÷¿¡ ÁÖ¾îÁø(¿¹: Á¤ºÎ°¡ ÁöÁ¤) µî·Ï Á¶Á÷ ½Äº°ÀÚ. Á¶Á÷ ´ÜÀ§ÀÇ °æ¿ì ³Î(Null)°ªÀÏ ¼ö ÀÖ½À´Ï´Ù. ÀÌ´Â ORGENTITYNAME¿¡ ÀúÀåµÇ¾î¾ß ÇÏ´Â Á¶Á÷ÀÇ À̸§Àº ¾Æ´Õ´Ï´Ù. |
MEMBER_ID |
BIGINT
NULL |
ÀÌ ¿¿¡´Â ÀÌ orgEntityÀÇ »óÀ§ orgEntity ±¸¼º¿ø ID°¡ µé¾î ÀÖ½À´Ï´Ù. ÀÌ ¿Àº ´õ ÀÌ»ó »ç¿ëµÇÁö ¾ÊÀ¸¸ç ¿ªÈ£È¯¿ëÀ¸·Î¸¸ Á¦°øµË´Ï´Ù. |
ORGENTITY_ID |
BIGINT
NOT NULL |
ÀÌ Á¶Á÷ ¶Ç´Â ºÎ¼¿¡ ´ëÇÑ MEMBER Å×À̺íÀÇ foreign key. |
ORGENTITYNAME |
VARCHAR (128)
NOT NULL |
Á¶Á÷(O) ¶Ç´Â ºÎ¼(OU)¿¡ ´ëÇÑ Ãà¾àÇü À̸§. ÀÌ À̸§Àº LDAP¿¡¼ Çʼö ¼Ó¼ºÀÎ O ¶Ç´Â OU¿¡ ¸ÊÇεDZ⠶§¹®¿¡ ³ÎÀÌ ¾Æ´Ñ °ªÀÌ ÇÊ¿äÇÕ´Ï´Ù. |
ORGENTITYTYPE |
CHARACTER (3)
NOT NULL |
OrgEntity À¯Çü. ¿Ã¹Ù¸¥ °ª: O(Á¶Á÷), OU(ºÎ¼) |
PREFERREDDELIVERY |
VARCHAR (1000)
NULL |
¼±È£ ¿î¼Û ¹æ¹ý. |
TAXPAYERID |
VARCHAR (254)
NULL |
°ú¼¼¸¦ À§ÇØ orgEntity¸¦ ½Äº°ÇÏ´Â µ¥ »ç¿ëµÇ´Â ¹®ÀÚ¿. ÀÌ ¿ÀÇ Ãß°¡´Â ¼¼±Ý ÅëÇÕ¿¡ ÀÇÇØ Æ®¸®°ÅµÇ³ª, ÀÌ ¿Àº ¼¼±ÝÀÌ ¾Æ´Ñ ´Ù¸¥ ºÎºÐ¿¡µµ À¯¿ëÇÕ´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020713460 | ORGENTITY_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_554 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_555 | ORGENTITY_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_132 | ORGENTITY_ID | BUSPROF | ORG_ID | °è´Ü½Ä |
F_133 | ORGENTITY_ID | BUSPROF | ORGUNIT_ID | °è´Ü½Ä |
F_142 | ORGENTITY_ID | BUYSUPMAP | BUYORGUNIT_ID | °è´Ü½Ä |
F_143 | ORGENTITY_ID | BUYSUPMAP | SUPORG_ID | °è´Ü½Ä |
F_144 | ORGENTITY_ID | BUYSUPSEC | SUPORG_ID | °è´Ü½Ä |
F_145 | ORGENTITY_ID | BUYSUPSEC | BUYORG_ID | °è´Ü½Ä |
F_326 | ORGENTITY_ID | FLOWADMIN | ORGENTITY_ID | °è´Ü½Ä |
F_452 | ORGENTITY_ID | MBRROLE | ORGENTITY_ID | °è´Ü½Ä |
F_513 | ORGENTITY_ID | ORDERS | ORGENTITY_ID | °è´Ü½Ä |
F_553 | ORGENTITY_ID | ORGCODE | ORGENTITY_ID | °è´Ü½Ä |
F_615 | ORGENTITY_ID | PROCBUYPRF | ORGENTITY_ID | °è´Ü½Ä |
F_617 | ORGENTITY_ID | PROCMSGVW | ORGENTITY_ID | °è´Ü½Ä |
F_694 | ORGENTITY_ID | RMA | ORGENTITY_ID | °è´Ü½Ä |
![]() |