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