I am building a simple job board and I have got 3 tables.
A User can recommend a Candidate for a Job. I want to create a table which is called Application.
Should I create an Application table, which has Candidate and Job and Status fields. Status field is just a text, which tells how the application status is.
Application: candidate: Candidate job: Job status: Text
I want to understand if I am build it correctly. I feel Application will have Many to Many Relationship with Candidate. And Application will have also Many to Many relationship with Job. Am i getting this relationships correct or am I on the wrong path.
And the way, I am building my Application table, does it make sense.