DeletedTNameIDs
From Species File Help
(Difference between revisions)
m |
m (cat) |
||
(One intermediate revision by one user not shown) | |||
Line 1: | Line 1: | ||
'''tblDeletedTNameIDs''', deleted taxon name IDs ('''for possible future development'''). | '''tblDeletedTNameIDs''', deleted taxon name IDs ('''for possible future development'''). | ||
− | + | *OrphanSciNameID, int, = tblSciNames.SciNameID, primary key, ID in tblSciNames where tblSciNames.TaxonNameID is a value that no longer exists in tblTaxa | |
− | + | *NewTNameID, int, = tblTaxa.TaxonNameID, when = 0 there is no related row in tblTaxa (happens only in some of the cases when tblSciNames.Status = 4) | |
− | + | *LastUpdate, smalldatetime, date and time of last update | |
− | + | *ModifiedBy, integer, 2 bytes, UserID of the signon that made the change | |
[[Category:ForeignRelatedTables]] | [[Category:ForeignRelatedTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 13:10, 8 September 2012
tblDeletedTNameIDs, deleted taxon name IDs (for possible future development).
- OrphanSciNameID, int, = tblSciNames.SciNameID, primary key, ID in tblSciNames where tblSciNames.TaxonNameID is a value that no longer exists in tblTaxa
- NewTNameID, int, = tblTaxa.TaxonNameID, when = 0 there is no related row in tblTaxa (happens only in some of the cases when tblSciNames.Status = 4)
- LastUpdate, smalldatetime, date and time of last update
- ModifiedBy, integer, 2 bytes, UserID of the signon that made the change