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 scientist
s 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
Last activity: Apr 29, 2016, 07:08 PM