Affiliation database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`affiliation`

Doctrine entity: Affiliation\Entity\Affiliation

Column	Doctrine type	Key
`affiliation_id`	`integer`
`branch`	`string`
`note`	`text`
`value_chain`	`string`
`market_access`	`text`
`strategic_importance`	`text`
`main_contribution`	`text`
`tasks_and_added_value`	`text`
`funding_factor`	`smallint`
`exclude_from_doa_check`	`boolean`
`self_funded`	`smallint`
`date_created`	`datetime`
`date_end`	`datetime`
`date_self_funded`	`datetime`
`communication_contact_name`	`string`
`communication_contact_email`	`string`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`parent_organisation_id`	`FK`	FK
`project_id`	`FK`	FK
`method_id`	`FK`	FK

`affiliation_affiliation_mailing_recipient`

Doctrine entity: Affiliation\Entity\Affiliation\Mailing\Recipient

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

`affiliation_contract_version`

Doctrine entity: Affiliation\Entity\ContractVersion

Column	Doctrine type	Key
`affiliation_contract_version_id`	`integer`
`affiliation_id`	`FK`	FK
`version_id`	`FK`	FK

`affiliation_description`

Doctrine entity: Affiliation\Entity\Description

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

`affiliation_financial`

Doctrine entity: Affiliation\Entity\Financial

Column	Doctrine type	Key
`affiliation_financial_id`	`integer`
`branch`	`string`
`email_cc`	`string`
`affiliation_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`affiliation_invoice`

Doctrine entity: Affiliation\Entity\Invoice

Column	Doctrine type	Key
`affiliation_invoice_id`	`integer`
`period`	`integer`
`year`	`integer`
`years`	`array`
`amount_invoiced`	`decimal`
`version_id`	`FK`	FK
`contract_version_id`	`FK`	FK
`affiliation_id`	`FK`	FK
`invoice_id`	`FK`	FK
`exchange_rate_id`	`FK`	FK

`affiliation_log`

Doctrine entity: Affiliation\Entity\Log

Column	Doctrine type	Key
`log_id`	`integer`
`year`	`integer`
`period`	`integer`
`log`	`string`
`date_created`	`datetime`
`affiliation_id`	`FK`	FK
`contact_id`	`FK`	FK

`affiliation_platform`

Doctrine entity: Affiliation\Entity\Affiliation\Platform

Column	Doctrine type	Key
`affiliation_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`affiliation_id`	`FK`	FK

`affiliation_survey`

Doctrine entity: Affiliation\Entity\Survey

Column	Doctrine type	Key
`survey_id`	`integer`
`title`	`text`
`description`	`text`
`introduction_text`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`month`	`smallint`
`is_active`	`boolean`

`affiliation_survey_result`

Doctrine entity: Affiliation\Entity\Survey\Result

Column	Doctrine type	Key
`description_id`	`integer`
`year`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`turnover_previous_year`	`float`
`fte_end_previous_year`	`float`
`survey_id`	`FK`	FK
`affiliation_id`	`FK`	FK
`contact_id`	`FK`	FK

`affiliation_version`

Doctrine entity: Affiliation\Entity\Version

Column	Doctrine type	Key
`affiliation_version_id`	`integer`
`affiliation_id`	`FK`	FK
`contact_id`	`FK`	FK
`version_id`	`FK`	FK
`affiliation_contract_version_id`	`FK`	FK

`affiliation_version_platform`

Doctrine entity: Affiliation\Entity\Version\Platform

Column	Doctrine type	Key
`affiliation_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`affiliation_version_id`	`FK`	FK

`affiliation_work_package_tasks_and_added_value`

Doctrine entity: Affiliation\Entity\Affiliation\WorkPackageTasksAndAddedValue

Column	Doctrine type	Key
`tasks_and_added_value_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`tasks`	`text`
`addedValue`	`text`
`affiliation_id`	`FK`	FK
`workpackage_id`	`FK`	FK

`project_doa`

Doctrine entity: Affiliation\Entity\Doa

