Following eval(BadCode)'s advice, I have created an ERD for my database. However, there are a few questions I've got creating an ERD.
The 'teams' table has two foreign keys ("was" and "became") that refer to the primary index in the 'teams' table. That's not a typo; those two keys state previous and subsequent identities of the teams.
For example, the St. Paul Mayors (SPM) became the Huntsville Mayors (HNT), so under the St. Paul Mayors entry, the "became" field has the value "HNT", while the Huntsville Mayors entry has "SPM" in the "was" field.
How do I show that multiple foreign keys in a table refer to the SAME key in another table? Under my 'colors' table, "logo_by", "large_logo_by", and "alt_logo_by" all refer to the "cont_id" field in the 'contributers' table. How do I show that?
I'm using crow's foot notation here.