SchemaSpy Analysis of meta_common - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Apr 25 13:19 CEST 2012 |
| ||||||
|
meta_common contains 117 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
users | creation_time | datetime | 19 | 0000-00-00 00:00:00 | Date & Time at which this record has been inserted | ||
users | deleted_from_ldap | enum | 2 | √ | n | If set to 'y' the user has been deleted from LDAP | |
languages | eu_language | enum | 2 | 0 | 1 if the language is an official language of the European Union | ||
countries | eu_member | enum | 2 | 0 | 1 if the Country belongs to the European Union | ||
v_countries | is_eu_member | enum | 2 | 0 | 1 if the Country belongs to the European Union | ||
v_countries | is_official | enum | 2 | 1 | 0 If the country is not officialy recognised | ||
countries | official | enum | 2 | 1 | 0 If the country is not officialy recognised | ||
countries | other_country | enum | 2 | √ | 0 | If set to true, it means that there is another country with a similar name. | |
regions | sub_region | enum | 2 | 0 | 1 If the region describes a subpart of a country; 0 if it is a group of countries | ||
v_countries | code_ec_trade | int | 10 | √ | null | E.C. Trade Coding | |
v_countries | code_isonum | int | 10 | √ | null | ISO 3166 / UN Statistical Division | |
continents | display_order | int | 10 | √ | 0 | ||
countries_equiv | ec_trade | int | 10 | √ | null | E.C. Trade Coding | |
countries_equiv | isonum | int | 10 | √ | null | ISO 3166 / UN Statistical Division | |
regions_regions | child_region_id | int unsigned | 10 | ||||
clusters | cluster_id | int unsigned | 10 | √ | |||
countries | cluster_id | int unsigned | 10 | √ | null | ||
v_countries | cluster_id | int unsigned | 10 | √ | null | ||
continents | continent_id | int unsigned | 10 | √ | |||
countries | continent_id | int unsigned | 10 | √ | null | Ref to the continent | |
official_regions | continent_id | int unsigned | 10 | ||||
regions_regions | parent_region_id | int unsigned | 10 | ||||
v_countries | parent_region_id | int unsigned | 10 | 0 | |||
v_main_regions | parent_region_id | int unsigned | 10 | 0 | |||
v_sub_regions | parent_region_id | int unsigned | 10 | 0 | |||
countries | region_id | int unsigned | 10 | √ | null | ||
official_regions | region_id | int unsigned | 10 | √ | |||
regions | region_id | int unsigned | 10 | √ | |||
regions_countries | region_id | int unsigned | 10 | ||||
v_countries | region_id | int unsigned | 10 | 0 | |||
v_sub_regions | region_id | int unsigned | 10 | 0 | |||
continents | comments | text | 65535 | √ | null | ||
official_regions | comments | text | 65535 | √ | null | ||
regions | comments | text | 65535 | √ | null | ||
regions_countries | comments | text | 65535 | √ | null | ||
clusters | description | text | 65535 | √ | null | ||
users | ldap_group | text | 65535 | Cached value of the LDAP list of user groups (comma separated) | |||
v_countries | parent_region_comments | text | 65535 | √ | null | ||
v_main_regions | parent_region_comments | text | 65535 | √ | null | ||
v_sub_regions | parent_region_comments | text | 65535 | √ | null | ||
v_countries | region_comments | text | 65535 | √ | null | ||
v_sub_regions | region_comments | text | 65535 | √ | null | ||
v_countries | code_iana | varchar | 2 | √ | null | Internet Assigned Numbers Authority | |
v_countries | code_iso2 | varchar | 2 | ||||
countries | country_id | varchar | 2 | ISO 3166-1 | |||
countries_equiv | country_id | varchar | 2 | ||||
regions_countries | country_id | varchar | 2 | ||||
v_countries | country_id | varchar | 2 | ISO 3166-1 | |||
countries_equiv | iana | varchar | 2 | √ | null | Internet Assigned Numbers Authority | |
languages_equiv | iso6391 | varchar | 2 | √ | null | ISO 639-1 | |
countries | parent_country_id | varchar | 2 | √ | null | "Parent" country or NULL | |
v_countries | parent_country_id | varchar | 2 | √ | null | "Parent" country or NULL | |
v_countries | code_ec_comref | varchar | 3 | √ | null | E.C. COMREF | |
v_countries | code_ec_comref_del | varchar | 3 | √ | null | E.C. COMREF - DELEGATIONS.PAY_CD | |
v_countries | code_ec_min | varchar | 3 | √ | null | E.C. MIN Coding | |
v_countries | code_ec_sysper | varchar | 3 | √ | null | E.C. Sysper Coding | |
v_countries | code_ioc | varchar | 3 | √ | null | International Olympic Committee | |
v_countries | code_iso3 | varchar | 3 | √ | null | ISO 3166 (3 alpha) | |
v_countries | code_un | varchar | 3 | √ | null | United Nations, International Traffic Distinguished Signs | |
countries_equiv | ec_comref | varchar | 3 | √ | null | E.C. COMREF | |
countries_equiv | ec_comref_del | varchar | 3 | √ | null | E.C. COMREF - DELEGATIONS.PAY_CD | |
countries_equiv | ec_min | varchar | 3 | √ | null | E.C. MIN Coding | |
countries_equiv | ec_sysper | varchar | 3 | √ | null | E.C. Sysper Coding | |
countries_equiv | ioc | varchar | 3 | √ | null | International Olympic Committee | |
countries_equiv | iso3 | varchar | 3 | √ | null | ISO 3166 (3 alpha) | |
languages_equiv | iso6392t | varchar | 3 | √ | null | ISO 639-2/T | |
languages | language_id | varchar | 3 | ISO 639-2/B | |||
languages_equiv | language_id | varchar | 3 | ||||
countries_equiv | un | varchar | 3 | √ | null | United Nations, International Traffic Distinguished Signs | |
languages_equiv | sysbien | varchar | 4 | √ | null | E.C. SYSBIEN | |
languages_equiv | sysper | varchar | 4 | √ | null | E.C. SYSPER | |
v_countries | code_itu | varchar | 5 | √ | null | International Telecommunication Union codes for international telephone calls | |
countries_equiv | itu | varchar | 5 | √ | null | International Telecommunication Union codes for international telephone calls | |
users | ldap_title | varchar | 5 | √ | null | Cached value of the LDAP title attribute | |
clusters | color | varchar | 6 | ffffff | |||
v_countries | code_janes_base | varchar | 10 | √ | null | Jane's Sentinel filenames base | |
v_countries | code_janes_folder | varchar | 10 | √ | null | Jane's Sentinel Folder name | |
countries_equiv | janes_base | varchar | 10 | √ | null | Jane's Sentinel filenames base | |
countries_equiv | janes_folder | varchar | 10 | √ | null | Jane's Sentinel Folder name | |
users | creation_user_id | varchar | 16 | LDAP user_id of the user who has inserted this record | |||
users | user_id | varchar | 16 | ID of the officer (As defined in the user_id field of the LDAP database) | |||
countries_equiv | global_atlas | varchar | 20 | √ | null | The FIPS global atlas code | |
countries | capital_adm | varchar | 255 | √ | null | ||
countries | capital_city | varchar | 255 | √ | null | ||
v_countries | code_oxan | varchar | 255 | √ | null | Oxford Analytica Country Name | |
v_countries | country_name_en | varchar | 255 | ISO 3166-2 | |||
v_countries | country_name_fr | varchar | 255 | ISO 3166-2 | |||
users | ldap_department | varchar | 255 | √ | null | Cached value of the LDAP department attribute | |
users | ldap_displayname | varchar | 255 | √ | null | Cached value of the LDAP displayname attribute | |
users | ldap_email | varchar | 255 | √ | null | Cached value of the LDAP email attribute | |
users | ldap_firstname | varchar | 255 | √ | null | Cached value of the LDAP firstname attribute | |
users | ldap_lastname | varchar | 255 | √ | null | Cached value of the LDAP lastname attribute | |
users | ldap_office | varchar | 255 | √ | null | Cached value of the LDAP office attribute | |
users | ldap_phone | varchar | 255 | √ | null | Cached value of the LDAP phone attribute | |
clusters | name | varchar | 255 | ||||
continents | name_en | varchar | 255 | ||||
countries | name_en | varchar | 255 | ISO 3166-2 | |||
languages | name_en | varchar | 255 | ISO 639-2/B | |||
official_regions | name_en | varchar | 255 | ||||
regions | name_en | varchar | 255 | ||||
continents | name_fr | varchar | 255 | ||||
countries | name_fr | varchar | 255 | ISO 3166-2 | |||
languages | name_fr | varchar | 255 | ISO 639-2/B | |||
official_regions | name_fr | varchar | 255 | ||||
regions | name_fr | varchar | 255 | ||||
countries_equiv | oxan | varchar | 255 | √ | null | Oxford Analytica Country Name | |
v_countries | parent_region_name_en | varchar | 255 | ||||
v_main_regions | parent_region_name_en | varchar | 255 | ||||
v_sub_regions | parent_region_name_en | varchar | 255 | ||||
v_countries | parent_region_name_fr | varchar | 255 | ||||
v_main_regions | parent_region_name_fr | varchar | 255 | ||||
v_sub_regions | parent_region_name_fr | varchar | 255 | ||||
v_countries | region_name_en | varchar | 255 | ||||
v_sub_regions | region_name_en | varchar | 255 | ||||
v_countries | region_name_fr | varchar | 255 | ||||
v_sub_regions | region_name_fr | varchar | 255 | ||||
countries_equiv | wikipedia_name | varchar | 255 | √ | null | The Wikipedia country name |