Login | Datasets | Logout
 

VegBank Data Dictionary - Search Fields

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

   Search VegBank Tables Here

««more pages

«previous  | 31 | 32 | 33 | 34 | 35 | 36 | 37 | page 38 | 39 | 40 |  next»
records 371 through 380 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Project ID PROJECT_ID no serial PK no Database generated identifier assigned to each unique project.
Project Project Name projectName required varchar (150) n/a no Project name as defined by the principal investigator.
Project Project Description projectDescription no text n/a no Short description of the project including the original purpose for conducting the project. This can be viewed as the project abstract plus supporting metadata.
Project Start Date startDate no Date n/a no Project start date.
Project Stop Date stopDate no Date n/a no Project stop date.
Project Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).
Project Contributor ID PROJECTCONTRIBUTOR_ID no serial PK no Database generated identifier assigned to each unique contribution to a project.
Project Contributor Project PROJECT_ID required Integer FK no Foreign key linking the contribution to a specific project.
Project Contributor Party PARTY_ID required Integer FK no Foreign key linking the contribution to a specific party.
Project Contributor 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.).

««more pages

«previous  | 31 | 32 | 33 | 34 | 35 | 36 | 37 | page 38 | 39 | 40 |  next»
records 371 through 380 of 503

more pages»»