SupplTaxonInfo

Latest revision as of 10:14, 9 September 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

@@ Line 1: / Line 1: @@
-'''tblSupplTaxonInfo''' contains supplementary information about taxa.
+'''tblSupplTaxonInfo''', supplementary information about taxa
-*SupplInfoID, integer, 2 bytes, identifier for the information
+*SupplInfoID, integer, 4 bytes, identifier for the information
 *TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
-*Title, text, 60 bytes maximum, title for this supplementary information item
+*Title, text, 60 characters maximum, title for this supplementary information item
-*SourceID, integer, 2 bytes, = tblSources.SourceID
+*SourceID, integer, 4 bytes, = tblSources.SourceID
 *Content, text, 8000 bytes maximum
-*AccessCode, integer, 2 bytes
+*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode
-*LastUpdate, smalldatetime, date and time of last update; TaxonNameID and LastUpdate comprise the composite primary key
+*LastUpdate, smalldatetime, date and time row last updated
-*ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
+*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:Tables]]