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


Å×ÀÌºí ¼³¸í:

ÀÌ Å×ÀÌºí¿¡´Â ¸ðµç °èȹµÈ ÀÛ¾÷ Ç׸ñÀÌ µé¾î ÀÖ½À´Ï´Ù.

¿­ ¼³¸í:

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