TFALGOREG

Reserved for IBM internal use.

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	TFALGOREG_ID	Primary Key
I0000247	NAME	Unique Index
I0000811	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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 Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_848	TFALGOREG_ID	TFALREGDSC	TFALGOREG_ID	Cascade
F_855	TFALGOREG_ID	TFEXTENG	TFALGOREG_ID	Cascade