# Clubspeed schema ERD

Table and field reference for the Fivetran Clubspeed connector.

## Table & Field Reference

### checks

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| user_id | Unknown | FK |
| broker | Unknown |  |
| closed_date | Unknown |  |
| discount | Unknown |  |
| discount_id | Unknown |  |
| discount_note | Unknown |  |
| discount_user_id | Unknown |  |
| fee | Unknown |  |
| gratuity | Unknown |  |
| invoice_date | Unknown |  |
| is_tax_exempt | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| opened_date | LocalDateTime |  |
| status | Unknown |  |
| total | Unknown |  |
| type | Unknown |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| check_id | Unknown | FK |
| customer_id | Unknown | FK |
| user_id | Unknown | FK |
| card_type | Unknown |  |
| ext_card_type | Unknown |  |
| external_account_name | Unknown |  |
| history_id | Unknown |  |
| invoice_paid_history_id | Unknown |  |
| pay_amount | Unknown |  |
| pay_date | LocalDateTime |  |
| pay_status | Unknown |  |
| pay_tax | Unknown |  |
| pay_terminal | Unknown |  |
| pay_type | Unknown |  |
| tender | Unknown |  |
| transaction | Unknown |  |
| troutd | Unknown |  |
| void_date | Unknown |  |
| void_note | Unknown |  |
| void_terminal | Unknown |  |
| void_user | Unknown |  |
| voucher_id | Unknown |  |
| voucher_note | Unknown |  |

### check_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| check_id | Unknown | PK, FK |
| p_customer_id | Unknown | FK |
| product_id | Unknown | FK |
| bonus_value | Unknown |  |
| c_id | Unknown |  |
| cadet_qty | Unknown |  |
| calculate_type | Unknown |  |
| com_value | Unknown |  |
| created_date | LocalDateTime |  |
| discount_applied | Unknown |  |
| discount_desc | Unknown |  |
| g_cust_id | Unknown |  |
| gst | Unknown |  |
| m_cust_id | Unknown |  |
| m_days | Unknown |  |
| m_days_added | Unknown |  |
| m_new_membershiptype_id | Unknown |  |
| m_old_membershiptype_id | Unknown |  |
| m_point | Unknown |  |
| m_primary_membership | Unknown |  |
| p_point | Unknown |  |
| p_point_type_id | Unknown |  |
| paid_value | Unknown |  |
| product_name | Unknown |  |
| qty | Unknown |  |
| s_cust_id | Unknown |  |
| s_no_of_laps_or_second | Unknown |  |
| s_sale_by | Unknown |  |
| s_vol | Unknown |  |
| status | Unknown |  |
| tax_id | Unknown |  |
| tax_percent | Unknown |  |
| unit_price | Unknown |  |
| unit_price_2 | Unknown |  |
| v_id | Unknown |  |
| void_note | Unknown |  |
| custom_** |  |  |

### event_heat_detail

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| added | LocalDateTime |  |
| proskill | Unknown |  |
| round_lose_num | Unknown |  |
| total_races | Unknown |  |

### gift_card_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| check_detail_id | Unknown | FK |
| check_id | Unknown | FK |
| customer_id | Unknown | FK |
| user_id | Unknown | FK |
| ip_address | Unknown |  |
| note | Unknown |  |
| points | Unknown |  |
| transaction_date | LocalDateTime |  |
| type | Unknown |  |

### event_heat_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_type_id | Unknown | FK |
| heat_type_id | Unknown | FK |
| cadets_per_heat | Unknown |  |
| description | Unknown |  |
| grid_id | Unknown |  |
| heats_per_racer | Unknown |  |
| is_inverted | Unknown |  |
| is_semi | Unknown |  |
| line_up_type | Unknown |  |
| proceed_method | Unknown |  |
| proceed_value | Unknown |  |
| racers_per_heat | Unknown |  |
| round_number | Unknown |  |
| round_win_by | Unknown |  |
| score_system_id | Unknown |  |
| team_grouping_type | Unknown |  |

### reservation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| check_id | Unknown | FK |
| customers_id | Unknown | FK |
| created_at | LocalDateTime |  |
| expires_at | Unknown |  |
| online_booking_reservation_status_id | Unknown |  |
| online_bookings_id | Unknown |  |
| quantity | Unknown |  |
| session_id | Unknown |  |

### event_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| display_at_registration | Unknown |  |
| enabled | Unknown |  |
| is_deleted | Unknown |  |
| member_only | Unknown |  |
| name | Unknown |  |
| online_product_id | Unknown |  |
| pts_per_reservation | Unknown |  |
| theme | Unknown |  |
| track_id | Unknown |  |

