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 plantUsage
Table Plant Usage
Notes This table links a plant name with a concept.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID PLANTUSAGE_ID no serial PK no Database assigned value to each unique record in the plantUsage table.
Plant Name PLANTNAME_ID required Integer FK no This field is the foreign key into the plantName table.
Usage Start usageStart no Date n/a no This is the date on which the party applied the name to the concept.
Usage Stop usageStop no Date n/a no This is the date on which the party ceased to apply the name to the concept.
Plant Name Status plantNameStatus no varchar (20) n/a closed This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined).
Class System classSystem no varchar (50) n/a open This is the name of the classification system wherein the name is applied (e.g., EnglishCommon or Scientific).
Plant Status PLANTSTATUS_ID no Integer FK no Plant Status which applies to this plantUsage.