Fivetran documentation

Search the docs

/

Clubspeed

Explore the interactive ERD

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	PKFK
`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	PKFK
`event_id`	Unknown	PKFK
`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	PKFK
`heat_id`	Unknown	PKFK
`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	PKFK
`membership_type_id`	Unknown	PKFK
`user_id`	Unknown	FK
`changed`	LocalDateTime
`expiration`	Unknown
`note`	Unknown

event_task

Column	Type	Keys
`id`	Unknown	PK
`event_reservation_id`	Unknown	PKFK
`event_task_type_id`	Unknown	PKFK
`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