Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

detaildba_tabledescriptionprojectcontributorwhere_tablenameprojectContributor

VegBank Data Dictionary: Tables

Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Table >>

Search VegBank Fields Here

Show field labels | Show database names

DB Table Name	projectContributor
Table	Project Contributor
Notes	This table stores information about a party contributing to a project.
Description	This table serves as an intersection entity used to 'link' a party with a specific project wherein vegetation plots are described.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID PROJECTCONTRIBUTOR_ID no serial PK no Database generated identifier assigned to each unique contribution to a project. Project PROJECT_ID required Integer FK no Foreign key linking the contribution to a specific project. Party PARTY_ID required Integer FK no Foreign key linking the contribution to a specific party. Role ROLE_ID no Integer FK no Foreign key that identifies the role that a specific party played in the project (e.g., PI, coPI, contact, author, research advisor, etc.).