Database entity relationship diagram

This reference is generated from the Doctrine ORM metadata. You can download the full ERD in Excel format here.

Entities

`access`

Doctrine entity: Admin\Entity\Access

Column	Doctrine type	Key
`access_id`	`integer`
`access`	`string`
`description`	`string`

`accounting_adapter`

Doctrine entity: Accounting\Entity\AccountingAdapter

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`ledger`	`string`
`accessToken`	`text`
`refreshToken`	`text`
`dateExpire`	`datetime`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`type`	`smallint`
`oAuth2Service_id`	`FK`	FK

`accounting_invoice_provider`

Doctrine entity: Accounting\Entity\InvoiceProvider

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`accountName`	`string`
`description`	`text`
`apiKey`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`type`	`smallint`
`hash`	`string`

`accounting_invoice_provider_client`

Doctrine entity: Accounting\Entity\InvoiceProvider\Client

Column	Doctrine type	Key
`client_id`	`integer`
`external_client_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`raw_data`	`json`
`invoiceProvider_id`	`FK`	FK
`contact_id`	`FK`	FK

`accounting_invoice_provider_invoice`

Doctrine entity: Accounting\Entity\InvoiceProvider\Invoice

Column	Doctrine type	Key
`id`	`integer`
`status`	`string`
`invoiceNumber`	`string`
`external_invoice_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`raw_data`	`json`
`invoiceProvider_id`	`FK`	FK
`invoice_id`	`FK`	FK

`accounting_payment_provider`

Doctrine entity: Accounting\Entity\PaymentProvider

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`apiKey`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`type`	`smallint`
`hash`	`string`

`address_type`

Doctrine entity: Contact\Entity\AddressType

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

`address_type_sort`

Doctrine entity: Contact\Entity\AddressTypeSort

Column	Doctrine type	Key
`sort_id`	`integer`
`sort`	`integer`
`main_type_id`	`FK`	FK
`sub_type_id`	`FK`	FK

`admin_api_log`

Doctrine entity: Admin\Entity\Api\Log

Column	Doctrine type	Key
`id`	`integer`
`class`	`string`
`type`	`smallint`
`dateCreated`	`datetime`
`uri`	`string`
`payload`	`text`
`statusCode`	`integer`
`status`	`text`
`response`	`text`

`admin_authentication`

Doctrine entity: Admin\Entity\Authentication

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`buttonText`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`type`	`smallint`
`oAuth2Service_id`	`FK`	FK

`admin_messages`

Doctrine entity: Admin\Entity\Queue

Column	Doctrine type	Key
`id`	`bigint`
`body`	`text`
`headers`	`text`
`queue_name`	`string`
`created_at`	`datetime`
`available_at`	`datetime`
`delivered_at`	`datetime`

`admin_oauth2_service`

Doctrine entity: Admin\Entity\OAuth2\Service

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`clientId`	`string`
`tenantId`	`string`
`clientSecret`	`string`
`redirectUrl`	`string`
`authorizationUrl`	`string`
`accessTokenUrl`	`string`
`userId`	`string`
`privateKey`	`string`
`profileUrl`	`string`
`type`	`smallint`
`scope_id`	`FK`	FK

`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

`announcement`

Doctrine entity: General\Entity\Announcement

Column	Doctrine type	Key
`announcement_id`	`integer`
`name`	`string`
`announcement_text`	`text`
`date_created`	`datetime`
`last_update`	`datetime`
`date_announcement_start`	`datetime`
`date_announcement_end`	`datetime`
`type`	`smallint`
`locations`	`smallint`
`is_dismissible`	`boolean`

`article`

Doctrine entity: Content\Entity\Article

Column	Doctrine type	Key
`article_id`	`integer`
`article`	`string`
`docref`	`string`
`date_created`	`datetime`
`sequence`	`integer`
`body`	`text`
`css`	`text`
`hide_from_navigation`	`smallint`
`article_in_title`	`smallint`

`article_version`

Doctrine entity: Content\Entity\Article\Version

Column	Doctrine type	Key
`article_version_id`	`integer`
`article`	`string`
`date_created`	`datetime`
`body`	`text`
`css`	`text`
`article_id`	`FK`	FK

`badge`

Doctrine entity: Event\Entity\Badge\Badge

Column	Doctrine type	Key
`badge_id`	`integer`
`badge`	`string`
`date_created`	`datetime`
`mm_top`	`integer`
`mm_left`	`integer`
`mm_width`	`integer`
`mm_height`	`integer`
`mm_horz_margin`	`integer`
`mm_vert_margin`	`integer`
`mm_name`	`integer`
`mm_organisation`	`integer`
`font_name`	`integer`
`font_organisation`	`integer`
`color_name`	`string`
`color_organisation`	`string`
`config`	`text`
`layout`	`json`
`mm_left_name`	`integer`
`contact_id`	`FK`	FK
`selection_id`	`FK`	FK

`badge_attachment`

Doctrine entity: Event\Entity\Badge\Attachment

Column	Doctrine type	Key
`attachment_id`	`integer`
`attachment`	`string`
`size`	`integer`
`date_updated`	`datetime`
`priority`	`smallint`
`sequence`	`smallint`
`side`	`smallint`
`badge_id`	`FK`	FK
`contenttype_id`	`FK`	FK

`badge_attachment_object`

Doctrine entity: Event\Entity\Badge\AttachmentObject

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

`badge_contact`

Doctrine entity: Event\Entity\Badge\Contact

Column	Doctrine type	Key
`badge_contact_id`	`integer`
`date_create`	`datetime`
`blocked`	`boolean`
`badge_id`	`FK`	FK
`contact_id`	`FK`	FK

`blog`

Doctrine entity: News\Entity\Blog

Column	Doctrine type	Key
`blog_id`	`integer`
`blog`	`string`
`hidden`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_published`	`datetime`
`bodytxt`	`text`
`introtxt`	`text`
`css`	`text`
`docref`	`string`
`subtitle`	`string`
`contact_id`	`FK`	FK

`blog_message`

Doctrine entity: News\Entity\Blog\Message

Column	Doctrine type	Key
`message_id`	`integer`
`message`	`text`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`blog_id`	`FK`	FK

`booth`

Doctrine entity: Event\Entity\Booth\Booth

Column	Doctrine type	Key
`booth_id`	`integer`
`booth`	`string`
`reference`	`string`
`length`	`decimal`
`depth`	`decimal`
`votable`	`smallint`
`coord_x`	`decimal`
`coord_y`	`decimal`
`orientation`	`smallint`
`panels`	`smallint`
`rotation`	`smallint`
`description`	`string`
`hidden`	`smallint`
`frontcolor`	`string`
`backcolor`	`string`
`exhibition_id`	`FK`	FK

`booth_challenge`

Doctrine entity: Event\Entity\Booth\Challenge

Column	Doctrine type	Key
`booth_challenge_id`	`integer`
`booth_id`	`FK`	FK
`challenge_id`	`FK`	FK

`booth_contact`

Doctrine entity: Event\Entity\Booth\Contact

Column	Doctrine type	Key
`booth_contact_id`	`integer`
`mail`	`smallint`
`crew`	`smallint`
`booth_id`	`FK`	FK
`contact_id`	`FK`	FK

`booth_financial`

Doctrine entity: Event\Entity\Booth\Financial

Column	Doctrine type	Key
`booth_financial_id`	`integer`
`branch`	`string`
`purchase_order`	`string`
`booth_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`booth_financial_invoice`

Doctrine entity: Event\Entity\Booth\FinancialInvoice

Column	Doctrine type	Key
`link_id`	`integer`
`booth_financial_id`	`FK`	FK
`invoice_id`	`FK`	FK

`booth_spec`

Doctrine entity: Event\Entity\Booth\Spec

Column	Doctrine type	Key
`booth_spec_id`	`integer`
`value_text`	`text`
`value_numeric`	`decimal`
`date_updated`	`datetime`
`booth_id`	`FK`	FK
`spec_id`	`FK`	FK

`calendar`

Doctrine entity: Calendar\Entity\Calendar

Column	Doctrine type	Key
`calendar_id`	`integer`
`calendar`	`string`
`location`	`string`
`docref`	`string`
`target_group`	`string`
`date_from`	`datetime`
`date_end`	`datetime`
`date_created`	`datetime`
`date_updated`	`datetime`
`final`	`smallint`
`on_homepage`	`boolean`
`highlight`	`boolean`
`highlight_description`	`text`
`own_event`	`boolean`
`present`	`boolean`
`sequence`	`smallint`
`description`	`text`
`url`	`string`
`date_plan`	`datetime`
`image_url`	`string`
`type_id`	`FK`	FK
`contact_id`	`FK`	FK
`meeting_id`	`FK`	FK

`calendar_contact`

Doctrine entity: Calendar\Entity\Contact

Column	Doctrine type	Key
`calendar_contact_id`	`integer`
`role_id`	`FK`	FK
`calendar_id`	`FK`	FK
`status_id`	`FK`	FK
`contact_id`	`FK`	FK

`calendar_contact_role`

Doctrine entity: Calendar\Entity\Contact\Role

Column	Doctrine type	Key
`role_id`	`integer`
`role`	`string`
`show_in_review_calendar`	`boolean`
`is_reviewer_role`	`boolean`
`sequence`	`smallint`

`calendar_contact_status`

Doctrine entity: Calendar\Entity\Contact\Status

Column	Doctrine type	Key
`status_id`	`integer`
`status`	`string`
`status_change`	`string`
`sequence`	`smallint`

`calendar_document`

Doctrine entity: Calendar\Entity\Document

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

`calendar_document_object`

Doctrine entity: Calendar\Entity\DocumentObject

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

`calendar_email_message`

Doctrine entity: Calendar\Entity\Calendar\EmailMessage

Column	Doctrine type	Key
`calendar_email_message_id`	`integer`
`date_created`	`datetime`
`calendar_id`	`FK`	FK
`email_message_id`	`FK`	FK

`calendar_mailing_recipient`

Doctrine entity: Calendar\Entity\Calendar\Mailing\Recipient

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

`calendar_type`

Doctrine entity: Calendar\Entity\Type

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

`category`

Doctrine entity: News\Entity\Blog\Category

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

`challenge`

Doctrine entity: General\Entity\Challenge

Column	Doctrine type	Key
`challenge_id`	`integer`
`challenge`	`string`
`docref`	`string`
`prefix`	`string`
`sequence`	`integer`
`html`	`text`
`css`	`text`
`sources`	`text`
`abstract`	`text`
`background_image`	`smallint`
`backcolor`	`string`
`frontcolor`	`string`
`type_id`	`FK`	FK

`challenge_icon`

Doctrine entity: General\Entity\Challenge\Icon

Column	Doctrine type	Key
`icon_id`	`integer`
`icon`	`blob`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`challenge_id`	`FK`	FK

`challenge_idea_poster_icon`

Doctrine entity: General\Entity\Challenge\Idea\Poster\Icon

Column	Doctrine type	Key
`icon_id`	`integer`
`icon`	`blob`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`challenge_id`	`FK`	FK

`challenge_idea_poster_image`

Doctrine entity: General\Entity\Challenge\Idea\Poster\Image

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

`challenge_image`

Doctrine entity: General\Entity\Challenge\Image

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

`challenge_pdf`

Doctrine entity: General\Entity\Challenge\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`date_created`	`datetime`
`challenge_id`	`FK`	FK

`challenge_type`

Doctrine entity: General\Entity\Challenge\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`description`	`text`
`sequence`	`integer`
`active_for_calls`	`smallint`

`cluster_cluster`

Doctrine entity: Cluster\Entity\Cluster

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

`cluster_cluster_logo`

Doctrine entity: Cluster\Entity\Cluster\Logo

Column	Doctrine type	Key
`logo_id`	`integer`
`cluster_logo`	`blob`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`cluster_id`	`FK`	FK

`cluster_platform`

Doctrine entity: Cluster\Entity\Platform

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

`cluster_platform_exchange`

Doctrine entity: Cluster\Entity\Platform\Exchange

Column	Doctrine type	Key
`exchange_id`	`integer`
`name`	`string`
`description`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`is_active`	`boolean`
`exchange_format`	`smallint`
`endpoint`	`string`
`redirect_url`	`string`
`username`	`string`
`password`	`string`
`client_id`	`string`
`client_secret`	`string`
`update_project_url`	`string`
`platform_id`	`FK`	FK
`cluster_id`	`FK`	FK

`cluster_platform_exchange_log`

Doctrine entity: Cluster\Entity\Platform\Exchange\Log

Column	Doctrine type	Key
`log_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`payload`	`text`
`code`	`integer`
`response`	`text`
`exchange_id`	`FK`	FK
`project_id`	`FK`	FK

`cluster_platform_exchange_project_selection`

Doctrine entity: Cluster\Entity\Platform\Exchange\ProjectSelection

Column	Doctrine type	Key
`exchange_project_selection_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`selection_type`	`smallint`
`exchange_id`	`FK`	FK
`project_selection_id`	`FK`	FK

`contact`

Doctrine entity: Contact\Entity\Contact

Column	Doctrine type	Key
`contact_id`	`integer`
`firstname`	`string`
`middlename`	`string`
`lastname`	`string`
`email`	`string`
`salted_password`	`string`
`position`	`string`
`department`	`string`
`date_birth`	`date`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_end`	`datetime`
`date_anonymous`	`datetime`
`date_activated`	`datetime`
`hash`	`string`
`trigger_update`	`boolean`
`can_be_deleted`	`boolean`
`can_be_anonymised`	`boolean`
`will_be_auto_removed`	`boolean`
`authentication_id`	`FK`	FK
`title_id`	`FK`	FK

`contact_address`

Doctrine entity: Contact\Entity\Address

Column	Doctrine type	Key
`address_id`	`integer`
`address`	`string`
`zipcode`	`string`
`city`	`string`
`type_id`	`FK`	FK
`contact_id`	`FK`	FK
`country_id`	`FK`	FK

`contact_contact_mailing_recipient`

Doctrine entity: Contact\Entity\Contact\Mailing\Recipient

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

`contact_dnd`

Doctrine entity: Contact\Entity\Dnd

Column	Doctrine type	Key
`dnd_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`size`	`integer`
`contact_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`program_id`	`FK`	FK

`contact_dnd_object`

Doctrine entity: Contact\Entity\DndObject

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

`contact_email`

Doctrine entity: Contact\Entity\Email

Column	Doctrine type	Key
`email_id`	`integer`
`email`	`string`
`contact_id`	`FK`	FK

`contact_log`

Doctrine entity: Contact\Entity\Log

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

`contact_note`

Doctrine entity: Contact\Entity\Note

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

`contact_office`

Doctrine entity: Contact\Entity\Office\Contact

Column	Doctrine type	Key
`office_contact_id`	`integer`
`hours`	`smallint`
`date_created`	`datetime`
`date_end`	`datetime`
`calendar_color`	`string`
`contact_id`	`FK`	FK

`contact_office_leave`

Doctrine entity: Contact\Entity\Office\Leave

Column	Doctrine type	Key
`leave_id`	`integer`
`description`	`string`
`date_start`	`date`
`date_end`	`date`
`hours`	`decimal`
`office_contact_id`	`FK`	FK
`type_id`	`FK`	FK

`contact_office_leave_type`

Doctrine entity: Contact\Entity\Office\LeaveType

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`factor`	`smallint`
`calendar`	`boolean`

`contact_organisation`

Doctrine entity: Contact\Entity\ContactOrganisation

Column	Doctrine type	Key
`contact_organisation_id`	`integer`
`branch`	`string`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`contact_phone`

Doctrine entity: Contact\Entity\Phone

Column	Doctrine type	Key
`phone_id`	`integer`
`phone`	`string`
`contact_id`	`FK`	FK
`type_id`	`FK`	FK

`contact_photo`

Doctrine entity: Contact\Entity\Photo

Column	Doctrine type	Key
`photo_id`	`integer`
`photo`	`blob`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`contact_id`	`FK`	FK

`contact_platform`

Doctrine entity: Contact\Entity\Contact\Platform

Column	Doctrine type	Key
`contact_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`contact_id`	`FK`	FK

`contact_profile`

Doctrine entity: Contact\Entity\Profile

Column	Doctrine type	Key
`profile_id`	`integer`
`description`	`text`
`linked_in`	`string`
`visible`	`smallint`
`contact_id`	`FK`	FK

`content_route`

Doctrine entity: Content\Entity\Route

Column	Doctrine type	Key
`route_id`	`integer`
`route`	`string`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`start_node_id`	`FK`	FK
`route_entity_id`	`FK`	FK
`template_id`	`FK`	FK
`tool_id`	`FK`	FK

`content_route_entity`

Doctrine entity: Content\Entity\Route\RouteEntity

Column	Doctrine type	Key
`route_entity_id`	`integer`
`name`	`string`
`entity_class_name`	`string`
`assertion_class_name`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`

`content_template`

Doctrine entity: Content\Entity\Template

Column	Doctrine type	Key
`template_id`	`integer`
`template`	`string`
`content`	`text`
`type`	`smallint`
`date_created`	`datetime`
`last_update`	`datetime`

`contenttype`

Doctrine entity: General\Entity\ContentType

Column	Doctrine type	Key
`contenttype_id`	`integer`
`description`	`string`
`contenttype`	`string`
`extension`	`string`

