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_tabledescriptiondefinedvaluewhere_tablenamedefinedvalue

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	definedValue
Table	Defined Value
Notes	This table stores the values of user-defined variables.
Description	This table stores values associated with specific user-defined variables identified in the userDefined table.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID DEFINEDVALUE_ID no serial PK no Database generated identifier assigned to each unique defined value. User Defined USERDEFINED_ID required Integer FK no Link to a specific user-defined variable defined in the userDefined table. Table Record tableRecord_ID required Integer n/a no The numeric value of the record number (primary key) that this user-defined value would have if it were in the table identified by USERDEFINED_ID. Defined Value definedValue required text n/a no The value of the user-defined variable.