#76 DB Migration: Tenant Settings Table

open high Created 2025-11-27 07:18 · Updated 2025-11-27 07:18

Description

Edit
Create 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 All
Loading audit history...