Accounting database reference
This reference is generated from the Doctrine ORM metadata.
Entities
accounting_adapter
Doctrine entity: Accounting\Entity\AccountingAdapter
Column | Doctrine type | Key |
|---|
id
| integer
| |
name
| string
| |
description
| text
| |
ledger
| string
| |
accessToken
| text
| |
refreshToken
| text
| |
dateExpire
| datetime
| |
dateCreated
| datetime
| |
lastUpdate
| datetime
| |
isActive
| boolean
| |
type
| smallint
| |
oAuth2Service_id
| FK
| FK |
accounting_invoice_provider
Doctrine entity: Accounting\Entity\InvoiceProvider
Column | Doctrine type | Key |
|---|
id
| integer
| |
name
| string
| |
accountName
| string
| |
description
| text
| |
apiKey
| text
| |
dateCreated
| datetime
| |
lastUpdate
| datetime
| |
isActive
| boolean
| |
type
| smallint
| |
hash
| string
| |
accounting_invoice_provider_client
Doctrine entity: Accounting\Entity\InvoiceProvider\Client
Column | Doctrine type | Key |
|---|
client_id
| integer
| |
external_client_id
| integer
| |
date_created
| datetime
| |
last_update
| datetime
| |
raw_data
| json
| |
invoiceProvider_id
| FK
| FK |
contact_id
| FK
| FK |
accounting_invoice_provider_invoice
Doctrine entity: Accounting\Entity\InvoiceProvider\Invoice
Column | Doctrine type | Key |
|---|
id
| integer
| |
StatusRepository
| string
| |
invoiceNumber
| string
| |
external_invoice_id
| integer
| |
date_created
| datetime
| |
last_update
| datetime
| |
raw_data
| json
| |
invoiceProvider_id
| FK
| FK |
invoice_id
| FK
| FK |
accounting_payment_provider
Doctrine entity: Accounting\Entity\PaymentProvider
Column | Doctrine type | Key |
|---|
id
| integer
| |
name
| string
| |
description
| text
| |
apiKey
| text
| |
dateCreated
| datetime
| |
lastUpdate
| datetime
| |
isActive
| boolean
| |
type
| smallint
| |
hash
| string
| |
transaction
Doctrine entity: Accounting\Entity\PaymentProvider\Transaction
Column | Doctrine type | Key |
|---|
transaction_id
| integer
| |
description
| string
| |
amount
| decimal
| |
amount_refunded
| decimal
| |
amount_remaining
| decimal
| |
method
| string
| |
StatusRepository
| string
| |
metadata
| string
| |
payment_identifier
| string
| |
date_created
| datetime
| |
date_cancelled
| datetime
| |
date_expired
| datetime
| |
date_paid
| datetime
| |
hash
| string
| |
paymentProvider_id
| FK
| FK |
Relationships
Source table | Association | Type | Source cardinality | Target cardinality | Target table | YuML |
|---|
accounting_adapter
| oAuth2Service
| Many-to-one | 0..*
| 0..1
| admin_oauth2_service
| [accounting_adapter]0..*-oAuth2Service 0..1>[admin_oauth2_service]
|
accounting_invoice_provider_client
| invoiceProvider
| Many-to-one | 0..*
| 1
| accounting_invoice_provider
| [accounting_invoice_provider_client]0..*-invoiceProvider 1>[accounting_invoice_provider]
|
accounting_invoice_provider_client
| contact
| One-to-one | 0..1
| 1
| contact
| [accounting_invoice_provider_client]0..1-contact 1>[contact]
|
accounting_invoice_provider_invoice
| invoiceProvider
| Many-to-one | 0..*
| 1
| accounting_invoice_provider
| [accounting_invoice_provider_invoice]0..*-invoiceProvider 1>[accounting_invoice_provider]
|
accounting_invoice_provider_invoice
| invoice
| One-to-one | 0..1
| 1
| invoice
| [accounting_invoice_provider_invoice]0..1-invoice 1>[invoice]
|
transaction
| paymentProvider
| Many-to-one | 0..*
| 1
| accounting_payment_provider
| [transaction]0..*-paymentProvider 1>[accounting_payment_provider]
|
02 November 2026