0

I am making a database for a school project and I am stuck at a certain point. I am wondering if a link table always needs his own identifier or are the PK's from the two other tables good enough?

The reason why I ask this is that I cannot find a suitable PK for this link table. So could I skip this?

Thanks in advance

Maxime de Lange
  • 287
  • 2
  • 7
  • 21
  • 1
    I don't know what is your problem to solve, but a link table in most of the cases have the foreign keys as PK. That's the main purpose. – ismaestro Mar 29 '15 at 11:17
  • I was looking for this confirmation. I had my doubts and all of a sudden I didn't knew what was what. Thanks for your reply. At the moment my link table does only have both PK's (from the other two tables) as his FK's. So I think that's about right – Maxime de Lange Mar 29 '15 at 11:23

0 Answers0