Organisation database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`organisation`

Doctrine entity: Organisation\Entity\Organisation

Column	Doctrine type	Key
`organisation_id`	`integer`
`organisation`	`string`
`date_created`	`datetime`
`docref`	`string`
`date_updated`	`datetime`
`date_end`	`datetime`
`is_funding_organisation`	`boolean`
`hide_from_public_country_project_list`	`boolean`
`country_id`	`FK`	FK
`type_id`	`FK`	FK

`organisation_advisory_board`

Doctrine entity: Organisation\Entity\AdvisoryBoard

Column	Doctrine type	Key
`advisory_board_id`	`integer`
`name`	`string`
`description`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`

`organisation_advisory_board_city`

Doctrine entity: Organisation\Entity\AdvisoryBoard\City

Column	Doctrine type	Key
`city_id`	`integer`
`name`	`string`
`docref`	`string`
`hidden`	`smallint`
`website`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`country_id`	`FK`	FK
`language_id`	`FK`	FK

`organisation_advisory_board_city_image`

Doctrine entity: Organisation\Entity\AdvisoryBoard\City\Image

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

`organisation_advisory_board_city_tender`

Doctrine entity: Organisation\Entity\AdvisoryBoard\City\Tender

Column	Doctrine type	Key
`solution_id`	`integer`
`title`	`string`
`description`	`string`
`website`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`language_id`	`FK`	FK
`city_id`	`FK`	FK

`organisation_advisory_board_member`

Doctrine entity: Organisation\Entity\AdvisoryBoard\Member

Column	Doctrine type	Key
`member_id`	`integer`
`hidden`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`website`	`string`
`contact_id`	`FK`	FK

`organisation_advisory_board_member_image`

Doctrine entity: Organisation\Entity\AdvisoryBoard\Member\Image

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

`organisation_advisory_board_solution`

Doctrine entity: Organisation\Entity\AdvisoryBoard\Solution

Column	Doctrine type	Key
`solution_id`	`integer`
`title`	`string`
`docref`	`string`
`hidden`	`smallint`
`description`	`text`
`targeted_customers`	`string`
`referenced_customers`	`string`
`condition_of_use`	`text`
`contact_email`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`advisory_board_id`	`FK`	FK

`organisation_advisory_board_solution_image`

Doctrine entity: Organisation\Entity\AdvisoryBoard\Solution\Image

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

`organisation_advisory_board_solution_website`

Doctrine entity: Organisation\Entity\AdvisoryBoard\Solution\Website

Column	Doctrine type	Key
`website_id`	`integer`
`url`	`string`
`text`	`string`
`solution_id`	`FK`	FK

`organisation_board`

Doctrine entity: Organisation\Entity\Board

Column	Doctrine type	Key
`board_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_signed`	`date`
`date_end`	`date`
`organisation_id`	`FK`	FK
`cluster_id`	`FK`	FK

`organisation_booth`

Doctrine entity: Organisation\Entity\Booth

Column	Doctrine type	Key
`organisation_booth_id`	`integer`
`booth_id`	`FK`	FK
`organisation_id`	`FK`	FK
`contact_id`	`FK`	FK

`organisation_description`

Doctrine entity: Organisation\Entity\Description

Column	Doctrine type	Key
`description_id`	`integer`
`description`	`text`
`organisation_id`	`FK`	FK

`organisation_financial`

Doctrine entity: Organisation\Entity\Financial

Column	Doctrine type	Key
`financial_id`	`integer`
`vat`	`string`
`date_vat`	`datetime`
`vat_status`	`smallint`
`omitcontact`	`smallint`
`iban`	`string`
`bic`	`string`
`supplier_number`	`string`
`required_purchase_order`	`smallint`
`send_only_invoice`	`smallint`
`email`	`smallint`
`organisation_id`	`FK`	FK

`organisation_founder`

Doctrine entity: Organisation\Entity\Founder

Column	Doctrine type	Key
`founder_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_signed`	`date`
`date_end`	`date`
`organisation_id`	`FK`	FK
`program_id`	`FK`	FK

`organisation_log`

Doctrine entity: Organisation\Entity\Log

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

`organisation_logo`

Doctrine entity: Organisation\Entity\Logo

Column	Doctrine type	Key
`logo_id`	`integer`
`organisation_logo`	`blob`
`logo_extension`	`string`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`organisation_id`	`FK`	FK

`organisation_name`

Doctrine entity: Organisation\Entity\Name

Column	Doctrine type	Key
`name_id`	`integer`
`name`	`string`
`date_created`	`datetime`
`project_id`	`FK`	FK
`organisation_id`	`FK`	FK

`organisation_note`

Doctrine entity: Organisation\Entity\Note

Column	Doctrine type	Key
`note_id`	`integer`
`note`	`text`
`source`	`string`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`organisation_organisation_mailing_recipient`

Doctrine entity: Organisation\Entity\Organisation\Mailing\Recipient

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

`organisation_parent`

Doctrine entity: Organisation\Entity\ParentEntity

Column	Doctrine type	Key
`parent_id`	`integer`
`member_type`	`smallint`
`eposs_member_type`	`smallint`
`artemisia_member_type`	`smallint`
`date_created`	`datetime`
`date_parent_type_update`	`datetime`
`date_updated`	`datetime`
`date_end`	`datetime`
`contact_id`	`FK`	FK
`type_id`	`FK`	FK
`organisation_id`	`FK`	FK

`organisation_parent_doa`

Doctrine entity: Organisation\Entity\Parent\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
`parent_id`	`FK`	FK
`program_id`	`FK`	FK

`organisation_parent_doa_object`

Doctrine entity: Organisation\Entity\Parent\DoaObject

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

`organisation_parent_financial`

Doctrine entity: Organisation\Entity\Parent\Financial

Column	Doctrine type	Key
`parent_financial_id`	`integer`
`branch`	`string`
`note`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`parent_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`organisation_parent_invoice`

