collaborators


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
datasetcollaborators.collaborator_id datasetcollaborators_ibfk_2C
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.
institution_id INT 10 √ null
institutions.id collaborators_ibfk_1N

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

When the record was created.
updated_on TIMESTAMP 26 √ 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