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 revision
Table Revision
Notes This table constitutes a log of changes in data deposited in the database.
Description This table was designed to store as a single, stand-alone table information about attributes in any of the database tables.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID REVISION_ID no serial PK no Database generated identifier assigned to each unique revision.
Table Name tableName required varchar (50) n/a no Name of the table where the change occurred.
Table Attribute tableAttribute required varchar (50) n/a no The name of the attribute where the chance occurred.
Table Record tableRecord required Integer n/a no The number of the record in which the change occurred (i.e., the value of the primary key associated with the value in which the change occurred)
Revision Date revisionDate required Date n/a no The date on which the revision was made.
Previous Value Text previousValueText required text n/a no The previous value as a character string.
Previous Value Type previousValueType required varchar (20) n/a no The data type of the attribute changed.
Previous Revision previousRevision_ID no Integer FK no Pointer to a previous record of a revision.