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