Publication database reference
This reference is generated from the Doctrine ORM metadata.
Entities
publication
Doctrine entity: Publication\Entity\Publication
Column | Doctrine type | Key |
|---|
publication_id
| integer
| |
publication
| string
| |
docref
| string
| |
description
| text
| |
date_created
| datetime
| |
size
| integer
| |
orginal
| string
| |
tag
| string
| |
sequence
| integer
| |
date_updated
| datetime
| |
contact_id
| FK
| FK |
contenttype_id
| FK
| FK |
type_id
| FK
| FK |
publication_download
Doctrine entity: Publication\Entity\Download
Column | Doctrine type | Key |
|---|
download_id
| integer
| |
date_created
| datetime
| |
contact_id
| FK
| FK |
publication_id
| FK
| FK |
publication_object
Doctrine entity: Publication\Entity\PublicationObject
Column | Doctrine type | Key |
|---|
object_id
| integer
| |
object
| blob
| |
publication_id
| FK
| FK |
publication_type
Doctrine entity: Publication\Entity\Type
Column | Doctrine type | Key |
|---|
type_id
| integer
| |
type
| string
| |
sequence
| integer
| |
hidden
| smallint
| |
category_id
| FK
| FK |
publication_type_category
Doctrine entity: Publication\Entity\Category
Column | Doctrine type | Key |
|---|
category_id
| integer
| |
category
| string
| |
Relationships
Source table | Association | Type | Source cardinality | Target cardinality | Target table | YuML |
|---|
publication
| call
| Many-to-many | 0..*
| 0..*
| programcall
| [publication]0..*-call 0..*>[programcall]
|
publication
| contact
| Many-to-one | 0..*
| 1
| contact
| [publication]0..*-contact 1>[contact]
|
publication
| contentType
| Many-to-one | 0..*
| 1
| contenttype
| [publication]0..*-contentType 1>[contenttype]
|
publication
| type
| Many-to-one | 0..*
| 1
| publication_type
| [publication]0..*-type 1>[publication_type]
|
publication_download
| contact
| Many-to-one | 0..*
| 0..1
| contact
| [publication_download]0..*-contact 0..1>[contact]
|
publication_download
| publication
| Many-to-one | 0..*
| 1
| publication
| [publication_download]0..*-publication 1>[publication]
|
publication_object
| publication
| Many-to-one | 0..*
| 1
| publication
| [publication_object]0..*-publication 1>[publication]
|
publication_type
| access
| Many-to-many | 0..*
| 0..*
| access
| [publication_type]0..*-access 0..*>[access]
|
publication_type
| category
| Many-to-one | 0..*
| 1
| publication_type_category
| [publication_type]0..*-category 1>[publication_type_category]
|
02 November 2026