ECIS Help 0.1-DEV Help

Event database reference

This reference is generated from the Doctrine ORM metadata.

Entities

badge

Doctrine entity: Event\Entity\Badge\Badge

Column

Doctrine type

Key

badge_id

integer

badge

string

date_created

datetime

mm_top

integer

mm_left

integer

mm_width

integer

mm_height

integer

mm_horz_margin

integer

mm_vert_margin

integer

mm_name

integer

mm_organisation

integer

font_name

integer

font_organisation

integer

color_name

string

color_organisation

string

config

text

layout

json

mm_left_name

integer

contact_id

FK

FK

selection_id

FK

FK

badge_attachment

Doctrine entity: Event\Entity\Badge\Attachment

Column

Doctrine type

Key

attachment_id

integer

attachment

string

size

integer

date_updated

datetime

priority

smallint

sequence

smallint

side

smallint

badge_id

FK

FK

contenttype_id

FK

FK

badge_attachment_object

Doctrine entity: Event\Entity\Badge\AttachmentObject

Column

Doctrine type

Key

object_id

integer

object

blob

attachment_id

FK

FK

badge_contact

Doctrine entity: Event\Entity\Badge\Contact

Column

Doctrine type

Key

badge_contact_id

integer

date_create

datetime

blocked

boolean

badge_id

FK

FK

contact_id

FK

FK

booth

Doctrine entity: Event\Entity\Booth\Booth

Column

Doctrine type

Key

booth_id

integer

booth

string

reference

string

length

decimal

depth

decimal

votable

smallint

coord_x

decimal

coord_y

decimal

orientation

smallint

panels

smallint

rotation

smallint

description

string

hidden

smallint

frontcolor

string

backcolor

string

exhibition_id

FK

FK

booth_challenge

Doctrine entity: Event\Entity\Booth\Challenge

Column

Doctrine type

Key

booth_challenge_id

integer

booth_id

FK

FK

challenge_id

FK

FK

booth_contact

Doctrine entity: Event\Entity\Booth\Contact

Column

Doctrine type

Key

booth_contact_id

integer

mail

smallint

crew

smallint

booth_id

FK

FK

contact_id

FK

FK

booth_financial

Doctrine entity: Event\Entity\Booth\Financial

Column

Doctrine type

Key

booth_financial_id

integer

branch

string

purchase_order

string

booth_id

FK

FK

contact_id

FK

FK

organisation_id

FK

FK

booth_financial_invoice

Doctrine entity: Event\Entity\Booth\FinancialInvoice

Column

Doctrine type

Key

link_id

integer

booth_financial_id

FK

FK

invoice_id

FK

FK

booth_spec

Doctrine entity: Event\Entity\Booth\Spec

Column

Doctrine type

Key

booth_spec_id

integer

value_text

text

value_numeric

decimal

date_updated

datetime

booth_id

FK

FK

spec_id

FK

FK

desk_costs

Doctrine entity: Event\Entity\Registration\Desk\Costs

Column

Doctrine type

Key

costs_id

integer

description

string

is_registration_fee

boolean

quantity

decimal

amount

decimal

date_paid

datetime

desk_id

FK

FK

vat_id

FK

FK

transaction_id

FK

FK

option_id

FK

FK

desk_costs_option

Doctrine entity: Event\Entity\Registration\Desk\Costs\Option

Column

Doctrine type

Key

desk_costs_option_id

integer

date_paid

datetime

costs_id

FK

FK

option_id

FK

FK

event_slideshow

Doctrine entity: Event\Entity\Slideshow

Column

Doctrine type

Key

slideshow_id

integer

name

string

description

text

interval

smallint

date_created

datetime

date_updated

datetime

date_refreshed

datetime

event_slideshow_slide

Doctrine entity: Event\Entity\Slideshow\Slide

Column

Doctrine type

Key

slide_id

integer

name

string

twig_content

text

is_active

boolean

date_created

datetime

date_updated

datetime

sequence

integer

slideshow_id

FK

FK

event_slideshow_slide_view

Doctrine entity: Event\Entity\Slideshow\Slide\View

Column

Doctrine type

Key

view_id

integer

client

string

date_created

datetime

slide_id

FK

FK

exhibition

Doctrine entity: Event\Entity\Exhibition\Exhibition

Column

Doctrine type

Key

exhibition_id

integer

exhibition

string

