SchemaSpy Analysis of tariqapro - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Apr 25 13:31 CEST 2012 |
| ||||||
|
tariqapro contains 318 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
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 | ||
mailing_newsletter | buzz | enum | 2 | n | if Yes, embed buzztracker's daily map in the newsletter | ||
v_countries | code_iana | varchar | 2 | √ | null | Internet Assigned Numbers Authority | |
v_countries | code_iso2 | varchar | 2 | ||||
__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 | |||
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 | ||
rss_feeds | has_pictures | enum | 2 | n | |||
countries_equiv | iana | varchar | 2 | √ | null | Internet Assigned Numbers Authority | |
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_equiv | iso6391 | varchar | 2 | √ | null | ISO 639-1 | |
countries | official | enum | 2 | 1 | 0 If the country is not officialy recognised | ||
countries | parent_country_id | varchar | 2 | √ | null | "Parent" country or NULL | |
v_countries | parent_country_id | varchar | 2 | √ | null | "Parent" country or NULL | |
mailing_newsletter | scrshot | enum | 2 | n | Embed a screenshot of Tarîqa | ||
mailing_newsletter | sent | enum | 2 | n | if Yes, the newsletter was already sent | ||
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_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 | |
mailing_newsletter_articles | n | smallint | 5 | 0 | |||
clusters | color | varchar | 6 | ffffff | |||
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 | √ | |||
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 | |||
countries | cluster_id | int unsigned | 10 | √ | null | ||
v_countries | cluster_id | int unsigned | 10 | √ | null | ||
v_countries | code_ec_trade | int | 10 | √ | null | E.C. Trade Coding | |
v_countries | code_isonum | int | 10 | √ | null | ISO 3166 / UN Statistical Division | |
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 | |
continents | continent_id | int unsigned | 10 | 0 | |||
countries | continent_id | int unsigned | 10 | √ | null | Ref to the continent | |
channeltv | display_order | int | 10 | √ | 0 | ||
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 | ||
flavours | dorder | int | 10 | √ | 0 | ||
countries_equiv | ec_trade | int | 10 | √ | null | E.C. Trade Coding | |
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 | |||
__q_country_queries | flavour_id | int unsigned | 10 | The query flavour identifier | |||
backup_queries | flavour_id | int unsigned | 10 | √ | null | The theme identifier | |
flavours | flavour_id | int unsigned | 10 | √ | Theme identifier | ||
homepage_flavours | flavour_id | int unsigned | 10 | √ | Theme identifier | ||
queries | flavour_id | int unsigned | 10 | √ | null | The theme identifier | |
queries_countries | flavour_id | int unsigned | 10 | The query flavour identifier | |||
queries_countries_tmp | flavour_id | int unsigned | 10 | √ | null | The query flavour identifier | |
queries_homepage | flavour_id | int unsigned | 10 | ||||
queries_regions | flavour_id | int unsigned | 10 | √ | null | The query flavour identifier | |
queries_tmp | flavour_id | int unsigned | 10 | √ | null | The theme identifier | |
newstickers_groups | group_id | int unsigned | 10 | √ | The group identifier | ||
newstickers_queries | group_id | int unsigned | 10 | The group identifier | |||
countries_equiv | isonum | int | 10 | √ | null | ISO 3166 / UN Statistical Division | |
countries_equiv | janes_base | varchar | 10 | √ | null | Jane's Sentinel filenames base | |
countries_equiv | janes_folder | varchar | 10 | √ | null | Jane's Sentinel Folder name | |
latestnews_articles | latestnews_id | int unsigned | 10 | √ | null | Internal ID of the article in the LatestNews database | |
countries_reliefweb_maps | map_id | int unsigned | 10 | √ | The map identifier | ||
mailing_newsletter | newsletter_id | int unsigned | 10 | √ | |||
mailing_newsletter_articles | newsletter_id | int unsigned | 10 | 0 | |||
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 | ||
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 | |||
__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 | √ | |||
themes | query_id | int unsigned | 10 | √ | null | ||
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 | ||
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 | |||
mailing_newsletter_articles | section_id | int unsigned | 10 | 0 | |||
mailing_newsletter_sections | section_id | int unsigned | 10 | √ | |||
__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 | √ | |||
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 | |||
latestnews_feeds | time_range | int | 10 | 1 | Number of hours to go backwards in the archive | ||
queries_tmp | time_range | int unsigned | 10 | 15 | Time range (in days) for the queries | ||
themes_topics | topic_id | int unsigned | 10 | √ | The topic identifier | ||
topics_queries | topic_id | int unsigned | 10 | The theme identifier | |||
latestnews_articles | language | varchar | 12 | √ | null | Language of the article | |
theme_users | user_id | varchar | 12 | ||||
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) | |||
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 | ||
latestnews_articles | date | datetime | 19 | √ | null | Date of publication of the article | |
rss_articles | date | datetime | 19 | √ | null | Date of publication of the article | |
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 | 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 | ||
latestnews_feeds | language | varchar | 20 | √ | null | Language of the feed (if avialable) | |
rss_feeds | language | varchar | 20 | √ | null | Language of the feed (if avialable) | |
weblogs | name | varchar | 30 | ||||
__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 | |||
engines | data | varchar | 45 | √ | null | For Google engines (the type of engine) | |
flavours | name | varchar | 45 | Theme name | |||
homepage_flavours | name | varchar | 45 | Theme name | |||
__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 | ||
queries | time_range | varchar | 50 | 15 | Time range (in days) for the queries | ||
channeltv_categories | name | varchar | 100 | The category name | |||
newstickers_groups | name | varchar | 100 | The group name | |||
radio_categories | name | varchar | 100 | The category name | |||
themes_topics | title | varchar | 100 | The topic title | |||
topics_queries | title | varchar | 100 | The title from query | |||
mailing_newsletter | banner | varchar | 255 | name of the banner to use | |||
channeltv | channel_name | varchar | 255 | √ | |||
v_countries | code_oxan | varchar | 255 | √ | null | Oxford Analytica Country Name | |
engines | copyright | varchar | 255 | √ | null | ||
sources | copyright | varchar | 255 | √ | null | ||
v_countries | country_name_en | varchar | 255 | ISO 3166-2 | |||
v_countries | country_name_fr | varchar | 255 | ISO 3166-2 | |||
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 | |
countries_reliefweb_maps | file | varchar | 255 | The file of the map | |||
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 | |
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 | |
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 | |
latestnews_feeds | link | varchar | 255 | √ | null | URL of the site corresponding to the current feed | |
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 | |
clusters | name | varchar | 255 | ||||
engines | name | varchar | 255 | Name of the data provider | |||
__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 | ||||
countries_equiv | oxan | varchar | 255 | √ | null | Oxford Analytica Country Name | |
countries_reliefweb_maps | page | varchar | 255 | The page of the map | |||
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 | ||||
latestnews_feeds | picture | varchar | 255 | √ | null | URL to the embeded Logo | |
rss_feeds | picture | varchar | 255 | √ | null | URL to the embeded Logo | |
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 | ||||
__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 | |
channeltv | streaming_url | varchar | 255 | The streaming URL | |||
radios | streaming_url | varchar | 255 | The streaming URL | |||
mailing_newsletter | theme | varchar | 255 | name of the visual theme to use | |||
countries_reliefweb_maps | thumbnail | varchar | 255 | The thumbnail of the map | |||
__q_country_queries | title | varchar | 255 | Title of the data block | |||
adv_search | title | varchar | 255 | √ | null | The title | |
backup_queries | title | varchar | 255 | Title of the data block | |||
latestnews_articles | title | varchar | 255 | Title of the article (truncated to 255 chars) | |||
latestnews_feeds | title | varchar | 255 | √ | null | Title of the feed | |
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 | |||
rss_feeds | title | varchar | 255 | √ | null | Title of the feed | |
sources | title | varchar | 255 | ||||
themes | title | varchar | 255 | ||||
rss_feeds | url | varchar | 512 | Full URL of the feed. UNIQUE CONSTRAINT. | |||
latestnews_articles | agency | text | 65535 | √ | null | Name of the Press Agency | |
rss_articles | author | text | 65535 | √ | null | Author of the article (if available) | |
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 | ||
latestnews_feeds | copyright | text | 65535 | √ | null | Copyright information | |
rss_feeds | copyright | text | 65535 | √ | null | Copyright information | |
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 | |
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_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 | ||
quicksearch_sources | display_title | text | 65535 | The title to be displayed in the search form | |||
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) | |
users | ldap_group | text | 65535 | Cached value of the LDAP list of user groups (comma separated) | |||
mailing_newsletter_articles | link | text | 65535 | √ | null | ||
rss_articles | link | text | 65535 | √ | null | Link to the article | |
themes | long_text | text | 65535 | √ | 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 | ||
__q_country_queries | query | text | 65535 | Query to run amongst the search engine | |||
__q_lexis_default_countryquery | query | text | 65535 | √ | null | ||
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 | |||
mailing_newsletter | recipients | text | 65535 | ||||
v_countries | region_comments | text | 65535 | √ | null | ||
v_sub_regions | region_comments | text | 65535 | √ | null | ||
themes | short_text | text | 65535 | √ | null | ||
mailing_newsletter | subject | text | 65535 | ||||
latestnews_articles | summary | text | 65535 | √ | null | Summary of the article | |
mailing_newsletter_articles | title | text | 65535 | √ | null | ||
rss_articles | title | text | 65535 | √ | null | Title of the article | |
__q_lexis_default_countryquery_upd | UpdateQuery | mediumtext | 16777215 | √ | null | ||
rss_articles | description | longtext | 2147483647 | √ | null | Summary of the article if available |