| Profession | Area |
|---|---|
| Social Worker | East End |
| Social Worker | West Side |
| Counselor | East End |
| Counselor | South Side |
| LocationID | CityName | State | Country |
|---|---|---|---|
| 1 | New York City | NY | USA |
| 2 | Los Angeles | CA | USA |
| 3 | London | England | UK |
| 4 | Paris | Île-de-France | France |
| 5 | Tokyo | Tokyo | Japan |
| SkillID | SkillName |
|---|---|
| 1 | Communication |
| 2 | Empathy |
| 3 | Conflict Resolution |
| 4 | Time Management |
| 5 | Emotional Intelligence |
| JobId | Title | Description | LocationID |
|---|---|---|---|
| (→ Locations.LocationID) | |||
| 1 | Child Welfare Specialist | Working with children and families in need. | 1 |
| 2 | Mental Health Counselor | Support individuals experiencing mental health issues. | 2 |
| 3 | Substance Abuse Therapist | Help clients overcome addiction. | 3 |
| 4 | Geriatric Social Worker | Assisting elderly clients with daily living tasks and emotional support. | 4 |
| 5 | School Social Worker | Providing social services within a school setting. | 5 |
| ApplicantId | Name | PhoneNumber | JobId | |
|---|---|---|---|---|
| (→ Jobs.JobId) | ||||
| 1 | John Doe | john@example.com | 555-123-4567 | 1 |
| 2 | Jane Smith | jane@example.com | 555-987-654-321 | 2 |
| 3 | Alice Johnson | alice@example.com | 555-098-765-432 | 3 |
| 4 | Bob Brown | bob@example.com | 555-432-109-876 | 4 |
| 5 | Charlie White | charlie@example.com | 555-123-456-789 | 5 |
| EmployerId | CompanyName | Address | ContactEmail |
|---|---|---|---|
| 1 | City Community Services | 123 Main St | cityservices@example.com |
| 2 | State Mental Health Agency | 456 Elm St | mentalhealth@example.com |
| 3 | National Substance Abuse Council | 789 Oak St | substanceabusecouncil@example.com |
| 4 | Retirement Home | 111 Pine St | retirementsupport@example.com |
| 5 | Local School District | 987 Fir St | schooldistrict@example.com |