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

61010

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)	plantName
Table	Plant Name
Field	ID
DB Field Name	PLANTNAME_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the plantName table.

 

Table (DB Name)	plantName
Table	Plant Name
Field	Plant Name
DB Field Name	plantName
Req'd?	required
Data Type	varchar (255)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The plant name.

 

Table (DB Name)	plantName
Table	Plant Name
Field	Reference
DB Field Name	reference_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	n/a
Definition	Foreign key into the reference table to identify the original source of the name (usually the type description).

 

Table (DB Name)	plantName
Table	Plant Name
Field	Date Entered
DB Field Name	dateEntered
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Field stores the date that the name was entered into the database.

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	ID
DB Field Name	PLANTSTATUS_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the plantStatus table.

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Plant Concept
DB Field Name	PLANTCONCEPT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantConcept.PLANTCONCEPT_ID
List?	no
Notes	n/a
Definition	Foreign key to identify the concept to which a party assigns a status

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Reference
DB Field Name	reference_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	n/a
Definition	Link to a reference where the status was reported

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Plant Concept Status
DB Field Name	plantConceptStatus
Req'd?	required
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	Status of the concept by the party (accepted, not accepted, undetermined)
closed List of Values: Value Description Sorting accepted   1 not accepted   2 undetermined   3

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Start Date
DB Field Name	startDate
Req'd?	required
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the date for which the status assignment by the party started.

 

Table (DB Name)	plantStatus
Table	Plant Status
Field	Stop Date
DB Field Name	stopDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the date for which the status assignment by the party ended.