# Webconnex schema ERD

Table and field reference for the Fivetran Webconnex connector.

## Table & Field Reference

### coupon_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| value | Unknown |  |
| value_type | Unknown |  |

### coupon_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| code | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| redeemed | Unknown |  |

### coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| available | Unknown |  |
| currency | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| name | Unknown |  |
| redeemed | Unknown |  |

### ticket_field_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ticket_id | Unknown | PK, FK |
| amount | Unknown |  |
| label | Unknown |  |
| path | Unknown |  |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| form_id | Unknown | FK |
| order_id | Unknown | FK |
| amount | Unknown |  |
| currency | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| display_id | Unknown |  |
| event_date | Unknown |  |
| fee | Unknown |  |
| form_acc_ref | Unknown |  |
| level_key | Unknown |  |
| level_label | Unknown |  |
| order_customer_id | Unknown |  |
| order_email | Unknown |  |
| status | Unknown |  |
| total | Unknown |  |

### membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| registrant_id | Unknown | FK |
| auto_renew | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| email | Unknown |  |
| expiration_date | Unknown |  |
| fee | Unknown |  |
| first_name | Unknown |  |
| imported_member_id | Unknown |  |
| last_name | Unknown |  |
| level_active | Unknown |  |
| level_allow_auto_renew | Unknown |  |
| level_expiration_schedule | Unknown |  |
| level_expiration_type | Unknown |  |
| level_fee | Unknown |  |
| level_hash | Unknown |  |
| level_id | Unknown |  |
| level_name | Unknown |  |
| level_next_renewal_date | Unknown |  |
| member_id | Unknown |  |
| payment_mask | Unknown |  |
| payment_method | Unknown |  |
| status | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| form_id | Unknown | FK |
| order_id | Unknown | FK |
| adjustment | Unknown |  |
| amount | Unknown |  |
| category | Unknown |  |
| currency | Unknown |  |
| date_created | Unknown |  |
| date_last | Unknown |  |
| date_next | Unknown |  |
| date_updated | Instant |  |
| deductible | Unknown |  |
| display_id | Unknown |  |
| order_email | Unknown |  |
| payments_completed | Unknown |  |
| payments_remaining | Unknown |  |
| schedule | Unknown |  |
| status | Unknown |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_archived | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| name | Unknown |  |
| product | Unknown |  |
| status | Unknown |  |

### coupon_form_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_form_id | Unknown | PK, FK |
| distribute | Unknown |  |
| per_ticket | Unknown |  |
| value | Unknown |  |
| value_type | Unknown |  |

### coupon_form_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_form_id | Unknown | PK, FK |
| code | Unknown |  |
| date_created | Unknown |  |
| redeemed | Unknown |  |

### coupon_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | PK, FK |
| available | Unknown |  |
| currency | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| name | Unknown |  |
| product_id | Unknown |  |
| redeemed | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| form_id | Unknown | FK |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_postal_code | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_street_1 | Unknown |  |
| billing_first_name | Unknown |  |
| billing_last_name | Unknown |  |
| billing_phone | Unknown |  |
| currency | Unknown |  |
| customer_email | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| display_id | Unknown |  |
| form_acc_ref | Unknown |  |
| form_name | Unknown |  |
| metadata | Unknown |  |
| order_number | Unknown |  |
| status | Unknown |  |
| total | Unknown |  |

### form_inventory

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| form_id | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |
| quantity | Unknown |  |
| sold | Unknown |  |

### registrant_field_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registrant_id | Unknown | PK, FK |
| amount | Unknown |  |
| label | Unknown |  |
| path | Unknown |  |
| value | Unknown |  |

### registrant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| form_id | Unknown | FK |
| order_id | Unknown | FK |
| amount | Unknown |  |
| checked_in | Unknown |  |
| currency | Unknown |  |
| date_checked_in | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| display_id | Unknown |  |
| form_acc_ref | Unknown |  |
| metadata | Unknown |  |
| outstanding_amount | Unknown |  |
| source_type | Unknown |  |
| status | Unknown |  |
| total | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| form_id | Unknown | FK |
| order_id | Unknown | FK |
| billing_email | Unknown |  |
| cc_expiration | Unknown |  |
| currency | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| deductible | Unknown |  |
| display_id | Unknown |  |
| exp_month | Unknown |  |
| exp_year | Unknown |  |
| gateway_message | Unknown |  |
| gateway_reference | Unknown |  |
| metadata | Unknown |  |
| order_email | Unknown |  |
| payment_mask | Unknown |  |
| payment_method | Unknown |  |
| payment_type | Unknown |  |
| source_type | Unknown |  |
| status | Unknown |  |
| total | Unknown |  |
| transaction_type | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| display_id | Unknown |  |
| email | Unknown |  |

## Relationships

- coupon_discount(coupon_id) → coupon(id)
- coupon_code(coupon_id) → coupon(id)
- coupon(product_id) → coupon_form(product_id)
- ticket_field_data(ticket_id) → ticket(id)
- ticket(order_id) → orders(id)
- ticket(form_id) → form(id)
- ticket(customer_id) → customer(id)
- membership(registrant_id) → registrant(id)
- membership(customer_id) → customer(id)
- subscription(order_id) → orders(id)
- subscription(form_id) → form(id)
- subscription(customer_id) → customer(id)
- coupon_form_discount(coupon_form_id) → coupon_form(id)
- coupon_form_code(coupon_form_id) → coupon_form(id)
- coupon_form(form_id) → form(id)
- orders(form_id) → form(id)
- orders(customer_id) → customer(id)
- form_inventory(form_id) → form(id)
- registrant_field_data(registrant_id) → registrant(id)
- registrant(order_id) → orders(id)
- registrant(form_id) → form(id)
- registrant(customer_id) → customer(id)
- transaction(order_id) → orders(id)
- transaction(form_id) → form(id)
- transaction(customer_id) → customer(id)