Pin ServiceJob's join columns to INT8

Shipped

August 26, 2026 at 8:03 AM UTC

Author

Kamo

Commit

0df24f4

Exporting the table's DDL showed org_id, engagement_id and customer_uid each emitted as INT8 DEFAULT unique_rowid() — inherited from the referenced key. Three foreign keys that, left unset, would invent a random id pointing at nothing instead of staying null. A job saved without a customer would silently claim one. Same mechanism CalendarEvent.member already pins against, and QuoteLineItem documents the UUID variant of.