### event_round

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| heat_type_id | Unknown | FK |
| cadets_per_heat | Unknown |  |
| grid_id | Unknown |  |
| heat_description | Unknown |  |
| heats_per_racer | Unknown |  |
| is_inverted | Unknown |  |
| is_semi | Unknown |  |
| line_up_type | Unknown |  |
| number | Unknown |  |
| proceed_method | Unknown |  |
| proceed_value | Unknown |  |
| racers_per_heat | Unknown |  |
| score_system_id | Unknown |  |
| win_by | Unknown |  |

### event_task_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| is_deleted | Unknown |  |
| name | Unknown |  |
| seq | Unknown |  |

### heat_detail

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| heat_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| assigned_to_entitle_heat | Unknown |  |
| auto_no | Unknown |  |
| finish_position | Unknown |  |
| first_time | Unknown |  |
| group_finish_position | Unknown |  |
| group_id | Unknown |  |
| history_auto_no | Unknown |  |
| line_up_position | Unknown |  |
| point_history_id | Unknown |  |
| position_edited_date | Unknown |  |
| pro_skill | Unknown |  |
| proskill_diff | Unknown |  |
| score | Unknown |  |
| time_added | LocalDateTime |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| check_id | Unknown | FK |
| event_reservation_id | Unknown | FK |
| event_type_id | Unknown | FK |
| created_heat_spot | Unknown |  |
| created_heat_time | Unknown |  |
| description | Unknown |  |
| display_at_registration | Unknown |  |
| duration | Unknown |  |
| is_event_closure | Unknown |  |
| member_only | Unknown |  |
| note | Unknown |  |
| online_code | Unknown |  |
| round_num | Unknown |  |
| scheduled_time | LocalDateTime |  |
| theme | Unknown |  |
| total_cadet_racer | Unknown |  |
| total_racer | Unknown |  |
| track_no | Unknown |  |
| type_name | Unknown |  |

### heat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| heat_type_id | Unknown | FK |
| beginning | Unknown |  |
| cadet_per_heat | Unknown |  |
| event_round | Unknown |  |
| finish | Unknown |  |
| heat_color | Unknown |  |
| laps_or_minutes | Unknown |  |
| member_only | Unknown |  |
| note | Unknown |  |
| number_of_cadet_reservation | Unknown |  |
| number_of_reservation | Unknown |  |
| points_needed | Unknown |  |
| race_by | Unknown |  |
| racers_per_heat | Unknown |  |
| schedule_duration | Unknown |  |
| scheduled_time | LocalDateTime |  |
| score_id | Unknown |  |
| speed_level | Unknown |  |
| status | Unknown |  |
| track | Unknown |  |
| win_by | Unknown |  |

### membership

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| membership_type_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| changed | LocalDateTime |  |
| expiration | Unknown |  |
| note | Unknown |  |

### event_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_reservation_id | Unknown | PK, FK |
| event_task_type_id | Unknown | PK, FK |
| completed_at | Unknown |  |
| completed_by | Unknown |  |

### membership_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| enabled | Unknown |  |
| expiration_type | Unknown |  |
| expires | Unknown |  |
| price_level | Unknown |  |
| sequence | Unknown |  |

### event_reservation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| event_reservation_type_id | Unknown | FK |
| event_status_id | Unknown | FK |
| event_type_id | Unknown | FK |
| user_id | Unknown | FK |
| allow_online_reservation | Unknown |  |
| check_id | Unknown |  |
| description | Unknown |  |
| end_time | Unknown |  |
| external_system_id | Unknown |  |
| is_deleted | Unknown |  |
| is_event_closure | Unknown |  |
| is_mixed | Unknown |  |
| main_id | Unknown |  |
| min_no_of_adults_per_booking | Unknown |  |
| min_no_of_cadets_per_booking | Unknown |  |
| no_of_cadet_racer | Unknown |  |
| no_of_racer | Unknown |  |
| no_of_total_racer | Unknown |  |
| notes | Unknown |  |
| pts_per_reservation | Unknown |  |
| rep_id | Unknown |  |
| start_time | LocalDateTime |  |
| subject | Unknown |  |

### event_reservation_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| membership_type_id | Unknown | FK |
| class_id | Unknown |  |
| description | Unknown |  |
| enabled | Unknown |  |
| g_point | Unknown |  |
| is_deleted | Unknown |  |
| m_point | Unknown |  |
| p_point | Unknown |  |
| price_1 | Unknown |  |
| price_2 | Unknown |  |
| price_cadet | Unknown |  |
| r_point | Unknown |  |
| tax_id | Unknown |  |
| type | Unknown |  |

