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 |