id | name | location |
---|---|---|
1 | Advertising Agency A | New York |
2 | Digital Media Company B | Los Angeles |
3 | PR Firm C | Chicago |
4 | Media Consultancy D | Boston |
5 | Branding Agency E | Dallas |
id | position |
---|---|
1 | Graphic Designer |
2 | Copywriter |
3 | Photographer |
4 | Web Developer |
5 | Content Creator |
agency_id | position_id |
---|---|
(→ Marketing_Agency.id) | (→ Creative_Position.id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 4 |