SchemaSpy Analysis of meta_common - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Apr 25 13:19 CEST 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

meta_common contains 117 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
users creation_user_id varchar 16 LDAP user_id of the user who has inserted this record
clusters name varchar 255
users user_id varchar 16 ID of the officer (As defined in the user_id field of the LDAP database)
continents display_order int 10  √  0
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
countries other_country enum 2  √  0 If set to true, it means that there is another country with a similar name.
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
v_countries region_id int unsigned 10 0
v_sub_regions region_id int unsigned 10 0
regions sub_region enum 2 0 1 If the region describes a subpart of a country; 0 if it is a group of countries
users creation_time datetime 19 0000-00-00 00:00:00 Date & Time at which this record has been inserted
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
clusters color varchar 6 ffffff
users deleted_from_ldap enum 2  √  n If set to 'y' the user has been deleted from LDAP
countries capital_adm varchar 255  √  null
countries capital_city varchar 255  √  null
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
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_ec_trade int 10  √  null E.C. Trade Coding
v_countries code_iana varchar 2  √  null Internet Assigned Numbers Authority
v_countries code_ioc varchar 3  √  null International Olympic Committee
v_countries code_iso2 varchar 2
v_countries code_iso3 varchar 3  √  null ISO 3166 (3 alpha)
v_countries code_isonum int 10  √  null ISO 3166 / UN Statistical Division
v_countries code_itu varchar 5  √  null International Telecommunication Union codes for international telephone calls
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
v_countries code_oxan varchar 255  √  null Oxford Analytica Country Name
v_countries code_un varchar 3  √  null United Nations, International Traffic Distinguished Signs
continents comments text 65535  √  null
official_regions comments text 65535  √  null
regions comments text 65535  √  null
regions_countries comments text 65535  √  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
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
v_countries country_name_en varchar 255 ISO 3166-2
v_countries country_name_fr varchar 255 ISO 3166-2
clusters description text 65535  √  null
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 ec_trade int 10  √  null E.C. Trade Coding
countries_equiv global_atlas varchar 20  √  null The FIPS global atlas code
countries_equiv iana varchar 2  √  null Internet Assigned Numbers Authority
countries_equiv ioc varchar 3  √  null International Olympic Committee
countries_equiv iso3 varchar 3  √  null ISO 3166 (3 alpha)
languages_equiv iso6391 varchar 2  √  null ISO 639-1
languages_equiv iso6392t varchar 3  √  null ISO 639-2/T
countries_equiv isonum int 10  √  null ISO 3166 / UN Statistical Division
countries_equiv itu varchar 5  √  null International Telecommunication Union codes for international telephone calls
countries_equiv janes_base varchar 10  √  null Jane's Sentinel filenames base
countries_equiv janes_folder varchar 10  √  null Jane's Sentinel Folder name
languages language_id varchar 3 ISO 639-2/B
languages_equiv language_id varchar 3
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_group text 65535 Cached value of the LDAP list of user groups (comma separated)
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
users ldap_title varchar 5  √  null Cached value of the LDAP title attribute
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
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 parent_region_comments text 65535  √  null
v_main_regions parent_region_comments text 65535  √  null
v_sub_regions parent_region_comments text 65535  √  null
regions_regions parent_region_id int unsigned 10
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_comments text 65535  √  null
v_sub_regions region_comments text 65535  √  null
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_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
languages_equiv sysbien varchar 4  √  null E.C. SYSBIEN
languages_equiv sysper varchar 4  √  null E.C. SYSPER
countries_equiv un varchar 3  √  null United Nations, International Traffic Distinguished Signs
countries_equiv wikipedia_name varchar 255  √  null The Wikipedia country name