Customer

Aggrosoft\WAWIBundle\Entity\Customer

Columns

Relations

106

Properties

Relationships

Click entity to navigate

→ Country → State ← Address ← CustomerContact ↔ Offer ↔ Offer ↔ Offer ← Offer ← Contact → Customer → Customer ← Customer ↔ Customer ↔ Customer → Client ↔ Client ↔ CustomerGroup ← CustomerMetaField → Payment → Payment → Shipping → Language → CostCenter → Address ← CustomerUpload ↔ VoucherSerie ↔ Discount ↔ Report → Country

erDiagram
    Customer {
                string id PK
                boolean blocked
                boolean deleted
                string foreignId
                datetime created
                string username
                        ___ ___more___
            }
                Customer }o--|| Country : "country"
        Country {
        int id PK
    }
                Customer }o--|| State : "state"
        State {
        int id PK
    }
                Customer ||--o{ Address : "addresses"
        Address {
        int id PK
    }
                Customer ||--o{ CustomerContact : "contactPersons"
        CustomerContact {
        int id PK
    }
                Customer ||--|| Offer : "activeOffer"
        Offer {
        int id PK
    }
                Customer ||--|| Offer : "activeOffer2"
        Offer {
        int id PK
    }
                Customer ||--|| Offer : "activeOffer3"
        Offer {
        int id PK
    }
                Customer ||--o{ Offer : "offers"
        Offer {
        int id PK
    }
                Customer ||--o{ Contact : "contacts"
        Contact {
        int id PK
    }
                Customer }o--|| Customer : "employer"
        Customer {
        int id PK
    }
                Customer }o--|| Customer : "invoiceCustomer"
        Customer {
        int id PK
    }
                Customer ||--o{ Customer : "employees"
        Customer {
        int id PK
    }
                Customer }o--o{ Customer : "advisers"
        Customer {
        int id PK
    }
                Customer }o--o{ Customer : "supportedCustomers"
        Customer {
        int id PK
    }
                Customer }o--|| Client : "client"
        Client {
        int id PK
    }
                Customer }o--o{ Client : "crossClients"
        Client {
        int id PK
    }
                Customer }o--o{ CustomerGroup : "groups"
        CustomerGroup {
        int id PK
    }
                Customer ||--o{ CustomerMetaField : "metafields"
        CustomerMetaField {
        int id PK
    }
                Customer }o--|| Payment : "payment"
        Payment {
        int id PK
    }
                Customer }o--|| Payment : "creditorPayment"
        Payment {
        int id PK
    }
                Customer }o--|| Shipping : "shipping"
        Shipping {
        int id PK
    }
                Customer }o--|| Language : "language"
        Language {
        int id PK
    }
                Customer }o--|| CostCenter : "costCenter"
        CostCenter {
        int id PK
    }
                Customer }o--|| Address : "defaultAddress"
        Address {
        int id PK
    }
                Customer ||--o{ CustomerUpload : "uploads"
        CustomerUpload {
        int id PK
    }
                Customer }o--o{ VoucherSerie : "voucherseries"
        VoucherSerie {
        int id PK
    }
                Customer }o--o{ Discount : "discounts"
        Discount {
        int id PK
    }
                Customer }o--o{ Report : "reports"
        Report {
        int id PK
    }
                Customer }o--|| Country : "exportCountry"
        Country {
        int id PK
    }

Metadaten

Tabelle customer

Bundle WAWIBundle

Repository Aggrosoft\WAWIBundle\Entity\Repository\CustomerRepository

Interfaces

