Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº ºñÁî´Ï½º Á¤Ã¥À» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ENDTIME |
TIMESTAMP
NULL |
Á¤Ã¥ Á¾·á ³¯Â¥. ³Î(Null)°ªÀ̸é Á¾·á ½Ã°£ÀÌ ¾Æ´Ô |
POLICY_ID |
BIGINT
NOT NULL |
Á¤Ã¥ ID. |
POLICYNAME |
VARCHAR (128)
NOT NULL |
Á¤Ã¥ °íÀ¯ À̸§. »óÁ¡¿¡´Â ºÎÆ®½ºÆ®·¦ Á¤Ã¥ MasterCatalog(storeEntity´ç Çϳª) ¹× CreditLine(storeEntity´ç Çϳª)ÀÌ ÀÖ½À´Ï´Ù. |
POLICYTYPE_ID |
CHARACTER (64)
NOT NULL |
Á¤Ã¥ À¯Çü ID. POLICYTYPE Å×À̺íÀÇ foreign key. |
PROPERTIES |
VARCHAR (254)
NULL |
ºñÁî´Ï½º Á¤Ã¥ ¸í·ÉÀ¸·Î ¼³Á¤ÇÒ ¼ö ÀÖ´Â ±âº» À̸§ °ª ½Ö. ¿¹¸¦ µé¸é, n1=v1&n2=v2. |
STARTTIME |
TIMESTAMP
NULL |
Á¤Ã¥ÀÇ ½ÃÀÛ ³¯Â¥. ³Î(null)°ªÀ̸é Áï½Ã ½ÃÀ۵˴ϴÙ. |
STOREENT_ID |
INTEGER
NOT NULL |
»óÁ¡ ¶Ç´Â StoreGroup ID. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000189 | POLICYNAME, POLICYTYPE_ID, STOREENT_ID | °íÀ¯ »öÀÎ |
SQL020206020723580 | POLICY_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_608 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
F_609 | POLICYTYPE_ID | POLICYTYPE | POLICYTYPE_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_536 | POLICY_ID | ORDPAYMTHD | POLICY_ID | °è´Ü½Ä |
F_584 | POLICY_ID | PAYSUMMARY | POLICY_ID | °è´Ü½Ä |
F_610 | POLICY_ID | POLICYCMD | POLICY_ID | °è´Ü½Ä |
F_612 | POLICY_ID | POLICYDESC | POLICY_ID | °è´Ü½Ä |
F_613 | POLICY_ID | POLICYTC | POLICY_ID | °è´Ü½Ä |
F_669 | POLICY_ID | REFUNDMTHD | POLICY_ID | °è´Ü½Ä |
F_695 | POLICY_ID | RMA | POLICY_ID | °è´Ü½Ä |
![]() |