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

tariqapro contains 318 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
latestnews_articles agency text 65535  √  null Name of the Press Agency
rss_articles author text 65535  √  null Author of the article (if available)
channeltv channel_name varchar 255  √ 
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_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
regions comments text 65535  √  null
regions_countries comments text 65535  √  null
rss_articles comments text 65535  √  null Comment about the article (if available)
latestnews_articles content text 65535  √  null Body of the article
mailing_newsletter_articles content text 65535  √  null
countries continent_id int unsigned 10  √  null Ref to the continent
engines copyright varchar 255  √  null
latestnews_feeds copyright text 65535  √  null Copyright information
rss_feeds copyright text 65535  √  null Copyright information
sources copyright varchar 255  √  null
engines data varchar 45  √  null For Google engines (the type of engine)
mailing_newsletter_articles data text 65535  √  null if not null: it is the content of the article, otherwise it is stored in the title/link/content fields
latestnews_articles date datetime 19  √  null Date of publication of the article
rss_articles date datetime 19  √  null Date of publication of the article
users deleted_from_ldap enum 2  √  n If set to 'y' the user has been deleted from LDAP
adv_search description text 65535  √  null The description
backup_queries description text 65535  √  null Optional description of the block
clusters description text 65535  √  null
engines description text 65535  √  null Description of the datasource
flavours description text 65535  √  null Theme description
homepage_flavours description text 65535  √  null Theme description
latestnews_feeds description text 65535  √  null Description of the feed
mailing_newsletter_sections description text 65535  √  null
queries description text 65535  √  null Optional description of the block
queries_countries description text 65535  √  null Optional description of the data block
queries_countries_tmp description text 65535  √  null Optional description of the data block
queries_homepage description text 65535  √  null Optional description of the data block
queries_regions description text 65535  √  null Optional description of the data block
queries_themes description text 65535  √  null Optional description of the data block
queries_tmp description text 65535  √  null Optional description of the block
radios description text 65535  √  null The description
rss_articles description longtext 2147483647  √  null Summary of the article if available
rss_feeds description text 65535  √  null Description of the feed
sources description text 65535  √  null
themes description text 65535  √  null
themes_topics description text 65535  √  null The topic description
engines disclaimer text 65535  √  null
sources disclaimer text 65535  √  null
channeltv display_order int 10  √  0
engines doc_url varchar 255  √  null URL where to find information about the source
sources doc_url varchar 255  √  null URL where to find information about the source
flavours dorder int 10  √  0
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
backup_queries flavour_id int unsigned 10  √  null The theme identifier
queries flavour_id int unsigned 10  √  null The theme identifier
queries_countries_tmp flavour_id int unsigned 10  √  null The query flavour identifier
queries_regions flavour_id int unsigned 10  √  null The query flavour identifier
queries_tmp flavour_id int unsigned 10  √  null The theme identifier
mailing_newsletter footer text 65535  √  null The foot message to print on the newsletter
latestnews_articles headline text 65535  √  null Title of the article (full length)
rss_articles headline text 65535  √  null Title of the article (full length)
countries_equiv iana varchar 2  √  null Internet Assigned Numbers Authority
backup_queries icon varchar 255  √  null
queries icon varchar 255  √  null
engines icon_url varchar 255  √  null URL of the icon (small logo) of the data provider
sources icon_url varchar 255  √  null URL of the icon (small logo) of the data provider
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
queries_countries label varchar 255  √  null Optional label for the data block
queries_countries_tmp label varchar 255  √  null Optional label for the data block
queries_regions label varchar 255  √  null Optional label for the data block
queries_themes label varchar 255  √  null Optional label for the data block
latestnews_articles language varchar 12  √  null Language of the article
latestnews_feeds language varchar 20  √  null Language of the feed (if avialable)
rss_feeds language varchar 20  √  null Language of the feed (if avialable)
latestnews_feeds last_refresh datetime 19  √  null Date/time at which the feed was last refreshed
rss_feeds last_refresh datetime 19  √  null Date/time at which the feed was last refreshed
latestnews_articles latestnews_id int unsigned 10  √  null Internal ID of the article in the LatestNews database
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
users ldap_title varchar 5  √  null Cached value of the LDAP title attribute
latestnews_feeds link varchar 255  √  null URL of the site corresponding to the current feed
mailing_newsletter_articles link text 65535  √  null
rss_articles link text 65535  √  null Link to the article
rss_feeds link varchar 255  √  null URL of the site corresponding to the current feed
channeltv logo_url varchar 255  √  null The logo URL
engines logo_url varchar 255  √  null URL of the logo of the data provider
radios logo_url varchar 255  √  null The logo URL
sources logo_url varchar 255  √  null URL of the logo of the data provider
themes long_text text 65535  √  null
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
latestnews_feeds picture varchar 255  √  null URL to the embeded Logo
rss_feeds picture varchar 255  √  null URL to the embeded Logo
__q_lexis_default_countryquery query text 65535  √  null
themes query_id int unsigned 10  √  null
v_countries region_comments text 65535  √  null
v_sub_regions region_comments text 65535  √  null
themes short_text text 65535  √  null
__q_country_queries source_data varchar 255  √  null Data used to identify the source inside the search engine
sources source_data varchar 255  √  null Data used to identify the source inside the search engine
latestnews_articles summary text 65535  √  null Summary of the article
languages_equiv sysbien varchar 4  √  null E.C. SYSBIEN
languages_equiv sysper varchar 4  √  null E.C. SYSPER
adv_search title varchar 255  √  null The title
latestnews_feeds title varchar 255  √  null Title of the feed
mailing_newsletter_articles title text 65535  √  null
rss_articles title text 65535  √  null Title of the article
rss_feeds title varchar 255  √  null Title of the feed
countries_equiv un varchar 3  √  null United Nations, International Traffic Distinguished Signs
__q_lexis_default_countryquery_upd UpdateQuery mediumtext 16777215  √  null
engines access_level int 10 10
latestnews_articles article_id int unsigned 10 0 Unique identifier of the article (url is wrong as it can appear in several feeds)
mailing_newsletter_articles article_id int unsigned 10  √ 
rss_articles article_id int unsigned 10 0 Unique identifier of the article (url is wrong as it can appear in several feeds)
backup_queries backup_id int unsigned 10  √ 
mailing_newsletter banner varchar 255 name of the banner to use
mailing_newsletter buzz enum 2 n if Yes, embed buzztracker's daily map in the newsletter
channeltv category_id int unsigned 10
channeltv_categories category_id int unsigned 10  √  The category identifier
radio_categories category_id int unsigned 10  √  The category identifier
radios category_id int unsigned 10 The category identifier
channeltv channel_id int unsigned 10  √  The channel identifier
regions_regions child_region_id int unsigned 10
clusters cluster_id int unsigned 10 0
v_countries code_iso2 varchar 2
clusters color varchar 6 ffffff
continents continent_id int unsigned 10 0
__q_country_queries country_id varchar 2
__q_lexis_default_countryquery country_id varchar 2 ISO 3166-1
countries country_id varchar 2 ISO 3166-1
countries_equiv country_id varchar 2
countries_reliefweb_maps country_id varchar 2 The country identifier
latestnews_feeds_countries country_id varchar 2
queries_countries country_id varchar 2
queries_countries_tmp country_id varchar 2
regions_countries country_id varchar 2
rss_feeds_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
mailing_newsletter crea_date datetime 19 0000-00-00 00:00:00
users creation_time datetime 19 0000-00-00 00:00:00 Date & Time at which this record has been inserted
users creation_user_id varchar 16 LDAP user_id of the user who has inserted this record
queries_countries display_order int unsigned 10 0 The higher, the closer to the top of the page will the block be displayed
queries_countries_tmp display_order int unsigned 10 0 The higher, the closer to the top of the page will the block be displayed
queries_homepage display_order int unsigned 10 0 The higher, the closer to the top of the page will the block be displayed
queries_regions display_order int unsigned 10 0 The higher, the closer to the top of the page will the block be displayed
queries_themes display_order int unsigned 10 0 The higher, the closer to the top of the page will the block be displayed
quicksearch_sources display_title text 65535 The title to be displayed in the search form
__q_country_queries engine_id varchar 32 Search engine to which the current source is relying on
adv_search engine_id varchar 32 The engine identifier
engines engine_id varchar 32
sources engine_id varchar 32 Search engine to which the current source is relying on
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
latestnews_articles feed_id int unsigned 10 ID of the feed this article belongs to
latestnews_feeds feed_id int unsigned 10 0 Unique identifier for the feed
latestnews_feeds_countries feed_id int unsigned 10 0
latestnews_feeds_themes feed_id int unsigned 10 0
rss_articles feed_id int unsigned 10 ID of the feed this article belongs to
rss_feeds feed_id int unsigned 10 0 Unique identifier for the feed
rss_feeds_countries feed_id int unsigned 10 0
rss_feeds_themes feed_id int unsigned 10 0
countries_reliefweb_maps file varchar 255 The file of the map
__q_country_queries flavour_id int unsigned 10 The query flavour identifier
flavours flavour_id int unsigned 10  √  Theme identifier
homepage_flavours flavour_id int unsigned 10  √  Theme identifier
queries_countries flavour_id int unsigned 10 The query flavour identifier
queries_homepage flavour_id int unsigned 10
newstickers_groups group_id int unsigned 10  √  The group identifier
newstickers_queries group_id int unsigned 10 The group identifier
rss_feeds has_pictures enum 2 n
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
languages language_id varchar 3 ISO 639-2/B
languages_equiv language_id varchar 3
users ldap_group text 65535 Cached value of the LDAP list of user groups (comma separated)
countries_reliefweb_maps map_id int unsigned 10  √  The map identifier
mailing_newsletter_articles n smallint 5 0
channeltv_categories name varchar 100 The category name
clusters name varchar 255
engines name varchar 255 Name of the data provider
flavours name varchar 45 Theme name
homepage_flavours name varchar 45 Theme name
newstickers_groups name varchar 100 The group name
radio_categories name varchar 100 The category name
weblogs name varchar 30
__q_lexis_default_countryquery name_en varchar 255
continents name_en varchar 255
countries name_en varchar 255 ISO 3166-2
languages name_en varchar 255 ISO 639-2/B
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
regions name_fr varchar 255
mailing_newsletter newsletter_id int unsigned 10  √ 
mailing_newsletter_articles newsletter_id int unsigned 10 0
countries official enum 2 1 0 If the country is not officialy recognised
adv_search order int unsigned 10 0 The order
quicksearch_sources order int unsigned 10 0 The order in which to be displayed in the search form
countries_reliefweb_maps page varchar 255 The page of the map
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
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
__q_country_queries query text 65535 Query to run amongst the search engine
backup_queries query text 65535 Query to run amongst the search engine
latestnews_feeds query text 65535 SQL WHERE statement
queries query text 65535 Query to run amongst the search engine
queries_tmp query text 65535 Query to run amongst the search engine
__q_country_queries query_id int unsigned 10 0
backup_queries query_id int unsigned 10
newstickers_queries query_id int unsigned 10 The query identifier
queries query_id int unsigned 10  √ 
queries_countries query_id int unsigned 10
queries_countries_tmp query_id int unsigned 10
queries_homepage query_id int unsigned 10
queries_regions query_id int unsigned 10
queries_themes query_id int unsigned 10
queries_tmp query_id int unsigned 10  √ 
topics_queries query_id int unsigned 10 The query identifier
weblogs query_id int unsigned 10
radios radio_id int unsigned 10  √  The radio identifier
mailing_newsletter recipients text 65535
latestnews_feeds refresh_rate int unsigned 10 15 Refresh rate of the feed (in seconds). 0 means unrestricted
rss_feeds refresh_rate int unsigned 10 15 Refresh rate of the feed (in seconds). 0 means unrestricted
queries_regions region_id int unsigned 10 0
regions region_id int unsigned 10 0
regions_countries region_id int unsigned 10
v_countries region_id int unsigned 10 0
v_sub_regions region_id int unsigned 10 0
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
mailing_newsletter scrshot enum 2 n Embed a screenshot of Tarîqa
mailing_newsletter_articles section_id int unsigned 10 0
mailing_newsletter_sections section_id int unsigned 10  √ 
mailing_newsletter sent enum 2 n if Yes, the newsletter was already sent
__q_country_queries source_id int unsigned 10 0
adv_search source_id int unsigned 10 0 The source_identifier
backup_queries source_id int unsigned 10 Data source
queries source_id int unsigned 10 Data source
queries_tmp source_id int unsigned 10 Data source
quicksearch_sources source_id int unsigned 10
sources source_id int unsigned 10  √ 
channeltv streaming_url varchar 255 The streaming URL
radios streaming_url varchar 255 The streaming URL
regions sub_region enum 2 0 1 If the region describes a subpart of a country; 0 if it is a group of countries
mailing_newsletter subject text 65535
mailing_newsletter theme varchar 255 name of the visual theme to use
latestnews_feeds_themes theme_id int unsigned 10
queries_themes theme_id int unsigned 10
rss_feeds_themes theme_id int unsigned 10
theme_users theme_id int unsigned 10
themes theme_id int unsigned 10  √ 
themes_topics theme_id int unsigned 10 The theme identifier
countries_reliefweb_maps thumbnail varchar 255 The thumbnail of the map
__q_country_queries time_range varchar 50 15 Time range (in days) for the queries
backup_queries time_range varchar 50 15 Time range (in days) for the queries
latestnews_feeds time_range int 10 1 Number of hours to go backwards in the archive
queries time_range varchar 50 15 Time range (in days) for the queries
queries_tmp time_range int unsigned 10 15 Time range (in days) for the queries
__q_country_queries title varchar 255 Title of the data block
backup_queries title varchar 255 Title of the data block
latestnews_articles title varchar 255 Title of the article (truncated to 255 chars)
mailing_newsletter_sections title varchar 255
queries title varchar 255 Title of the data block
queries_tmp title varchar 255 Title of the data block
sources title varchar 255
themes title varchar 255
themes_topics title varchar 100 The topic title
topics_queries title varchar 100 The title from query
themes_topics topic_id int unsigned 10  √  The topic identifier
topics_queries topic_id int unsigned 10 The theme identifier
latestnews_articles ts_article timestamp 19 0000-00-00 00:00:00 Load date of the article
rss_articles ts_article timestamp 19 0000-00-00 00:00:00 Load date of the article
rss_feeds url varchar 512 Full URL of the feed. UNIQUE CONSTRAINT.
rss_feeds use_proxy bit 0 1 If set to 1, the feed will be downloaded through the proxy, otherwise direct connection will be used
theme_users user_id varchar 12
users user_id varchar 16 ID of the officer (As defined in the user_id field of the LDAP database)