ID | Degree |
---|---|
1 | Doctor of Dental Surgery |
2 | Master of Science in Dentistry |
ID | SpecializedIn |
---|---|
1 | Pediatric Dentistry |
2 | Endodontics |
ID | Title | Description | Location | CompanyName | PostedDate | FullTimePartTime |
---|---|---|---|---|---|---|
1 | Orthodontist | An experienced Orthodontist required. | New York | ABCD Inc | 2024-03-13 12:00:50 | Full Time |
2 | General Dentist | A General Dentist needed for our clinic. | California | XYZ Clinic | 2024-03-13 12:00:50 | Full Time |
3 | Periodontist | A qualified Periodontist wanted for our hospital. | Texas | LMN Hospital | 2024-03-13 12:00:50 | Full Time |
4 | Dental Assistant | Experienced Dental Assistants needed. | Florida | OPQ Clinic | 2024-03-13 12:00:50 | Part Time |
ID | Name | PhoneNumber | HireDate | JobID | |
---|---|---|---|---|---|
(→ Jobs.ID) | |||||
1 | John Doe | john@gmail.com | 1234567890 | 2024-03-13 12:00:50 | 1 |
2 | Jane Smith | jane@yahoo.com | 9876543210 | 2024-03-13 12:00:50 | 2 |
3 | Michael Johnson | mike@outlook.com | 5555555555 | 2024-03-13 12:00:50 | 3 |
4 | Emma Williams | emma@hotmail.com | 7777777777 | 2024-03-13 12:00:50 | 4 |
ID | FirstName | LastName | DentalSpecialty | JoiningDate | EducationID | SpecializationID |
---|---|---|---|---|---|---|
(→ Education.ID) | (→ Specialization.ID) | |||||
1 | Alice | Smith | Orthodontist | 2024-03-13 12:00:50 | 1 | 1 |
2 | Bob | Johnson | Orthodontist | 2024-03-13 12:00:50 | 2 | 2 |
3 | Charlie | Williams | Periodontist | 2024-03-13 12:00:50 | 1 | 1 |
4 | David | Brown | Periodontist | 2024-03-13 12:00:50 | 2 | 2 |