TDD_FORKEY

The fkey table. The table defines all the foreign key relationships. This table is pivotal as it is used by most of the utility routines.


Columns

No Name Domain Dty Len Scale Nulls Foreign Key Description
1 TDD_VERSION TDD_VERSION I 4   N   Version stamp. The last version is always the number one (1). All old versions will have a negative version number. TDD_VERSION will have the corresponding date when the version was updated/deleted.
2 FKY_TAB_MASTER DV_SQLID C 30   N TDD_TABLE.TAB_NAME Table name.
3 FKY_COL_MASTER DV_SQLID C 30   N TDD_COLUMN.COL_NAME Column name.
4 FKY_VAL_MASTER DV_CODE I 4   Y   Additional value predicate. If this is not NULL then FKY_VCO_SLAVE indicates the column to which the value should be equal to.
5 FKY_TAB_SLAVE DV_SQLID C 30   N TDD_TABLE.TAB_NAME Table name.
6 FKY_COL_SLAVE DV_SQLID C 30   N TDD_COLUMN.COL_NAME Column name.
7 FKY_VCO_SLAVE DV_SQLID C 30   Y TDD_COLUMN.COL_NAME Column name.
8 FKY_LOV_DISPCOL TDD_COLNUM I 2   Y   Column to display during default LOV processing. NULL indicates all columns. A value greater than the number of columns in the LOV table will show the return column. Otherwise the column indicated will be shown.

Dependents

None


Updated 31 Oct 2002.