All Questions
1 question
2
votes
2
answers
688
views
Composite primary key plus a separate (surrogate) id column for foreign key references
I am trying to build a database about locations like so:
Country → Region → Town
Countries will be populated with a list of pre-defined worldwide countries, regions & towns are input by users.
...
- 123