# Smartwaiver schema ERD

Table and field reference for the Fivetran Smartwaiver connector.

## Table & Field Reference

### checkin

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| first_name | Unknown |  |
| is_minor | Unknown |  |
| last_name | Unknown |  |
| position | Unknown |  |

### waiver_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| display_text | Unknown |  |
| value | Unknown |  |

### waiver_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| tag_name | Unknown |  |

### waiver_flag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| display_text | Unknown |  |
| reason | Unknown |  |

### waiver_participant_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| waiver_participant_index | Unknown | PK, FK |
| display_text | Unknown |  |
| value | Unknown |  |

### waiver_participant_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| waiver_participant_index | Unknown | PK, FK |
| participant_tag | Unknown |  |

### waiver_participant_flag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| waiver_participant_index | Unknown | PK, FK |
| display_text | Unknown |  |
| reason | Unknown |  |

### waiver_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waiver_id | Unknown | PK, FK |
| dob | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| is_minor | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| minor_expired | Unknown |  |
| phone | Unknown |  |

### waiver

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| template_id | Unknown | FK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_line_one | Unknown |  |
| address_line_two | Unknown |  |
| address_state | Unknown |  |
| address_zip | Unknown |  |
| auto_tag | Unknown |  |
| client_ip | Unknown |  |
| created_on | Unknown |  |
| dob | Unknown |  |
| drivers_license_number | Unknown |  |
| drivers_license_state | Unknown |  |
| email | Unknown |  |
| emergency_contact_first_name | Unknown |  |
| emergency_contact_last_name | Unknown |  |
| emergency_contact_name | Unknown |  |
| emergency_contact_phone | Unknown |  |
| expiration_date | Unknown |  |
| expired | Unknown |  |
| first_name | Unknown |  |
| guardian_dob | Unknown |  |
| guardian_first_name | Unknown |  |
| guardian_last_name | Unknown |  |
| guardian_middle_name | Unknown |  |
| guardian_phone | Unknown |  |
| guardian_relationship | Unknown |  |
| insurance_carrier | Unknown |  |
| insurance_policy_number | Unknown |  |
| is_minor | Unknown |  |
| kiosk | Unknown |  |
| last_name | Unknown |  |
| marketing_allowed | Unknown |  |
| marketing_allowed_checkbox | Unknown |  |
| middle_name | Unknown |  |
| pdf | Unknown |  |
| photos | Unknown |  |
| prefill_id | Unknown |  |
| test_ec | Unknown |  |
| title | Unknown |  |
| verified | Unknown |  |

### template_vanity_url

| Column | Type | Keys |
| --- | --- | --- |
| url | Unknown | PK |
| template_id | Unknown | PK, FK |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| kiosk_url | Unknown |  |
| published_on | Unknown |  |
| published_version | Unknown |  |
| title | Unknown |  |
| web_url | Unknown |  |
| webhook_email_validation_required | Unknown |  |
| webhook_endpoint | Unknown |  |

## Relationships

- checkin(waiver_id) → waiver(id)
- waiver_custom_field(waiver_id) → waiver(id)
- waiver_tag(waiver_id) → waiver(id)
- waiver_flag(waiver_id) → waiver(id)
- waiver_participant_custom_field(waiver_id) → waiver_participant(waiver_id)
- waiver_participant_custom_field(waiver_participant_index) → waiver_participant(index)
- waiver_participant_tag(waiver_id) → waiver_participant(waiver_id)
- waiver_participant_tag(waiver_participant_index) → waiver_participant(index)
- waiver_participant_flag(waiver_id) → waiver_participant(waiver_id)
- waiver_participant_flag(waiver_participant_index) → waiver_participant(index)
- waiver_participant(waiver_id) → waiver(id)
- waiver(template_id) → template(id)
- template_vanity_url(template_id) → template(id)