Schema Design

Keys, constraints, data types and normal forms, plus changing a schema safely with migrations.

  1. 01

    Choose a Primary Key

    • easy
  2. 02

    Let Constraints Protect Your Data

    • easy
    • Pro
  3. 03

    Store Money and Time

    • easy
    • Pro
  4. 04

    Spot Normalisation Problems

    • medium
    • Pro
  5. 05

    Soft Delete or Hard Delete?

    • medium
    • Pro
  6. 06

    Migrations in Version Control

    • medium
    • Pro
  7. 07

    Backfill a Large Table

    • hard
    • Pro