People
People
Field | Type | Description |
---|---|---|
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. |
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
Primary Keys
id
- The unique identifier for the person record.
Foreign Keys
agency_id
- The ID of the agency this person belongs to.
Updated 6 days ago