WebsiteVisit Table

This is how Truxton records website visits.

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
);