Program database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`eureka_secretariat_staff_member`

Doctrine entity: Program\Entity\EurekaSecretariatStaffMember

Column	Doctrine type	Key
`eureka_secretariat_staff_member_id`	`integer`
`information`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK

`funder`

Doctrine entity: Program\Entity\Funder

Column	Doctrine type	Key
`funder_id`	`integer`
`info_office`	`text`
`info_public`	`text`
`show_on_website`	`boolean`
`position`	`smallint`
`website`	`text`
`contact_id`	`FK`	FK
`country_id`	`FK`	FK

`nda`

Doctrine entity: Program\Entity\Nda

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

`nda_object`

Doctrine entity: Program\Entity\NdaObject

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

`program`

Doctrine entity: Program\Entity\Program

Column	Doctrine type	Key
`program_id`	`integer`
`program`	`string`
`number`	`string`

`program_call_platform`

Doctrine entity: Program\Entity\Call\Platform

Column	Doctrine type	Key
`program_call_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`programcall_id`	`FK`	FK

`program_call_template_custom_template`

Doctrine entity: Program\Entity\Call\Template\CustomTemplate

Column	Doctrine type	Key
`customtemplate_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`size`	`integer`
`type`	`smallint`
`contenttype_id`	`FK`	FK
`programcall_id`	`FK`	FK

`program_call_template_custom_template_object`

Doctrine entity: Program\Entity\Call\Template\CustomTemplateObject

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

`program_call_template_doa_template`

Doctrine entity: Program\Entity\Call\Template\DoaTemplate

Column	Doctrine type	Key
`doatemplate_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`online_content`	`text`
`size`	`integer`
`contenttype_id`	`FK`	FK
`cluster_id`	`FK`	FK
`programcall_id`	`FK`	FK

`program_call_template_doa_template_object`

Doctrine entity: Program\Entity\Call\Template\DoaTemplateObject

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

`program_call_template_loi_template`

Doctrine entity: Program\Entity\Call\Template\LoiTemplate

Column	Doctrine type	Key
`loitemplate_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`online_content`	`text`
`size`	`integer`
`contenttype_id`	`FK`	FK
`cluster_id`	`FK`	FK
`programcall_id`	`FK`	FK

`program_call_template_loi_template_object`

Doctrine entity: Program\Entity\Call\Template\LoiTemplateObject

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

`program_call_template_nda_template`

Doctrine entity: Program\Entity\Call\Template\NdaTemplate

Column	Doctrine type	Key
`ndatemplate_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`online_content`	`text`
`size`	`integer`
`contenttype_id`	`FK`	FK
`cluster_id`	`FK`	FK
`programcall_id`	`FK`	FK

`program_call_template_nda_template_object`

Doctrine entity: Program\Entity\Call\Template\NdaTemplateObject

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

`program_call_template_project_document_type_template`

Doctrine entity: Program\Entity\Call\Template\ProjectDocumentTypeTemplate

Column	Doctrine type	Key
`project_document_type_template_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`size`	`integer`
`show_instructions`	`boolean`
`instruction_text`	`text`
`contenttype_id`	`FK`	FK
`project_document_type_id`	`FK`	FK
`programcall_id`	`FK`	FK

`program_call_template_project_document_type_template_object`

Doctrine entity: Program\Entity\Call\Template\ProjectDocumentTypeTemplateObject

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

`program_doa`

Doctrine entity: Program\Entity\Doa

Column	Doctrine type	Key
`doa_id`	`integer`
`date_approved`	`datetime`
`date_signed`	`date`
`branch`	`string`
`size`	`integer`
`date_updated`	`datetime`
`date_created`	`datetime`
`contenttype_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`program_id`	`FK`	FK

`program_doa_object`

Doctrine entity: Program\Entity\DoaObject

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

`program_program_mailing_recipient`

Doctrine entity: Program\Entity\Program\Mailing\Recipient

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

`program_program_platform`

Doctrine entity: Program\Entity\Program\Platform

Column	Doctrine type	Key
`program_program_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`program_id`	`FK`	FK

