places.sqlite::moz_historyvisits

This table records all visits to URLs recorded in the moz_places table.

Schema

CREATE TABLE moz_historyvisits (id INTEGER PRIMARY KEY, from_visit INTEGER, place_id INTEGER, visit_date INTEGER, visit_type INTEGER, session INTEGER)

id	Auto-incrementing PRIMARY KEY
from_visit	The moz_historyvisits::id of the URL that the user navigated to this URL from. If from_visit = 0 then this page was not navigated to from any other.
place_id	many-to-one relationship with places.sqlite::moz_places::id
visit_date	Date and times that this visit occoured, formated as PRTime.
visit_type	The visit_type (also referred to as a transition type) records the means by which the user naviaged to this URL: 1 The user followed a link. 2 The user typed the page's URL in the URL bar or selected it from URL bar autocomplete results, clicked on it from from the history sidebar, history menu, or a history query in the personal toolbar or places organizer. 3 The user followed a bookmark. 4 This URL is embedded. This is true of all images on a page, contents of i-frames and contents of frames; regardless if whether or not the user clicked something to get there. 5 The user got here via a permanent redirect (HTTP 301). 6 The user got here via a temporary redirect (HTTP 302/307). 7 This is a download. Source: [1]
session