`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

`country`

Doctrine entity: General\Entity\Country

Column	Doctrine type	Key
`country_id`	`integer`
`country_cd`	`string`
`full_name`	`string`
`sorting_name`	`string`
`full_name_with_article`	`string`
`adjective`	`string`
`citizen`	`string`
`docRef`	`string`
`iso3`	`string`

`country_eu`

Doctrine entity: General\Entity\Eu

Column	Doctrine type	Key
`eu_id`	`integer`
`date_since`	`date`
`country_id`	`FK`	FK

`country_eureka`

Doctrine entity: General\Entity\Eureka

Column	Doctrine type	Key
`eureka_id`	`integer`
`date_since`	`date`
`country_id`	`FK`	FK

`country_flag`

Doctrine entity: General\Entity\Flag

Column	Doctrine type	Key
`flag_id`	`integer`
`object`	`blob`
`country_id`	`FK`	FK

`country_itac`

Doctrine entity: General\Entity\Itac

Column	Doctrine type	Key
`itac_id`	`integer`
`date_since`	`date`
`country_id`	`FK`	FK

`country_page`

Doctrine entity: General\Entity\Country\Page

Column	Doctrine type	Key
`country_page_id`	`integer`
`type`	`smallint`
`twig_content`	`text`
`style`	`text`
`country_id`	`FK`	FK

`country_video`

Doctrine entity: General\Entity\Country\Video

Column	Doctrine type	Key
`country_video_id`	`integer`
`title`	`text`
`type`	`smallint`
`description`	`text`
`country_id`	`FK`	FK
`video_id`	`FK`	FK

`currency`

Doctrine entity: General\Entity\Currency

Column	Doctrine type	Key
`currency_id`	`integer`
`name`	`string`
`iso4217`	`string`
`symbol`	`string`

`currency_exchange_rate`

Doctrine entity: General\Entity\ExchangeRate

Column	Doctrine type	Key
`exchange_rate_id`	`integer`
`rate`	`decimal`
`date`	`date`
`currency_id`	`FK`	FK

`deeplink`

Doctrine entity: Deeplink\Entity\Deeplink

Column	Doctrine type	Key
`deeplink_id`	`integer`
`hash`	`string`
`validation_token`	`string`
`needs_validation`	`boolean`
`date_created`	`datetime`
`date_end`	`datetime`
`date_access`	`datetime`
`times_accessed`	`integer`
`key_id`	`string`
`email`	`string`
`target_id`	`FK`	FK
`contact_id`	`FK`	FK

`deeplink_target`

Doctrine entity: Deeplink\Entity\Target

Column	Doctrine type	Key
`target_id`	`integer`
`target`	`string`
`route`	`string`

`desk_costs`

Doctrine entity: Event\Entity\Registration\Desk\Costs

Column	Doctrine type	Key
`costs_id`	`integer`
`description`	`string`
`is_registration_fee`	`boolean`
`quantity`	`decimal`
`amount`	`decimal`
`date_paid`	`datetime`
`desk_id`	`FK`	FK
`vat_id`	`FK`	FK
`transaction_id`	`FK`	FK
`option_id`	`FK`	FK

`desk_costs_option`

Doctrine entity: Event\Entity\Registration\Desk\Costs\Option

Column	Doctrine type	Key
`desk_costs_option_id`	`integer`
`date_paid`	`datetime`
`costs_id`	`FK`	FK
`option_id`	`FK`	FK

`docusign_app`

Doctrine entity: General\Entity\DocusignApp

Column	Doctrine type	Key
`docusign_app_id`	`integer`
`name`	`string`
`applications`	`json`
`apiAccountId`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`accountBaseUri`	`string`
`hash`	`string`
`oAuth2Service_id`	`FK`	FK

`docusign_envelope`

Doctrine entity: General\Entity\Docusign\Envelope

Column	Doctrine type	Key
`docusign_envelope_id`	`integer`
`envelopeId`	`string`
`status`	`string`
`emailSubject`	`string`
`date_created`	`datetime`
`last_update`	`datetime`
`date_delivered`	`datetime`
`date_completed`	`datetime`
`date_expire`	`datetime`
`type`	`string`
`docusign_app_id`	`FK`	FK

`docusign_envelope_document`

Doctrine entity: General\Entity\Docusign\Envelope\Document

Column	Doctrine type	Key
`docusign_envelope_document_id`	`integer`
`documentId`	`string`
`documentGuid`	`string`
`name`	`string`
`type`	`string`
`date_created`	`datetime`
`last_update`	`datetime`
`docusign_envelope_id`	`FK`	FK

`docusign_envelope_document_object`

Doctrine entity: General\Entity\Docusign\Envelope\Document\DocumentObject

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

`docusign_envelope_event`

Doctrine entity: General\Entity\Docusign\Envelope\Event

Column	Doctrine type	Key
`docusign_envelope_event_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`event`	`string`
`docusign_envelope_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

`email_message`

Doctrine entity: Mailing\Entity\EmailMessage

Column	Doctrine type	Key
`email_message_id`	`integer`
`identifier`	`string`
`date_created`	`datetime`
`email_address`	`string`
`recipient_name`	`string`
`subject`	`string`
`to`	`text`
`message`	`text`
`amount_of_attachments`	`smallint`
`contact_id`	`FK`	FK
`mailing_contact_id`	`FK`	FK
`mailtemplate_id`	`FK`	FK
`sender_id`	`FK`	FK
`mailer_id`	`FK`	FK

`email_message_event`

Doctrine entity: Mailing\Entity\EmailMessageEvent

Column	Doctrine type	Key
`email_message_event_id`	`integer`
`event`	`string`
`time`	`datetime`
`message_id`	`bigint`
`email`	`string`
`campaign`	`string`
`smtp_reply`	`string`
`url`	`string`
`ip`	`string`
`agent`	`string`
`error`	`string`
`error_related_to`	`string`
`source`	`string`
`email_message_id`	`FK`	FK

`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

`evaluation`

Doctrine entity: Evaluation\Entity\Evaluation

Column	Doctrine type	Key
`evaluation_id`	`integer`
`description`	`text`
`date_updated`	`datetime`
`eligible`	`smallint`
`status_id`	`FK`	FK
`contact_id`	`FK`	FK
`country_id`	`FK`	FK
`type_id`	`FK`	FK
`project_id`	`FK`	FK

`evaluation_feedback`

Doctrine entity: Evaluation\Entity\Feedback

Column	Doctrine type	Key
`evaluation_feedback_id`	`integer`
`date_updated`	`datetime`
`mandatory_improvements`	`text`
`recommended_improvements`	`text`
`review_feedback`	`text`
`evaluation_feedback`	`text`
`evaluation_conclusion`	`text`
`version_id`	`FK`	FK
`status_id`	`FK`	FK

`evaluation_platform`

Doctrine entity: Evaluation\Entity\Evaluation\Platform

Column	Doctrine type	Key
`project_evaluation_platform_id`	`integer`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`platform_id`	`FK`	FK
`evaluation_id`	`FK`	FK

`evaluation_report2`

Doctrine entity: Evaluation\Entity\Report

Column	Doctrine type	Key
`evaluation_report_id`	`integer`
`final`	`boolean`
`date_final`	`datetime`
`date_submitted`	`datetime`
`date_reviewed`	`datetime`
`date_created`	`datetime`
`date_updated`	`datetime`
`project_version_score`	`smallint`
`evaluation_result`	`smallint`
`office_evaluation`	`smallint`
`comment_for_project_leader`	`text`
`version_id`	`FK`	FK

`evaluation_report2_criterion`

Doctrine entity: Evaluation\Entity\Report\Criterion

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

`evaluation_report2_criterion_category`

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

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

`evaluation_report2_criterion_topic`

Doctrine entity: Evaluation\Entity\Report\Criterion\Topic

Column	Doctrine type	Key
`topic_id`	`integer`
`sequence`	`integer`
`topic`	`string`

`evaluation_report2_criterion_type`

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

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

`evaluation_report2_criterion_version`

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

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

`evaluation_report2_criterion_version_topic`

Doctrine entity: Evaluation\Entity\Report\Criterion\VersionTopic

Column	Doctrine type	Key
`criterion_topic_id`	`integer`
`weight`	`smallint`
`criterion_version_id`	`FK`	FK
`topic_id`	`FK`	FK

`evaluation_report2_project_report`

Doctrine entity: Evaluation\Entity\Report\ProjectReport

Column	Doctrine type	Key
`project_report_id`	`integer`
`project_status`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`evaluation_report_id`	`FK`	FK
`report_id`	`FK`	FK
`report_review_id`	`FK`	FK

`evaluation_report2_project_version`

Doctrine entity: Evaluation\Entity\Report\ProjectVersion

Column	Doctrine type	Key
`project_version_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`evaluation_report_id`	`FK`	FK
`project_version_review_id`	`FK`	FK
`version_id`	`FK`	FK

`evaluation_report2_result`

Doctrine entity: Evaluation\Entity\Report\Result

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

`evaluation_report2_type`

Doctrine entity: Evaluation\Entity\Report\Type

Column	Doctrine type	Key
`type_id`	`integer`
`sequence`	`integer`
`type`	`string`
`process_type`	`smallint`
`version_type_id`	`FK`	FK

`evaluation_report2_version`

Doctrine entity: Evaluation\Entity\Report\Version

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

`evaluation_report2_window`

Doctrine entity: Evaluation\Entity\Report\Window

Column	Doctrine type	Key
`window_id`	`integer`
`title`	`string`
`description`	`text`
`date_start_report`	`datetime`
`date_end_report`	`datetime`
`date_start_selection`	`datetime`
`date_end_selection`	`datetime`
`inputMethod`	`array`
`report_version_id`	`FK`	FK

`evaluation_report2_window_project`

Doctrine entity: Evaluation\Entity\Report\Window\Project

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

`evaluation_type`

Doctrine entity: Evaluation\Entity\Type

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

`event_slideshow`

Doctrine entity: Event\Entity\Slideshow

Column	Doctrine type	Key
`slideshow_id`	`integer`
`name`	`string`
`description`	`text`
`interval`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_refreshed`	`datetime`

`event_slideshow_slide`

Doctrine entity: Event\Entity\Slideshow\Slide

Column	Doctrine type	Key
`slide_id`	`integer`
`name`	`string`
`twig_content`	`text`
`is_active`	`boolean`
`date_created`	`datetime`
`date_updated`	`datetime`
`sequence`	`integer`
`slideshow_id`	`FK`	FK

`event_slideshow_slide_view`

Doctrine entity: Event\Entity\Slideshow\Slide\View

Column	Doctrine type	Key
`view_id`	`integer`
`client`	`string`
`date_created`	`datetime`
`slide_id`	`FK`	FK

`exhibition`

Doctrine entity: Event\Entity\Exhibition\Exhibition

Column	Doctrine type	Key
`exhibition_id`	`integer`
`exhibition`	`string`
`date_start`	`datetime`
`date_end`	`datetime`

`exhibition_cost`

Doctrine entity: Event\Entity\Exhibition\Cost

Column	Doctrine type	Key
`cost_id`	`integer`
`cost`	`string`
`amount`	`decimal`
`exhibition_id`	`FK`	FK

`exhibition_floorplan`

Doctrine entity: Event\Entity\Exhibition\Floorplan

Column	Doctrine type	Key
`floorplan_id`	`integer`
`floorplan`	`string`
`object`	`blob`
`ppm`	`decimal`
`date_created`	`datetime`
`date_updated`	`datetime`
`pixel_width`	`decimal`
`pixel_height`	`decimal`
`pixel_top`	`decimal`
`pixel_left`	`decimal`
`origin_x`	`decimal`
`origin_y`	`decimal`
`mark1_x`	`decimal`
`mark1_y`	`decimal`
`mark2_x`	`decimal`
`mark2_y`	`decimal`
`mark_length`	`decimal`
`contenttype_id`	`FK`	FK
`exhibition_id`	`FK`	FK

`exhibition_floorplan_item`

Doctrine entity: Event\Entity\Exhibition\FloorplanItem

Column	Doctrine type	Key
`item_id`	`integer`
`item`	`string`
`rotation`	`decimal`
`size_x`	`decimal`
`size_y`	`decimal`
`size_z`	`decimal`
`coord_x`	`decimal`
`coord_y`	`decimal`
`floorplan_id`	`FK`	FK

`exhibition_spec`

Doctrine entity: Event\Entity\Exhibition\Spec

Column	Doctrine type	Key
`spec_id`	`integer`
`spec`	`string`
`label`	`string`
`decimals`	`smallint`
`unit`	`string`
`description`	`text`
`formula`	`text`
`costs`	`decimal`
`exhibition_id`	`FK`	FK
`type_id`	`FK`	FK
`group_id`	`FK`	FK

`exhibition_spec_form`

Doctrine entity: Event\Entity\Exhibition\SpecForm

Column	Doctrine type	Key
`form_id`	`integer`
`sequence`	`integer`
`description`	`text`
`inline_help`	`text`
`required`	`smallint`
`locked`	`smallint`
`hidden`	`smallint`
`spec_id`	`FK`	FK

`exhibition_spec_group`

Doctrine entity: Event\Entity\Exhibition\SpecGroup

Column	Doctrine type	Key
`group_id`	`integer`
`group`	`string`
`sequence`	`integer`

`exhibition_spec_type`

Doctrine entity: Event\Entity\Exhibition\SpecType

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

`exhibition_tour`

Doctrine entity: Event\Entity\Exhibition\Tour

Column	Doctrine type	Key
`tour_id`	`integer`
`date_start`	`datetime`
`unguided`	`boolean`
`tour`	`string`
`contact_id`	`FK`	FK
`exhibition_id`	`FK`	FK

`exhibition_tour_booth`

Doctrine entity: Event\Entity\Exhibition\TourBooth

Column	Doctrine type	Key
`tour_booth_id`	`integer`
`date_visit`	`datetime`
`booth_id`	`FK`	FK
`tour_id`	`FK`	FK

`exhibition_vote`

Doctrine entity: Event\Entity\Exhibition\Vote

Column	Doctrine type	Key
`vote_id`	`integer`
`sequence`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`voter_id`	`FK`	FK
`booth_id`	`FK`	FK

`exhibition_voter`

Doctrine entity: Event\Entity\Exhibition\Voter

Column	Doctrine type	Key
`voter_id`	`integer`
`exhibition_id`	`FK`	FK

`facebook`

Doctrine entity: Contact\Entity\Facebook

Column	Doctrine type	Key
`facebook_id`	`integer`
`facebook`	`string`
`public`	`smallint`
`can_send_message`	`smallint`
`from_clause`	`text`
`where_clause`	`text`
`orderby_clause`	`text`
`contact_key`	`string`
`com_extra`	`smallint`
`com_sub`	`smallint`
`show_email`	`smallint`
`show_phone`	`smallint`

`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

`funding`

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`
`status`	`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

`idea`

Doctrine entity: Idea\Entity\Idea

Column	Doctrine type	Key
`idea_id`	`integer`
`idea_nr`	`string`
`idea`	`string`
`title`	`string`
`docref`	`string`
`uid`	`string`
`has_presentation`	`smallint`
`has_poster`	`smallint`
`visibility`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`location_x`	`integer`
`location_y`	`integer`
`contact_id`	`FK`	FK
`tool_id`	`FK`	FK

`idea_challenge`

Doctrine entity: Idea\Entity\Challenge

Column	Doctrine type	Key
`idea_challenge_id`	`integer`
`challenge_id`	`FK`	FK
`idea_id`	`FK`	FK

`idea_description`

Doctrine entity: Idea\Entity\Description

Column	Doctrine type	Key
`description_id`	`integer`
`description`	`text`
`type_id`	`FK`	FK
`idea_id`	`FK`	FK

`idea_description_type`

Doctrine entity: Idea\Entity\Description\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`title`	`string`
`template`	`text`
`help_block`	`string`
`sequence`	`smallint`
`width`	`smallint`

`idea_document`

Doctrine entity: Idea\Entity\Document

Column	Doctrine type	Key
`document_id`	`integer`
`document`	`string`
`filename`	`string`
`size`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`idea_session_id`	`FK`	FK
`idea_id`	`FK`	FK

`idea_document_object`

Doctrine entity: Idea\Entity\DocumentObject

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

`idea_idea_mailing_recipient`

Doctrine entity: Idea\Entity\Idea\Mailing\Recipient

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

`idea_image`

Doctrine entity: Idea\Entity\Image

Column	Doctrine type	Key
`image_id`	`integer`
`image`	`string`
`date_created`	`datetime`
`description`	`string`
`size`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`idea_id`	`FK`	FK

`idea_image_object`

Doctrine entity: Idea\Entity\ImageObject

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

`idea_invite`

Doctrine entity: Idea\Entity\Invite

Column	Doctrine type	Key
`invite_id`	`integer`
`date_create`	`datetime`
`unique_selling_proposition`	`text`
`innovation`	`text`
`motivation`	`text`
`date_taken`	`datetime`
`type`	`smallint`
`idea_id`	`FK`	FK
`contact_id`	`FK`	FK
`invited_contact_id`	`FK`	FK

`idea_meeting`

Doctrine entity: Idea\Entity\Meeting

Column	Doctrine type	Key
`meeting_id`	`integer`
`calendar`	`string`
`location`	`string`
`description`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_from`	`datetime`
`date_end`	`datetime`
`access_details`	`text`
`idea_id`	`FK`	FK

`idea_meeting_invite`

Doctrine entity: Idea\Entity\Meeting\Invite

Column	Doctrine type	Key
`invite_id`	`integer`
`date_create`	`datetime`
`date_taken`	`datetime`
`type`	`smallint`
`unique_selling_proposition`	`text`
`innovation`	`text`
`motivation`	`text`
`contact_id`	`FK`	FK
`meeting_id`	`FK`	FK

`idea_meeting_participant`

Doctrine entity: Idea\Entity\Meeting\Participant

Column	Doctrine type	Key
`participant_id`	`integer`
`description`	`text`
`date_created`	`datetime`
`last_update`	`datetime`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`meeting_id`	`FK`	FK
`invite_id`	`FK`	FK

`idea_message`

Doctrine entity: Idea\Entity\Message

Column	Doctrine type	Key
`message_id`	`integer`
`message`	`text`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`idea_id`	`FK`	FK

`idea_message_document`

Doctrine entity: Idea\Entity\Message\Document

Column	Doctrine type	Key
`document_id`	`integer`
`filename`	`string`
`size`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`message_id`	`FK`	FK

`idea_message_document_object`

Doctrine entity: Idea\Entity\Message\DocumentObject

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

`idea_partner`

Doctrine entity: Idea\Entity\Partner