### heat_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cadets_per_heat | Unknown |  |
| cannot_below | Unknown |  |
| cannot_exceed | Unknown |  |
| cost | Unknown |  |
| enabled | Unknown |  |
| entitle_heat | Unknown |  |
| is_deleted | Unknown |  |
| is_event_heat_only | Unknown |  |
| is_practice_heat | Unknown |  |
| laps_or_minutes | Unknown |  |
| member_only | Unknown |  |
| name | Unknown |  |
| on_heat_finish_assign_loop | Unknown |  |
| on_heat_start | Unknown |  |
| on_heat_stop | Unknown |  |
| print_result | Unknown |  |
| race_by | Unknown |  |
| racers_per_heat | Unknown |  |
| schedule_duration | Unknown |  |
| speed_level | Unknown |  |
| track_id | Unknown |  |
| web | Unknown |  |
| win_by | Unknown |  |

### event_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color_id | Unknown |  |
| seq | Unknown |  |
| status | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_created | LocalDateTime |  |
| address | Unknown |  |
| address_2 | Unknown |  |
| award_1 | Unknown |  |
| award_2 | Unknown |  |
| birth_date | Unknown |  |
| card_id | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| credit_limit | Unknown |  |
| credit_on_hold | Unknown |  |
| do_not_email | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| general_note | Unknown |  |
| hotel | Unknown |  |
| how_did_you_hear_about_us | Unknown |  |
| ignore_dob | Unknown |  |
| industry_id | Unknown |  |
| is_deleted | Unknown |  |
| is_employee | Unknown |  |
| is_gift_card | Unknown |  |
| issued_by | Unknown |  |
| last_name | Unknown |  |
| last_visited | Unknown |  |
| membership_status | Unknown |  |
| membership_text | Unknown |  |
| membership_text_long | Unknown |  |
| mobile_phone | Unknown |  |
| original_id | Unknown |  |
| phone_number | Unknown |  |
| price_level | Unknown |  |
| privacy_1 | Unknown |  |
| privacy_2 | Unknown |  |
| privacy_3 | Unknown |  |
| privacy_4 | Unknown |  |
| promotion_code | Unknown |  |
| proskill | Unknown |  |
| racer_name | Unknown |  |
| ref_id | Unknown |  |
| state | Unknown |  |
| status_1 | Unknown |  |
| status_2 | Unknown |  |
| status_3 | Unknown |  |
| status_4 | Unknown |  |
| total_race | Unknown |  |
| total_visit | Unknown |  |
| waiver | Unknown |  |
| waiver_2 | Unknown |  |
| web_user_name | Unknown |  |
| zip | Unknown |  |
| custom_** |  |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| card_id | Unknown |  |
| email | Unknown |  |
| employment_start_date | LocalDateTime |  |
| enabled | Unknown |  |
| first_name | Unknown |  |
| is_deleted | Unknown |  |
| is_system_user | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |

## Relationships

- checks(user_id) → users(id)
- checks(customer_id) → customer(id)
- payment(user_id) → users(id)
- payment(check_id) → checks(id)
- payment(customer_id) → customer(id)
- check_detail(product_id) → product(id)
- check_detail(p_customer_id) → customer(id)
- check_detail(check_id) → checks(id)
- event_heat_detail(event_id) → event(id)
- event_heat_detail(customer_id) → customer(id)
- gift_card_history(user_id) → users(id)
- gift_card_history(check_id) → checks(id)
- gift_card_history(customer_id) → customer(id)
- gift_card_history(check_detail_id) → check_detail(id)
- event_heat_type(heat_type_id) → heat_type(id)
- event_heat_type(event_type_id) → event_type(id)
- reservation(check_id) → checks(id)
- reservation(customers_id) → customer(id)
- event_round(event_id) → event(id)
- event_round(heat_type_id) → heat_type(id)
- heat_detail(user_id) → users(id)
- heat_detail(heat_id) → heat(id)
- heat_detail(customer_id) → customer(id)
- event(event_reservation_id) → event_reservation(id)
- event(check_id) → checks(id)
- event(event_type_id) → event_type(id)
- heat(heat_type_id) → heat_type(id)
- membership(customer_id) → customer(id)
- membership(membership_type_id) → membership_type(id)
- membership(user_id) → users(id)
- event_task(event_reservation_id) → event_reservation(id)
- event_task(event_task_type_id) → event_task_type(id)
- event_reservation(user_id) → users(id)
- event_reservation(event_reservation_type_id) → event_reservation_type(id)
- event_reservation(event_status_id) → event_status(id)
- event_reservation(customer_id) → customer(id)
- event_reservation(event_type_id) → event_type(id)
- product(membership_type_id) → membership_type(id)