`programcall`

Doctrine entity: Program\Entity\Call\Call

Column	Doctrine type	Key
`programcall_id`	`integer`
`programcall`	`string`
`project_number_mask`	`string`
`instruction_text`	`text`
`docref`	`string`
`po_open_date`	`datetime`
`po_close_date`	`datetime`
`loi_submission_date`	`datetime`
`fpp_open_date`	`datetime`
`fpp_close_date`	`datetime`
`doa_submission_date`	`datetime`
`label_announcement_date`	`datetime`
`doa_requirement`	`smallint`
`loi_requirement`	`boolean`
`project_report`	`smallint`
`nda_requirement`	`smallint`
`challenge_per_project`	`smallint`
`active`	`boolean`
`call_stages`	`smallint`
`merge_engine`	`smallint`
`po_has_work_packages`	`smallint`
`has_online_work_packages`	`smallint`
`report_tasks_and_added_values_per_work_package`	`boolean`
`program_id`	`FK`	FK

`programcall_country`

Doctrine entity: Program\Entity\Call\Country

Column	Doctrine type	Key
`programcall_country_id`	`integer`
`date_national_application`	`string`
`date_expected_funding_decision`	`string`
`programcall_id`	`FK`	FK
`country_id`	`FK`	FK

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`eureka_secretariat_staff_member`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[eureka_secretariat_staff_member]0..1-contact 1>[contact]`
`funder`	`country`	Many-to-one	`0..*`	`1`	`country`	`[funder]0..*-country 1>[country]`
`funder`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[funder]0..1-contact 1>[contact]`
`nda`	`approver`	Many-to-one	`0..*`	`0..1`	`contact`	`[nda]0..*-approver 0..1>[contact]`
`nda`	`call`	Many-to-one	`0..*`	`0..1`	`programcall`	`[nda]0..*-call 0..1>[programcall]`
`nda`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[nda]0..*-contact 1>[contact]`
`nda`	`contentType`	Many-to-one	`0..*`	`0..1`	`contenttype`	`[nda]0..*-contentType 0..1>[contenttype]`
`nda_object`	`nda`	Many-to-one	`0..*`	`1`	`nda`	`[nda_object]0..*-nda 1>[nda]`
`program`	`cluster`	Many-to-many	`0..*`	`0..*`	`cluster_cluster`	`[program]0..-cluster 0..>[cluster_cluster]`
`program`	`invoiceMethod`	Many-to-many	`0..*`	`0..*`	`invoice_method`	`[program]0..-invoiceMethod 0..>[invoice_method]`
`program_call_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[program_call_platform]0..*-platform 1>[cluster_platform]`
`program_call_platform`	`programCall`	Many-to-one	`0..*`	`1`	`programcall`	`[program_call_platform]0..*-programCall 1>[programcall]`
`program_call_template_custom_template`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[program_call_template_custom_template]0..*-contentType 1>[contenttype]`
`program_call_template_custom_template`	`programCall`	Many-to-one	`0..*`	`1`	`programcall`	`[program_call_template_custom_template]0..*-programCall 1>[programcall]`
`program_call_template_custom_template_object`	`customTemplate`	Many-to-one	`0..*`	`1`	`program_call_template_custom_template`	`[program_call_template_custom_template_object]0..*-customTemplate 1>[program_call_template_custom_template]`
`program_call_template_doa_template`	`cluster`	Many-to-one	`0..*`	`1`	`cluster_cluster`	`[program_call_template_doa_template]0..*-cluster 1>[cluster_cluster]`
`program_call_template_doa_template`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[program_call_template_doa_template]0..*-contentType 1>[contenttype]`
`program_call_template_doa_template`	`programCall`	Many-to-one	`0..*`	`1`	`programcall`	`[program_call_template_doa_template]0..*-programCall 1>[programcall]`
`program_call_template_doa_template_object`	`doaTemplate`	Many-to-one	`0..*`	`1`	`program_call_template_doa_template`	`[program_call_template_doa_template_object]0..*-doaTemplate 1>[program_call_template_doa_template]`
`program_call_template_loi_template`	`cluster`	Many-to-one	`0..*`	`1`	`cluster_cluster`	`[program_call_template_loi_template]0..*-cluster 1>[cluster_cluster]`
`program_call_template_loi_template`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[program_call_template_loi_template]0..*-contentType 1>[contenttype]`
`program_call_template_loi_template`	`programCall`	Many-to-one	`0..*`	`1`	`programcall`	`[program_call_template_loi_template]0..*-programCall 1>[programcall]`
`program_call_template_loi_template_object`	`loiTemplate`	Many-to-one	`0..*`	`1`	`program_call_template_loi_template`	`[program_call_template_loi_template_object]0..*-loiTemplate 1>[program_call_template_loi_template]`
`program_call_template_nda_template`	`cluster`	Many-to-one	`0..*`	`1`	`cluster_cluster`	`[program_call_template_nda_template]0..*-cluster 1>[cluster_cluster]`
`program_call_template_nda_template`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[program_call_template_nda_template]0..*-contentType 1>[contenttype]`
`program_call_template_nda_template`	`programCall`	Many-to-one	`0..*`	`1`	`programcall`	`[program_call_template_nda_template]0..*-programCall 1>[programcall]`
`program_call_template_nda_template_object`	`ndaTemplate`	Many-to-one	`0..*`	`1`	`program_call_template_nda_template`	`[program_call_template_nda_template_object]0..*-ndaTemplate 1>[program_call_template_nda_template]`
`program_call_template_project_document_type_template`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[program_call_template_project_document_type_template]0..*-contentType 1>[contenttype]`
`program_call_template_project_document_type_template`	`programCall`	Many-to-one	`0..*`	`1`	`programcall`	`[program_call_template_project_document_type_template]0..*-programCall 1>[programcall]`
`program_call_template_project_document_type_template`	`projectDocumentType`	Many-to-one	`0..*`	`1`	`project_document_type`	`[program_call_template_project_document_type_template]0..*-projectDocumentType 1>[project_document_type]`
`program_call_template_project_document_type_template_object`	`projectDocumentTypeTemplate`	Many-to-one	`0..*`	`1`	`program_call_template_project_document_type_template`	`[program_call_template_project_document_type_template_object]0..*-projectDocumentTypeTemplate 1>[program_call_template_project_document_type_template]`
`program_doa`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[program_doa]0..*-contact 1>[contact]`
`program_doa`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[program_doa]0..*-contentType 1>[contenttype]`
`program_doa`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[program_doa]0..*-organisation 1>[organisation]`
`program_doa`	`program`	Many-to-one	`0..*`	`1`	`program`	`[program_doa]0..*-program 1>[program]`
`program_doa_object`	`doa`	Many-to-one	`0..*`	`1`	`program_doa`	`[program_doa_object]0..*-doa 1>[program_doa]`
`program_program_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[program_program_platform]0..*-platform 1>[cluster_platform]`
`program_program_platform`	`program`	Many-to-one	`0..*`	`1`	`program`	`[program_program_platform]0..*-program 1>[program]`
`programcall`	`cluster`	Many-to-many	`0..*`	`0..*`	`cluster_cluster`	`[programcall]0..-cluster 0..>[cluster_cluster]`
`programcall`	`program`	Many-to-one	`0..*`	`1`	`program`	`[programcall]0..*-program 1>[program]`
`programcall_country`	`call`	Many-to-one	`0..*`	`1`	`programcall`	`[programcall_country]0..*-call 1>[programcall]`
`programcall_country`	`country`	Many-to-one	`0..*`	`1`	`country`	`[programcall_country]0..*-country 1>[country]`

02 November 2026