date_start

datetime

date_end

datetime

exhibition_cost

Doctrine entity: Event\Entity\Exhibition\Cost

Column

Doctrine type

Key

cost_id

integer

cost

string

amount

decimal

exhibition_id

FK

FK

exhibition_floorplan

Doctrine entity: Event\Entity\Exhibition\Floorplan

Column

Doctrine type

Key

floorplan_id

integer

floorplan

string

object

blob

ppm

decimal

date_created

datetime

date_updated

datetime

pixel_width

decimal

pixel_height

decimal

pixel_top

decimal

pixel_left

decimal

origin_x

decimal

origin_y

decimal

mark1_x

decimal

mark1_y

decimal

mark2_x

decimal

mark2_y

decimal

mark_length

decimal

contenttype_id

FK

FK

exhibition_id

FK

FK

exhibition_floorplan_item

Doctrine entity: Event\Entity\Exhibition\FloorplanItem

Column

Doctrine type

Key

item_id

integer

item

string

rotation

decimal

size_x

decimal

size_y

decimal

size_z

decimal

coord_x

decimal

coord_y

decimal

floorplan_id

FK

FK

exhibition_spec

Doctrine entity: Event\Entity\Exhibition\Spec

Column

Doctrine type

Key

spec_id

integer

spec

string

label

string

decimals

smallint

unit

string

description

text

formula

text

costs

decimal

exhibition_id

FK

FK

type_id

FK

FK

group_id

FK

FK

exhibition_spec_form

Doctrine entity: Event\Entity\Exhibition\SpecForm

Column

Doctrine type

Key

form_id

integer

sequence

integer

description

text

inline_help

text

required

smallint

locked

smallint

hidden

smallint

spec_id

FK

FK

exhibition_spec_group

Doctrine entity: Event\Entity\Exhibition\SpecGroup

Column

Doctrine type

Key

group_id

integer

group

string

sequence

integer

exhibition_spec_type

Doctrine entity: Event\Entity\Exhibition\SpecType

Column

Doctrine type

Key

type_id

integer

type

string

exhibition_tour

Doctrine entity: Event\Entity\Exhibition\Tour

Column

Doctrine type

Key

tour_id

integer

date_start

datetime

unguided

boolean

tour

string

contact_id

FK

FK

exhibition_id

FK

FK

exhibition_tour_booth

Doctrine entity: Event\Entity\Exhibition\TourBooth

Column

Doctrine type

Key

tour_booth_id

integer

date_visit

datetime

booth_id

FK

FK

tour_id

FK

FK

exhibition_vote

Doctrine entity: Event\Entity\Exhibition\Vote

Column

Doctrine type

Key

vote_id

integer

sequence

integer

date_created

datetime

date_updated

datetime

voter_id

FK

FK

booth_id

FK

FK

exhibition_voter

Doctrine entity: Event\Entity\Exhibition\Voter

Column

Doctrine type

Key

voter_id

integer

exhibition_id

FK

FK

meeting

Doctrine entity: Event\Entity\Meeting

Column

Doctrine type

Key

meeting_id

integer

meeting

string

vatnumber

string

description

text

location

string

url

string

participants

integer

date_from

date

date_till

date

date_reg_open

date

date_reg_close

date

type

smallint

has_projects

boolean

has_costs

boolean

has_registration

boolean

visible

boolean

hashtag

string

html

text

css

text

country_id

FK

FK

vat_type_id

FK

FK

paymentProvider_id

FK

FK

invoiceProvider_id

FK

FK

sender_id

FK

FK

meeting_b2b_event

Doctrine entity: Event\Entity\Meeting\B2BEvent

Column

Doctrine type

Key

b2b_event_id

integer

deeplink_key

string

meeting_id

FK

FK

target_id

FK

FK

meeting_b2b_event_meeting

Doctrine entity: Event\Entity\Meeting\B2BEvent\Meeting

Column

Doctrine type

Key

meeting_id

integer

date_created

datetime

date_updated

datetime

requesterContactStatus

smallint

invitedContactStatus

smallint

timeslot_id

FK

FK

b2b_event_resource_id

FK

FK

requester_contact_id

FK

FK

invited_contact_id

FK

FK

meeting_b2b_event_meeting_mailing_recipient

Doctrine entity: Event\Entity\Meeting\B2BEvent\Meeting\Mailing\Recipient

