Marketers

idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com
3Michael Johnsonmichael@example.com
4Emily Davisemily@example.com
5William Brownwilliam@example.com

Channels

idchannelName
1Social Media
2Email Marketing
3Content Marketing
4SEO
5Affiliate Marketing

JobPostings

idtitledescriptionsalary
1Digital Marketing ManagerManage digital marketing campaigns across multiple channels.70000.0
2SEO SpecialistOptimize website content and structure for search engines.60000.0
3Social Media CoordinatorCreate and manage social media content.50000.0
4Email Marketing StrategistDevelop and execute email marketing campaigns.65000.0
5Affiliate Marketing ManagerBuild and maintain relationships with affiliates.75000.0

Marketer_Jobs

idmarketerIDjobPostingID
(→ Marketers.id)(→ JobPostings.id)
111
222
333
444
555

Marketers_Channels

idmarketerIDchannelID
(→ Marketers.id)(→ Channels.id)
111
222
333
444
555