DeletedTNameIDs
From Species File Help
(Difference between revisions)
m |
|||
| Line 1: | Line 1: | ||
| − | '''tblDeletedTNameIDs''', deleted taxon name IDs (''' | + | '''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 | OrphanSciNameID, int, = tblSciNames.SciNameID, primary key, ID in tblSciNames where tblSciNames.TaxonNameID is a value that no longer exists in tblTaxa | ||
Revision as of 17:27, 4 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
