## Orthodontists

id | name | address | phoneNumber | email | education
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Education.name)
1 | Dr. Smith | 123 Main St | 555-1234 | smith@example.com | Doctor of Dental Surgery
2 | Dr. Johnson | 456 Elm St | 555-5678 | johnson@example.com | Master of Science in Dentistry
3 | Dr. Brown | 789 Oak St | 555-9012 | brown@example.com | Bachelor of Dental Surgery

## Periodontists

id | name | address | phoneNumber | email | education
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Education.name)
1 | Dr. Miller | 123 Pine St | 555-3456 | miller@example.com | Doctor of Dental Surgery
2 | Dr. Wilson | 456 Fir St | 555-7890 | wilson@example.com | Certificate in Periodontics
3 | Dr. Davis | 789 Palm St | 555-1357 | davis@example.com | Doctorate in Clinical Periodontology

## Employers

id | companyName | location | jobTitle | postDate
--- | --- | --- | --- | ---
1 | Smile Inc. | New York | Dental Hygienist | 2021-01-01 10:00:00
2 | Teeth Care Center | Los Angeles | Dental Assistant | 2021-02-01 10:00:00
3 | Gum Health Solutions | Chicago | Pediatric Dentist | 2021-03-01 10:00:00
4 | Tooth Fairy Services | Miami | Endodontist | 2021-04-01 10:00:00
5 | Enamel Experts | Houston | Prosthodontist | 2021-05-01 10:00:00

## Education

id | degree | institution | startYear | endYear
--- | --- | --- | --- | ---
1 | PhD | University of Dentistry | 2010 | 2014
2 | BS | State University | 2006 | 2010
3 | MD | Medical School | 2002 | 2006
4 | MS | Research Institute | 2008 | 2012
5 | DDSc | Top Dental School | 2004 | 2008