Smartwaiver
Explore the interactive ERD
Table & Field Reference
checkin
| Column | Type | Keys |
|---|---|---|
date | Unknown | PK |
waiver_id | Unknown | PKFK |
first_name | Unknown | |
is_minor | Unknown | |
last_name | Unknown | |
position | Unknown |
waiver_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waiver_id | Unknown | PKFK |
display_text | Unknown | |
value | Unknown |
waiver_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waiver_id | Unknown | PKFK |
tag_name | Unknown |
waiver_flag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waiver_id | Unknown | PKFK |
display_text | Unknown | |
reason | Unknown |
waiver_participant_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waiver_id | Unknown | PKFK |
waiver_participant_index | Unknown | PKFK |
display_text | Unknown | |
value | Unknown |
waiver_participant_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waiver_id | Unknown | PKFK |
waiver_participant_index | Unknown | PKFK |
participant_tag | Unknown |
waiver_participant_flag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waiver_id | Unknown | PKFK |
waiver_participant_index | Unknown | PKFK |
display_text | Unknown | |
reason | Unknown |
waiver_participant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waiver_id | Unknown | PKFK |
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 | PKFK |
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 |