News database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`blog`

Doctrine entity: News\Entity\Blog

Column	Doctrine type	Key
`blog_id`	`integer`
`blog`	`string`
`hidden`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_published`	`datetime`
`bodytxt`	`text`
`introtxt`	`text`
`css`	`text`
`docref`	`string`
`subtitle`	`string`
`contact_id`	`FK`	FK

`blog_message`

Doctrine entity: News\Entity\Blog\Message

Column	Doctrine type	Key
`message_id`	`integer`
`message`	`text`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`blog_id`	`FK`	FK

`category`

Doctrine entity: News\Entity\Blog\Category

Column	Doctrine type	Key
`category_id`	`integer`
`category`	`string`
`docref`	`string`

`magazine`

Doctrine entity: News\Entity\Magazine

Column	Doctrine type	Key
`magazine_id`	`integer`
`issue`	`smallint`
`title`	`string`
`sub_title`	`string`
`docref`	`string`
`hidden`	`boolean`
`type`	`smallint`
`footer_background`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_published`	`date`
`html_table_of_content`	`text`
`css_table_of_content`	`text`
`cover_image_url`	`string`

`magazine_article`

Doctrine entity: News\Entity\Magazine\Article

Column	Doctrine type	Key
`article_id`	`integer`
`title`	`string`
`sub_title`	`string`
`description`	`string`
`docref`	`string`
`page_start`	`smallint`
`page_end`	`smallint`
`hidden`	`smallint`
`layout`	`smallint`
`width`	`smallint`
`background_color`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`html`	`text`
`css`	`text`
`head_script`	`text`
`cover_image_url`	`string`
`external_link`	`string`
`magazine_id`	`FK`	FK
`contact_id`	`FK`	FK

`magazine_article_download`

Doctrine entity: News\Entity\Magazine\Article\Download

Column	Doctrine type	Key
`download_id`	`integer`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`article_id`	`FK`	FK

`magazine_article_pdf`

Doctrine entity: News\Entity\Magazine\Article\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`date_created`	`datetime`
`article_id`	`FK`	FK

`magazine_download`

Doctrine entity: News\Entity\Magazine\Download

Column	Doctrine type	Key
`download_id`	`integer`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`magazine_id`	`FK`	FK

`magazine_pdf`

Doctrine entity: News\Entity\Magazine\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`date_created`	`datetime`
`magazine_id`	`FK`	FK

`news`

Doctrine entity: News\Entity\News

Column	Doctrine type	Key
`news_id`	`integer`
`news`	`string`
`subtitle`	`string`
`highlight`	`smallint`
`highlight_description`	`text`
`on_homepage`	`smallint`
`internal`	`smallint`
`hidden`	`smallint`
`date_start`	`datetime`
`date_updated`	`datetime`
`date_published`	`datetime`
`bodytxt`	`text`
`css`	`text`
`docref`	`string`
`external_link`	`string`
`image_url`	`string`

`news_category`

Doctrine entity: News\Entity\News\Category

Column	Doctrine type	Key
`category_id`	`integer`
`category`	`string`
`docref`	`string`

`tag`

Doctrine entity: News\Entity\Blog\Tag

Column	Doctrine type	Key
`tag_id`	`integer`
`tag`	`string`
`docref`	`string`

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`blog`	`category`	Many-to-many	`0..*`	`0..*`	`category`	`[blog]0..-category 0..>[category]`
`blog`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[blog]0..*-contact 1>[contact]`
`blog`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[blog]0..-project 0..>[project]`
`blog`	`tag`	Many-to-many	`0..*`	`0..*`	`tag`	`[blog]0..-tag 0..>[tag]`
`blog_message`	`blog`	Many-to-one	`0..*`	`1`	`blog`	`[blog_message]0..*-blog 1>[blog]`
`blog_message`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[blog_message]0..*-contact 1>[contact]`
`magazine_article`	`blog`	Many-to-many	`0..*`	`0..*`	`blog`	`[magazine_article]0..-blog 0..>[blog]`
`magazine_article`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[magazine_article]0..*-contact 1>[contact]`
`magazine_article`	`country`	Many-to-many	`0..*`	`0..*`	`country`	`[magazine_article]0..-country 0..>[country]`
`magazine_article`	`magazine`	Many-to-one	`0..*`	`1`	`magazine`	`[magazine_article]0..*-magazine 1>[magazine]`
`magazine_article`	`organisation`	Many-to-many	`0..*`	`0..*`	`organisation`	`[magazine_article]0..-organisation 0..>[organisation]`
`magazine_article`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[magazine_article]0..-project 0..>[project]`
`magazine_article`	`result`	Many-to-many	`0..*`	`0..*`	`result`	`[magazine_article]0..-result 0..>[result]`
`magazine_article_download`	`article`	Many-to-one	`0..*`	`1`	`magazine_article`	`[magazine_article_download]0..*-article 1>[magazine_article]`
`magazine_article_download`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[magazine_article_download]0..*-contact 0..1>[contact]`
`magazine_article_pdf`	`article`	Many-to-one	`0..*`	`1`	`magazine_article`	`[magazine_article_pdf]0..*-article 1>[magazine_article]`
`magazine_download`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[magazine_download]0..*-contact 0..1>[contact]`
`magazine_download`	`magazine`	Many-to-one	`0..*`	`1`	`magazine`	`[magazine_download]0..*-magazine 1>[magazine]`
`magazine_pdf`	`magazine`	Many-to-one	`0..*`	`1`	`magazine`	`[magazine_pdf]0..*-magazine 1>[magazine]`
`news`	`category`	Many-to-many	`0..*`	`0..*`	`news_category`	`[news]0..-category 0..>[news_category]`
`news`	`organisation`	Many-to-many	`0..*`	`0..*`	`organisation`	`[news]0..-organisation 0..>[organisation]`
`news`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[news]0..-project 0..>[project]`

02 November 2026