employerID | name | phoneNumber | |
---|---|---|---|
1 | Company A | companyA@example.com | 123456789 |
2 | Company B | companyB@example.com | 987654321 |
categoryID | description |
---|---|
1 | Graphic Design |
2 | Web Development |
skillID | skillName |
---|---|
1 | Adobe Photoshop |
2 | HTML/CSS |
locationID | city | state | country |
---|---|---|---|
1 | New York | NY | USA |
2 | Los Angeles | CA | USA |
pricingID | price |
---|---|
1 | 500 |
2 | 700 |
jobID | title | postingDate | employerID | categoryID | skills | locationID | visualArtProfession | pricingID |
---|---|---|---|---|---|---|---|---|
(→ Employers.employerID) | (→ Categories.categoryID) | (→ Locations.locationID) | (→ Pricing.pricingID) | |||||
1 | Freelance Graphic Designer | 2024-03-13 13:08:29 | 1 | 1 | ["Adobe Photoshop"] | 1 | Photographer | 1 |
2 | Full Stack Web Developer | 2024-03-13 13:08:29 | 2 | 2 | ["HTML/CSS", "JavaScript", "React"] | 2 | Photographer | 2 |
3 | Wedding Videographer | 2024-03-13 13:08:29 | 3 | None | null | 3 | Videographer | 2 |
4 | Real Estate Photography | 2024-03-13 13:08:29 | 4 | None | ["DSLR Camera"] | 4 | Photographer | 1 |
5 | Corporate Event Videography | 2024-03-13 13:08:29 | 5 | None | null | 5 | Videographer | 2 |