Content database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`article`

Doctrine entity: Content\Entity\Article

Column	Doctrine type	Key
`article_id`	`integer`
`article`	`string`
`docref`	`string`
`date_created`	`datetime`
`sequence`	`integer`
`body`	`text`
`css`	`text`
`hide_from_navigation`	`smallint`
`article_in_title`	`smallint`

`article_version`

Doctrine entity: Content\Entity\Article\Version

Column	Doctrine type	Key
`article_version_id`	`integer`
`article`	`string`
`date_created`	`datetime`
`body`	`text`
`css`	`text`
`article_id`	`FK`	FK

`content_route`

Doctrine entity: Content\Entity\Route

Column	Doctrine type	Key
`route_id`	`integer`
`route`	`string`
`identifier`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`start_node_id`	`FK`	FK
`route_entity_id`	`FK`	FK
`template_id`	`FK`	FK
`tool_id`	`FK`	FK

`content_route_entity`

Doctrine entity: Content\Entity\Route\RouteEntity

Column	Doctrine type	Key
`route_entity_id`	`integer`
`name`	`string`
`entity_class_name`	`string`
`assertion_class_name`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`

`content_template`

Doctrine entity: Content\Entity\Template

Column	Doctrine type	Key
`template_id`	`integer`
`template`	`string`
`content`	`text`
`type`	`smallint`
`date_created`	`datetime`
`last_update`	`datetime`

`image`

Doctrine entity: Content\Entity\Image

Column	Doctrine type	Key
`image_id`	`integer`
`image`	`string`
`date_created`	`datetime`
`size`	`integer`
`width`	`integer`
`height`	`integer`
`date_updated`	`datetime`
`contenttype_id`	`FK`	FK

`image_object`

Doctrine entity: Content\Entity\ImageObject

Column	Doctrine type	Key
`object_id`	`integer`
`object`	`blob`
`image_id`	`FK`	FK

`node`

Doctrine entity: Content\Entity\Node

Column	Doctrine type	Key
`node_id`	`integer`
`title`	`string`
`start_date`	`datetime`
`uri`	`string`
`hide_from_navigation`	`smallint`
`node_content`	`smallint`
`twig_content`	`text`
`style`	`text`
`javascript`	`text`
`template_id`	`FK`	FK
`layout_template_id`	`FK`	FK
`route_id`	`FK`	FK

`node_tree`

Doctrine entity: Content\Entity\Tree

Column	Doctrine type	Key
`tree_id`	`integer`
`sequence`	`integer`
`child_node_id`	`FK`	FK
`parent_node_id`	`FK`	FK

`node_version`

Doctrine entity: Content\Entity\Node\Version

Column	Doctrine type	Key
`node_version_id`	`integer`
`date_created`	`datetime`
`title`	`string`
`twig_content`	`text`
`style`	`text`
`javascript`	`text`
`node_id`	`FK`	FK

`video`

Doctrine entity: Content\Entity\Video

Column	Doctrine type	Key
`video_id`	`integer`
`uri`	`string`
`link`	`string`
`filename`	`string`
`description`	`text`
`thumbnail`	`array`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_released`	`datetime`
`privacy`	`array`
`embed`	`array`
`width`	`integer`
`height`	`integer`
`duration`	`integer`

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`article`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[article]0..-access 0..>[access]`
`article`	`project`	Many-to-many	`0..*`	`0..*`	`project`	`[article]0..-project 0..>[project]`
`article_version`	`sourceArticle`	Many-to-one	`0..*`	`1`	`article`	`[article_version]0..*-sourceArticle 1>[article]`
`content_route`	`routeEntity`	Many-to-one	`0..*`	`1`	`content_route_entity`	`[content_route]0..*-routeEntity 1>[content_route_entity]`
`content_route`	`startNode`	Many-to-one	`0..*`	`0..1`	`node`	`[content_route]0..*-startNode 0..1>[node]`
`content_route`	`template`	Many-to-one	`0..*`	`0..1`	`content_template`	`[content_route]0..*-template 0..1>[content_template]`
`content_route`	`ideaTool`	One-to-one	`0..1`	`0..1`	`idea_tool`	`[content_route]0..1-ideaTool 0..1>[idea_tool]`
`image`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[image]0..*-contentType 1>[contenttype]`
`image_object`	`image`	Many-to-one	`0..*`	`1`	`image`	`[image_object]0..*-image 1>[image]`
`node`	`access`	Many-to-many	`0..*`	`0..*`	`access`	`[node]0..-access 0..>[access]`
`node`	`nodeLayout`	Many-to-one	`0..*`	`0..1`	`content_template`	`[node]0..*-nodeLayout 0..1>[content_template]`
`node`	`nodeTemplate`	Many-to-one	`0..*`	`1`	`content_template`	`[node]0..*-nodeTemplate 1>[content_template]`
`node`	`route`	Many-to-one	`0..*`	`1`	`content_route`	`[node]0..*-route 1>[content_route]`
`node_tree`	`parentNode`	Many-to-one	`0..*`	`0..1`	`node`	`[node_tree]0..*-parentNode 0..1>[node]`
`node_tree`	`childNode`	One-to-one	`0..1`	`1`	`node`	`[node_tree]0..1-childNode 1>[node]`
`node_version`	`sourceNode`	Many-to-one	`0..*`	`1`	`node`	`[node_version]0..*-sourceNode 1>[node]`

02 November 2026