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 commUsage
Table Community Usage
Notes This table links a community name with a concept.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID COMMUSAGE_ID no serial PK no Database assigned value to each unique record in the communityUsage table.
Community Name COMMNAME_ID required Integer FK no This field is the foreign key into the commName 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.
Community Name Status commNameStatus 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., Scientific, Spanish common).
Comm Status COMMSTATUS_ID no Integer FK no Comm Status which applies to this commUsage.