Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀº Ưº° ÆÇ¸Å¿¡ ´ëÇÑ Á¤º¸¸¦ Á¦°øÇϰí ÇØ´ç ±¸¸Å, À¯È¿¼º ¹× ÇÒÀÎ Á¶°Ç¿¡ ´ëÇÑ ÂüÁ¶»çÇ×À» Á¦°øÇÕ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CPPMN_ID |
INTEGER
NOT NULL |
ÄíÆù Ưº° ÆÇ¸Å ID(1Â÷ Ű). |
CPPMNDESC |
CHARACTER (254)
NULL |
ÄíÆù Ưº° ÆÇ¸Å ¼³¸í(ÆÇ¸ÅÀÚ º¸±â¿ë) |
CPPMNNAME |
CHARACTER (64)
NOT NULL |
ÄíÆù Ưº° ÆÇ¸ÅÀÇ À̸§ |
CPPMNVAL_ID |
INTEGER
NULL |
CPPMNVAL Å×À̺íÀÇ foreign key. |
CREATIONTIME |
TIMESTAMP
NULL |
Ç׸ñÀÌ ÀÛ¼ºµÈ ³¯Â¥ ¹× ½Ã°£. |
EARLYBIRDLIMIT |
INTEGER
NULL |
early-bird ÄíÆùÀÇ ÇѰè. ÀÌ ¼Ó¼ºÀÌ ³Î(Null)°ªÀÎ °æ¿ì, ÇØ´ç Ưº° ÆÇ¸Å°¡ early-bird À¯ÇüÀÌ ¾Æ´ÔÀ» ³ªÅ¸³À´Ï´Ù. |
ENDDATE |
TIMESTAMP
NULL |
ÀÌ Æ¯º° ÆÇ¸Å°¡ ´õ ÀÌ»ó À¯È¿ÇÏÁö ¾Ê°Ô µÇ´Â ³¯Â¥ |
FIELD1 |
VARCHAR (64)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
INITIATIVE_ID |
INTEGER
NULL |
ÀÌ Æ¯º° ÆÇ¸Å°¡ ¼ÓÇÏ´Â Çà»ç Å×ÀÌºí¿¡ ´ëÇÑ foreign key |
NUMOFFERED |
INTEGER
NOT NULL |
ÀÌ Æ¯º° ÆÇ¸Å¸¦ ÅëÇØ ÀÌ¹Ì Á¦°øµÈ ÄíÆù ¼ö |
NUMSEENALLOWED |
INTEGER
NOT NULL |
ÀÌ Çʵå´Â »ç¿ëÀÚ¿¡°Ô ÀÌ ÄíÆù Ưº° ÆÇ¸Å¸¦ Á¦°øÇÒ È½¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. OfferLists¿ëÀÌ ¾Æ´Ñ ¹è³Ê ±¤°í¿¡ ´ëÇØ¼¸¸ ¿Ã¹Ù¸¨´Ï´Ù. |
NUMUSEALLOWED |
INTEGER
NOT NULL |
ÀÌ ÄíÆùÀ» »óȯÇÒ ¼ö Àִ Ƚ¼ö |
PROMODISPTYPE |
CHARACTER (4)
NOT NULL |
Ưº° ÆÇ¸Å°¡ ¸Åü¿Í Åë½ÅÇÏ´Â ¹æ½Ä. Áï, Ưº° ÆÇ¸Å°¡ Ç¥½ÃµÇ´Â À§Ä¡ÀÔ´Ï´Ù. °¡´ÉÇÑ °ª: B=¹è³Ê ±¤°í, E=ÀüÀÚ ¿ìÆí, O=ÆÇ¸Å ¼³Á¤ ¸ñ·Ï. |
PURCHASECONDTYPE |
CHARACTER (4)
NOT NULL |
ÀÌ Çʵå´Â Ưº° ÆÇ¸Å ±¸¸Å Á¶°Ç À¯ÇüÀ» ÁöÁ¤ÇÕ´Ï´Ù. °¡´ÉÇÑ °ª: P=»óǰ, O=ÁÖ¹®. |
SETCCURR |
CHARACTER (3)
NULL |
À̰ÍÀº Ưº° ÆÇ¸Å¿¡ ´ëÇÑ ±âº» ÅëÈÀÔ´Ï´Ù. ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ ÄÚµå. |
STARTDATE |
TIMESTAMP
NOT NULL |
ÀÌ ÄíÆù Ưº° ÆÇ¸Å°¡ ´õ ÀÌ»ó À¯È¿ÇÏÁö ¾Ê°Ô µÇ´Â ³¯Â¥ |
STATUS |
CHARACTER (1)
NOT NULL |
ÄíÆù Ưº° ÆÇ¸Å »óŸ¦ ³ªÅ¸³À´Ï´Ù. ¿Ã¹Ù¸¥ °ª: A=Ȱ¼ºÈ, D=»èÁ¦µÊ ¶Ç´Â E=¸¸±â. |
STOREENT_ID |
INTEGER
NOT NULL |
ÀÌ ÄíÆù Ưº° ÆÇ¸Å¸¦ ÁÖ°üÇÏ´Â »óÁ¡ÀÇ ID |
TOTALNUMOFFER |
INTEGER
NOT NULL |
ÀÌ Æ¯º° ÆÇ¸Å¿¡ ´ëÇØ Á¦°øÇÒ ÄíÆù ¼ö. °í°´ÀÌ ½ÂÀÎÇÑ ÄíÆù ¼ö¸¦ ³ªÅ¸³À´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020614370 | CPPMN_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_265 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
F_266 | INITIATIVE_ID | INITIATIVE | INITIATIVE_ID | °è´Ü½Ä |
F_267 | CPPMNVAL_ID | CPPMNVAL | CPPMNVAL_ID | °è´Ü½Ä |
F_268 | SETCCURR | SETCURR | SETCCURR | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_264 | CPPMN_ID | CPOFFER | CPPMN_ID | °è´Ü½Ä |
F_270 | CPPMN_ID | CPPMNDESC | CPPMN_ID | °è´Ü½Ä |
F_271 | CPPMN_ID | CPPMNDISC | CPPMN_ID | °è´Ü½Ä |
F_273 | CPPMN_ID | CPPMNORD | CPPMN_ID | °è´Ü½Ä |
F_275 | CPPMN_ID | CPPMNPROD | CPPMN_ID | °è´Ü½Ä |
F_277 | CPPMN_ID | CPWALLET | CPPMN_ID | °è´Ü½Ä |
![]() |