All Questions
2 questions
0
votes
1
answer
47
views
Which foreign keys do I use if they are repeated
I have the following two tables
company_relationships
|ID|Company_ID|Affiliate_ID|<Relationship Info>|
+--+----------+------------+-------------------+
jobs
|ID|Company_ID|<Job Info>|
+...
- 111
5
votes
1
answer
924
views
Optimised Schema for City-to-City Distance Table
This is my first question, forgive me if this question is simple. I'm stuck here, trying to implement the relationships for the data represented below. I want to scale it vertically (new rows), ...
- 175