erDiagram
    lease_policies {
        bigint id PK "1"
        string policy_name "High Risk Auto Lease"
        string policy_code UK "AUTO-HIGH-RISK-001"
        text description "Requires additional approval for customers with credit score below 650"
        boolean is_active "true"
        int priority "10"
        timestamp effective_from "2024-01-01"
        timestamp effective_to "2025-12-31"
        bigint created_by FK "100"
        timestamp created_at "2024-01-15 09:30:00"
        timestamp updated_at "2024-06-20 14:15:00"
    }

    lease_policy_scopes {
        bigint id PK "101"
        bigint policy_id FK "1"
        string scope_type "REGION"
        string scope_value "US-WEST"
    }

    lease_policy_scopes {
        bigint id PK "102"
        bigint policy_id FK "1"
        string scope_type "CUSTOMER_TYPE"
        string scope_value "NEW_CUSTOMER"
    }

    lease_policy_conditions {
        bigint id PK "201"
        bigint policy_id FK "1"
        string field_name "credit_score"
        string operator "LESS_THAN"
        text value "650"
        string value_type "NUMBER"
        string logic_group "AND"
        int group_order "1"
    }

    lease_policy_conditions {
        bigint id PK "202"
        bigint policy_id FK "1"
        string field_name "vehicle_value"
        string operator "GREATER_THAN"
        text value "50000"
        string value_type "NUMBER"
        string logic_group "AND"
        int group_order "2"
    }

    lease_policy_conditions {
        bigint id PK "203"
        bigint policy_id FK "1"
        string field_name "employment_status"
        string operator "EQUALS"
        text value "SELF_EMPLOYED"
        string value_type "STRING"
        string logic_group "OR"
        int group_order "1"
    }

    lease_policy_actions {
        bigint id PK "301"
        bigint policy_id FK "1"
        string action_type "REQUIRE_APPROVAL"
        json action_config "{ approver_level: 'SENIOR_MANAGER', timeout_hours: 48 }"
    }

    lease_policy_actions {
        bigint id PK "302"
        bigint policy_id FK "1"
        string action_type "ADD_FEE"
        json action_config "{ fee_code: 'RISK_PREMIUM', amount: 500, currency: 'USD' }"
    }

    lease_policy_evaluations {
        bigint id PK "10001"
        bigint lease_processing_id FK "5001"
        bigint policy_id FK "1"
        boolean condition_met "true"
        json evaluation_details "{ matched_conditions: ['credit_score', 'vehicle_value'] }"
        string result_action "REQUIRE_APPROVAL"
        timestamp evaluated_at "2024-02-15 10:23:45"
    }

    approval_setups {
        bigint id PK "401"
        string model_type "LEASE_APPLICATION"
        string action "RISK_POLICY_APPROVAL"
        boolean is_active "true"
    }

    lease_policies ||--o{ lease_policy_scopes : has
    lease_policies ||--o{ lease_policy_conditions : has
    lease_policies ||--o{ lease_policy_actions : has
    lease_policies ||--o{ lease_policy_evaluations : logs
    lease_policy_actions }o--|| approval_setups : references
                    

sequenceDiagram
    autonumber
    actor User
    participant LW as Livewire
    participant SVC as LeaseService
    participant PE as PolicyEngine
    participant DB as Database
    participant AE as ApprovalEngine

    User->>LW: Submit Lease
    LW->>SVC: create(leaseData)
    
    SVC->>DB: INSERT LeaseProcessing (DRAFT)
    DB-->>SVC: lease_id
    
    SVC->>PE: evaluate(lease)
    activate PE
    
    PE->>DB: SELECT policies WHERE scope matches
    DB-->>PE: policies[]
    
    loop Each Policy (by priority)
        PE->>DB: SELECT conditions WHERE policy_id
        DB-->>PE: conditions[]
        
        PE->>PE: evaluateConditions(lease, conditions)
        
        alt Conditions Match
            PE->>DB: SELECT actions WHERE policy_id
            DB-->>PE: actions[]
            
            loop Each Action
                alt REQUIRE_APPROVAL
                    PE->>AE: createRequest(setup_id, lease_id)
                else ADD_FEE
                    PE->>SVC: addFee(lease, config)
                else MODIFY_TERMS
                    PE->>SVC: modifyTerms(lease, config)
                else NOTIFY
                    PE->>PE: queueNotification(config)
                end
            end
            
            PE->>DB: INSERT evaluation (MET)
        else No Match
            PE->>DB: INSERT evaluation (SKIPPED)
        end
    end
    
    PE-->>SVC: {approvals_needed, fees_added, terms_modified}
    deactivate PE
    
    alt approvals_needed
        SVC->>DB: UPDATE status = PENDING_APPROVAL
    else
        SVC->>DB: UPDATE status = ACTIVE
    end
    
    SVC-->>LW: Result
    LW-->>User: Show Status