GRIN-NPGS Data Dictionary

Taxonomy Area, Tables Owned by PROD




Taxonomy Area Table Diagram

[AREA TABLE DIAGRAM]

------- Return to: [Columns] [Areas] -------

Common name table (CN)

Definition
Table of common names for the taxon. The most commonly used name should be listed first.

Rules
Only SBML and DBMU can add, update or delete cn records.

Constraint
Primary key
Columns: cname, taxno.

Foreign key
Column: taxno. References table TAX (taxno).

Other indexes
Non-unique on column: cname.

Non-unique on column: cnid.

------- Return to: [Columns] [Areas] -------

Species number (taxno)

Characteristics
NUMBER(8), Required

Definition
The internal species identifier for this common name.

Rules
Foreign key. Link to tax table. Cannot be updated.
If tax record deleted, cn record automatically deleted.

------- Return to: [Columns] [Areas] -------

Common name (cname)

Characteristics
VARCHAR2(50), Required

Definition
Common name for the taxon.

------- Return to: [Columns] [Areas] -------

Common name source (source)

Characteristics
VARCHAR2(20), Optional

Definition
Source of the common name (e.g., literature).

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
General comments about the common name.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
VARCHAR2(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Search identifier (cnid)

Characteristics
VARCHAR2(50), Optional, Software supplied

Definition
The plantid with all punctuation and special characters removed, then all characters converted to uppercase.

------- Return to: [Columns] [Areas] -------

Economic uses table (USES)

Definition
Table of the economic uses of the taxa. It follows the standards set by the International Working Group on Plant Taxonomic Databases (TDWG).

Rules
Only SBML and DBMU can add, update or delete uses records.

Constraint
Primary key
Columns: taxno, taxuse.

Foreign key
Column: taxno. References table TAX (taxno).

Other indexes
Non-unique on column: taxuse.

------- Return to: [Columns] [Areas] -------

Species number (taxno)

Characteristics
NUMBER(8), Required

Definition
The internal species identifier that indicates the taxonomy for the economic use.

Rules
Foreign key. Link to tax table. Cannot be updated.
If tax record deleted, uses record automatically deleted.

------- Return to: [Columns] [Areas] -------

Economic usage (taxuse)

Characteristics
VARCHAR2(10), Required, Coded

Definition
Economic usage from the International Working Group on Plant Taxonomic Databases (TDWG).

Rules
Standard codes. Uppercase.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     ADDITIVE   Food additives                           Std.    
     ALTHOST    Harmful organism host                    Std.    
     BEE        Bee plants                               Std.    
     CITESI     CITES Appendix I                         Std.    
     CITESII    CITES Appendix II                        Std.    
     CITESIII   CITES Appendix III                       Std.    
     CPC        Center for Plant Conservation listed     Std.    
     ENVIRON    Environmental                            Std.    
     FOOD       Human food                               Std.    
     FORAGE     Animal food                              Std.    
     FUEL       Fuels                                    Std.    
     FWE        Fish & Wildlife Endangered species       Std.    
     FWT        Fish & Wildlife Threatened species       Std.    
     GENETIC    Gene sources                             Std.    
     HOST       Invertebrate food                        Std.    
     MATERIAL   Materials                                Std.    
     MEDICINE   Medicines                                Std.    
     PESTICIDE  Non-vertebrate poisons                   Std.    
     POISON     Vertebrate poisons                       Std.    
     SOCIAL     Social                                   Std.    
     WEED       Weed                                     Std.    
Code Comments

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
This field contains general comments about the economic use of this species.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Category of uses (usetype)

Characteristics
VARCHAR2(250), Optional, Coded

Definition
Category of uses.

------- Return to: [Columns] [Areas] -------

Family table (FAM)

Definition
Table of valid family names and other levels above genus for look-up on data entry and edit checking. It can also be used for constructing queries but would be less appropriate than the family name in the genus record.

Rules
Only SBML and DBMU can add, update or delete fam records.

Constraint
Primary key
Column: famno.

Foreign key
Column: validfamno. References table FAM (famno).

Unique key
Columns: family, famauthor, subfamily, tribe, subtribe.

------- Return to: [Columns] [Areas] -------

Family number (famno)

Characteristics
NUMBER(8), Required, Software supplied

Definition
The unique internal identifier for the classification above the genus level. It serves as a link between the family table and other tables in the database.

Rules
Primary key. Unique sequence number. Can be updated unless referenced in other tables.

------- Return to: [Columns] [Areas] -------

Valid family number (validfamno)

Characteristics
NUMBER(8), Optional

Definition
Family number for the valid family if this is a synonym.

Rules
Foreign key. Link to fam table.
If validfamno = famno, family = valid family.
If validfamno <> famno, family = synonym.

------- Return to: [Columns] [Areas] -------

Family name (family)

Characteristics
VARCHAR2(25), Required

Definition
Family names ending in "aceae".

Example
Asteraceae
Apiaceae

Rules
Initcap.

------- Return to: [Columns] [Areas] -------

Family authority (famauthor)

Characteristics
VARCHAR2(100), Optional

Definition
Authority of the family.

Rules
Each author name checked against taut table.

------- Return to: [Columns] [Areas] -------

Alternate family (altfamily)

Characteristics
VARCHAR2(25), Optional, Software supplied

Definition
Conserved alternate family name.

Example
Compositae
Umbelliferae

Rules
Initcap.

------- Return to: [Columns] [Areas] -------

Subfamily division (subfamily)

Characteristics
VARCHAR2(25), Optional

Definition
Subfamily division of the family.

Rules
Initcap.

------- Return to: [Columns] [Areas] -------

Tribe division (tribe)

Characteristics
VARCHAR2(25), Optional

Definition
Tribe division of the family.

Rules
Initcap. Must have subfamily to add tribe.

------- Return to: [Columns] [Areas] -------

Subtribe division (subtribe)

Characteristics
VARCHAR2(25), Optional

Definition
Subtribe division of the family.

Rules
Initcap. Must have tribe to add subtribe.

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
General comments about the family information.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Genus table (GN)

Definition
Table of genera of both accepted names and synonyms. It also includes all classification levels between the genus and species levels for grouping taxa. Intergeneric hybrids are flagged in a separate field so that the genus names sort properly. The gno field is the primary key and is applied to a complete classification from genus down to subseries.

Rules
Only SBML and DBMU can add, update or delete gn records.

Unique key = genus, gauthor, subgenus, section, series,
subseries.

Constraint
Primary key
Column: gno.

Foreign key
Column: famno. References table FAM (famno).

Column: validgno. References table GN (gno).

Unique key
Columns: genus, gauthor, subgenus, section, subsection, series, subseries.

Other indexes
Non-unique on column: cname.

------- Return to: [Columns] [Areas] -------

Genus number (gno)

Characteristics
NUMBER(8), Required, Software supplied

Definition
The unique internal identifier assigned to genus, and subgeneric levels. It serves as a link between the genus table and other tables in the database.

Rules
Primary key. Unique sequence number. Cannot be updated.

------- Return to: [Columns] [Areas] -------

Valid genus number (validgno)

Characteristics
NUMBER(8), Optional

Definition
Genus number for valid genus if this is a synonym.

Rules
Foreign key. Link to gn table.
If validgno = gno, genus = valid genus.
If validgno <> gno, genus = synonym.

------- Return to: [Columns] [Areas] -------

Qualifier code (qual)

Characteristics
CHAR(2), Optional, Coded

Definition
Code qualifying the genus name if the name is a synonym.

Rules
Standard codes. Uppercase.
On insert or update: if validgno = gno, qual = ~ or null.
On insert or update: if validgno <> gno and qual is null, set qual to '='.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
      ~         Possibly a synonym                       Std.    
     =          Is a synonym                             Std.    
     =~         Usually considered a synonym             Std.    
     ?          Tentative synonym                        Std.    
     ~                                                   Std.    
------- Return to: [Columns] [Areas] -------

Genus hybrid flag (ghybrid)

Characteristics
CHAR(1), Optional, Coded

Definition
A code to indicate this is a hybrid (X) or root cross (+).

Rules
Standard codes. Uppercase.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     +          Graft-chimera hybrid                     Std.    
     N          Intersubgeneric hybrid                   Std.    
     X          Intergeneric hybrid                      Std.    
Code Comments

------- Return to: [Columns] [Areas] -------

Genus name (genus)

Characteristics
VARCHAR2(30), Required

Definition
Genus name for the taxon in the database.

Example
Triticum
Zea

Rules
Initcap.

------- Return to: [Columns] [Areas] -------

Genus authority (gauthor)

Characteristics
VARCHAR2(100), Optional

Definition
Authority of the genus.

Rules
Each author name checked against taut table (future).

------- Return to: [Columns] [Areas] -------

Subgenus name (subgenus)

Characteristics
VARCHAR2(30), Optional

Definition
Subgenus name for a genus.

Rules
Initcap.

------- Return to: [Columns] [Areas] -------

Section name (section)

Characteristics
VARCHAR2(30), Optional

Definition
The section name for a genus.

Rules
Initcap. Must have subgenus to add section.

------- Return to: [Columns] [Areas] -------

Series name (series)

Characteristics
VARCHAR2(30), Optional

Definition
The series name for a genus.

Rules
Initcap. Must have section to add series.

------- Return to: [Columns] [Areas] -------

Subseries name (subseries)

Characteristics
VARCHAR2(30), Optional

Definition
The subseries name for a genus.

Rules
Initcap. Must have series to add subseries.

------- Return to: [Columns] [Areas] -------

Family number (famno)

Characteristics
NUMBER(8), Optional

Definition
The internal identifier for the classification above the genus level.

Rules
Foreign key. Link to fam table.

------- Return to: [Columns] [Areas] -------

Alternate family (othfamily)

Characteristics
VARCHAR2(100), Optional

Definition
Alternate families in which the genus has been placed.

Rules
Initcap. Must be one or more families from fam table (may be synonyms).

------- Return to: [Columns] [Areas] -------

Common name (cname)

Characteristics
VARCHAR2(30), Optional

Definition
Common name for the genus.

Rules
Initcap.

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
General comments about the genus name.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Subsection (subsection)

Characteristics
VARCHAR2(30), Optional

Definition
The subsection name for a genus.

------- Return to: [Columns] [Areas] -------

Genus citation table (GCIT)

Definition
Table of literature citations of generic names. It matches the species citation table in structure but links to the genus table instead of the taxon table.

Rules
Only SBML and DBMU can add, update or delete gcit records.

Minimum data to add a gcit record is one of these fields: abbr, cittitle.

Constraint
Primary key
Column: citno.

Foreign key
Column: gno. References table GN (gno).

Column: abbr. References table LIT (abbr).

------- Return to: [Columns] [Areas] -------

Citation number (citno)

Characteristics
NUMBER(8), Required, Software supplied

Definition
The unique internal identifier assigned to the genus citation. It serves as a link between the genus citation table and other tables in the database.

Rules
Primary key. Unique sequence number. Cannot be updated.

------- Return to: [Columns] [Areas] -------

Genus number (gno)

Characteristics
NUMBER(8), Required

Definition
The internal genus identifier for the citation.

Rules
Foreign key. Link to gn table.
If gn record deleted, gcit record automatically deleted.

------- Return to: [Columns] [Areas] -------

Reference abbreviation (abbr)

Characteristics
VARCHAR2(20), Optional

Definition
The short abbreviation for this reference.

Example
Crop Sci
Agron J
Ann Bot
F Ariz

Rules
Foreign key. Link to lit table.

------- Return to: [Columns] [Areas] -------

Citation title (cittitle)

Characteristics
VARCHAR2(240), Optional

Definition
The title of the article or chapter.

Example
Registration of ICGV 86564 Peanut Germplasm
Registration of Bayshore Smooth Cordgrass
Inheritance of Adult-Plant Resistance to Powdery Mildew in
Knox 62 and Massey Winter Wheats
Systematics, Diversity, and Germplasm

Rules
cittitle <> lit.reftitle or lit.stdabbr.

------- Return to: [Columns] [Areas] -------

Author of publication (author)

Characteristics
VARCHAR2(240), Optional

Definition
Author(s) of the article or chapter.

Example
R.R. Kalton, P. Richardson
P.E. Lake

------- Return to: [Columns] [Areas] -------

Citation year (cityr)

Characteristics
NUMBER(4), Optional

Definition
The year the citation was published or made available.

Rules
Values between 1600 and (current year + 1).

------- Return to: [Columns] [Areas] -------

Citation reference (citref)

Characteristics
VARCHAR2(60), Optional

Definition
The citation (volume, page, etc.) within the journal or book.

Example
34(1):300
18(10):920
pp. 3-11

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
General comments about the genus citation.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Species distribution table (DIST)

Definition
Table of species distributions. It serves as a link structure between the taxon table and the geo table.

Rules
Only SBML can add, update or delete dist records.

Constraint
Primary key
Column: distno.

Foreign key
Column: geono. References table GEO (geono).

Column: taxno. References table TAX (taxno).

------- Return to: [Columns] [Areas] -------

Species distributions number (distno)

Characteristics
NUMBER(8), Required, Software supplied

Definition
The unique internal identifier assigned to the distribution.

Rules
Primary key. Unique sequence number. Cannot be updated.

------- Return to: [Columns] [Areas] -------

Species number (taxno)

Characteristics
NUMBER(8), Required

Definition
The internal species identifier that indicates the taxonomy for the species distribution.

Rules
Foreign key. Link to tax table.
If tax record deleted, dist record automatically deleted.

------- Return to: [Columns] [Areas] -------

Geographic number (geono)

Characteristics
NUMBER(8), Optional

Definition
The internal geographic identifier to indicate the species range.

Rules
Foreign key. Link to geo table.

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
General comments about the distribution of the taxon in the country.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Taxonomic web links table (TURL)

Definition
Table of URL links to images or pages about a taxonomic name.

Constraint
Primary key
Column: turlno.

Foreign key
Column: famno. Delete rule Cascade. References table FAM (famno).

Column: gno. Delete rule Cascade. References table GN (gno).

Column: site. References table MAIN.SITE (site).

Column: taxno. Delete rule Cascade. References table TAX (taxno).

------- Return to: [Columns] [Areas] -------

Taxonomic URL number (turlno)

Characteristics
NUMBER(8), Required

Definition
Taxonomic URL number.

------- Return to: [Columns] [Areas] -------

URL type (urltype)

Characteristics
VARCHAR2(10), Required, Coded

Definition
Code for the type of page.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     IMAGE      Image link                               SBML    
     LINK       Http link                                Std.    
------- Return to: [Columns] [Areas] -------

Family number (famno)

Characteristics
NUMBER(8), Required

Definition
Internal identifier for the family.

------- Return to: [Columns] [Areas] -------

Genus number (gno)

Characteristics
NUMBER(8), Optional

Definition
Internal identifier for the genus.

------- Return to: [Columns] [Areas] -------

Taxonomic number (taxno)

Characteristics
NUMBER(8), Optional

Definition
Internal identifier for the taxon.

------- Return to: [Columns] [Areas] -------

Caption (caption)

Characteristics
VARCHAR2(240), Optional

Definition
Caption to display if no image is shown.

------- Return to: [Columns] [Areas] -------

URL (url)

Characteristics
VARCHAR2(100), Required

Definition
Full URL address of the page.

------- Return to: [Columns] [Areas] -------

Site (site)

Characteristics
VARCHAR2(8), Required

Definition
The site responsible for the Taxonomic URL record.

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
General comment about the link.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
VARCHAR2(10), Required, Software supplied

Definition
Person who entered or last updated the record.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Required

Definition
The date the record was entered into the database.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional

Definition
The date the record was last updated.

------- Return to: [Columns] [Areas] -------

Taxonomy table (TAX)

Definition
Table of taxa, for both currently accepted names and synonyms. All levels from species to forma are covered by this table. Cultivars are in the accession level (acc) table. Synonyms refer to accepted names in the same table through the validtaxno column. The genus name is provided to reduce the number of records that need to be linked to get information, likewise the shortest complete name for the taxon is found in the taxon column.

Rules
A site can update sitecmt field only. SBML and DBMU can add, update or delete tax records.

If taxon changed to a synonym, automatically update accessions to new valid taxon and create al records where action = NOM-CHANGE.

Constraint
Primary key
Column: taxno.

Foreign key
Column: cno. References table COOP (cno).

Column: cropno. References table CROP (cropno).

Column: gno. References table GN (gno).

Column: psite1. References table MAIN.SITE (site).

Column: psite2. References table MAIN.SITE (site).

Column: validtaxno. References table TAX (taxno).

Unique key
Columns: taxon, taxauthor.

------- Return to: [Columns] [Areas] -------

Species number (taxno)

Characteristics
NUMBER(8), Required, Software supplied

Definition
The unique internal identifier for the taxon/species.

Example
40544
100001

Rules
Primary key. Unique sequence number. Cannot be updated.

------- Return to: [Columns] [Areas] -------

Valid species number (validtaxno)

Characteristics
NUMBER(8), Optional

Definition
Species identifier for the valid taxon if this is a synonym.

Rules
Foreign key. Link to tax table.
If validtaxno = taxno, taxon = valid name.
If validtaxno <> taxno, taxon = synonym.

------- Return to: [Columns] [Areas] -------

Interspecific hybrid flag (shybrid)

Characteristics
CHAR(1), Optional, Coded

Definition
A code to show that this taxon is an interspecific hybrid.

Rules
Standard codes. Lowercase.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     x          Interspecific hybrid                     Std.    
------- Return to: [Columns] [Areas] -------

Specific epithet (species)

Characteristics
VARCHAR2(30), Required

Definition
The specific epithet of the scientific name.

Example
aestivum
mays

Rules
Lowercase.
If species name starts with a hybrid flag, move to hybrid field and strip from name.

------- Return to: [Columns] [Areas] -------

Species author (sauthor)

Characteristics
VARCHAR2(100), Optional

Definition
The authority for the specific epithet.

Example
L.
Boiss.

Rules
Each author name checked against taut table.

------- Return to: [Columns] [Areas] -------

Intraspecific hybrid flag (ssphybrid)

Characteristics
CHAR(1), Optional, Coded

Definition
A code to indicate this taxon is an intraspecific hybrid.

Rules
Standard codes. Lowercase.
Must have subsp to add ssphybrid.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     n          Intraspecific hybrid (nothosubspecies)   Std.    
------- Return to: [Columns] [Areas] -------

Subspecific epithet (subsp)

Characteristics
VARCHAR2(30), Optional

Definition
The subspecific epithet for the taxon.

Example
mays
mexicana

Rules
Lowercase.

------- Return to: [Columns] [Areas] -------

Subspecies authority (sspauthor)

Characteristics
VARCHAR2(100), Optional

Definition
The authority for the subspecific epithet.

Example
(L.) I. Ferg.
(Willd.) P. Silva
Waldron

Rules
Each author name checked against taut table (future).

------- Return to: [Columns] [Areas] -------

Intervarietal hybrid flag (varhybrid)

Characteristics
CHAR(1), Optional, Coded

Definition
A code to indicate this taxon is an intervarietal hybrid.

Rules
Standard codes. Lowercase.
Must have var to add varhybrid.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     n          Intervarietal hybrid (nothovariety)      Std.    
------- Return to: [Columns] [Areas] -------

Botanical variety (var)

Characteristics
VARCHAR2(30), Optional

Definition
The botanical variety of the species.

Example
hirsuta
glaucus

Rules
Lowercase.

------- Return to: [Columns] [Areas] -------

Varietal authority (varauthor)

Characteristics
VARCHAR2(100), Optional

Definition
The authority for the varietal epithet.

Example
Kohler
(Bertoni) L. B. Smith

Rules
Each author name checked against taut table (future).

------- Return to: [Columns] [Areas] -------

Subvarietal hybrid flag (svhybrid)

Characteristics
CHAR(1), Optional, Coded

Definition
A code to indicate that this taxon is a subvarietal hybrid.

Rules
Standard codes. Lowercase.
Must have subvar to add svhybrid.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     p          Prol.                                    Std.    
     r          Race                                     Std.    
     t                                                   Std.    
------- Return to: [Columns] [Areas] -------

Subvarietal epithet (subvar)

Characteristics
VARCHAR2(30), Optional

Definition
The subvarietal epithet for the taxon.

Rules
Lowercase.

------- Return to: [Columns] [Areas] -------

Subvarietal epithet authority (svauthor)

Characteristics
VARCHAR2(100), Optional

Definition
The authority for the subvarietal epithet.

Rules
Each author name checked against taut table (future).

------- Return to: [Columns] [Areas] -------

Forma or lower rank code (fhybrid)

Characteristics
CHAR(1), Optional, Coded

Definition
A code to indicate this taxon is an interforma hybrid.

Rules
Standard codes. Lowercase.
Must have forma to add fhybrid.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     n          Interforma hybrid (nothoforma)           Std.    
------- Return to: [Columns] [Areas] -------

Forma or low rank (forma)

Characteristics
VARCHAR2(30), Optional

Definition
The botanical form of the species, or lower rank (e.g., race), often a local variant caused by something in the environment.

Example
nana
pendula

Rules
Lowercase.

------- Return to: [Columns] [Areas] -------

Forma authority (fauthor)

Characteristics
VARCHAR2(100), Optional

Definition
The authority for the forma epithet.

Example
Nakai
(Carr.) Rehder

Rules
Each author name checked against taut table (future).

------- Return to: [Columns] [Areas] -------

Genus record number (gno)

Characteristics
NUMBER(8), Required

Definition
The internal genus identifier to indicate the full classification of the taxon.

Rules
Foreign key. Link to gn table.

------- Return to: [Columns] [Areas] -------

Crop number (cropno)

Characteristics
NUMBER(8), Optional

Definition
The internal crop identifier for this taxonomy.

Rules
Foreign key. Link to crop table.

------- Return to: [Columns] [Areas] -------

First priority site (psite1)

Characteristics
VARCHAR2(8), Optional

Definition
The first priority site in the NPGS.

Rules
Foreign key. Link to site table.

------- Return to: [Columns] [Areas] -------

Second priority site (psite2)

Characteristics
VARCHAR2(8), Optional

Definition
The second priority site in the NPGS.

Rules
Foreign key. Link to site table.
Move psite2 to psite1 if psite1 null.

------- Return to: [Columns] [Areas] -------

Restriction (rest)

Characteristics
VARCHAR2(10), Optional, Coded

Definition
Restrictions on the taxon that may affect distribution.

Rules
Standard codes. Uppercase.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     NARCOTIC   Used to produce narcotics                Std.    
     RARE       Rare or endangered                       Std.    
     WEED       Noxious weed                             Std.    
------- Return to: [Columns] [Areas] -------

Life form (lifeform)

Characteristics
VARCHAR2(10), Optional, Coded

Definition
The normal life form of the species.

Rules
Standard codes. Uppercase.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     ANN-BI-PER Annual/Biennial and/or Perennial         Std.    
     ANN-BIE    Annual and/or Biennial                   Std.    
     ANN-PER    Annual and/or Perennial                  Std.    
     ANNUAL     Annual                                   Std.    
     BIE-PER    Biennial and/or Perennial                Std.    
     BIENNIAL   Biennial                                 Std.    
     PERENNIAL  Perennial                                Std.    
     SHRUB      Shrub                                    Std.    
     TREE       Tree                                     Std.    
     VINE       Vine                                     Std.    
------- Return to: [Columns] [Areas] -------

Fertilization (fert)

Characteristics
VARCHAR2(10), Optional, Coded

Definition
The type of fertilization that is common in this species.

Rules
Standard codes. Uppercase.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     INSECT     Insect pollination                       Std.    
     OTHER      Other pollination methods                Std.    
     PARTIAL    Partial pollination                      Std.    
     SELF       Self pollination                         Std.    
     WIND       Wind pollination                         Std.    
------- Return to: [Columns] [Areas] -------

Questionable name flag (pending)

Characteristics
CHAR(1), Optional

Definition
A flag ('X') to indicate that the name is in question.

Rules
Value = X.
User supplied and maintained.

------- Return to: [Columns] [Areas] -------

Qualifier code (qual)

Characteristics
VARCHAR2(6), Optional, Coded

Definition
Code(s) for synonyms to show what type it is.

Rules
Standard codes. Uppercase.

Codes
     Value      Definition                               Site    
     =====      ==========                               ====    
     =          Synonym - complete replacement           Std.    
     =~         Synonym - some doubt                     Std.    
     B          Basionym                                 Std.    
     S          Synonym                                  Std.    
     ~          Synonym - not consensus                  Std.    
------- Return to: [Columns] [Areas] -------

Cooperator number (cno)

Characteristics
NUMBER(8), Optional

Definition
The internal cooperator identifier indicating the person who verified this name.

Rules
Foreign key. Link to coop table.

------- Return to: [Columns] [Areas] -------

Date verified (verified)

Characteristics
DATE, Optional

Definition
The date the name was verified.

Rules
Must be a valid date.

------- Return to: [Columns] [Areas] -------

Scientific name (taxon)

Characteristics
VARCHAR2(100), Optional, Software supplied

Definition
The binomial or trinomial name of the taxon.

Example
Triticum aestivum

Rules
On input or update: generated from genus, species, and lowest rank, if below species.

------- Return to: [Columns] [Areas] -------

Taxonomic name authority (taxauthor)

Characteristics
VARCHAR2(100), Optional, Software supplied

Definition
The authority of the taxonomic name.

Rules
Value of lowest rank authority.

------- Return to: [Columns] [Areas] -------

Original citation (protologue)

Characteristics
VARCHAR2(240), Optional

Definition
The original literature reference for the species.

Example
Rhodora 42: 524. 1940
Bibl. Cult. Trees + Shrubs. 51. 1949

------- Return to: [Columns] [Areas] -------

Taxonomic comment (taxcmt)

Characteristics
VARCHAR2(2000), Optional

Definition
Taxonomic comments.

Rules
Only entered by SBML.

------- Return to: [Columns] [Areas] -------

Site comment (sitecmt)

Characteristics
VARCHAR2(240), Optional

Definition
Comments on the name, added by the repository curators.

Rules
Only entered by psite1 or psite2.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Other name (othname)

Characteristics
VARCHAR2(240), Optional

Definition
An alternate name for the taxon under the International Code of
Nomenclature for Cultivated Plants.

------- Return to: [Columns] [Areas] -------

Taxonomy citation table (TCIT)

Definition
Table of the citation reference for recent literature about a taxon. The taxno links this record to the taxon and the abbr links it to the list of literature.

Rules
Only SBML and DBMU can add, update or delete tcit records.

Minimum data to add a tcit record is one of these fields: abbr, cittitle.

Constraint
Primary key
Column: citno.

Foreign key
Column: abbr. References table LIT (abbr).

Column: taxno. References table TAX (taxno).

------- Return to: [Columns] [Areas] -------

Citation number (citno)

Characteristics
NUMBER(8), Required, Software supplied

Definition
The unique internal identifier assigned to the taxonomic citation. It serves as a link between the taxonomic citation table and other tables in the database.

Rules
Primary key. Unique sequence number. Cannot be updated.

------- Return to: [Columns] [Areas] -------

Species number (taxno)

Characteristics
NUMBER(8), Required

Definition
The internal species identifier that indicates the taxonomy for the citation.

Rules
Foreign key. Link to tax table. Cannot be updated.
If tax record deleted, tcit record automatically deleted.

------- Return to: [Columns] [Areas] -------

Reference abbreviation (abbr)

Characteristics
VARCHAR2(20), Optional

Definition
The short abbreviation for this reference.

Example
Crop Sci
Agron J
Ann Bot
F Ariz

Rules
Foreign key. Link to lit table.

------- Return to: [Columns] [Areas] -------

Citation title (cittitle)

Characteristics
VARCHAR2(240), Optional

Definition
The title of the article or chapter.

Example
Registration of ICGV 86564 Peanut Germplasm
Registration of Bayshore Smooth Cordgrass
Inheritance of Adult-Plant Resistance to Powdery Mildew in
Knox 62 and Massey Winter Wheats
Systematics, Diversity, and Germplasm

Rules
cittitle <> lit.reftitle or lit.stdabbr.

------- Return to: [Columns] [Areas] -------

Author of publication (author)

Characteristics
VARCHAR2(240), Optional

Definition
Author(s) of the article or chapter.

Example
R.R. Kalton, P. Richardson
P.E. Lake

------- Return to: [Columns] [Areas] -------

Citation year (cityr)

Characteristics
NUMBER(4), Optional

Definition
The year the citation was published or made available.

Rules
Values between 1600 and (current year + 1).

------- Return to: [Columns] [Areas] -------

Citation reference (citref)

Characteristics
VARCHAR2(60), Optional

Definition
The citation (volume, page, etc.) within the journal or book.

Example
34(1):300
18(10):920
pp. 3-11

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
This field contains comments about the taxonomic citation.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who entered or last updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------

Type genus table (GNT)

Definition
Table linking families to their type genus.

Rules
Only SBML and DBMU can add, update or delete gnt records.

Constraint
Primary key
Columns: gno, famno.

Foreign key
Column: famno. References table FAM (famno).

Column: gno. References table GN (gno).

------- Return to: [Columns] [Areas] -------

Genus number (gno)

Characteristics
NUMBER(8), Required

Definition
The internal genus identifier to indicate the type genus.

Rules
Foreign key. Link to gn table. Cannot be updated.
If gn record deleted, gnt record automatically deleted.

------- Return to: [Columns] [Areas] -------

Family number (famno)

Characteristics
NUMBER(8), Required

Definition
The internal identifier for the classification above the genus level.

Rules
Foreign key. Link to fam table.
If fam record deleted, gnt record automatically deleted.

------- Return to: [Columns] [Areas] -------

Comment (cmt)

Characteristics
VARCHAR2(240), Optional

Definition
General comment about the type genus.

------- Return to: [Columns] [Areas] -------

User identifier (userid)

Characteristics
CHAR(10), Optional, Software supplied, Default = substr(USER,1,10)

Definition
Login ID of the person who last entered or updated the record.

Rules
On insert or update: set to current user.

------- Return to: [Columns] [Areas] -------

Date created (created)

Characteristics
DATE, Optional, Software supplied, Default = Current date

Definition
The date the record was inserted into the database.

Rules
On insert: set to system date.
On update: keep original date.

------- Return to: [Columns] [Areas] -------

Date modified (modified)

Characteristics
DATE, Optional, Software supplied

Definition
The date the record was last updated.

Rules
On insert: set to null.
On update: set to system date.

------- Return to: [Columns] [Areas] -------