Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡´Â ¸ðµç °èȹµÈ ÀÛ¾÷ Ç׸ñÀÌ µé¾î ÀÖ½À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
INTERFACENAME |
VARCHAR (254)
NULL |
°èȹµÈ ÀÛ¾÷À» ½ÇÇàÇØ¾ß ÇÏ´Â Áö¸¦ ³ªÅ¸³»´Â È®ÀÎ ¸í·ÉÀÇ ÀÎÅÍÆäÀ̽º. |
MEMBER_ID |
BIGINT
NOT NULL |
°èȹµÈ ÀÛ¾÷ÀÇ ¼ÒÀ¯ÀÚ |
SCCACTIVE |
CHARACTER (1)
NOT NULL, DEFAULT 'A' |
ÀÛ¾÷ Ȱ¼ºÈ Áö½ÃÀÚ |
SCCAPPTYPE |
CHARACTER (20)
NULL |
ÀÀ¿ëÇÁ·Î±×·¥ À¯Çü |
SCCHOST |
VARCHAR (128)
NULL |
È£½ºÆ® À̸§ |
SCCINTERVAL |
INTEGER
NULL |
ÀÛ¾÷ ½ºÄÉÁÙ °£°Ý(ÃÊ) |
SCCJOBREFNUM |
BIGINT
NOT NULL |
ÀÛ¾÷ ÂüÁ¶ ¹øÈ£. |
SCCPATHINFO |
VARCHAR (254)
NOT NULL |
¸í·É À̸§ |
SCCPRIORITY |
INTEGER
NOT NULL, DEFAULT 0 |
¿ì¼±¼øÀ§ |
SCCQUERY |
VARCHAR (3000)
NULL |
°èȹµÈ ¸í·É¿¡ ´ëÇÑ Á¶È¸ ¹®ÀÚ¿ |
SCCRECATT |
INTEGER
NOT NULL, DEFAULT 0 |
Àç½Ãµµ °è¼ö |
SCCRECDELAY |
INTEGER
NOT NULL, DEFAULT 0 |
Àç½Ãµµ Áö¿¬ ½Ã°£(ÃÊ) |
SCCSEQUENCE |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÛ¾÷ ¼ø¼ ¹øÈ£ |
SCCSTART |
TIMESTAMP
NOT NULL |
ÀÛ¾÷¿¡ ´ëÇÑ °èȹµÈ ½ÃÀÛ ½Ã°£ |
STOREENT_ID |
INTEGER
NOT NULL, DEFAULT 0 |
°èȹµÈ ÀÛ¾÷ÀÌ ½ÇÇàµÇ´Â »óÁ¡ÀÇ »óÁ¡ ID. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000226 | SCCJOBREFNUM, SCCSEQUENCE | °íÀ¯ »öÀÎ |
SQL020206020743660 | SCCJOBREFNUM | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_737 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
F_738 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_735 | SCCJOBREFNUM | SCHBRDCST | JOBREFNUM | °è´Ü½Ä |
F_739 | SCCJOBREFNUM | SCHORDERS | JOB_RN | °è´Ü½Ä |
F_741 | SCCJOBREFNUM | SCHSTATUS | SCSJOBNBR | °è´Ü½Ä |
F_915 | SCCJOBREFNUM | SCHACTIVE | SCSJOBNBR | °è´Ü½Ä |
![]() |