TaxonNameLSIDs
From Species File Help
(Difference between revisions)
(created page) |
(formatting) |
||
| Line 1: | Line 1: | ||
'''tblTxnNmLSIDs''' contains infomation about LSIDs for scientific taxon names. | '''tblTxnNmLSIDs''' contains infomation about LSIDs for scientific taxon names. | ||
| − | + | *TxnNmLSID, integer, 4 bytes, primary key, = ID portion of LSIDs | |
| − | + | *FileID, integer, 4 bytes, = tblFiles.FileID | |
| − | + | *TaxonNameID, integer, 4 bytes, when row added = tblTaxa.TaxonNameID, but table relationship cannot be created because the row must remain here even if the row in tblTaxa is deleted | |
| − | + | *NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index | |
| − | + | *TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted | |
| − | + | *Status, integer, 1 byte | |
| − | + | **0 = active | |
| − | + | **1 = dormant, used for deleted nominotypical subs | |
| − | + | **2 = artifact from rows erroneously added | |
| − | + | **3 = moved to other species file identified in Note | |
| − | + | **4 = moved out of scope | |
| − | + | **5 = dormant, AccessCode changed to > 0 | |
| − | + | *Note, text, 100 bytes maximum, used to record that the value of TxnNmLSID in this row is reserved for future merge into this species file of an existing private species file named in this field. Other uses are likely in the future. | |
| − | + | *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:ForeignRelatedTables]] | [[Category:ForeignRelatedTables]] | ||
Revision as of 21:48, 4 September 2012
tblTxnNmLSIDs contains infomation about LSIDs for scientific taxon names.
- TxnNmLSID, integer, 4 bytes, primary key, = ID portion of LSIDs
- FileID, integer, 4 bytes, = tblFiles.FileID
- TaxonNameID, integer, 4 bytes, when row added = tblTaxa.TaxonNameID, but table relationship cannot be created because the row must remain here even if the row in tblTaxa is deleted
- NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index
- TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted
- Status, integer, 1 byte
- 0 = active
- 1 = dormant, used for deleted nominotypical subs
- 2 = artifact from rows erroneously added
- 3 = moved to other species file identified in Note
- 4 = moved out of scope
- 5 = dormant, AccessCode changed to > 0
- Note, text, 100 bytes maximum, used to record that the value of TxnNmLSID in this row is reserved for future merge into this species file of an existing private species file named in this field. Other uses are likely in the future.
- 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