Column	Doctrine type	Key
`partner_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`is_admin`	`boolean`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`idea_id`	`FK`	FK

`idea_poster`

Doctrine entity: Idea\Entity\Poster\Poster

Column	Doctrine type	Key
`poster_id`	`integer`
`visibility`	`smallint`
`format`	`smallint`
`date_created`	`datetime`
`layout`	`json`
`idea_id`	`FK`	FK

`idea_poster_attachment`

Doctrine entity: Idea\Entity\Poster\Attachment

Column	Doctrine type	Key
`attachment_id`	`integer`
`attachment`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`priority`	`smallint`
`width`	`smallint`
`height`	`smallint`
`sequence`	`smallint`
`size`	`integer`
`poster_id`	`FK`	FK
`contenttype_id`	`FK`	FK

`idea_poster_attachment_object`

Doctrine entity: Idea\Entity\Poster\AttachmentObject

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

`idea_poster_pdf`

Doctrine entity: Idea\Entity\Poster\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`thumbnail`	`blob`
`html`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`poster_id`	`FK`	FK

`idea_session`

Doctrine entity: Idea\Entity\Session

Column	Doctrine type	Key
`idea_session_id`	`integer`
`schedule`	`string`
`idea_id`	`FK`	FK
`session_id`	`FK`	FK

`idea_status`

Doctrine entity: Idea\Entity\Status

Column	Doctrine type	Key
`status_id`	`integer`
`title`	`string`
`description`	`text`
`date_created`	`datetime`
`last_update`	`datetime`
`contact_id`	`FK`	FK
`idea_id`	`FK`	FK

`idea_status_document`

Doctrine entity: Idea\Entity\Status\Document

Column	Doctrine type	Key
`document_id`	`integer`
`filename`	`string`
`size`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK
`status_id`	`FK`	FK

`idea_status_document_object`

Doctrine entity: Idea\Entity\Status\DocumentObject

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

`idea_tool`

Doctrine entity: Idea\Entity\Tool

Column	Doctrine type	Key
`tool_id`	`integer`
`name`	`string`
`title`	`string`
`docref`	`string`
`description`	`text`
`has_nda`	`smallint`
`has_poster`	`smallint`
`poster_html`	`text`
`poster_master`	`json`
`has_presentation`	`smallint`
`has_workgroup_sessions`	`smallint`
`show_on_community`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_open`	`datetime`
`date_closed`	`datetime`
`deeplink_key`	`string`
`programcall_id`	`FK`	FK
`meeting_id`	`FK`	FK
`target_id`	`FK`	FK
`challenge_id`	`FK`	FK

`idea_video`

Doctrine entity: Idea\Entity\Video

Column	Doctrine type	Key
`idea_video_id`	`integer`
`title`	`text`
`type`	`smallint`
`description`	`text`
`idea_id`	`FK`	FK
`video_id`	`FK`	FK

`image`

Doctrine entity: Content\Entity\Image

Column	Doctrine type	Key
`image_id`	`integer`
`image`	`string`
`date_created`	`datetime`
`size`	`integer`
`width`	`integer`
`height`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK

`image_object`

Doctrine entity: Content\Entity\ImageObject

Column	Doctrine type	Key
`object_id`	`integer`
`object`	`blob`
`image_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

`invoice`

Doctrine entity: Invoice\Entity\Invoice

Column	Doctrine type	Key
`invoice_id`	`integer`
`branch`	`string`
`omitcontact`	`smallint`
`has_open_item_statement`	`smallint`
`date_created`	`datetime`
`date_invoice`	`datetime`
`date_sent`	`date`
`date_paid`	`date`
`amount_open`	`decimal`
`amount_total`	`decimal`
`amount_paid`	`decimal`
`invoice_nr`	`string`
`purchase_order`	`string`
`daybooknumber`	`string`
`accounting_adapter`	`smallint`
`tw_date`	`date`
`tw_open`	`decimal`
`type_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`accountingAdapter_id`	`FK`	FK
`paymentProvider_id`	`FK`	FK
`invoiceProvider_id`	`FK`	FK

`invoice_credit`

Doctrine entity: Invoice\Entity\Credit

Column	Doctrine type	Key
`credit_id`	`integer`
`invoice_nr`	`string`
`credit_nr`	`string`
`credit_invoice_id`	`FK`	FK
`orginal_invoice_id`	`FK`	FK

`invoice_journal`

Doctrine entity: Invoice\Entity\Journal

Column	Doctrine type	Key
`journal_id`	`integer`
`journal`	`text`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`organisation_contact_id`	`FK`	FK

`invoice_journal_entry`

Doctrine entity: Invoice\Entity\Journal\Entry

Column	Doctrine type	Key
`entry_id`	`integer`
`entry`	`string`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`journal_id`	`FK`	FK

`invoice_log`

Doctrine entity: Invoice\Entity\Log

Column	Doctrine type	Key
`log_id`	`integer`
`log`	`string`
`date_created`	`datetime`
`date_followup`	`datetime`
`mark`	`boolean`
`contact_id`	`FK`	FK
`invoice_id`	`FK`	FK

`invoice_mailing_recipient`

Doctrine entity: Invoice\Entity\Invoice\Mailing\Recipient

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

`invoice_message`

Doctrine entity: Invoice\Entity\Message

Column	Doctrine type	Key
`message_id`	`integer`
`message`	`string`
`invoice_id`	`FK`	FK

`invoice_method`

Doctrine entity: Invoice\Entity\Method

Column	Doctrine type	Key
`method_id`	`integer`
`method`	`string`

`invoice_payment`

Doctrine entity: Invoice\Entity\Payment

Column	Doctrine type	Key
`payment_id`	`integer`
`date_created`	`datetime`
`amount`	`decimal`
`invoice_id`	`FK`	FK

`invoice_pdf`

Doctrine entity: Invoice\Entity\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`date_created`	`datetime`
`date_end`	`datetime`
`invoice_id`	`FK`	FK

`invoice_row`

Doctrine entity: Invoice\Entity\Row

Column	Doctrine type	Key
`row_id`	`integer`
`row`	`string`
`quantity`	`decimal`
`amount`	`decimal`
`sequence`	`integer`
`code`	`string`
`dimension`	`integer`
`invoice_id`	`FK`	FK
`vat_id`	`FK`	FK

`invoice_sync`

Doctrine entity: Invoice\Entity\Sync

Column	Doctrine type	Key
`sync_id`	`integer`
`date_sync`	`datetime`
`sync`	`text`

`invoice_word`

Doctrine entity: Invoice\Entity\Word

Column	Doctrine type	Key
`word_id`	`integer`
`word`	`blob`
`date_created`	`datetime`
`date_end`	`datetime`
`invoice_id`	`FK`	FK

`keyword`

Doctrine entity: Project\Entity\Keyword

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

`language`

Doctrine entity: General\Entity\Language

Column	Doctrine type	Key
`language_id`	`integer`
`language`	`string`
`locale`	`string`
`date_created`	`datetime`
`last_update`	`datetime`

`log`

Doctrine entity: General\Entity\Log

Column	Doctrine type	Key
`id`	`integer`
`date`	`datetime`
`priority`	`string`
`errorMessage`	`text`
`url`	`string`
`file`	`string`
`line`	`integer`
`errorType`	`string`
`trace`	`text`
`request_data`	`json`

`magazine`

Doctrine entity: News\Entity\Magazine

Column	Doctrine type	Key
`magazine_id`	`integer`
`issue`	`smallint`
`title`	`string`
`sub_title`	`string`
`docref`	`string`
`hidden`	`boolean`
`type`	`smallint`
`footer_background`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_published`	`date`
`html_table_of_content`	`text`
`css_table_of_content`	`text`
`cover_image_url`	`string`

`magazine_article`

Doctrine entity: News\Entity\Magazine\Article

Column	Doctrine type	Key
`article_id`	`integer`
`title`	`string`
`sub_title`	`string`
`description`	`string`
`docref`	`string`
`page_start`	`smallint`
`page_end`	`smallint`
`hidden`	`smallint`
`layout`	`smallint`
`width`	`smallint`
`background_color`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`html`	`text`
`css`	`text`
`head_script`	`text`
`cover_image_url`	`string`
`external_link`	`string`
`magazine_id`	`FK`	FK
`contact_id`	`FK`	FK

`magazine_article_download`

Doctrine entity: News\Entity\Magazine\Article\Download

Column	Doctrine type	Key
`download_id`	`integer`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`article_id`	`FK`	FK

`magazine_article_pdf`

Doctrine entity: News\Entity\Magazine\Article\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`date_created`	`datetime`
`article_id`	`FK`	FK

`magazine_download`

Doctrine entity: News\Entity\Magazine\Download

Column	Doctrine type	Key
`download_id`	`integer`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`magazine_id`	`FK`	FK

`magazine_pdf`

Doctrine entity: News\Entity\Magazine\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`date_created`	`datetime`
`magazine_id`	`FK`	FK

`mailing`

Doctrine entity: Mailing\Entity\Mailing

Column	Doctrine type	Key
`mailing_id`	`integer`
`mailing`	`string`
`mail_html`	`text`
`mail_subject`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_last_email_sent`	`datetime`
`date_queue_start`	`datetime`
`expired_contacts`	`boolean`
`optout_contacts`	`boolean`
`date_deleted`	`datetime`
`tag`	`string`
`contact_id`	`FK`	FK
`mailtemplate_id`	`FK`	FK
`optin_id`	`FK`	FK
`meeting_id`	`FK`	FK
`sender_id`	`FK`	FK
`mailer_id`	`FK`	FK

`mailing_attachment`

Doctrine entity: Mailing\Entity\Attachment

Column	Doctrine type	Key
`attachment_id`	`integer`
`attachment`	`blob`
`filename`	`string`
`inline`	`smallint`
`contenttype`	`string`
`mailing_id`	`FK`	FK

`mailing_contact`

Doctrine entity: Mailing\Entity\Contact

Column	Doctrine type	Key
`mailing_contact_id`	`integer`
`blocked`	`boolean`
`date_sent`	`datetime`
`hash`	`string`
`contact_id`	`FK`	FK
`mailing_id`	`FK`	FK

`mailing_deeplink`

Doctrine entity: Mailing\Entity\Deeplink

Column	Doctrine type	Key
`deeplink_id`	`integer`
`date_expiration`	`date`
`expire_days`	`smallint`
`key_id`	`string`
`target_id`	`FK`	FK
`mailing_id`	`FK`	FK

`mailing_mailer`

Doctrine entity: Mailing\Entity\Mailer

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`service`	`smallint`
`hostname`	`string`
`username`	`string`
`password`	`string`
`port`	`smallint`
`ssl`	`string`
`sendGridApiKey`	`string`
`isDevelopment`	`boolean`
`isActive`	`boolean`
`oAuth2Service_id`	`FK`	FK

`mailing_queue`

Doctrine entity: Mailing\Entity\Queue

Column	Doctrine type	Key
`mailing_queue_id`	`integer`
`date_create`	`datetime`
`date_send`	`datetime`
`mailing_contact_id`	`FK`	FK
`mailing_id`	`FK`	FK

`mailing_transactional`

Doctrine entity: Mailing\Entity\Transactional

Column	Doctrine type	Key
`info_id`	`integer`
`scope`	`smallint`
`action`	`string`
`date_created`	`datetime`
`last_update`	`datetime`
`info`	`string`
`subject`	`string`
`content`	`text`
`sender_id`	`FK`	FK
`mailtemplate_id`	`FK`	FK
`mailer_id`	`FK`	FK
`target_id`	`FK`	FK

`mailing_transactional_mailing_recipient`

Doctrine entity: Mailing\Entity\Transactional\Mailing\Recipient

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

`mailing_transactional_recipient`

Doctrine entity: Mailing\Entity\Transactional\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`dateUpdated`	`datetime`
`transactional_id`	`FK`	FK
`generalMailingRecipient_id`	`FK`	FK
`affiliationMailingRecipient_id`	`FK`	FK
`calendarMailingRecipient_id`	`FK`	FK
`contactMailingRecipient_id`	`FK`	FK
`b2bEventMailingRecipient_id`	`FK`	FK
`meetingMailingRecipient_id`	`FK`	FK
`ideaMailingRecipient_id`	`FK`	FK
`invoiceMailingRecipient_id`	`FK`	FK
`organisationMailingRecipient_id`	`FK`	FK
`progressReportMailingRecipient_id`	`FK`	FK
`programMailingRecipient_id`	`FK`	FK
`changeRequestMailingRecipient_id`	`FK`	FK
`projectMailingRecipient_id`	`FK`	FK
`projectVersionMailingRecipient_id`	`FK`	FK

`mailing_version`

Doctrine entity: Mailing\Entity\Mailing\Version

Column	Doctrine type	Key
`mailing_version_id`	`integer`
`mailing`	`string`
`mail_html`	`text`
`mail_subject`	`string`
`mailing_id`	`FK`	FK

`mailingtype`

Doctrine entity: Mailing\Entity\Type

Column	Doctrine type	Key
`mailingtype_id`	`integer`
`mailingtype`	`string`

`mailtemplate`

Doctrine entity: Mailing\Entity\Template

Column	Doctrine type	Key
`mailtemplate_id`	`integer`
`mailtemplate`	`string`
`subject`	`string`
`body`	`text`
`is_active`	`boolean`
`is_default`	`boolean`
`last_update`	`datetime`

`maintenance`

Doctrine entity: General\Entity\Maintenance

Column	Doctrine type	Key
`maintenance_id`	`integer`
`name`	`string`
`maintenance_page_text`	`text`
`is_active`	`boolean`
`date_created`	`datetime`
`last_update`	`datetime`
`allow_ip`	`string`

`meeting`

Doctrine entity: Event\Entity\Meeting

Column	Doctrine type	Key
`meeting_id`	`integer`
`meeting`	`string`
`vatnumber`	`string`
`description`	`text`
`location`	`string`
`url`	`string`
`participants`	`integer`
`date_from`	`date`
`date_till`	`date`
`date_reg_open`	`date`
`date_reg_close`	`date`
`type`	`smallint`
`has_projects`	`boolean`
`has_costs`	`boolean`
`has_registration`	`boolean`
`visible`	`boolean`
`hashtag`	`string`
`html`	`text`
`css`	`text`
`country_id`	`FK`	FK
`vat_type_id`	`FK`	FK
`paymentProvider_id`	`FK`	FK
`invoiceProvider_id`	`FK`	FK
`sender_id`	`FK`	FK

`meeting_b2b_event`

Doctrine entity: Event\Entity\Meeting\B2BEvent

Column	Doctrine type	Key
`b2b_event_id`	`integer`
`deeplink_key`	`string`
`meeting_id`	`FK`	FK
`target_id`	`FK`	FK

`meeting_b2b_event_meeting`

Doctrine entity: Event\Entity\Meeting\B2BEvent\Meeting

Column	Doctrine type	Key
`meeting_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`requesterContactStatus`	`smallint`
`invitedContactStatus`	`smallint`
`timeslot_id`	`FK`	FK
`b2b_event_resource_id`	`FK`	FK
`requester_contact_id`	`FK`	FK
`invited_contact_id`	`FK`	FK

`meeting_b2b_event_meeting_mailing_recipient`

Doctrine entity: Event\Entity\Meeting\B2BEvent\Meeting\Mailing\Recipient

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

`meeting_b2b_event_meeting_message`

Doctrine entity: Event\Entity\Meeting\B2BEvent\Meeting\Message

Column	Doctrine type	Key
`message_id`	`integer`
`message`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`meeting_id`	`FK`	FK
`contact_id`	`FK`	FK

`meeting_b2b_event_resource`

Doctrine entity: Event\Entity\Meeting\B2BEvent\Resource

Column	Doctrine type	Key
`resource_id`	`integer`
`label`	`string`
`description`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`location_x`	`integer`
`location_y`	`integer`
`b2b_event_id`	`FK`	FK

`meeting_b2b_event_timeslot`

Doctrine entity: Event\Entity\Meeting\B2BEvent\Timeslot

Column	Doctrine type	Key
`timeslot_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_start`	`datetime`
`date_end`	`datetime`
`b2b_event_id`	`FK`	FK
`day_id`	`FK`	FK

`meeting_badge`

Doctrine entity: Event\Entity\Meeting\Badge

Column	Doctrine type	Key
`meeting_badge_id`	`integer`
`meeting_id`	`FK`	FK
`badge_id`	`FK`	FK

`meeting_cost`

Doctrine entity: Event\Entity\Meeting\Cost

Column	Doctrine type	Key
`cost_id`	`integer`
`cost`	`string`
`amount`	`decimal`
`amount_early_bird`	`decimal`
`early_bird_date`	`datetime`
`selection_type`	`smallint`
`vat_id`	`FK`	FK
`meeting_id`	`FK`	FK

`meeting_coupon`

Doctrine entity: Event\Entity\Meeting\Coupon

Column	Doctrine type	Key
`coupon_id`	`integer`
`hash`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_taken`	`datetime`
`date_end`	`datetime`
`registration_id`	`FK`	FK
`meeting_id`	`FK`	FK
`booth_id`	`FK`	FK

`meeting_day`

Doctrine entity: Event\Entity\Meeting\Day

Column	Doctrine type	Key
`day_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_day`	`date`
`meeting_id`	`FK`	FK

`meeting_floorplan`

Doctrine entity: Event\Entity\Meeting\Floorplan

Column	Doctrine type	Key
`floorplan_id`	`integer`
`floorplan`	`string`
`object`	`blob`
`ppm`	`decimal`
`date_created`	`datetime`
`date_updated`	`datetime`
`pixel_width`	`integer`
`pixel_height`	`integer`
`origin_x`	`decimal`
`origin_y`	`decimal`
`contenttype_id`	`FK`	FK
`meeting_id`	`FK`	FK

`meeting_mailing`

Doctrine entity: Event\Entity\Meeting\MeetingMailing

Column	Doctrine type	Key
`meeting_mailing_id`	`integer`
`mailingtype_id`	`FK`	FK
`mailing_id`	`FK`	FK
`meeting_id`	`FK`	FK

`meeting_mailing_recipient`

Doctrine entity: Event\Entity\Meeting\Mailing\Recipient

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

`meeting_option`

Doctrine entity: Event\Entity\Meeting\Option

Column	Doctrine type	Key
`option_id`	`integer`
`otype`	`string`
`ooption`	`text`
`otext`	`text`
`ovalues`	`text`
`required`	`smallint`
`is_registration_fee`	`smallint`
`hidden`	`boolean`
`sort`	`smallint`
`ofriendlytext`	`text`
`meeting_id`	`FK`	FK

`meeting_option_costs`

Doctrine entity: Event\Entity\Meeting\OptionCost

Column	Doctrine type	Key
`costs_id`	`integer`
`description`	`string`
`option_values`	`string`
`amount`	`decimal`
`option_id`	`FK`	FK
`vat_id`	`FK`	FK

`meeting_quota`

Doctrine entity: Event\Entity\Meeting\Quota

Column	Doctrine type	Key
`quota_id`	`integer`
`amount`	`smallint`
`description`	`text`
`meeting_id`	`FK`	FK
`country_id`	`FK`	FK

`meeting_ticket`

Doctrine entity: Event\Entity\Meeting\Ticket

Column	Doctrine type	Key
`ticket_id`	`integer`
`size`	`integer`
`date_updated`	`datetime`
`layout`	`json`
`contenttype_id`	`FK`	FK
`meeting_id`	`FK`	FK

