Calendar database reference

This reference is generated from the Doctrine ORM metadata.

Entities

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

Relationships

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

02 November 2026