Create
Query
pilot.db
—
bookings
account_invites
accounts
applied_migrations
audit_log
availability
availability_exceptions
bookings
campaign_leads
campaign_offers
campaigns
cards
commission_rates
commission_runs
drills_library
invoices
magic_tokens
offers
practice_logs
quotes
saas_invoices
service_student_prices
services
sessions
sqlite_sequence
student_summaries
students
subscription_events
trainer_settings
trainers
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 50 in bookings
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
student_id
INTEGER NOT NULL
service_key
s27
TEXT NOT NULL
starts_at
2026-08-24T10:00:00.000Z
TEXT NOT NULL
duration_min
INTEGER NOT NULL
card_id
INTEGER
invoice_id
INTEGER
video_analysis
{"status":"ready","swing_count":null,"started_at":"2026-08-23T10:06:51.947Z","stopped_at":"2026-08-23T10:06:58.188Z","purchased_at":null,"video_filename":"b2357ecc-12d3-4280-8478-33696f289bb2.mp4","video_size":7810002,"video_uploaded_at":"2026-08-23T10:06:59.809Z"}
TEXT
notes
Aus Angebot „Einsteiger Paket – Dein Start ins Golfspiel"
TEXT
status
confirmed
TEXT NOT NULL (default 'confirmed'
created_at
2026-08-18 17:58:05
TEXT NOT NULL (default datetime('now')
protocol
NULL
TEXT
protocol_approved_at
NULL
TEXT
confirmation_sent_at
2026-08-18 17:58:05
TEXT
reminder_sent_at
2026-08-23 04:07:04
TEXT
cancellation_sent_at
NULL
TEXT
video_unlocked_at
NULL
TEXT
video_invoice_id
INTEGER
swing_metrics
{"phases":{"address":0.6,"top":1.2000000000000004,"impact":4.249999999999993,"finish":11.050000000000022,"tempoRatio":0.19672131147541044,"swingDuration":10.450000000000022},"metrics":{"tempo_ratio":0.2,"swing_duration_s":10.5,"shoulder_rotation_top_deg":63.5,"hip_rotation_top_deg":22.4,"x_factor_top_deg":41.2,"spine_tilt_address_deg":43.3,"spine_tilt_top_deg":24.9,"spine_tilt_impact_deg":31.8,"elbow_left_top_deg":132.2,"elbow_right_top_deg":126.5,"knee_left_address_deg":152.5,"knee_right_address_deg":160.3,"head_drift_pct":27.8},"ai_text":"**CaddyBear-Analyse für Nico Mueller**\n\nVier Werte stechen ins Auge:\n\n1. **Tempo-Ratio 0,2** (Referenz ~3:1): Der Schwung dauert mit 10,5 s ungewöhnlich lang – möglicherweise ein Messartefakt, aber falls real, fehlt jegliche Dynamik im Übergang.\n2. **Schulterrotation nur 63,5°** (Referenz 85–100°): Die Rückdrehung wirkt deutlich verkürzt, was Kraftpotenzial kostet.\n3. **Kopfdrift 27,8 %** (Referenz <5 %): Auffällig hohe laterale Kopfbewegung – Gleichgewicht und Zentrum könnten instabil sein.\n4. **Lead-Arm (links) 132,2°** am Top (Referenz >150°): Der Arm ist merklich gebeugt, was zur verkürzten Schulterrotation passen könnte.\n\n**Übungsvorschläge:**\n- **Kopfstabilität:** Schwungübung mit Schläger an der Wand oder „Kopf-an-Stab\"-Drill, um den Drift zu reduzieren.\n- **Schulter & Arm:** Langsame Rückdrehung mit Betonung des gestreckten Leadarms bis zum Top – gern als Ergänzung zur bisherigen Eisenarbeit aus der letzten Stunde.","created_at":"2026-08-23T10:04:58.133Z"}
TEXT
student_note
NULL
TEXT
Update
Cancel