# Luma schema ERD

Table and field reference for the Fivetran Luma connector.

## Table & Field Reference

### event_guest_registration_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_guest_id | Unknown | PK, FK |
| answer | Unknown |  |
| label | Unknown |  |
| question_type | Unknown |  |

### event_guest

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| user_api_id | Unknown | FK |
| approval_status | Unknown |  |
| check_in_qr_code | Unknown |  |
| checked_in_at | Unknown |  |
| created_at | Unknown |  |
| invited_at | Unknown |  |
| joined_at | Unknown |  |
| registered_at | Unknown |  |
| user_email | Unknown |  |
| user_name | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cover_url | Unknown |  |
| description | Unknown |  |
| duration_interval | Unknown |  |
| end_at | Unknown |  |
| event_type | Unknown |  |
| geo_address_json | Unknown |  |
| geo_latitude | Unknown |  |
| geo_longitude | Unknown |  |
| name | Unknown |  |
| series_api_id | Unknown |  |
| social_image_url | Unknown |  |
| start_at | Unknown |  |
| timezone | Unknown |  |
| url | Unknown |  |
| user_api_id | Unknown |  |
| visibility | Unknown |  |

### event_host

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| avatar_url | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |

## Relationships

- event_guest_registration_answer(event_guest_id) → event_guest(id)
- event_guest(user_api_id) → event(user_api_id)
- event_guest(event_id) → event(id)
- event_host(id) → event(user_api_id)
- event_host(event_id) → event(id)