✨ Add Tenant Entity and Migrations

[zacharykeeping]

Hi Developers,

Pain

We need a database table to store tenant metadata and settings. This provides a persistent store for tenant information beyond configuration files.

Suggested Solution

Create a Tenant entity with all required settings fields. Generate EF Core migration and seed default SSW tenant data.

Implementation:

• Create Tenant entity class
• Create BaseTenantEntity base class
• Configure in ApplicationDbContext
• Generate migration
• Add seed data

Tasks

• Create Domain/Entities/Tenant.cs
• Create Domain/Common/BaseTenantEntity.cs
• Configure entity in ApplicationDbContext
• Generate EF migration
• Create seed data migrator
• Test migration on clean database
• Add unique constraints on tenant identifiers
• Include audit fields (CreatedDate, etc.)

Acceptance Criteria

• Meets Definition of Done - https://github.com/SSWConsulting/SSW.Rewards.Mobile/blob/main/_docs/Definition-of-Done.md
• Tenant entity created with all settings
• EF migration generated and tested
• Seed data for SSW tenant
• Unique constraints on tenant identifiers
• Audit fields included (CreatedDate, etc.)

More Information

Files to Create/Modify:

• NEW: src/Domain/Entities/Tenant.cs
• NEW: src/Domain/Common/BaseTenantEntity.cs
• MODIFY: src/Infrastructure/Persistence/ApplicationDbContext.cs
• MODIFY: src/Infrastructure/Persistence/ApplicationDbContextInitializer.cs
• NEW: EF migration file

Epic: #1483

Thanks!