People

Field	Type	Description
`id` 🔑	INTEGER	Legacy row identifier (same value as person_id).
`person_id`	INTEGER	The unique identifier for the person record.
`agency_id` 🔗	INTEGER	The ID of the agency this person belongs to.
`external_identifier`	STRING	External systems identifier for the person, if provided.
`first_name`	STRING	The person's first or given name.
`middle_name`	STRING	The person's middle name, if provided.
`last_name`	STRING	The person's last or family name.
`suffix`	STRING	The person's name suffix (e.g., Jr., Sr., III).
`preferred_name`	STRING	The person's preferred name or nickname.
`email`	STRING	The person's primary email address.
`date_of_birth`	DATE	The person's exact date of birth.
`estimated_date_of_birth`	DATE	The person's estimated date of birth if the exact date is unknown.
`gender`	STRING	The person's gender identity.
`created_at`	TIMESTAMP	The timestamp when the person record was created.
`updated_at`	TIMESTAMP	The timestamp when the person record was last updated.

Key Information