country Table (19)
•
Environment: onsite, online
Some tooltip text!
• 4 minutes to read
• 4 minutes to read
country MDO list item table. Country information
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| country_id | Primary key | PK | |
| name | Name of country in installed language | String(239) | |
| rank | Rank order | UShort | ● |
| tooltip | Tooltip or other description | String(254) | ● |
| deleted | 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists | UShort | ● |
| english_name | Name of country in english | String(39) | ● |
| zip_prefix | N- DK- etc. | String(5) | ● |
| flagres_id | Resource ID of flag graphic | UInt | ● |
| addressLayout | Points to address format used in the GUI | Id | |
| addressLayoutDomestic | Points to address format used for labels to own country | Id | |
| addressLayoutForeign | Points to address format used for labels to other countries than own country | Id | |
| currency_id | Default currency for this country | FK Currency | ● |
| orgNrText | Lead text for organisation field | String(254) | ● |
| domainName | Default Web domain identifier (.no, .uk, etc; but without the dot) | String(9) | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort | |
| 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 | ● |
| dialInPrefix | Prefix for dialing into the country from outside (country code) | String(31) | ● |
| dialOutPrefix | Prefix for dialling out of the country, voice call | String(31) | ● |
| interAreaPrefix | Prefix for inter-area dialling in the country | String(31) | ● |
| customPhoneDesc | Custom phone description, if any (comes from ISO/ITU documents) | String(254) | ● |
| phonePartOfNA | Is the phone system part of the North American system | Bool | ● |
| isBuiltIn | Is this record populated by SuperOffice priming data? | Bool | ● |
| 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 | ● |
| abbrev3 | ISO 3-letter abbreviation | String(3) | ● |
| abbrev2 | ISO 2-letter abbreviation | String(2) | ● |
| tzLocationId | Default timezone location for this country | FK TZLocation | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| country_id | PK | Clustered, Unique |
| name | String(239) | Unique |
| english_name | String(39) | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| contact | Companies and Organizations. This table features a special record containing information about the contact that owns the database. |
| CountryGroupLink | User group link table for Country, for MDO item hiding |
| CountryHeadingLink | Heading link table for Country, for MDO headers |
| Currency | Currency list table |
| LanguageInfoCountry | Many-many link between countries and languages, to give intelligent choices for language |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
| PhoneFormat | Formatting information for telephone numbers |
| QuoteVersion | There may be multiple Versions of a Quote, with one of them active |
| redletterday | Red letter days for calendar (holidays, birthday of king etc) |
| TZLocation | Time zone location |
| ziptocity | Zip codes and city names. Zip codes used during address entry. You will find more information about addressformat on 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.