{
  "tenant_id": "acme-corp-001",
  "name": "Acme Corporation",
  "subdomain": "acme",
  "domain": "acme.chatnio.com",
  "status": "active",
  "plan": "enterprise",
  "created_at": "2024-01-15T10:00:00Z",
  "settings": {
    "branding": {
      "logo_url": "https://cdn.chatnio.com/tenants/acme/logo.png",
      "primary_color": "#1e40af",
      "favicon_url": "https://cdn.chatnio.com/tenants/acme/favicon.ico"
    },
    "features": {
      "custom_models": true,
      "advanced_analytics": true,
      "api_access": true,
      "white_label": true
    }
  }
}

tenant_quotas:
  basic_plan:
    requests_per_minute: 100
    requests_per_day: 10000
    storage_gb: 10
    users: 50
    models: ["gpt-3.5-turbo", "claude-instant"]
  
  enterprise_plan:
    requests_per_minute: 1000
    requests_per_day: 100000
    storage_gb: 1000
    users: 1000
    models: ["*"]  # All models
    custom_models: true

#!/bin/bash
TENANT_ID=$1
TENANT_NAME=$2
ADMIN_EMAIL=$3
 
# Create tenant database schema
mysql -e "CREATE DATABASE chatnio_${TENANT_ID};"
 
# Initialize tenant configuration
curl -X POST "https://api.chatnio.com/admin/tenants" \
  -H "Content-Type: application/json" \
  -d "{
    \"tenant_id\": \"${TENANT_ID}\",
    \"name\": \"${TENANT_NAME}\",
    \"admin_email\": \"${ADMIN_EMAIL}\"
  }"
 
# Setup DNS and SSL
./setup-domain.sh ${TENANT_ID}
 
echo "Tenant ${TENANT_ID} onboarded successfully"

-- Add tenant_id to all major tables
ALTER TABLE users ADD COLUMN tenant_id VARCHAR(36) NOT NULL;
ALTER TABLE channels ADD COLUMN tenant_id VARCHAR(36) NOT NULL;
ALTER TABLE conversations ADD COLUMN tenant_id VARCHAR(36) NOT NULL;
ALTER TABLE api_keys ADD COLUMN tenant_id VARCHAR(36) NOT NULL;
 
-- Create tenant management tables
CREATE TABLE tenants (
    id VARCHAR(36) PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    subdomain VARCHAR(100) UNIQUE NOT NULL,
    status ENUM('active', 'suspended', 'terminated') DEFAULT 'active',
    plan VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
 
CREATE TABLE tenant_settings (
    tenant_id VARCHAR(36) PRIMARY KEY,
    branding JSON,
    features JSON,
    quotas JSON,
    FOREIGN KEY (tenant_id) REFERENCES tenants(id) ON DELETE CASCADE
);

multi_tenancy:
  enabled: true
  isolation_mode: "database"  # database, schema, or application
  subdomain_routing: true
  custom_domains: true
  
  default_quotas:
    users: 100
    api_requests_per_month: 100000
    storage_gb: 50
    
  billing:
    enabled: true
    provider: "stripe"
    currency: "USD"

func TenantMiddleware(next http.Handler) http.Handler {
    return http.HandlerFunc(func(w http.ResponseWriter, r *http.Request) {
        var tenantID string
        
        // Extract tenant from subdomain
        host := r.Host
        if subdomain := extractSubdomain(host); subdomain != "" {
            tenant, err := getTenantBySubdomain(subdomain)
            if err == nil {
                tenantID = tenant.ID
            }
        }
        
        // Extract tenant from custom domain
        if tenantID == "" {
            tenant, err := getTenantByDomain(host)
            if err == nil {
                tenantID = tenant.ID
            }
        }
        
        // Add tenant context
        ctx := context.WithValue(r.Context(), "tenant_id", tenantID)
        next.ServeHTTP(w, r.WithContext(ctx))
    })
}

func WithTenantFilter(ctx context.Context, query string) string {
    tenantID := ctx.Value("tenant_id").(string)
    if tenantID == "" {
        panic("No tenant context found")
    }
    
    // Add tenant filter to all queries
    if strings.Contains(query, "WHERE") {
        return strings.Replace(query, "WHERE", 
            fmt.Sprintf("WHERE tenant_id = '%s' AND", tenantID), 1)
    } else {
        return query + fmt.Sprintf(" WHERE tenant_id = '%s'", tenantID)
    }
}

# Prometheus metrics configuration
tenant_metrics:
  - name: tenant_api_requests_total
    type: counter
    labels: [tenant_id, method, endpoint, status]
    
  - name: tenant_active_users
    type: gauge
    labels: [tenant_id]
    
  - name: tenant_resource_usage
    type: gauge
    labels: [tenant_id, resource_type]
 
# Grafana dashboard per tenant
grafana:
  tenant_dashboards:
    enabled: true
    auto_provision: true
    variables:
      - name: tenant
        type: query
        query: "label_values(tenant_id)"

tenant_alerts:
  - alert: TenantHighErrorRate
    expr: rate(tenant_api_requests_total{status=~"5.."}[5m]) > 0.1
    labels:
      severity: warning
    annotations:
      summary: "High error rate for tenant {{ $labels.tenant_id }}"
      
  - alert: TenantQuotaExceeded
    expr: tenant_resource_usage{resource_type="api_requests"} > tenant_quota{resource_type="api_requests"}
    labels:
      severity: critical
    annotations:
      summary: "Tenant {{ $labels.tenant_id }} exceeded quota"