FosterCareAgency


Description

Foster care agency directory - Directory of foster care agencies and placement organizations providing services for children in foster care. This table stores agency contact information, addresses, and representative details to support foster care coordination, placement management, and inter-agency communication for child welfare and family services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
FosterCareID int identity 4 √ null

Agency primary key - Unique identifier for each foster care agency
FosterCareName varchar 50 √ null

Agency name - Official name of the foster care agency
Address varchar 50 √ null

Agency address - Street address of the foster care agency
City varchar 50 √ null

Agency city - City where the foster care agency is located
State varchar 20 √ null

Agency state - State where the foster care agency is located
Zip varchar 50 √ null

Agency ZIP code - Postal code for the foster care agency
Telephone varchar 50 √ null

Agency phone - Primary telephone number for the foster care agency
Agent varchar 100 √ null

Agency representative - Name of the primary contact or agent at the foster care agency

Indexes

Constraint Name Type Sort Column(s)
PK_FosterCareAgency Primary key Asc FosterCareID

Relationships

Close relationships within degrees of separation