feat(coderd/database): generate foreign key constraints and add database.IsForeignKeyViolation#9657