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 |
|
|
|
|