Mailing database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`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

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

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

Relationships

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

02 November 2026