General database reference

This reference is generated from the Doctrine ORM metadata.

Entities

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

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

`contenttype`

Doctrine entity: General\Entity\ContentType

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

`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

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

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

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

`password`

Doctrine entity: General\Entity\Password

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

`title`

Doctrine entity: General\Entity\Title

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

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

Doctrine entity: General\Entity\VatType

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

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`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]`
`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]`
`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]`
`vat`	`country`	Many-to-one	`0..*`	`1`	`country`	`[vat]0..*-country 1>[country]`

02 November 2026