Idea database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`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

`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

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`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`	`StatusRepository`	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]`
`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]`

02 November 2026