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  | page 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  next»
records 201 through 210 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Named Place Owner owner no varchar (100) n/a no Although somewhat redundant with the owner information contained in observationContributor with roleCode of owner, this allows the program to provide ownership information automatically. The ownership field supercedes this field in priority.
Named Place Reference reference_ID no Integer FK no Link to a reference that contains further information on the named place.
Named Place 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).
Named Place Correlation   NAMEDPLACECORRELATION_ID required serial PK no Primary Key.
Named Place Correlation Parent Place PARENTPLACE_ID required Integer FK no Link to a parent geographical region.
Named Place Correlation Child Place CHILDPLACE_ID required Integer FK no Link to a child geographical region.
Named Place Correlation Place Convergence placeConvergence required varchar (20) n/a closed This is the descriptive attribute that is used to relate the congruence between two places, Parent [convergence value] child (generally greater than).
Note ID NOTE_ID no serial PK no Database generated identifier assigned to each unique note.
Note Note Link NOTELINK_ID required Integer FK no Link to the noteLink table via which a note is associated with a table, record and attribute.
Note Party PARTY_ID required Integer FK no Link to the party table to identify the party that contributed the note.

««more pages

«previous  | page 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  next»
records 201 through 210 of 503

more pages»»