`meeting_ticket_object`

Doctrine entity: Event\Entity\Meeting\TicketObject

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

`meeting_transactional`

Doctrine entity: Event\Entity\Meeting\Transactional

Column	Doctrine type	Key
`meeting_transactional_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`subject`	`string`
`content`	`text`
`meeting_id`	`FK`	FK
`transactional_id`	`FK`	FK
`sender_id`	`FK`	FK
`mail_template_id`	`FK`	FK
`mailer_id`	`FK`	FK
`target_id`	`FK`	FK

`meeting_transactional_attachment`

Doctrine entity: Event\Entity\Meeting\TransactionalAttachment

Column	Doctrine type	Key
`attachment_id`	`integer`
`attachment`	`blob`
`filename`	`string`
`inline`	`smallint`
`contenttype`	`string`
`meeting_transactional_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

`news`

Doctrine entity: News\Entity\News

Column	Doctrine type	Key
`news_id`	`integer`
`news`	`string`
`subtitle`	`string`
`highlight`	`smallint`
`highlight_description`	`text`
`on_homepage`	`smallint`
`internal`	`smallint`
`hidden`	`smallint`
`date_start`	`datetime`
`date_updated`	`datetime`
`date_published`	`datetime`
`bodytxt`	`text`
`css`	`text`
`docref`	`string`
`external_link`	`string`
`image_url`	`string`

`news_category`

Doctrine entity: News\Entity\News\Category

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

`node`

Doctrine entity: Content\Entity\Node

Column	Doctrine type	Key
`node_id`	`integer`
`title`	`string`
`start_date`	`datetime`
`uri`	`string`
`hide_from_navigation`	`smallint`
`node_content`	`smallint`
`twig_content`	`text`
`style`	`text`
`javascript`	`text`
`template_id`	`FK`	FK
`layout_template_id`	`FK`	FK
`route_id`	`FK`	FK

`node_tree`

Doctrine entity: Content\Entity\Tree

Column	Doctrine type	Key
`tree_id`	`integer`
`sequence`	`integer`
`child_node_id`	`FK`	FK
`parent_node_id`	`FK`	FK

`node_version`

Doctrine entity: Content\Entity\Node\Version

Column	Doctrine type	Key
`node_version_id`	`integer`
`date_created`	`datetime`
`title`	`string`
`twig_content`	`text`
`style`	`text`
`javascript`	`text`
`node_id`	`FK`	FK

`oauth_access_tokens`

Doctrine entity: Api\Entity\OAuth\AccessToken

Column	Doctrine type	Key
`id`	`integer`
`access_token`	`text`
`expires`	`datetime_immutable`
`scope`	`string`
`client_id`	`FK`	FK
`user_id`	`FK`	FK

`oauth_authorization_codes`

Doctrine entity: Api\Entity\OAuth\AuthorizationCode

Column	Doctrine type	Key
`id`	`integer`
`authorization_code`	`string`
`expires`	`datetime_immutable`
`redirect_uri`	`string`
`scope`	`string`
`id_token`	`string`
`code_challenge`	`string`
`code_challenge_method`	`string`
`client_id`	`FK`	FK
`user_id`	`FK`	FK

`oauth_clients`

Doctrine entity: Api\Entity\OAuth\Client

Column	Doctrine type	Key
`client_id`	`string`
`client_secret`	`string`
`name`	`string`
`description`	`text`
`client_secret_teaser`	`string`
`redirect_uri`	`string`
`grant_types`	`string`
`scope_id`	`FK`	FK

`oauth_jwt`

Doctrine entity: Api\Entity\OAuth\Jwt

Column	Doctrine type	Key
`id`	`integer`
`public_key`	`string`
`subject`	`string`
`client_id`	`FK`	FK

`oauth_public_keys`

Doctrine entity: Api\Entity\OAuth\PublicKey

Column	Doctrine type	Key
`id`	`integer`
`public_key`	`text`
`private_key`	`text`
`encryption_algorithm`	`string`
`client_id`	`FK`	FK

`oauth_refresh_tokens`

Doctrine entity: Api\Entity\OAuth\RefreshToken

Column	Doctrine type	Key
`id`	`integer`
`refresh_token`	`string`
`expires`	`datetime_immutable`
`scope`	`string`
`client_id`	`FK`	FK
`user_id`	`FK`	FK

`oauth_scopes`

Doctrine entity: Api\Entity\OAuth\Scope

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`scope`	`string`
`is_default`	`boolean`

`optin`

Doctrine entity: Contact\Entity\OptIn

Column	Doctrine type	Key
`optin_id`	`integer`
`optin`	`string`
`active`	`integer`
`description`	`string`

`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

`password`

Doctrine entity: General\Entity\Password

Column	Doctrine type	Key
`password_id`	`integer`
`description`	`string`
`website`	`string`
`accountname`	`string`
`username`	`string`
`password`	`string`

`permit_contact`

Doctrine entity: Admin\Entity\Permit\Contact

Column	Doctrine type	Key
`key_id`	`integer`
`contact_id`	`FK`	FK
`role_id`	`FK`	FK
`setter_id`	`FK`	FK
`access_id`	`FK`	FK

`permit_entity`

Doctrine entity: Admin\Entity\Permit\Entity

Column	Doctrine type	Key
`entity_id`	`integer`
`entity`	`string`
`underscore_full_entity_name`	`string`

`permit_role`

Doctrine entity: Admin\Entity\Permit\Role

Column	Doctrine type	Key
`role_id`	`integer`
`role`	`string`
`entity_id`	`FK`	FK

`permit_setter`

Doctrine entity: Admin\Entity\Permit\Setter

Column	Doctrine type	Key
`setter_id`	`integer`
`setter`	`string`
`entity_key`	`string`
`from_clause`	`text`
`where_clause`	`text`
`contact_key`	`string`
`entity_id`	`FK`	FK

`phone_type`

Doctrine entity: Contact\Entity\PhoneType

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

`press_article`

Doctrine entity: Press\Entity\Article

Column	Doctrine type	Key
`article_id`	`integer`
`article`	`string`
`highlight`	`smallint`
`highlight_description`	`text`
`hidden`	`integer`
`docRef`	`string`
`url`	`string`
`date_released`	`date`
`date_created`	`date`
`date_updated`	`date`
`content`	`text`
`keywords`	`string`
`size`	`integer`
`language`	`string`
`bureau_id`	`FK`	FK
`contenttype_id`	`FK`	FK

`press_article_object`

Doctrine entity: Press\Entity\ArticleObject

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

`press_bureau`

Doctrine entity: Press\Entity\Bureau

Column	Doctrine type	Key
`bureau_id`	`integer`
`bureau`	`string`

`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

`programcall_session`

Doctrine entity: Idea\Entity\Tool\Session

Column	Doctrine type	Key
`session_id`	`integer`
`session`	`string`
`quota`	`smallint`
`minutes_per_presentation`	`smallint`
`open_for_registration`	`smallint`
`date_from`	`datetime`
`date_end`	`datetime`
`tool_id`	`FK`	FK

`programcall_session_participant`

Doctrine entity: Idea\Entity\Tool\Session\Participant

Column	Doctrine type	Key
`participant_id`	`integer`
`date_created`	`datetime`
`last_update`	`datetime`
`contact_id`	`FK`	FK
`session_id`	`FK`	FK

`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`
`status`	`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`
`status`	`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_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_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_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

`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_report`

Doctrine entity: ProgressReport\Entity\Report

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

`project_report_criterion`

Doctrine entity: ProgressReport\Entity\Report\Criterion

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

`project_report_criterion_category`

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

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

`project_report_criterion_type`

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

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

`project_report_criterion_version`

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

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

`project_report_effort_spent`

Doctrine entity: ProgressReport\Entity\Effort\Spent

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

`project_report_email_message`

Doctrine entity: ProgressReport\Entity\Report\EmailMessage

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

`project_report_item`

Doctrine entity: ProgressReport\Entity\Item

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

`project_report_item_object`

Doctrine entity: ProgressReport\Entity\ItemObject

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

`project_report_mailing_recipient`

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

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

`project_report_result`

Doctrine entity: ProgressReport\Entity\Report\Result

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

`project_report_result_affiliation_result`

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

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

`project_report_result_deliverable_result`

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

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

`project_report_result_milestone_result`

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

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

`project_report_review`

Doctrine entity: ProgressReport\Entity\Reviewer

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

`project_report_type`

Doctrine entity: ProgressReport\Entity\Report\Type

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

`project_report_version`

Doctrine entity: ProgressReport\Entity\Report\Version

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

`project_report_window`

Doctrine entity: ProgressReport\Entity\Window

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

`project_report_window_project`

Doctrine entity: ProgressReport\Entity\Window\Project

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

`project_report_workpackage_description`

Doctrine entity: ProgressReport\Entity\Workpackage\Description

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

`project_review`

Doctrine entity: Evaluation\Entity\Reviewer

Column	Doctrine type	Key
`review_id`	`integer`
`project_id`	`FK`	FK
`contact_id`	`FK`	FK
`type_id`	`FK`	FK

`project_review_contact`

Doctrine entity: Evaluation\Entity\Reviewer\Contact

Column	Doctrine type	Key
`review_contact_id`	`integer`
`handle`	`string`
`contact_id`	`FK`	FK

`project_review_type`

Doctrine entity: Evaluation\Entity\Reviewer\Type

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

`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

`publication`

Doctrine entity: Publication\Entity\Publication

Column	Doctrine type	Key
`publication_id`	`integer`
`publication`	`string`
`docref`	`string`
`description`	`text`
`date_created`	`datetime`
`size`	`integer`
`orginal`	`string`
`tag`	`string`
`sequence`	`integer`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`type_id`	`FK`	FK

`publication_download`

Doctrine entity: Publication\Entity\Download

Column	Doctrine type	Key
`download_id`	`integer`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`publication_id`	`FK`	FK

`publication_object`

Doctrine entity: Publication\Entity\PublicationObject

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

`publication_type`

Doctrine entity: Publication\Entity\Type

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

`publication_type_category`

Doctrine entity: Publication\Entity\Category

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

`quality_action`

Doctrine entity: Quality\Entity\Action

Column	Doctrine type	Key
`action_id`	`integer`
`action`	`string`
`sequence`	`smallint`
`participants`	`string`
`deadline`	`string`
`how_evaluated`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_archived`	`datetime`
`process_id`	`FK`	FK
`year_id`	`FK`	FK
`source_id`	`FK`	FK
`contact_id`	`FK`	FK
`group_id`	`FK`	FK

`quality_action_group`

Doctrine entity: Quality\Entity\Action\Group

Column	Doctrine type	Key
`group_id`	`integer`
`group`	`string`
`type`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`

`quality_action_result`

Doctrine entity: Quality\Entity\Action\Result

Column	Doctrine type	Key
`result_id`	`integer`
`description`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`action_id`	`FK`	FK
`phase_id`	`FK`	FK
`status_id`	`FK`	FK

`quality_action_source`

Doctrine entity: Quality\Entity\Action\Source

Column	Doctrine type	Key
`source_id`	`integer`
`source`	`string`
`sequence`	`integer`
`active`	`boolean`
`date_created`	`datetime`
`date_updated`	`datetime`

`quality_dashboard_category`

Doctrine entity: Quality\Entity\Dashboard\Category

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

`quality_dashboard_type`

Doctrine entity: Quality\Entity\Dashboard\Type

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

`quality_kpi`

Doctrine entity: Quality\Entity\Kpi

Column	Doctrine type	Key
`kpi_id`	`integer`
`sequence`	`smallint`
`sequence_dashboard`	`smallint`
`kpi`	`string`
`unit`	`string`
`show_on_dashboard`	`boolean`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_archived`	`datetime`
`process_id`	`FK`	FK
`group_id`	`FK`	FK
`dashboard_type_id`	`FK`	FK
`year_id`	`FK`	FK
`contact_id`	`FK`	FK

`quality_kpi_group`

Doctrine entity: Quality\Entity\Kpi\Group

Column	Doctrine type	Key
`group_id`	`integer`
`group`	`string`
`sequence`	`smallint`
`background_color`	`string`
`front_color`	`string`
`type`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`

`quality_kpi_result`

Doctrine entity: Quality\Entity\Kpi\Result

Column	Doctrine type	Key
`result_id`	`integer`
`value`	`decimal`
`not_applicable`	`boolean`
`comments`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`kpi_id`	`FK`	FK
`phase_id`	`FK`	FK
`status_id`	`FK`	FK

`quality_kpi_target`

Doctrine entity: Quality\Entity\Kpi\Target

Column	Doctrine type	Key
`kpi_target_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`min_value`	`decimal`
`max_value`	`decimal`
`include_equal`	`boolean`
`cause_analysis`	`text`
`corrective_action`	`text`
`target_id`	`FK`	FK
`kpi_id`	`FK`	FK

`quality_phase`

Doctrine entity: Quality\Entity\Phase

Column	Doctrine type	Key
`phase_id`	`integer`
`phase`	`string`
`sequence`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`active_for_kpi`	`boolean`
`active_for_actions`	`boolean`
`show_on_dashboard`	`boolean`
`type_id`	`FK`	FK
`year_id`	`FK`	FK

`quality_phase_type`

Doctrine entity: Quality\Entity\Phase\Type

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

`quality_process`

Doctrine entity: Quality\Entity\Process

Column	Doctrine type	Key
`process_id`	`integer`
`sequence`	`integer`
`process`	`string`
`background_color`	`string`
`front_color`	`string`

`quality_status`

Doctrine entity: Quality\Entity\Status

Column	Doctrine type	Key
`status_id`	`integer`
`status`	`string`
`score`	`smallint`
`lower_bound`	`decimal`
`upper_bound`	`decimal`
`color`	`string`
`background_color`	`string`
`sequence`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`active`	`boolean`

`quality_target`

Doctrine entity: Quality\Entity\Target

Column	Doctrine type	Key
`target_id`	`integer`
`target`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`active`	`boolean`
`year_id`	`FK`	FK

`quality_year`

Doctrine entity: Quality\Entity\Year

Column	Doctrine type	Key
`year_id`	`integer`
`year`	`smallint`
`color`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`

`registration`

Doctrine entity: Event\Entity\Registration

Column	Doctrine type	Key
`registration_id`	`integer`
`hide_in_list`	`smallint`
`overbooked`	`smallint`
`b2b_available_for_meetings`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_end`	`datetime`
`is_active`	`boolean`
`contact_id`	`FK`	FK
`meeting_id`	`FK`	FK

`registration_desk`

Doctrine entity: Event\Entity\Registration\Desk

Column	Doctrine type	Key
`desk_id`	`integer`
`date_created`	`datetime`
`date_sent`	`datetime`
`date_desk`	`datetime`
`date_payment_pending`	`datetime`
`registration_id`	`FK`	FK

`registration_financial`

Doctrine entity: Event\Entity\Registration\Financial

Column	Doctrine type	Key
`registration_financial_id`	`integer`
`branch`	`string`
`purchase_order`	`string`
`registration_id`	`FK`	FK
`organisation_id`	`FK`	FK
`vat_type_id`	`FK`	FK

`registration_invoice`

Doctrine entity: Event\Entity\Registration\Invoice

Column	Doctrine type	Key
`registration_invoice_id`	`integer`
`registration_id`	`FK`	FK
`transaction_id`	`FK`	FK
`invoice_id`	`FK`	FK

`registration_option`

Doctrine entity: Event\Entity\Registration\Option

Column	Doctrine type	Key
`registration_option_id`	`integer`
`value`	`text`
`option_id`	`FK`	FK
`registration_id`	`FK`	FK

`reminder`

Doctrine entity: Invoice\Entity\Reminder

Column	Doctrine type	Key
`reminder_id`	`integer`
`date_reminded`	`datetime`
`date_created`	`datetime`
`description`	`text`
`size`	`integer`
`date_updated`	`datetime`
`branch`	`string`
`journal_id`	`FK`	FK
`type_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`reminder_pdf`

Doctrine entity: Invoice\Entity\Reminder\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`object`	`blob`
`reminder_id`	`FK`	FK
`invoice_id`	`FK`	FK

`reminder_type`

Doctrine entity: Invoice\Entity\Reminder\Type

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

`reporting_storage_location`

Doctrine entity: Reporting\Entity\StorageLocation

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`connectionString`	`text`
`exportFileType`	`string`
`container`	`string`
`folder`	`string`
`oAuth2Service_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`

`selection`

Doctrine entity: Contact\Entity\Selection

Column	Doctrine type	Key
`selection_id`	`integer`
`selection`	`string`
`tag`	`string`
`date_created`	`datetime`
`date_deleted`	`datetime`
`amountOfContacts`	`integer`
`note`	`text`
`contact_id`	`FK`	FK
`type_id`	`FK`	FK
`meeting_id`	`FK`	FK

`selection_contact`

Doctrine entity: Contact\Entity\SelectionContact

Column	Doctrine type	Key
`selection_contact_id`	`integer`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`selection_id`	`FK`	FK

`selection_sql`

Doctrine entity: Contact\Entity\SelectionSql

Column	Doctrine type	Key
`sql_id`	`integer`
`sql_query`	`text`
`selection_id`	`FK`	FK

`selection_type`

Doctrine entity: Contact\Entity\Selection\Type

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

`sender`

Doctrine entity: Mailing\Entity\Sender

Column	Doctrine type	Key
`sender_id`	`integer`
`sender`	`string`
`sender_type`	`smallint`
`email`	`string`
`is_active`	`boolean`
`is_default`	`boolean`

`session`

Doctrine entity: Admin\Entity\Session

Column	Doctrine type	Key
`session_id`	`integer`
`session_key`	`string`
`session_name`	`string`
`ip`	`string`
`date_start`	`datetime`
`date_end`	`datetime`
`modified`	`integer`
`lifetime`	`integer`
`hits`	`integer`
`data`	`object`
`contact_id`	`FK`	FK

`session_pageview`

Doctrine entity: Admin\Entity\Pageview

Column	Doctrine type	Key
`pageview_id`	`integer`
`session_key`	`string`
`date`	`datetime`
`route`	`string`
`namespace`	`string`
`controller`	`string`
`action`	`string`
`params`	`text`
`contact_id`	`FK`	FK

`tag`

Doctrine entity: News\Entity\Blog\Tag

Column	Doctrine type	Key
`tag_id`	`integer`
`tag`	`string`
`docref`	`string`

