ProgressReport database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`project_report`

Doctrine entity: ProgressReport\Entity\Report

Column	Doctrine type	Key
`report_id`	`integer`
`date_created`	`datetime`
`date_final`	`datetime`
`date_submitted`	`datetime`
`contact_id`	`FK`	FK
`project_id`	`FK`	FK
`version_id`	`FK`	FK
`evaluation_report_version_id`	`FK`	FK

`project_report_criterion`

Doctrine entity: ProgressReport\Entity\Report\Criterion

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

`project_report_criterion_category`

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

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

`project_report_criterion_type`

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

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

`project_report_criterion_version`

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

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

`project_report_effort_spent`

Doctrine entity: ProgressReport\Entity\Effort\Spent

Column	Doctrine type	Key
`item_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`summary`	`text`
`effort`	`float`
`comment`	`text`
`contact_id`	`FK`	FK
`report_id`	`FK`	FK
`affiliation_id`	`FK`	FK

`project_report_email_message`

Doctrine entity: ProgressReport\Entity\Report\EmailMessage

Column	Doctrine type	Key
`project_report_email_message_id`	`integer`
`date_created`	`datetime`
`report_id`	`FK`	FK
`email_message_id`	`FK`	FK

`project_report_item`

Doctrine entity: ProgressReport\Entity\Item

Column	Doctrine type	Key
`item_id`	`integer`
`item`	`string`
`date_created`	`datetime`
`size`	`integer`
`date_updated`	`datetime`
`final`	`smallint`
`contact_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`report_id`	`FK`	FK

`project_report_item_object`

Doctrine entity: ProgressReport\Entity\ItemObject

Column	Doctrine type	Key
`object_id`	`integer`
`object`	`blob`
`item_id`	`FK`	FK

`project_report_mailing_recipient`

Doctrine entity: ProgressReport\Entity\Report\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`project_report_result`

Doctrine entity: ProgressReport\Entity\Report\Result

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

`project_report_result_affiliation_result`

Doctrine entity: ProgressReport\Entity\Report\Result\AffiliationResult

Column	Doctrine type	Key
`affiliation_result_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_changed`	`datetime`
`progress`	`smallint`
`progress_explanation`	`text`
`contract_signed_with_public_authorities`	`boolean`
`contract_signed_with_public_authorities_explanation`	`text`
`expected_market_achievements`	`text`
`costs_spent`	`float`
`effort_spent`	`float`
`costs_and_effort_spent_descripency_explanation`	`text`
`report_id`	`FK`	FK
`affiliation_id`	`FK`	FK

`project_report_result_deliverable_result`

Doctrine entity: ProgressReport\Entity\Report\Result\DeliverableResult

Column	Doctrine type	Key
`deliverable_result_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_changed`	`datetime`
`delivered`	`boolean`
`actual_date_due`	`date`
`comment`	`text`
`report_id`	`FK`	FK
`workpackage_deliverable_id`	`FK`	FK

`project_report_result_milestone_result`

Doctrine entity: ProgressReport\Entity\Report\Result\MilestoneResult

Column	Doctrine type	Key
`milestone_result_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_changed`	`datetime`
`completed`	`boolean`
`date_completed`	`date`
`comment`	`text`
`report_id`	`FK`	FK
`milestone_id`	`FK`	FK

`project_report_review`

Doctrine entity: ProgressReport\Entity\Reviewer

Column	Doctrine type	Key
`review_id`	`integer`
`is_primary`	`boolean`
`project_report_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_report_type`

Doctrine entity: ProgressReport\Entity\Report\Type

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

`project_report_version`

Doctrine entity: ProgressReport\Entity\Report\Version

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

`project_report_window`

Doctrine entity: ProgressReport\Entity\Window

