Add DEPTS.PARENT_DEPT_ID for nested departments

Shipped

August 7, 2026 at 5:58 AM UTC

Author

Kamo

Commit

7f70b12

Nullable with no backfill -- null means top level, which is what every existing department was and most will stay. Declared plain UUID with an explicit DROP DEFAULT. Departments key off UUID DEFAULT gen_random_uuid(), and a FK column that inherits that default gets stamped with a random parent on every existing row, orphaning all of them and failing the constraint that follows.