Column

Doctrine type

Key

id

integer

type

string

title

string

description

string

meeting_b2b_event_meeting_message

Doctrine entity: Event\Entity\Meeting\B2BEvent\Meeting\Message

Column

Doctrine type

Key

message_id

integer

message

text

date_created

datetime

date_updated

datetime

meeting_id

FK

FK

contact_id

FK

FK

meeting_b2b_event_resource

Doctrine entity: Event\Entity\Meeting\B2BEvent\Resource

Column

Doctrine type

Key

resource_id

integer

label

string

description

text

date_created

datetime

date_updated

datetime

location_x

integer

location_y

integer

b2b_event_id

FK

FK

meeting_b2b_event_timeslot

Doctrine entity: Event\Entity\Meeting\B2BEvent\Timeslot

Column

Doctrine type

Key

timeslot_id

integer

date_created

datetime

date_updated

datetime

date_start

datetime

date_end

datetime

b2b_event_id

FK

FK

day_id

FK

FK

meeting_badge

Doctrine entity: Event\Entity\Meeting\Badge

Column

Doctrine type

Key

meeting_badge_id

integer

meeting_id

FK

FK

badge_id

FK

FK

meeting_cost

Doctrine entity: Event\Entity\Meeting\Cost

Column

Doctrine type

Key

cost_id

integer

cost

string

amount

decimal

amount_early_bird

decimal

early_bird_date

datetime

selection_type

smallint

vat_id

FK

FK

meeting_id

FK

FK

meeting_coupon

Doctrine entity: Event\Entity\Meeting\Coupon

Column

Doctrine type

Key

coupon_id

integer

hash

string

date_created

datetime

date_updated

datetime

date_taken

datetime

date_end

datetime

registration_id

FK

FK

meeting_id

FK

FK

booth_id

FK

FK

meeting_day

Doctrine entity: Event\Entity\Meeting\Day

Column

Doctrine type

Key

day_id

integer

date_created

datetime

date_updated

datetime

date_day

date

meeting_id

FK

FK

meeting_floorplan

Doctrine entity: Event\Entity\Meeting\Floorplan

Column

Doctrine type

Key

floorplan_id

integer

floorplan

string

object

blob

ppm

decimal

date_created

datetime

date_updated

datetime

pixel_width

integer

pixel_height

integer

origin_x

decimal

origin_y

decimal

contenttype_id

FK

FK

meeting_id

FK

FK

meeting_mailing

Doctrine entity: Event\Entity\Meeting\MeetingMailing

Column

Doctrine type

Key

meeting_mailing_id

integer

mailingtype_id

FK

FK

mailing_id

FK

FK

meeting_id

FK

FK

meeting_mailing_recipient

Doctrine entity: Event\Entity\Meeting\Mailing\Recipient

Column

Doctrine type

Key

id

integer

type

string

title

string

description

string

meeting_option

Doctrine entity: Event\Entity\Meeting\Option

Column

Doctrine type

Key

option_id

integer

otype

string

ooption

text

otext

text

ovalues

text

required

smallint

is_registration_fee

smallint

hidden

boolean

sort

smallint

ofriendlytext

text

meeting_id

FK

FK

meeting_option_costs

Doctrine entity: Event\Entity\Meeting\OptionCost

Column

Doctrine type

Key

costs_id

integer

description

string

option_values

string

amount

decimal

option_id

FK

FK

vat_id

FK

FK

meeting_quota

Doctrine entity: Event\Entity\Meeting\Quota

Column

Doctrine type

Key

quota_id

integer

amount

smallint

description

text

close_registration_when_reached

boolean

closing_text

text

meeting_id

FK

FK

country_id

FK

FK

meeting_ticket

Doctrine entity: Event\Entity\Meeting\Ticket

Column

Doctrine type

Key

ticket_id

integer

size

integer

date_updated

datetime

layout

json

contenttype_id

FK

FK

meeting_id

FK

FK

meeting_ticket_object

Doctrine entity: Event\Entity\Meeting\TicketObject

Column

Doctrine type

Key

object_id

integer

object

blob

ticket_id

FK

FK

meeting_transactional

Doctrine entity: Event\Entity\Meeting\Transactional

Column

Doctrine type

Key

meeting_transactional_id

integer

date_created

datetime

last_update

datetime

subject

string

content

text

meeting_id

FK

FK

transactional_id

