Evaluation database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`evaluation`

Doctrine entity: Evaluation\Entity\Evaluation

Column	Doctrine type	Key
`evaluation_id`	`integer`
`description`	`text`
`date_updated`	`datetime`
`eligible`	`smallint`
`status_id`	`FK`	FK
`contact_id`	`FK`	FK
`country_id`	`FK`	FK
`type_id`	`FK`	FK
`project_id`	`FK`	FK

`evaluation_feedback`

Doctrine entity: Evaluation\Entity\Feedback

Column	Doctrine type	Key
`evaluation_feedback_id`	`integer`
`date_updated`	`datetime`
`mandatory_improvements`	`text`
`recommended_improvements`	`text`
`review_feedback`	`text`
`evaluation_feedback`	`text`
`evaluation_conclusion`	`text`
`version_id`	`FK`	FK
`status_id`	`FK`	FK

`evaluation_platform`

Doctrine entity: Evaluation\Entity\Evaluation\Platform

Column	Doctrine type	Key
`project_evaluation_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`evaluation_id`	`FK`	FK

`evaluation_report2`

Doctrine entity: Evaluation\Entity\Report

Column	Doctrine type	Key
`evaluation_report_id`	`integer`
`final`	`boolean`
`date_final`	`datetime`
`date_submitted`	`datetime`
`date_reviewed`	`datetime`
`date_created`	`datetime`
`date_updated`	`datetime`
`project_version_score`	`smallint`
`evaluation_result`	`smallint`
`office_evaluation`	`smallint`
`comment_for_project_leader`	`text`
`version_id`	`FK`	FK

`evaluation_report2_criterion`

Doctrine entity: Evaluation\Entity\Report\Criterion

Column	Doctrine type	Key
`criterion_id`	`integer`
`sequence`	`integer`
`criterion`	`string`
`help_block`	`text`
`input_type`	`smallint`
`values`	`text`
`has_score`	`boolean`
`background_color`	`string`
`has_background_color`	`boolean`
`archived`	`boolean`

`evaluation_report2_criterion_category`

Doctrine entity: Evaluation\Entity\Report\Criterion\Category

Column	Doctrine type	Key
`category_id`	`integer`
`sequence`	`integer`
`category`	`string`

`evaluation_report2_criterion_topic`

Doctrine entity: Evaluation\Entity\Report\Criterion\Topic

Column	Doctrine type	Key
`topic_id`	`integer`
`sequence`	`integer`
`topic`	`string`

`evaluation_report2_criterion_type`

Doctrine entity: Evaluation\Entity\Report\Criterion\Type

Column	Doctrine type	Key
`type_id`	`integer`
`sequence`	`integer`
`type`	`string`
`category_id`	`FK`	FK

`evaluation_report2_criterion_version`

Doctrine entity: Evaluation\Entity\Report\Criterion\Version

Column	Doctrine type	Key
`criterion_version_id`	`integer`
`sequence`	`integer`
`required`	`boolean`
`confidential`	`boolean`
`highlighted`	`boolean`
`has_actions`	`boolean`
`defaultValue`	`string`
`criterion_id`	`FK`	FK
`version_id`	`FK`	FK
`type_id`	`FK`	FK

`evaluation_report2_criterion_version_topic`

Doctrine entity: Evaluation\Entity\Report\Criterion\VersionTopic

Column	Doctrine type	Key
`criterion_topic_id`	`integer`
`weight`	`smallint`
`criterion_version_id`	`FK`	FK
`topic_id`	`FK`	FK

`evaluation_report2_project_report`

Doctrine entity: Evaluation\Entity\Report\ProjectReport

Column	Doctrine type	Key
`project_report_id`	`integer`
`project_status`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`evaluation_report_id`	`FK`	FK
`report_id`	`FK`	FK
`report_review_id`	`FK`	FK

`evaluation_report2_project_version`

Doctrine entity: Evaluation\Entity\Report\ProjectVersion

Column	Doctrine type	Key
`project_version_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`evaluation_report_id`	`FK`	FK
`project_version_review_id`	`FK`	FK
`version_id`	`FK`	FK

`evaluation_report2_result`

Doctrine entity: Evaluation\Entity\Report\Result

