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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000247 | NAME | Unique Index |
SQL030416035131310 | TFALGOREG_ID | Primary Key |
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 |
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 |