How to populate row - multiple assignments

[Marina Woodson]

Hello,

I am very new to MySQL and i am trying to populate a several tables for open jobs, interviews, etc.

I currently have a table with Candidate information, Company information, and and Interview information. In the interview table I am supposed to have each company be able to require several skills that the candidates have to match. Also, there should be several interviewees for one open position. So I have to assign the candidate ID's to the open jobs.

I cannot seem to work out how I have to populate the table to do that. For example, do I use the company name and its ID for a primary key over and over in several rows? But that doesn't allow me to do it, because this is a primary key.

I hope this makes sense.