# Heap schema ERD

Table and field reference for the Fivetran Heap connector.

## Table & Field Reference

### user

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Long | PK |
| identity | String |  |
| join_date | Instant |  |
| last_modified | Instant |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Long | PK |
| session_id | Long | FK |
| user_id | Long | FK |
| browser | String |  |
| city | String |  |
| country | String |  |
| device_type | String |  |
| domain | String |  |
| event_name | String |  |
| heap_previous_page | String |  |
| landing_page | String |  |
| landing_page_query | String |  |
| library | String |  |
| pageview_id | Long |  |
| path | String |  |
| platform | String |  |
| referrer | String |  |
| region | String |  |
| time | Instant |  |
| title | String |  |
| type | String |  |

### pageview

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Long | PK |
| user_id | Long | FK |
| browser | String |  |
| city | String |  |
| country | String |  |
| device_type | String |  |
| domain | String |  |
| hash | String |  |
| heap_previous_page | String |  |
| landing_page | String |  |
| landing_page_hash | String |  |
| landing_page_query | String |  |
| library | String |  |
| path | String |  |
| platform | String |  |
| query | String |  |
| referrer | String |  |
| region | String |  |
| session_id | Long |  |
| time | Instant |  |
| title | String |  |
| utm_medium | String |  |
| utm_source | String |  |

### user_migration

| Column | Type | Keys |
| --- | --- | --- |
| from_user_id | Long | FK |
| to_user_id | Long | FK |
| time | Instant |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Long | PK |
| user_id | Long | FK |
| browser | String |  |
| city | String |  |
| country | String |  |
| device_type | String |  |
| event_id | Long |  |
| landing_page | String |  |
| landing_page_hash | String |  |
| landing_page_query | String |  |
| library | String |  |
| platform | String |  |
| referrer | String |  |
| region | String |  |
| time | Instant |  |
| utm_medium | String |  |
| utm_source | String |  |

## Relationships

- event(session_id) → session(session_id)
- event(user_id) → user(user_id)
- pageview(user_id) → user(user_id)
- user_migration(from_user_id) → user(user_id)
- user_migration(to_user_id) → user(user_id)
- session(user_id) → user(user_id)