`title`

Doctrine entity: General\Entity\Title

Column	Doctrine type	Key
`title_id`	`integer`
`title`	`string`
`attention`	`string`
`salutation`	`string`

`transaction`

Doctrine entity: Accounting\Entity\PaymentProvider\Transaction

Column	Doctrine type	Key
`transaction_id`	`integer`
`description`	`string`
`amount`	`decimal`
`amount_refunded`	`decimal`
`amount_remaining`	`decimal`
`method`	`string`
`status`	`string`
`metadata`	`string`
`payment_identifier`	`string`
`date_created`	`datetime`
`date_cancelled`	`datetime`
`date_expired`	`datetime`
`date_paid`	`datetime`
`hash`	`string`
`paymentProvider_id`	`FK`	FK

`vat`

Doctrine entity: General\Entity\Vat

Column	Doctrine type	Key
`vat_id`	`integer`
`vat_code`	`string`
`vat_percentage`	`decimal`
`vat_date_start`	`date`
`country_id`	`FK`	FK

`vat_dimension`

Doctrine entity: Invoice\Entity\Vat\Dimension

Column	Doctrine type	Key
`vat_dimension_id`	`integer`
`dimension`	`string`
`ledger`	`string`
`vat_id`	`FK`	FK
`vat_type_id`	`FK`	FK

`vat_type`

Doctrine entity: General\Entity\VatType

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`description`	`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

`video`

Doctrine entity: Content\Entity\Video

Column	Doctrine type	Key
`video_id`	`integer`
`uri`	`string`
`link`	`string`
`filename`	`string`
`description`	`text`
`thumbnail`	`array`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_released`	`datetime`
`privacy`	`array`
`embed`	`array`
`width`	`integer`
`height`	`integer`
`duration`	`integer`

