Project database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`costs`

Doctrine entity: Project\Entity\Cost\Cost

Column	Doctrine type	Key
`costs_id`	`integer`
`costs`	`decimal`
`date_start`	`date`
`date_end`	`date`
`affiliation_id`	`FK`	FK

`costs_version`

Doctrine entity: Project\Entity\Cost\Version

Column	Doctrine type	Key
`costs_id`	`integer`
`costs`	`decimal`
`date_start`	`date`
`date_end`	`date`
`affiliation_version_id`	`FK`	FK

`effort`

Doctrine entity: Project\Entity\Effort\Effort

Column	Doctrine type	Key
`effort_id`	`integer`
`effort`	`decimal`
`date_start`	`date`
`date_end`	`date`
`affiliation_id`	`FK`	FK
`workpackage_id`	`FK`	FK

`effort_spent`

Doctrine entity: Project\Entity\Effort\Spent

Column	Doctrine type	Key
`effort_id`	`integer`
`effort`	`decimal`
`date_start`	`date`
`date_end`	`date`
`affiliation_id`	`FK`	FK
`workpackage_id`	`FK`	FK

`effort_version`

Doctrine entity: Project\Entity\Effort\Version

Column	Doctrine type	Key
`effort_id`	`integer`
`effort`	`decimal`
`date_start`	`date`
`date_end`	`date`
`affiliation_version_id`	`FK`	FK
`workpackage_id`	`FK`	FK

`FundingRepository`

Doctrine entity: Project\Entity\Funding\Funding

Column	Doctrine type	Key
`funding_id`	`integer`
`date_start`	`date`
`date_end`	`date`
`year`	`smallint`
`date_updated`	`date`
`source_id`	`FK`	FK
`status_id`	`FK`	FK
`affiliation_id`	`FK`	FK

`funding_funded`

Doctrine entity: Project\Entity\Funding\Funded

Column	Doctrine type	Key
`funded_id`	`integer`
`funding_eu`	`decimal`
`funding_national`	`decimal`
`affiliation_id`	`FK`	FK

`funding_source`

Doctrine entity: Project\Entity\Funding\Source

Column	Doctrine type	Key
`source_id`	`integer`
`source`	`string`
`description`	`string`

`funding_status`

Doctrine entity: Project\Entity\Funding\Status

Column	Doctrine type	Key
`status_id`	`integer`
`cluster_code`	`string`
`code`	`string`
`StatusRepository`	`string`
`color`	`string`
`status_funding`	`string`
`is_evaluation`	`boolean`
`status_evaluation`	`string`
`sequence`	`smallint`

`funding_version`

Doctrine entity: Project\Entity\Funding\Version

Column	Doctrine type	Key
`costs_id`	`integer`
`funding_eu`	`decimal`
`funding_national`	`decimal`
`affiliation_version_id`	`FK`	FK

`invite`

Doctrine entity: Project\Entity\Invite

Column	Doctrine type	Key
`invite_id`	`integer`
`date_create`	`datetime`
`invite`	`string`
`date_expire`	`datetime`
`date_taken`	`datetime`
`deeplink_id`	`integer`
`contact_id`	`FK`	FK
`invited_contact_id`	`FK`	FK
`project_id`	`FK`	FK

`keyword`

Doctrine entity: Project\Entity\Keyword

Column	Doctrine type	Key
`keyword_id`	`integer`
`keyword`	`string`
`docref`	`string`

`project`

Doctrine entity: Project\Entity\Project

Column	Doctrine type	Key
`project_id`	`integer`
`project_nr`	`string`
`project`	`string`
`docref`	`string`
`title`	`string`
`date_start`	`date`
`date_pca_signed`	`date`
`date_end`	`date`
`date_start_actual`	`date`
`date_end_actual`	`date`
`kick_off_date`	`date`
`date_start_expected`	`date`
`date_created`	`datetime`
`exclude_from_export`	`boolean`
`description`	`text`
`roadmap`	`text`
`short_description`	`string`
`summary`	`text`
`html`	`text`
`programcall_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_achievement`

Doctrine entity: Project\Entity\Achievement

Column	Doctrine type	Key
`achievement_id`	`integer`
`achievement`	`string`
`docref`	`string`
`description`	`text`
`author`	`text`
`research_areas`	`text`
`impact`	`text`
`impact_quantification`	`string`
`proposed_candidate`	`smallint`
`candidate`	`smallint`
`StatusRepository`	`smallint`
`public`	`smallint`
`date_created`	`datetime`
`sequence`	`integer`
`date_updated`	`datetime`
`sustainableDevelopmentGoal`	`smallint`
`sustainability_impact`	`text`
`contact_id`	`FK`	FK
`type_id`	`FK`	FK
`project_id`	`FK`	FK

`project_achievement_category`

Doctrine entity: Project\Entity\Achievement\Category

Column	Doctrine type	Key
`category_id`	`integer`
`category`	`string`
`impact_explanation`	`text`
`exploitable`	`smallint`
`bulk_uploadable`	`smallint`

`project_achievement_document`

Doctrine entity: Project\Entity\Achievement\Document

Column	Doctrine type	Key
`document_id`	`integer`
`size`	`integer`
`document`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`achievement_id`	`FK`	FK
`contenttype_id`	`FK`	FK

`project_achievement_document_object`

Doctrine entity: Project\Entity\Achievement\DocumentObject

Column	Doctrine type	Key
`document_object_id`	`integer`
`object`	`blob`
`document_id`	`FK`	FK

`project_achievement_exploitable_result`

Doctrine entity: Project\Entity\Achievement\ExploitableResult

Column	Doctrine type	Key
`exploitable_result_id`	`integer`
`publication_date`	`date`
`email`	`text`
`technical_features`	`text`
`integration_constraints`	`text`
`intended_users`	`text`
`reuse_conditions`	`text`
`date_approved`	`datetime`
`achievement_id`	`FK`	FK
`approve_contact_id`	`FK`	FK

`project_achievement_exploitable_result_image`

Doctrine entity: Project\Entity\Achievement\ExploitableResult\Image

Column	Doctrine type	Key
`image_id`	`integer`
`image`	`blob`
`date_created`	`datetime`
`type`	`smallint`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`exploitable_result_id`	`FK`	FK

`project_achievement_link`

Doctrine entity: Project\Entity\Achievement\Link