FK

FK

sender_id

FK

FK

mail_template_id

FK

FK

mailer_id

FK

FK

target_id

FK

FK

meeting_transactional_attachment

Doctrine entity: Event\Entity\Meeting\TransactionalAttachment

Column

Doctrine type

Key

attachment_id

integer

attachment

blob

filename

string

inline

smallint

contenttype

string

meeting_transactional_id

FK

FK

registration

Doctrine entity: Event\Entity\Registration

Column

Doctrine type

Key

registration_id

integer

hide_in_list

smallint

overbooked

smallint

b2b_available_for_meetings

smallint

date_created

datetime

date_updated

datetime

date_end

datetime

is_active

boolean

contact_id

FK

FK

meeting_id

FK

FK

registration_desk

Doctrine entity: Event\Entity\Registration\Desk

Column

Doctrine type

Key

desk_id

integer

date_created

datetime

date_sent

datetime

date_desk

datetime

date_payment_pending

datetime

registration_id

FK

FK

registration_financial

Doctrine entity: Event\Entity\Registration\Financial

Column

Doctrine type

Key

registration_financial_id

integer

branch

string

purchase_order

string

registration_id

FK

FK

organisation_id

FK

FK

vat_type_id

FK

FK

registration_invoice

Doctrine entity: Event\Entity\Registration\Invoice

Column

Doctrine type

Key

registration_invoice_id

integer

registration_id

FK

FK

transaction_id

FK

FK

invoice_id

FK

FK

registration_option

Doctrine entity: Event\Entity\Registration\Option

Column

Doctrine type

Key

registration_option_id

integer

value

text

option_id

FK

FK

registration_id

FK

FK

Relationships

Source table

Association

Type

Source cardinality

Target cardinality

Target table

YuML

badge

contact

Many-to-one

0..*

1

contact

[badge]0..*-contact 1>[contact]

badge

selection

Many-to-one

0..*

1

selection

[badge]0..*-selection 1>[selection]

badge_attachment

badge

Many-to-one

0..*

1

badge

[badge_attachment]0..*-badge 1>[badge]

badge_attachment

contentType

Many-to-one

0..*

1

contenttype

[badge_attachment]0..*-contentType 1>[contenttype]

badge_attachment

selections

Many-to-many

0..*

0..*

selection

[badge_attachment]0..*-selections 0..*>[selection]

badge_attachment_object

attachment

Many-to-one

0..*

1

badge_attachment

[badge_attachment_object]0..*-attachment 1>[badge_attachment]

badge_contact

badge

Many-to-one

0..*

1

badge

[badge_contact]0..*-badge 1>[badge]

badge_contact

contact

Many-to-one

0..*

1

contact

[badge_contact]0..*-contact 1>[contact]

booth

exhibition

Many-to-one

0..*

1

exhibition

[booth]0..*-exhibition 1>[exhibition]

booth_challenge

booth

Many-to-one

0..*

1

booth

[booth_challenge]0..*-booth 1>[booth]

booth_challenge

challenge

Many-to-one

0..*

1

challenge

[booth_challenge]0..*-challenge 1>[challenge]

booth_contact

booth

Many-to-one

0..*

1

booth

[booth_contact]0..*-booth 1>[booth]

booth_contact

contact

Many-to-one

0..*

1

contact

[booth_contact]0..*-contact 1>[contact]

booth_financial

contact

Many-to-one

0..*

1

contact

[booth_financial]0..*-contact 1>[contact]

booth_financial

organisation

Many-to-one

0..*

1

organisation

[booth_financial]0..*-organisation 1>[organisation]

booth_financial

booth

One-to-one

0..1

1

booth

[booth_financial]0..1-booth 1>[booth]

booth_financial_invoice

boothFinancial

One-to-one

0..1

1

booth_financial

[booth_financial_invoice]0..1-boothFinancial 1>[booth_financial]

booth_financial_invoice

invoice

One-to-one

0..1

1

invoice

[booth_financial_invoice]0..1-invoice 1>[invoice]

booth_spec

booth

Many-to-one

0..*

1

booth

[booth_spec]0..*-booth 1>[booth]

booth_spec

exhibitionSpec

Many-to-one

0..*

1

exhibition_spec

[booth_spec]0..*-exhibitionSpec 1>[exhibition_spec]

desk_costs

desk

Many-to-one

0..*

