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

221010

VegBank Data Dictionary: Field Details

Search for a VegBank Field (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Field >>

Search VegBank Tables Here

Table (DB Name)	note
Table	Note
Field	Role
DB Field Name	ROLE_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	aux_Role.ROLE_ID
List?	no
Notes	Foreign key into the aux_role table
Definition	What role was the party playing when the note was applied?

 

Table (DB Name)	note
Table	Note
Field	Note Date
DB Field Name	noteDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The date on which the note was stored in the database.

 

Table (DB Name)	note
Table	Note
Field	Note Type
DB Field Name	noteType
Req'd?	required
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	The type of note: Database Management, Observation Author, Database User and Internal. "Database Management" notes are those added by the management team and may be queried and viewed by the public. "Database Use" notes are those entered by the users of the database and are publicly viewable. "Internal" notes are for management to use internally and will not be broadcast.
closed List of Values: Value Description Sorting Clarification   0 Correction   0 Internal   0 Warning   0

 

Table (DB Name)	note
Table	Note
Field	Note Text
DB Field Name	noteText
Req'd?	required
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	actual note text
Definition	The text of the note.

 

Table (DB Name)	note
Table	Note
Field	Accession Code
DB Field Name	accessionCode
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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).

 

Table (DB Name)	noteLink
Table	Note Link
Field	ID
DB Field Name	NOTELINK_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the noteLink table
Definition	Database generated identifier assigned to each unique noteLink.

 

Table (DB Name)	noteLink
Table	Note Link
Field	Table Name
DB Field Name	tableName
Req'd?	required
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of the table that the note is associated with.

 

Table (DB Name)	noteLink
Table	Note Link
Field	Attribute Name
DB Field Name	attributeName
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of the attribute in the table (stored in tableName) that the note is associated with.

 

Table (DB Name)	noteLink
Table	Note Link
Field	Table Record
DB Field Name	tableRecord
Req'd?	required
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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).

 

Table (DB Name)	observation
Table	Observation
Field	OBSERVATION ID
DB Field Name	OBSERVATION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the observation table
Definition	Database generated identifier assigned to each unique plot observation.