The person record contains all the personal information that we need to know about people in our database. Many other tables have a foreign key into person. See the many Relations below.
The table name is people but the model name is Person. We don't have a strict naming convention for table/model names like Ruby on Rails does.
Table: people
- addr1
- first line of address
- addr2
- optional second line of address
- akey
- a computed key used for address unduplication
- city
- city
- comment
- arbitrary length comment about the person
- covid_vax
- Is there a COVID vaccination card uploaded? If so, it is located at: /var/Reg/documents/covid_vax_$id.suffix where $id is the id column of the person and with some image suffix like .jpg or .gif or .png The value of the column is the filename in that directory. This is like a boolean - false if empty
- country
- country
- date_entrd
- date this person's record was first entered
- date_updat
- last date the record was updated
- diet
- dietary restrictions - vegan, gluten free, allergies, etc
- deceased
- the person has passed
- e_mailings
- I want MMC emailings
- email
- email address
- first
- first name
- id
- unique id
- id_sps
- foreign key to person - the partner, if partnered
- inactive
- This record is no longer active - for whatever reason. Do not include it in any mailings.
- last
- last name
- only_temple
- Is this person ONLY a Temple Guest?
- pronouns
- preferred pronouns - will appear on the badge
- safety_form
- this person has filled out a safety form
- sanskrit
- Sanskrit name - if any. one can search for a person by their Sanskrit name
- secure_code
- generated at record creation time - 6 random letters Used for sending in email for online member payment and also for having people update their own People entry.
- sex
- gender - M or F. for people that have as yet not specified their gender this field could be either blank ' ' or C (not sure why old reg had a C - couple?). this field matters for housing purposes.
- share_mailings
- it is okay to share my information with other organizations
- snail_mailings
- I want MMC snail mailings
- st_prov
- state or province
- tel_cell
- cell phone
- tel_home
- home phone
- tel_work
- work phone These phone numbers are used in many places. Especially in the phone list, of course.
- temple_id
- the unique id in the temple visitor database. not all people will have one - only those who have reserved a visit to the temple. used in grab_new.
- vax_okay
- the COVID-19 vaccination card is legit
- waiver_signed
- they signed a waiver of liability (yoga programs)
- zip_post
- zip (or postal) code
Relations