Table source was originally designed as the list of publications from which data was extracted directly. Data submissions are stored with the following values:
first_author: Contributor name
title: 'Personal communication'
year: Contribution year
url: null
It may be better to distinguish between these cases by adding columns:
contributor: Name of the person who either extracted the data (from the publication given by first_author, title, year, url) or who submitted the data directly
date_added: Date that the data was added to the database
In this case, we need to determine who is contributor for each of the extracted data: Mylène Jacquemart, Guillem Carcanade (or both?).
Table
sourcewas originally designed as the list of publications from which data was extracted directly. Data submissions are stored with the following values:first_author: Contributor nametitle:'Personal communication'year: Contribution yearurl:nullIt may be better to distinguish between these cases by adding columns:
contributor: Name of the person who either extracted the data (from the publication given byfirst_author,title,year,url) or who submitted the data directlydate_added: Date that the data was added to the databaseIn this case, we need to determine who is
contributorfor each of the extracted data: Mylène Jacquemart, Guillem Carcanade (or both?).