KlarnaTransaction

Aggrosoft\WAWIBundle\Entity\KlarnaTransaction

Columns

Relations

Properties

Relationships

Click entity to navigate

erDiagram
    KlarnaTransaction {
                string id PK
                string foreignId
                decimal amount
                datetime captureDate
                datetime saleDate
                string captureId
                        ___ ___more___
            }
                KlarnaTransaction }o--|| Order : "order"
        Order {
        int id PK
    }
                KlarnaTransaction }o--|| Country : "purchaseCountry"
        Country {
        int id PK
    }
                KlarnaTransaction }o--|| Country : "shippingCountry"
        Country {
        int id PK
    }
                KlarnaTransaction }o--|| Client : "client"
        Client {
        int id PK
    }

Metadaten

Tabelle klarnatransaction

Bundle WAWIBundle

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`foreignId`	`foreignId`	`string(255)`		{{ entity.foreignId }}
`amount`	`amount`	`decimal(11,2)`		{{ entity.amount }}
`captureDate`	`captureDate`	`datetime`		{{ entity.captureDate }}
`saleDate`	`saleDate`	`datetime`		{{ entity.saleDate }}
`captureId`	`captureId`	`string(128)`		{{ entity.captureId }}
`merchantReference1`	`merchantReference1`	`string(255)`		{{ entity.merchantReference1 }}
`merchantReference2`	`merchantReference2`	`string(255)`		{{ entity.merchantReference2 }}
`shortOrderId`	`shortOrderId`	`string(255)`		{{ entity.shortOrderId }}
`type`	`type`	`string(32)`		{{ entity.type }}
`paymentReference`	`paymentReference`	`string(255)`		{{ entity.paymentReference }}
`refundId`	`refundId`	`string(128)`		{{ entity.refundId }}
`merchantCaptureReference`	`merchantCaptureReference`	`string(255)`		{{ entity.merchantCaptureReference }}
`merchantRefundReference`	`merchantRefundReference`	`string(255)`		{{ entity.merchantRefundReference }}
`currencyCode`	`currencyCode`	`string(6)`		{{ entity.currencyCode }}
`vatRate`	`vatRate`	`decimal(11,2)`		{{ entity.vatRate }}
`vatAmount`	`vatAmount`	`decimal(11,2)`		{{ entity.vatAmount }}
`detailedType`	`detailedType`	`string(128)`		{{ entity.detailedType }}

Tipp: Diese Properties sind über Getter/Setter-Methoden in Twig verfügbar. Verwende {{ entity.propertyName }} zum Lesen.

Property	Access	Twig Usage	Methods	Return Type
`client` DB	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`amount` DB	read write	{{ entity.amount }}	`getAmount()` `setAmount()`	`string`
`captureDate` DB	read write	{{ entity.captureDate }}	`getCaptureDate()` `setCaptureDate()`	`\DateTime`
`captureId` DB	read write	{{ entity.captureId }}	`getCaptureId()` `setCaptureId()`	`string`
`merchantReference1` DB	read write	{{ entity.merchantReference1 }}	`getMerchantReference1()` `setMerchantReference1()`	`string`
`merchantReference2` DB	read write	{{ entity.merchantReference2 }}	`getMerchantReference2()` `setMerchantReference2()`	`string`
`type` DB	read write	{{ entity.type }}	`getType()` `setType()`	`string`
`paymentReference` DB	read write	{{ entity.paymentReference }}	`getPaymentReference()` `setPaymentReference()`	`string`
`refundId` DB	read write	{{ entity.refundId }}	`getRefundId()` `setRefundId()`	`string`
`merchantCaptureReference` DB	read write	{{ entity.merchantCaptureReference }}	`getMerchantCaptureReference()` `setMerchantCaptureReference()`	`string`
`merchantRefundReference` DB	read write	{{ entity.merchantRefundReference }}	`getMerchantRefundReference()` `setMerchantRefundReference()`	`string`
`currencyCode` DB	read write	{{ entity.currencyCode }}	`getCurrencyCode()` `setCurrencyCode()`	`string`
`vatRate` DB	read write	{{ entity.vatRate }}	`getVatRate()` `setVatRate()`	`string`
`vatAmount` DB	read write	{{ entity.vatAmount }}	`getVatAmount()` `setVatAmount()`	`string`
`detailedType` DB	read write	{{ entity.detailedType }}	`getDetailedType()` `setDetailedType()`	`string`
`order` DB	read write	{{ entity.order }}	`getOrder()` `setOrder()`	`\Aggrosoft\WAWIBundle\Entity\Order`
`purchaseCountry` DB	read write	{{ entity.purchaseCountry }}	`getPurchaseCountry()` `setPurchaseCountry()`	`\Aggrosoft\WAWIBundle\Entity\Country`
`shippingCountry` DB	read write	{{ entity.shippingCountry }}	`getShippingCountry()` `setShippingCountry()`	`\Aggrosoft\WAWIBundle\Entity\Country`
`foreignId` DB	read write	{{ entity.foreignId }}	`getForeignId()` `setForeignId()`	`string`
`shortOrderId` DB	read write	{{ entity.shortOrderId }}	`getShortOrderId()` `setShortOrderId()`	`string`
`saleDate` DB	read write	{{ entity.saleDate }}	`getSaleDate()` `setSaleDate()`	`\DateTime`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`order`	ManyToOne	Order	-	-	-	{{ entity.order }}
`purchaseCountry`	ManyToOne	Country	-	-	-	{{ entity.purchaseCountry }}
`shippingCountry`	ManyToOne	Country	-	-	-	{{ entity.shippingCountry }}
`client`	ManyToOne	Client	-	-	-	{{ entity.client }}

Index Name	Columns	Type
`foreignId_idx`	`foreignId`	INDEX