Api database reference
This reference is generated from the Doctrine ORM metadata.
Entities
oauth_access_tokens
Doctrine entity: Api\Entity\OAuth\AccessToken
Column | Doctrine type | Key |
|---|
id
| integer
| |
access_token
| text
| |
expires
| datetime_immutable
| |
scope
| string
| |
client_id
| FK
| FK |
user_id
| FK
| FK |
oauth_authorization_codes
Doctrine entity: Api\Entity\OAuth\AuthorizationCode
Column | Doctrine type | Key |
|---|
id
| integer
| |
authorization_code
| string
| |
expires
| datetime_immutable
| |
redirect_uri
| string
| |
scope
| string
| |
id_token
| string
| |
code_challenge
| string
| |
code_challenge_method
| string
| |
client_id
| FK
| FK |
user_id
| FK
| FK |
oauth_clients
Doctrine entity: Api\Entity\OAuth\Client
Column | Doctrine type | Key |
|---|
client_id
| string
| |
client_secret
| string
| |
name
| string
| |
description
| text
| |
client_secret_teaser
| string
| |
redirect_uri
| string
| |
grant_types
| string
| |
scope_id
| FK
| FK |
oauth_jwt
Doctrine entity: Api\Entity\OAuth\Jwt
Column | Doctrine type | Key |
|---|
id
| integer
| |
public_key
| string
| |
subject
| string
| |
client_id
| FK
| FK |
oauth_public_keys
Doctrine entity: Api\Entity\OAuth\PublicKey
Column | Doctrine type | Key |
|---|
id
| integer
| |
public_key
| text
| |
private_key
| text
| |
encryption_algorithm
| string
| |
client_id
| FK
| FK |
oauth_refresh_tokens
Doctrine entity: Api\Entity\OAuth\RefreshToken
Column | Doctrine type | Key |
|---|
id
| integer
| |
refresh_token
| string
| |
expires
| datetime_immutable
| |
scope
| string
| |
client_id
| FK
| FK |
user_id
| FK
| FK |
oauth_scopes
Doctrine entity: Api\Entity\OAuth\Scope
Column | Doctrine type | Key |
|---|
id
| integer
| |
type
| string
| |
scope
| string
| |
is_default
| boolean
| |
Relationships
Source table | Association | Type | Source cardinality | Target cardinality | Target table | YuML |
|---|
oauth_access_tokens
| client
| Many-to-one | 0..*
| 1
| oauth_clients
| [oauth_access_tokens]0..*-client 1>[oauth_clients]
|
oauth_access_tokens
| contact
| Many-to-one | 0..*
| 0..1
| contact
| [oauth_access_tokens]0..*-contact 0..1>[contact]
|
oauth_authorization_codes
| client
| Many-to-one | 0..*
| 1
| oauth_clients
| [oauth_authorization_codes]0..*-client 1>[oauth_clients]
|
oauth_authorization_codes
| contact
| Many-to-one | 0..*
| 0..1
| contact
| [oauth_authorization_codes]0..*-contact 0..1>[contact]
|
oauth_clients
| scope
| Many-to-one | 0..*
| 1
| oauth_scopes
| [oauth_clients]0..*-scope 1>[oauth_scopes]
|
oauth_jwt
| client
| Many-to-one | 0..*
| 1
| oauth_clients
| [oauth_jwt]0..*-client 1>[oauth_clients]
|
oauth_public_keys
| client
| One-to-one | 0..1
| 1
| oauth_clients
| [oauth_public_keys]0..1-client 1>[oauth_clients]
|
oauth_refresh_tokens
| client
| Many-to-one | 0..*
| 1
| oauth_clients
| [oauth_refresh_tokens]0..*-client 1>[oauth_clients]
|
oauth_refresh_tokens
| contact
| Many-to-one | 0..*
| 0..1
| contact
| [oauth_refresh_tokens]0..*-contact 0..1>[contact]
|
02 November 2026