Build an AI Appointment Assistant | Ep 2: The Whole Database in One Go (Laravel 13)

Great features start with a solid database. In Episode 2 we design EVERY table our AI appointment app will ever need — up front — so no future episode has to touch a migration again. We build an admin flag, doctors, weekly availability, and appointments, write modern Laravel 13 models, seed demo data, and then deliberately try to double-book a doctor to watch the database defend itself. In this episode: ✅ Design all tables in one focused sitting ✅ Modern Laravel 13 models (#[Fillable] attribute + casts() method) ✅ Model a doctor's weekly availability + a reusable slotsFor() method ✅ Seed an admin user + doctors with varied schedules ✅ PROVE the unique constraint blocks double-booking (in Tinker) 🧰 Stack: Laravel 13 · React 19 · Inertia.js 3 · TypeScript · Tailwind 4 · Laravel AI SDK · Google Gemini (free) · SQLite ▶️ Full playlist:    • Build an AI Appointment Assistant — Larave...   💻 Source code: https://github.com/shadrackjm/ai-doct... 🔔 Subscribe for more Laravel + AI builds: Editor used: Cursor (VS Code also works) Local dev: Laravel Herd (https://herd.laravel.com) AI key: Google AI Studio (free tier) #Laravel #ReactJS #AI #LaravelAI #InertiaJS #WebDevelopment #FullStack #TypeScript #Database