Login | Datasets | Logout

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 VegBank Fields Here

Show field labels | Show database names

DB Table Name plantStatus
Table Plant Status
Notes This table store the status of a community concept as perceived by a party at a time.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID PLANTSTATUS_ID no serial PK no Database assigned value to each unique record in the plantStatus table.
Plant Concept PLANTCONCEPT_ID required Integer FK no Foreign key to identify the concept to which a party assigns a status
Reference reference_ID no Integer FK no Link to a reference where the status was reported
Plant Concept Status plantConceptStatus required varchar (20) n/a closed Status of the concept by the party (accepted, not accepted, undetermined)
Start Date startDate required Date n/a no This is the date for which the status assignment by the party started.
Stop Date stopDate no Date n/a no This is the date for which the status assignment by the party ended.
Plant Party Comments plantPartyComments no text n/a no Comments by party providing rationale for status assignment
Plant Parent plantParent_ID no Integer FK no 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).
Plant Level plantLevel no varchar (80) n/a closed The classLevel attribute specifies a level in the taxonomic hierarchy that a class belongs.
Party PARTY_ID required Integer FK no Foreign key that identifies the party that made the status assignment
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).