Children
Children
Field | Type | Description |
---|---|---|
id 🔑 | INTEGER | The child's unique identifier. |
agency_id 🔗 | INTEGER | The ID of the agency this child belongs to. |
person_id 🔗 | INTEGER | The unique identifier for the associated person record. |
created_at | TIMESTAMP | The timestamp when the child record was created. |
updated_at | TIMESTAMP | The timestamp when the child record was last updated. |
client_id | STRING | The external client identifier for the child. |
external_group_id | STRING | The group identifier for siblings or otherwise-related children. |
confidential | BOOLEAN | Indicates if the child's record is confidential. |
sealed | BOOLEAN | Indicates if the child's record is sealed. |
community_of_origin_zipcode | STRING | The zipcode of the community where the child originally lived. |
in_care | BOOLEAN | Indicates if the child is currently in care. |
date_joined_agency | DATE | The date when the child joined the agency's care. |
Key Information
Primary Keys
id
- The child's unique identifier.
Foreign Keys
agency_id
- The ID of the agency this child belongs to.person_id
- The unique identifier for the associated person record.
Updated 6 days ago