SupplTaxonInfo
From Species File Help
(Difference between revisions)
(created page) |
|||
| Line 1: | Line 1: | ||
| − | '''tblSupplTaxonInfo''' | + | '''tblSupplTaxonInfo''', supplementary information about taxa |
| − | + | SupplInfoID, integer, 4 bytes, identifier for the information | |
| − | + | TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID | |
| − | + | Title, text, 60 characters maximum, title for this supplementary information item | |
| − | + | SourceID, integer, 4 bytes, = tblSources.SourceID | |
| − | + | Content, text, 8000 bytes maximum | |
| − | + | AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode | |
| − | + | 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 | ||
[[Category:TaxaTables]] | [[Category:TaxaTables]] | ||
Revision as of 16:14, 29 August 2012
tblSupplTaxonInfo, supplementary information about taxa
SupplInfoID, integer, 4 bytes, identifier for the information TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID Title, text, 60 characters maximum, title for this supplementary information item SourceID, integer, 4 bytes, = tblSources.SourceID Content, text, 8000 bytes maximum AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode 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
