Comments
Sort by recent activity
We need the data to be valid. When the keys are repeated at random this breaks the data validity
e.g. A cart table with a TotalCost calculated from the products in the cart. If the data is being copied from another data source then the TotalCost is not valid. / comments
We need the data to be valid. When the keys are repeated at random this breaks the data validity
e.g. A cart table with a TotalCost calculated from the products in the cart. If the data is being co...
Say I have a table participants with PK part_id and another table DeliveryAddress with foreign key part_id.
If i setup the foreign key on DeliveryAddress back to the participants table then it will only select unique part_id when a participant could have multiple delivery addresses.
There is a hint to the right of the "Population method" on the Foreign key generator UI stating: If the foreign key references a single column, each value in the referenced column is only used once. I have tested this and it creates a one to one foreign key. / comments
Say I have a table participants with PK part_id and another table DeliveryAddress with foreign key part_id.
If i setup the foreign key on DeliveryAddress back to the participants table then it will...