Add DEPTS.PARENT_DEPT_ID for nested departments

Ya

7 Agosti 2026, 05:58 UTC

Mwandishi

Kamo

Ahadi ya

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.