> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # country table > Country information ## country Table (19) country MDO list item table. Country information ## Fields | Name | Description | Type | Nullable | | ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------- | :------: | | country\_id | Primary key | PK | No | | name | Name of country in installed language | String(239) | No | | rank | Rank order | UShort | Yes | | tooltip | Tooltip or other description | String(254) | Yes | | deleted | 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists | UShort | Yes | | english\_name | Name of country in english | String(39) | Yes | | zip\_prefix | N- DK- etc. | String(5) | Yes | | flagres\_id | Resource ID of flag graphic | UInt | Yes | | addressLayout | Points to address format used in the GUI | Id | No | | addressLayoutDomestic | Points to address format used for labels to own country | Id | No | | addressLayoutForeign | Points to address format used for labels to other countries than own country | Id | No | | currency\_id | Default currency for this country | FK [Currency](./currency.mdx) | Yes | | orgNrText | Lead text for organisation field | String(254) | Yes | | domainName | Default Web domain identifier (.no, .uk, etc; but without the dot) | String(9) | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Number of updates made to this record | UShort | No | | defaultLcid | LCID code in .NET, this should be the defaultLcid of the language that has the isDefault flag set in the LanguageInforCountry link table | UInt | Yes | | dialInPrefix | Prefix for dialing into the country from outside (country code) | String(31) | Yes | | dialOutPrefix | Prefix for dialling out of the country, voice call | String(31) | Yes | | interAreaPrefix | Prefix for inter-area dialling in the country | String(31) | Yes | | customPhoneDesc | Custom phone description, if any (comes from ISO/ITU documents) | String(254) | Yes | | phonePartOfNA | Is the phone system part of the North American system | Bool | Yes | | isBuiltIn | Is this record populated by SuperOffice priming data? | Bool | Yes | | isoNumber | The primary key used by ISO to identify countries when they have a revolution and change their name from Upper Volta to Burkina Faso :-) | UInt | Yes | | abbrev3 | ISO 3-letter abbreviation | String(3) | Yes | | abbrev2 | ISO 2-letter abbreviation | String(2) | Yes | | tzLocationId | Default timezone location for this country | FK [TZLocation](./tzlocation.mdx) | Yes | country table relationship diagram ## Indexes | Fields | Types | Description | | ------------- | ----------- | ----------- | | name | String(239) | Unique | | english\_name | String(39) | Index | ## Relationships | Table | Description | | -------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [associate](./associate) | Employees, resources and other users - except for External persons | | [contact](./contact) | Companies and Organizations. | | [CountryGroupLink](./countrygrouplink) | User group link table for Country, for MDO item hiding | | [CountryHeadingLink](./countryheadinglink) | Heading link table for Country, for MDO headers | | [Currency](./currency) | Currency list table | | [LanguageInfoCountry](./languageinfocountry) | Many-many link between countries and languages, to give intelligent choices for language | | [person](./person) | Persons | | [PhoneFormat](./phoneformat) | Formatting information for telephone numbers | | [QuoteVersion](./quoteversion) | There may be multiple Versions of a Quote, with one of them active | | [redletterday](./redletterday) | Red letter days for calendar (holidays, birthday of king etc) | | [TZLocation](./tzlocation) | Time zone location | | [ziptocity](./ziptocity) | Zip codes and city names. Zip codes used during address entry. You will find more information about addressformat on [http://techdoc.superoffice.com](http://techdoc.superoffice.com) | ## Replication Flags * Replicate changes DOWN from central to satellites and travellers. * Copy to satellite and travel prototypes. ## Security Flags * No access control via user's Role. ## Related topics - [LanguageInfoCountry table](/en/database/tables/languageinfocountry.md) - [CountryHeadingLink table](/en/database/tables/countryheadinglink.md) - [CountryGroupLink table](/en/database/tables/countrygrouplink.md) - [country](/en/api/mdo-providers/reference/country.md) - [Post Country](/en/api/reference/restful/rest/list_country/post-country.md) - [Put Country](/en/api/reference/restful/rest/list_country/put-country.md)