Country

Aggrosoft\WAWIBundle\Entity\Country

Columns

Relations

Properties

Relationships

Click entity to navigate

→ Currency ← Customer ← State ← Address ← CountryMetaField ↔ ShippingCost ↔ Discount

erDiagram
    Country {
                string id PK
                string foreignId
                string title
                boolean active
                boolean isInEurope
                string isocode
                        ___ ___more___
            }
                Country }o--|| Currency : "currency"
        Currency {
        int id PK
    }
                Country ||--o{ Customer : "customers"
        Customer {
        int id PK
    }
                Country ||--o{ State : "states"
        State {
        int id PK
    }
                Country ||--o{ Address : "addresses"
        Address {
        int id PK
    }
                Country ||--o{ CountryMetaField : "metafields"
        CountryMetaField {
        int id PK
    }
                Country }o--o{ ShippingCost : "shippingcosts"
        ShippingCost {
        int id PK
    }
                Country }o--o{ Discount : "discounts"
        Discount {
        int id PK
    }

Metadaten

Tabelle country

Bundle WAWIBundle

Repository Aggrosoft\WAWIBundle\Entity\Repository\CountryRepository

Interfaces

Translatable IMetaExtendable IHasLanguage IPrototype

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`foreignId`	`foreign_id`	`string(36)`		{{ entity.foreignId }}
`title`	`title`	`string(255)`		{{ entity.title }}
`active`	`active`	`boolean`		{{ entity.active }}
`isInEurope`	`isInEurope`	`boolean`		{{ entity.isInEurope }}
`isocode`	`isocode`	`string(36)`		{{ entity.isocode }}
`isocode2`	`isocode2`	`string(36)`		{{ entity.isocode2 }}
`sort`	`sort`	`integer(11)`		{{ entity.sort }}
`vatId`	`vatId`	`string(50)`		{{ entity.vatId }}
`useVatOfThisShippingCountry`	`useVatOfThisShippingCountry`	`boolean`		{{ entity.useVatOfThisShippingCountry }}
`useVatOfThisShippingCountryFromAll`	`useVatOfThisShippingCountryFromAll`	`boolean`		{{ entity.useVatOfThisShippingCountryFromAll }}
`useVatOfThisShippingCountryFromDate`	`useVatOfThisShippingCountryFromDate`	`date`		{{ entity.useVatOfThisShippingCountryFromDate }}
`useVatOfThisShippingCountryByCustomCondition`	`useVatOfThisShippingCountryByCustomCondition`	`string(255)`		{{ entity.useVatOfThisShippingCountryByCustomCondition }}
`taxFree`	`taxFree`	`boolean`		{{ entity.taxFree }}

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

Property	Access	Twig Usage	Methods	Return Type
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`foreignId` DB	read write	{{ entity.foreignId }}	`getForeignId()` `setForeignId()`	`string`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`active` DB	read write	{{ entity.active }}	`getActive()` `setActive()`	`boolean`
`isocode` DB	read write	{{ entity.isocode }}	`getIsocode()` `setIsocode()`	`string`
`sort` DB	read write	{{ entity.sort }}	`getSort()` `setSort()`	`integer`
`customers` DB	read	{{ entity.customers }}	`getCustomers()`	`Doctrine\Common\Collections\Collection`
`states` DB	read	{{ entity.states }}	`getStates()`	`Doctrine\Common\Collections\Collection`
`addresses` DB	read	{{ entity.addresses }}	`getAddresses()`	`Doctrine\Common\Collections\Collection`
`isInEurope` DB	read write	{{ entity.isInEurope }}	`getIsInEurope()` `setIsInEurope()`	`boolean`
`isocode2` DB	read write	{{ entity.isocode2 }}	`getIsocode2()` `setIsocode2()`	`string`
`translatableLocale` Computed	write		`setTranslatableLocale()`	-
`metafields` DB	read	{{ entity.metafields }}	`getMetafields()`	`\Doctrine\Common\Collections\Collection`
`shippingcosts` DB	read	{{ entity.shippingcosts }}	`getShippingcosts()`	`\Doctrine\Common\Collections\Collection`
`discounts` DB	read	{{ entity.discounts }}	`getDiscounts()`	`\Doctrine\Common\Collections\Collection`
`vatId` DB	read write	{{ entity.vatId }}	`getVatId()` `setVatId()`	`string`
`currency` DB	read write	{{ entity.currency }}	`getCurrency()` `setCurrency()`	`\Aggrosoft\WAWIBundle\Entity\Currency`
`useVatOfThisShippingCountry` DB	read write	{{ entity.useVatOfThisShippingCountry }}	`getUseVatOfThisShippingCountry()` `setUseVatOfThisShippingCountry()`	`boolean`
`useVatOfThisShippingCountryFromAll` DB	read write	{{ entity.useVatOfThisShippingCountryFromAll }}	`getUseVatOfThisShippingCountryFromAll()` `setUseVatOfThisShippingCountryFromAll()`	`boolean`
`language` Computed	read	{{ entity.language }}	`getLanguage()`	-
`selectedLanguage` Computed	read write	{{ entity.selectedLanguage }}	`getSelectedLanguage()` `setSelectedLanguage()`	-
`useVatOfThisShippingCountryByCustomCondition` DB	read write	{{ entity.useVatOfThisShippingCountryByCustomCondition }}	`getUseVatOfThisShippingCountryByCustomCondition()` `setUseVatOfThisShippingCountryByCustomCondition()`	`string`
`useVatOfThisShippingCountryFromDate` DB	read write	{{ entity.useVatOfThisShippingCountryFromDate }}	`getUseVatOfThisShippingCountryFromDate()` `setUseVatOfThisShippingCountryFromDate()`	`\DateTime`
`entityLocale` Computed	read	{{ entity.entityLocale }}	`getEntityLocale()`	-
`taxFree` DB	read write	{{ entity.taxFree }}	`getTaxFree()` `setTaxFree()`	`boolean`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`currency`	ManyToOne	Currency	-	-	-	{{ entity.currency }}
`customers`	OneToMany	Customer	`country`	-	-	{{ entity.customers }}
`states`	OneToMany	State	`country`	-	-	{{ entity.states }}
`addresses`	OneToMany	Address	`country`	-	-	{{ entity.addresses }}
`metafields`	OneToMany	CountryMetaField	`country`	-	`persist` `remove`	{{ entity.metafields }}
`shippingcosts`	ManyToMany	ShippingCost	`countries`	-	-	{{ entity.shippingcosts }}
`discounts`	ManyToMany	Discount	-	`countries`	-	{{ entity.discounts }}

Index Name	Columns	Type
`search_idx`	`isocode` `isocode2`	INDEX