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