Column	Doctrine type	Key
`doa_id`	`integer`
`size`	`integer`
`date_received`	`datetime`
`date_updated`	`datetime`
`date_submitted`	`datetime`
`date_signed`	`date`
`date_approved`	`datetime`
`group_name`	`string`
`chamber_of_commerce_location`	`string`
`company_registration_number`	`string`
`company_registration_authority`	`string`
`vat_number`	`string`
`address`	`text`
`vat_status`	`smallint`
`type`	`smallint`
`additional_approver_name`	`string`
`additional_approver_email`	`string`
`affiliation_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`approve_contact_id`	`FK`	FK
`authorized_contact_id`	`FK`	FK
`contact_id`	`FK`	FK
`docusign_envelope_id`	`FK`	FK

`project_doa_object`

Doctrine entity: Affiliation\Entity\DoaObject

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

`project_doa_reminder`

Doctrine entity: Affiliation\Entity\Doa\Reminder

Column	Doctrine type	Key
`reminder_id`	`integer`
`email`	`text`
`date_created`	`datetime`
`affiliation_id`	`FK`	FK
`receiver_id`	`FK`	FK
`sender_id`	`FK`	FK

`project_loi`

Doctrine entity: Affiliation\Entity\Loi

Column	Doctrine type	Key
`loi_id`	`integer`
`date_signed`	`date`
`date_approved`	`datetime`
`size`	`integer`
`date_updated`	`datetime`
`date_created`	`datetime`
`approve_contact_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`affiliation_id`	`FK`	FK
`contact_id`	`FK`	FK

`project_loi_object`

