People

People

FieldTypeDescription
id 🔑INTEGERThe unique identifier for the person record.
agency_id 🔗INTEGERThe ID of the agency this person belongs to.
external_identifierSTRINGExternal systems identifier for the person, if provided.
first_nameSTRINGThe person's first or given name.
middle_nameSTRINGThe person's middle name, if provided.
last_nameSTRINGThe person's last or family name.
suffixSTRINGThe person's name suffix (e.g., Jr., Sr., III).
preferred_nameSTRINGThe person's preferred name or nickname.
emailSTRINGThe person's primary email address.
created_atTIMESTAMPThe timestamp when the person record was created.
updated_atTIMESTAMPThe timestamp when the person record was last updated.

Key Information

Primary Keys

  • id - The unique identifier for the person record.

Foreign Keys

  • agency_id - The ID of the agency this person belongs to.