adyen_sessions id 1 int(11) NO auto_increment adyen_sessions uniq 2 varchar(255) NO adyen_sessions url 3 text NO adyen_sessions created_at 4 datetime NO attendence_links id 1 int(11) NO auto_increment attendence_links manager_id 2 int(11) NO attendence_links event_id 3 int(11) NO attendence_links link_hash 4 varchar(120) NO attendence_links created_at 5 datetime NO booking id 1 int(11) NO auto_increment booking user_id 2 int(11) NO booking event_id 3 int(11) NO booking created_at 4 datetime NO booking notified_at 5 datetime YES NULL clips_history id 1 int(11) NO auto_increment clips_history ref 2 varchar(255) NO clips_history type 3 enum('adyen','booking') NO 'adyen' clips_history user_id 4 int(11) NO clips_history gateway_link 5 varchar(999) YES NULL clips_history gateway_link_expire 6 varchar(255) YES NULL clips_history gateway_ref 7 varchar(255) YES NULL clips_history amount 8 float NO clips_history product_id 9 int(11) YES NULL clips_history club_id 10 int(11) NO clips_history note 11 varchar(255) YES NULL clips_history invoice 12 varchar(400) NO clips_history status 13 varchar(255) YES NULL clips_history created_at 14 datetime NO clubs id 1 int(11) NO auto_increment clubs uniq 2 varchar(255) NO clubs name 3 varchar(999) NO clubs country 4 varchar(10) NO clubs email 5 varchar(400) NO emails_log id 1 int(11) NO auto_increment emails_log uniq 2 varchar(255) NO emails_log email_key 3 varchar(255) NO emails_log params 4 text NO emails_log from_mail 5 varchar(400) NO emails_log to_mail 6 varchar(400) NO emails_log to_nick 7 varchar(400) NO emails_log attachements 8 text NO emails_log lang 9 varchar(10) NO emails_log subject 10 text NO emails_log content 11 text NO emails_log sent_at 12 datetime NO events id 1 int(11) NO auto_increment events uniq 2 varchar(255) NO events template_id 3 int(11) NO events pair 4 varchar(255) YES NULL events title 5 varchar(255) NO events text 6 text NO events photo 7 text NO events place 8 varchar(500) NO events capacity 9 int(11) NO events start_time 10 datetime NO events end_time 11 datetime NO events duration 12 int(11) NO events difficulty 13 enum('1','2','3','4','5') YES NULL events club_id 14 int(11) NO events program_id 15 int(11) NO events trainer_id 16 int(11) NO events lang 17 varchar(255) NO events booking_avaible 18 int(11) NO 1 events streaming 19 int(1) NO 0 events streaming_only 20 int(1) NO 0 events streaming_embed 21 text YES NULL events streaming_views 22 int(11) NO 0 events attendence_finish 23 int(11) NO 0 events target_for 24 enum('member','nonmember','both') NO events member_price 25 int(11) NO 0 events nonmember_price 26 int(11) NO 0 events is_new 27 int(11) NO 0 events created_at 28 datetime NO events updated_at 29 datetime NO events planned_publish 30 datetime YES NULL events notified_at 31 datetime YES NULL events status 32 enum('unpublished','published','canceled','planned') NO 'unpublished' events_content id 1 int(11) NO auto_increment events_content event_id 2 int(11) NO events_content lang 3 varchar(2) NO events_content event_name 4 varchar(400) NO events_content event_description 5 text NO log id 1 int(11) NO auto_increment log message 2 text NO log created_at 3 datetime NO managers id 1 int(11) NO auto_increment managers uniq 2 varchar(7) NO managers hpid 3 varchar(10) NO managers username 4 varchar(255) NO managers salt 5 varchar(255) NO managers password 6 varchar(255) NO managers fullname 7 varchar(500) NO managers language 8 varchar(255) YES NULL managers email 9 text NO managers phone 10 varchar(400) NO managers photo 11 text YES NULL managers club_id 12 int(11) NO managers rights 13 enum('trainer','administrator','reception') NO 'trainer' managers lang 14 varchar(10) NO managers allow_delete_users 15 int(1) NO 0 managers created_at 16 datetime NO managers updated_at 17 datetime YES NULL managers last_login 18 datetime YES NULL managers active 19 int(1) NO 1 managers_clubs id 1 int(11) NO auto_increment managers_clubs manager_id 2 int(11) NO managers_clubs club_id 3 int(11) NO modals id 1 int(11) NO auto_increment modals uniq 2 varchar(255) NO modals user_id 3 int(11) YES NULL modals type 4 enum('info','new_lesson','no_show','ban') NO 'info' modals content 5 text NO modals multiple 6 int(11) NO 0 modals valid_from 7 datetime NO modals valid_to 8 datetime YES NULL modals created_at 9 datetime NO notified_users id 1 int(11) NO auto_increment notified_users lang 2 varchar(2) NO notified_users club_name 3 varchar(400) NO notified_users user_name 4 varchar(900) NO notified_users user_email 5 varchar(900) NO notified_users event_name 6 varchar(900) NO presence id 1 int(11) NO auto_increment presence user_id 2 int(11) NO presence event_id 3 int(11) NO presence status 4 int(11) NO presence created_at 5 datetime NO presence_events id 1 int(11) NO auto_increment presence_events event_id 2 int(11) NO presence_events created_at 3 datetime NO presence_strikes id 1 int(11) NO auto_increment presence_strikes user_id 2 int(11) NO presence_strikes ban 3 int(11) NO 0 presence_strikes created_at 4 datetime NO programs id 1 int(11) NO auto_increment programs uniq 2 varchar(255) NO programs name 3 varchar(400) NO programs color 4 varchar(255) NO programs default_image 5 varchar(999) YES NULL reminders id 1 int(11) NO auto_increment reminders user_id 2 int(11) NO reminders event_id 3 int(11) NO reminders created_at 4 datetime NO reminders reminded_at 5 datetime YES NULL reminders_zoom id 1 int(11) NO auto_increment reminders_zoom user_id 2 int(11) NO reminders_zoom event_id 3 int(11) NO reminders_zoom created_at 4 datetime NO reminders_zoom reminded_at 5 datetime YES NULL settings id 1 int(11) NO auto_increment settings db_key 2 varchar(255) NO settings db_value 3 varchar(255) NO streaming_views id 1 int(11) NO auto_increment streaming_views event_id 2 int(11) NO streaming_views user_id 3 int(11) NO streaming_views created_at 4 datetime NO templates id 1 int(11) NO auto_increment templates uniq 2 varchar(255) NO templates type_id 3 int(11) NO templates photo 4 varchar(999) NO templates duration 5 int(11) NO templates level 6 int(11) NO templates capacity 7 int(11) NO templates booking_avaible 8 int(1) NO 1 templates target_for 9 enum('member','nonmember','both') NO templates member_price 10 int(11) NO 0 templates nonmember_price 11 int(11) NO 0 templates is_new 12 int(11) NO 0 templates status 13 enum('published','hidden','deleted') NO 'published' templates created_at 14 datetime NO templates_content id 1 int(11) NO auto_increment templates_content template_id 2 int(11) NO templates_content lang 3 varchar(2) NO templates_content class_name 4 varchar(400) NO templates_content class_description 5 text NO trials id 1 int(11) NO auto_increment trials code 2 varchar(255) NO users id 1 int(11) NO auto_increment users uniq 2 varchar(7) NO users salt 3 varchar(255) NO users password 4 varchar(255) NO users name 5 varchar(500) NO users surname 6 varchar(500) NO users email 7 text NO users phone 8 varchar(500) NO users photo 9 text YES NULL users club_id 10 int(11) NO users lang 11 varchar(10) NO users exerp_status 12 varchar(255) NO users created_at 13 datetime NO users updated_at 14 datetime YES NULL users last_login 15 datetime YES NULL users exerp_id 16 varchar(255) YES NULL users external_id 17 varchar(255) YES NULL users first_sync 18 int(11) NO 0 users sync_clubs 19 int(1) NO 1 users sync_exerp 20 int(1) NO 0 users wrong_cancel 21 int(11) NO 0 users unlimited 22 int(1) NO 0 users presence_blocked 23 datetime YES NULL users active 24 int(1) NO 1 users confirmed 25 int(11) NO 0 users member 26 int(11) NO 0 users_clubs id 1 int(11) NO auto_increment users_clubs user_id 2 int(11) NO users_clubs club_id 3 int(11) NO users_clubs valid 4 date YES NULL users_deleted id 1 int(11) NO auto_increment users_deleted origin_id 2 int(11) NO users_deleted uniq 3 varchar(7) NO users_deleted salt 4 varchar(255) NO users_deleted password 5 varchar(255) NO users_deleted name 6 varchar(500) NO users_deleted surname 7 varchar(500) NO users_deleted email 8 text NO users_deleted phone 9 varchar(500) NO users_deleted photo 10 text YES NULL users_deleted club_id 11 int(11) NO users_deleted lang 12 varchar(10) NO users_deleted exerp_status 13 varchar(255) NO users_deleted created_at 14 datetime NO users_deleted updated_at 15 datetime YES NULL users_deleted last_login 16 datetime YES NULL users_deleted exerp_id 17 varchar(255) YES NULL users_deleted external_id 18 varchar(255) YES NULL users_deleted first_sync 19 int(11) NO 0 users_deleted sync_clubs 20 int(1) NO 1 users_deleted sync_exerp 21 int(1) NO 0 users_deleted wrong_cancel 22 int(11) NO 0 users_deleted unlimited 23 int(1) NO 0 users_deleted presence_blocked 24 datetime YES NULL users_deleted active 25 int(1) NO 1 users_deleted confirmed 26 int(11) NO 0 users_deleted member 27 int(11) NO 0 users_deleted deleted_at 28 datetime NO users_modals id 1 int(11) NO auto_increment users_modals user_id 2 int(11) NO users_modals modal_id 3 int(11) NO users_modals created_at 4 datetime NO users_trials id 1 int(11) NO auto_increment users_trials user_id 2 int(11) NO users_trials trial_id 3 int(11) NO users_trials created_at 4 datetime NO visitors id 1 int(11) NO auto_increment visitors name 2 varchar(400) NO visitors event_id 3 int(11) NO visitors created_at 4 datetime NO waitlist id 1 int(11) NO auto_increment waitlist user_id 2 int(11) NO waitlist event_id 3 int(11) NO waitlist created_at 4 datetime NO waitlist_contacted id 1 int(11) NO auto_increment waitlist_contacted uniq 2 varchar(255) NO waitlist_contacted waitlist_id 3 int(11) NO waitlist_contacted created_at 4 datetime NO adyen_sessions PRIMARY 0 1 id attendence_links event_id 1 1 event_id attendence_links link_hash 1 1 link_hash attendence_links manager_id 1 1 manager_id attendence_links PRIMARY 0 1 id booking event_id 1 1 event_id booking PRIMARY 0 1 id booking user_id 1 1 user_id clips_history club_id 1 1 club_id clips_history PRIMARY 0 1 id clips_history product_id 1 1 product_id clips_history ref 1 1 ref clips_history status 1 1 status clips_history user_id 1 1 user_id clubs PRIMARY 0 1 id emails_log PRIMARY 0 1 id events club_id 1 1 club_id events member_price 1 1 member_price events nonmember_price 1 1 nonmember_price events PRIMARY 0 1 id events program_id 1 1 program_id events trainer_id 1 1 trainer_id events_content event_id 1 1 event_id events_content PRIMARY 0 1 id log PRIMARY 0 1 id managers club_id 1 1 club_id managers hpid 1 1 hpid managers PRIMARY 0 1 id managers_clubs club_id 1 1 club_id managers_clubs manager_id 1 1 manager_id managers_clubs PRIMARY 0 1 id modals PRIMARY 0 1 id modals type 1 1 type modals uniq 1 1 uniq modals user_id 1 1 user_id modals valid_from 1 1 valid_from modals valid_to 1 1 valid_to notified_users PRIMARY 0 1 id presence event_id 1 1 event_id presence PRIMARY 0 1 id presence user_id 1 1 user_id presence_events event_id 1 1 event_id presence_events PRIMARY 0 1 id presence_strikes ban 1 1 ban presence_strikes PRIMARY 0 1 id presence_strikes user_id 1 1 user_id programs PRIMARY 0 1 id reminders PRIMARY 0 1 id reminders_zoom PRIMARY 0 1 id settings db_key 1 1 db_key settings PRIMARY 0 1 id streaming_views PRIMARY 0 1 id templates PRIMARY 0 1 id templates uniq 1 1 uniq templates_content PRIMARY 0 1 id templates_content template_id 1 1 template_id trials code 1 1 code trials PRIMARY 0 1 id users club_id 1 1 club_id users exerp_id 1 1 exerp_id users external_id 1 1 external_id users PRIMARY 0 1 id users_clubs club_id 1 1 club_id users_clubs PRIMARY 0 1 id users_clubs user_id 1 1 user_id users_deleted club_id 1 1 club_id users_deleted exerp_id 1 1 exerp_id users_deleted external_id 1 1 external_id users_deleted PRIMARY 0 1 id users_modals modal_id 1 1 modal_id users_modals PRIMARY 0 1 id users_modals user_id 1 1 user_id users_trials PRIMARY 0 1 id users_trials trial_id 1 1 trial_id users_trials user_id 1 1 user_id visitors event_id 1 1 event_id visitors PRIMARY 0 1 id visitors user_id 1 1 name waitlist event_id 1 1 event_id waitlist PRIMARY 0 1 id waitlist user_id 1 1 user_id waitlist_contacted PRIMARY 0 1 id waitlist_contacted waitlist_id 1 1 waitlist_id