1

registration_desk

[desk_costs]0..*-desk 1>[registration_desk]

desk_costs

meetingOption

Many-to-one

0..*

0..1

meeting_option

[desk_costs]0..*-meetingOption 0..1>[meeting_option]

desk_costs

transaction

Many-to-one

0..*

0..1

transaction

[desk_costs]0..*-transaction 0..1>[transaction]

desk_costs

vat

Many-to-one

0..*

1

vat

[desk_costs]0..*-vat 1>[vat]

desk_costs_option

deskCosts

Many-to-one

0..*

1

desk_costs

[desk_costs_option]0..*-deskCosts 1>[desk_costs]

desk_costs_option

registrationOption

Many-to-one

0..*

1

registration_option

[desk_costs_option]0..*-registrationOption 1>[registration_option]

event_slideshow_slide

slideshow

Many-to-one

0..*

1

event_slideshow

[event_slideshow_slide]0..*-slideshow 1>[event_slideshow]

event_slideshow_slide_view

slide

Many-to-one

0..*

1

event_slideshow_slide

[event_slideshow_slide_view]0..*-slide 1>[event_slideshow_slide]

exhibition

meeting

Many-to-many

0..*

0..*

meeting

[exhibition]0..*-meeting 0..*>[meeting]

exhibition_cost

exemptBooth

Many-to-many

0..*

0..*

booth

[exhibition_cost]0..*-exemptBooth 0..*>[booth]

exhibition_cost

exhibition

Many-to-one

0..*

1

exhibition

[exhibition_cost]0..*-exhibition 1>[exhibition]

exhibition_floorplan

contentType

Many-to-one

0..*

1

contenttype

[exhibition_floorplan]0..*-contentType 1>[contenttype]

exhibition_floorplan

exhibition

One-to-one

0..1

1

exhibition

[exhibition_floorplan]0..1-exhibition 1>[exhibition]

exhibition_floorplan_item

floorplan

Many-to-one

0..*

1

exhibition_floorplan

[exhibition_floorplan_item]0..*-floorplan 1>[exhibition_floorplan]

exhibition_spec

exhibition

Many-to-one

0..*

1

exhibition

[exhibition_spec]0..*-exhibition 1>[exhibition]

exhibition_spec

group

Many-to-one

0..*

0..1

exhibition_spec_group

[exhibition_spec]0..*-group 0..1>[exhibition_spec_group]

exhibition_spec

type

Many-to-one

0..*

1

exhibition_spec_type

[exhibition_spec]0..*-type 1>[exhibition_spec_type]

exhibition_spec_form

spec

One-to-one

0..1

1

exhibition_spec

[exhibition_spec_form]0..1-spec 1>[exhibition_spec]

exhibition_tour

contact

Many-to-one

0..*

1

contact

[exhibition_tour]0..*-contact 1>[contact]

exhibition_tour

exhibition

Many-to-one

0..*

1

exhibition

[exhibition_tour]0..*-exhibition 1>[exhibition]

exhibition_tour

tourContact

Many-to-many

0..*

0..*

contact

[exhibition_tour]0..*-tourContact 0..*>[contact]

exhibition_tour_booth

booth

Many-to-one

0..*

1

booth

[exhibition_tour_booth]0..*-booth 1>[booth]

exhibition_tour_booth

tour

Many-to-one

0..*

1

exhibition_tour

[exhibition_tour_booth]0..*-tour 1>[exhibition_tour]

exhibition_vote

booth

Many-to-one

0..*

1

booth

[exhibition_vote]0..*-booth 1>[booth]

exhibition_vote

voter

Many-to-one

0..*

1

exhibition_voter

[exhibition_vote]0..*-voter 1>[exhibition_voter]

exhibition_voter

contact

Many-to-many

0..*

0..*

contact

[exhibition_voter]0..*-contact 0..*>[contact]

exhibition_voter

exhibition

Many-to-one

0..*

1

exhibition

[exhibition_voter]0..*-exhibition 1>[exhibition]

meeting

VIPSelections

Many-to-many

0..*

0..*

selection

[meeting]0..*-VIPSelections 0..*>[selection]

meeting

access

Many-to-many

0..*

0..*

access

[meeting]0..*-access 0..*>[access]

meeting

country

Many-to-one

0..*

0..1

country

[meeting]0..*-country 0..1>[country]

meeting

