country

254 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
address.country_id FK_D4E6F81F92F3E70R
categorycountrytax.country_id FK_9B13321BF92F3E70R
client.country_id FK_C7440455F92F3E70R
country_discount.country_id FK_D22AE5B3F92F3E70C
countrymetafield.country_id FK_887C52DDF92F3E70R
customer.country_id FK_81398E09F92F3E70R
liability.country_id FK_3B59ECCCF92F3E70R
offer.billingCountry_id FK_29D6873E4FFDFEE3R
offer.shippingCountry_id FK_29D6873EBD1BCD8AR
payment_country.country_id FK_4A3AC78CF92F3E70C
payment_excludedcountry.country_id FK_3D86084FF92F3E70C
product.countryoforigin_id FK_D34A04ADEAB5B262R
productcountrytax.country_id FK_32D356A6F92F3E70R
retailstore.country_id FK_1364CE6BF92F3E70R
shipping_country.country_id FK_B53BCFA2F92F3E70C
shipping_excludedcountry.country_id FK_E3AD2265F92F3E70C
shippingcost_country.country_id FK_C7CB7404F92F3E70C
shippingcost_excludedcountry.country_id FK_3B7D7D82F92F3E70C
state.country_id FK_A393D2FBF92F3E70R
tax.shipperCountry_id FK_8E81BA7693034E33R
vendorinformation.country_id FK_D0473C9CF92F3E70R
vendororder.billingCountry_id FK_82C1E65C4FFDFEE3R
vendororder.shippingCountry_id FK_82C1E65CBD1BCD8AR
vendororder.vendorCountry_id FK_82C1E65C31894D3CR
warehouse.country_id FK_ECB38BFCF92F3E70R
foreign_id VARCHAR 36 √ null
title VARCHAR 255 null
active BIT 1 null
isInEurope BIT 1 null
isocode VARCHAR 36 null
isocode2 VARCHAR 36 null
sort INT 10 null
currency_id VARCHAR 36 √ null
currency.id FK_5373C96638248176R
vatId VARCHAR 50 √ null
useVatOfThisShippingCountry BIT 1 null
useVatOfThisShippingCountryFromAll BIT 1 null
useVatOfThisShippingCountryByCustomCondition VARCHAR 255 √ null
useVatOfThisShippingCountryFromDate DATE 10 √ null
taxFree BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_5373C96638248176 Performance Asc currency_id
search_idx Performance Asc/Asc isocode + isocode2

Relationships

Close relationships within degrees of separation