Transition dast_site_profiles to loose foreign keys

Implementation Plan

• Update base class for Sbom::Source to rely on Gitlab::Database::SecApplicationRecord
• Update db/docs/TABLE_NAME.yml to point to new gitlab_sec schema
• If table references tables beyond the sec DB boundary (i.e. ✅ projects, ❌ sbom_*), use the generate-loose-foreign-key script to decompose foreign keys for target table
• do while verifying behavior
  • Fix cross-database transactions
  • Fix cross joins