| id | name | specialty | experience_years | clinic |
|---|---|---|---|---|
| (→ Clinics.name) | ||||
| 1 | Dr. Jane Smith | Child & Adolescent | 10 | Harmony Wellness Center |
| 2 | Dr. John Doe | Cognitive Behavioral Therapy | 7 | Mental Health Solutions |
| id | name | specialty | experience_years | clinic |
|---|---|---|---|---|
| (→ Clinics.name) | ||||
| 1 | Dr. Alice Brown | General Adult | 8 | Harmony Wellness Center |
| 2 | Dr. Bob Johnson | Geriatric | 9 | Mental Health Associates |
| id | title | description | salary | start_date | end_date | status |
|---|---|---|---|---|---|---|
| 1 | Psychologist | Providing therapy to children and adolescents. | 60000 | 2023-01-01 | 2023-12-31 | Open |
| 2 | Psychiatrist | Diagnosing and treating mental disorders. | 80000 | 2023-01-01 | 2023-12-31 | Open |
| id | first_name | last_name | phone_number | job_id | |
|---|---|---|---|---|---|
| (→ Jobs.id) | |||||
| 1 | John | Doe | john.doe@example.com | 555-123-4567 | 1 |
| 2 | Jane | Smith | jane.smith@example.com | 555-987-6543 | 1 |
| id | name | address | city | state | zipcode |
|---|---|---|---|---|---|
| 1 | Harmony Wellness Center | 123 Main St | Anytown | CA | 12345 |
| 2 | Mental Health Solutions | 456 Elm St | Another City | NY | 67890 |