WebSphere Commerce database table: TFALGOREG
Reserved for IBM internal use.
Column Descriptions 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.
Indexes Index Name Indexed Column Names Index Type I0000247 NAME Unique Index SQL060903235300120 TFALGOREG_ID Primary Key I0000811 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
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