Nutritionists

nutritionist_idemailfull_name
1john.smith@example.comJohn Smith
2jane.doe@example.comJane Doe
3michael.brown@example.comMichael Brown
4emily.white@example.comEmily White
5david.black@example.comDavid Black

Diets

diet_type_iddiet_type_value
1Vegan
2Non-vegan
3Low Carb
4Paleo
5Gluten Free

Nutritionists_Diets

nutritionist_iddiet_type_id
(→ Nutritionists.nutritionist_id)(→ Diets.diet_type_id)
11
21
31
41
51
53

JobPostings

job_posting_idtitledescriptionlocationsalary
1Registered DietitianHelp clients achieve their nutritional goals.New York, NY80000
2Nutrition ConsultantAdvise on healthy eating habits and meal planning.Los Angeles, CA65000
3Food ScientistResearch and develop new food products.Chicago, IL75000
4Health CoachGuide clients towards healthier lifestyles.San Francisco, CA60000
5Clinical NutritionistAssess and treat patients with malnutrition.Seattle, WA85000

Applicants

applicant_idfirst_namelast_nameemailphone_number
1AliceWilsonalice.wilson@example.com+1234567890
2RobertLeerobert.lee@example.com+9876543210
3AnnaMartinezanna.martinez@example.com+0987654321
4MarkTaylormark.taylor@example.com+1357924680
5LauraHalllaura.hall@example.com+2468135790

ApplicationStatus

application_idjob_posting_idapplicant_idstatusapplied_date
(→ JobPostings.job_posting_id)(→ Applicants.applicant_id)
111Applied2024-01-30 19:23:08
212Interview Scheduled2024-01-30 19:23:08
323Rejected2024-01-30 19:23:08
434Offer Made2024-01-30 19:23:08
545On Hold2024-01-30 19:23:08