ForeignTNameIDs

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(cat)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
'''tblForeignTNameIDs''', LSIDs issued by other entities such as Species 2000 and ZooBank ('''for possible future development''').
 
'''tblForeignTNameIDs''', LSIDs issued by other entities such as Species 2000 and ZooBank ('''for possible future development''').
  
    SciNameID, int, = tblSciNames.SciNameID
+
*SciNameID, int, = tblSciNames.SciNameID
    ForeignURN, varchar(1000), text of a urn for an LSID provided by a database other than this one.
+
*ForeignURN, varchar(1000), text of a urn for an LSID provided by a database other than this one.
    LastUpdate, smalldatetime
+
*LastUpdate, smalldatetime
    ModifiedBy, smallint, = tblAuthorizedUsers.UserID
+
*ModifiedBy, smallint, = tblAuthorizedUsers.UserID
  
 
[[Category:ForeignRelatedTables]]
 
[[Category:ForeignRelatedTables]]
 +
[[Category:Tables]]

Latest revision as of 13:11, 8 September 2012

tblForeignTNameIDs, LSIDs issued by other entities such as Species 2000 and ZooBank (for possible future development).

  • SciNameID, int, = tblSciNames.SciNameID
  • ForeignURN, varchar(1000), text of a urn for an LSID provided by a database other than this one.
  • LastUpdate, smalldatetime
  • ModifiedBy, smallint, = tblAuthorizedUsers.UserID
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox