GUS Schema >> SRes::TaxonName

Holds information about the name of the taxon referred to by the taxon_id.

column nulls? type description
TAXON_NAME_ID no NUMBER(10,0) Primary key. Edit
TAXON_ID no SRes::Taxon (NUMBER(10,0) )Foreign key to SRes.Taxon. Edit
NAME no STRING(255) text descriptor for the entry Edit
UNIQUE_NAME_VARIANT STRING(255) The unique variant of this name if name not unique Edit
NAME_CLASS STRING(255) Type of name e.g. scientific name, synonym, mispelling Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Subclasses: