laneweaver-database-design

What problem does it solve?

This Skill helps design PostgreSQL 17 schemas for laneweaverTMS using Supabase conventions—UUIDs, ENUMs, audit trails, soft deletes, triggers, functions, views, and atomic migration patterns—reducing manual design time and ensuring consistency across deployments.

Core Features & Use Cases

• Schema design: Define UUID primary keys, audit columns, soft deletes, and row-level security policies.
• Enum strategy: Plan and deploy 32+ ENUMs to represent lifecycle, statuses, and categories.
• Migrations & Automation: Create deterministic, atomic migrations with triggers and functions.
• Polymorphic relationships & views: Model complex relationships and derived data for reporting.

Quick Start

Provide a deterministic migration plan for laneweaverTMS using Supabase conventions. For example, create an initial schema for the loads table with UUID primary key, audit columns, and soft delete, and set up a trigger to populate updated_at on modifications.