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

381010

VegBank Data Dictionary: Field Details

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

Search VegBank Tables Here

Table (DB Name)	project
Table	Project
Field	ID
DB Field Name	PROJECT_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the project table.
Definition	Database generated identifier assigned to each unique project.

 

Table (DB Name)	project
Table	Project
Field	Project Name
DB Field Name	projectName
Req'd?	required
Data Type	varchar (150)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Project name as defined by the principal investigator.

 

Table (DB Name)	project
Table	Project
Field	Project Description
DB Field Name	projectDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Short description of the project including the original purpose for conducting the project. This can be viewed as the project abstract plus supporting metadata.

 

Table (DB Name)	project
Table	Project
Field	Start Date
DB Field Name	startDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Project start date.

 

Table (DB Name)	project
Table	Project
Field	Stop Date
DB Field Name	stopDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Project stop date.

 

Table (DB Name)	project
Table	Project
Field	Accession Code
DB Field Name	accessionCode
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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).

 

Table (DB Name)	projectContributor
Table	Project Contributor
Field	ID
DB Field Name	PROJECTCONTRIBUTOR_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the projectContributor table.
Definition	Database generated identifier assigned to each unique contribution to a project.

 

Table (DB Name)	projectContributor
Table	Project Contributor
Field	Project
DB Field Name	PROJECT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	project.PROJECT_ID
List?	no
Notes	Foreign key into the project table
Definition	Foreign key linking the contribution to a specific project.

 

Table (DB Name)	projectContributor
Table	Project Contributor
Field	Party
DB Field Name	PARTY_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	Foreign key into the party table
Definition	Foreign key linking the contribution to a specific party.

 

Table (DB Name)	projectContributor
Table	Project Contributor
Field	Role
DB Field Name	ROLE_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	aux_Role.ROLE_ID
List?	no
Notes	Foreign key into aux_Role table
Definition	Foreign key that identifies the role that a specific party played in the project (e.g., PI, coPI, contact, author, research advisor, etc.).