Example schemas

Geo hierarchy, employee self-reference, a mutual FK cycle, and temporal job history — the small intro example.

Many-to-many playlists, an InvoiceLine join-with-payload, self-referential reports_to, @soft_delete, money as i64 cents.

An OrderDetail join with a discount payload, self-referential employees, multi-FK orders, and composite indexes.

Two many-to-many relations on one model, dual FK to the same model, a store↔staff mutual cycle, and a geo chain — the most complex example.

Fork-lineage self-reference, PR head/base dual FK, org/team RBAC joins, and issue↔label many-to-many.

@fulltext, three many-to-many pairs, a subscription-billing join, and ISO currency as char(3).

Reply-thread self-reference, follow/block join models (dual FK to Account), and notifications.

A textbook many-to-many-with-payload (Enrollment grade), section/term/course FKs, and GPA constraints.

Appointments, role-as-string providers, prescriptions and diagnoses, and a composite scheduling index.

A RoomType template vs Room inventory split, date-range availability, and i64 money.

A struct GeoPoint (required + optional), an OrderItem join, and a timestamped status-event audit log.

Double-entry transactions, a Transfer dual FK to Account, joint-account many-to-many, and char(3) currency.

Flight dual FK to Airport, a unique-seat composite index (seat lock), and IATA codes as char(3).

snake_case component refs (tsx:// / jsx:// / api://), self-referential comments and categories, @fulltext, and @soft_delete.

An Org→Team→Project→Issue hierarchy, sub-issue self-reference, label many-to-many, and dual composite indexes.

Per-tenant *Organization scoping, a Membership RBAC join, API keys, and an audit log.

Product variants, CartItem/OrderItem joins, money as i64 minor units, and SKU/order-number natural keys.

A +u64 high-volume PK, a fixed array [f64; 3], a struct Calibration, and append-heavy telemetry.