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

71010

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)	plantStatus
Table	Plant Status
Field	Plant Party Comments
DB Field Name	plantPartyComments
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Comments by party providing rationale for status assignment

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Plant Parent
DB Field Name	plantParent_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	plantConcept.PLANTCONCEPT_ID
List?	no
Notes	n/a
Definition	The plantParent is a recursive key to the concept of the parent level in the classification hierarchy. For example if this plantConcept were at the genus level the plantParent would be the plantConcept that is the family level (or subfamily level).

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Plant Level
DB Field Name	plantLevel
Req'd?	no
Data Type	varchar (80)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	The classLevel attribute specifies a level in the taxonomic hierarchy that a class belongs.
closed List of Values: Value Description Sorting Kingdom   1 Subkingdom   2 Superdivision   3 Division   4 Class   5 Subclass   6 Order   7 Suborder   8 Family   9 Subfamily   10 Tribe   11 Subtribe   12 Genus   13 Subgenus   14 Section   15 Species Aggregate   16 Species   17 Subspecies   18 Variety   19 Cultivar/Forma   20

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Party
DB Field Name	PARTY_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	n/a
Definition	Foreign key that identifies the party that made the status assignment

 

Table (DB Name)	plantStatus
Table	Plant Status
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)	plantUsage
Table	Plant Usage
Field	ID
DB Field Name	PLANTUSAGE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the plantUsage table.

 

Table (DB Name)	plantUsage
Table	Plant Usage
Field	Plant Name
DB Field Name	PLANTNAME_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantName.PLANTNAME_ID
List?	no
Notes	n/a
Definition	This field is the foreign key into the plantName table.

 

Table (DB Name)	plantUsage
Table	Plant Usage
Field	Usage Start
DB Field Name	usageStart
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the date on which the party applied the name to the concept.

 

Table (DB Name)	plantUsage
Table	Plant Usage
Field	Usage Stop
DB Field Name	usageStop
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the date on which the party ceased to apply the name to the concept.

 

Table (DB Name)	plantUsage
Table	Plant Usage
Field	Plant Name Status
DB Field Name	plantNameStatus
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined).
closed List of Values: Value Description Sorting standard   1 not standard   2 undetermined   3