Column	Doctrine type	Key
`link_id`	`integer`
`url`	`string`
`label`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`achievement_id`	`FK`	FK

`project_achievement_type`

Doctrine entity: Project\Entity\Achievement\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`description`	`text`
`impact_quantification_explanation`	`text`
`sequence`	`integer`
`category_id`	`FK`	FK

`project_action`

Doctrine entity: Project\Entity\Action

Column	Doctrine type	Key
`action_id`	`integer`
`number`	`integer`
`action`	`string`
`sequence`	`integer`
`remarks`	`text`
`date_created`	`datetime`
`date_update`	`datetime`
`deadline`	`string`
`obligation`	`smallint`
`StatusRepository`	`smallint`
`status_date`	`datetime`
`checked`	`smallint`
`date_checked`	`datetime`
`date_closed`	`datetime`
`show_in_evaluation_report`	`boolean`
`type_id`	`FK`	FK
`project_id`	`FK`	FK
`created_contact_id`	`FK`	FK
`status_contact_id`	`FK`	FK
`checked_contact_id`	`FK`	FK
`closed_contact_id`	`FK`	FK
`criterion_version_id`	`FK`	FK
`project_calendar_id`	`FK`	FK
`report_id`	`FK`	FK
`version_id`	`FK`	FK

`project_action_changelog`

Doctrine entity: Project\Entity\Action\Changelog

Column	Doctrine type	Key
`changelog_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`type`	`smallint`
`source`	`smallint`
`changelog`	`text`
`contact_id`	`FK`	FK
`action_id`	`FK`	FK

`project_action_comment`

Doctrine entity: Project\Entity\Action\Comment

Column	Doctrine type	Key
`comment_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`is_reviewer_comment`	`boolean`
`comment`	`text`
`contact_id`	`FK`	FK
`action_id`	`FK`	FK

`project_action_type`

Doctrine entity: Project\Entity\Action\Type

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

`project_area`

Doctrine entity: Project\Entity\Area

Column	Doctrine type	Key
`area_id`	`integer`
`code`	`string`
`label`	`string`
`type`	`smallint`
`date_created`	`datetime`
`date_update`	`datetime`
`left`	`integer`
`level`	`integer`
`right`	`integer`
`tree_root`	`FK`	FK
`parent_id`	`FK`	FK

`project_award`

Doctrine entity: Project\Entity\Award

Column	Doctrine type	Key
`award_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`year`	`smallint`
`position`	`smallint`
`sub_type`	`string`
`motivation`	`text`
`project_id`	`FK`	FK
`type_id`	`FK`	FK

`project_award_type`

Doctrine entity: Project\Entity\Award\Type

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

`project_booth`

Doctrine entity: Project\Entity\Booth

Column	Doctrine type	Key
`project_booth_id`	`integer`
`booth_id`	`FK`	FK
`project_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_calendar`

Doctrine entity: Project\Entity\Calendar\Calendar

Column	Doctrine type	Key
`project_calendar_id`	`integer`
`sequence`	`integer`
`calendar_id`	`FK`	FK
`project_id`	`FK`	FK

`project_calendar_review`

Doctrine entity: Project\Entity\Calendar\Reviewer

Column	Doctrine type	Key
`review_id`	`integer`
`project_calendar_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_challenge`

Doctrine entity: Project\Entity\Project\Challenge

Column	Doctrine type	Key
`project_challenge_id`	`integer`
`challenge_id`	`FK`	FK
`project_id`	`FK`	FK

`project_change_request_mailing_recipient`

Doctrine entity: Project\Entity\ChangeRequest\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`
`filterOnActiveCountry`	`boolean`
`optin_id`	`FK`	FK
`role_id`	`FK`	FK

`project_change_request_process_email_message`

Doctrine entity: Project\Entity\ChangeRequest\Process\EmailMessage

Column	Doctrine type	Key
`project_change_request_process_email_message_id`	`integer`
`date_created`	`datetime`
`action`	`string`
`process_id`	`FK`	FK
`email_message_id`	`FK`	FK

`project_changelog`

Doctrine entity: Project\Entity\Changelog

Column	Doctrine type	Key
`changelog_id`	`integer`
`type`	`smallint`
`source`	`smallint`
`date_created`	`datetime`
`last_update`	`datetime`
`changelog`	`text`
`project_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_changerequest_cost_change`

Doctrine entity: Project\Entity\ChangeRequest\CostChange

Column	Doctrine type	Key
`cost_change_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`reason`	`text`
`impact`	`text`
`solution`	`text`
`contact_id`	`FK`	FK
`process_id`	`FK`	FK

`project_changerequest_country`

Doctrine entity: Project\Entity\ChangeRequest\Country

Column	Doctrine type	Key
`changerequest_country_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`type`	`smallint`
`reason`	`text`
`impact`	`text`
`solution`	`text`
`contact_id`	`FK`	FK
`process_id`	`FK`	FK
`country_id`	`FK`	FK

`project_changerequest_process`

Doctrine entity: Project\Entity\ChangeRequest\Process

Column	Doctrine type	Key
`process_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`date_submitted`	`date`
`mode`	`smallint`
`type`	`smallint`
`reason`	`text`
`amount_of_milestones`	`smallint`
`amount_of_deliverables`	`smallint`
`impact`	`text`
`information`	`text`
`new_ambition`	`text`
`new_innovation`	`text`
`new_impact_on_the_market`	`text`
`why_consortium_remain_legitimate`	`text`
`feedback`	`text`
`contact_id`	`FK`	FK
`project_id`	`FK`	FK

`project_cluster`

Doctrine entity: Project\Entity\Project\Cluster

Column	Doctrine type	Key
`project_cluster_id`	`integer`
`type`	`integer`
`cluster_id`	`FK`	FK
`project_id`	`FK`	FK

`project_contract`

Doctrine entity: Project\Entity\Contract

Column	Doctrine type	Key
`contract_id`	`integer`
`date_created`	`datetime`
`date_update`	`datetime`
`date_start`	`date`
`date_end`	`date`
`allow_corrections`	`boolean`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`country_id`	`FK`	FK
`project_id`	`FK`	FK
`currency_id`	`FK`	FK

`project_contract_costs`

Doctrine entity: Project\Entity\Contract\Cost

Column	Doctrine type	Key
`costs_id`	`integer`
`costs`	`decimal`
`date_start`	`date`
`date_end`	`date`
`affiliation_id`	`FK`	FK

`project_contract_costs_version`

Doctrine entity: Project\Entity\Contract\CostVersion

Column	Doctrine type	Key
`costs_id`	`integer`
`costs`	`decimal`
`date_start`	`date`
`date_end`	`date`
`affiliation_contract_version_id`	`FK`	FK

`project_contract_document`

Doctrine entity: Project\Entity\Contract\Document

Column	Doctrine type	Key
`document_id`	`integer`
`document`	`string`
`date_created`	`datetime`
`size`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`contract_id`	`FK`	FK

`project_contract_document_object`

Doctrine entity: Project\Entity\Contract\DocumentObject

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

`project_contract_platform`

Doctrine entity: Project\Entity\Contract\Platform

Column	Doctrine type	Key
`project_contract_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`contract_id`	`FK`	FK

