| id |
int(11)
|
|
|
|
| session_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| host |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(11)
|
|
|
|
| current_page |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| page_title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| referrer |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| fbclid |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| gclid |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| ttclid |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| utm_source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| utm_medium |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| utm_campaign |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| landing_url |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| device_type |
enum('desktop', 'mobile', 'tablet')
|
utf8mb4_unicode_ci
|
|
|
| browser |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| os |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(2)
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| ip_hash |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| pages_viewed |
int(11)
|
|
|
|
| session_start |
datetime
|
|
|
|
| last_activity |
datetime
|
|
|
|
| created_at |
timestamp
|
|
|
|
