Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

detaildba_tabledescriptionnotelinkwhere_tablenamenotelink

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 for VegBank Table >>

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).