`project_contract_version`

Doctrine entity: Project\Entity\Contract\Version

Column	Doctrine type	Key
`version_id`	`integer`
`date_created`	`datetime`
`approved`	`smallint`
`date_start`	`date`
`date_end`	`date`
`contract_id`	`FK`	FK

`project_contract_version_document`

Doctrine entity: Project\Entity\Contract\VersionDocument

Column	Doctrine type	Key
`document_id`	`integer`
`size`	`integer`
`document`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`version_id`	`FK`	FK
`contenttype_id`	`FK`	FK

`project_contract_version_document_object`

Doctrine entity: Project\Entity\Contract\VersionDocumentObject

Column	Doctrine type	Key
`document_object_id`	`integer`
`object`	`blob`
`document_id`	`FK`	FK

`project_contract_version_platform`

Doctrine entity: Project\Entity\Contract\Version\Platform

Column	Doctrine type	Key
`project_version_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`version_id`	`FK`	FK

`project_description`

Doctrine entity: Project\Entity\Description\Description

Column	Doctrine type	Key
`description_id`	`integer`
`description`	`string`
`content`	`text`
`abstract`	`text`
`date_created`	`datetime`
`hidden`	`smallint`
`project_id`	`FK`	FK

`project_description_tree`

Doctrine entity: Project\Entity\Description\Tree

Column	Doctrine type	Key
`tree_id`	`integer`
`sequence`	`integer`
`child_project_description_id`	`FK`	FK
`parent_project_description_id`	`FK`	FK

`project_document`

Doctrine entity: Project\Entity\Document\Document

Column	Doctrine type	Key
`document_id`	`integer`
`document`	`string`
`date_created`	`datetime`
`size`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`contact_id`	`FK`	FK
`project_id`	`FK`	FK
`type_id`	`FK`	FK

`project_document_object`

Doctrine entity: Project\Entity\Document\DocumentObject

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

`project_document_type`

Doctrine entity: Project\Entity\Document\Type

Column	Doctrine type	Key
`type_id`	`integer`
`name`	`string`
`document_type`	`smallint`
`view`	`boolean`

`project_event`

Doctrine entity: Project\Entity\Event

Column	Doctrine type	Key
`event_id`	`integer`
`name`	`string`
`description`	`string`
`date_created`	`datetime`
`date_update`	`datetime`
`date_start`	`date`
`date_end`	`date`
`type_id`	`FK`	FK

`project_event_type`

Doctrine entity: Project\Entity\Event\Type

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

`project_fee`

Doctrine entity: Project\Entity\Fee

Column	Doctrine type	Key
`fee_id`	`integer`
`year`	`integer`
`percentage`	`decimal`
`contribution`	`decimal`

`project_help`

Doctrine entity: Project\Entity\Help

Column	Doctrine type	Key
`help_id`	`integer`
`title`	`string`
`key`	`string`
`link_title`	`string`
`content`	`text`
`docref`	`string`
`hide_from_navigation`	`smallint`

`project_help_faq`

Doctrine entity: Project\Entity\HelpFaq

Column	Doctrine type	Key
`faq_id`	`integer`
`question`	`string`
`answer`	`text`
`docref`	`string`

`project_help_tree`

Doctrine entity: Project\Entity\HelpTree

Column	Doctrine type	Key
`tree_id`	`integer`
`sequence`	`integer`
`child_help_id`	`FK`	FK
`parent_help_id`	`FK`	FK

`project_image`

Doctrine entity: Project\Entity\Image

Column	Doctrine type	Key
`image_id`	`integer`
`image`	`string`
`type`	`smallint`
`project_id`	`FK`	FK

`project_log`

Doctrine entity: Project\Entity\Log

Column	Doctrine type	Key
`log_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`log`	`text`
`project_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_logo`

Doctrine entity: Project\Entity\Logo

Column	Doctrine type	Key
`logo_id`	`integer`
`logo`	`blob`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`project_id`	`FK`	FK

`project_milestone`

Doctrine entity: Project\Entity\Milestone

Column	Doctrine type	Key
`milestone_id`	`integer`
`number`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_due`	`date`
`description`	`text`
`project_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_milestone_document`

Doctrine entity: Project\Entity\Milestone\Document

Column	Doctrine type	Key
`document_id`	`integer`
`filename`	`string`
`size`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`milestone_id`	`FK`	FK

`project_milestone_document_object`

Doctrine entity: Project\Entity\Milestone\DocumentObject

Column	Doctrine type	Key
`document_object_id`	`integer`
`object`	`blob`
`document_id`	`FK`	FK

`project_pca`

Doctrine entity: Project\Entity\Pca

Column	Doctrine type	Key
`pca_id`	`integer`
`filename`	`string`
`size`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_deleted`	`datetime`
`date_signed`	`date`
`contenttype_id`	`FK`	FK
`project_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_pca_object`

Doctrine entity: Project\Entity\PcaObject

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

`project_platform`

Doctrine entity: Project\Entity\Project\Platform

Column	Doctrine type	Key
`project_platform_id`	`integer`
`review_information`	`json`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`project_id`	`FK`	FK

`project_project_area`

Doctrine entity: Project\Entity\Project\Area

Column	Doctrine type	Key
`project_area_id`	`integer`
`sequence`	`integer`
`area_id`	`FK`	FK
`project_id`	`FK`	FK

`project_project_mailing_recipient`

