TaxonNameLSIDs
From Species File Help
(Difference between revisions)
(cat) |
|||
(6 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | ''' | + | '''tblTaxonNameLSIDs''' contains infomation about LSIDs for scientific taxon names. |
− | * | + | *TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs |
− | *FileID, integer, 4 bytes, = tblFiles.FileID | + | *FileID, integer, 4 bytes, = tblFiles.FileID. Identifies which file this TaxonNameID is or was associated with. This column will be added to the table. |
+ | *FullTaxonNameLSID, text, 127 bytes maximum, full LSID as displayed for users | ||
*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 | *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 | *NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index | ||
Line 10: | Line 11: | ||
**1 = dormant, used for deleted nominotypical subs | **1 = dormant, used for deleted nominotypical subs | ||
**2 = artifact from rows erroneously added | **2 = artifact from rows erroneously added | ||
− | **3 = | + | **3 = copied from other species file |
**4 = moved out of scope | **4 = moved out of scope | ||
− | **5 = dormant, AccessCode changed to > 0 | + | **5 = dormant, AccessCode changed to > 0, do not display LSID |
− | * | + | **6 = dormant, AccessCode changed to > 0, LSIDresolver.aspx grants confidential access to PageUser |
*LastUpdate, smalldatetime, date and time row last updated | *LastUpdate, smalldatetime, date and time row last updated | ||
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | *ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change |
Latest revision as of 16:15, 11 January 2014
tblTaxonNameLSIDs contains infomation about LSIDs for scientific taxon names.
- TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs
- FileID, integer, 4 bytes, = tblFiles.FileID. Identifies which file this TaxonNameID is or was associated with. This column will be added to the table.
- FullTaxonNameLSID, text, 127 bytes maximum, full LSID as displayed for users
- 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 = copied from other species file
- 4 = moved out of scope
- 5 = dormant, AccessCode changed to > 0, do not display LSID
- 6 = dormant, AccessCode changed to > 0, LSIDresolver.aspx grants confidential access to PageUser
- 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