Database Tables and Views
All datasets, data views, and their columns are generated from the information coming from the assessments.
These tables and views provide pre-joined, analysis-ready data for Superset dashboards.
dimensions
EVERSE quality dimensions.
- id
- Primary key
- identifier
- Unique identifier (e.g., "testing")
- name
- Display name (e.g., "Testing")
- description
- Detailed description
indicators
Quality indicators linked to dimensions.
- id
- Primary key
- identifier
- Unique identifier (e.g., "IND-testing-001")
- name
- Display name
- description
- What this indicator measures
- quality_dimension
- Reference to parent dimension
software
Registered research software projects.
- id
- Primary key
- name
- Display name
- repository_url
- Source code repository URL
- programming_language
- Array of programming languages
assessments_detailed
Provides a detailed view of each assessment, including metadata and the full JSON payload of all checks.
- id
- Unique identifier for the assessment.
- date_created
- The date the assessment was performed.
- software_name
- Name of the assessed software.
- total_checks
- Total number of checks in the assessment.
checks_detailed
An unnested view of individual checks, linking each check to its corresponding indicator and dimension.
- assessment_id
- Identifier of the assessment this check belongs to.
- software_name
- Name of the assessed software.
- indicator_id
- Identifier of the quality indicator being assessed.
- status
- The result of the check (e.g., Pass, Fail).
- indicator_name
- Name of the indicator.
- dimension_name
- Name of the quality dimension.
assessment_summary
Aggregated metrics per software project.
- software_name
- Software name
- assessment_count
- Total assessments
- latest_assessment
- Most recent assessment date
- avg_checks
- Average checks per assessment
- unique_indicators
- Unique indicators assessed
dimension_coverage
Pass/fail statistics per quality dimension.
- dimension_name
- Dimension name
- total_checks
- Total checks in this dimension
- passed
- Checks with Pass status
- failed
- Checks with Fail status
- pass_rate
- Percentage of passed checks
indicator_results
Results grouped by indicator and status.
- indicator_name
- Indicator name
- dimension_name
- Dimension name
- status
- Check status
- occurrences
- Count of this status
- percentage
- Percentage of total for indicator
software_quality_scores
Quality scores per software and dimension.
- software_name
- Software name
- dimension_name
- Dimension name
- score
- Pass rate as percentage
assessment_trends
Monthly assessment statistics.
- month
- Month (truncated date)
- assessments
- Assessments in this month
- software_count
- Unique software assessed
common_issues
Frequently failing indicators across all assessments.
- indicator_name
- Indicator name
- dimension_name
- Parent dimension
- failure_count
- Number of failures
- affected_software
- Software affected by this issue
software_languages
Software projects with programming languages.
- software_name
- Software name
- language
- Programming languages array