| nutritionist_id | full_name | |
|---|---|---|
| 1 | john.smith@example.com | John Smith |
| 2 | jane.doe@example.com | Jane Doe |
| 3 | michael.brown@example.com | Michael Brown |
| 4 | emily.white@example.com | Emily White |
| 5 | david.black@example.com | David Black |
| diet_type_id | diet_type_value |
|---|---|
| 1 | Vegan |
| 2 | Non-vegan |
| 3 | Low Carb |
| 4 | Paleo |
| 5 | Gluten Free |
| nutritionist_id | diet_type_id |
|---|---|
| (→ Nutritionists.nutritionist_id) | (→ Diets.diet_type_id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 3 |
| job_posting_id | title | description | location | salary |
|---|---|---|---|---|
| 1 | Registered Dietitian | Help clients achieve their nutritional goals. | New York, NY | 80000 |
| 2 | Nutrition Consultant | Advise on healthy eating habits and meal planning. | Los Angeles, CA | 65000 |
| 3 | Food Scientist | Research and develop new food products. | Chicago, IL | 75000 |
| 4 | Health Coach | Guide clients towards healthier lifestyles. | San Francisco, CA | 60000 |
| 5 | Clinical Nutritionist | Assess and treat patients with malnutrition. | Seattle, WA | 85000 |
| applicant_id | first_name | last_name | phone_number | |
|---|---|---|---|---|
| 1 | Alice | Wilson | alice.wilson@example.com | +1234567890 |
| 2 | Robert | Lee | robert.lee@example.com | +9876543210 |
| 3 | Anna | Martinez | anna.martinez@example.com | +0987654321 |
| 4 | Mark | Taylor | mark.taylor@example.com | +1357924680 |
| 5 | Laura | Hall | laura.hall@example.com | +2468135790 |
| application_id | job_posting_id | applicant_id | status | applied_date |
|---|---|---|---|---|
| (→ JobPostings.job_posting_id) | (→ Applicants.applicant_id) | |||
| 1 | 1 | 1 | Applied | 2024-01-30 19:23:08 |
| 2 | 1 | 2 | Interview Scheduled | 2024-01-30 19:23:08 |
| 3 | 2 | 3 | Rejected | 2024-01-30 19:23:08 |
| 4 | 3 | 4 | Offer Made | 2024-01-30 19:23:08 |
| 5 | 4 | 5 | On Hold | 2024-01-30 19:23:08 |