Websites
From Species File Help
(Difference between revisions)
(cat) |
(add bit value 8 for Flags) |
||
| (3 intermediate revisions by one user not shown) | |||
| Line 7: | Line 7: | ||
**1 = used for taxon specific links | **1 = used for taxon specific links | ||
**2 = used for reference links | **2 = used for reference links | ||
| − | **4 = used for specimen links | + | **4 = used for specimen links, unneeded flag. When on, it indicates the website provides specimen level data. There are three other types of data that do not have bits in this column. The intent to provide links from specimen records was never implemented. |
| + | **8 = used for source links | ||
*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 17:02, 13 May 2013
tblWebsites contains information about other websites.
- WebsiteID, integer, 4 bytes, identifier for the website
- Name, text, 400 characters maximum
- RootLink, text, 200 characters maximum, root portion of the hyperlink
- Flags, integer, 1 byte, bitwise flags
- 1 = used for taxon specific links
- 2 = used for reference links
- 4 = used for specimen links, unneeded flag. When on, it indicates the website provides specimen level data. There are three other types of data that do not have bits in this column. The intent to provide links from specimen records was never implemented.
- 8 = used for source links
- 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