`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
`access`	`selection`	Many-to-many	`0..*`	`0..*`	`selection`	`[access]0..-selection 0..>[selection]`
`accounting_adapter`	`oAuth2Service`	Many-to-one	`0..*`	`0..1`	`admin_oauth2_service`	`[accounting_adapter]0..*-oAuth2Service 0..1>[admin_oauth2_service]`
`accounting_invoice_provider_client`	`invoiceProvider`	Many-to-one	`0..*`	`1`	`accounting_invoice_provider`	`[accounting_invoice_provider_client]0..*-invoiceProvider 1>[accounting_invoice_provider]`
`accounting_invoice_provider_client`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[accounting_invoice_provider_client]0..1-contact 1>[contact]`
`accounting_invoice_provider_invoice`	`invoiceProvider`	Many-to-one	`0..*`	`1`	`accounting_invoice_provider`	`[accounting_invoice_provider_invoice]0..*-invoiceProvider 1>[accounting_invoice_provider]`
`accounting_invoice_provider_invoice`	`invoice`	One-to-one	`0..1`	`1`	`invoice`	`[accounting_invoice_provider_invoice]0..1-invoice 1>[invoice]`
`address_type_sort`	`mainType`	Many-to-one	`0..*`	`1`	`address_type`	`[address_type_sort]0..*-mainType 1>[address_type]`
`address_type_sort`	`subType`	Many-to-one	`0..*`	`1`	`address_type`	`[address_type_sort]0..*-subType 1>[address_type]`
`admin_authentication`	`oAuth2Service`	Many-to-one	`0..*`	`0..1`	`admin_oauth2_service`	`[admin_authentication]0..*-oAuth2Service 0..1>[admin_oauth2_service]`
`admin_oauth2_service`	`scope`	Many-to-one	`0..*`	`1`	`oauth_scopes`	`[admin_oauth2_service]0..*-scope 1>[oauth_scopes]`
`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`	`version`	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`	`version`	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`	`version`	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`	`version`	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]`
`article`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[article]0..-access 0..>[access]`
`article`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[article]0..-project 0..>[project]`
`article_version`	`sourceArticle`	Many-to-one	`0..*`	`1`	`article`	`[article_version]0..*-sourceArticle 1>[article]`
`badge`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[badge]0..*-contact 1>[contact]`
`badge`	`selection`	Many-to-one	`0..*`	`1`	`selection`	`[badge]0..*-selection 1>[selection]`
`badge_attachment`	`badge`	Many-to-one	`0..*`	`1`	`badge`	`[badge_attachment]0..*-badge 1>[badge]`
`badge_attachment`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[badge_attachment]0..*-contentType 1>[contenttype]`
`badge_attachment`	`selections`	Many-to-many	`0..*`	`0..*`	`selection`	`[badge_attachment]0..-selections 0..>[selection]`
`badge_attachment_object`	`attachment`	Many-to-one	`0..*`	`1`	`badge_attachment`	`[badge_attachment_object]0..*-attachment 1>[badge_attachment]`
`badge_contact`	`badge`	Many-to-one	`0..*`	`1`	`badge`	`[badge_contact]0..*-badge 1>[badge]`
`badge_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[badge_contact]0..*-contact 1>[contact]`
`blog`	`category`	Many-to-many	`0..*`	`0..*`	`category`	`[blog]0..-category 0..>[category]`
`blog`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[blog]0..*-contact 1>[contact]`
`blog`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[blog]0..-project 0..>[project]`
`blog`	`tag`	Many-to-many	`0..*`	`0..*`	`tag`	`[blog]0..-tag 0..>[tag]`
`blog_message`	`blog`	Many-to-one	`0..*`	`1`	`blog`	`[blog_message]0..*-blog 1>[blog]`
`blog_message`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[blog_message]0..*-contact 1>[contact]`
`booth`	`exhibition`	Many-to-one	`0..*`	`1`	`exhibition`	`[booth]0..*-exhibition 1>[exhibition]`
`booth_challenge`	`booth`	Many-to-one	`0..*`	`1`	`booth`	`[booth_challenge]0..*-booth 1>[booth]`
`booth_challenge`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[booth_challenge]0..*-challenge 1>[challenge]`
`booth_contact`	`booth`	Many-to-one	`0..*`	`1`	`booth`	`[booth_contact]0..*-booth 1>[booth]`
`booth_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[booth_contact]0..*-contact 1>[contact]`
`booth_financial`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[booth_financial]0..*-contact 1>[contact]`
`booth_financial`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[booth_financial]0..*-organisation 1>[organisation]`
`booth_financial`	`booth`	One-to-one	`0..1`	`1`	`booth`	`[booth_financial]0..1-booth 1>[booth]`
`booth_financial_invoice`	`boothFinancial`	One-to-one	`0..1`	`1`	`booth_financial`	`[booth_financial_invoice]0..1-boothFinancial 1>[booth_financial]`
`booth_financial_invoice`	`invoice`	One-to-one	`0..1`	`1`	`invoice`	`[booth_financial_invoice]0..1-invoice 1>[invoice]`
`booth_spec`	`booth`	Many-to-one	`0..*`	`1`	`booth`	`[booth_spec]0..*-booth 1>[booth]`
`booth_spec`	`exhibitionSpec`	Many-to-one	`0..*`	`1`	`exhibition_spec`	`[booth_spec]0..*-exhibitionSpec 1>[exhibition_spec]`
`calendar`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[calendar]0..*-contact 1>[contact]`
`calendar`	`type`	Many-to-one	`0..*`	`1`	`calendar_type`	`[calendar]0..*-type 1>[calendar_type]`
`calendar`	`meeting`	One-to-one	`0..1`	`0..1`	`meeting`	`[calendar]0..1-meeting 0..1>[meeting]`
`calendar_contact`	`calendar`	Many-to-one	`0..*`	`1`	`calendar`	`[calendar_contact]0..*-calendar 1>[calendar]`
`calendar_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[calendar_contact]0..*-contact 1>[contact]`
`calendar_contact`	`role`	Many-to-one	`0..*`	`1`	`calendar_contact_role`	`[calendar_contact]0..*-role 1>[calendar_contact_role]`
`calendar_contact`	`status`	Many-to-one	`0..*`	`1`	`calendar_contact_status`	`[calendar_contact]0..*-status 1>[calendar_contact_status]`
`calendar_document`	`calendar`	Many-to-one	`0..*`	`1`	`calendar`	`[calendar_document]0..*-calendar 1>[calendar]`
`calendar_document`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[calendar_document]0..*-contact 1>[contact]`
`calendar_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[calendar_document]0..*-contentType 1>[contenttype]`
`calendar_document_object`	`document`	Many-to-one	`0..*`	`1`	`calendar_document`	`[calendar_document_object]0..*-document 1>[calendar_document]`
`calendar_email_message`	`calendar`	Many-to-one	`0..*`	`1`	`calendar`	`[calendar_email_message]0..*-calendar 1>[calendar]`
`calendar_email_message`	`emailMessage`	Many-to-one	`0..*`	`1`	`email_message`	`[calendar_email_message]0..*-emailMessage 1>[email_message]`
`calendar_type`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[calendar_type]0..-access 0..>[access]`
`challenge`	`call`	Many-to-many	`0..*`	`0..*`	`programcall`	`[challenge]0..-call 0..>[programcall]`
`challenge`	`type`	Many-to-one	`0..*`	`1`	`challenge_type`	`[challenge]0..*-type 1>[challenge_type]`
`challenge_icon`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[challenge_icon]0..*-challenge 1>[challenge]`
`challenge_icon`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[challenge_icon]0..*-contentType 1>[contenttype]`
`challenge_idea_poster_icon`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[challenge_idea_poster_icon]0..*-challenge 1>[challenge]`
`challenge_idea_poster_icon`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[challenge_idea_poster_icon]0..*-contentType 1>[contenttype]`
`challenge_idea_poster_image`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[challenge_idea_poster_image]0..*-challenge 1>[challenge]`
`challenge_idea_poster_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[challenge_idea_poster_image]0..*-contentType 1>[contenttype]`
`challenge_image`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[challenge_image]0..*-challenge 1>[challenge]`
`challenge_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[challenge_image]0..*-contentType 1>[contenttype]`
`challenge_pdf`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[challenge_pdf]0..*-challenge 1>[challenge]`
`cluster_cluster_logo`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[cluster_cluster_logo]0..*-contentType 1>[contenttype]`
`cluster_cluster_logo`	`cluster`	One-to-one	`0..1`	`1`	`cluster_cluster`	`[cluster_cluster_logo]0..1-cluster 1>[cluster_cluster]`
`cluster_platform_exchange`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[cluster_platform_exchange]0..*-platform 1>[cluster_platform]`
`cluster_platform_exchange`	`sourceCluster`	Many-to-one	`0..*`	`0..1`	`cluster_cluster`	`[cluster_platform_exchange]0..*-sourceCluster 0..1>[cluster_cluster]`
`cluster_platform_exchange_log`	`exchange`	Many-to-one	`0..*`	`1`	`cluster_platform_exchange`	`[cluster_platform_exchange_log]0..*-exchange 1>[cluster_platform_exchange]`
`cluster_platform_exchange_log`	`project`	Many-to-one	`0..*`	`1`	`project`	`[cluster_platform_exchange_log]0..*-project 1>[project]`
`cluster_platform_exchange_project_selection`	`exchange`	Many-to-one	`0..*`	`1`	`cluster_platform_exchange`	`[cluster_platform_exchange_project_selection]0..*-exchange 1>[cluster_platform_exchange]`
`cluster_platform_exchange_project_selection`	`selection`	Many-to-one	`0..*`	`1`	`project_selection`	`[cluster_platform_exchange_project_selection]0..*-selection 1>[project_selection]`
`contact`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[contact]0..-access 0..>[access]`
`contact`	`authentication`	Many-to-one	`0..*`	`0..1`	`admin_authentication`	`[contact]0..*-authentication 0..1>[admin_authentication]`
`contact`	`optIn`	Many-to-many	`0..*`	`0..*`	`optin`	`[contact]0..-optIn 0..>[optin]`
`contact`	`title`	Many-to-one	`0..*`	`0..1`	`title`	`[contact]0..*-title 0..1>[title]`
`contact_address`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_address]0..*-contact 1>[contact]`
`contact_address`	`country`	Many-to-one	`0..*`	`1`	`country`	`[contact_address]0..*-country 1>[country]`
`contact_address`	`type`	Many-to-one	`0..*`	`1`	`address_type`	`[contact_address]0..*-type 1>[address_type]`
`contact_dnd`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_dnd]0..*-contact 1>[contact]`
`contact_dnd`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[contact_dnd]0..*-contentType 1>[contenttype]`
`contact_dnd`	`program`	Many-to-one	`0..*`	`1`	`program`	`[contact_dnd]0..*-program 1>[program]`
`contact_dnd_object`	`dnd`	Many-to-one	`0..*`	`1`	`contact_dnd`	`[contact_dnd_object]0..*-dnd 1>[contact_dnd]`
`contact_email`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_email]0..*-contact 1>[contact]`
`contact_log`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_log]0..*-contact 1>[contact]`
`contact_log`	`createdBy`	Many-to-one	`0..*`	`1`	`contact`	`[contact_log]0..*-createdBy 1>[contact]`
`contact_note`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_note]0..*-contact 1>[contact]`
`contact_office`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[contact_office]0..1-contact 1>[contact]`
`contact_office_leave`	`officeContact`	Many-to-one	`0..*`	`1`	`contact_office`	`[contact_office_leave]0..*-officeContact 1>[contact_office]`
`contact_office_leave`	`type`	Many-to-one	`0..*`	`1`	`contact_office_leave_type`	`[contact_office_leave]0..*-type 1>[contact_office_leave_type]`
`contact_organisation`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[contact_organisation]0..*-organisation 1>[organisation]`
`contact_organisation`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[contact_organisation]0..1-contact 1>[contact]`
`contact_phone`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_phone]0..*-contact 1>[contact]`
`contact_phone`	`type`	Many-to-one	`0..*`	`1`	`phone_type`	`[contact_phone]0..*-type 1>[phone_type]`
`contact_photo`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_photo]0..*-contact 1>[contact]`
`contact_photo`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[contact_photo]0..*-contentType 1>[contenttype]`
`contact_platform`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[contact_platform]0..*-contact 1>[contact]`
`contact_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[contact_platform]0..*-platform 1>[cluster_platform]`
`contact_profile`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[contact_profile]0..1-contact 1>[contact]`
`content_route`	`routeEntity`	Many-to-one	`0..*`	`1`	`content_route_entity`	`[content_route]0..*-routeEntity 1>[content_route_entity]`
`content_route`	`startNode`	Many-to-one	`0..*`	`0..1`	`node`	`[content_route]0..*-startNode 0..1>[node]`
`content_route`	`template`	Many-to-one	`0..*`	`0..1`	`content_template`	`[content_route]0..*-template 0..1>[content_template]`
`content_route`	`ideaTool`	One-to-one	`0..1`	`0..1`	`idea_tool`	`[content_route]0..1-ideaTool 0..1>[idea_tool]`
`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]`
`country_eu`	`country`	One-to-one	`0..1`	`1`	`country`	`[country_eu]0..1-country 1>[country]`
`country_eureka`	`country`	One-to-one	`0..1`	`1`	`country`	`[country_eureka]0..1-country 1>[country]`
`country_flag`	`country`	One-to-one	`0..1`	`1`	`country`	`[country_flag]0..1-country 1>[country]`
`country_itac`	`country`	One-to-one	`0..1`	`1`	`country`	`[country_itac]0..1-country 1>[country]`
`country_page`	`country`	Many-to-one	`0..*`	`1`	`country`	`[country_page]0..*-country 1>[country]`
`country_video`	`country`	Many-to-one	`0..*`	`1`	`country`	`[country_video]0..*-country 1>[country]`
`country_video`	`video`	Many-to-one	`0..*`	`1`	`video`	`[country_video]0..*-video 1>[video]`
`currency_exchange_rate`	`currency`	Many-to-one	`0..*`	`1`	`currency`	`[currency_exchange_rate]0..*-currency 1>[currency]`
`deeplink`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[deeplink]0..*-contact 0..1>[contact]`
`deeplink`	`target`	Many-to-one	`0..*`	`1`	`deeplink_target`	`[deeplink]0..*-target 1>[deeplink_target]`
`desk_costs`	`desk`	Many-to-one	`0..*`	`1`	`registration_desk`	`[desk_costs]0..*-desk 1>[registration_desk]`
`desk_costs`	`meetingOption`	Many-to-one	`0..*`	`0..1`	`meeting_option`	`[desk_costs]0..*-meetingOption 0..1>[meeting_option]`
`desk_costs`	`transaction`	Many-to-one	`0..*`	`0..1`	`transaction`	`[desk_costs]0..*-transaction 0..1>[transaction]`
`desk_costs`	`vat`	Many-to-one	`0..*`	`1`	`vat`	`[desk_costs]0..*-vat 1>[vat]`
`desk_costs_option`	`deskCosts`	Many-to-one	`0..*`	`1`	`desk_costs`	`[desk_costs_option]0..*-deskCosts 1>[desk_costs]`
`desk_costs_option`	`registrationOption`	Many-to-one	`0..*`	`1`	`registration_option`	`[desk_costs_option]0..*-registrationOption 1>[registration_option]`
`docusign_app`	`oAuth2Service`	Many-to-one	`0..*`	`1`	`admin_oauth2_service`	`[docusign_app]0..*-oAuth2Service 1>[admin_oauth2_service]`
`docusign_envelope`	`docusignApp`	Many-to-one	`0..*`	`1`	`docusign_app`	`[docusign_envelope]0..*-docusignApp 1>[docusign_app]`
`docusign_envelope_document`	`envelope`	Many-to-one	`0..*`	`1`	`docusign_envelope`	`[docusign_envelope_document]0..*-envelope 1>[docusign_envelope]`
`docusign_envelope_document_object`	`document`	Many-to-one	`0..*`	`1`	`docusign_envelope_document`	`[docusign_envelope_document_object]0..*-document 1>[docusign_envelope_document]`
`docusign_envelope_event`	`envelope`	Many-to-one	`0..*`	`1`	`docusign_envelope`	`[docusign_envelope_event]0..*-envelope 1>[docusign_envelope]`
`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]`
`email_message`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[email_message]0..*-contact 0..1>[contact]`
`email_message`	`mailer`	Many-to-one	`0..*`	`1`	`mailing_mailer`	`[email_message]0..*-mailer 1>[mailing_mailer]`
`email_message`	`mailingContact`	Many-to-one	`0..*`	`0..1`	`mailing_contact`	`[email_message]0..*-mailingContact 0..1>[mailing_contact]`
`email_message`	`sender`	Many-to-one	`0..*`	`0..1`	`sender`	`[email_message]0..*-sender 0..1>[sender]`
`email_message`	`template`	Many-to-one	`0..*`	`0..1`	`mailtemplate`	`[email_message]0..*-template 0..1>[mailtemplate]`
`email_message_event`	`emailMessage`	Many-to-one	`0..*`	`1`	`email_message`	`[email_message_event]0..*-emailMessage 1>[email_message]`
`eureka_secretariat_staff_member`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[eureka_secretariat_staff_member]0..1-contact 1>[contact]`
`evaluation`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[evaluation]0..*-contact 1>[contact]`
`evaluation`	`country`	Many-to-one	`0..*`	`1`	`country`	`[evaluation]0..*-country 1>[country]`
`evaluation`	`project`	Many-to-one	`0..*`	`1`	`project`	`[evaluation]0..*-project 1>[project]`
`evaluation`	`status`	Many-to-one	`0..*`	`1`	`funding_status`	`[evaluation]0..*-status 1>[funding_status]`
`evaluation`	`type`	Many-to-one	`0..*`	`1`	`evaluation_type`	`[evaluation]0..*-type 1>[evaluation_type]`
`evaluation_feedback`	`status`	Many-to-one	`0..*`	`1`	`funding_status`	`[evaluation_feedback]0..*-status 1>[funding_status]`
`evaluation_feedback`	`version`	One-to-one	`0..1`	`1`	`project_version`	`[evaluation_feedback]0..1-version 1>[project_version]`
`evaluation_platform`	`evaluation`	Many-to-one	`0..*`	`1`	`evaluation`	`[evaluation_platform]0..*-evaluation 1>[evaluation]`
`evaluation_platform`	`platform`	Many-to-one	`0..*`	`1`	`cluster_platform`	`[evaluation_platform]0..*-platform 1>[cluster_platform]`
`evaluation_report2`	`version`	Many-to-one	`0..*`	`1`	`evaluation_report2_version`	`[evaluation_report2]0..*-version 1>[evaluation_report2_version]`
`evaluation_report2_criterion`	`reportTypes`	Many-to-many	`0..*`	`0..*`	`evaluation_report2_type`	`[evaluation_report2_criterion]0..-reportTypes 0..>[evaluation_report2_type]`
`evaluation_report2_criterion_type`	`category`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_category`	`[evaluation_report2_criterion_type]0..*-category 1>[evaluation_report2_criterion_category]`
`evaluation_report2_criterion_version`	`criterion`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion`	`[evaluation_report2_criterion_version]0..*-criterion 1>[evaluation_report2_criterion]`
`evaluation_report2_criterion_version`	`reportVersion`	Many-to-one	`0..*`	`1`	`evaluation_report2_version`	`[evaluation_report2_criterion_version]0..*-reportVersion 1>[evaluation_report2_version]`
`evaluation_report2_criterion_version`	`type`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_type`	`[evaluation_report2_criterion_version]0..*-type 1>[evaluation_report2_criterion_type]`
`evaluation_report2_criterion_version_topic`	`criterionVersion`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_version`	`[evaluation_report2_criterion_version_topic]0..*-criterionVersion 1>[evaluation_report2_criterion_version]`
`evaluation_report2_criterion_version_topic`	`topic`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_topic`	`[evaluation_report2_criterion_version_topic]0..*-topic 1>[evaluation_report2_criterion_topic]`
`evaluation_report2_project_report`	`evaluationReport`	One-to-one	`0..1`	`1`	`evaluation_report2`	`[evaluation_report2_project_report]0..1-evaluationReport 1>[evaluation_report2]`
`evaluation_report2_project_report`	`report`	One-to-one	`0..1`	`0..1`	`project_report`	`[evaluation_report2_project_report]0..1-report 0..1>[project_report]`
`evaluation_report2_project_report`	`reviewer`	One-to-one	`0..1`	`0..1`	`project_report_review`	`[evaluation_report2_project_report]0..1-reviewer 0..1>[project_report_review]`
`evaluation_report2_project_version`	`evaluationReport`	One-to-one	`0..1`	`1`	`evaluation_report2`	`[evaluation_report2_project_version]0..1-evaluationReport 1>[evaluation_report2]`
`evaluation_report2_project_version`	`reviewer`	One-to-one	`0..1`	`0..1`	`project_version_review`	`[evaluation_report2_project_version]0..1-reviewer 0..1>[project_version_review]`
`evaluation_report2_project_version`	`version`	One-to-one	`0..1`	`0..1`	`project_version`	`[evaluation_report2_project_version]0..1-version 0..1>[project_version]`
`evaluation_report2_result`	`criterionVersion`	Many-to-one	`0..*`	`1`	`evaluation_report2_criterion_version`	`[evaluation_report2_result]0..*-criterionVersion 1>[evaluation_report2_criterion_version]`
`evaluation_report2_result`	`evaluationReport`	Many-to-one	`0..*`	`1`	`evaluation_report2`	`[evaluation_report2_result]0..*-evaluationReport 1>[evaluation_report2]`
`evaluation_report2_type`	`versionType`	Many-to-one	`0..*`	`0..1`	`project_version_type`	`[evaluation_report2_type]0..*-versionType 0..1>[project_version_type]`
`evaluation_report2_version`	`reportType`	Many-to-one	`0..*`	`1`	`evaluation_report2_type`	`[evaluation_report2_version]0..*-reportType 1>[evaluation_report2_type]`
`evaluation_report2_version`	`topics`	Many-to-many	`0..*`	`0..*`	`evaluation_report2_criterion_topic`	`[evaluation_report2_version]0..-topics 0..>[evaluation_report2_criterion_topic]`
`evaluation_report2_window`	`reportVersion`	Many-to-one	`0..*`	`0..1`	`evaluation_report2_version`	`[evaluation_report2_window]0..*-reportVersion 0..1>[evaluation_report2_version]`
`evaluation_report2_window_project`	`project`	Many-to-one	`0..*`	`1`	`project`	`[evaluation_report2_window_project]0..*-project 1>[project]`
`evaluation_report2_window_project`	`window`	Many-to-one	`0..*`	`1`	`evaluation_report2_window`	`[evaluation_report2_window_project]0..*-window 1>[evaluation_report2_window]`
`evaluation_report2_window_project`	`evaluationReport`	One-to-one	`0..1`	`0..1`	`evaluation_report2`	`[evaluation_report2_window_project]0..1-evaluationReport 0..1>[evaluation_report2]`
`event_slideshow_slide`	`slideshow`	Many-to-one	`0..*`	`1`	`event_slideshow`	`[event_slideshow_slide]0..*-slideshow 1>[event_slideshow]`
`event_slideshow_slide_view`	`slide`	Many-to-one	`0..*`	`1`	`event_slideshow_slide`	`[event_slideshow_slide_view]0..*-slide 1>[event_slideshow_slide]`
`exhibition`	`meeting`	Many-to-many	`0..*`	`0..*`	`meeting`	`[exhibition]0..-meeting 0..>[meeting]`
`exhibition_cost`	`exemptBooth`	Many-to-many	`0..*`	`0..*`	`booth`	`[exhibition_cost]0..-exemptBooth 0..>[booth]`
`exhibition_cost`	`exhibition`	Many-to-one	`0..*`	`1`	`exhibition`	`[exhibition_cost]0..*-exhibition 1>[exhibition]`
`exhibition_floorplan`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[exhibition_floorplan]0..*-contentType 1>[contenttype]`
`exhibition_floorplan`	`exhibition`	One-to-one	`0..1`	`1`	`exhibition`	`[exhibition_floorplan]0..1-exhibition 1>[exhibition]`
`exhibition_floorplan_item`	`floorplan`	Many-to-one	`0..*`	`1`	`exhibition_floorplan`	`[exhibition_floorplan_item]0..*-floorplan 1>[exhibition_floorplan]`
`exhibition_spec`	`exhibition`	Many-to-one	`0..*`	`1`	`exhibition`	`[exhibition_spec]0..*-exhibition 1>[exhibition]`
`exhibition_spec`	`group`	Many-to-one	`0..*`	`0..1`	`exhibition_spec_group`	`[exhibition_spec]0..*-group 0..1>[exhibition_spec_group]`
`exhibition_spec`	`type`	Many-to-one	`0..*`	`1`	`exhibition_spec_type`	`[exhibition_spec]0..*-type 1>[exhibition_spec_type]`
`exhibition_spec_form`	`spec`	One-to-one	`0..1`	`1`	`exhibition_spec`	`[exhibition_spec_form]0..1-spec 1>[exhibition_spec]`
`exhibition_tour`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[exhibition_tour]0..*-contact 1>[contact]`
`exhibition_tour`	`exhibition`	Many-to-one	`0..*`	`1`	`exhibition`	`[exhibition_tour]0..*-exhibition 1>[exhibition]`
`exhibition_tour`	`tourContact`	Many-to-many	`0..*`	`0..*`	`contact`	`[exhibition_tour]0..-tourContact 0..>[contact]`
`exhibition_tour_booth`	`booth`	Many-to-one	`0..*`	`1`	`booth`	`[exhibition_tour_booth]0..*-booth 1>[booth]`
`exhibition_tour_booth`	`tour`	Many-to-one	`0..*`	`1`	`exhibition_tour`	`[exhibition_tour_booth]0..*-tour 1>[exhibition_tour]`
`exhibition_vote`	`booth`	Many-to-one	`0..*`	`1`	`booth`	`[exhibition_vote]0..*-booth 1>[booth]`
`exhibition_vote`	`voter`	Many-to-one	`0..*`	`1`	`exhibition_voter`	`[exhibition_vote]0..*-voter 1>[exhibition_voter]`
`exhibition_voter`	`contact`	Many-to-many	`0..*`	`0..*`	`contact`	`[exhibition_voter]0..-contact 0..>[contact]`
`exhibition_voter`	`exhibition`	Many-to-one	`0..*`	`1`	`exhibition`	`[exhibition_voter]0..*-exhibition 1>[exhibition]`
`facebook`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[facebook]0..-access 0..>[access]`
`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]`
`funding`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[funding]0..*-affiliation 1>[affiliation]`
`funding`	`source`	Many-to-one	`0..*`	`1`	`funding_source`	`[funding]0..*-source 1>[funding_source]`
`funding`	`status`	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]`
`idea`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[idea]0..*-contact 1>[contact]`
`idea`	`favourite`	Many-to-many	`0..*`	`0..*`	`contact`	`[idea]0..-favourite 0..>[contact]`
`idea`	`keyword`	Many-to-many	`0..*`	`0..*`	`keyword`	`[idea]0..-keyword 0..>[keyword]`
`idea`	`mainIdea`	Many-to-many	`0..*`	`0..*`	`idea`	`[idea]0..-mainIdea 0..>[idea]`
`idea`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[idea]0..-project 0..>[project]`
`idea`	`tool`	Many-to-one	`0..*`	`1`	`idea_tool`	`[idea]0..*-tool 1>[idea_tool]`
`idea_challenge`	`challenge`	Many-to-one	`0..*`	`1`	`challenge`	`[idea_challenge]0..*-challenge 1>[challenge]`
`idea_challenge`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_challenge]0..*-idea 1>[idea]`
`idea_description`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_description]0..*-idea 1>[idea]`
`idea_description`	`type`	Many-to-one	`0..*`	`1`	`idea_description_type`	`[idea_description]0..*-type 1>[idea_description_type]`
`idea_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[idea_document]0..*-contentType 1>[contenttype]`
`idea_document`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_document]0..*-idea 1>[idea]`
`idea_document`	`session`	Many-to-one	`0..*`	`0..1`	`idea_session`	`[idea_document]0..*-session 0..1>[idea_session]`
`idea_document_object`	`document`	Many-to-one	`0..*`	`1`	`idea_document`	`[idea_document_object]0..*-document 1>[idea_document]`
`idea_image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[idea_image]0..*-contentType 1>[contenttype]`
`idea_image`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_image]0..*-idea 1>[idea]`
`idea_image_object`	`image`	Many-to-one	`0..*`	`1`	`idea_image`	`[idea_image_object]0..*-image 1>[idea_image]`
`idea_invite`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[idea_invite]0..*-contact 1>[contact]`
`idea_invite`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_invite]0..*-idea 1>[idea]`
`idea_invite`	`invitedContact`	Many-to-one	`0..*`	`1`	`contact`	`[idea_invite]0..*-invitedContact 1>[contact]`
`idea_meeting`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_meeting]0..*-idea 1>[idea]`
`idea_meeting_invite`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[idea_meeting_invite]0..*-contact 1>[contact]`
`idea_meeting_invite`	`meeting`	Many-to-one	`0..*`	`1`	`idea_meeting`	`[idea_meeting_invite]0..*-meeting 1>[idea_meeting]`
`idea_meeting_participant`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[idea_meeting_participant]0..*-contact 1>[contact]`
`idea_meeting_participant`	`meeting`	Many-to-one	`0..*`	`1`	`idea_meeting`	`[idea_meeting_participant]0..*-meeting 1>[idea_meeting]`
`idea_meeting_participant`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[idea_meeting_participant]0..*-organisation 1>[organisation]`
`idea_meeting_participant`	`invite`	One-to-one	`0..1`	`0..1`	`idea_meeting_invite`	`[idea_meeting_participant]0..1-invite 0..1>[idea_meeting_invite]`
`idea_message`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[idea_message]0..*-contact 1>[contact]`
`idea_message`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_message]0..*-idea 1>[idea]`
`idea_message_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[idea_message_document]0..*-contentType 1>[contenttype]`
`idea_message_document`	`message`	Many-to-one	`0..*`	`1`	`idea_message`	`[idea_message_document]0..*-message 1>[idea_message]`
`idea_message_document_object`	`document`	Many-to-one	`0..*`	`1`	`idea_message_document`	`[idea_message_document_object]0..*-document 1>[idea_message_document]`
`idea_partner`	`associate`	Many-to-many	`0..*`	`0..*`	`contact`	`[idea_partner]0..-associate 0..>[contact]`
`idea_partner`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[idea_partner]0..*-contact 1>[contact]`
`idea_partner`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_partner]0..*-idea 1>[idea]`
`idea_partner`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[idea_partner]0..*-organisation 1>[organisation]`
`idea_poster`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_poster]0..*-idea 1>[idea]`
`idea_poster_attachment`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[idea_poster_attachment]0..*-contentType 1>[contenttype]`
`idea_poster_attachment`	`poster`	Many-to-one	`0..*`	`1`	`idea_poster`	`[idea_poster_attachment]0..*-poster 1>[idea_poster]`
`idea_poster_attachment_object`	`attachment`	Many-to-one	`0..*`	`1`	`idea_poster_attachment`	`[idea_poster_attachment_object]0..*-attachment 1>[idea_poster_attachment]`
`idea_poster_pdf`	`poster`	One-to-one	`0..1`	`1`	`idea_poster`	`[idea_poster_pdf]0..1-poster 1>[idea_poster]`
`idea_session`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_session]0..*-idea 1>[idea]`
`idea_session`	`session`	Many-to-one	`0..*`	`1`	`programcall_session`	`[idea_session]0..*-session 1>[programcall_session]`
`idea_status`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[idea_status]0..*-contact 1>[contact]`
`idea_status`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_status]0..*-idea 1>[idea]`
`idea_status_document`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[idea_status_document]0..*-contentType 1>[contenttype]`
`idea_status_document`	`status`	Many-to-one	`0..*`	`1`	`idea_status`	`[idea_status_document]0..*-status 1>[idea_status]`
`idea_status_document_object`	`document`	Many-to-one	`0..*`	`1`	`idea_status_document`	`[idea_status_document_object]0..*-document 1>[idea_status_document]`
`idea_tool`	`challenge`	Many-to-many	`0..*`	`0..*`	`challenge`	`[idea_tool]0..-challenge 0..>[challenge]`
`idea_tool`	`deeplinkTarget`	Many-to-one	`0..*`	`0..1`	`deeplink_target`	`[idea_tool]0..*-deeplinkTarget 0..1>[deeplink_target]`
`idea_tool`	`descriptionType`	Many-to-many	`0..*`	`0..*`	`idea_description_type`	`[idea_tool]0..-descriptionType 0..>[idea_description_type]`
`idea_tool`	`pinnedChallenge`	Many-to-one	`0..*`	`0..1`	`challenge`	`[idea_tool]0..*-pinnedChallenge 0..1>[challenge]`
`idea_tool`	`call`	One-to-one	`0..1`	`0..1`	`programcall`	`[idea_tool]0..1-call 0..1>[programcall]`
`idea_tool`	`meeting`	One-to-one	`0..1`	`0..1`	`meeting`	`[idea_tool]0..1-meeting 0..1>[meeting]`
`idea_video`	`idea`	Many-to-one	`0..*`	`1`	`idea`	`[idea_video]0..*-idea 1>[idea]`
`idea_video`	`video`	Many-to-one	`0..*`	`1`	`video`	`[idea_video]0..*-video 1>[video]`
`image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[image]0..*-contentType 1>[contenttype]`
`image_object`	`image`	Many-to-one	`0..*`	`1`	`image`	`[image_object]0..*-image 1>[image]`
`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]`
`invoice`	`accountingAdapter`	Many-to-one	`0..*`	`0..1`	`accounting_adapter`	`[invoice]0..*-accountingAdapter 0..1>[accounting_adapter]`
`invoice`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice]0..*-contact 1>[contact]`
`invoice`	`invoiceProvider`	Many-to-one	`0..*`	`0..1`	`accounting_invoice_provider`	`[invoice]0..*-invoiceProvider 0..1>[accounting_invoice_provider]`
`invoice`	`journal`	Many-to-many	`0..*`	`0..*`	`invoice_journal`	`[invoice]0..-journal 0..>[invoice_journal]`
`invoice`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[invoice]0..*-organisation 1>[organisation]`
`invoice`	`paymentProvider`	Many-to-one	`0..*`	`0..1`	`accounting_payment_provider`	`[invoice]0..*-paymentProvider 0..1>[accounting_payment_provider]`
`invoice`	`vatType`	Many-to-one	`0..*`	`1`	`vat_type`	`[invoice]0..*-vatType 1>[vat_type]`
`invoice_credit`	`creditInvoice`	One-to-one	`0..1`	`1`	`invoice`	`[invoice_credit]0..1-creditInvoice 1>[invoice]`
`invoice_credit`	`originalInvoice`	One-to-one	`0..1`	`1`	`invoice`	`[invoice_credit]0..1-originalInvoice 1>[invoice]`
`invoice_journal`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_journal]0..*-contact 1>[contact]`
`invoice_journal`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[invoice_journal]0..*-organisation 1>[organisation]`
`invoice_journal`	`organisationContact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_journal]0..*-organisationContact 1>[contact]`
`invoice_journal_entry`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_journal_entry]0..*-contact 1>[contact]`
`invoice_journal_entry`	`journal`	Many-to-one	`0..*`	`1`	`invoice_journal`	`[invoice_journal_entry]0..*-journal 1>[invoice_journal]`
`invoice_log`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_log]0..*-contact 1>[contact]`
`invoice_log`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_log]0..*-invoice 1>[invoice]`
`invoice_message`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_message]0..*-invoice 1>[invoice]`
`invoice_payment`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_payment]0..*-invoice 1>[invoice]`
`invoice_pdf`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_pdf]0..*-invoice 1>[invoice]`
`invoice_row`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_row]0..*-invoice 1>[invoice]`
`invoice_row`	`vat`	Many-to-one	`0..*`	`1`	`vat`	`[invoice_row]0..*-vat 1>[vat]`
`invoice_word`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_word]0..*-invoice 1>[invoice]`
`magazine_article`	`blog`	Many-to-many	`0..*`	`0..*`	`blog`	`[magazine_article]0..-blog 0..>[blog]`
`magazine_article`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[magazine_article]0..*-contact 1>[contact]`
`magazine_article`	`country`	Many-to-many	`0..*`	`0..*`	`country`	`[magazine_article]0..-country 0..>[country]`
`magazine_article`	`magazine`	Many-to-one	`0..*`	`1`	`magazine`	`[magazine_article]0..*-magazine 1>[magazine]`
`magazine_article`	`organisation`	Many-to-many	`0..*`	`0..*`	`organisation`	`[magazine_article]0..-organisation 0..>[organisation]`
`magazine_article`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[magazine_article]0..-project 0..>[project]`
`magazine_article`	`result`	Many-to-many	`0..*`	`0..*`	`result`	`[magazine_article]0..-result 0..>[result]`
`magazine_article_download`	`article`	Many-to-one	`0..*`	`1`	`magazine_article`	`[magazine_article_download]0..*-article 1>[magazine_article]`
`magazine_article_download`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[magazine_article_download]0..*-contact 0..1>[contact]`
`magazine_article_pdf`	`article`	Many-to-one	`0..*`	`1`	`magazine_article`	`[magazine_article_pdf]0..*-article 1>[magazine_article]`
`magazine_download`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[magazine_download]0..*-contact 0..1>[contact]`
`magazine_download`	`magazine`	Many-to-one	`0..*`	`1`	`magazine`	`[magazine_download]0..*-magazine 1>[magazine]`
`magazine_pdf`	`magazine`	Many-to-one	`0..*`	`1`	`magazine`	`[magazine_pdf]0..*-magazine 1>[magazine]`
`mailing`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[mailing]0..*-contact 1>[contact]`
`mailing`	`mailer`	Many-to-one	`0..*`	`1`	`mailing_mailer`	`[mailing]0..*-mailer 1>[mailing_mailer]`
`mailing`	`meeting`	Many-to-one	`0..*`	`0..1`	`meeting`	`[mailing]0..*-meeting 0..1>[meeting]`
`mailing`	`optIn`	Many-to-one	`0..*`	`0..1`	`optin`	`[mailing]0..*-optIn 0..1>[optin]`
`mailing`	`selection`	Many-to-many	`0..*`	`0..*`	`selection`	`[mailing]0..-selection 0..>[selection]`
`mailing`	`sender`	Many-to-one	`0..*`	`1`	`sender`	`[mailing]0..*-sender 1>[sender]`
`mailing`	`template`	Many-to-one	`0..*`	`1`	`mailtemplate`	`[mailing]0..*-template 1>[mailtemplate]`
`mailing_attachment`	`mailing`	Many-to-one	`0..*`	`1`	`mailing`	`[mailing_attachment]0..*-mailing 1>[mailing]`
`mailing_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[mailing_contact]0..*-contact 1>[contact]`
`mailing_contact`	`mailing`	Many-to-one	`0..*`	`1`	`mailing`	`[mailing_contact]0..*-mailing 1>[mailing]`
`mailing_deeplink`	`target`	Many-to-one	`0..*`	`1`	`deeplink_target`	`[mailing_deeplink]0..*-target 1>[deeplink_target]`
`mailing_deeplink`	`mailing`	One-to-one	`0..1`	`1`	`mailing`	`[mailing_deeplink]0..1-mailing 1>[mailing]`
`mailing_mailer`	`oAuth2Service`	Many-to-one	`0..*`	`0..1`	`admin_oauth2_service`	`[mailing_mailer]0..*-oAuth2Service 0..1>[admin_oauth2_service]`
`mailing_queue`	`mailing`	Many-to-one	`0..*`	`1`	`mailing`	`[mailing_queue]0..*-mailing 1>[mailing]`
`mailing_queue`	`mailingContact`	Many-to-one	`0..*`	`1`	`mailing_contact`	`[mailing_queue]0..*-mailingContact 1>[mailing_contact]`
`mailing_transactional`	`mailer`	Many-to-one	`0..*`	`1`	`mailing_mailer`	`[mailing_transactional]0..*-mailer 1>[mailing_mailer]`
`mailing_transactional`	`sender`	Many-to-one	`0..*`	`1`	`sender`	`[mailing_transactional]0..*-sender 1>[sender]`
`mailing_transactional`	`target`	Many-to-one	`0..*`	`0..1`	`deeplink_target`	`[mailing_transactional]0..*-target 0..1>[deeplink_target]`
`mailing_transactional`	`template`	Many-to-one	`0..*`	`1`	`mailtemplate`	`[mailing_transactional]0..*-template 1>[mailtemplate]`
`mailing_transactional_recipient`	`affiliationMailingRecipient`	Many-to-one	`0..*`	`0..1`	`affiliation_affiliation_mailing_recipient`	`[mailing_transactional_recipient]0..*-affiliationMailingRecipient 0..1>[affiliation_affiliation_mailing_recipient]`
`mailing_transactional_recipient`	`b2bEventMailingRecipient`	Many-to-one	`0..*`	`0..1`	`meeting_b2b_event_meeting_mailing_recipient`	`[mailing_transactional_recipient]0..*-b2bEventMailingRecipient 0..1>[meeting_b2b_event_meeting_mailing_recipient]`
`mailing_transactional_recipient`	`calendarMailingRecipient`	Many-to-one	`0..*`	`0..1`	`calendar_mailing_recipient`	`[mailing_transactional_recipient]0..*-calendarMailingRecipient 0..1>[calendar_mailing_recipient]`
`mailing_transactional_recipient`	`changeRequestMailingRecipient`	Many-to-one	`0..*`	`0..1`	`project_change_request_mailing_recipient`	`[mailing_transactional_recipient]0..*-changeRequestMailingRecipient 0..1>[project_change_request_mailing_recipient]`
`mailing_transactional_recipient`	`contactMailingRecipient`	Many-to-one	`0..*`	`0..1`	`contact_contact_mailing_recipient`	`[mailing_transactional_recipient]0..*-contactMailingRecipient 0..1>[contact_contact_mailing_recipient]`
`mailing_transactional_recipient`	`generalMailingRecipient`	Many-to-one	`0..*`	`0..1`	`mailing_transactional_mailing_recipient`	`[mailing_transactional_recipient]0..*-generalMailingRecipient 0..1>[mailing_transactional_mailing_recipient]`
`mailing_transactional_recipient`	`ideaMailingRecipient`	Many-to-one	`0..*`	`0..1`	`idea_idea_mailing_recipient`	`[mailing_transactional_recipient]0..*-ideaMailingRecipient 0..1>[idea_idea_mailing_recipient]`
`mailing_transactional_recipient`	`invoiceMailingRecipient`	Many-to-one	`0..*`	`0..1`	`invoice_mailing_recipient`	`[mailing_transactional_recipient]0..*-invoiceMailingRecipient 0..1>[invoice_mailing_recipient]`
`mailing_transactional_recipient`	`meetingMailingRecipient`	Many-to-one	`0..*`	`0..1`	`meeting_mailing_recipient`	`[mailing_transactional_recipient]0..*-meetingMailingRecipient 0..1>[meeting_mailing_recipient]`
`mailing_transactional_recipient`	`organisationMailingRecipient`	Many-to-one	`0..*`	`0..1`	`organisation_organisation_mailing_recipient`	`[mailing_transactional_recipient]0..*-organisationMailingRecipient 0..1>[organisation_organisation_mailing_recipient]`
`mailing_transactional_recipient`	`programMailingRecipient`	Many-to-one	`0..*`	`0..1`	`program_program_mailing_recipient`	`[mailing_transactional_recipient]0..*-programMailingRecipient 0..1>[program_program_mailing_recipient]`
`mailing_transactional_recipient`	`progressReportMailingRecipient`	Many-to-one	`0..*`	`0..1`	`project_report_mailing_recipient`	`[mailing_transactional_recipient]0..*-progressReportMailingRecipient 0..1>[project_report_mailing_recipient]`
`mailing_transactional_recipient`	`projectMailingRecipient`	Many-to-one	`0..*`	`0..1`	`project_project_mailing_recipient`	`[mailing_transactional_recipient]0..*-projectMailingRecipient 0..1>[project_project_mailing_recipient]`
`mailing_transactional_recipient`	`projectVersionMailingRecipient`	Many-to-one	`0..*`	`0..1`	`project_version_mailing_recipient`	`[mailing_transactional_recipient]0..*-projectVersionMailingRecipient 0..1>[project_version_mailing_recipient]`
`mailing_transactional_recipient`	`selection`	Many-to-many	`0..*`	`0..*`	`selection`	`[mailing_transactional_recipient]0..-selection 0..>[selection]`
`mailing_transactional_recipient`	`transactional`	Many-to-one	`0..*`	`1`	`mailing_transactional`	`[mailing_transactional_recipient]0..*-transactional 1>[mailing_transactional]`
`mailing_version`	`sourceMailing`	Many-to-one	`0..*`	`1`	`mailing`	`[mailing_version]0..*-sourceMailing 1>[mailing]`
`meeting`	`VIPSelections`	Many-to-many	`0..*`	`0..*`	`selection`	`[meeting]0..-VIPSelections 0..>[selection]`
`meeting`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[meeting]0..-access 0..>[access]`
`meeting`	`country`	Many-to-one	`0..*`	`0..1`	`country`	`[meeting]0..*-country 0..1>[country]`
`meeting`	`invoiceProvider`	Many-to-one	`0..*`	`0..1`	`accounting_invoice_provider`	`[meeting]0..*-invoiceProvider 0..1>[accounting_invoice_provider]`
`meeting`	`paymentProvider`	Many-to-one	`0..*`	`0..1`	`accounting_payment_provider`	`[meeting]0..*-paymentProvider 0..1>[accounting_payment_provider]`
`meeting`	`selectionQuotaExempt`	Many-to-many	`0..*`	`0..*`	`selection`	`[meeting]0..-selectionQuotaExempt 0..>[selection]`
`meeting`	`sender`	Many-to-one	`0..*`	`1`	`sender`	`[meeting]0..*-sender 1>[sender]`
`meeting`	`vatType`	Many-to-one	`0..*`	`0..1`	`vat_type`	`[meeting]0..*-vatType 0..1>[vat_type]`
`meeting_b2b_event`	`deeplinkTarget`	Many-to-one	`0..*`	`0..1`	`deeplink_target`	`[meeting_b2b_event]0..*-deeplinkTarget 0..1>[deeplink_target]`
`meeting_b2b_event`	`meeting`	One-to-one	`0..1`	`1`	`meeting`	`[meeting_b2b_event]0..1-meeting 1>[meeting]`
`meeting_b2b_event_meeting`	`invitedContact`	Many-to-one	`0..*`	`1`	`contact`	`[meeting_b2b_event_meeting]0..*-invitedContact 1>[contact]`
`meeting_b2b_event_meeting`	`requesterContact`	Many-to-one	`0..*`	`1`	`contact`	`[meeting_b2b_event_meeting]0..*-requesterContact 1>[contact]`
`meeting_b2b_event_meeting`	`resource`	Many-to-one	`0..*`	`0..1`	`meeting_b2b_event_resource`	`[meeting_b2b_event_meeting]0..*-resource 0..1>[meeting_b2b_event_resource]`
`meeting_b2b_event_meeting`	`timeslot`	Many-to-one	`0..*`	`1`	`meeting_b2b_event_timeslot`	`[meeting_b2b_event_meeting]0..*-timeslot 1>[meeting_b2b_event_timeslot]`
`meeting_b2b_event_meeting_message`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[meeting_b2b_event_meeting_message]0..*-contact 1>[contact]`
`meeting_b2b_event_meeting_message`	`meeting`	Many-to-one	`0..*`	`1`	`meeting_b2b_event_meeting`	`[meeting_b2b_event_meeting_message]0..*-meeting 1>[meeting_b2b_event_meeting]`
`meeting_b2b_event_resource`	`B2BEvent`	Many-to-one	`0..*`	`1`	`meeting_b2b_event`	`[meeting_b2b_event_resource]0..*-B2BEvent 1>[meeting_b2b_event]`
`meeting_b2b_event_timeslot`	`B2BEvent`	Many-to-one	`0..*`	`1`	`meeting_b2b_event`	`[meeting_b2b_event_timeslot]0..*-B2BEvent 1>[meeting_b2b_event]`
`meeting_b2b_event_timeslot`	`meetingDay`	Many-to-one	`0..*`	`1`	`meeting_day`	`[meeting_b2b_event_timeslot]0..*-meetingDay 1>[meeting_day]`
`meeting_badge`	`badge`	Many-to-one	`0..*`	`1`	`badge`	`[meeting_badge]0..*-badge 1>[badge]`
`meeting_badge`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_badge]0..*-meeting 1>[meeting]`
`meeting_cost`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_cost]0..*-meeting 1>[meeting]`
`meeting_cost`	`selection`	Many-to-many	`0..*`	`0..*`	`selection`	`[meeting_cost]0..-selection 0..>[selection]`
`meeting_cost`	`vat`	Many-to-one	`0..*`	`1`	`vat`	`[meeting_cost]0..*-vat 1>[vat]`
`meeting_coupon`	`booth`	Many-to-one	`0..*`	`1`	`booth`	`[meeting_coupon]0..*-booth 1>[booth]`
`meeting_coupon`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_coupon]0..*-meeting 1>[meeting]`
`meeting_coupon`	`registration`	One-to-one	`0..1`	`0..1`	`registration`	`[meeting_coupon]0..1-registration 0..1>[registration]`
`meeting_day`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_day]0..*-meeting 1>[meeting]`
`meeting_floorplan`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[meeting_floorplan]0..*-contentType 1>[contenttype]`
`meeting_floorplan`	`meeting`	One-to-one	`0..1`	`1`	`meeting`	`[meeting_floorplan]0..1-meeting 1>[meeting]`
`meeting_mailing`	`mailing`	Many-to-one	`0..*`	`1`	`mailing`	`[meeting_mailing]0..*-mailing 1>[mailing]`
`meeting_mailing`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_mailing]0..*-meeting 1>[meeting]`
`meeting_mailing`	`type`	Many-to-one	`0..*`	`1`	`mailingtype`	`[meeting_mailing]0..*-type 1>[mailingtype]`
`meeting_option`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_option]0..*-meeting 1>[meeting]`
`meeting_option_costs`	`option`	Many-to-one	`0..*`	`1`	`meeting_option`	`[meeting_option_costs]0..*-option 1>[meeting_option]`
`meeting_option_costs`	`selection`	Many-to-many	`0..*`	`0..*`	`selection`	`[meeting_option_costs]0..-selection 0..>[selection]`
`meeting_option_costs`	`vat`	Many-to-one	`0..*`	`1`	`vat`	`[meeting_option_costs]0..*-vat 1>[vat]`
`meeting_quota`	`country`	Many-to-one	`0..*`	`1`	`country`	`[meeting_quota]0..*-country 1>[country]`
`meeting_quota`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_quota]0..*-meeting 1>[meeting]`
`meeting_ticket`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[meeting_ticket]0..*-contentType 1>[contenttype]`
`meeting_ticket`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_ticket]0..*-meeting 1>[meeting]`
`meeting_ticket_object`	`ticket`	Many-to-one	`0..*`	`1`	`meeting_ticket`	`[meeting_ticket_object]0..*-ticket 1>[meeting_ticket]`
`meeting_transactional`	`mailer`	Many-to-one	`0..*`	`0..1`	`mailing_mailer`	`[meeting_transactional]0..*-mailer 0..1>[mailing_mailer]`
`meeting_transactional`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[meeting_transactional]0..*-meeting 1>[meeting]`
`meeting_transactional`	`sender`	Many-to-one	`0..*`	`0..1`	`sender`	`[meeting_transactional]0..*-sender 0..1>[sender]`
`meeting_transactional`	`target`	Many-to-one	`0..*`	`0..1`	`deeplink_target`	`[meeting_transactional]0..*-target 0..1>[deeplink_target]`
`meeting_transactional`	`template`	Many-to-one	`0..*`	`0..1`	`mailtemplate`	`[meeting_transactional]0..*-template 0..1>[mailtemplate]`
`meeting_transactional`	`transactional`	Many-to-one	`0..*`	`1`	`mailing_transactional`	`[meeting_transactional]0..*-transactional 1>[mailing_transactional]`
`meeting_transactional_attachment`	`meetingTransactional`	Many-to-one	`0..*`	`1`	`meeting_transactional`	`[meeting_transactional_attachment]0..*-meetingTransactional 1>[meeting_transactional]`
`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]`
`news`	`category`	Many-to-many	`0..*`	`0..*`	`news_category`	`[news]0..-category 0..>[news_category]`
`news`	`organisation`	Many-to-many	`0..*`	`0..*`	`organisation`	`[news]0..-organisation 0..>[organisation]`
`news`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[news]0..-project 0..>[project]`
`node`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[node]0..-access 0..>[access]`
`node`	`nodeLayout`	Many-to-one	`0..*`	`0..1`	`content_template`	`[node]0..*-nodeLayout 0..1>[content_template]`
`node`	`nodeTemplate`	Many-to-one	`0..*`	`1`	`content_template`	`[node]0..*-nodeTemplate 1>[content_template]`
`node`	`route`	Many-to-one	`0..*`	`1`	`content_route`	`[node]0..*-route 1>[content_route]`
`node_tree`	`parentNode`	Many-to-one	`0..*`	`0..1`	`node`	`[node_tree]0..*-parentNode 0..1>[node]`
`node_tree`	`childNode`	One-to-one	`0..1`	`1`	`node`	`[node_tree]0..1-childNode 1>[node]`
`node_version`	`sourceNode`	Many-to-one	`0..*`	`1`	`node`	`[node_version]0..*-sourceNode 1>[node]`
`oauth_access_tokens`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_access_tokens]0..*-client 1>[oauth_clients]`
`oauth_access_tokens`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[oauth_access_tokens]0..*-contact 0..1>[contact]`
`oauth_authorization_codes`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_authorization_codes]0..*-client 1>[oauth_clients]`
`oauth_authorization_codes`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[oauth_authorization_codes]0..*-contact 0..1>[contact]`
`oauth_clients`	`scope`	Many-to-one	`0..*`	`1`	`oauth_scopes`	`[oauth_clients]0..*-scope 1>[oauth_scopes]`
`oauth_jwt`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_jwt]0..*-client 1>[oauth_clients]`
`oauth_public_keys`	`client`	One-to-one	`0..1`	`1`	`oauth_clients`	`[oauth_public_keys]0..1-client 1>[oauth_clients]`
`oauth_refresh_tokens`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_refresh_tokens]0..*-client 1>[oauth_clients]`
`oauth_refresh_tokens`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[oauth_refresh_tokens]0..*-contact 0..1>[contact]`
`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]`
`permit_contact`	`access`	Many-to-one	`0..*`	`0..1`	`access`	`[permit_contact]0..*-access 0..1>[access]`
`permit_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[permit_contact]0..*-contact 1>[contact]`
`permit_contact`	`role`	Many-to-one	`0..*`	`1`	`permit_role`	`[permit_contact]0..*-role 1>[permit_role]`
`permit_contact`	`setter`	Many-to-one	`0..*`	`0..1`	`permit_setter`	`[permit_contact]0..*-setter 0..1>[permit_setter]`
`permit_role`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[permit_role]0..-access 0..>[access]`
`permit_role`	`entity`	Many-to-one	`0..*`	`1`	`permit_entity`	`[permit_role]0..*-entity 1>[permit_entity]`
`permit_setter`	`entity`	Many-to-one	`0..*`	`1`	`permit_entity`	`[permit_setter]0..*-entity 1>[permit_entity]`
`permit_setter`	`role`	Many-to-many	`0..*`	`0..*`	`permit_role`	`[permit_setter]0..-role 0..>[permit_role]`
`press_article`	`bureau`	Many-to-one	`0..*`	`1`	`press_bureau`	`[press_article]0..*-bureau 1>[press_bureau]`
`press_article`	`contentType`	Many-to-one	`0..*`	`0..1`	`contenttype`	`[press_article]0..*-contentType 0..1>[contenttype]`
`press_article`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[press_article]0..-project 0..>[project]`
`press_article_object`	`article`	Many-to-one	`0..*`	`1`	`press_article`	`[press_article_object]0..*-article 1>[press_article]`
`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]`
`programcall_session`	`tool`	Many-to-one	`0..*`	`1`	`idea_tool`	`[programcall_session]0..*-tool 1>[idea_tool]`
`programcall_session_participant`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[programcall_session_participant]0..*-contact 1>[contact]`
`programcall_session_participant`	`session`	Many-to-one	`0..*`	`1`	`programcall_session`	`[programcall_session_participant]0..*-session 1>[programcall_session]`
`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`	`version`	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`	`version`	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`	`version`	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_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_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_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]`
`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_report`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report]0..*-contact 1>[contact]`
`project_report`	`evaluationReportVersion`	Many-to-one	`0..*`	`0..1`	`evaluation_report2_version`	`[project_report]0..*-evaluationReportVersion 0..1>[evaluation_report2_version]`
`project_report`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_report]0..*-project 1>[project]`
`project_report`	`reportVersion`	Many-to-one	`0..*`	`0..1`	`project_report_version`	`[project_report]0..*-reportVersion 0..1>[project_report_version]`
`project_report_criterion`	`achievementCategory`	Many-to-one	`0..*`	`0..1`	`project_achievement_category`	`[project_report_criterion]0..*-achievementCategory 0..1>[project_achievement_category]`
`project_report_criterion`	`reportTypes`	Many-to-many	`0..*`	`0..*`	`project_report_type`	`[project_report_criterion]0..-reportTypes 0..>[project_report_type]`
`project_report_criterion_type`	`category`	Many-to-one	`0..*`	`1`	`project_report_criterion_category`	`[project_report_criterion_type]0..*-category 1>[project_report_criterion_category]`
`project_report_criterion_version`	`criterion`	Many-to-one	`0..*`	`1`	`project_report_criterion`	`[project_report_criterion_version]0..*-criterion 1>[project_report_criterion]`
`project_report_criterion_version`	`reportVersion`	Many-to-one	`0..*`	`1`	`project_report_version`	`[project_report_criterion_version]0..*-reportVersion 1>[project_report_version]`
`project_report_criterion_version`	`type`	Many-to-one	`0..*`	`1`	`project_report_criterion_type`	`[project_report_criterion_version]0..*-type 1>[project_report_criterion_type]`
`project_report_effort_spent`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_report_effort_spent]0..*-affiliation 1>[affiliation]`
`project_report_effort_spent`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_effort_spent]0..*-contact 1>[contact]`
`project_report_effort_spent`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_effort_spent]0..*-report 1>[project_report]`
`project_report_email_message`	`emailMessage`	Many-to-one	`0..*`	`1`	`email_message`	`[project_report_email_message]0..*-emailMessage 1>[email_message]`
`project_report_email_message`	`progressReport`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_email_message]0..*-progressReport 1>[project_report]`
`project_report_item`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_item]0..*-contact 1>[contact]`
`project_report_item`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[project_report_item]0..*-contentType 1>[contenttype]`
`project_report_item`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_item]0..*-report 1>[project_report]`
`project_report_item_object`	`item`	Many-to-one	`0..*`	`1`	`project_report_item`	`[project_report_item_object]0..*-item 1>[project_report_item]`
`project_report_result`	`criterionVersion`	Many-to-one	`0..*`	`1`	`project_report_criterion_version`	`[project_report_result]0..*-criterionVersion 1>[project_report_criterion_version]`
`project_report_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result]0..*-report 1>[project_report]`
`project_report_result_affiliation_result`	`affiliation`	Many-to-one	`0..*`	`1`	`affiliation`	`[project_report_result_affiliation_result]0..*-affiliation 1>[affiliation]`
`project_report_result_affiliation_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result_affiliation_result]0..*-report 1>[project_report]`
`project_report_result_deliverable_result`	`deliverable`	Many-to-one	`0..*`	`1`	`workpackage_deliverable`	`[project_report_result_deliverable_result]0..*-deliverable 1>[workpackage_deliverable]`
`project_report_result_deliverable_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result_deliverable_result]0..*-report 1>[project_report]`
`project_report_result_milestone_result`	`milestone`	Many-to-one	`0..*`	`1`	`project_milestone`	`[project_report_result_milestone_result]0..*-milestone 1>[project_milestone]`
`project_report_result_milestone_result`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_result_milestone_result]0..*-report 1>[project_report]`
`project_report_review`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_review]0..*-contact 1>[contact]`
`project_report_review`	`projectReport`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_review]0..*-projectReport 1>[project_report]`
`project_report_version`	`reportType`	Many-to-one	`0..*`	`1`	`project_report_type`	`[project_report_version]0..*-reportType 1>[project_report_type]`
`project_report_window`	`reportVersion`	Many-to-one	`0..*`	`0..1`	`project_report_version`	`[project_report_window]0..*-reportVersion 0..1>[project_report_version]`
`project_report_window_project`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_report_window_project]0..*-project 1>[project]`
`project_report_window_project`	`window`	Many-to-one	`0..*`	`1`	`project_report_window`	`[project_report_window_project]0..*-window 1>[project_report_window]`
`project_report_window_project`	`report`	One-to-one	`0..1`	`0..1`	`project_report`	`[project_report_window_project]0..1-report 0..1>[project_report]`
`project_report_workpackage_description`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_report_workpackage_description]0..*-contact 1>[contact]`
`project_report_workpackage_description`	`report`	Many-to-one	`0..*`	`1`	`project_report`	`[project_report_workpackage_description]0..*-report 1>[project_report]`
`project_report_workpackage_description`	`workpackage`	Many-to-one	`0..*`	`1`	`workpackage`	`[project_report_workpackage_description]0..*-workpackage 1>[workpackage]`
`project_review`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[project_review]0..*-contact 1>[contact]`
`project_review`	`project`	Many-to-one	`0..*`	`1`	`project`	`[project_review]0..*-project 1>[project]`
`project_review`	`type`	Many-to-one	`0..*`	`1`	`project_review_type`	`[project_review]0..*-type 1>[project_review_type]`
`project_review_contact`	`contact`	One-to-one	`0..1`	`1`	`contact`	`[project_review_contact]0..1-contact 1>[contact]`
`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`	`version`	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`	`version`	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`	`version`	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`	`version`	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`	`version`	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]`
`publication`	`call`	Many-to-many	`0..*`	`0..*`	`programcall`	`[publication]0..-call 0..>[programcall]`
`publication`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[publication]0..*-contact 1>[contact]`
`publication`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[publication]0..*-contentType 1>[contenttype]`
`publication`	`type`	Many-to-one	`0..*`	`1`	`publication_type`	`[publication]0..*-type 1>[publication_type]`
`publication_download`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[publication_download]0..*-contact 0..1>[contact]`
`publication_download`	`publication`	Many-to-one	`0..*`	`1`	`publication`	`[publication_download]0..*-publication 1>[publication]`
`publication_object`	`publication`	Many-to-one	`0..*`	`1`	`publication`	`[publication_object]0..*-publication 1>[publication]`
`publication_type`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[publication_type]0..-access 0..>[access]`
`publication_type`	`category`	Many-to-one	`0..*`	`1`	`publication_type_category`	`[publication_type]0..*-category 1>[publication_type_category]`
`quality_action`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[quality_action]0..*-contact 0..1>[contact]`
`quality_action`	`group`	Many-to-one	`0..*`	`0..1`	`quality_action_group`	`[quality_action]0..*-group 0..1>[quality_action_group]`
`quality_action`	`process`	Many-to-one	`0..*`	`1`	`quality_process`	`[quality_action]0..*-process 1>[quality_process]`
`quality_action`	`source`	Many-to-one	`0..*`	`1`	`quality_action_source`	`[quality_action]0..*-source 1>[quality_action_source]`
`quality_action`	`year`	Many-to-one	`0..*`	`1`	`quality_year`	`[quality_action]0..*-year 1>[quality_year]`
`quality_action_result`	`action`	Many-to-one	`0..*`	`1`	`quality_action`	`[quality_action_result]0..*-action 1>[quality_action]`
`quality_action_result`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[quality_action_result]0..*-contact 1>[contact]`
`quality_action_result`	`phase`	Many-to-one	`0..*`	`1`	`quality_phase`	`[quality_action_result]0..*-phase 1>[quality_phase]`
`quality_action_result`	`status`	Many-to-one	`0..*`	`1`	`quality_status`	`[quality_action_result]0..*-status 1>[quality_status]`
`quality_dashboard_type`	`category`	Many-to-one	`0..*`	`1`	`quality_dashboard_category`	`[quality_dashboard_type]0..*-category 1>[quality_dashboard_category]`
`quality_kpi`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[quality_kpi]0..*-contact 0..1>[contact]`
`quality_kpi`	`dashboardType`	Many-to-one	`0..*`	`0..1`	`quality_dashboard_type`	`[quality_kpi]0..*-dashboardType 0..1>[quality_dashboard_type]`
`quality_kpi`	`group`	Many-to-one	`0..*`	`0..1`	`quality_kpi_group`	`[quality_kpi]0..*-group 0..1>[quality_kpi_group]`
`quality_kpi`	`process`	Many-to-one	`0..*`	`1`	`quality_process`	`[quality_kpi]0..*-process 1>[quality_process]`
`quality_kpi`	`year`	Many-to-one	`0..*`	`1`	`quality_year`	`[quality_kpi]0..*-year 1>[quality_year]`
`quality_kpi_result`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[quality_kpi_result]0..*-contact 1>[contact]`
`quality_kpi_result`	`kpi`	Many-to-one	`0..*`	`1`	`quality_kpi`	`[quality_kpi_result]0..*-kpi 1>[quality_kpi]`
`quality_kpi_result`	`phase`	Many-to-one	`0..*`	`1`	`quality_phase`	`[quality_kpi_result]0..*-phase 1>[quality_phase]`
`quality_kpi_result`	`status`	Many-to-one	`0..*`	`1`	`quality_status`	`[quality_kpi_result]0..*-status 1>[quality_status]`
`quality_kpi_target`	`kpi`	Many-to-one	`0..*`	`1`	`quality_kpi`	`[quality_kpi_target]0..*-kpi 1>[quality_kpi]`
`quality_kpi_target`	`target`	Many-to-one	`0..*`	`1`	`quality_target`	`[quality_kpi_target]0..*-target 1>[quality_target]`
`quality_phase`	`type`	Many-to-one	`0..*`	`1`	`quality_phase_type`	`[quality_phase]0..*-type 1>[quality_phase_type]`
`quality_phase`	`year`	Many-to-one	`0..*`	`1`	`quality_year`	`[quality_phase]0..*-year 1>[quality_year]`
`quality_target`	`year`	One-to-one	`0..1`	`1`	`quality_year`	`[quality_target]0..1-year 1>[quality_year]`
`registration`	`blockedTimeslots`	Many-to-many	`0..*`	`0..*`	`meeting_b2b_event_timeslot`	`[registration]0..-blockedTimeslots 0..>[meeting_b2b_event_timeslot]`
`registration`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[registration]0..*-contact 1>[contact]`
`registration`	`meeting`	Many-to-one	`0..*`	`1`	`meeting`	`[registration]0..*-meeting 1>[meeting]`
`registration`	`meetingDays`	Many-to-many	`0..*`	`0..*`	`meeting_day`	`[registration]0..-meetingDays 0..>[meeting_day]`
`registration_desk`	`registration`	One-to-one	`0..1`	`1`	`registration`	`[registration_desk]0..1-registration 1>[registration]`
`registration_financial`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[registration_financial]0..*-organisation 1>[organisation]`
`registration_financial`	`vatType`	Many-to-one	`0..*`	`1`	`vat_type`	`[registration_financial]0..*-vatType 1>[vat_type]`
`registration_financial`	`registration`	One-to-one	`0..1`	`1`	`registration`	`[registration_financial]0..1-registration 1>[registration]`
`registration_invoice`	`registration`	Many-to-one	`0..*`	`1`	`registration`	`[registration_invoice]0..*-registration 1>[registration]`
`registration_invoice`	`invoice`	One-to-one	`0..1`	`1`	`invoice`	`[registration_invoice]0..1-invoice 1>[invoice]`
`registration_invoice`	`transaction`	One-to-one	`0..1`	`0..1`	`transaction`	`[registration_invoice]0..1-transaction 0..1>[transaction]`
`registration_option`	`option`	Many-to-one	`0..*`	`1`	`meeting_option`	`[registration_option]0..*-option 1>[meeting_option]`
`registration_option`	`registration`	Many-to-one	`0..*`	`1`	`registration`	`[registration_option]0..*-registration 1>[registration]`
`reminder`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[reminder]0..*-contact 1>[contact]`
`reminder`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[reminder]0..*-contentType 1>[contenttype]`
`reminder`	`invoice`	Many-to-many	`0..*`	`0..*`	`invoice`	`[reminder]0..-invoice 0..>[invoice]`
`reminder`	`journal`	Many-to-one	`0..*`	`0..1`	`invoice_journal`	`[reminder]0..*-journal 0..1>[invoice_journal]`
`reminder`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[reminder]0..*-organisation 1>[organisation]`
`reminder`	`type`	Many-to-one	`0..*`	`1`	`reminder_type`	`[reminder]0..*-type 1>[reminder_type]`
`reminder_pdf`	`invoice`	Many-to-one	`0..*`	`0..1`	`invoice`	`[reminder_pdf]0..*-invoice 0..1>[invoice]`
`reminder_pdf`	`reminder`	Many-to-one	`0..*`	`1`	`reminder`	`[reminder_pdf]0..*-reminder 1>[reminder]`
`reporting_storage_location`	`oAuth2Service`	Many-to-one	`0..*`	`0..1`	`admin_oauth2_service`	`[reporting_storage_location]0..*-oAuth2Service 0..1>[admin_oauth2_service]`
`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]`
`selection`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[selection]0..*-contact 1>[contact]`
`selection`	`meeting`	Many-to-one	`0..*`	`0..1`	`meeting`	`[selection]0..*-meeting 0..1>[meeting]`
`selection`	`type`	Many-to-one	`0..*`	`0..1`	`selection_type`	`[selection]0..*-type 0..1>[selection_type]`
`selection_contact`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[selection_contact]0..*-contact 1>[contact]`
`selection_contact`	`selection`	Many-to-one	`0..*`	`1`	`selection`	`[selection_contact]0..*-selection 1>[selection]`
`selection_sql`	`selection`	One-to-one	`0..1`	`1`	`selection`	`[selection_sql]0..1-selection 1>[selection]`
`session`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[session]0..*-contact 1>[contact]`
`session_pageview`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[session_pageview]0..*-contact 1>[contact]`
`transaction`	`paymentProvider`	Many-to-one	`0..*`	`1`	`accounting_payment_provider`	`[transaction]0..*-paymentProvider 1>[accounting_payment_provider]`
`vat`	`country`	Many-to-one	`0..*`	`1`	`country`	`[vat]0..*-country 1>[country]`
`vat_dimension`	`vat`	Many-to-one	`0..*`	`1`	`vat`	`[vat_dimension]0..*-vat 1>[vat]`
`vat_dimension`	`vatType`	Many-to-one	`0..*`	`1`	`vat_type`	`[vat_dimension]0..*-vatType 1>[vat_type]`
`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`	`version`	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]`

28 July 2026