invoiceProvider

Many-to-one

0..*

0..1

accounting_invoice_provider

[meeting]0..*-invoiceProvider 0..1>[accounting_invoice_provider]

meeting

paymentProvider

Many-to-one

0..*

0..1

accounting_payment_provider

[meeting]0..*-paymentProvider 0..1>[accounting_payment_provider]

meeting

selectionQuotaExempt

Many-to-many

0..*

0..*

selection

[meeting]0..*-selectionQuotaExempt 0..*>[selection]

meeting

sender

Many-to-one

0..*

1

sender

[meeting]0..*-sender 1>[sender]

meeting

vatType

Many-to-one

0..*

0..1

vat_type

[meeting]0..*-vatType 0..1>[vat_type]

meeting_b2b_event

deeplinkTarget

Many-to-one

0..*

0..1

deeplink_target

[meeting_b2b_event]0..*-deeplinkTarget 0..1>[deeplink_target]

meeting_b2b_event

meeting

One-to-one

0..1

1

meeting

[meeting_b2b_event]0..1-meeting 1>[meeting]

meeting_b2b_event_meeting

invitedContact

Many-to-one

0..*

1

contact

[meeting_b2b_event_meeting]0..*-invitedContact 1>[contact]

meeting_b2b_event_meeting

requesterContact

Many-to-one

0..*

1

contact

[meeting_b2b_event_meeting]0..*-requesterContact 1>[contact]

meeting_b2b_event_meeting

resource

Many-to-one

0..*

0..1

meeting_b2b_event_resource

[meeting_b2b_event_meeting]0..*-resource 0..1>[meeting_b2b_event_resource]

meeting_b2b_event_meeting

timeslot

Many-to-one

0..*

1

meeting_b2b_event_timeslot

[meeting_b2b_event_meeting]0..*-timeslot 1>[meeting_b2b_event_timeslot]

meeting_b2b_event_meeting_message

contact

Many-to-one

0..*

1

contact

[meeting_b2b_event_meeting_message]0..*-contact 1>[contact]

meeting_b2b_event_meeting_message

meeting

Many-to-one

0..*

1

meeting_b2b_event_meeting

[meeting_b2b_event_meeting_message]0..*-meeting 1>[meeting_b2b_event_meeting]

meeting_b2b_event_resource

B2BEvent

Many-to-one

0..*

1

meeting_b2b_event

[meeting_b2b_event_resource]0..*-B2BEvent 1>[meeting_b2b_event]

meeting_b2b_event_timeslot

B2BEvent

Many-to-one

0..*

1

meeting_b2b_event

[meeting_b2b_event_timeslot]0..*-B2BEvent 1>[meeting_b2b_event]

meeting_b2b_event_timeslot

meetingDay

Many-to-one

0..*

1

meeting_day

[meeting_b2b_event_timeslot]0..*-meetingDay 1>[meeting_day]

meeting_badge

badge

Many-to-one

0..*

1

badge

[meeting_badge]0..*-badge 1>[badge]

meeting_badge

meeting

Many-to-one

0..*

1

meeting

[meeting_badge]0..*-meeting 1>[meeting]

meeting_cost

meeting

Many-to-one

0..*

1

meeting

[meeting_cost]0..*-meeting 1>[meeting]

meeting_cost

selection

Many-to-many

0..*

0..*

selection

[meeting_cost]0..*-selection 0..*>[selection]

meeting_cost

vat

Many-to-one

0..*

1

vat

[meeting_cost]0..*-vat 1>[vat]

meeting_coupon

booth

Many-to-one

0..*

1

booth

[meeting_coupon]0..*-booth 1>[booth]

meeting_coupon

meeting

Many-to-one

0..*

1

meeting

[meeting_coupon]0..*-meeting 1>[meeting]

meeting_coupon

registration

One-to-one

0..1

0..1

registration

[meeting_coupon]0..1-registration 0..1>[registration]

meeting_day

meeting

Many-to-one

0..*

1

meeting

[meeting_day]0..*-meeting 1>[meeting]

meeting_floorplan

contentType

Many-to-one

0..*

1

contenttype

[meeting_floorplan]0..*-contentType 1>[contenttype]

meeting_floorplan

meeting

One-to-one

0..1

1

meeting

[meeting_floorplan]0..1-meeting 1>[meeting]

meeting_mailing

mailing

Many-to-one

