determination

Table info.

Title Determination
Description Determination

Fields

Name Type Required Index Hidden On form Title Pick list Description
DeterminationID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created.
TimestampModified datetime Last edited The timestamp the record was last modified.
Version int(11) Version version
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Addendum varchar(16) Addendum DeterminationAddendum
  • s. str.
  • s.l.
  • group
  • complex
  • vel aff.
  • intergrade
  • intermediate
A suffix added after the taxon name to indicate a concept for that name (s.l., s.s., group, complex).
AlternateName varchar(128) MUL Alternative name An unpublished or unofficial name that has been applied to the specimen. This field should only be used if the determination is not current.
Confidence varchar(50) Flora Flora
  • Flora of Australia
  • Flora Malesiana
  • Algae of Australia
To indicate if the specimen has been seen for a flora or other project
DeterminedDate date MUL Date The date of determination
DeterminedDatePrecision tinyint(4) Determined Date Precision determinedDatePrecision
FeatureOrBasis varchar(50) Det. type Determination type
  • Det.
  • Conf.
  • Annot.
  • AVH annot.
  • Type status
  • Acc. name change
The type of determination (determination, annotation, confirmation, type status determination etc.)
IsCurrent bit(1) Current Check the box to indicate which determination is current. A collection object record can only have one determination.
Method varchar(50) Basis DeterminationBasis
  • Duplicate
  • Image
  • Original folder
If the determination is based on examination of a duplicate or an image, select the appropriate value from the pick list
NameUsage varchar(64) Extra information Any extra information relating to the determination that is not part of a taxon name, e.g. 'var. indet', 'subsp. indet', 'vegetative group B'. Information entered in this field will be appended to the taxon name on labels.
Number1 float(20,10) Number1
Number2 float(20,10) Number2 User definable.
Qualifier varchar(16) Qualifier Qualifier
  • ?
  • aff.
  • cf.
The determination qualifier, if used
VarQualifer varchar(16)
Remarks text Det. notes Any notes relating to the determination, e.g. 'The awn is shorter than usual in this species'
SubSpQualifier varchar(16) Type qualifier TypeStatusQual
  • possible
  • probable
  • ?
Type status qualifier
Text1 text Text1 User definable
Text2 text Text2 User definable.
TypeStatusName varchar(50) MUL Type status TypeStatus
  • Epitype
  • Holotype
  • Isolectotype
  • Isoneotype
  • Isosyntype
  • Isotype
  • Lectotype
  • Neotype
  • Residual syntype
  • Paraneotype
  • Paratype
  • Paralectotype
  • Syntype
  • Type
  • Authentic specimen
  • Isoepitype
The type status of the specimen
VarQualifier varchar(16) Qualifier rank QualifierRank
  • species
  • genus
  • family
  • subspecies
  • forma
  • variety
The rank at which the qualifier applies
YesNo1 bit(1) Stored under this name Indicates the specimen is stored under this name. Only use for types. This should be the most recent basionym.
YesNo2 bit(1) Determiner inferred Check the box if the determiner's name has been inferred from the handwriting
GUID varchar(128) MUL GUID guid
CollectionObjectID int(11) MUL
DeterminerID int(11) MUL
PreferredTaxonID int(11) MUL
TaxonID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
AlterNameIDX AlternateName
DeterminationGuidIDX GUID
DeterminedDateIDX DeterminedDate
DetMemIDX CollectionMemberID
FKC1E98FE31D39F06C TaxonID
FKC1E98FE3280D00CB PreferredTaxonID
FKC1E98FE35327F942 ModifiedByAgentID
FKC1E98FE375E37458 CollectionObjectID
FKC1E98FE37699B003 CreatedByAgentID
FKC1E98FE3E9268B1C DeterminerID
PRIMARY DeterminationID
TypeStatusNameIDX TypeStatusName

One-to-many relationships

Name Field Related table Related field
FK259B07CA47AE835E DeterminationID determinationcitation DeterminationID

Many-to-one relationships

Name Field Related table Related field
FKC1E98FE31D39F06C TaxonID taxon TaxonID
FKC1E98FE3280D00CB PreferredTaxonID taxon TaxonID
FKC1E98FE35327F942 ModifiedByAgentID agent AgentID
FKC1E98FE375E37458 CollectionObjectID collectionobject CollectionObjectID
FKC1E98FE37699B003 CreatedByAgentID agent AgentID
FKC1E98FE3E9268B1C DeterminerID agent AgentID