FlexLesson
Tables (20)
availability_exceptions
- ID (id) — UUID — Primary key — NOT NULL
- instructor_id — UUID
- exception_date — DATE
- start_time — TIME
- end_time — TIME
- reason — VARCHAR(255)
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → instructors.ID — NOT NULL
availability_rules
- ID (id) — UUID — Primary key — NOT NULL
- instructor_id — UUID
- day_of_week — INTEGER
- start_time — TIME
- end_time — TIME
- duration_options — JSONB
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → instructors.ID — NOT NULL
booking_attendees
- ID (id) — UUID — Primary key — NOT NULL
- booking_id — UUID
- student_id — UUID
- host_id — UUID
- attendee_type — VARCHAR(50)
- payment_to — VARCHAR(50)
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → hosts.ID — NOT NULL
- ID (id3) — UUID — Foreign key → students.ID — NOT NULL
- ID (id4) — UUID — Foreign key → bookings.ID — NOT NULL
booking_invites
- ID (id) — UUID — Primary key — NOT NULL
- booking_id — UUID
- invite_code — VARCHAR(9)
- max_guests — INTEGER
- accepted_count — INTEGER
- expires_at — TIMESTAMPTZ
- last_accepted_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → bookings.ID — NOT NULL
bookings
- ID (id) — UUID — Primary key — NOT NULL
- instructor_id — UUID
- host_id — UUID
- waiver_version_id — UUID
- package_id — UUID
- original_booking_id — UUID
- lesson_date — DATE
- lesson_start_time — TIME
- lesson_end_time — TIME
- duration_minutes — INTEGER
- lesson_address — TEXT
- base_price_cents — INTEGER
- extra_student_count — INTEGER
- extra_student_fee_cents — INTEGER
- total_price_cents — INTEGER
- payment_method — VARCHAR(50)
- payment_status — VARCHAR(50)
- stripe_payment_intent_id — VARCHAR(255)
- host_transfer_confirmed — BOOLEAN
- booking_status — VARCHAR(50)
- cancelled_by — VARCHAR(50)
- cancellation_reason — TEXT
- cancelled_at — TIMESTAMPTZ
- refund_amount_cents — INTEGER
- waiver_accepted — BOOLEAN
- waiver_accepted_at — TIMESTAMPTZ
- waiver_ip_address — INET
- used_package_credit — BOOLEAN
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → instructors.ID — NOT NULL
- ID (id3) — UUID — Foreign key → hosts.ID — NOT NULL
- ID (id4) — UUID — Foreign key → bookings.ID — NOT NULL
- ID (id5) — UUID — Foreign key → waivers.ID — NOT NULL
certificates
- ID (id) — UUID — Primary key — NOT NULL
- student_id — UUID
- test_id — UUID
- belt_level — VARCHAR(100)
- issued_date — DATE
- pdf_url — TEXT
- pdf_generated_at — TIMESTAMPTZ
- download_count — INTEGER
- last_downloaded_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → students.ID — NOT NULL
emergency_contacts
- ID (id) — UUID — Primary key — NOT NULL
- student_id — UUID
- name — VARCHAR(255)
- relationship — VARCHAR(100)
- phone_number — VARCHAR(50)
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → students.ID — NOT NULL
extra_attendee_payments
- ID (id) — UUID — Primary key — NOT NULL
- booking_id — UUID
- guest_host_id — UUID
- amount_cents — INTEGER
- payment_method — VARCHAR(50)
- payment_status — VARCHAR(50)
- stripe_payment_intent_id — VARCHAR(255)
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → hosts.ID — NOT NULL
- ID (id3) — UUID — Foreign key → bookings.ID — NOT NULL
host_credits
- ID (id) — UUID — Primary key — NOT NULL
- host_id — UUID
- booking_id — UUID
- amount_cents — INTEGER
- reason — VARCHAR(255)
- used — BOOLEAN
- used_at — TIMESTAMPTZ
- expires_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → hosts.ID — NOT NULL
- ID (id3) — UUID — Foreign key → bookings.ID — NOT NULL
hosts
- ID (id) — UUID — Primary key — NOT NULL
- user_id — UUID
- full_name — VARCHAR(255)
- date_of_birth — DATE
- address — TEXT
- email — VARCHAR(255)
- phone_number — VARCHAR(50)
- can_sign_waiver — BOOLEAN
- zelle_qr_url — TEXT
- venmo_qr_url — TEXT
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → users.ID — NOT NULL
instructor_checklists
- ID (id) — UUID — Primary key — NOT NULL
- instructor_id — UUID
- lesson_date — DATE
- items — JSONB
- auto_generated — BOOLEAN
- completed — BOOLEAN
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → instructors.ID — NOT NULL
instructors
- ID (id) — UUID — Primary key — NOT NULL
- user_id — UUID
- business_name — VARCHAR(255)
- slug — VARCHAR(255)
- service_type — VARCHAR(100)
- bio — TEXT
- profile_image_url — TEXT
- hourly_rate_cents — INTEGER
- max_students — INTEGER
- base_capacity — INTEGER
- extra_student_fee_cents — INTEGER
- stripe_account_id — VARCHAR(255)
- stripe_onboarding_complete — BOOLEAN
- zelle_qr_url — TEXT
- venmo_qr_url — TEXT
- platform_fee_percentage — DECIMAL(5,2)
- beta_expires_at — TIMESTAMPTZ
- is_beta_user — BOOLEAN
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → users.ID — NOT NULL
level_tests
- ID (id) — UUID — Primary key — NOT NULL
- instructor_id — UUID
- test_name — VARCHAR(255)
- requirements — TEXT
- promotion_form_fields — JSONB
- requires_boards_count — BOOLEAN
- belt_color — VARCHAR(50)
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → instructors.ID — NOT NULL
notifications
- ID (id) — UUID — Primary key — NOT NULL
- recipient_id — UUID
- type — VARCHAR(100)
- title — VARCHAR(255)
- body — TEXT
- action_url — TEXT
- action_label — VARCHAR(100)
- is_read — BOOLEAN
- read_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → users.ID — NOT NULL
payments
- ID (id) — UUID — Primary key — NOT NULL
- booking_id — UUID
- stripe_payment_intent_id — VARCHAR(255)
- amount_cents — INTEGER
- platform_fee_cents — INTEGER
- instructor_amount_cents — INTEGER
- status — VARCHAR(50)
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → bookings.ID — NOT NULL
slot_locks
- ID (id) — UUID — Primary key — NOT NULL
- instructor_id — UUID
- host_id — UUID
- lesson_date — DATE
- lesson_start_time — TIME
- duration_minutes — INTEGER
- expires_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → instructors.ID — NOT NULL
- ID (id3) — UUID — Foreign key → hosts.ID — NOT NULL
student_progress
- ID (id) — UUID — Primary key — NOT NULL
- student_id — UUID
- test_id — UUID
- completed_requirements — JSONB
- progress_percentage — DECIMAL(5,2)
- host_notified — BOOLEAN
- notified_at — TIMESTAMPTZ
- promotion_form_data — JSONB
- host_form_submitted — BOOLEAN
- form_submitted_at — TIMESTAMPTZ
- test_completed — BOOLEAN
- test_date — DATE
- passed — BOOLEAN
- instructor_notes — TEXT
- score — DECIMAL(5,2)
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → students.ID — NOT NULL
students
- ID (id) — UUID — Primary key — NOT NULL
- host_id — UUID
- full_name — VARCHAR(255)
- date_of_birth — DATE
- is_host — BOOLEAN
- notes — TEXT
- current_level — VARCHAR(100)
- lessons_in_current_level — INTEGER
- last_test_date — DATE
- ready_for_level_test — BOOLEAN
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → hosts.ID — NOT NULL
users
- ID (id) — UUID — Primary key — NOT NULL
- clerk_id — VARCHAR(255)
- phone_number — VARCHAR(50)
- role — VARCHAR(50)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
waivers
- ID (id) — UUID — Primary key — NOT NULL
- instructor_id — UUID
- waiver_text — TEXT
- version — INTEGER
- is_active — BOOLEAN
- created_at — TIMESTAMPTZ
- ID (id2) — UUID — Foreign key → instructors.ID — NOT NULL