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 commClass
Table Community Classification
Notes This table stores general information about classification events where one or more community concepts were applied to a specific Observation by one or more parties.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID COMMCLASS_ID no serial PK no Database generated identifier assigned to each unique observation classification event.
Observation OBSERVATION_ID required Integer FK no Link to the observation table identifying which observation is being classified.
Classification Start Date classStartDate no Date n/a no Start date for the application of a vegetation class to a plot observation by one or more parties.
Classification Stop Date classStopDate no Date n/a no Stop date for the application of a vegetation class to a plot observation by one or more parties.
Inspection inspection no Boolean n/a no Classification informed by simple inspection of data.
Table Analysis tableAnalysis no Boolean n/a no Classification informed by inspection of floristic composition tables.
Multivariate Analysis multivariateAnalysis no Boolean n/a no Classification informed by use of multivariate numerical tools.
Expert System expertSystem no text n/a no Description of any automated expert system used in classification.
Classification Publication classPublication_ID no Integer FK no Link to a publication wherein the observation was classified.
Classification Notes classNotes no text n/a no Notes about the classification event by the parties participating in the event. This might include the purpose or rationale for the classification.
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).