ÀÌ Å×ÀÌºí¿¡´Â ¸ðµç °èȹµÈ ÀÛ¾÷ Ç׸ñÀÌ µé¾î ÀÖ½À´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
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 | °íÀ¯ »öÀÎ |
I0000321 | SCCPATHINFO | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I0000322 | SCCHOST | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I0000323 | SCCAPPTYPE | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416035101850 | SCCJOBREFNUM | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_737 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
F_738 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_735 | SCCJOBREFNUM | SCHBRDCST | JOBREFNUM | °è´Ü½Ä |
F_739 | SCCJOBREFNUM | SCHORDERS | JOB_RN | °è´Ü½Ä |
F_741 | SCCJOBREFNUM | SCHSTATUS | SCSJOBNBR | °è´Ü½Ä |
F_915 | SCCJOBREFNUM | SCHACTIVE | SCSJOBNBR | °è´Ü½Ä |
F_959 | SCCJOBREFNUM | EMLPROMO | SCCJOBREFNUM | °è´Ü½Ä |
F_985 | SCCJOBREFNUM | FILEUPLOAD | SCCJOBREFNUM | °è´Ü½Ä |