Doctrine entity: Affiliation\Entity\LoiObject

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

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`affiliation`	`associate`	Many-to-many	`0..*`	`0..*`	`contact`	`[affiliation]0..-associate 0..>[contact]`
`affiliation`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[affiliation]0..*-contact 1>[contact]`
`affiliation`	`invoiceMethod`	Many-to-one	`0..*`	`0..1`	`invoice_method`	`[affiliation]0..*-invoiceMethod 0..1>[invoice_method]`
`affiliation`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[affiliation]0..*-organisation 1>[organisation]`
`affiliation`	`parentOrganisation`	Many-to-one	`0..*`	`0..1`	`organisation_parent_organisation`	`[affiliation]0..*-parentOrganisation 0..1>[organisation_parent_organisation]`
`affiliation`	`project`	Many-to-one	`0..*`	`1`	`project`	`[affiliation]0..*-project 1>[project]`
`affiliation`	`proxyContact`	Many-to-many	`0..*`	`0..*`	`contact`	`[affiliation]0..-proxyContact 0..>[contact]`
`affiliation_contract_version`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[affiliation_contract_version]0..*-affiliation 1>[affiliation]`
`affiliation_contract_version`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_contract_version`	`[affiliation_contract_version]0..*-version 1>[project_contract_version]`
`affiliation_description`	`affiliation`	One-to-one	`0..1`	`1`	`affiliation`	`[affiliation_description]0..1-affiliation 1>[affiliation]`
`affiliation_financial`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[affiliation_financial]0..*-contact 1>[contact]`
`affiliation_financial`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[affiliation_financial]0..*-organisation 1>[organisation]`
`affiliation_financial`	`affiliation`	One-to-one	`0..1`	`1`	`affiliation`	`[affiliation_financial]0..1-affiliation 1>[affiliation]`
`affiliation_invoice`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[affiliation_invoice]0..*-affiliation 1>[affiliation]`
`affiliation_invoice`	`contractVersion`	Many-to-one	`0..*`	`0..1`	`project_contract_version`	`[affiliation_invoice]0..*-contractVersion 0..1>[project_contract_version]`
`affiliation_invoice`	`exchangeRate`	Many-to-one	`0..*`	`0..1`	`currency_exchange_rate`	`[affiliation_invoice]0..*-exchangeRate 0..1>[currency_exchange_rate]`
`affiliation_invoice`	`VersionRepository`	Many-to-one	`0..*`	`0..1`	`project_version`	`[affiliation_invoice]0..*-version 0..1>[project_version]`
`affiliation_invoice`	`invoice`	One-to-one	`0..1`	`1`	`invoice`	`[affiliation_invoice]0..1-invoice 1>[invoice]`
`affiliation_log`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[affiliation_log]0..*-affiliation 1>[affiliation]`
`affiliation_log`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[affiliation_log]0..*-contact 1>[contact]`
`affiliation_platform`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[affiliation_platform]0..*-affiliation 1>[affiliation]`
`affiliation_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[affiliation_platform]0..*-platform 1>[cluster_platform]`
`affiliation_survey`	`organisationTypes`	Many-to-many	`0..*`	`0..*`	`organisation_type`	`[affiliation_survey]0..-organisationTypes 0..>[organisation_type]`
`affiliation_survey_result`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[affiliation_survey_result]0..*-affiliation 1>[affiliation]`
`affiliation_survey_result`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[affiliation_survey_result]0..*-contact 1>[contact]`
`affiliation_survey_result`	`survey`	Many-to-one	`0..*`	`1`	`affiliation_survey`	`[affiliation_survey_result]0..*-survey 1>[affiliation_survey]`
`affiliation_version`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[affiliation_version]0..*-affiliation 1>[affiliation]`
`affiliation_version`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[affiliation_version]0..*-contact 1>[contact]`
`affiliation_version`	`contractVersion`	Many-to-one	`0..*`	`0..1`	`affiliation_contract_version`	`[affiliation_version]0..*-contractVersion 0..1>[affiliation_contract_version]`
`affiliation_version`	`VersionRepository`	Many-to-one	`0..*`	`1`	`project_version`	`[affiliation_version]0..*-version 1>[project_version]`
`affiliation_version_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[affiliation_version_platform]0..*-platform 1>[cluster_platform]`
`affiliation_version_platform`	`VersionRepository`	Many-to-one	`0..*`	`1`	`affiliation_version`	`[affiliation_version_platform]0..*-version 1>[affiliation_version]`
`affiliation_work_package_tasks_and_added_value`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[affiliation_work_package_tasks_and_added_value]0..*-affiliation 1>[affiliation]`
`affiliation_work_package_tasks_and_added_value`	`workPackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[affiliation_work_package_tasks_and_added_value]0..*-workPackage 1>[workpackage]`
`project_doa`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_doa]0..*-affiliation 1>[affiliation]`
`project_doa`	`approver`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_doa]0..*-approver 0..1>[contact]`
`project_doa`	`authorizedContact`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_doa]0..*-authorizedContact 0..1>[contact]`
`project_doa`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_doa]0..*-contact 1>[contact]`
`project_doa`	`contentType`	Many-to-one	`0..*`	`0..1`	`contenttype`	`[project_doa]0..*-contentType 0..1>[contenttype]`
`project_doa`	`envelope`	One-to-one	`0..1`	`0..1`	`docusign_envelope`	`[project_doa]0..1-envelope 0..1>[docusign_envelope]`
`project_doa_object`	`doa`	Many-to-one	`0..*`	`1`	`project_doa`	`[project_doa_object]0..*-doa 1>[project_doa]`
`project_doa_reminder`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_doa_reminder]0..*-affiliation 1>[affiliation]`
`project_doa_reminder`	`receiver`	Many-to-one	`0..*`	`1`	`contact`	`[project_doa_reminder]0..*-receiver 1>[contact]`
`project_doa_reminder`	`sender`	Many-to-one	`0..*`	`1`	`contact`	`[project_doa_reminder]0..*-sender 1>[contact]`
`project_loi`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_loi]0..*-affiliation 1>[affiliation]`
`project_loi`	`approver`	Many-to-one	`0..*`	`0..1`	`contact`	`[project_loi]0..*-approver 0..1>[contact]`
`project_loi`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_loi]0..*-contact 1>[contact]`
`project_loi`	`contentType`	Many-to-one	`0..*`	`0..1`	`contenttype`	`[project_loi]0..*-contentType 0..1>[contenttype]`
`project_loi_object`	`loi`	Many-to-one	`0..*`	`1`	`project_loi`	`[project_loi_object]0..*-loi 1>[project_loi]`

02 November 2026