Affiliations are used to describe a person's interests - the way that they are connected to the center. Programs have affiliations that are assigned to everyone registering for the program. Reports search for everyone that has an affiliation. Members are assigned an affiliation corresponding to their category.
Table: affils
- descrip
- the description of the affiliation
- id
- unique id
- selectable
- a boolean. is the system affiliation selectable when editing a person or program?
- system
- a boolean. if 'yes' it means Reg uses this affiliation internally. Cannot be edited.
Relations
| affil_person | affilperson | has_many |
| affil_program | affilprogram | has_many |
| affil_report | affilreport | has_many |
| people | affil_person => person | many_to_many |
| programs | affil_program => program | many_to_many |
| reports | affil_report => report | many_to_many |