Forum Moderators: DixonJones
The cookie table would contain the cookie value, user agent, ip address, first referring url (this is the url that referred the person on their first visit), cookie create date, and then any unique user information that you can tie to your cookie.
The visit table would contain a session value, create date, referring_url, first url visited on your site, and a link to the cookie table (probably using the cookie id).
Having these two tables in place has helped me out a lot both as a means of tracking individual users, and getting larger usage patterns figured out.