taxoncitation

Table info.

Title Taxon Citation
Description Taxon Citation

Fields

Name Type Required Index Hidden On form Title Pick list Description
TaxonCitationID 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
Number1 float(20,10) Number1 User definable
Number2 float(20,10) Number2 User definable
Remarks text Comments Remarks about the usage of the name in the reference work
Text1 text Text1 User definable
Text2 text Text2 User definable
YesNo1 bit(1) Yes No1 User definable
YesNo2 bit(1) Yes No2 User definable
ReferenceWorkID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
TaxonID int(11) MUL

Indexes

Name Fields Unique Nullable
FK14242FB11D39F06C TaxonID
FK14242FB15327F942 ModifiedByAgentID
FK14242FB169734F30 ReferenceWorkID
FK14242FB17699B003 CreatedByAgentID
PRIMARY TaxonCitationID

Many-to-one relationships

Name Field Related table Related field
FK14242FB11D39F06C TaxonID taxon TaxonID
FK14242FB15327F942 ModifiedByAgentID agent AgentID
FK14242FB169734F30 ReferenceWorkID referencework ReferenceWorkID
FK14242FB17699B003 CreatedByAgentID agent AgentID