Reserved for IBM internal use.
Column Description(s):
Column Name | Column Type | Description |
TFALGOREG_ID |
INTEGER NOT NULL |
Reserved for IBM internal use. |
CLASSNAME |
VARCHAR(254) |
Reserved for IBM internal use. |
NAME |
VARCHAR(254) NOT NULL |
Reserved for IBM internal use. |
TFALGOTYPE_ID |
INTEGER |
Reserved for IBM internal use. |
TFDOMAIN_ID |
INTEGER |
Reserved for IBM internal use. |
TFSBDOMAIN_ID |
INTEGER |
Reserved for IBM internal use. |
MEMBER_ID |
BIGINT NOT NULL |
Reserved for IBM internal use. |
ENDTIME |
TIMESTAMP |
Reserved for IBM internal use. |
PRICEPOL |
INTEGER |
Reserved for IBM internal use. |
ALLOCPOL |
INTEGER |
Reserved for IBM internal use. |
MATCHPOL |
INTEGER |
Reserved for IBM internal use. |
CREATETIME |
TIMESTAMP |
Reserved for IBM internal use. |
UPDATETIME |
TIMESTAMP |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000247 |
NAME |
Unique Index |
SQL050212031319770 |
TFALGOREG_ID |
Primary Key |
I0000811 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_841 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
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_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 Name(s) | Constraint Type |
F_848 |
TFALGOREG_ID |
TFALREGDSC |
TFALGOREG_ID |
Cascade |
F_855 |
TFALGOREG_ID |
TFEXTENG |
TFALGOREG_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.