Difference between revisions of "WebsiteVisit Table"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
CREATE TABLE "WebsiteVisit" | CREATE TABLE "WebsiteVisit" | ||
( | ( | ||
| − | "ID" uuid NOT NULL, | + | "ID" uuid NOT NULL, |
| − | "URLTypeID" smallint, | + | "URLTypeID" smallint, |
| − | "URLID" bigint DEFAULT 0 NOT NULL, | + | "URLID" bigint DEFAULT 0 NOT NULL, |
| − | "When" timestamp without time zone NOT NULL, | + | "When" timestamp without time zone NOT NULL, |
| − | "AccountID" bigint DEFAULT 0 NOT NULL, | + | "AccountID" bigint DEFAULT 0 NOT NULL, |
"WebsiteMethodID" smallint DEFAULT 0 NOT NULL, | "WebsiteMethodID" smallint DEFAULT 0 NOT NULL, | ||
| − | "FileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL, | + | "FileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL, |
| − | "MediaID" 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, | + | "LocalFilename" text DEFAULT ''::text NOT NULL, |
| − | "Offset" bigint DEFAULT (-1) NOT NULL, | + | "Offset" bigint DEFAULT (-1) NOT NULL, |
| − | "DomainID" bigint DEFAULT 0 NOT NULL, | + | "DomainID" bigint DEFAULT 0 NOT NULL, |
| − | "LocalFileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL | + | "LocalFileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL |
); | ); | ||
</source> | </source> | ||
Revision as of 07:43, 23 October 2022
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
);
