Children

Children

FieldTypeDescription
id 🔑INTEGERThe child's unique identifier.
agency_id 🔗INTEGERThe ID of the agency this child belongs to.
person_id 🔗INTEGERThe unique identifier for the associated person record.
created_atTIMESTAMPThe timestamp when the child record was created.
updated_atTIMESTAMPThe timestamp when the child record was last updated.
client_idSTRINGThe external client identifier for the child.
external_group_idSTRINGThe group identifier for siblings or otherwise-related children.
confidentialBOOLEANIndicates if the child's record is confidential.
sealedBOOLEANIndicates if the child's record is sealed.
community_of_origin_zipcodeSTRINGThe zipcode of the community where the child originally lived.
in_careBOOLEANIndicates if the child is currently in care.
date_joined_agencyDATEThe 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.