OtherEcoTaxa
From Species File Help
tblOtherEcoTaxa, taxa in ecological relationships but outside the primary scope
- OtherEcoTaxonID, integer, 4 bytes, primary key, identifier for a taxon outside the primary scope
- FileID, integer, 4 bytes, = tblFiles.FileID
- OtherEcoTaxonStr, text, 150 character maximum, a string with OtherEcoTaxonIDs showing the ancestors and separated by "-". "g" is added at the end of OtherEcoTaxonID for a genus. "s" is added at the end of OtherEcoTaxonID for a subgenus.
- ScientificName, text, 100 characters maximum
- CommonName, text, 100 characters maximum (may include multiple common names separated by commas)
- RankID, integer, 4 bytes
- 30 = above genus
- 20 = genus
- 18 = subgenus
- 15 = below subgenus and above species
- 10 = species
- 5 = below species
- AboveID, integer, 4 bytes, = OtherEcoTaxonID. A value of 0 indicates that no parent taxon is included in the table. There is no limit to the number of "top taxa" that have no parent taxa.
- LastUpdate, smalldatetime, date and time row last updated
- ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
- CreatedOn, smalldatetime, date and time row was created
- CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
