collaborators


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
datasetcollaborators.collaborator_id datasetcollaborators_ibfk_2 C
projectcollaborators.collaborator_id projectcollaborators_ibfk_1 C
first_name VARCHAR 255 null

Last name (surname) of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
last_name VARCHAR 255 null

First name (and middle name if available) of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
email VARCHAR 255 √ null

E-mail address of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
phone VARCHAR 255 √ null

Phone number of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
external_id VARCHAR 255 √ null

An identifier for the data submitter. If that submitter is an individual, ORCID identifiers are recommended.
institution_id INT 10 √ null
institutions.id collaborators_ibfk_1 N

Author’s affiliation when the resource was created. Foreign key to ‘institutions’
created_on DATETIME 19 √ CURRENT_TIMESTAMP

When the record was created.
updated_on TIMESTAMP 19 √ CURRENT_TIMESTAMP

When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
institution_id Performance Asc institution_id

Relationships

Close relationships within degrees of separation