Column	Doctrine type	Key
`result_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_changed`	`datetime`
`score`	`smallint`
`value`	`text`
`comment`	`text`
`evaluation_report_id`	`FK`	FK
`criterion_version_id`	`FK`	FK

`evaluation_report2_type`

Doctrine entity: Evaluation\Entity\Report\Type

Column	Doctrine type	Key
`type_id`	`integer`
`sequence`	`integer`
`type`	`string`
`process_type`	`smallint`
`version_type_id`	`FK`	FK

`evaluation_report2_version`

Doctrine entity: Evaluation\Entity\Report\Version

Column	Doctrine type	Key
`version_id`	`integer`
`label`	`string`
`description`	`text`
`archived`	`boolean`
`date_created`	`datetime`
`type_id`	`FK`	FK

`evaluation_report2_window`

Doctrine entity: Evaluation\Entity\Report\Window

Column	Doctrine type	Key
`window_id`	`integer`
`title`	`string`
`description`	`text`
`date_start_report`	`datetime`
`date_end_report`	`datetime`
`date_start_selection`	`datetime`
`date_end_selection`	`datetime`
`inputMethod`	`array`
`report_version_id`	`FK`	FK

`evaluation_report2_window_project`

Doctrine entity: Evaluation\Entity\Report\Window\Project

Column	Doctrine type	Key
`window_project_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`window_id`	`FK`	FK
`project_id`	`FK`	FK
`evaluation_report_id`	`FK`	FK

`evaluation_type`

Doctrine entity: Evaluation\Entity\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`

`project_review`

Doctrine entity: Evaluation\Entity\Reviewer

Column	Doctrine type	Key
`review_id`	`integer`
`project_id`	`FK`	FK
`contact_id`	`FK`	FK
`type_id`	`FK`	FK

`project_review_contact`

Doctrine entity: Evaluation\Entity\Reviewer\Contact

Column	Doctrine type	Key
`review_contact_id`	`integer`
`handle`	`string`
`contact_id`	`FK`	FK

`project_review_type`

