# Livestorm schema ERD

Table and field reference for the Fivetran Livestorm connector.

## Table & Field Reference

### session_people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown | FK |
| session_id | Unknown | FK |
| created_at | Instant |  |
| registrant_detail | Json |  |
| up_vote_count | Unknown |  |
| updated_at | Instant |  |
| vote_count | Unknown |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| attendee_count | Unknown |  |
| breakout_room_parent_session_id | Unknown |  |
| canceled_at | Instant |  |
| created_at | Instant |  |
| duration | Unknown |  |
| ended_at | Instant |  |
| estimated_started_at | Instant |  |
| name | Unknown |  |
| registrant_count | Unknown |  |
| started_at | Instant |  |
| status | Unknown |  |
| timezone | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### session_recording

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| session_id | Unknown | FK |
| file_name | Unknown |  |
| file_size | Unknown |  |
| file_type | Unknown |  |
| mime_type | Unknown |  |
| type | Unknown |  |

### event_people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown | FK |
| event_id | Unknown | FK |
| created_at | Instant |  |
| registrant_detail | Json |  |
| timezone | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### session_chat_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| session_id | Unknown | FK |
| author_id | Unknown |  |
| created_at | Instant |  |
| from_guest_speaker | Unknown |  |
| from_team_member | Unknown |  |
| text_content | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| chat_enabled | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| estimated_duration | Unknown |  |
| everyone_can_speak | Unknown |  |
| fields | Json |  |
| languages | Unknown |  |
| light_registration_page_enabled | Unknown |  |
| owner_type | Unknown |  |
| polls_enabled | Unknown |  |
| published_at | Instant |  |
| questions_enabled | Unknown |  |
| recording_enabled | Unknown |  |
| recording_public | Unknown |  |
| registration_page_enabled | Unknown |  |
| scheduling_status | Unknown |  |
| show_in_company_page | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| role | Unknown |  |
| timezone | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### session_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| session_id | Unknown | FK |
| created_at | Instant |  |
| question | Unknown |  |
| responded_at | Instant |  |
| response | Unknown |  |
| response_orally | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| pending_invite | Unknown |  |
| role | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

## Relationships

- session_people(email) → people(email)
- session_people(session_id) → session(id)
- session(event_id) → event(id)
- session_recording(session_id) → session(id)
- event_people(email) → people(email)
- event_people(event_id) → event(id)
- session_chat_message(session_id) → session(id)
- event(owner_id) → users(id)
- session_question(session_id) → session(id)