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 noteLink
Table Note Link
Notes This table links a note made by a database user or manager to a specific table, record and attribute in the database.
Description This table was developed with the goal of keeping all the notes associated with the plots in a single table rather than distributed in many tables across the database.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID NOTELINK_ID no serial PK no Database generated identifier assigned to each unique noteLink.
Table Name tableName required varchar (50) n/a no Name of the table that the note is associated with.
Attribute Name attributeName no varchar (50) n/a no Name of the attribute in the table (stored in tableName) that the note is associated with.
Table Record tableRecord required Integer n/a no The record number (row) containing the value with which the note is associated (which translates to the primary key value for the table wherein the record is stored).