I have adopted the standard approach of replacing semantic primary keys with integral primary keys, in the case that the semantic key is not static and is referenced from external tables.
--- old+++ new@@ -1 +1 @@-I have adopted the standard approach of replacing semantic primary keys with integral primary keys, in the case that the semantic key is not static and is referenced to from external tables.+I have adopted the standard approach of replacing semantic primary keys with integral primary keys, in the case that the semantic key is not static and is referenced from external tables.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We can rethink this for milestone 2.0. Given that changing of the semantic keys is a rare occurance, if we can get the new SQL foriegn key cascade to work, then we can easily refactor back. But we should only do this if there is a real need.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Diff:
We can rethink this for milestone 2.0. Given that changing of the semantic keys is a rare occurance, if we can get the new SQL foriegn key cascade to work, then we can easily refactor back. But we should only do this if there is a real need.