Doctrine entity: Organisation\Entity\Parent\Invoice

Column	Doctrine type	Key
`partner_invoice_id`	`integer`
`year`	`integer`
`amount_invoiced`	`decimal`
`parent_id`	`FK`	FK
`invoice_id`	`FK`	FK
`program_id`	`FK`	FK

`organisation_parent_invoice_extra`

Doctrine entity: Organisation\Entity\Parent\InvoiceExtra

Column	Doctrine type	Key
`parent_extra_invoice_id`	`integer`
`year`	`integer`
`amount_invoiced`	`decimal`
`parent_id`	`FK`	FK
`invoice_id`	`FK`	FK
`program_id`	`FK`	FK

`organisation_parent_organisation`

Doctrine entity: Organisation\Entity\Parent\Organisation

Column	Doctrine type	Key
`parent_organisation_id`	`integer`
`parent_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`organisation_parent_type`

Doctrine entity: Organisation\Entity\Parent\Type

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

`organisation_platform`

Doctrine entity: Organisation\Entity\Organisation\Platform

Column	Doctrine type	Key
`organisation_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`organisation_id`	`FK`	FK

`organisation_selection`

Doctrine entity: Organisation\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

`organisation_type`

Doctrine entity: Organisation\Entity\Type

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

`organisation_update`

Doctrine entity: Organisation\Entity\Update

Column	Doctrine type	Key
`update_id`	`integer`
`description`	`text`
`website`	`text`
`date_created`	`datetime`
`date_approved`	`datetime`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`type_id`	`FK`	FK

`organisation_update_logo`

Doctrine entity: Organisation\Entity\UpdateLogo

Column	Doctrine type	Key
`logo_id`	`integer`
`organisation_logo`	`blob`
`logo_extension`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`update_id`	`FK`	FK

`organisation_web`

