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_tabledescriptionrevisionwhere_tablenamerevision

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