Doctrine entity: Project\Entity\Project\Mailing\Recipient

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

`project_project_role`

Doctrine entity: Project\Entity\Project\Role

Column	Doctrine type	Key
`project_project_role_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_end`	`datetime`
`comment`	`text`
`project_id`	`FK`	FK
`contact_id`	`FK`	FK
`role_id`	`FK`	FK

`project_rationale`

Doctrine entity: Project\Entity\Rationale

Column	Doctrine type	Key
`project_country_id`	`integer`
`rationale`	`text`
`has_contacted_funder`	`smallint`
`contacted_funder_feedback`	`text`
`date_national_application_expected`	`string`
`date_national_application_submitted`	`date`
`date_expected_funding_decision`	`string`
`project_id`	`FK`	FK
`country_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_rationale_platform`

Doctrine entity: Project\Entity\Rationale\Platform

Column	Doctrine type	Key
`project_rationale_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`project_country_id`	`FK`	FK

`project_role`

Doctrine entity: Project\Entity\Role

Column	Doctrine type	Key
`role_id`	`integer`
`type`	`string`
`title`	`string`
`description`	`text`
`contact_id`	`FK`	FK

`project_selection`

Doctrine entity: Project\Entity\Selection

Column	Doctrine type	Key
`selection_id`	`integer`
`selection`	`string`
`description`	`text`
`title`	`string`
`introduction_text`	`text`
`tag`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`sql_query`	`text`
`contact_id`	`FK`	FK

`project_version`

Doctrine entity: Project\Entity\Version\Version

Column	Doctrine type	Key
`version_id`	`integer`
`date_created`	`datetime`
`date_build_finished`	`datetime`
`date_submitted`	`datetime`
`date_reviewed`	`datetime`
`date_cancelled`	`datetime`
`approved`	`smallint`
`date_start`	`date`
`date_end`	`date`
`contact_id`	`FK`	FK
`project_id`	`FK`	FK
`type_id`	`FK`	FK
`process_id`	`FK`	FK
`evaluation_report_version_id`	`FK`	FK

`project_version_contact`

Doctrine entity: Project\Entity\Version\Contact

Column	Doctrine type	Key
`version_contact_id`	`integer`
`version_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_version_email_message`

Doctrine entity: Project\Entity\Version\EmailMessage

Column	Doctrine type	Key
`project_version_email_message_id`	`integer`
`date_created`	`datetime`
`version_id`	`FK`	FK
`email_message_id`	`FK`	FK

`project_version_mailing_recipient`

Doctrine entity: Project\Entity\Version\Mailing\Recipient

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

`project_version_platform`

Doctrine entity: Project\Entity\Version\Platform

Column	Doctrine type	Key
`project_version_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`version_id`	`FK`	FK

`project_version_review`

Doctrine entity: Project\Entity\Version\Reviewer

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

`project_version_type`

Doctrine entity: Project\Entity\Version\Type

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

`project_web`

Doctrine entity: Project\Entity\Web

Column	Doctrine type	Key
`web_id`	`integer`
`web`	`string`
`label`	`string`
`main`	`smallint`
`project_id`	`FK`	FK

`project_workpackage_contact`

Doctrine entity: Project\Entity\Workpackage\Contact

Column	Doctrine type	Key
`workpackage_contact_id`	`integer`
`version_id`	`FK`	FK
`workpackage_id`	`FK`	FK
`contact_id`	`FK`	FK

`result`

Doctrine entity: Project\Entity\Result\Result

Column	Doctrine type	Key
`result_id`	`integer`
`result`	`string`
`docref`	`string`
`date_created`	`datetime`
`date_released`	`date`
`abstract`	`text`
`html`	`text`
`css`	`text`
`size`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`contact_id`	`FK`	FK
`project_id`	`FK`	FK
`type_id`	`FK`	FK
`image_id`	`FK`	FK

`result_image`

Doctrine entity: Project\Entity\Result\Image

Column	Doctrine type	Key
`image_id`	`integer`
`image`	`blob`
`date_created`	`datetime`
`type`	`smallint`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`result_id`	`FK`	FK

`result_object`

Doctrine entity: Project\Entity\Result\ResultObject

Column	Doctrine type	Key
`result_object_id`	`integer`
`object`	`blob`
`result_id`	`FK`	FK

`result_type`

Doctrine entity: Project\Entity\Result\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`title`	`string`
`description`	`text`
`sequence`	`smallint`
`list_type`	`smallint`
`category_id`	`FK`	FK

`result_type_category`

Doctrine entity: Project\Entity\Result\Type\Category

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

`version_document`

Doctrine entity: Project\Entity\Version\Document

Column	Doctrine type	Key
`document_id`	`integer`
`size`	`integer`
`document`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_signed`	`date`
`version_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`type_id`	`FK`	FK
`docusign_envelope_id`	`FK`	FK

`version_document_object`

Doctrine entity: Project\Entity\Version\DocumentObject

Column	Doctrine type	Key
`document_object_id`	`integer`
`object`	`blob`
`document_id`	`FK`	FK

`workpackage`

Doctrine entity: Project\Entity\Workpackage\Workpackage

Column	Doctrine type	Key
`workpackage_id`	`integer`
`sequence`	`smallint`
`workpackage`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_end`	`datetime`
`date_time_frame_start`	`date`
`date_time_frame_end`	`date`
`contact_id`	`FK`	FK
`project_id`	`FK`	FK

`workpackage_deliverable`

Doctrine entity: Project\Entity\Workpackage\Deliverable

Column	Doctrine type	Key
`deliverable_id`	`integer`
`number`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_deleted`	`datetime`
`date_due`	`date`
`description`	`text`
`access`	`smallint`
`workpackage_id`	`FK`	FK
`type_id`	`FK`	FK
`contact_id`	`FK`	FK

`workpackage_deliverable_document`

Doctrine entity: Project\Entity\Workpackage\Deliverable\Document

Column	Doctrine type	Key
`document_id`	`integer`
`filename`	`string`
`size`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`deliverable_id`	`FK`	FK

`workpackage_deliverable_document_object`

Doctrine entity: Project\Entity\Workpackage\Deliverable\DocumentObject

Column	Doctrine type	Key
`document_object_id`	`integer`
`object`	`blob`
`document_id`	`FK`	FK

`workpackage_deliverable_type`

