Pin ServiceJob's join columns to INT8

Shipped

26 ஆகஸ்ட், 2026 அன்று 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.