0..*

1

mailing

[meeting_mailing]0..*-mailing 1>[mailing]

meeting_mailing

meeting

Many-to-one

0..*

1

meeting

[meeting_mailing]0..*-meeting 1>[meeting]

meeting_mailing

type

Many-to-one

0..*

1

mailingtype

[meeting_mailing]0..*-type 1>[mailingtype]

meeting_option

meeting

Many-to-one

0..*

1

meeting

[meeting_option]0..*-meeting 1>[meeting]

meeting_option_costs

option

Many-to-one

0..*

1

meeting_option

[meeting_option_costs]0..*-option 1>[meeting_option]

meeting_option_costs

selection

Many-to-many

0..*

0..*

selection

[meeting_option_costs]0..*-selection 0..*>[selection]

meeting_option_costs

vat

Many-to-one

0..*

1

vat

[meeting_option_costs]0..*-vat 1>[vat]

meeting_quota

country

Many-to-one

0..*

1

country

[meeting_quota]0..*-country 1>[country]

meeting_quota

meeting

Many-to-one

0..*

1

meeting

[meeting_quota]0..*-meeting 1>[meeting]

meeting_ticket

contentType

Many-to-one

0..*

1

contenttype

[meeting_ticket]0..*-contentType 1>[contenttype]

meeting_ticket

meeting

Many-to-one

0..*

1

meeting

[meeting_ticket]0..*-meeting 1>[meeting]

meeting_ticket_object

ticket

Many-to-one

0..*

1

meeting_ticket

[meeting_ticket_object]0..*-ticket 1>[meeting_ticket]

meeting_transactional

mailer

Many-to-one

0..*

0..1

mailing_mailer

[meeting_transactional]0..*-mailer 0..1>[mailing_mailer]

meeting_transactional

meeting

Many-to-one

0..*

1

meeting

[meeting_transactional]0..*-meeting 1>[meeting]

meeting_transactional

sender

Many-to-one

0..*

0..1

sender

[meeting_transactional]0..*-sender 0..1>[sender]

meeting_transactional

target

Many-to-one

0..*

0..1

deeplink_target

[meeting_transactional]0..*-target 0..1>[deeplink_target]

meeting_transactional

template

Many-to-one

0..*

0..1

mailtemplate

[meeting_transactional]0..*-template 0..1>[mailtemplate]

meeting_transactional

transactional

Many-to-one

0..*

1

mailing_transactional

[meeting_transactional]0..*-transactional 1>[mailing_transactional]

meeting_transactional_attachment

meetingTransactional

Many-to-one

0..*

1

meeting_transactional

[meeting_transactional_attachment]0..*-meetingTransactional 1>[meeting_transactional]

registration

blockedTimeslots

Many-to-many

0..*

0..*

meeting_b2b_event_timeslot

[registration]0..*-blockedTimeslots 0..*>[meeting_b2b_event_timeslot]

registration

contact

Many-to-one

0..*

1

contact

[registration]0..*-contact 1>[contact]

registration

meeting

Many-to-one

0..*

1

meeting

[registration]0..*-meeting 1>[meeting]

registration

meetingDays

Many-to-many

0..*

0..*

meeting_day

[registration]0..*-meetingDays 0..*>[meeting_day]

registration_desk

registration

One-to-one

0..1

1

registration

[registration_desk]0..1-registration 1>[registration]

registration_financial

organisation

Many-to-one

0..*

1

organisation

[registration_financial]0..*-organisation 1>[organisation]

registration_financial

vatType

Many-to-one

0..*

1

vat_type

[registration_financial]0..*-vatType 1>[vat_type]

registration_financial

registration

One-to-one

0..1

1

registration

[registration_financial]0..1-registration 1>[registration]

registration_invoice

registration

Many-to-one

0..*

1

registration

[registration_invoice]0..*-registration 1>[registration]

registration_invoice

invoice

One-to-one

0..1

1

invoice

[registration_invoice]0..1-invoice 1>[invoice]

registration_invoice

transaction

One-to-one

0..1

0..1

transaction

[registration_invoice]0..1-transaction 0..1>[transaction]

registration_option

option

Many-to-one

0..*

1

meeting_option

[registration_option]0..*-option 1>[meeting_option]

registration_option

registration

Many-to-one

0..*

1

registration

[registration_option]0..*-registration 1>[registration]

02 November 2026