i know how to do a many-many with a junction table but i have a database for tracking job interviews
1. job opening info
2. appplicants general info
3. applicants status for the job
one applicant - job opening is many-many
Q- what to do with the applicant status table? this info is unique to the applicant BUT for a specific Job opening.
1. job opening info
2. appplicants general info
3. applicants status for the job
one applicant - job opening is many-many
Q- what to do with the applicant status table? this info is unique to the applicant BUT for a specific Job opening.