Family Finding Searches
Family Finding Searches
| Field | Type | Description |
|---|---|---|
id 🔑 | INTEGER | Legacy row identifier (same value as family_finding_search_id). |
family_finding_search_id | INTEGER | The unique identifier for the family finding search record. |
agency_id 🔗 | INTEGER | The ID of the agency this family finding search belongs to. |
start_date | DATE | The date when the family finding search started. |
end_date | DATE | The date when the family finding search ended, if applicable. |
child_id 🔗 | INTEGER | The unique identifier for the child associated with this family finding search. |
updated_at | TIMESTAMP | The timestamp when the family finding search record was last updated. |
created_at | TIMESTAMP | The timestamp when the family finding search record was created. |
Key Information
Primary Keys
id- Legacy row identifier (same value as family_finding_search_id).
Foreign Keys
agency_id- The ID of the agency this family finding search belongs to.child_id- The unique identifier for the child associated with this family finding search.
Updated about 1 month ago