Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀº ½Ã½ºÅÛÀÇ ¸ðµç ¾×¼¼½º Á¦¾î Á¤Ã¥À» ÀúÀåÇÕ´Ï´Ù. °¢ Á¤Ã¥Àº Á¤Ã¥ Å×À̺íÀÇ ÇàÀÔ´Ï´Ù. °¢ Á¤Ã¥Àº Á¶Ä¡ ±×·ì, ±¸¼º¿ø ±×·ì, ÀÚ¿ø ±×·ì, ¼±ÅÃÀûÀ¸·Î °ü°è¸¦ ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ACACTGRP_ID |
INTEGER
NOT NULL |
Á¶Ä¡ ±×·ì ID. Á¤Ã¥ÀÌ ÂüÁ¶ÇÏ´Â Á¶Ä¡ ±×·ìÀÇ ID. ACACTGRP Å×À̺íÀÇ foreign key. |
ACPOLICY_ID |
INTEGER
NOT NULL |
ÀÌ Á¤Ã¥ ·¹ÄÚµåÀÇ Á¤Ã¥ ID. 1Â÷ ŰÀÔ´Ï´Ù. |
ACRELATION_ID |
INTEGER
NULL |
Á¤Ã¥ÀÌ ÂüÁ¶µÇ´Â °ü·Ã ID. |
ACRELGRP_ID |
INTEGER
NULL |
Á¤Ã¥ÀÌ ÂüÁ¶ÇÏ´Â °ü°è ±×·ì ID. |
ACRESGRP_ID |
INTEGER
NOT NULL |
Á¤Ã¥ÀÌ ÂüÁ¶ÇÏ´Â ÀÚ¿ø ±×·ì ID. |
FIELD1 |
VARCHAR (128)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
MBRGRP_ID |
BIGINT
NOT NULL |
±¸¼º¿ø ±×·ì ID. MBRGRP_ID Çʵå Å×À̺í MBRGRP Å×À̺íÀÇ foreign key. |
MEMBER_ID |
BIGINT
NOT NULL |
Á¤Ã¥ ¼ÒÀ¯ÀÚÀÇ ±¸¼º¿ø ID. MEMBER Å×À̺íÀÇ foreign key. |
POLICYNAME |
VARCHAR (128)
NOT NULL |
Á¤Ã¥ À̸§ |
POLICYTYPE |
INTEGER
NULL |
ÀÌ Ç÷¡±×´Â ÅÛÇø®Æ® Á¤Ã¥°ú ±âº» »çÀÌÆ® Àü¿ª Á¤Ã¥À» ±¸º°ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù. À̰ÍÀº ¼±Åà ÇʵåÀÔ´Ï´Ù. °ª 1Àº ÅÛÇø®Æ® Á¤Ã¥ÀÓÀ» ³ªÅ¸³»°í 1ÀÌ ¾Æ´Ï¸é ÅÛÇø®Æ® Á¤Ã¥ÀÌ ¾Æ´ÔÀ» ³ªÅ¸³À´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000006 | POLICYNAME, MEMBER_ID | °íÀ¯ »öÀÎ |
SQL020206020537520 | ACPOLICY_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_29 | ACRELGRP_ID | ACRELGRP | ACRELGRP_ID | °è´Ü½Ä |
F_30 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_31 | MBRGRP_ID | MBRGRP | MBRGRP_ID | °è´Ü½Ä |
F_32 | ACACTGRP_ID | ACACTGRP | ACACTGRP_ID | °è´Ü½Ä |
F_33 | ACRESGRP_ID | ACRESGRP | ACRESGRP_ID | °è´Ü½Ä |
F_34 | ACRELATION_ID | ACRELATION | ACRELATION_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_26 | ACPOLICY_ID | ACORGPOL | ACPOLICY_ID | °è´Ü½Ä |
F_27 | ACPOLICY_ID | ACPOLDESC | ACPOLICY_ID | °è´Ü½Ä |
![]() |