Supplying some further information:
Each table currently does not have a team_id - they each only have their
Secondly, I parse data weekly so there are multiple week snapshops of
each table.. for example:
Week 1 Snapshot houses 120 teams and their data (non-ordered) ids from
Week 2 Snapshot houses the same 120 teams and their new data
(non-ordered) ids range from 121-240.
Week 3 Snapshot houses the same 120 teams and their new data
range from 121-240.
This applies to every table I have. In my model I currently show the
current week's data only. I could simply overwrite this data, but I'm
saving weekly snapshots so that people can select previous week data or
data from farther back.
So, there needs o be an associative team_id that is assigned to every
team and so it's the same for every table.. i.e. 120 teams in
alphabetical order with team_ids that range from 1-120. This should
apply to each table.
How do I create the join table to accomplish this?