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 | 4 | 5 | 6 | page 7 | 8 | 9 | 10 |  next»
records 61 through 70 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Plant Status Plant Party Comments plantPartyComments no text n/a no Comments by party providing rationale for status assignment
Plant Status 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 Status Plant Level plantLevel no varchar (80) n/a closed The classLevel attribute specifies a level in the taxonomic hierarchy that a class belongs.
Plant Status Party PARTY_ID required Integer FK no Foreign key that identifies the party that made the status assignment
Plant Status 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).
Plant Usage ID PLANTUSAGE_ID no serial PK no Database assigned value to each unique record in the plantUsage table.
Plant Usage Plant Name PLANTNAME_ID required Integer FK no This field is the foreign key into the plantName table.
Plant Usage Usage Start usageStart no Date n/a no This is the date on which the party applied the name to the concept.
Plant 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.
Plant Usage 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).

««more pages

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

more pages»»