| 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 |