WebsiteVisit Table - Revision history

Sam at 11:33, 3 February 2024

2024-02-03T11:33:55Z

Sam: /* LocalFileID */

2024-01-29T10:48:47Z

LocalFileID

Sam: /* DomainID */

2024-01-29T10:48:28Z

DomainID

Sam: /* MediaID */

2024-01-29T10:48:13Z

MediaID

Sam: /* FileID */

2024-01-29T10:47:40Z

FileID

Sam: /* WebsiteMethodID */

2024-01-29T10:47:28Z

WebsiteMethodID

Sam: /* URLTypeID */

2024-01-29T10:08:16Z

URLTypeID

Sam at 12:54, 27 January 2024

2024-01-27T12:54:30Z

Sam at 11:43, 23 October 2022

2022-10-23T11:43:17Z

Sam at 12:55, 8 December 2020

2020-12-08T12:55:16Z

@@ Line 30: / Line 30: @@
 ==<code>URLID</code>==
-The identifier of the URL that was retrieved by the browser. This corresponds to the <code>ID</code> column of the <code>[URL]</code> table.
+The identifier of the URL that was retrieved by the browser.
 ==<code>When</code>==
@@ Line 37: / Line 38: @@
 ==<code>AccountID</code>==
 The identifier of the account that retrieved the URL.
-This corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[Account Table|Account]]<nowiki>]</nowiki></code> table.
+This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Account Table|Account]]<nowiki>]</nowiki></code> table.
 ==<code>WebsiteMethodID</code>==
@@ Line 49: / Line 50: @@
 ==<code>MediaID</code>==
 The globally unique identifier of the media this web site visit came from.
-This corresponds to the <code>[ID]</code> column of the <code>[Media]</code> table.
+This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
 ==<code>LocalFilename</code>==
@@ Line 58: / Line 59: @@
 ==<code>DomainID</code>==
-The string identifier of the domain of this URL. It corresponds to the <code>[ID]</code> column of the <code>[Domain]</code> table.
+The string identifier of the domain of this URL.
 ==<code>LocalFileID</code>==
-The globally unique identifier of the file that contains this URL's contents. If it exists, it corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.
+The globally unique identifier of the file that contains this URL's contents.

← Older revision		Revision as of 10:48, 29 January 2024
Line 61:		Line 61:

	==<code>LocalFileID</code>==		==<code>LocalFileID</code>==
−	The globally unique identifier of the file that contains this URL's contents. If it exists, it corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[File Table\|File]]<nowiki>]</nowiki></code> table.	+	The globally unique identifier of the file that contains this URL's contents. If it exists, it corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[File Table\|File]]<nowiki>]</nowiki></code> table.

@@ Line 58: / Line 58: @@
 ==<code>DomainID</code>==
-The string identifier of the domain of this URL. It corresponds to the <code>ID</code> column of the <code>[Domain]</code> table.
+The string identifier of the domain of this URL. It corresponds to the <code>[ID]</code> column of the <code>[Domain]</code> table.
 ==<code>LocalFileID</code>==
 The globally unique identifier of the file that contains this URL's contents. If it exists, it corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.

@@ Line 49: / Line 49: @@
 ==<code>MediaID</code>==
 The globally unique identifier of the media this web site visit came from.
-This corresponds to the <code>ID</code> column of the <code>[Media]</code> table.
+This corresponds to the <code>[ID]</code> column of the <code>[Media]</code> table.
 ==<code>LocalFilename</code>==

@@ Line 45: / Line 45: @@
 ==<code>FileID</code>==
 The globally unique identifier of the file that contained this web site visit.
-This corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.
+This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.
 ==<code>MediaID</code>==

@@ Line 41: / Line 41: @@
 ==<code>WebsiteMethodID</code>==
 The identifier of the website method used to retrieve this URL. 0 - Unknown, 1 - Get, 2 - Post, etc.
-It corresponds to the <code>ID</code> column of the <code>[WebsiteMethod]</code> table.
+It corresponds to the <code>[ID]</code> column of the <code>[WebsiteMethod]</code> table.
 ==<code>FileID</code>==

@@ Line 26: / Line 26: @@
 ==<code>URLTypeID</code>==
 This is the globally unique identifier of the Url type.
-This points to the <code>ID</code> column of the <code>[URLType]</code> table.
+This points to the <code>[ID]</code> column of the <code>[URLType]</code> table.
 ==<code>URLID</code>==

@@ Line 1: / Line 1: @@
 This is how Truxton records website visits.
 <source lang="SQL">
 CREATE TABLE "WebsiteVisit"
@@ Line 18: / Line 19: @@
 );
 </source>

@@ Line 4: / Line 4: @@
 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,
-   "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>