erDiagram
    Agent ||--o{ Run : "tested in"
    EvalSet ||--o{ Run : "evaluated by"
    EvalSet ||--o{ EvalSetMember : "contains"
    TestCase ||--o{ EvalSetMember : "belongs to"
    Run ||--o{ TestCaseResult : "produces"
    TestCase ||--o{ TestCaseResult : "evaluated in"
 
    Agent {
        uuid id PK
        string name
        string description
        enum mode
        string endpoint_url
        text system_prompt
        jsonb tools
        string agent_model
        string agent_provider
        jsonb metadata
        timestamp created_at
        timestamp updated_at
    }
 
    TestCase {
        uuid id PK
        string name
        string description
        enum difficulty
        text_array tags
        enum status
        jsonb persona
        string initial_message
        jsonb user_context
        int max_turns
        jsonb expected_outcomes
        jsonb expected_tool_calls
        string evaluation_criteria_override
        timestamp created_at
        timestamp updated_at
    }
 
    EvalSet {
        uuid id PK
        string name
        string description
        int version
        timestamp created_at
        timestamp updated_at
    }
 
    EvalSetMember {
        uuid eval_set_id FK
        uuid test_case_id FK
        int position
    }
 
    Run {
        uuid id PK
        string name
        uuid agent_id FK
        string agent_endpoint_url
        text agent_system_prompt
        jsonb agent_tools
        string agent_mode
        string agent_model
        string agent_provider
        uuid eval_set_id FK
        int eval_set_version
        jsonb config
        enum status
        bool is_baseline
        jsonb aggregate_metrics
        timestamp started_at
        timestamp completed_at
        timestamp created_at
        timestamp updated_at
    }
 
    TestCaseResult {
        uuid id PK
        uuid run_id FK
        uuid test_case_id FK
        jsonb transcript
        int turn_count
        jsonb verdict
        int total_latency_ms
        int agent_latency_p50_ms
        int agent_latency_p95_ms
        int agent_latency_max_ms
        jsonb agent_token_usage
        jsonb platform_token_usage
        float estimated_cost_usd
        bool passed
        text error_message
        timestamp started_at
        timestamp completed_at
        timestamp created_at
        timestamp updated_at
    }