#76 DB Migration: Tenant Settings Table
Description
EditCreate database migration for tenant-specific settings.
Migration File: engine/migrations/sql/XXX_tenant_settings_table.sql
Table: tenant_settings
Columns:
- tenant_id: varchar(100) primary key
- display_name: varchar(255)
- status: varchar(20) (active, suspended, pending_deletion)
- settings: jsonb (flexible settings storage)
- rate_limits: jsonb
- security_settings: jsonb
- created_at: timestamp
- updated_at: timestamp
- created_by: uuid
- deleted_at: timestamp
Settings JSONB Structure:
- session_timeout_minutes: int
- max_sessions_per_user: int
- password_policy: object
- mfa_required: boolean
- allowed_oauth_providers: array
Rate Limits JSONB:
- api_requests_per_minute: int
- workflow_submissions_per_hour: int
- etc.
With ultra attention to details and correctness.
Before closing: write comment summarizing implementation with screenshot.
Comments
Loading comments...
Context
Loading context...
Audit History
View AllLoading audit history...