Login | Datasets | Logout
 

VegBank Data Dictionary - Search Fields

  Search for a VegBank Field (enter a word, field name, etc.):    <<Hide search
Match any word
Match whole words only

   Search VegBank Tables Here
««more pages

«previous  | 1 | 2 | 3 | page 4 | 5 | 6 | 7 | 8 | 9 | 10 |  next»
records 31 through 40 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Community Usage Community Name COMMNAME_ID required Integer FK no This field is the foreign key into the commName table.
Community Usage Usage Start usageStart no Date n/a no This is the date on which the party applied the name to the concept.
Community Usage 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 Usage 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).
Community Usage 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).
Community Usage Comm Status COMMSTATUS_ID no Integer FK no Comm Status which applies to this commUsage.
Plant Concept ID PLANTCONCEPT_ID no serial PK no Database assigned value to each unique record in the commConcept table.
Plant Concept Plant Name PLANTNAME_ID required Integer FK no This is a foreign key into the plant name list, the entry in which when combined with a reference constitutes a concept.
Plant Concept Reference reference_ID required Integer FK no This is a foreign key to the reference in which the name was used, thereby defining a concept.
Plant Concept Plant Description plantDescription no text n/a no The plantDescription is a description of the plantConcept by the party contributing the plantConcept.

««more pages

«previous  | 1 | 2 | 3 | page 4 | 5 | 6 | 7 | 8 | 9 | 10 |  next»
records 31 through 40 of 503

more pages»»