{% if current_user and current_user.groups and '/nbspspaceadmin' in current_user.groups and db_health and db_health.status == 'error' %}
<div class="alert alert-danger mb-4" role="alert">
    <h4 class="alert-heading"><i class="fas fa-database me-2"></i>Database Schema Issues Detected</h4>
    <p>There are {{ db_health.issues_count }} schema issues that need attention.</p>
    
    {% if db_health.missing_tables|length > 0 %}
    <h5 class="mt-3">Missing Tables:</h5>
    <ul>
        {% for table in db_health.missing_tables %}
        <li>{{ table }}</li>
        {% endfor %}
    </ul>
    {% endif %}
    
    {% if db_health.models %}
    <h5 class="mt-3">Table Issues:</h5>
    <ul>
        {% for model_name, model_info in db_health.models.items() %}
            {% if model_info.has_issues %}
            <li>
                <strong>{{ model_name }}</strong> ({{ model_info.table_name }}):
                {% if model_info.missing_columns|length > 0 %}
                <ul>
                    {% for column in model_info.missing_columns %}
                    <li>Missing column: {{ column.name }} ({{ column.type }})</li>
                    {% endfor %}
                </ul>
                {% endif %}
            </li>
            {% endif %}
        {% endfor %}
    </ul>
    {% endif %}
    
    <hr>
    <p class="mb-0">
        <button class="btn btn-sm btn-outline-light" type="button" data-bs-toggle="collapse" data-bs-target="#dbHealthDetails">
            Show Details
        </button>
    </p>
    
    <div class="collapse mt-3" id="dbHealthDetails">
        <div class="card card-body bg-danger-subtle">
            <pre class="mb-0"><code>{{ db_health|tojson(indent=2) }}</code></pre>
        </div>
    </div>
</div>

{% endif %}