...
Name | Null? | Data Type | Use | |
---|---|---|---|---|
NODENAME | NOT NULL | VARCHAR2(100) | DNS host name | |
IPADDRESS |
| VARCHAR2(15) | IPv4 address | |
SITENAME |
| VARCHAR2(100) | Domain name of the node | |
NICKNAME |
| VARCHAR2(35) | Abstraction of the hostname with the TLD first.1 | |
FULLNAME |
| VARCHAR2(100) | Human-friendly description of the node/site | |
LOCATION |
| VARCHAR2(100) | City and/or State/Province/Region for nodenode^2^ | |
COUNTRY |
| VARCHAR2(100) | Country for node | |
CONTINENT |
| VARCHAR2(100) | Continent or region where node is thought to be located2located^3^ | |
LATANDLONG |
| VARCHAR2(25) | Latitude and longitude of node | |
PROJECTTYPE |
| VARCHAR2(10) | Flags describing how nodes are used^4^ | |
PINGSERVER |
| VARCHAR2(100) | URL for requesting a ping from this node to another 5 | |
TRACESERVER |
| VARCHAR2(100) | URL for requesting a traceroute from this node to another 5 | |
DATASERVER |
| VARCHAR2(100) | URL for retrieving PingER data from this node 5 | |
URL |
| VARCHAR2(100) |
| URL for the home page for the institution running the node |
GMT |
| VARCHAR2(10) |
| Node's time offset from GMT, not used |
COMMENTS |
| VARCHAR2(4000) |
| Comments and notes on when and how the node's record was last updated ^6 |
APP_USER |
| VARCHAR2(20) | Windows user name of the last user to edit the node's record | |
CONTACTS |
| VARCHAR2(100) | Name and email address(es) of the node's maintainer(s) | |
PING_SIZE |
| NUMBER | Size of pings to be sent to the node - only controls SLAC's PingER install |
Anchor | ||||
---|---|---|---|---|
|
- EDU.SLAC.STANFORD.N3 - third node at SLAC, hostname pinger.slac.stanford.edu
- CH.CERN.N2 - second node at CERN, hostname wanmoninst1.cern.ch
- AO.UCAN.EDU.N1 - first node at University of in Angola, hostname www.ucan.edu
2. Location information is either provided by the site or is based off a geographic IP database like GeoIPToolAnchor colnote2 colnote2
User interface
A user interface for the table was created in Oracle's HTML DB / Application Express and can be accessed at https://oraweb.slac.stanford.edu/apex/slacprod/f?p=123:1. Authorized users are authenticated by their SLAC Windows credentials.
...
Code Block |
---|
update nodedetails set country = 'United States, continent = 'North America'
where nodename = 'EDU.SLAC.STANFORD.N3'
|
It may be necessary to exit and re-launch the UI in order to get the new country and continent to appear in the list of values.