Admin database reference
This reference is generated from the Doctrine ORM metadata.
Entities
access
Doctrine entity: Admin\Entity\Access
Column | Doctrine type | Key |
|---|
access_id
| integer
| |
access
| string
| |
description
| string
| |
admin_api_log
Doctrine entity: Admin\Entity\Api\Log
Column | Doctrine type | Key |
|---|
id
| integer
| |
class
| string
| |
type
| smallint
| |
dateCreated
| datetime
| |
uri
| string
| |
payload
| text
| |
statusCode
| integer
| |
StatusRepository
| text
| |
response
| text
| |
admin_authentication
Doctrine entity: Admin\Entity\Authentication
Column | Doctrine type | Key |
|---|
id
| integer
| |
name
| string
| |
description
| text
| |
buttonText
| string
| |
dateCreated
| datetime
| |
lastUpdate
| datetime
| |
isActive
| boolean
| |
type
| smallint
| |
oAuth2Service_id
| FK
| FK |
admin_messages
Doctrine entity: Admin\Entity\Queue
Column | Doctrine type | Key |
|---|
id
| bigint
| |
body
| text
| |
headers
| text
| |
queue_name
| string
| |
created_at
| datetime
| |
available_at
| datetime
| |
delivered_at
| datetime
| |
admin_oauth2_service
Doctrine entity: Admin\Entity\OAuth2\Service
Column | Doctrine type | Key |
|---|
id
| integer
| |
name
| string
| |
description
| text
| |
clientId
| string
| |
tenantId
| string
| |
clientSecret
| string
| |
redirectUrl
| string
| |
authorizationUrl
| string
| |
accessTokenUrl
| string
| |
userId
| string
| |
privateKey
| string
| |
profileUrl
| string
| |
type
| smallint
| |
scope_id
| FK
| FK |
Doctrine entity: Admin\Entity\Permit\Contact
Column | Doctrine type | Key |
|---|
key_id
| integer
| |
contact_id
| FK
| FK |
role_id
| FK
| FK |
setter_id
| FK
| FK |
access_id
| FK
| FK |
permit_entity
Doctrine entity: Admin\Entity\Permit\Entity
Column | Doctrine type | Key |
|---|
entity_id
| integer
| |
entity
| string
| |
underscore_full_entity_name
| string
| |
permit_role
Doctrine entity: Admin\Entity\Permit\Role
Column | Doctrine type | Key |
|---|
role_id
| integer
| |
role
| string
| |
entity_id
| FK
| FK |
permit_setter
Doctrine entity: Admin\Entity\Permit\Setter
Column | Doctrine type | Key |
|---|
setter_id
| integer
| |
setter
| string
| |
entity_key
| string
| |
from_clause
| text
| |
where_clause
| text
| |
contact_key
| string
| |
entity_id
| FK
| FK |
session
Doctrine entity: Admin\Entity\Session
Column | Doctrine type | Key |
|---|
session_id
| integer
| |
session_key
| string
| |
session_name
| string
| |
ip
| string
| |
date_start
| datetime
| |
date_end
| datetime
| |
modified
| integer
| |
lifetime
| integer
| |
hits
| integer
| |
data
| object
| |
contact_id
| FK
| FK |
session_pageview
Doctrine entity: Admin\Entity\Pageview
Column | Doctrine type | Key |
|---|
pageview_id
| integer
| |
session_key
| string
| |
date
| datetime
| |
route
| string
| |
namespace
| string
| |
controller
| string
| |
action
| string
| |
params
| text
| |
contact_id
| FK
| FK |
Relationships
Source table | Association | Type | Source cardinality | Target cardinality | Target table | YuML |
|---|
access
| selection
| Many-to-many | 0..*
| 0..*
| selection
| [access]0..*-selection 0..*>[selection]
|
admin_authentication
| oAuth2Service
| Many-to-one | 0..*
| 0..1
| admin_oauth2_service
| [admin_authentication]0..*-oAuth2Service 0..1>[admin_oauth2_service]
|
admin_oauth2_service
| scope
| Many-to-one | 0..*
| 1
| oauth_scopes
| [admin_oauth2_service]0..*-scope 1>[oauth_scopes]
|
permit_contact
| access
| Many-to-one | 0..*
| 0..1
| access
| [permit_contact]0..*-access 0..1>[access]
|
permit_contact
| contact
| Many-to-one | 0..*
| 1
| contact
| [permit_contact]0..*-contact 1>[contact]
|
permit_contact
| role
| Many-to-one | 0..*
| 1
| permit_role
| [permit_contact]0..*-role 1>[permit_role]
|
permit_contact
| setter
| Many-to-one | 0..*
| 0..1
| permit_setter
| [permit_contact]0..*-setter 0..1>[permit_setter]
|
permit_role
| access
| Many-to-many | 0..*
| 0..*
| access
| [permit_role]0..*-access 0..*>[access]
|
permit_role
| entity
| Many-to-one | 0..*
| 1
| permit_entity
| [permit_role]0..*-entity 1>[permit_entity]
|
permit_setter
| entity
| Many-to-one | 0..*
| 1
| permit_entity
| [permit_setter]0..*-entity 1>[permit_entity]
|
permit_setter
| role
| Many-to-many | 0..*
| 0..*
| permit_role
| [permit_setter]0..*-role 0..*>[permit_role]
|
session
| contact
| Many-to-one | 0..*
| 1
| contact
| [session]0..*-contact 1>[contact]
|
session_pageview
| contact
| Many-to-one | 0..*
| 1
| contact
| [session_pageview]0..*-contact 1>[contact]
|
02 November 2026