People Profile Fields Reference

how-to Product: Parishioner CRM Reviewed: Tue Sep 08 2026 03:00:00 GMT+0300 (Eastern European Summer Time)

Every person record in Kononia contains structured fields tracking personal details, contact info, church enrollment status, and spiritual tracking.

1. General & Biographical Fields

Database Column	Data Type	UI Field Name	Allowed Values / Constraints
`first_name`	`text`	First Name	Required.
`last_name`	`text`	Last Name	Required.
`preferred_name`	`text`	Preferred Name	Optional nickname.
`gender`	`text`	Gender	`'male'`, `'female'`, `'other'`, `'prefer_not_to_say'`
`date_of_birth`	`date`	Birthdate	Date formatting.
`marital_status`	`text`	Marital Status	`'single'`, `'married'`, `'widowed'`, `'divorced'`, `'separated'`, `'religious'`
`photo_url`	`text`	Avatar Photo	URL string pointing to Supabase Storage bucket.

Database Column	Data Type	UI Field Name	Default / Detail
`email`	`text`	Email	Contact email.
`phone`	`text`	Home Phone	Landline or main contact number.
`mobile_phone`	`text`	Mobile Phone	SMS target number.
`whatsapp_number`	`text`	WhatsApp	Direct chat number.
`preferred_contact`	`text`	Preferred Method	`'phone'`, `'email'`, `'sms'`, `'whatsapp'`
`address_line1`	`text`	Address Line 1	Main street details.
`address_line2`	`text`	Address Line 2	Suite, apartment, unit, etc.
`city`	`text`	City	Local city.
`state`	`text`	State / Region	Region identifier.
`zip`	`text`	ZIP / Postal Code	Area routing code.
`country`	`text`	Country	Default `'US'`.

Database Column	Data Type	UI Field Name	Description / Allowed Values
`membership_status`	`membership_status`	Status	Enum: `'visitor'`, `'regular_attendee'`, `'member'`, `'active_member'`, `'inactive'`, `'transferred'`, `'deceased'`, `'removed'`. Default: `'visitor'`
`membership_date`	`date`	Date Joined	Date they became a member.
`envelope_number`	`text`	Envelope Number	Used to map offline tithe contributions.
`campus`	`text`	Campus / Site	Optional campus designation.
`origin_church`	`text`	Previous Parish	Name of the church they moved from.
`church_code`	`text`	Church Code	Unique regional lookup identifier.

Database Column	Data Type	UI Field Name	Description
`confession_father_id`	`uuid`	Confession Father	Foreign key linking to a Priest’s record in `public.people`.
`at_risk_flag`	`boolean`	At Risk	Automatically set to `true` if absences exceed defined limits.
`consecutive_absences`	`smallint`	Consecutive Absences	Tracked by attendance triggers. Defaults to `0`.
`last_attendance_at`	`timestamptz`	Last Attended	Timestamp of the most recent registered event check-in.

linked_user_id (uuid): References the user’s authenticating credential in auth.users. Linking allows the member to log in to the self-service app dashboard.
directory_visible (boolean): When true, this profile is visible to other members in the public parish directory. Defaults to true.
custom_fields (jsonb): Key-value store containing custom attributes created by the organization (e.g., allergies, special talents).
formation_progress (jsonb): Keeps track of Sunday School grades and theological curriculum completions.