µ¥ÀÌÅͺ£À̽º Å×À̺í: CPPMN


Å×ÀÌºí ¼³¸í:

ÀÌ Å×À̺íÀº Ưº° ÆÇ¸Å¿¡ ´ëÇÑ Á¤º¸¸¦ Á¦°øÇϰí ÇØ´ç ±¸¸Å, À¯È¿¼º ¹× ÇÒÀÎ Á¶°Ç¿¡ ´ëÇÑ ÂüÁ¶»çÇ×À» Á¦°øÇÕ´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
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 °è´Ü½Ä
IBM copyright