# Snowplow schema ERD

Table and field reference for the Fivetran Snowplow connector.

## Table & Field Reference

### bad_event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| event | String |  |
| reason | String |  |

### custom_context

| Column | Type | Keys |
| --- | --- | --- |
| collector_tstamp | Instant | PK, FK |
| event_id | String | PK, FK |

### event

| Column | Type | Keys |
| --- | --- | --- |
| collector_tstamp | Instant | PK |
| event_id | String | PK |
| app_id | String |  |
| br_colordepth | Int |  |
| br_cookies | Boolean |  |
| br_family | String |  |
| br_features_director | Boolean |  |
| br_features_flash | Boolean |  |
| br_features_gears | Boolean |  |
| br_features_java | Boolean |  |
| br_features_pdf | Boolean |  |
| br_features_quicktime | Boolean |  |
| br_features_realplayer | Boolean |  |
| br_features_silverlight | Boolean |  |
| br_features_windowsmedia | Boolean |  |
| br_lang | String |  |
| br_name | String |  |
| br_renderengine | String |  |
| br_type | String |  |
| br_version | String |  |
| br_viewheight | String |  |
| data | String |  |
| derived_tstamp | Instant |  |
| doc_charset | String |  |
| doc_height | Int |  |
| doc_width | Int |  |
| domain_sessionid | String |  |
| domain_sessionidx | String |  |
| domain_userid | String |  |
| dvce_created_tstamp | Instant |  |
| dvce_ismobile | Boolean |  |
| dvce_screenheight | String |  |
| dvce_sent_tstamp | Instant |  |
| dvce_type | String |  |
| event | String |  |
| event_format | String |  |
| event_name | String |  |
| event_vendor | String |  |
| event_version | String |  |
| geo_city | String |  |
| geo_country | String |  |
| geo_latitude | Double |  |
| geo_longitude | Double |  |
| geo_region | String |  |
| geo_region_name | String |  |
| geo_timezone | String |  |
| geo_zipcode | String |  |
| mac_address | String |  |
| mkt_campaign | String |  |
| mkt_clickid | String |  |
| mkt_content | String |  |
| mkt_medium | String |  |
| mkt_network | String |  |
| mkt_source | String |  |
| mkt_term | String |  |
| name_tracker | String |  |
| network_userid | String |  |
| os_family | String |  |
| os_manufacturer | String |  |
| os_name | String |  |
| os_timezone | String |  |
| page_referrer | String |  |
| page_title | String |  |
| page_url | String |  |
| page_urlfragment | String |  |
| page_urlhost | String |  |
| page_urlpath | String |  |
| page_urlport | Int |  |
| page_urlquery | String |  |
| page_urlscheme | String |  |
| platform | String |  |
| pp_xoffset_max | Int |  |
| pp_xoffset_min | Int |  |
| pp_yoffset_max | Int |  |
| pp_yoffset_min | Int |  |
| refr_domain_user_id | String |  |
| refr_dvce_tstamp | Instant |  |
| refr_medium | String |  |
| refr_source | String |  |
| refr_term | String |  |
| refr_urlfragment | String |  |
| refr_urlhost | String |  |
| refr_urlpath | String |  |
| refr_urlport | Int |  |
| refr_urlquery | String |  |
| refr_urlscheme | String |  |
| se_action | String |  |
| se_category | String |  |
| se_label | String |  |
| se_property | String |  |
| se_value | String |  |
| sequence_number | String |  |
| ti_category | String |  |
| ti_currency | String |  |
| ti_name | String |  |
| ti_orderid | String |  |
| ti_price | String |  |
| ti_quantity | Double |  |
| ti_sku | String |  |
| tr_affiliation | String |  |
| tr_city | String |  |
| tr_country | String |  |
| tr_currency | String |  |
| tr_orderid | String |  |
| tr_shipping | String |  |
| tr_state | String |  |
| tr_tax | String |  |
| tr_total | String |  |
| true_tstamp | Instant |  |
| txn_id | String |  |
| user_fingerprint | String |  |
| user_id | String |  |
| user_ipaddress | String |  |
| useragent | String |  |
| v_collector | String |  |
| v_tracker | String |  |

### ua_parser_context

| Column | Type | Keys |
| --- | --- | --- |
| collector_tstamp | Instant | PK, FK |
| event_id | String | PK, FK |
| device_family | String |  |
| os_family | String |  |
| os_major | String |  |
| os_minor | String |  |
| os_patch | String |  |
| os_patch_minor | String |  |
| os_version | String |  |
| useragent_family | String |  |
| useragent_major | String |  |
| useragent_minor | String |  |
| useragent_patch | String |  |
| useragent_version | String |  |

## Relationships

- custom_context(event_id) → event(collector_tstamp)
- custom_context(collector_tstamp) → event(collector_tstamp)
- ua_parser_context(event_id) → event(collector_tstamp)
- ua_parser_context(collector_tstamp) → event(collector_tstamp)