Study_Personnel

PERSONNEL associated with a STUDY.

Columns
Name Type Description Foreign Key
person_accession varchar(15) Primary key
site_name varchar(100) Name of the site
email varchar(100) Email address for the individual in this data record
first_name varchar(40) First name
honorific varchar(20) Honorific title for the individual in this data record
last_name varchar(40) Family name
orcid varchar(1000) Open Researcher and Contributer ID
organization varchar(125) Organization or institution
role_in_study varchar(40) Role for personnel lk_personnel_role.name
study_accession varchar(15) Foreign key reference to the STUDY table study.study_accession
suffixes varchar(40) Name suffix
title_in_study varchar(100) Personnel title
workspace_id int(11) Foreign key reference to WORKSPACE table
Indexes
Name Column Description
PRIMARY person_accession BTREE
fk_study_personnel_1 study_accession BTREE
fk_study_personnel_2 role_in_study BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top