IMetaExtendable IClientable IPrototype IReportable ICrossClientable IUpdateTimeTrackable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`blocked`	`blocked`	`boolean`		{{ entity.blocked }}
`deleted`	`deleted`	`boolean`		{{ entity.deleted }}
`foreignId`	`foreign_id`	`string(36)`		{{ entity.foreignId }}
`created`	`created`	`datetime`		{{ entity.created }}
`username`	`username`	`string(255)`		{{ entity.username }}
`email`	`email`	`string(255)`		{{ entity.email }}
`cc`	`cc`	`string(255)`		{{ entity.cc }}
`emailForInvoice`	`emailForInvoice`	`string(255)`		{{ entity.emailForInvoice }}
`emailForOrderConfirmation`	`emailForOrderConfirmation`	`string(255)`		{{ entity.emailForOrderConfirmation }}
`emailForContact`	`emailForContact`	`string(255)`		{{ entity.emailForContact }}
`notSendMailsForEmployeeContacts`	`notSendMailsForEmployeeContacts`	`boolean`		{{ entity.notSendMailsForEmployeeContacts }}
`pass`	`pass`	`string(128)`		{{ entity.pass }}
`salt`	`salt`	`string(128)`		{{ entity.salt }}
`customerNumber`	`customerNumber`	`string(36)`		{{ entity.customerNumber }}
`foreignCustomerNumber`	`foreignCustomerNumber`	`string(128)`		{{ entity.foreignCustomerNumber }}
`internalCustomerNumber`	`internalCustomerNumber`	`integer`		{{ entity.internalCustomerNumber }}
`uid`	`uid`	`string(128)`		{{ entity.uid }}
`glnNumber`	`glnNumber`	`string(128)`		{{ entity.glnNumber }}
`vatId`	`vatId`	`string(128)`		{{ entity.vatId }}
`vatIdStatus`	`vatIdStatus`	`integer`		{{ entity.vatIdStatus }}
`vatIdNote`	`vatIdNote`	`text`		{{ entity.vatIdNote }}
`vatNumber`	`vatNumber`	`string(128)`		{{ entity.vatNumber }}
`noTax`	`noTax`	`boolean`		{{ entity.noTax }}
`taxFreeInvoices`	`taxFreeInvoices`	`boolean`		{{ entity.taxFreeInvoices }}
`company`	`company`	`string(255)`		{{ entity.company }}
`title`	`title`	`string(255)`		{{ entity.title }}
`firstName`	`firstName`	`string(255)`		{{ entity.firstName }}
`lastName`	`lastName`	`string(255)`		{{ entity.lastName }}
`street`	`street`	`string(255)`		{{ entity.street }}
`city`	`city`	`string(255)`		{{ entity.city }}
`zip`	`zip`	`string(128)`		{{ entity.zip }}
`phone`	`phone`	`string(128)`		{{ entity.phone }}
`mobilePhone`	`mobilePhone`	`string(128)`		{{ entity.mobilePhone }}
`privatePhone`	`privatePhone`	`string(128)`		{{ entity.privatePhone }}
`fax`	`fax`	`string(128)`		{{ entity.fax }}
`salutation`	`salutation`	`string(128)`		{{ entity.salutation }}
`birthDate`	`birthDate`	`date`		{{ entity.birthDate }}
`boni`	`boni`	`integer`		{{ entity.boni }}
`creditBalance`	`creditBalance`	`decimal`		{{ entity.creditBalance }}
`url`	`url`	`string(255)`		{{ entity.url }}
`note`	`note`	`text`		{{ entity.note }}
`receivableAccount`	`receivableAccount`	`string(32)`		{{ entity.receivableAccount }}
`creditorAccount`	`creditorAccount`	`string(32)`		{{ entity.creditorAccount }}
`lastContact`	`lastContact`	`date`		{{ entity.lastContact }}
`additionalInfo`	`additionalInfo`	`string(255)`		{{ entity.additionalInfo }}
`bankAccountHolder`	`bankAccountHolder`	`string(255)`		{{ entity.bankAccountHolder }}
`bankName`	`bankName`	`string(255)`		{{ entity.bankName }}
`bicCode`	`bicCode`	`string(255)`		{{ entity.bicCode }}
`ibanNumber`	`ibanNumber`	`string(255)`		{{ entity.ibanNumber }}
`sepaMandate`	`sepaMandate`	`string(255)`		{{ entity.sepaMandate }}
`sepaMandateStatus`	`sepaMandateStatus`	`string(10)`		{{ entity.sepaMandateStatus }}
`paypalEMail`	`paypalEMail`	`string(255)`		{{ entity.paypalEMail }}
`paymentTerm`	`paymentTerm`	`integer(2)`		{{ entity.paymentTerm }}
`debitNotePaymentTerm`	`debitNotePaymentTerm`	`integer(2)`		{{ entity.debitNotePaymentTerm }}
`invoiceLimit`	`invoiceLimit`	`decimal`		{{ entity.invoiceLimit }}
`agentPercentFee`	`agentPercentFee`	`decimal`		{{ entity.agentPercentFee }}
`cashDiscountPercent`	`cashDiscountPercent`	`decimal`		{{ entity.cashDiscountPercent }}
`cashDiscountDays`	`cashDiscountDays`	`integer(8)`		{{ entity.cashDiscountDays }}
`agentFixFee`	`agentFixFee`	`decimal`		{{ entity.agentFixFee }}
`agentFeeFormula`	`agentFeeFormula`	`text`		{{ entity.agentFeeFormula }}
`agentUrlParameter`	`agentUrlParameter`	`string(255)`		{{ entity.agentUrlParameter }}
`uniqNumber`	`uniqNumber`	`string(128)`		{{ entity.uniqNumber }}
`nettoMode`	`nettoMode`	`boolean`		{{ entity.nettoMode }}
`offerAdditionalInfo`	`offerAdditionalInfo`	`text`		{{ entity.offerAdditionalInfo }}
`offerAdditionalInfo2`	`offerAdditionalInfo2`	`text`		{{ entity.offerAdditionalInfo2 }}
`offerAdditionalInfo3`	`offerAdditionalInfo3`	`text`		{{ entity.offerAdditionalInfo3 }}
`updated`	`updated`	`datetime`		{{ entity.updated }}

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

