This file defines foreign key columns in the textual database. If there are no foreign keys then this file can be left empty, but the file must exist even if it is empty in order for this to be considered a valid TDD.
Each line in the file contains a comma separated list of values that define a single foreign key. A colon is used to separate the foreign key and the column it refers to:
<table_name>, <column_name> : <foreign_table_name>, <foreign_column_name>
The values are as follows:
|The name of the table that contains the foreign key.|
|The name of the column that contains the foreign key.|
|The table that the foreign key refers to.|
The column in the foreign table that is reference by the foreign key.
Houses,Occupancy:Occupancy,code Cars,Car Make:Car Make,code Cars,Car Wheel Size:Car Wheel Size,code Rooms,Num Beds:Num Beds,code Houses,Heating:Heating,code
In this example, the first line specifies that the
Occupancy column in the
Houses table is a foreign key reference to the
code column in the