Correct top-level structure

schema.sql present

migrations/ folder

seeds/ folder

docs/ folder with ERD and SCHEMA

Mermaid ERD diagram

UUID primary keys

snake_case naming

Plural table names

created_at and updated_at present

Soft delete pattern

Junction table for N:M

Foreign keys with cascade options

NOT NULL on required columns

Indexes on foreign keys

UP migration files

DOWN migration files

Transactions in UP migration

Transactions in DOWN migration

CHECK constraint on quantity

CHECK constraint on refill limit

updated_at trigger

GIN index for full-text search

Foreign key on prescriptions

Index on prescription foreign key

UUID primary key on prescriptions

OLTP normalized to 3NF

OLAP denormalization

Materialized view for aggregates

Time-ordered UUID

Composite index selectivity

Partial index on nullable/sparse column

Index on foreign keys

created_at and updated_at

Normalization rationale documented

UUID performance rationale

No EAV pattern