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 |