erDiagram
    visitors_visit {
        int id PK
        varchar visitor_id
        int uid
        int localtime
        int returning
        int visit_count
        int page_count
        int entry
        int entry_time
        int exit
        int exit_time
        int total_time
        int bot
        varchar config_id
        varchar config_resolution
        int config_pdf
        int config_flash
        int config_java
        int config_quicktime
        int config_realplayer
        int config_windowsmedia
        int config_silverlight
        int config_cookie
        varchar config_browser_engine
        varchar config_browser_name
        varchar config_browser_version
        varchar config_client_type
        varchar config_device_brand
        varchar config_device_model
        varchar config_device_type
        varchar config_os
        varchar config_os_version
        varchar location_browser_lang
        varchar location_ip
        varchar location_continent
        varchar location_country
        varchar location_region
        varchar location_city
        numeric location_latitude
        numeric location_longitude
    }

    visitors_event {
        int id PK
        int visit_id FK
        varchar page_view
        varchar plugin
        varchar event
        int plugin_int_1
        int plugin_int_2
        varchar plugin_var_1
        varchar plugin_var_2
        varchar plugin_var_3
        varchar plugin_var_4
        text title
        int uid
        int url_prefix
        text url
        varchar path
        varchar route
        text referrer_url
        varchar server
        int pf_network
        int pf_server
        int pf_transfer
        int pf_dom_processing
        int pf_dom_complete
        int pf_on_load
        int pf_total
        int created
    }

    visitors_counter {
        int entity_id PK
        varchar entity_type PK
        int total
        int today
        int timestamp
    }

    visitors_visit ||--o{ visitors_event : "has"