The table represents a foreign relationship between tables that does not already exist in the database.
Column Name | Column Type | Column Description |
---|---|---|
FKCOLUMN_NAME | CHARACTER (18) NULL |
The foreign column name. |
FKTABLE_NAME | CHARACTER (10) NULL |
The foreign (or "child" ) table name. |
TABLENAME | CHARACTER (10) NULL |
The primary (or "parent") table name. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000300 | TABLENAME, FKTABLE_NAME, FKCOLUMN_NAME | Unique Index |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|