Database Table: TFALGOREG

Reserved for IBM internal use.

Column Name Column Type Column Description
ALLOCPOL INTEGER
NULL
Reserved for IBM internal use.
CLASSNAME VARCHAR (254)
NULL
Reserved for IBM internal use.
CREATETIME TIMESTAMP
NULL
Reserved for IBM internal use.
ENDTIME TIMESTAMP
NULL
Reserved for IBM internal use.
MATCHPOL INTEGER
NULL
Reserved for IBM internal use.
MEMBER_ID BIGINT
NOT NULL
Reserved for IBM internal use.
NAME VARCHAR (254)
NOT NULL
Reserved for IBM internal use.
PRICEPOL INTEGER
NULL
Reserved for IBM internal use.
TFALGOREG_ID INTEGER
NOT NULL
Reserved for IBM internal use.
TFALGOTYPE_ID INTEGER
NULL
Reserved for IBM internal use.
TFDOMAIN_ID INTEGER
NULL
Reserved for IBM internal use.
TFSBDOMAIN_ID INTEGER
NULL
Reserved for IBM internal use.
UPDATETIME TIMESTAMP
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000247 NAME Unique Index
SQL030416035131310 TFALGOREG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_837 PRICEPOL TFALGOPOL TFALGOPOL_ID Cascade
F_838 MATCHPOL TFALGOPOL TFALGOPOL_ID Cascade
F_839 ALLOCPOL TFALGOPOL TFALGOPOL_ID Cascade
F_840 TFALGOTYPE_ID TFALGOTYPE TFALGOTYPE_ID Cascade
F_841 MEMBER_ID MEMBER MEMBER_ID Cascade
F_842 TFDOMAIN_ID TFDOMAIN TFDOMAIN_ID Cascade
F_843 TFSBDOMAIN_ID TFSBDOMAIN TFSBDOMAIN_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_848 TFALGOREG_ID TFALREGDSC TFALGOREG_ID Cascade
F_855 TFALGOREG_ID TFEXTENG TFALGOREG_ID Cascade