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

91010

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)	address
Table	Address
Field	Postal Code
DB Field Name	postalCode
Req'd?	no
Data Type	varchar (10)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Zip code or other postal code.

 

Table (DB Name)	address
Table	Address
Field	Country
DB Field Name	country
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Country of the physical address.

 

Table (DB Name)	address
Table	Address
Field	Address is Current?
DB Field Name	currentFlag
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This flag signifies whether the address is the current address of the party.

 

Table (DB Name)	address
Table	Address
Field	Address Start Date
DB Field Name	addressStartDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The first database date on which the address/organization information applied (have a discrete date on which address is known to applied - not necessarily the first date on which the address applied).

 

Table (DB Name)	aux_Role
Table	Role
Field	ID
DB Field Name	ROLE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the aux_Role table.
Definition	Database assigned value for a unique role code

 

Table (DB Name)	aux_Role
Table	Role
Field	Role Code
DB Field Name	roleCode
Req'd?	required
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	constraining list of role codes for *Contributor tables

 

Table (DB Name)	aux_Role
Table	Role
Field	Role Description
DB Field Name	roleDescription
Req'd?	no
Data Type	varchar (200)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Description of the role

 

Table (DB Name)	aux_Role
Table	Role
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)	reference
Table	Reference
Field	ID
DB Field Name	reference_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Primary key for the reference table.

 

Table (DB Name)	reference
Table	Reference
Field	Short Name
DB Field Name	shortName
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The 'shortName' field provides a concise or abbreviated name that describes the resource that is being documented.