Help with basic databases design in Bubble

[malikasfandyarashraf]

I am building a simple job board and I have got 3 tables.

1. User
2. Candidate
3. Job

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.

[boston85719]

Application will have a single relationship to a user and single relationship to a job. Your status should be an option set.

[malikasfandyarashraf]

Thanks. for this. Got it