Column	Doctrine type	Key
`window_id`	`integer`
`window`	`string`
`date_year`	`smallint`
`date_semester`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_start`	`datetime`
`date_reference`	`date`
`date_end`	`datetime`
`months_since_project_start`	`integer`
`spent_costs_and_effort_reporting`	`smallint`
`version_id`	`FK`	FK

`project_report_window_project`

Doctrine entity: ProgressReport\Entity\Window\Project

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

`project_report_workpackage_description`

Doctrine entity: ProgressReport\Entity\Workpackage\Description

Column	Doctrine type	Key
`workpackage_description_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`description`	`text`
`contact_id`	`FK`	FK
`report_id`	`FK`	FK
`workpackage_id`	`FK`	FK

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`project_report`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report]0..*-contact 1>[contact]`
`project_report`	`evaluationReportVersion`	Many-to-one	`0..*`	`0..1`	`evaluation_report2_version`	`[project_report]0..*-evaluationReportVersion 0..1>[evaluation_report2_version]`
`project_report`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_report]0..*-project 1>[project]`
`project_report`	`reportVersion`	Many-to-one	`0..*`	`0..1`	`project_report_version`	`[project_report]0..*-reportVersion 0..1>[project_report_version]`
`project_report_criterion`	`achievementCategory`	Many-to-one	`0..*`	`0..1`	`project_achievement_category`	`[project_report_criterion]0..*-achievementCategory 0..1>[project_achievement_category]`
`project_report_criterion`	`reportTypes`	Many-to-many	`0..*`	`0..*`	`project_report_type`	`[project_report_criterion]0..-reportTypes 0..>[project_report_type]`
`project_report_criterion_type`	`category`	Many-to-one	`0..*`	`1`	`project_report_criterion_category`	`[project_report_criterion_type]0..*-category 1>[project_report_criterion_category]`
`project_report_criterion_version`	`criterion`	Many-to-one	`0..*`	`1`	`project_report_criterion`	`[project_report_criterion_version]0..*-criterion 1>[project_report_criterion]`
`project_report_criterion_version`	`reportVersion`	Many-to-one	`0..*`	`1`	`project_report_version`	`[project_report_criterion_version]0..*-reportVersion 1>[project_report_version]`
`project_report_criterion_version`	`type`	Many-to-one	`0..*`	`1`	`project_report_criterion_type`	`[project_report_criterion_version]0..*-type 1>[project_report_criterion_type]`
`project_report_effort_spent`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_report_effort_spent]0..*-affiliation 1>[affiliation]`
`project_report_effort_spent`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_effort_spent]0..*-contact 1>[contact]`
`project_report_effort_spent`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_effort_spent]0..*-report 1>[project_report]`
`project_report_email_message`	`emailMessage`	Many-to-one	`0..*`	`1`	`email_message`	`[project_report_email_message]0..*-emailMessage 1>[email_message]`
`project_report_email_message`	`progressReport`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_email_message]0..*-progressReport 1>[project_report]`
`project_report_item`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_item]0..*-contact 1>[contact]`
`project_report_item`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_report_item]0..*-contentType 1>[contenttype]`
`project_report_item`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_item]0..*-report 1>[project_report]`
`project_report_item_object`	`item`	Many-to-one	`0..*`	`1`	`project_report_item`	`[project_report_item_object]0..*-item 1>[project_report_item]`
`project_report_result`	`criterionVersion`	Many-to-one	`0..*`	`1`	`project_report_criterion_version`	`[project_report_result]0..*-criterionVersion 1>[project_report_criterion_version]`
`project_report_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result]0..*-report 1>[project_report]`
`project_report_result_affiliation_result`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_report_result_affiliation_result]0..*-affiliation 1>[affiliation]`
`project_report_result_affiliation_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result_affiliation_result]0..*-report 1>[project_report]`
`project_report_result_deliverable_result`	`deliverable`	Many-to-one	`0..*`	`1`	`workpackage_deliverable`	`[project_report_result_deliverable_result]0..*-deliverable 1>[workpackage_deliverable]`
`project_report_result_deliverable_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result_deliverable_result]0..*-report 1>[project_report]`
`project_report_result_milestone_result`	`milestone`	Many-to-one	`0..*`	`1`	`project_milestone`	`[project_report_result_milestone_result]0..*-milestone 1>[project_milestone]`
`project_report_result_milestone_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result_milestone_result]0..*-report 1>[project_report]`
`project_report_review`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_review]0..*-contact 1>[contact]`
`project_report_review`	`projectReport`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_review]0..*-projectReport 1>[project_report]`
`project_report_version`	`reportType`	Many-to-one	`0..*`	`1`	`project_report_type`	`[project_report_version]0..*-reportType 1>[project_report_type]`
`project_report_window`	`reportVersion`	Many-to-one	`0..*`	`0..1`	`project_report_version`	`[project_report_window]0..*-reportVersion 0..1>[project_report_version]`
`project_report_window_project`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_report_window_project]0..*-project 1>[project]`
`project_report_window_project`	`window`	Many-to-one	`0..*`	`1`	`project_report_window`	`[project_report_window_project]0..*-window 1>[project_report_window]`
`project_report_window_project`	`report`	One-to-one	`0..1`	`0..1`	`project_report`	`[project_report_window_project]0..1-report 0..1>[project_report]`
`project_report_workpackage_description`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_workpackage_description]0..*-contact 1>[contact]`
`project_report_workpackage_description`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_workpackage_description]0..*-report 1>[project_report]`
`project_report_workpackage_description`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[project_report_workpackage_description]0..*-workpackage 1>[workpackage]`

02 November 2026