vanilla-rails-data-modeling

What problem does it solve?

This Skill standardizes Rails data modeling by enforcing UUID primary keys, account_id based multi-tenancy, and state-as-record patterns, ensuring auditability and scalable design across teams.

Core Features & Use Cases

• UUID primary keys: All tables use UUIDs to avoid ID enumeration and enable timestamp ordering.
• Multi-tenancy via account_id: Every tenant-scoped table includes account_id for isolation.
• State as records: Replace boolean flags with dedicated state tables to track who changed what and when.
• Index and join patterns: Guidance on leading account_id in composite indexes and robust join table patterns.
• Migration conventions: Reversible migrations with UUID references and explicit patterns for large tables.

Quick Start

Apply these conventions to your Rails schema to enforce UUIDs, account scoping, and state-tracking for auditable data.