JobPosting
ID | Title | Location | DatePosted |
1 | Tattoo Artist | New York | 2021-10-01 |
2 | Piercer | Los Angeles | 2021-10-02 |
BodyArtProfession
ProfessionID | Name |
1 | Tattoo Artist |
2 | Piercer |
AgeGroup
AgeID | MinimumAge | MaximumAge |
1 | 18 | 65 |
2 | 30 | 90 |
EmploymentType
TypeID | Description |
1 | Full Time |
2 | Part Time |
SalaryRange
RangeID | LowValue | HighValue |
1 | 30000 | 70000 |
2 | 20000 | 50000 |
JobPostingDetails
DetailsID | JobPostingID | BodyArtProfessionID | AgeID | EmploymentTypeID | SalaryRangeID |
| (→ JobPosting.ID) | (→ BodyArtProfession.ProfessionID) | (→ AgeGroup.AgeID) | (→ EmploymentType.TypeID) | (→ SalaryRange.RangeID) |
1 | 1 | 1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 | 2 | 2 |
3 | 3 | 1 | 2 | 2 | 2 |
4 | 4 | 2 | 1 | 1 | 1 |
5 | 5 | 2 | 2 | 1 | 2 |