Doctrine entity: Evaluation\Entity\Reviewer\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`description`	`string`

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`evaluation`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[evaluation]0..*-contact 1>[contact]`
`evaluation`	`country`	Many-to-one	`0..*`	`1`	`country`	`[evaluation]0..*-country 1>[country]`
`evaluation`	`project`	Many-to-one	`0..*`	`1`	`project`	`[evaluation]0..*-project 1>[project]`
`evaluation`	`StatusRepository`	Many-to-one	`0..*`	`1`	`funding_status`	`[evaluation]0..*-status 1>[funding_status]`
`evaluation`	`type`	Many-to-one	`0..*`	`1`	`evaluation_type`	`[evaluation]0..*-type 1>[evaluation_type]`
`evaluation_feedback`	`StatusRepository`	Many-to-one	`0..*`	`1`	`funding_status`	`[evaluation_feedback]0..*-status 1>[funding_status]`
`evaluation_feedback`	`VersionRepository`	One-to-one	`0..1`	`1`	`project_version`	`[evaluation_feedback]0..1-version 1>[project_version]`
`evaluation_platform`	`evaluation`	Many-to-one	`0..*`	`1`	`evaluation`	`[evaluation_platform]0..*-evaluation 1>[evaluation]`
`evaluation_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[evaluation_platform]0..*-platform 1>[cluster_platform]`
`evaluation_report2`	`VersionRepository`	Many-to-one	`0..*`	`1`	`evaluation_report2_version`	`[evaluation_report2]0..*-version 1>[evaluation_report2_version]`
`evaluation_report2_criterion`	`reportTypes`	Many-to-many	`0..*`	`0..*`	`evaluation_report2_type`	`[evaluation_report2_criterion]0..-reportTypes 0..>[evaluation_report2_type]`
`evaluation_report2_criterion_type`	`category`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_category`	`[evaluation_report2_criterion_type]0..*-category 1>[evaluation_report2_criterion_category]`
`evaluation_report2_criterion_version`	`criterion`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion`	`[evaluation_report2_criterion_version]0..*-criterion 1>[evaluation_report2_criterion]`
`evaluation_report2_criterion_version`	`reportVersion`	Many-to-one	`0..*`	`1`	`evaluation_report2_version`	`[evaluation_report2_criterion_version]0..*-reportVersion 1>[evaluation_report2_version]`
`evaluation_report2_criterion_version`	`type`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_type`	`[evaluation_report2_criterion_version]0..*-type 1>[evaluation_report2_criterion_type]`
`evaluation_report2_criterion_version_topic`	`criterionVersion`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_version`	`[evaluation_report2_criterion_version_topic]0..*-criterionVersion 1>[evaluation_report2_criterion_version]`
`evaluation_report2_criterion_version_topic`	`topic`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_topic`	`[evaluation_report2_criterion_version_topic]0..*-topic 1>[evaluation_report2_criterion_topic]`
`evaluation_report2_project_report`	`evaluationReport`	One-to-one	`0..1`	`1`	`evaluation_report2`	`[evaluation_report2_project_report]0..1-evaluationReport 1>[evaluation_report2]`
`evaluation_report2_project_report`	`report`	One-to-one	`0..1`	`0..1`	`project_report`	`[evaluation_report2_project_report]0..1-report 0..1>[project_report]`
`evaluation_report2_project_report`	`reviewer`	One-to-one	`0..1`	`0..1`	`project_report_review`	`[evaluation_report2_project_report]0..1-reviewer 0..1>[project_report_review]`
`evaluation_report2_project_version`	`evaluationReport`	One-to-one	`0..1`	`1`	`evaluation_report2`	`[evaluation_report2_project_version]0..1-evaluationReport 1>[evaluation_report2]`
`evaluation_report2_project_version`	`reviewer`	One-to-one	`0..1`	`0..1`	`project_version_review`	`[evaluation_report2_project_version]0..1-reviewer 0..1>[project_version_review]`
`evaluation_report2_project_version`	`VersionRepository`	One-to-one	`0..1`	`0..1`	`project_version`	`[evaluation_report2_project_version]0..1-version 0..1>[project_version]`
`evaluation_report2_result`	`criterionVersion`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_version`	`[evaluation_report2_result]0..*-criterionVersion 1>[evaluation_report2_criterion_version]`
`evaluation_report2_result`	`evaluationReport`	Many-to-one	`0..*`	`1`	`evaluation_report2`	`[evaluation_report2_result]0..*-evaluationReport 1>[evaluation_report2]`
`evaluation_report2_type`	`versionType`	Many-to-one	`0..*`	`0..1`	`project_version_type`	`[evaluation_report2_type]0..*-versionType 0..1>[project_version_type]`
`evaluation_report2_version`	`reportType`	Many-to-one	`0..*`	`1`	`evaluation_report2_type`	`[evaluation_report2_version]0..*-reportType 1>[evaluation_report2_type]`
`evaluation_report2_version`	`topics`	Many-to-many	`0..*`	`0..*`	`evaluation_report2_criterion_topic`	`[evaluation_report2_version]0..-topics 0..>[evaluation_report2_criterion_topic]`
`evaluation_report2_window`	`reportVersion`	Many-to-one	`0..*`	`0..1`	`evaluation_report2_version`	`[evaluation_report2_window]0..*-reportVersion 0..1>[evaluation_report2_version]`
`evaluation_report2_window_project`	`project`	Many-to-one	`0..*`	`1`	`project`	`[evaluation_report2_window_project]0..*-project 1>[project]`
`evaluation_report2_window_project`	`window`	Many-to-one	`0..*`	`1`	`evaluation_report2_window`	`[evaluation_report2_window_project]0..*-window 1>[evaluation_report2_window]`
`evaluation_report2_window_project`	`evaluationReport`	One-to-one	`0..1`	`0..1`	`evaluation_report2`	`[evaluation_report2_window_project]0..1-evaluationReport 0..1>[evaluation_report2]`
`project_review`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_review]0..*-contact 1>[contact]`
`project_review`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_review]0..*-project 1>[project]`
`project_review`	`type`	Many-to-one	`0..*`	`1`	`project_review_type`	`[project_review]0..*-type 1>[project_review_type]`
`project_review_contact`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[project_review_contact]0..1-contact 1>[contact]`

02 November 2026