Tattoo_Artists

IDNameExperienceStyle
1John Doe7Realism
2Jane Smith5Traditional
3Alice Johnson8Neotraditional
4Bob Brown9Watercolor
5Charlie Green6Blackwork

Piercers

IDNameYears_ExperienceSpecialization
1Mike White8Body Modification
2Emily Black7Surface Anchors
3David Blue9Conchtas
4Steve Gray6Ear Lobe Expansion
5Kevin Orange5Nipple and Genital Piercing

Age_Info

IDTattoo_ArtistIDPiercerIDAge
(→ Tattoo_Artists.ID)(→ Piercers.ID)
11None30
2None130
32None25
4None225
53None35
6None335

Job_Postings

IDTitleDescriptionLocationSalaryPosted_Date
1Senior Tattoo ArtistSeeking experienced tattoo artist...New York700002022-01-01
2Junior PiercerLooking for a new piercer...Los Angeles400002022-01-15
3Tattoo ApprenticeApprenticeship program available...San Francisco300002022-02-01
4Advanced Body PiercerExpertise in body modification...Chicago500002022-02-15
5Part-time Tattoo ArtistFlexible hours available...Houston450002022-03-01

Applicants

IDNameEmailPhone_NumberApplication_Date
1Alex Williamsalex@example.com555-555-55552022-01-02
2Samantha Wilsonsamantha@example.com555-555-55562022-01-03
3Ryan Taylorryan@example.com555-555-55572022-01-04
4Angela Leeangela@example.com555-555-55582022-01-05
5Chris Clarkchris@example.com555-555-55592022-01-06

Applications

IDApplicantIDJobPostingIDCover_LetterResume_URLStatus
(→ Applicants.ID)(→ Job_Postings.ID)
111Dear Hiring Manager...http://www.resume.com/alexwilliamsPending
221Dear Hiring Manager...http://www.resume.com/samanthawilsonRejected
332Dear Hiring Manager...http://www.resume.com/ryantaylorAccepted
443Dear Hiring Manager...http://www.resume.com/angelaleeInterview Scheduled
554Dear Hiring Manager...http://www.resume.com/chrisclarkOn Hold