feat(schemas): add `saml_application_configs` table

[darcyYe]

Summary

add saml_application_configs table

We made entity_id and acs_url nullable because:

1. There is a one-to-one correspondence between records in saml_application_configs and SAML apps.
2. If a SAML app is created via the API without simultaneously inserting a record into saml_application_configs, we would need to determine, based on the DB state at that time, when to insert a saml_application_configs record. If these fields are not nullable, for a particular SAML app, when the SAML config record does not exist, it would be impossible to use the patch API to modify one of these fields individually.

Testing

Covered by CI.

Checklist

• [ ] .changeset
• [ ] unit tests
• [ ] integration tests
• [ ] necessary TSDoc comments

[github-actions[bot]]

COMPARE TO master

Total Size Diff :chart_with_upwards_trend: +2.56 KB

Diff by File

|Name|Diff| |---|---| |packages/schemas/alterations/next-1731904029-add-saml-application-configs-table.ts|:chart_with_upwards_trend: +1.13 KB| |packages/schemas/src/foundations/jsonb-types/index.ts|:chart_with_upwards_trend: +47 Bytes| |packages/schemas/src/foundations/jsonb-types/saml-application-configs.ts|:chart_with_upwards_trend: +616 Bytes| |packages/schemas/tables/saml_application_configs.sql|:chart_with_upwards_trend: +802 Bytes|