WebsiteVisit Table

This is how Truxton records website visits.

SQL

CREATE TABLE "WebsiteVisit"
(
  "ID"              uuid NOT NULL,
  "URLTypeID"       smallint,
  "URLID"           bigint DEFAULT 0 NOT NULL,
  "When"            timestamp without time zone NOT NULL,
  "AccountID"       bigint DEFAULT 0 NOT NULL,
  "WebsiteMethodID" smallint DEFAULT 0 NOT NULL,
  "FileID"          uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL,
  "MediaID"         uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL,
  "LocalFilename"   text DEFAULT ''::text NOT NULL,
  "Offset"          bigint DEFAULT (-1) NOT NULL,
  "DomainID"        bigint DEFAULT 0 NOT NULL,
  "LocalFileID"     uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL
);

Columns

ID

The globally unique identifier for this web site visit.

URLTypeID

This is the globally unique identifier of the Url type. This points to the [ID] column of the [URLType] table. It should be one of these values.

URLID

The identifier of the URL that was retrieved by the browser. This corresponds to the [ID] column of the [URL] table.

When

The date and time of when the browser retrieved the URL.

AccountID

The identifier of the account that retrieved the URL. This corresponds to the [ID] column of the [Account] table.

WebsiteMethodID

The identifier of the website method used to retrieve this URL. 0 - Unknown, 1 - Get, 2 - Post, etc. It corresponds to the [ID] column of the [WebsiteMethod] table.

FileID

The globally unique identifier of the file that contained this web site visit. This corresponds to the [ID] column of the [File] table.

MediaID

The globally unique identifier of the media this web site visit came from. This corresponds to the [ID] column of the [Media] table.

LocalFilename

The name of the file on the local file system where this URL's contents were stored.

Offset

The offset into the parent file where this URL was found (if known).

DomainID

The string identifier of the domain of this URL. It corresponds to the [ID] column of the [Domain] table.

LocalFileID

The globally unique identifier of the file that contains this URL's contents. If it exists, it corresponds to the [ID] column of the [File] table.