Property	Access	Twig Usage	Methods	Return Type
`label` Computed	read	{{ entity.label }}	`getLabel()`	-
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`foreignId` DB	read write	{{ entity.foreignId }}	`getForeignId()` `setForeignId()`	`string`
`username` DB	read write	{{ entity.username }}	`getUsername()` `setUsername()`	`string`
`email` DB	read write	{{ entity.email }}	`getEmail()` `setEmail()`	`string`
`newPassword` Computed	read write	{{ entity.newPassword }}	`getNewPassword()` `setNewPassword()`	-
`pass` DB	read write	{{ entity.pass }}	`getPass()` `setPass()`	`string`
`salt` DB	read write	{{ entity.salt }}	`getSalt()` `setSalt()`	`string`
`customerNumber` DB	read write	{{ entity.customerNumber }}	`getCustomerNumber()` `setCustomerNumber()`	`string`
`vatId` DB	read write	{{ entity.vatId }}	`getVatId()` `setVatId()`	`string`
`company` DB	read write	{{ entity.company }}	`getCompany()` `setCompany()`	`string`
`firstName` DB	read write	{{ entity.firstName }}	`getFirstName()` `setFirstName()`	`string`
`lastName` DB	read write	{{ entity.lastName }}	`getLastName()` `setLastName()`	`string`
`street` DB	read write	{{ entity.street }}	`getStreet()` `setStreet()`	`string`
`city` DB	read write	{{ entity.city }}	`getCity()` `setCity()`	`string`
`zip` DB	read write	{{ entity.zip }}	`getZip()` `setZip()`	`string`
`phone` DB	read write	{{ entity.phone }}	`getPhone()` `setPhone()`	`string`
`fax` DB	read write	{{ entity.fax }}	`getFax()` `setFax()`	`string`
`salutation` DB	read write	{{ entity.salutation }}	`getSalutation()` `setSalutation()`	`string`
`birthDate` DB	read write	{{ entity.birthDate }}	`getBirthDate()` `setBirthDate()`	`\DateTime`
`country` DB	read write	{{ entity.country }}	`getCountry()` `setCountry()`	`Aggrosoft\WAWIBundle\Entity\Country`
`state` DB	read write	{{ entity.state }}	`getState()` `setState()`	`Aggrosoft\WAWIBundle\Entity\State`
`addresses` DB	read	{{ entity.addresses }}	`getAddresses()`	`Doctrine\Common\Collections\Collection`
`client` DB	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`metafields` DB	read	{{ entity.metafields }}	`getMetafields()`	`\Doctrine\Common\Collections\Collection`
`mobilePhone` DB	read write	{{ entity.mobilePhone }}	`getMobilePhone()` `setMobilePhone()`	`string`
`privatePhone` DB	read write	{{ entity.privatePhone }}	`getPrivatePhone()` `setPrivatePhone()`	`string`
`boni` DB	read write	{{ entity.boni }}	`getBoni()` `setBoni()`	`integer`
`additionalInfo` DB	read write	{{ entity.additionalInfo }}	`getAdditionalInfo()` `setAdditionalInfo()`	`string`
`internalCustomerNumber` DB	read write	{{ entity.internalCustomerNumber }}	`getInternalCustomerNumber()` `setInternalCustomerNumber()`	`string`
`contacts` DB	read	{{ entity.contacts }}	`getContacts()`	`\Doctrine\Common\Collections\Collection`
`offers` DB	read	{{ entity.offers }}	`getOffers()`	`\Doctrine\Common\Collections\Collection`
`url` DB	read write	{{ entity.url }}	`getUrl()` `setUrl()`	`string`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`lastContact` DB	read write	{{ entity.lastContact }}	`getLastContact()` `setLastContact()`	`\DateTime`
`groups` DB	read	{{ entity.groups }}	`getGroups()`	`\Doctrine\Common\Collections\Collection`
`receivableContact` Computed	read write	{{ entity.receivableContact }}	`getReceivableContact()` `setReceivableContact()`	`string`
`receivableAccount` DB	read write	{{ entity.receivableAccount }}	`getReceivableAccount()` `setReceivableAccount()`	`string`
`payment` DB	read write	{{ entity.payment }}	`getPayment()` `setPayment()`	`\Aggrosoft\WAWIBundle\Entity\Payment`
`shipping` DB	read write	{{ entity.shipping }}	`getShipping()` `setShipping()`	`\Aggrosoft\WAWIBundle\Entity\Shipping`
`language` DB	read write	{{ entity.language }}	`getLanguage()` `setLanguage()`	`\Aggrosoft\WAWIBundle\Entity\Language`
`blocked` DB	read write	{{ entity.blocked }}	`getBlocked()` `setBlocked()`	`boolean`
`nettoMode` DB	read write	{{ entity.nettoMode }}	`getNettoMode()` `setNettoMode()`	`boolean`
`offerAdditionalInfo` DB	read write	{{ entity.offerAdditionalInfo }}	`getOfferAdditionalInfo()` `setOfferAdditionalInfo()`	`string`
`offerAdditionalInfo2` DB	read write	{{ entity.offerAdditionalInfo2 }}	`getOfferAdditionalInfo2()` `setOfferAdditionalInfo2()`	`string`
`offerAdditionalInfo3` DB	read write	{{ entity.offerAdditionalInfo3 }}	`getOfferAdditionalInfo3()` `setOfferAdditionalInfo3()`	`string`
`bankAccountHolder` DB	read write	{{ entity.bankAccountHolder }}	`getBankAccountHolder()` `setBankAccountHolder()`	`string`
`bankName` DB	read write	{{ entity.bankName }}	`getBankName()` `setBankName()`	`string`
`bicCode` DB	read write	{{ entity.bicCode }}	`getBicCode()` `setBicCode()`	`string`
`ibanNumber` DB	read write	{{ entity.ibanNumber }}	`getIbanNumber()` `setIbanNumber()`	`string`
`paymentTerm` DB	read write	{{ entity.paymentTerm }}	`getPaymentTerm()` `setPaymentTerm()`	`integer`
`creditorAccount` DB	read write	{{ entity.creditorAccount }}	`getCreditorAccount()` `setCreditorAccount()`	`string`
`paypalEMail` DB	read write	{{ entity.paypalEMail }}	`getPaypalEMail()` `setPaypalEMail()`	`string`
`creditorPayment` DB	read write	{{ entity.creditorPayment }}	`getCreditorPayment()` `setCreditorPayment()`	`\Aggrosoft\WAWIBundle\Entity\Payment`
`uploads` DB	read	{{ entity.uploads }}	`getUploads()`	`\Doctrine\Common\Collections\Collection`
`vatNumber` DB	read write	{{ entity.vatNumber }}	`getVatNumber()` `setVatNumber()`	`string`
`noTax` DB	read write	{{ entity.noTax }}	`getNoTax()` `setNoTax()`	`boolean`
`agentPercentFee` DB	read write	{{ entity.agentPercentFee }}	`getAgentPercentFee()` `setAgentPercentFee()`	`string`
`agentFixFee` DB	read write	{{ entity.agentFixFee }}	`getAgentFixFee()` `setAgentFixFee()`	`string`
`agentFeeFormula` DB	read write	{{ entity.agentFeeFormula }}	`getAgentFeeFormula()` `setAgentFeeFormula()`	`string`
`voucherseries` DB	read	{{ entity.voucherseries }}	`getVoucherseries()`	`\Doctrine\Common\Collections\Collection`
`sepaMandate` DB	read write	{{ entity.sepaMandate }}	`getSepaMandate()` `setSepaMandate()`	`string`
`sepaMandateStatus` DB	read write	{{ entity.sepaMandateStatus }}	`getSepaMandateStatus()` `setSepaMandateStatus()`	`string`
`reports` DB	read	{{ entity.reports }}	`getReports()`	`\Doctrine\Common\Collections\Collection`
`cashDiscountPercent` DB	read write	{{ entity.cashDiscountPercent }}	`getCashDiscountPercent()` `setCashDiscountPercent()`	`string`
`cashDiscountDays` DB	read write	{{ entity.cashDiscountDays }}	`getCashDiscountDays()` `setCashDiscountDays()`	`integer`
`cashDiscountPercentAlsoInGroups` Computed	read	{{ entity.cashDiscountPercentAlsoInGroups }}	`getCashDiscountPercentAlsoInGroups()`	-
`cashDiscountDaysAlsoInGroups` Computed	read	{{ entity.cashDiscountDaysAlsoInGroups }}	`getCashDiscountDaysAlsoInGroups()`	-
`discounts` DB	read	{{ entity.discounts }}	`getDiscounts()`	`\Doctrine\Common\Collections\Collection`
`uid` DB	read write	{{ entity.uid }}	`getUid()` `setUid()`	`string`
`emailForInvoice` DB	read write	{{ entity.emailForInvoice }}	`getEmailForInvoice()` `setEmailForInvoice()`	`string`
`created` DB	read write	{{ entity.created }}	`getCreated()` `setCreated()`	`\DateTime`
`crossClients` DB	read	{{ entity.crossClients }}	`getCrossClients()`	`\Doctrine\Common\Collections\Collection`
`defaultAddress` DB	read write	{{ entity.defaultAddress }}	`getDefaultAddress()` `setDefaultAddress()`	`\Aggrosoft\WAWIBundle\Entity\Address`
`deleted` DB	read write	{{ entity.deleted }}	`getDeleted()` `setDeleted()`	`boolean`
`activeOffer` DB	read write	{{ entity.activeOffer }}	`getActiveOffer()` `setActiveOffer()`	`\Aggrosoft\WAWIBundle\Entity\Offer`
`debitNotePaymentTerm` DB	read write	{{ entity.debitNotePaymentTerm }}	`getDebitNotePaymentTerm()` `setDebitNotePaymentTerm()`	`integer`
`creditBalance` DB	read write	{{ entity.creditBalance }}	`getCreditBalance()` `setCreditBalance()`	`string`
`foreignCustomerNumber` DB	read write	{{ entity.foreignCustomerNumber }}	`getForeignCustomerNumber()` `setForeignCustomerNumber()`	`string`
`contactPersons` DB	read	{{ entity.contactPersons }}	`getContactPersons()`	`\Doctrine\Common\Collections\Collection`
`employer` DB	read write	{{ entity.employer }}	`getEmployer()` `setEmployer()`	`\Aggrosoft\WAWIBundle\Entity\Customer`
`employees` DB	read write	{{ entity.employees }}	`getEmployees()` `setEmployees()`	`\Doctrine\Common\Collections\Collection`
`advisers` DB	read write	{{ entity.advisers }}	`getAdvisers()` `setAdvisers()`	`\Doctrine\Common\Collections\Collection`
`supportedCustomers` DB	read	{{ entity.supportedCustomers }}	`getSupportedCustomers()`	`\Doctrine\Common\Collections\Collection`
`vatIdStatus` DB	read write	{{ entity.vatIdStatus }}	`getVatIdStatus()` `setVatIdStatus()`	`integer`
`activeOffer2` DB	read write	{{ entity.activeOffer2 }}	`getActiveOffer2()` `setActiveOffer2()`	`\Aggrosoft\WAWIBundle\Entity\Offer`
`activeOffer3` DB	read write	{{ entity.activeOffer3 }}	`getActiveOffer3()` `setActiveOffer3()`	`\Aggrosoft\WAWIBundle\Entity\Offer`
`agentUrlParameter` DB	read write	{{ entity.agentUrlParameter }}	`getAgentUrlParameter()` `setAgentUrlParameter()`	`string`
`glnNumber` DB	read write	{{ entity.glnNumber }}	`getGlnNumber()` `setGlnNumber()`	`string`
`invoiceLimit` DB	read write	{{ entity.invoiceLimit }}	`getInvoiceLimit()` `setInvoiceLimit()`	`string`
`locale` Computed	read write	{{ entity.locale }}	`getLocale()` `setLocale()`	-
`cc` DB	read write	{{ entity.cc }}	`getCc()` `setCc()`	`string`
`emailForContact` DB	read write	{{ entity.emailForContact }}	`getEmailForContact()` `setEmailForContact()`	`string`
`notSendMailsForEmployeeContacts` DB	read write	{{ entity.notSendMailsForEmployeeContacts }}	`getNotSendMailsForEmployeeContacts()` `setNotSendMailsForEmployeeContacts()`	`boolean`
`emailForOrderConfirmation` DB	read write	{{ entity.emailForOrderConfirmation }}	`getEmailForOrderConfirmation()` `setEmailForOrderConfirmation()`	`string`
`costCenter` DB	read write	{{ entity.costCenter }}	`getCostCenter()` `setCostCenter()`	`\Aggrosoft\WAWIBundle\Entity\CostCenter`
`vatIdNote` DB	read write	{{ entity.vatIdNote }}	`getVatIdNote()` `setVatIdNote()`	`string`
`invoiceCustomer` DB	read write	{{ entity.invoiceCustomer }}	`getInvoiceCustomer()` `setInvoiceCustomer()`	`\Aggrosoft\WAWIBundle\Entity\Customer`
`uniqNumber` DB	read write	{{ entity.uniqNumber }}	`getUniqNumber()` `setUniqNumber()`	`string`
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`
`streetWithoutHouseNumber` Computed	read	{{ entity.streetWithoutHouseNumber }}	`getStreetWithoutHouseNumber()`	-
`houseNumber` Computed	read	{{ entity.houseNumber }}	`getHouseNumber()`	-
`streetParts` Computed	read	{{ entity.streetParts }}	`getStreetParts()`	-
`taxFreeInvoices` DB	read write	{{ entity.taxFreeInvoices }}	`getTaxFreeInvoices()` `setTaxFreeInvoices()`	`boolean`
`exportCountry` DB	read write	{{ entity.exportCountry }}	`getExportCountry()` `setExportCountry()`	`\Aggrosoft\WAWIBundle\Entity\Country`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`country`	ManyToOne	Country	-	`customers`	-	{{ entity.country }}
`state`	ManyToOne	State	-	`customers`	-	{{ entity.state }}
`addresses`	OneToMany	Address	`customer`	-	`all`	{{ entity.addresses }}
`contactPersons`	OneToMany	CustomerContact	`customer`	-	`all`	{{ entity.contactPersons }}
`activeOffer`	OneToOne	Offer	-	-	-	{{ entity.activeOffer }}
`activeOffer2`	OneToOne	Offer	-	-	-	{{ entity.activeOffer2 }}
`activeOffer3`	OneToOne	Offer	-	-	-	{{ entity.activeOffer3 }}
`offers`	OneToMany	Offer	`customer`	-	-	{{ entity.offers }}
`contacts`	OneToMany	Contact	`customer`	-	`remove`	{{ entity.contacts }}
`employer`	ManyToOne	Customer	-	-	-	{{ entity.employer }}
`invoiceCustomer`	ManyToOne	Customer	-	-	-	{{ entity.invoiceCustomer }}
`employees`	OneToMany	Customer	`employer`	-	`persist` `remove`	{{ entity.employees }}
`advisers`	ManyToMany	Customer	-	`supportedCustomers`	-	{{ entity.advisers }}
`supportedCustomers`	ManyToMany	Customer	`advisers`	-	-	{{ entity.supportedCustomers }}
`client`	ManyToOne	Client	-	`customers`	-	{{ entity.client }}
`crossClients`	ManyToMany	Client	-	`crossCustomers`	-	{{ entity.crossClients }}
`groups`	ManyToMany	CustomerGroup	-	`customers`	`persist`	{{ entity.groups }}
`metafields`	OneToMany	CustomerMetaField	`customer`	-	`persist` `remove`	{{ entity.metafields }}
`payment`	ManyToOne	Payment	-	`customers`	-	{{ entity.payment }}
`creditorPayment`	ManyToOne	Payment	-	-	-	{{ entity.creditorPayment }}
`shipping`	ManyToOne	Shipping	-	`customers`	-	{{ entity.shipping }}
`language`	ManyToOne	Language	-	`customers`	-	{{ entity.language }}
`costCenter`	ManyToOne	CostCenter	-	-	-	{{ entity.costCenter }}
`defaultAddress`	ManyToOne	Address	-	`customersDefault`	-	{{ entity.defaultAddress }}
`uploads`	OneToMany	CustomerUpload	`customer`	-	`all`	{{ entity.uploads }}
`voucherseries`	ManyToMany	VoucherSerie	-	`customers`	-	{{ entity.voucherseries }}
`discounts`	ManyToMany	Discount	-	`customers`	-	{{ entity.discounts }}
`reports`	ManyToMany	Report	-	`customers`	`persist`	{{ entity.reports }}
`exportCountry`	ManyToOne	Country	-	-	-	{{ entity.exportCountry }}

Index Name	Columns	Type
`search_idx`	`foreign_id`	INDEX
`customernumber_idx`	`internalCustomerNumber`	INDEX
`email_idx`	`email`	INDEX
`name_idx`	`firstName` `lastName`	INDEX
`customernumber_idx`	`customerNumber`	INDEX