Rename sponsor_partner to affiliate

[fyliu]

Overview

We should rename the sponsor_partner table to something like affiliate. And the project_sponsor_partner_xref table to affiliation or similar. This would simplify and clarify the ideas behind these tables.

Also more clear would be converting the project_sponsor_partner_xref.is_sponsor field to type. See discussion below.

Action Items

ERD, spreadsheet, code changes for each of these

• rename sponsor_partner to affiliate
• rename project_sponsor_partner_xref to affiliation. Made part of [docs] Document github actions #65
  • convert the is_sponsor field name to type and make it a choice or enum. Made part of [docs] Document github actions #65

Resources/Instructions

Proposed Changes

• Rename the project_sponsor_partner_xref table to affiliation or a more appropriate descriptive term for the relationship.
• Rename the sponsor_partner table to affiliate.
• Make is_sponsor is a choice like choose between sponsor or partner, and call it type

What the changes give us

Mostly simpler naming for these concepts.

Clearer code when working with the relationship and model.

Example to create a project-affiliate relation

Affiliation.objects.create(project="PeopleDepot", affiliate="Code for America", type="partner")

The current way would look like this

ProjectSponsorPartnerXref.objects.create(project="PeopleDepot", sponsor_partner="Code for America", is_sponsor=False)

Originally posted by @fyliu in hackforla#270 (comment)