[FAM] Onboarding SCS app to FAM

[ianliuwk1019]

Describe the task
Onboarding new application "SCS" to FAM.

Pending to confirm with the team (TODO):

• IDP provider (IDP, BCeID or both)
• App's description.
• What roles, roles' description and if associated with forest_client.

Acceptance Criteria
Flyway -

• Add a new flyway migration at FAM for SCS
• Add new application SCS to fam_application
• Add new SCS roles to fam_role
• Add SCS to fam_application_client

Terraform -

• Add a new oidc app client (SCS) to Cognito with Terraform.
• Configure new app client's callback_urls and logout_urls; refer to above screenshot information.
• Configure only with minimum_oidc_attribute_list and with correct supported_identity_providers
• Configure IDP providers (IDIR, BCeID or both) correctly based on app needs.
• Add client_id placeholder to flyway.tf

Others -

• Add client_id placeholder to reusable_data_model_gen.yml
• Add client_id placeholder to docker-base-services.yml

Additional context

• Example PR: feat: #2066 Onboarding ISP to FAM #2068
• Or here