Contact database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`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

`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

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

`optin`

Doctrine entity: Contact\Entity\OptIn

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

`phone_type`

Doctrine entity: Contact\Entity\PhoneType

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

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`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]`
`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]`
`facebook`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[facebook]0..-access 0..>[access]`
`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]`

02 November 2026