Doctrine entity: Organisation\Entity\Web

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

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`organisation`	`country`	Many-to-one	`0..*`	`1`	`country`	`[organisation]0..*-country 1>[country]`
`organisation`	`type`	Many-to-one	`0..*`	`1`	`organisation_type`	`[organisation]0..*-type 1>[organisation_type]`
`organisation_advisory_board_city`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_advisory_board_city]0..*-contact 1>[contact]`
`organisation_advisory_board_city`	`country`	Many-to-one	`0..*`	`1`	`country`	`[organisation_advisory_board_city]0..*-country 1>[country]`
`organisation_advisory_board_city`	`language`	Many-to-one	`0..*`	`1`	`language`	`[organisation_advisory_board_city]0..*-language 1>[language]`
`organisation_advisory_board_city_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[organisation_advisory_board_city_image]0..*-contentType 1>[contenttype]`
`organisation_advisory_board_city_image`	`city`	One-to-one	`0..1`	`1`	`organisation_advisory_board_city`	`[organisation_advisory_board_city_image]0..1-city 1>[organisation_advisory_board_city]`
`organisation_advisory_board_city_tender`	`city`	Many-to-one	`0..*`	`1`	`organisation_advisory_board_city`	`[organisation_advisory_board_city_tender]0..*-city 1>[organisation_advisory_board_city]`
`organisation_advisory_board_city_tender`	`language`	Many-to-one	`0..*`	`1`	`language`	`[organisation_advisory_board_city_tender]0..*-language 1>[language]`
`organisation_advisory_board_member`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_advisory_board_member]0..*-contact 1>[contact]`
`organisation_advisory_board_member_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[organisation_advisory_board_member_image]0..*-contentType 1>[contenttype]`
`organisation_advisory_board_member_image`	`member`	One-to-one	`0..1`	`1`	`organisation_advisory_board_member`	`[organisation_advisory_board_member_image]0..1-member 1>[organisation_advisory_board_member]`
`organisation_advisory_board_solution`	`advisoryBoard`	Many-to-one	`0..*`	`1`	`organisation_advisory_board`	`[organisation_advisory_board_solution]0..*-advisoryBoard 1>[organisation_advisory_board]`
`organisation_advisory_board_solution`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[organisation_advisory_board_solution]0..-project 0..>[project]`
`organisation_advisory_board_solution_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[organisation_advisory_board_solution_image]0..*-contentType 1>[contenttype]`
`organisation_advisory_board_solution_image`	`solution`	One-to-one	`0..1`	`1`	`organisation_advisory_board_solution`	`[organisation_advisory_board_solution_image]0..1-solution 1>[organisation_advisory_board_solution]`
`organisation_advisory_board_solution_website`	`solution`	Many-to-one	`0..*`	`1`	`organisation_advisory_board_solution`	`[organisation_advisory_board_solution_website]0..*-solution 1>[organisation_advisory_board_solution]`
`organisation_board`	`cluster`	Many-to-one	`0..*`	`1`	`cluster_cluster`	`[organisation_board]0..*-cluster 1>[cluster_cluster]`
`organisation_board`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_board]0..*-organisation 1>[organisation]`
`organisation_booth`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_booth]0..*-contact 1>[contact]`
`organisation_booth`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_booth]0..*-organisation 1>[organisation]`
`organisation_booth`	`booth`	One-to-one	`0..1`	`1`	`booth`	`[organisation_booth]0..1-booth 1>[booth]`
`organisation_description`	`organisation`	One-to-one	`0..1`	`1`	`organisation`	`[organisation_description]0..1-organisation 1>[organisation]`
`organisation_financial`	`vatType`	Many-to-many	`0..*`	`0..*`	`vat_type`	`[organisation_financial]0..-vatType 0..>[vat_type]`
`organisation_financial`	`organisation`	One-to-one	`0..1`	`1`	`organisation`	`[organisation_financial]0..1-organisation 1>[organisation]`
`organisation_founder`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_founder]0..*-organisation 1>[organisation]`
`organisation_founder`	`program`	Many-to-one	`0..*`	`1`	`program`	`[organisation_founder]0..*-program 1>[program]`
`organisation_log`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_log]0..*-contact 1>[contact]`
`organisation_log`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_log]0..*-organisation 1>[organisation]`
`organisation_logo`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[organisation_logo]0..*-contentType 1>[contenttype]`
`organisation_logo`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_logo]0..*-organisation 1>[organisation]`
`organisation_name`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_name]0..*-organisation 1>[organisation]`
`organisation_name`	`project`	Many-to-one	`0..*`	`1`	`project`	`[organisation_name]0..*-project 1>[project]`
`organisation_note`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_note]0..*-contact 1>[contact]`
`organisation_note`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_note]0..*-organisation 1>[organisation]`
`organisation_parent`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_parent]0..*-contact 1>[contact]`
`organisation_parent`	`type`	Many-to-one	`0..*`	`1`	`organisation_parent_type`	`[organisation_parent]0..*-type 1>[organisation_parent_type]`
`organisation_parent`	`organisation`	One-to-one	`0..1`	`1`	`organisation`	`[organisation_parent]0..1-organisation 1>[organisation]`
`organisation_parent_doa`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_parent_doa]0..*-contact 1>[contact]`
`organisation_parent_doa`	`contentType`	Many-to-one	`0..*`	`0..1`	`contenttype`	`[organisation_parent_doa]0..*-contentType 0..1>[contenttype]`
`organisation_parent_doa`	`parent`	Many-to-one	`0..*`	`1`	`organisation_parent`	`[organisation_parent_doa]0..*-parent 1>[organisation_parent]`
`organisation_parent_doa`	`program`	Many-to-one	`0..*`	`1`	`program`	`[organisation_parent_doa]0..*-program 1>[program]`
`organisation_parent_doa_object`	`doa`	Many-to-one	`0..*`	`1`	`organisation_parent_doa`	`[organisation_parent_doa_object]0..*-doa 1>[organisation_parent_doa]`
`organisation_parent_financial`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_parent_financial]0..*-contact 1>[contact]`
`organisation_parent_financial`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_parent_financial]0..*-organisation 1>[organisation]`
`organisation_parent_financial`	`parent`	Many-to-one	`0..*`	`1`	`organisation_parent`	`[organisation_parent_financial]0..*-parent 1>[organisation_parent]`
`organisation_parent_invoice`	`parent`	Many-to-one	`0..*`	`1`	`organisation_parent`	`[organisation_parent_invoice]0..*-parent 1>[organisation_parent]`
`organisation_parent_invoice`	`program`	Many-to-one	`0..*`	`1`	`program`	`[organisation_parent_invoice]0..*-program 1>[program]`
`organisation_parent_invoice`	`invoice`	One-to-one	`0..1`	`1`	`invoice`	`[organisation_parent_invoice]0..1-invoice 1>[invoice]`
`organisation_parent_invoice_extra`	`parent`	Many-to-one	`0..*`	`1`	`organisation_parent`	`[organisation_parent_invoice_extra]0..*-parent 1>[organisation_parent]`
`organisation_parent_invoice_extra`	`program`	Many-to-one	`0..*`	`1`	`program`	`[organisation_parent_invoice_extra]0..*-program 1>[program]`
`organisation_parent_invoice_extra`	`invoice`	One-to-one	`0..1`	`1`	`invoice`	`[organisation_parent_invoice_extra]0..1-invoice 1>[invoice]`
`organisation_parent_organisation`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_parent_organisation]0..*-contact 1>[contact]`
`organisation_parent_organisation`	`parent`	Many-to-one	`0..*`	`1`	`organisation_parent`	`[organisation_parent_organisation]0..*-parent 1>[organisation_parent]`
`organisation_parent_organisation`	`organisation`	One-to-one	`0..1`	`1`	`organisation`	`[organisation_parent_organisation]0..1-organisation 1>[organisation]`
`organisation_platform`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_platform]0..*-organisation 1>[organisation]`
`organisation_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[organisation_platform]0..*-platform 1>[cluster_platform]`
`organisation_selection`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_selection]0..*-contact 1>[contact]`
`organisation_update`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[organisation_update]0..*-contact 1>[contact]`
`organisation_update`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_update]0..*-organisation 1>[organisation]`
`organisation_update`	`type`	Many-to-one	`0..*`	`1`	`organisation_type`	`[organisation_update]0..*-type 1>[organisation_type]`
`organisation_update_logo`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[organisation_update_logo]0..*-contentType 1>[contenttype]`
`organisation_update_logo`	`update`	Many-to-one	`0..*`	`0..1`	`organisation_update`	`[organisation_update_logo]0..*-update 0..1>[organisation_update]`
`organisation_web`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[organisation_web]0..*-organisation 1>[organisation]`

02 November 2026