The database contains a table named
history_items. This lists all URL's, with their title, and id and the total number of time the website was visited. Another table is named
history_visits. This lists all individual visits, with a timestamp, id and, possibly, information about the source which redirected the user to this website.
In the Chrome browser history, the transition type is also stored. This notes whether the user arrived at the website via a link, a reload or whether he typed in the address directly. Is such transition information also available in the Safari
history_visits also contains integer columns named origin, generation and attributes. However, it is unclear to me what these mean. Is there a documentation available for the Safari browser history database?