customer_id int comment(FK to customers table - logged in customer, null for guests)
full_name varchar(255) not_null comment(Customer full name or Guest identifier)
session_id varchar(255) not_null comment(Unique session identifier for tracking)
ip_address varchar(45) not_null comment(IP address of visitor - IPv4 or IPv6 format)
hostname varchar(255) comment(Resolved hostname from IP address)
time_entry varchar(14) not_null comment(Timestamp when visitor first entered site - YYYYMMDDHHmmss format)
time_last_click varchar(14) not_null comment(Timestamp of last activity - YYYYMMDDHHmmss format)
last_page_url text not_null comment(URL of last page visited)
http_referer text comment(HTTP referer - where visitor came from)
user_agent mediumtext comment(Browser user agent string for device/browser identification)
--
idx_whos_online_session_id session_id
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci