SQL schema validator doesn't recognize nullable-tenant-id scope pattern

projects/ores.sql/utility/validate_schemas.sh's TENANT_002=/=TENANT_003 checks flag any table whose tenant_id isn't part of the primary key/EXCLUDE constraint, with no awareness of the legitimate nullable-tenant-id shape: a table supporting system/tenant/party scope levels (system-scope rows leave tenant_id null so they're shared across every tenant) genuinely cannot put a nullable column in a not null PK/EXCLUDE clause. ores_scheduler_job_definitions_tbl, ores_mq_queues_tbl, and ores_synthetic_market_data_generation_configs_tbl already use this shape by design, and each needed its own hand-written TENANT_002=/=TENANT_003 entry in validation_ignore.txt rather than the validator recognising it as a category. Codegen already has a name for this exact shape – domain_entity.sql.nullable_tenant_id – consumed by the SQL/C++ templates for exactly this scoping pattern. Teach the validator to check that flag (or infer it the same way the templates do: tenant_id uuid with no not null) and skip TENANT_002=/=003 automatically for tables built that way, rather than requiring a per-table ignore entry every time a new nullable-tenant-id table is added.

Surfaced while working the ir-curve-bootstrap-config task (task) in the IR curve bootstrapping + official curve republish story (Sprint 25): compass db recreate surfaced two pre-existing warnings on ores_synthetic_market_data_generation_configs_tbl (from an unrelated PR, #1826) that turned out to be an intentional design, not a bug – fixed for now with a documented validation_ignore.txt entry, but the underlying gap (the validator not recognising a category codegen itself already names) will keep recurring for every future nullable-tenant-id table until the validator understands the pattern generically.

• projects/ores.sql/utility/validation_ignore.txt – the TENANT_002=/=TENANT_003 entries for ores_synthetic_market_data_generation_configs_tbl, ores_scheduler_job_definitions_tbl, and ores_mq_queues_tbl, each explaining the same shape independently.
• projects/ores.codegen/library/templates/*.mustache – domain_entity.sql.nullable_tenant_id usage, the existing codegen name for this pattern.

• IR curve bootstrapping + official curve republish – the story whose task surfaced this.