Database Tables and Fields

Note: This documentation is for an old version of Webinator. The latest documentaion is here.

Database Tables and Fields

These are the database fields:

Table: html

Field     Description
--------  --------------
Url       The URL of the real HTML page
Title     The Title of the page
Body      The textual content of the page
Meta      The selected meta data from the page, separated by newlines
Visited   The date the page was fetched
Depth     The number of URLs traversed to reach the page
Dlsecs    The total number of seconds to descend all of
          the links to reach the page
id        Unique record id. Or hash code when \verb`-unique` is enabled.
New       Currently unused

Table: refs

Field     Description
--------  --------------
Url       The URL of the an HTML page
Ref       The URL of a reference (link) on the HTML page
id        Unique record id.

Table: error

Field     Description
--------  --------------
Url       The URL of the an HTML page that could not be retrieved
Reason    The reason it could not be retrieved
id        Unique record id (includes timestamp info).

Table: querylog

Note: This table is only used if query logging is enabled in the search interface.

Field     Description
--------  --------------
id        Contains the date and time of the query (unique record id)
Client    The hostname of the web client that performed the query
Query     The user's query as entered

Find out about fields with the following query:

gw -st "select TBNAME,NAME,TYPE from SYSCOLUMNS
         where TBNAME not matches 'SYS%' order by TBNAME,NAME"