Sample Header Ad - 728x90

Multiple references to another table, but I don't know how many

-1 votes
1 answer
45 views
I have two tables in a database, folowwing this model: scientists : id (int) | name (varchar) | surname (varchar) | publications (int) publications : id (int) | fulltext (varchar) I would like to add a field to the publications table which refers to scientists' id, but I don't know how many scientists will be reffered to (can be 0, 1 or any other positive number) in order to ease the count of publications for each scientist. What are my options ? Is my approach wrong ?
Asked by Magix (109 rep)
Apr 29, 2016, 07:03 PM
Last activity: Apr 29, 2016, 07:08 PM