Relationships
Relationships
| Field | Type | Description |
|---|---|---|
id 🔑 | INTEGER | Unique identifier for the relationship record. |
agency_id 🔗 | INTEGER | The ID of the agency this relationship belongs to. |
external_identifier | STRING | External systems identifier for the relationship, if provided. |
source_person_id 🔗 | INTEGER | The ID of the source person in the relationship. |
destination_person_id 🔗 | INTEGER | The ID of the destination person in the relationship. |
kinship_relationship | STRING | The specific type of kinship relationship (e.g., parent, sibling, cousin, aunt, uncle). |
kinship_relationship_other_description | STRING | Additional description if the kinship relationship is 'other'. |
fictive_kin_description | STRING | Description of the fictive kin relationship, if applicable. |
parental_line | STRING | The parental line of the relationship (maternal, paternal, parental, or combinations). |
lineage_type | STRING | The type of lineage (biological, adopted, step, half, marriage, alleged, presumed, unknown). |
emotional_relationship_statuses | STRING | The emotional status of the relationship (close, cordial, distant, contentious, no_prior_interaction). |
additional_relationship_details | STRING | Additional details about the relationship. |
verification_source | STRING | Source of relationship verification (worker, not_verified). |
verified_at | TIMESTAMP | The timestamp when the relationship was verified. |
locked | BOOLEAN | Whether the relationship is locked from further edits. |
created_at | TIMESTAMP | The timestamp when the relationship record was created. |
updated_at | TIMESTAMP | The timestamp when the relationship record was last updated. |
deleted_at | TIMESTAMP | The timestamp when the relationship record was soft deleted, if applicable. |
Key Information
Primary Keys
id- Unique identifier for the relationship record.
Foreign Keys
agency_id- The ID of the agency this relationship belongs to.source_person_id- The ID of the source person in the relationship.destination_person_id- The ID of the destination person in the relationship.
Updated 6 days ago