Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡´Â »ç¿ëÀÚ°¡ ½ÂÀÎÇÑ ÄíÆùÀÌ µé¾î ÀÖ½À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ACCEPTFROMTYPE |
CHARACTER (4)
NOT NULL |
ÄíÆùÀÌ ½ÂÀÎµÈ Àå¼Ò¸¦ ³ªÅ¸³À´Ï´Ù. B = ¹è³Ê ±¤°í E = ÀüÀÚ ¿ìÆí O = ÆÇ¸Å ¼³Á¤ ¸ñ·Ï |
CPPMN_ID |
INTEGER
NOT NULL |
Ưº° ÆÇ¸Å ID. CPPMN Å×À̺íÀÇ foreign key. |
CPWALLET_ID |
BIGINT
NOT NULL |
1Â÷ Ű. |
FIELD1 |
VARCHAR (64)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
NUMUSE |
INTEGER
NOT NULL |
ÀÌ ÄíÆùÀÌ »ç¿ëµÈ Ƚ¼ö |
STATE |
CHARACTER (4)
NOT NULL |
ÄíÆùÀÇ »óÅÂ(U=»ç¿ë °¡´É, D=»èÁ¦µÊ, N=»ç¿ë ºÒ°¡´É, E=¸¸±âµÊ) |
TIMEACCEPT |
TIMESTAMP
NULL |
Å×À̺í Ç׸ñÀÌ ÀÛ¼ºµÈ ½Ã°£ |
USERS_ID |
BIGINT
NOT NULL |
°í°´ ID. USERS Å×À̺íÀÇ foreign key. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020616500 | CPWALLET_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_276 | USERS_ID | USERS | USERS_ID | °è´Ü½Ä |
F_277 | CPPMN_ID | CPPMN | CPPMN_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_262 | CPWALLET_ID | CPITMAP | CPWALLET_ID | °è´Ü½Ä |
F_484 | CPWALLET_ID | ORCPMAP | CPWALLET_ID | °è´Ü½Ä |
F_828 | CPWALLET_ID | TCPITMAP | CPWALLET_ID | °è´Ü½Ä |
F_862 | CPWALLET_ID | TORCPMAP | CPWALLET_ID | °è´Ü½Ä |
![]() |