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

321010

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)	party
Table	Party
Field	Middle Name
DB Field Name	middleName
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	One's middle name or initial, if any.

 

Table (DB Name)	party
Table	Party
Field	Surname
DB Field Name	surName
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name shared in common to identify the members of a family, as distinguished from each member's given name.

 

Table (DB Name)	party
Table	Party
Field	Organization Name
DB Field Name	organizationName
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of an organization.

 

Table (DB Name)	party
Table	Party
Field	Current Name
DB Field Name	currentName_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	n/a
Definition	Recursive foreign key to current name of this party.

 

Table (DB Name)	party
Table	Party
Field	Contact Instructions
DB Field Name	contactInstructions
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Instructions for contacting a party.

 

Table (DB Name)	party
Table	Party
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)	party
Table	Party
Field	Party Type
DB Field Name	partyType
Req'd?	no
Data Type	varchar (40)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	The type of party this is.
closed List of Values: Value Description Sorting user a private user of vegbank- party info not to be exported or displayed 1 person a person 2 team a group of persons, but not a whole organization 3 organization an entire organization 4 consortium a group of organizations 5

 

Table (DB Name)	partyMember
Table	Party Member
Field	Party Member ID
DB Field Name	partyMember_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database generated number to uniquely identify this record of this table.

 

Table (DB Name)	partyMember
Table	Party Member
Field	Main Party
DB Field Name	parentParty_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	n/a
Definition	Link to the parent party to whom the child party here belongs.

 

Table (DB Name)	partyMember
Table	Party Member
Field	Sub-Party
DB Field Name	childParty_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	n/a
Definition	Link to the child party who belongs to the parent listed in parentParty_ID.