Doctrine entity: Project\Entity\Workpackage\Deliverable\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`

`workpackage_description`

Doctrine entity: Project\Entity\Workpackage\Description

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

`workpackage_document`

Doctrine entity: Project\Entity\Workpackage\Document

Column	Doctrine type	Key
`document_id`	`integer`
`document`	`string`
`size`	`integer`
`public`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`workpackage_id`	`FK`	FK

`workpackage_document_object`

Doctrine entity: Project\Entity\Workpackage\DocumentObject

Column	Doctrine type	Key
`document_object_id`	`integer`
`object`	`blob`
`document_id`	`FK`	FK

`workpackage_platform`

Doctrine entity: Project\Entity\Workpackage\Platform

Column	Doctrine type	Key
`project_workpackage_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`workpackage_id`	`FK`	FK

`workpackage_task`

Doctrine entity: Project\Entity\Workpackage\Task

Column	Doctrine type	Key
`task_id`	`integer`
`number`	`smallint`
`task`	`string`
`description`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_deleted`	`datetime`
`workpackage_id`	`FK`	FK
`contact_id`	`FK`	FK

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`costs`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[costs]0..*-affiliation 1>[affiliation]`
`costs_version`	`affiliationVersion`	Many-to-one	`0..*`	`1`	`affiliation_version`	`[costs_version]0..*-affiliationVersion 1>[affiliation_version]`
`effort`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[effort]0..*-affiliation 1>[affiliation]`
`effort`	`workpackage`	Many-to-one	`0..*`	`0..1`	`workpackage`	`[effort]0..*-workpackage 0..1>[workpackage]`
`effort_spent`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[effort_spent]0..*-affiliation 1>[affiliation]`
`effort_spent`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[effort_spent]0..*-workpackage 1>[workpackage]`
`effort_version`	`affiliationVersion`	Many-to-one	`0..*`	`1`	`affiliation_version`	`[effort_version]0..*-affiliationVersion 1>[affiliation_version]`
`effort_version`	`workpackage`	Many-to-one	`0..*`	`0..1`	`workpackage`	`[effort_version]0..*-workpackage 0..1>[workpackage]`
`FundingRepository`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[funding]0..*-affiliation 1>[affiliation]`
`FundingRepository`	`source`	Many-to-one	`0..*`	`1`	`funding_source`	`[funding]0..*-source 1>[funding_source]`
`FundingRepository`	`StatusRepository`	Many-to-one	`0..*`	`1`	`funding_status`	`[funding]0..*-status 1>[funding_status]`
`funding_funded`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[funding_funded]0..*-affiliation 1>[affiliation]`
`funding_version`	`affiliationVersion`	Many-to-one	`0..*`	`1`	`affiliation_version`	`[funding_version]0..*-affiliationVersion 1>[affiliation_version]`
`invite`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invite]0..*-contact 1>[contact]`
`invite`	`invitedContact`	Many-to-one	`0..*`	`0..1`	`contact`	`[invite]0..*-invitedContact 0..1>[contact]`
`invite`	`project`	Many-to-one	`0..*`	`1`	`project`	`[invite]0..*-project 1>[project]`
`project`	`call`	Many-to-one	`0..*`	`1`	`programcall`	`[project]0..*-call 1>[programcall]`
`project`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project]0..*-contact 1>[contact]`
`project`	`keyword`	Many-to-many	`0..*`	`0..*`	`keyword`	`[project]0..-keyword 0..>[keyword]`
`project`	`proxyCall`	Many-to-many	`0..*`	`0..*`	`programcall`	`[project]0..-proxyCall 0..>[programcall]`
`project`	`proxyContact`	Many-to-many	`0..*`	`0..*`	`contact`	`[project]0..-proxyContact 0..>[contact]`
`project_achievement`	`affiliation`	Many-to-many	`0..*`	`0..*`	`affiliation`	`[project_achievement]0..-affiliation 0..>[affiliation]`
`project_achievement`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_achievement]0..*-contact 1>[contact]`
`project_achievement`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_achievement]0..*-project 1>[project]`
`project_achievement`	`type`	Many-to-one	`0..*`	`0..1`	`project_achievement_type`	`[project_achievement]0..*-type 0..1>[project_achievement_type]`
`project_achievement_document`	`achievement`	Many-to-one	`0..*`	`1`	`project_achievement`	`[project_achievement_document]0..*-achievement 1>[project_achievement]`
`project_achievement_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_achievement_document]0..*-contentType 1>[contenttype]`
`project_achievement_document_object`	`document`	One-to-one	`0..1`	`1`	`project_achievement_document`	`[project_achievement_document_object]0..1-document 1>[project_achievement_document]`
`project_achievement_exploitable_result`	`approver`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_achievement_exploitable_result]0..*-approver 0..1>[contact]`
`project_achievement_exploitable_result`	`achievement`	One-to-one	`0..1`	`1`	`project_achievement`	`[project_achievement_exploitable_result]0..1-achievement 1>[project_achievement]`
`project_achievement_exploitable_result_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_achievement_exploitable_result_image]0..*-contentType 1>[contenttype]`
`project_achievement_exploitable_result_image`	`exploitableResult`	Many-to-one	`0..*`	`1`	`project_achievement_exploitable_result`	`[project_achievement_exploitable_result_image]0..*-exploitableResult 1>[project_achievement_exploitable_result]`
`project_achievement_link`	`achievement`	Many-to-one	`0..*`	`1`	`project_achievement`	`[project_achievement_link]0..*-achievement 1>[project_achievement]`
`project_achievement_type`	`category`	Many-to-one	`0..*`	`1`	`project_achievement_category`	`[project_achievement_type]0..*-category 1>[project_achievement_category]`
`project_action`	`checkedContact`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_action]0..*-checkedContact 0..1>[contact]`
`project_action`	`closedContact`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_action]0..*-closedContact 0..1>[contact]`
`project_action`	`createdContact`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_action]0..*-createdContact 0..1>[contact]`
`project_action`	`evaluationCriterionVersion`	Many-to-one	`0..*`	`0..1`	`evaluation_report2_criterion_version`	`[project_action]0..*-evaluationCriterionVersion 0..1>[evaluation_report2_criterion_version]`
`project_action`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_action]0..*-project 1>[project]`
`project_action`	`projectCalendar`	Many-to-one	`0..*`	`0..1`	`project_calendar`	`[project_action]0..*-projectCalendar 0..1>[project_calendar]`
`project_action`	`report`	Many-to-one	`0..*`	`0..1`	`project_report`	`[project_action]0..*-report 0..1>[project_report]`
`project_action`	`statusContact`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_action]0..*-statusContact 0..1>[contact]`
`project_action`	`type`	Many-to-one	`0..*`	`1`	`project_action_type`	`[project_action]0..*-type 1>[project_action_type]`
`project_action`	`VersionRepository`	Many-to-one	`0..*`	`0..1`	`project_version`	`[project_action]0..*-version 0..1>[project_version]`
`project_action_changelog`	`action`	Many-to-one	`0..*`	`1`	`project_action`	`[project_action_changelog]0..*-action 1>[project_action]`
`project_action_changelog`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_action_changelog]0..*-contact 1>[contact]`
`project_action_comment`	`action`	Many-to-one	`0..*`	`1`	`project_action`	`[project_action_comment]0..*-action 1>[project_action]`
`project_action_comment`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_action_comment]0..*-contact 1>[contact]`
`project_area`	`parent`	Many-to-one	`0..*`	`0..1`	`project_area`	`[project_area]0..*-parent 0..1>[project_area]`
`project_area`	`root`	Many-to-one	`0..*`	`0..1`	`project_area`	`[project_area]0..*-root 0..1>[project_area]`
`project_award`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_award]0..*-project 1>[project]`
`project_award`	`type`	Many-to-one	`0..*`	`1`	`project_award_type`	`[project_award]0..*-type 1>[project_award_type]`
`project_booth`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_booth]0..*-contact 1>[contact]`
`project_booth`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_booth]0..*-project 1>[project]`
`project_booth`	`booth`	One-to-one	`0..1`	`1`	`booth`	`[project_booth]0..1-booth 1>[booth]`
`project_calendar`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_calendar]0..*-project 1>[project]`
`project_calendar`	`result`	Many-to-many	`0..*`	`0..*`	`result`	`[project_calendar]0..-result 0..>[result]`
`project_calendar`	`calendar`	One-to-one	`0..1`	`1`	`calendar`	`[project_calendar]0..1-calendar 1>[calendar]`
`project_calendar_review`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_calendar_review]0..*-contact 1>[contact]`
`project_calendar_review`	`projectCalendar`	Many-to-one	`0..*`	`1`	`project_calendar`	`[project_calendar_review]0..*-projectCalendar 1>[project_calendar]`
`project_challenge`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[project_challenge]0..*-challenge 1>[challenge]`
`project_challenge`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_challenge]0..*-project 1>[project]`
`project_change_request_mailing_recipient`	`optIn`	Many-to-one	`0..*`	`0..1`	`optin`	`[project_change_request_mailing_recipient]0..*-optIn 0..1>[optin]`
`project_change_request_mailing_recipient`	`role`	Many-to-one	`0..*`	`0..1`	`project_role`	`[project_change_request_mailing_recipient]0..*-role 0..1>[project_role]`
`project_change_request_process_email_message`	`emailMessage`	Many-to-one	`0..*`	`1`	`email_message`	`[project_change_request_process_email_message]0..*-emailMessage 1>[email_message]`
`project_change_request_process_email_message`	`process`	Many-to-one	`0..*`	`1`	`project_changerequest_process`	`[project_change_request_process_email_message]0..*-process 1>[project_changerequest_process]`
`project_changelog`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_changelog]0..*-contact 1>[contact]`
`project_changelog`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_changelog]0..*-project 1>[project]`
`project_changerequest_cost_change`	`affiliation`	Many-to-many	`0..*`	`0..*`	`affiliation`	`[project_changerequest_cost_change]0..-affiliation 0..>[affiliation]`
`project_changerequest_cost_change`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_changerequest_cost_change]0..*-contact 1>[contact]`
`project_changerequest_cost_change`	`process`	Many-to-one	`0..*`	`1`	`project_changerequest_process`	`[project_changerequest_cost_change]0..*-process 1>[project_changerequest_process]`
`project_changerequest_country`	`affiliation`	Many-to-many	`0..*`	`0..*`	`affiliation`	`[project_changerequest_country]0..-affiliation 0..>[affiliation]`
`project_changerequest_country`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_changerequest_country]0..*-contact 1>[contact]`
`project_changerequest_country`	`country`	Many-to-one	`0..*`	`1`	`country`	`[project_changerequest_country]0..*-country 1>[country]`
`project_changerequest_country`	`process`	Many-to-one	`0..*`	`1`	`project_changerequest_process`	`[project_changerequest_country]0..*-process 1>[project_changerequest_process]`
`project_changerequest_process`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_changerequest_process]0..*-contact 1>[contact]`
`project_changerequest_process`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_changerequest_process]0..*-project 1>[project]`
`project_cluster`	`cluster`	Many-to-one	`0..*`	`1`	`cluster_cluster`	`[project_cluster]0..*-cluster 1>[cluster_cluster]`
`project_cluster`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_cluster]0..*-project 1>[project]`
`project_contract`	`affiliation`	Many-to-many	`0..*`	`0..*`	`affiliation`	`[project_contract]0..-affiliation 0..>[affiliation]`
`project_contract`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_contract]0..*-contact 1>[contact]`
`project_contract`	`country`	Many-to-one	`0..*`	`1`	`country`	`[project_contract]0..*-country 1>[country]`
`project_contract`	`currency`	Many-to-one	`0..*`	`1`	`currency`	`[project_contract]0..*-currency 1>[currency]`
`project_contract`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[project_contract]0..*-organisation 1>[organisation]`
`project_contract`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_contract]0..*-project 1>[project]`
`project_contract_costs`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_contract_costs]0..*-affiliation 1>[affiliation]`
`project_contract_costs_version`	`affiliationVersion`	Many-to-one	`0..*`	`1`	`affiliation_contract_version`	`[project_contract_costs_version]0..*-affiliationVersion 1>[affiliation_contract_version]`
`project_contract_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_contract_document]0..*-contentType 1>[contenttype]`
`project_contract_document`	`contract`	Many-to-one	`0..*`	`1`	`project_contract`	`[project_contract_document]0..*-contract 1>[project_contract]`
`project_contract_document_object`	`document`	Many-to-one	`0..*`	`1`	`project_contract_document`	`[project_contract_document_object]0..*-document 1>[project_contract_document]`
`project_contract_platform`	`contract`	Many-to-one	`0..*`	`1`	`project_contract`	`[project_contract_platform]0..*-contract 1>[project_contract]`
`project_contract_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[project_contract_platform]0..*-platform 1>[cluster_platform]`
`project_contract_version`	`contract`	Many-to-one	`0..*`	`1`	`project_contract`	`[project_contract_version]0..*-contract 1>[project_contract]`
`project_contract_version_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_contract_version_document]0..*-contentType 1>[contenttype]`
`project_contract_version_document`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_contract_version`	`[project_contract_version_document]0..*-version 1>[project_contract_version]`
`project_contract_version_document_object`	`document`	Many-to-one	`0..*`	`1`	`project_contract_version_document`	`[project_contract_version_document_object]0..*-document 1>[project_contract_version_document]`
`project_contract_version_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[project_contract_version_platform]0..*-platform 1>[cluster_platform]`
`project_contract_version_platform`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_contract_version`	`[project_contract_version_platform]0..*-version 1>[project_contract_version]`
`project_description`	`contact`	Many-to-many	`0..*`	`0..*`	`contact`	`[project_description]0..-contact 0..>[contact]`
`project_description`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_description]0..*-project 1>[project]`
`project_description_tree`	`parentDescription`	Many-to-one	`0..*`	`0..1`	`project_description`	`[project_description_tree]0..*-parentDescription 0..1>[project_description]`
`project_description_tree`	`childDescription`	One-to-one	`0..1`	`1`	`project_description`	`[project_description_tree]0..1-childDescription 1>[project_description]`
`project_document`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_document]0..*-contact 1>[contact]`
`project_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_document]0..*-contentType 1>[contenttype]`
`project_document`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_document]0..*-project 1>[project]`
`project_document`	`type`	Many-to-one	`0..*`	`1`	`project_document_type`	`[project_document]0..*-type 1>[project_document_type]`
`project_document_object`	`document`	Many-to-one	`0..*`	`1`	`project_document`	`[project_document_object]0..*-document 1>[project_document]`
`project_document_type`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[project_document_type]0..-access 0..>[access]`
`project_document_type`	`versionType`	Many-to-many	`0..*`	`0..*`	`project_version_type`	`[project_document_type]0..-versionType 0..>[project_version_type]`
`project_event`	`type`	Many-to-one	`0..*`	`1`	`project_event_type`	`[project_event]0..*-type 1>[project_event_type]`
`project_help`	`faq`	Many-to-many	`0..*`	`0..*`	`project_help_faq`	`[project_help]0..-faq 0..>[project_help_faq]`
`project_help_tree`	`parentHelp`	Many-to-one	`0..*`	`0..1`	`project_help`	`[project_help_tree]0..*-parentHelp 0..1>[project_help]`
`project_help_tree`	`childHelp`	One-to-one	`0..1`	`1`	`project_help`	`[project_help_tree]0..1-childHelp 1>[project_help]`
`project_image`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_image]0..*-project 1>[project]`
`project_log`	`affiliation`	Many-to-many	`0..*`	`0..*`	`affiliation`	`[project_log]0..-affiliation 0..>[affiliation]`
`project_log`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_log]0..*-contact 1>[contact]`
`project_log`	`country`	Many-to-many	`0..*`	`0..*`	`country`	`[project_log]0..-country 0..>[country]`
`project_log`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_log]0..*-project 1>[project]`
`project_logo`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_logo]0..*-contentType 1>[contenttype]`
`project_logo`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_logo]0..*-project 1>[project]`
`project_milestone`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_milestone]0..*-contact 1>[contact]`
`project_milestone`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_milestone]0..*-project 1>[project]`
`project_milestone_document`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_milestone_document]0..*-contact 1>[contact]`
`project_milestone_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_milestone_document]0..*-contentType 1>[contenttype]`
`project_milestone_document`	`milestone`	Many-to-one	`0..*`	`1`	`project_milestone`	`[project_milestone_document]0..*-milestone 1>[project_milestone]`
`project_milestone_document_object`	`document`	Many-to-one	`0..*`	`1`	`project_milestone_document`	`[project_milestone_document_object]0..*-document 1>[project_milestone_document]`
`project_pca`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_pca]0..*-contact 1>[contact]`
`project_pca`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_pca]0..*-contentType 1>[contenttype]`
`project_pca`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_pca]0..*-project 1>[project]`
`project_pca_object`	`pca`	Many-to-one	`0..*`	`1`	`project_pca`	`[project_pca_object]0..*-pca 1>[project_pca]`
`project_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[project_platform]0..*-platform 1>[cluster_platform]`
`project_platform`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_platform]0..*-project 1>[project]`
`project_project_area`	`area`	Many-to-one	`0..*`	`1`	`project_area`	`[project_project_area]0..*-area 1>[project_area]`
`project_project_area`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_project_area]0..*-project 1>[project]`
`project_project_mailing_recipient`	`role`	Many-to-one	`0..*`	`0..1`	`project_role`	`[project_project_mailing_recipient]0..*-role 0..1>[project_role]`
`project_project_role`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_project_role]0..*-contact 1>[contact]`
`project_project_role`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_project_role]0..*-project 1>[project]`
`project_project_role`	`role`	Many-to-one	`0..*`	`1`	`project_role`	`[project_project_role]0..*-role 1>[project_role]`
`project_rationale`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_rationale]0..*-contact 1>[contact]`
`project_rationale`	`country`	Many-to-one	`0..*`	`1`	`country`	`[project_rationale]0..*-country 1>[country]`
`project_rationale`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_rationale]0..*-project 1>[project]`
`project_rationale_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[project_rationale_platform]0..*-platform 1>[cluster_platform]`
`project_rationale_platform`	`rationale`	Many-to-one	`0..*`	`1`	`project_rationale`	`[project_rationale_platform]0..*-rationale 1>[project_rationale]`
`project_role`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_role]0..*-contact 0..1>[contact]`
`project_role`	`selection`	Many-to-many	`0..*`	`0..*`	`selection`	`[project_role]0..-selection 0..>[selection]`
`project_selection`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_selection]0..*-contact 1>[contact]`
`project_version`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_version]0..*-contact 1>[contact]`
`project_version`	`evaluationReportVersion`	Many-to-one	`0..*`	`0..1`	`evaluation_report2_version`	`[project_version]0..*-evaluationReportVersion 0..1>[evaluation_report2_version]`
`project_version`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_version]0..*-project 1>[project]`
`project_version`	`versionType`	Many-to-one	`0..*`	`1`	`project_version_type`	`[project_version]0..*-versionType 1>[project_version_type]`
`project_version`	`changeRequestProcess`	One-to-one	`0..1`	`0..1`	`project_changerequest_process`	`[project_version]0..1-changeRequestProcess 0..1>[project_changerequest_process]`
`project_version_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_version_contact]0..*-contact 1>[contact]`
`project_version_contact`	`VersionRepository`	One-to-one	`0..1`	`1`	`project_version`	`[project_version_contact]0..1-version 1>[project_version]`
`project_version_email_message`	`emailMessage`	Many-to-one	`0..*`	`1`	`email_message`	`[project_version_email_message]0..*-emailMessage 1>[email_message]`
`project_version_email_message`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_version`	`[project_version_email_message]0..*-version 1>[project_version]`
`project_version_mailing_recipient`	`role`	Many-to-one	`0..*`	`0..1`	`project_role`	`[project_version_mailing_recipient]0..*-role 0..1>[project_role]`
`project_version_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[project_version_platform]0..*-platform 1>[cluster_platform]`
`project_version_platform`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_version`	`[project_version_platform]0..*-version 1>[project_version]`
`project_version_review`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_version_review]0..*-contact 1>[contact]`
`project_version_review`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_version`	`[project_version_review]0..*-version 1>[project_version]`
`project_web`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_web]0..*-project 1>[project]`
`project_workpackage_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_workpackage_contact]0..*-contact 1>[contact]`
`project_workpackage_contact`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_version`	`[project_workpackage_contact]0..*-version 1>[project_version]`
`project_workpackage_contact`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[project_workpackage_contact]0..*-workpackage 1>[workpackage]`
`result`	`challenge`	Many-to-many	`0..*`	`0..*`	`challenge`	`[result]0..-challenge 0..>[challenge]`
`result`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[result]0..*-contact 1>[contact]`
`result`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[result]0..*-contentType 1>[contenttype]`
`result`	`image`	Many-to-one	`0..*`	`0..1`	`image`	`[result]0..*-image 0..1>[image]`
`result`	`organisation`	Many-to-many	`0..*`	`0..*`	`organisation`	`[result]0..-organisation 0..>[organisation]`
`result`	`project`	Many-to-one	`0..*`	`1`	`project`	`[result]0..*-project 1>[project]`
`result`	`projects`	Many-to-many	`0..*`	`0..*`	`project`	`[result]0..-projects 0..>[project]`
`result`	`type`	Many-to-one	`0..*`	`1`	`result_type`	`[result]0..*-type 1>[result_type]`
`result_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[result_image]0..*-contentType 1>[contenttype]`
`result_image`	`result`	Many-to-one	`0..*`	`1`	`result`	`[result_image]0..*-result 1>[result]`
`result_object`	`result`	Many-to-one	`0..*`	`1`	`result`	`[result_object]0..*-result 1>[result]`
`result_type`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[result_type]0..-access 0..>[access]`
`result_type`	`category`	Many-to-one	`0..*`	`1`	`result_type_category`	`[result_type]0..*-category 1>[result_type_category]`
`version_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[version_document]0..*-contentType 1>[contenttype]`
`version_document`	`type`	Many-to-one	`0..*`	`1`	`project_document_type`	`[version_document]0..*-type 1>[project_document_type]`
`version_document`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_version`	`[version_document]0..*-version 1>[project_version]`
`version_document`	`envelope`	One-to-one	`0..1`	`0..1`	`docusign_envelope`	`[version_document]0..1-envelope 0..1>[docusign_envelope]`
`version_document_object`	`document`	Many-to-one	`0..*`	`1`	`version_document`	`[version_document_object]0..*-document 1>[version_document]`
`workpackage`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[workpackage]0..*-contact 1>[contact]`
`workpackage`	`project`	Many-to-one	`0..*`	`1`	`project`	`[workpackage]0..*-project 1>[project]`
`workpackage_deliverable`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[workpackage_deliverable]0..*-contact 1>[contact]`
`workpackage_deliverable`	`type`	Many-to-one	`0..*`	`1`	`workpackage_deliverable_type`	`[workpackage_deliverable]0..*-type 1>[workpackage_deliverable_type]`
`workpackage_deliverable`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[workpackage_deliverable]0..*-workpackage 1>[workpackage]`
`workpackage_deliverable_document`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[workpackage_deliverable_document]0..*-contact 1>[contact]`
`workpackage_deliverable_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[workpackage_deliverable_document]0..*-contentType 1>[contenttype]`
`workpackage_deliverable_document`	`deliverable`	Many-to-one	`0..*`	`1`	`workpackage_deliverable`	`[workpackage_deliverable_document]0..*-deliverable 1>[workpackage_deliverable]`
`workpackage_deliverable_document_object`	`document`	Many-to-one	`0..*`	`1`	`workpackage_deliverable_document`	`[workpackage_deliverable_document_object]0..*-document 1>[workpackage_deliverable_document]`
`workpackage_description`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[workpackage_description]0..*-contact 1>[contact]`
`workpackage_description`	`workpackage`	One-to-one	`0..1`	`1`	`workpackage`	`[workpackage_description]0..1-workpackage 1>[workpackage]`
`workpackage_document`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[workpackage_document]0..*-contact 1>[contact]`
`workpackage_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[workpackage_document]0..*-contentType 1>[contenttype]`
`workpackage_document`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[workpackage_document]0..*-workpackage 1>[workpackage]`
`workpackage_document_object`	`document`	Many-to-one	`0..*`	`1`	`workpackage_document`	`[workpackage_document_object]0..*-document 1>[workpackage_document]`
`workpackage_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[workpackage_platform]0..*-platform 1>[cluster_platform]`
`workpackage_platform`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[workpackage_platform]0..*-workpackage 1>[workpackage]`
`workpackage_task`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[workpackage_task]0..*-contact 1>[contact]`
`workpackage_task`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[workpackage_task]0..*-workpackage 1>[workpackage]`

02 November 2026