ÀÌ Å×À̺íÀº Ưº° ÆÇ¸Å¿¡ ´ëÇÑ Á¤º¸¸¦ Á¦°øÇϰí ÇØ´ç ±¸¸Å, À¯È¿¼º ¹× ÇÒÀÎ Á¶°Ç¿¡ ´ëÇÑ ÂüÁ¶»çÇ×À» Á¦°øÇÕ´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
CPPMNDESC | CHARACTER (254) NULL |
ÄíÆù Ưº° ÆÇ¸Å ¼³¸í(ÆÇ¸ÅÀÚ º¸±â¿ë). |
CPPMNNAME | CHARACTER (64) NOT NULL |
ÄíÆù Ưº° ÆÇ¸ÅÀÇ À̸§. |
CPPMNVAL_ID | INTEGER NULL |
CPPMNVAL Å×À̺íÀÇ foreign key. |
CPPMN_ID | INTEGER NOT NULL |
ÄíÆù Ưº° ÆÇ¸Å ID(1Â÷ Ű). |
CREATIONTIME | TIMESTAMP NULL |
Ç׸ñÀÌ ÀÛ¼ºµÈ ³¯Â¥ ¹× ½Ã°£. |
EARLYBIRDLIMIT | INTEGER NULL |
early-bird ÄíÆùÀÇ ÇѰè. ÀÌ ¼Ó¼ºÀÌ ³Î(Null)°ªÀÎ °æ¿ì, ÇØ´ç Ưº° ÆÇ¸Å°¡ early-bird À¯ÇüÀÌ ¾Æ´ÔÀ» ³ªÅ¸³À´Ï´Ù. |
ENDDATE | TIMESTAMP NULL |
ÀÌ Æ¯º° ÆÇ¸Å°¡ ´õ ÀÌ»ó À¯È¿ÇÏÁö ¾Ê°Ô µÇ´Â ³¯Â¥. |
FIELD1 | VARCHAR (64) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
INITIATIVE_ID | INTEGER NULL |
ÀÌ Æ¯º° ÆÇ¸Å°¡ ¼ÓÇÏ´Â Çà»ç Å×ÀÌºí¿¡ ´ëÇÑ foreign key. |
NUMACPALLOWED | INTEGER NOT NULL, DEFAULT 1 |
À̰ÍÀº ´ÜÀÏ »ç¿ëÀÚ°¡ ½ÂÀÎÇÒ ¼ö ÀÖ´Â ÄíÆù Ưº° ÆÇ¸ÅÀÇ ÄíÆù ¼öÀÔ´Ï´Ù. ±âº»°ªÀº 1ÀÔ´Ï´Ù. |
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 |
ÀÌ Æ¯º° ÆÇ¸Å¿¡ ´ëÇØ Á¦°øÇÒ ÄíÆù ¼ö. °í°´ÀÌ ½ÂÀÎÇÑ ÄíÆù ¼ö¸¦ ³ªÅ¸³À´Ï´Ù. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000289 | CPPMNNAME, STOREENT_ID | °íÀ¯ »öÀÎ |
I0000302 | ENDDATE | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416034915530 | CPPMN_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
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 | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
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 | °è´Ü½Ä |
F_975 | CPPMN_ID | CPPMNACC | CPPMN_ID | °è´Ü½Ä |
F_976 | CPPMN_ID | CPPMNCAT | CPPMN_ID | °è´Ü½Ä |