- Tables
- Relationships
- Utility Tables
- Constraints
- Anomalies
- Columns
- Donate

SchemaSpy Analysis of sahebkhabar - Columns | Generated by SchemaSpy

Generated by SchemaSpy on Wed Jan 20 16:28 IRST 2016 |

Legend: |

Primary key columns
Columns with indexes

Comments Legend

sahebkhabar contains 803 columns - click on heading to sort:

Table | Column | Type | Size | Nulls | Auto | Default | Comments
--- | --- | --- | --- | --- | --- | --- | ---
site | about_us_news_id | int | 10 | √ |  | null |
user_profile | access_level | int unsigned | 10 | √ |  | null | 0:sysadmin,1:newsadmin
api_audit_log | action_code | int unsigned | 10 |  |  |  |
entity_audit_log | action_code | tinyint unsigned | 3 |  |  |  |
ads | active | bit | 0 |  |  | 1 |
entity_tag | active | bit | 0 | √ |  | 1 |
keyword | active | bit | 0 |  |  | 1 |
link | active | bit | 0 |  |  | 1 |
link_group | active | bit | 0 |  |  | 1 |
media | active | bit | 0 | √ |  | 1 |
menu | active | tinyint | 3 |  |  |  |
news | active | bit | 0 | √ |  | null |
news_comment | active | bit | 0 | √ |  | null |
news_history | active | bit | 0 | √ |  | null |
news_media | active | bit | 0 | √ |  | 1 |
news_news | active | bit | 0 | √ |  | 1 |
news_place | active | bit | 0 | √ |  | 1 |
news_place_archive | active | bit | 0 | √ |  | 1 |
news_type | active | bit | 0 |  |  |  |
newsletter | active | bit | 0 |  |  | 1 |
person | active | bit | 0 | √ |  | 1 |
place | active | bit | 0 |  |  | 1 |
poll | active | tinyint unsigned | 3 |  |  |  |
product | active | bit | 1 |  |  |  |
product_category | active | bit | 1 |  |  |  |
region | active | bit | 0 |  |  | 1 |
role | active | bit | 0 | √ |  | null |
site | active | bit | 0 |  |  | 1 |
source | active | bit | 0 | √ |  | null |
subscription | active | tinyint unsigned | 3 | √ |  | null | reserved. use status to disable a subscription
tag_item | active | bit | 0 |  |  |  |
tag_option | active | bit | 0 |  |  |  |
topic | active | bit | 0 |  |  | 1 |
user_profile | active | bit | 0 |  |  | 1 |
user_role | active | bit | 0 | √ |  | 1 |
user_profile | active_from | datetime | 19 | √ |  | null | account is non-expired from this datetime
user_profile | active_to | datetime | 19 | √ |  | null | account is non-expired to this datetime
user_profile | address | varchar | 150 | √ |  | null |
site | ads_news_id | int | 10 | √ |  | null |
site | alexa_meta_verification | varchar | 200 | √ |  | null |
place | allow_ips | varchar | 500 | √ |  | null |
place | any_keyword | tinyint unsigned | 3 | √ |  | null | true: or between keyword ids, false: and between keyword ids
api_audit_log | api | varchar | 50 |  |  |  |
newsletter | api_key | varchar | 500 | √ |  | null |
place | archive_place_id | int unsigned | 10 | √ |  | null |
ads | aspect_ratio | float | 12 | √ |  | null |
ip_country | assigned | bigint | 19 |  |  |  |
source | authority | varchar | 100 | √ |  | null |
place | auto_fill | bit | 0 |  |  | 0 |
user_profile | avatar | int | 10 | √ |  | null |
person | b_date | varchar | 10 | √ |  | null | Maybe contains just year number so its ENGINE is not datetime .
site | backlink_phrase_list | varchar | 1000 | √ |  | null |
site | backlink_phrase_url | varchar | 100 | √ |  | null |
person | biography | varchar | 4000 | √ |  | null |
news_comment | body | text | 65535 | √ |  | null |
user_message | body | text | 65535 | √ |  | null |
news_history | body_html | mediumtext | 16777215 | √ |  | null |
news | body_html_id | int unsigned | 10 | √ |  | null |
news_history | body_html_id | int unsigned | 10 | √ |  | null |
news_history | body_plain | mediumtext | 16777215 | √ |  | null |
news | body_plain_id | int unsigned | 10 | √ |  | null |
news_history | body_plain_id | int unsigned | 10 | √ |  | null |
news | body_wcount | int unsigned | 10 | √ |  | null |
news_history | body_wcount | int unsigned | 10 | √ |  | null |
place | box_bg_color | char | 7 | √ |  | null |
place | box_shadow | varchar | 50 | √ |  | null |
place | box_title | varchar | 150 | √ |  | null |
place | carousel_autostart | bit | 0 | √ |  | null |
place | carousel_control | bit | 0 | √ |  | null |
place | carousel_delay | int unsigned | 10 | √ |  | null |
place | carousel_item | int unsigned | 10 | √ |  | null |
place | carousel_items | int unsigned | 10 | √ |  | null |
place | carousel_paging | bit | 0 | √ |  | null |
product | category_id | int unsigned | 10 |  |  |  |
subscription | cell | varchar | 40 | √ |  | null |
user_profile | cell_number | varchar | 15 | √ |  | null |
person | cell_phone | varchar | 100 | √ |  | null |
vote | choice_id | int unsigned | 10 |  |  |  |
user_profile | city | varchar | 25 | √ |  | null |
ads | click_count | int unsigned | 10 | √ |  | null |
ip_country | cntry | char | 3 |  |  |  |
menu | code | varchar | 30 |  |  |  |
news | code | varchar | 100 |  |  |  |
news_history | code | varchar | 50 |  |  |  |
news_type | code | varchar | 20 | √ |  | null |
person | code | varchar | 50 | √ |  | null |
place | code | varchar | 50 | √ |  | null |
product_category | code | varchar | 30 | √ |  | null |
region | code | varchar | 10 | √ |  | null |
source | code | varchar | 30 |  |  |  |
news | comment_approval | bit | 0 | √ |  | null |
news_history | comment_approval | bit | 0 | √ |  | null |
news_history | comment_count | int unsigned | 10 | √ |  | null |
news_log | comment_count | int unsigned | 10 |  |  | 0 |
place | comment_count | int unsigned | 10 | √ |  | null |
news | comment_headline | varchar | 250 | √ |  | null |
news_history | comment_headline | varchar | 250 | √ |  | null |
user_profile | config | varchar | 1000 | √ |  | null |
site | contact_us_news_id | int | 10 | √ |  | null |
site | copyright_clause | varchar | 1000 | √ |  | null |
ip_country | country | varchar | 37 |  |  |  |
user_profile | country | varchar | 25 | √ |  | null |
news_comment | country_code | char | 2 | √ |  | null |
subscription | country_code | varchar | 2 | √ |  | null |
ads | created | timestamp | 19 | √ |  | null |
entity_tag | created | timestamp | 19 | √ |  | null |
keyword | created | timestamp | 19 | √ |  | null |
large_entity | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
link | created | timestamp | 19 | √ |  | null |
link_group | created | timestamp | 19 | √ |  | null |
media | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
messaging_log | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_comment | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_history | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_keyword | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_log | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_media | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_news | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_place | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_place_archive | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_type | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
newsletter | created | datetime | 19 |  |  |  |
person | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
place | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
poll | created | datetime | 19 |  |  |  |
poll_option | created | datetime | 19 |  |  |  |
product | created | datetime | 19 |  |  |  |
product_category | created | datetime | 19 |  |  |  |
product_price_log | created | datetime | 19 |  |  |  |
region | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
role | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
site | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
source | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
subscription | created | datetime | 19 | √ |  | null |
subscription_log | created | datetime | 19 |  |  |  |
tag_item | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
tag_option | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
topic | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
user_profile | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
user_role | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
vote | created | datetime | 19 |  |  |  |
ads | creator | int unsigned | 10 | √ |  | null |
entity_tag | creator | int unsigned | 10 | √ |  | null |
keyword | creator | int unsigned | 10 | √ |  | null |
link | creator | int unsigned | 10 | √ |  | null |
link_group | creator | int unsigned | 10 | √ |  | null |
media | creator | int unsigned | 10 | √ |  | null |
news | creator | int unsigned | 10 | √ |  | null |
news_comment | creator | int unsigned | 10 | √ |  | null | publisher
news_history | creator | int | 10 |  |  |  |
news_keyword | creator | int unsigned | 10 | √ |  | null |
news_media | creator | int unsigned | 10 | √ |  | null |
news_news | creator | int unsigned | 10 | √ |  | null |
news_place | creator | int unsigned | 10 | √ |  | null |
news_place_archive | creator | int unsigned | 10 | √ |  | null |
news_type | creator | int unsigned | 10 | √ |  | null |
newsletter | creator | int | 10 |  |  |  |
person | creator | int unsigned | 10 | √ |  | null |
place | creator | int unsigned | 10 |  |  |  |
poll | creator | int unsigned | 10 |  |  |  |
product | creator | int unsigned | 10 |  |  |  |
product_category | creator | int unsigned | 10 |  |  |  |
product_price_log | creator | int unsigned | 10 |  |  |  |
region | creator | int unsigned | 10 |  |  |  |
role | creator | int unsigned | 10 | √ |  | null |
site | creator | int unsigned | 10 | √ |  | null |
source | creator | int unsigned | 10 | √ |  | null |
subscription | creator | int unsigned | 10 | √ |  | null | only appliable when an authenticated user creates one
tag_item | creator | int unsigned | 10 | √ |  | null |
tag_option | creator | int unsigned | 10 | √ |  | null |
topic | creator | int unsigned | 10 | √ |  | null |
user_profile | creator | int unsigned | 10 | √ |  | null |
user_role | creator | int unsigned | 10 | √ |  | null |
place | cross_site | bit | 0 | √ |  | 0 | 0 or null: site-specific, 1: cross-site.
ip_country | ctry | char | 2 |  |  |  |
product | currency | varchar | 3 |  |  |  |
ads | customer | varchar | 255 | √ |  | null |
newsletter | customizable | bit | 0 | √ |  | 0 |
news_log | data | varchar | 1000 | √ |  | null |
site | data_folder | varchar | 100 | √ |  | null |
api_audit_log | date | datetime | 19 |  |  |  |
entity_audit_log | date | datetime | 19 |  |  |  |
news_transition_log | date | datetime | 19 |  |  |  |
site | db_connection_string | varchar | 150 | √ |  | null |
media | deleted | bit | 0 | √ |  | null |
news_history | deleted | bit | 0 | √ |  | null |
place | deny_ips | varchar | 500 | √ |  | null |
product_category | depth | int unsigned | 10 |  |  |  |
region | depth | tinyint unsigned | 3 |  |  |  |
topic | depth | tinyint unsigned | 3 |  |  | 1 | topic: 1, subtopic: 2, sub-subtopic: 3, etc.
media | des | varchar | 1000 | √ |  | null |
product | description | varchar | 1000 | √ |  | null |
product_category | description | varchar | 1000 | √ |  | null |
topic | description | varchar | 500 | √ |  | null | description meta in html page of this topic
news | doc_num | varchar | 20 | √ |  | null |
news_history | doc_num | varchar | 50 | √ |  | null |
site_domain | domain_name | varchar | 50 |  |  |  |
place | duplicate_score | int unsigned | 10 | √ |  | null | minimum similarity score to find original news of a matched news of this place (using query). 0 means no duplicate removal should be done.
media | duration | int unsigned | 10 | √ |  | null | ms
news_comment | edited_body | text | 65535 | √ |  | null |
news_comment | edited_username | varchar | 30 | √ |  | null |
person | email | varchar | 100 | √ |  | null |
subscription | email | varchar | 70 |  |  |  |
user_profile | email | varchar | 50 | √ |  | null |
site | email_password | varchar | 100 | √ |  | null |
site | email_username | varchar | 100 | √ |  | null |
ads | end_date | timestamp | 19 | √ |  | null |
news | end_date | datetime | 19 | √ |  | null |
news_history | end_date | timestamp | 19 | √ |  | null |
place | end_date | datetime | 19 | √ |  | null |
poll | end_date | datetime | 19 |  |  |  |
media | entity | int unsigned | 10 |  |  | 1 | 1: news, 2: ads, 3: person
entity_audit_log | entity_class | varchar | 30 |  |  |  |
entity_audit_log | entity_id | int unsigned | 10 |  |  |  |
news_history | entity_tag_ids | varchar | 80 | √ |  | null |
entity_audit_log | entity_title | varchar | 200 | √ |  | null |
news | event_date | datetime | 19 | √ |  | null | date of news event
news_history | event_date | datetime | 19 | √ |  | null | date of news event
calendar | event_des | varchar | 300 | √ |  | null |
user_profile | failed_login_count | int unsigned | 10 |  |  | 0 |
user_profile | failed_login_date | datetime | 19 | √ |  | null |
user_profile | failed_login_ip | varchar | 50 | √ |  | null |
place | filter_news_type | varchar | 50 | √ |  | null |
place | filter_source | varchar | 500 | √ |  | null |
place | filter_topic | varchar | 100 | √ |  | null |
person | first_name | varchar | 50 | √ |  | null |
user_profile | first_name | varchar | 25 | √ |  | null |
news_type | fixed | bit | 0 |  |  |  |
news | flags | int | 10 | √ |  | null |
site | flags | bigint | 19 | √ |  | null | site boolean flags
source | flags | int unsigned | 10 |  |  |  |
tag_item | flags | int unsigned | 10 |  |  |  |
ads | flash_media_id | int unsigned | 10 | √ |  | null |
news_transition_log | from_state | tinyint unsigned | 3 |  |  |  |
news_transition_log | from_user_id | int unsigned | 10 |  |  |  |
keyword | full_title | varchar | 255 |  |  |  | full title in the form: parent > title
product_category | full_title | varchar | 255 |  |  |  |
region | full_title | varchar | 255 |  |  |  | full title in the form: parent > title
topic | full_title | varchar | 200 |  |  |  | full title in the form: parent > title
person | gender | tinyint unsigned | 3 | √ |  | null |
calendar | gh_day | tinyint unsigned | 3 |  |  |  |
calendar | gh_month_name | varchar | 25 |  |  |  |
calendar | gh_year | smallint unsigned | 5 |  |  |  |
site | google_analytic_js | varchar | 1000 | √ |  | null |
site | google_meta_verification | varchar | 200 | √ |  | null |
calendar | gr_date | date | 10 | √ |  | null |
calendar | gr_day | tinyint unsigned | 3 |  |  |  |
calendar | gr_month_name | varchar | 25 |  |  |  |
calendar | gr_year | smallint unsigned | 5 |  |  |  |
user_config | grid_size | int unsigned | 10 | √ |  | null |
place | has_archive | bit | 0 | √ |  | 1 |
place | has_carousel | bit | 0 | √ |  | null |
news | has_comment | bit | 0 | √ |  | null |
news_history | has_comment | bit | 0 | √ |  | null |
place | has_comment | bit | 0 | √ |  | 0 |
place | has_feed | bit | 0 | √ |  | 0 |
place | has_image | bit | 0 | √ |  | 0 |
place | has_journalist | bit | 0 | √ |  | 0 |
place | has_kicker | bit | 0 | √ |  | null |
place | has_lead | bit | 0 | √ |  | 0 |
place | has_player | bit | 0 | √ |  | 0 |
place | has_publish_date | tinyint unsigned | 3 | √ |  | null |
place | has_related_image | bit | 0 | √ |  | 0 |
place | has_related_news | tinyint unsigned | 3 | √ |  | null |
place | has_short_headline | bit | 0 | √ |  | 1 |
place | has_source | bit | 0 | √ |  | 0 |
place | has_subhead | bit | 0 | √ |  | null |
site | has_subscription | bit | 0 | √ |  | null |
place | has_telegram | bit | 0 | √ |  | 0 |
place | has_titr1 | bit | 0 | √ |  | 0 |
place | header_bg_color | char | 7 | √ |  | null |
news | headline | varchar | 500 | √ |  | null | title
news_history | headline | varchar | 500 |  |  |  |
news_history | headline_length | int unsigned | 10 | √ |  | null | to prevent realtime counting for each view cutting.
calendar | holiday | bit | 0 |  |  |  |
site | home_page_title | varchar | 100 | √ |  | null |
place | html_container_id | varchar | 150 | √ |  | null |
product | icon_id | int unsigned | 10 | √ |  | null |
product_category | icon_id | int unsigned | 10 | √ |  | null |
ads | id | mediumint | 7 |  | √ |  |
api_audit_log | id | int unsigned | 10 |  | √ |  |
calendar | id | smallint unsigned | 5 |  |  |  |
entity_audit_log | id | int unsigned | 10 |  | √ |  |
entity_tag | id | int unsigned | 10 |  | √ |  |
ip_country | id | int | 10 |  |  |  |
keyword | id | int unsigned | 10 |  | √ |  |
large_entity | id | int unsigned | 10 |  | √ |  |
link | id | int unsigned | 10 |  | √ |  |
link_group | id | int unsigned | 10 |  | √ |  |
media | id | int unsigned | 10 |  | √ |  |
menu | id | int unsigned | 10 |  |  |  |
messaging_log | id | int unsigned | 10 |  | √ |  |
news | id | int unsigned | 10 |  | √ |  |
news_comment | id | int unsigned | 10 |  | √ |  |
news_history | id | int unsigned | 10 |  | √ |  |
news_keyword | id | int unsigned | 10 |  | √ |  |
news_log | id | int unsigned | 10 |  | √ |  |
news_media | id | int unsigned | 10 |  | √ |  |
news_news | id | int | 10 |  | √ |  |
news_place | id | int unsigned | 10 |  | √ |  |
news_place_archive | id | int unsigned | 10 |  | √ |  |
news_subtopic | id | int unsigned | 10 |  | √ |  |
news_transition_log | id | int unsigned | 10 |  | √ |  |
news_type | id | int unsigned | 10 |  | √ |  |
newsletter | id | int unsigned | 10 |  | √ |  |
person | id | int unsigned | 10 |  | √ |  |
place | id | int unsigned | 10 |  | √ |  |
poll | id | int unsigned | 10 |  | √ |  |
poll_option | id | int unsigned | 10 |  | √ |  |
product | id | int unsigned | 10 |  | √ |  |
product_category | id | int unsigned | 10 |  | √ |  |
product_price_log | id | int unsigned | 10 |  | √ |  |
region | id | int unsigned | 10 |  | √ |  |
role | id | int unsigned | 10 |  | √ |  |
site | id | int unsigned | 10 |  |  |  |
site_domain | id | int unsigned | 10 |  |  |  |
source | id | mediumint unsigned | 8 |  | √ |  |
subscription | id | int unsigned | 10 |  | √ |  |
subscription_log | id | int | 10 |  | √ |  |
tag_item | id | int unsigned | 10 |  | √ |  |
tag_option | id | int unsigned | 10 |  | √ |  |
topic | id | int unsigned | 10 |  | √ |  |
user_config | id | int unsigned | 10 |  | √ |  |
user_message | id | int | 10 |  |  |  |
user_profile | id | int unsigned | 10 |  | √ |  |
user_role | id | int unsigned | 10 |  | √ |  |
user_site | id | int unsigned | 10 |  | √ |  |
vote | id | int unsigned | 10 |  | √ |  |
user_config | image | varchar | 100 | √ |  | null |
news | image2_id | int unsigned | 10 | √ |  | null |
news_history | image2_id | int unsigned | 10 | √ |  | null |
news | image_id | int unsigned | 10 | √ |  | null |
news_history | image_id | int unsigned | 10 | √ |  | null |
product | image_id | int unsigned | 10 | √ |  | null |
ads | image_media_id | int unsigned | 10 | √ |  | null |
place | image_size | int | 10 | √ |  | null | 1 to 5
site | imap_server | varchar | 100 | √ |  | null |
tag_item | in_reports | tinyint unsigned | 3 | √ |  | null | show this tagitem in newsroom reports or not
site | info_email | varchar | 100 | √ |  | null |
person | initial | int unsigned | 10 | √ |  | null |
news_media | internal | bit | 0 |  |  |  |
news | invisible_top | bit | 0 |  |  | 0 | Invisible in top places, ex: invisble in top-visited place
news_history | invisible_top | bit | 0 |  |  | 0 | Invisible in top places, ex: invisble in top-visited place
api_audit_log | ip | varchar | 30 | √ |  | null |
vote | ip | varchar | 40 | √ |  | null |
ip_country | ip_from | bigint | 19 |  |  |  |
ip_country | ip_to | bigint | 19 |  |  |  |
place | is_main | bit | 0 |  |  | 0 |
news_comment | is_read | bit | 0 | √ |  | 0 |
tag_option | item_id | int unsigned | 10 |  |  |  |
poll_option | item_order | int unsigned | 10 |  |  |  |
tag_item | item_type | tinyint unsigned | 3 |  |  |  |
person | job_title | varchar | 75 | √ |  | null |
person | journalist | bit | 0 | √ |  | null | is this person a journalist
news | journalist_id | int unsigned | 10 | √ |  | null |
news_history | journalist_id | int unsigned | 10 | √ |  | null |
topic | keyword | varchar | 500 | √ |  | null | keyword meta in html page of this topic
media_keyword | keyword_id | int unsigned | 10 |  |  |  |
news_keyword | keyword_id | int unsigned | 10 |  |  |  |
subscription | keyword_id | int unsigned | 10 | √ |  | null |
news_history | keyword_ids | varchar | 80 | √ |  | null |
place | keywords | varchar | 50 | √ |  | null | cvs list of keyword ids
news | kicker | varchar | 500 | √ |  | null | routitr
news_history | kicker | varchar | 500 | √ |  | null |
site | lang_code | char | 5 |  |  |  |
site | lang_direction | char | 3 |  |  |  |
news | language | varchar | 2 | √ |  | fa |
poll | language | varchar | 2 |  |  |  |
ads | last_click | datetime | 19 | √ |  | null |
news_log | last_comment | datetime | 19 | √ |  | null |
user_profile | last_login_date | datetime | 19 | √ |  | null |
user_profile | last_login_ip | varchar | 50 | √ |  | null |
person | last_name | varchar | 50 |  |  |  |
user_profile | last_name | varchar | 25 | √ |  | null |
user_profile | last_password_change | datetime | 19 | √ |  | null |
newsletter | last_publish | datetime | 19 | √ |  | null |
news_log | last_publish_date | datetime | 19 | √ |  | null | When news is published, unpublished, and then published again this field holds the last publish date.
ads | last_view | datetime | 19 | √ |  | null |
news_log | last_view | datetime | 19 | √ |  | null |
user_message | last_view | datetime | 19 | √ |  | null |
region | latitude | double | 22 | √ |  | null |
news | lead | varchar | 4000 | √ |  | null | chekideh
news_history | lead | varchar | 4000 | √ |  | null |
place | lead_limit | int unsigned | 10 | √ |  | null |
news_comment | like_count | int unsigned | 10 | √ |  | null |
news_log | like_count | int unsigned | 10 |  |  | 0 |
site | limit_news_days | int | 10 | √ |  | null |
site | limit_start_date | datetime | 19 | √ |  | null |
place | link | varchar | 500 | √ |  | null | box custom link
link | link_group_id | int unsigned | 10 | √ |  | null |
site | links_news_id | int | 10 | √ |  | null |
news | locked | datetime | 19 | √ |  | null |
news_history | locked | datetime | 19 | √ |  | null |
news | locker_id | int unsigned | 10 | √ |  | null |
news_history | locker_id | int unsigned | 10 | √ |  | null |
region | longitude | double | 22 | √ |  | null |
site | mandatory_body | int unsigned | 10 | √ |  | 0 | 0 means optional. Greater than zero means at least that number of characters are required.
site | mandatory_headline | int unsigned | 10 | √ |  | 1 | 0 means optional. Greater than zero means at least that number of characters are required.
site | mandatory_journalist | bit | 0 | √ |  | 0 |
site | mandatory_keyword | int unsigned | 10 | √ |  | 0 | 0 means optional. Greater than zero means at least that number of keywords are required.
site | mandatory_lead | int unsigned | 10 | √ |  | 0 | 0 means optional. Greater than zero means at least that number of characters are required.
site | mandatory_region | bit | 0 | √ |  | 0 |
site | mandatory_short_headline | int unsigned | 10 | √ |  | 0 | 0 means optional. Greater than zero means at least that number of characters are required.
site | mandatory_source | bit | 0 | √ |  | 0 |
site | master_site_id | int unsigned | 10 | √ |  | null | maste site of this site
site | max_body_chars | int unsigned | 10 | √ |  | 25000 |
ads | max_click | int | 10 | √ |  | null |
site | max_headline_chars | int unsigned | 10 | √ |  | null |
site | max_kicker_chars | int unsigned | 10 | √ |  | null |
site | max_lead_chars | int unsigned | 10 | √ |  | null |
site | max_short_headline_chars | int unsigned | 10 | √ |  | null |
ads | max_view | int | 10 | √ |  | null |
entity_tag | media_id | int unsigned | 10 | √ |  | null |
media_keyword | media_id | int unsigned | 10 |  |  |  |
news_media | media_id | int unsigned | 10 |  |  |  |
news_history | media_ids | varchar | 200 | √ |  | null |
site | media_url | varchar | 100 |  |  |  | base url address for media
newsletter | medium | tinyint | 3 |  |  | 1 | 1: email, 2: sms
role | menu_ids | varchar | 1000 | √ |  | null | CSV which starts and ends width comma
site | meta_copyright | varchar | 250 | √ |  | null |
site | meta_des | varchar | 500 | √ |  | null |
topic | meta_des | varchar | 500 | √ |  | null |
site | meta_frontpage | varchar | 500 | √ |  | null |
site | meta_keyword | varchar | 300 | √ |  | null |
topic | meta_keyword | varchar | 300 | √ |  | null |
ads | modified | timestamp | 19 | √ |  | null |
entity_tag | modified | timestamp | 19 | √ |  | null |
keyword | modified | timestamp | 19 | √ |  | null |
link | modified | timestamp | 19 | √ |  | null |
link_group | modified | timestamp | 19 | √ |  | null |
media | modified | timestamp | 19 | √ |  | null |
news | modified | timestamp | 19 | √ |  | null |
news_comment | modified | timestamp | 19 | √ |  | null | reply_date
news_history | modified | timestamp | 19 | √ |  | null |
news_media | modified | timestamp | 19 | √ |  | null |
news_news | modified | timestamp | 19 | √ |  | null |
news_place | modified | timestamp | 19 | √ |  | null |
news_place_archive | modified | timestamp | 19 | √ |  | null |
news_type | modified | timestamp | 19 | √ |  | null |
newsletter | modified | datetime | 19 | √ |  | null |
person | modified | timestamp | 19 | √ |  | null |
place | modified | timestamp | 19 | √ |  | null |
poll | modified | datetime | 19 | √ |  | null |
product | modified | datetime | 19 | √ |  | null |
product_category | modified | datetime | 19 | √ |  | null |
region | modified | timestamp | 19 | √ |  | null |
role | modified | timestamp | 19 | √ |  | null |
site | modified | timestamp | 19 | √ |  | null |
source | modified | timestamp | 19 | √ |  | null |
subscription | modified | datetime | 19 | √ |  | null |
tag_item | modified | timestamp | 19 | √ |  | null |
tag_option | modified | timestamp | 19 | √ |  | null |
topic | modified | timestamp | 19 | √ |  | null |
user_profile | modified | timestamp | 19 | √ |  | null |
user_role | modified | timestamp | 19 | √ |  | null |
ads | modifier | int unsigned | 10 | √ |  | null |
entity_tag | modifier | int unsigned | 10 | √ |  | null |
keyword | modifier | int unsigned | 10 | √ |  | null |
link | modifier | int unsigned | 10 | √ |  | null |
link_group | modifier | int unsigned | 10 | √ |  | null |
media | modifier | int unsigned | 10 | √ |  | null |
news | modifier | int unsigned | 10 | √ |  | null |
news_comment | modifier | int unsigned | 10 | √ |  | null | reply_user_id
news_history | modifier | int unsigned | 10 | √ |  | null |
news_media | modifier | int unsigned | 10 | √ |  | null |
news_news | modifier | int unsigned | 10 | √ |  | null |
news_place | modifier | int unsigned | 10 | √ |  | null |
news_place_archive | modifier | int unsigned | 10 | √ |  | null |
news_type | modifier | int unsigned | 10 | √ |  | null |
newsletter | modifier | int | 10 | √ |  | null |
person | modifier | int unsigned | 10 | √ |  | null |
place | modifier | int unsigned | 10 | √ |  | null |
poll | modifier | int unsigned | 10 | √ |  | null |
product | modifier | int unsigned | 10 | √ |  | null |
product_category | modifier | int unsigned | 10 | √ |  | null |
region | modifier | int unsigned | 10 | √ |  | null |
role | modifier | int unsigned | 10 | √ |  | null |
site | modifier | int unsigned | 10 | √ |  | null |
source | modifier | int unsigned | 10 | √ |  | null |
subscription | modifier | int unsigned | 10 | √ |  | null | only appliable when an authenticated user modifies one
tag_item | modifier | int unsigned | 10 | √ |  | null |
tag_option | modifier | int unsigned | 10 | √ |  | null |
topic | modifier | int unsigned | 10 | √ |  | null |
user_profile | modifier | int unsigned | 10 | √ |  | null |
user_role | modifier | int unsigned | 10 | √ |  | null |
place | module_path | varchar | 2000 | √ |  | null |
place | mosaic_archive | int unsigned | 10 | √ |  | null |
subscription | name | varchar | 40 |  |  |  |
user_profile | national_code | varchar | 10 | √ |  | null |
news_comment | negative | int unsigned | 10 | √ |  | null |
news_log | negative | int unsigned | 10 |  |  | 0 |
place | news_age | int unsigned | 10 | √ |  | 7 | Maximum new age in day
place | news_age_unit | smallint unsigned | 5 |  |  | 3 | {1: MINUTE, 2: HOUR, 3: DAY}
news_history | news_comment_ids | varchar | 200 | √ |  | null |
newsletter | news_count | int | 10 |  |  | 1 |
place | news_count | int unsigned | 10 |  |  | 1 |
subscription | news_count | smallint unsigned | 5 | √ |  | null | if null, will use newsletter.news_count
user_message | news_history_id | int | 10 | √ |  | null |
entity_tag | news_id | int unsigned | 10 | √ |  | null |
news_comment | news_id | int unsigned | 10 |  |  |  |
news_history | news_id | int unsigned | 10 |  |  |  |
news_keyword | news_id | int unsigned | 10 |  |  |  |
news_log | news_id | int unsigned | 10 |  |  | 0 |
news_media | news_id | int unsigned | 10 |  |  |  |
news_news | news_id | int unsigned | 10 |  |  |  |
news_place | news_id | int unsigned | 10 |  |  |  |
news_place_archive | news_id | int unsigned | 10 |  |  |  |
news_subtopic | news_id | int unsigned | 10 |  |  |  |
news_transition_log | news_id | int unsigned | 10 | √ |  | null |
messaging_log | news_ids | varchar | 250 | √ |  | null |
user_config | news_language | varchar | 2 | √ |  | null |
user_config | news_type | smallint unsigned | 5 | √ |  | null |
place | news_type_id | int unsigned | 10 | √ |  | null |
messaging_log | newsletter_id | int unsigned | 10 | √ |  | null |
subscription | newsletter_id | int unsigned | 10 |  |  |  |
news | note | varchar | 400 | √ |  | null | json crawlpartdata
news_history | note | varchar | 400 | √ |  | null | json crawlpartdata
tag_option | option_order | int unsigned | 10 | √ |  | null |
media | original_bitrate | int unsigned | 10 | √ |  | null | kbps
media | original_filename | varchar | 255 |  |  |  |
media | original_format | varchar | 5 |  |  |  |
media | original_height | int unsigned | 10 | √ |  | null | in pixels
media | original_size | int unsigned | 10 | √ |  | null |
media | original_width | int unsigned | 10 | √ |  | null | in pixels
media | owner | varchar | 50 | √ |  | null | interviewer, camera man, author, etc.
site | page_title | varchar | 100 | √ |  | null |
keyword | parent_id | int unsigned | 10 | √ |  | null | parent keyword (for multi-level keyword support)
news_comment | parent_id | int unsigned | 10 | √ |  | null |
product_category | parent_id | int unsigned | 10 | √ |  | null |
region | parent_id | int unsigned | 10 | √ |  | null |
topic | parent_id | int unsigned | 10 | √ |  | null |
user_profile | password | varchar | 60 | √ |  | null |
site | password_expire_days | int unsigned | 10 | √ |  | 0 |
user_profile | password_expired | bit | 0 |  |  | 0 |
site | path_seperator | char | 1 | √ |  | null |
site | permissions | varchar | 200 | √ |  | null | comma separated list of permissions enabled on this website
role | permissions_ids | varchar | 1000 | √ |  | null | CSV which starts and ends width comma
entity_tag | person_id | int unsigned | 10 | √ |  | null |
media | personals | varchar | 250 | √ |  | null |
user_profile | phone_number | varchar | 15 | √ |  | null |
person | photographer | bit | 0 | √ |  | null | is this person a photographer
media | photographer_id | int unsigned | 10 | √ |  | null |
ads | place_id | int unsigned | 10 |  |  |  |
news_place | place_id | int unsigned | 10 |  |  |  |
news_place_archive | place_id | int unsigned | 10 |  |  |  |
newsletter | place_id | int unsigned | 10 |  |  |  |
poll | place_id | int unsigned | 10 |  |  |  |
news_history | place_ids | varchar | 80 | √ |  | null |
role | place_ids | varchar | 1000 | √ |  | null | CSV which starts and ends width comma
media | places | varchar | 250 | √ |  | null |
poll_option | poll_id | int unsigned | 10 |  |  |  |
vote | poll_id | int unsigned | 10 |  |  |  |
site_domain | port_number | smallint unsigned | 5 |  |  |  |
news_comment | positive | int unsigned | 10 | √ |  | null |
news_log | positive | int unsigned | 10 |  |  | 0 |
keyword | preferred_id | int unsigned | 10 | √ |  | null | preferred keyword
person | prefix_name | varchar | 50 | √ |  | null |
product | price | float | 12 |  |  |  |
product_price_log | price | float | 12 |  |  |  |
product | price_max | float | 12 |  |  |  |
product_price_log | price_max | float | 12 |  |  |  |
product | price_min | float | 12 |  |  |  |
product_price_log | price_min | float | 12 |  |  |  |
person | print_name | varchar | 100 | √ |  | null |
ads | priority | int | 10 |  |  |  |
link | priority | int unsigned | 10 | √ |  | null |
link_group | priority | int unsigned | 10 |  |  |  |
news_media | priority | int unsigned | 10 | √ |  | null |
news_news | priority | smallint unsigned | 5 |  |  |  |
news_place | priority | int | 10 | √ |  | null |
news_place_archive | priority | int unsigned | 10 | √ |  | null |
news_type | priority | int unsigned | 10 | √ |  | null |
place | priority | int unsigned | 10 | √ |  | null |
poll | priority | int unsigned | 10 |  |  | 0 |
product | priority | int unsigned | 10 |  |  |  |
source | priority | int unsigned | 10 | √ |  | null | used for ordering
tag_item | priority | smallint | 5 | √ |  | null |
topic | priority | int unsigned | 10 | √ |  | null |
product_price_log | product_id | int unsigned | 10 |  |  |  |
site_domain | protocol | varchar | 10 |  |  | * | Could be * for all protocols
news_log | pub_comment_count | int unsigned | 10 |  |  | 0 |
news | publish_date | datetime | 19 | √ |  | null |
news_history | publish_date | timestamp | 19 | √ |  | null |
place | publish_date_format | varchar | 20 | √ |  | null |
messaging_log | publish_strategy | tinyint | 3 |  |  |  |
newsletter | publish_strategy | tinyint | 3 |  |  | 1 | 1: automatic, 2: manual
subscription_log | publish_strategy | int | 10 |  |  |  |
news_comment | published | bit | 0 | √ |  | 0 |
place | query | varchar | 500 | √ |  | null |
poll | question | varchar | 1000 |  |  |  |
user_message | received | timestamp | 19 | √ |  | null |
user_message | recipient | int | 10 | √ |  | null |
news | recipient_id | int unsigned | 10 | √ |  | null |
news_history | recipient_id | int unsigned | 10 | √ |  | null |
news | redirect_url | varchar | 250 | √ |  | null |
news_history | redirect_url | varchar | 250 | √ |  | null |
api_audit_log | ref | varchar | 30 | √ |  | null |
api_audit_log | referer | varchar | 100 | √ |  | null |
news | region_id | int unsigned | 10 | √ |  | null |
news_history | region_id | int unsigned | 10 | √ |  | null |
user_profile | region_ids | varchar | 1000 | √ |  | null | comma-separated list of region ids
ip_country | registry | varchar | 7 |  |  |  |
place | related_news_count | int unsigned | 10 | √ |  | null |
news_news | related_news_id | int unsigned | 10 |  |  |  |
news_history | related_news_ids | varchar | 100 | √ |  | null |
news_history | related_sub_topic_ids | varchar | 80 | √ |  | null |
news_news | relation_type | tinyint unsigned | 3 | √ |  | null |
place | relation_type | varchar | 50 | √ |  | null | comma-separated relation type
site | render_news_source | bit | 0 | √ |  | 0 |
news_comment | reply_body | varchar | 500 | √ |  | null |
media | repos | tinyint unsigned | 3 | √ |  | 1 | repository version, 0: old, 1 or null is current
user_role | role_id | int unsigned | 10 |  |  |  |
user_profile | salt | varchar | 30 | √ |  | null |
tag_option | score | float unsigned | 12 | √ |  | null |
news | score_ed | smallint unsigned | 5 | √ |  | null |
news_history | score_ed | smallint unsigned | 5 | √ |  | null |
news | score_eic | smallint unsigned | 5 | √ |  | null |
news_history | score_eic | smallint unsigned | 5 | √ |  | null |
keyword | search_title | varchar | 100 |  |  |  |
media | search_title | varchar | 255 | √ |  | null |
news | search_title | varchar | 500 | √ |  | null | normalized headline for searching
person | search_title | varchar | 100 | √ |  | null |
product | search_title | varchar | 100 | √ |  | null |
product_category | search_title | varchar | 100 | √ |  | null |
region | search_title | varchar | 200 |  |  |  |
source | search_title | varchar | 100 |  |  |  |
topic | search_title | varchar | 200 |  |  |  |
user_profile | search_title | varchar | 100 | √ |  | null |
user_message | sender | int | 10 |  |  |  |
site | sender_email | varchar | 100 | √ |  | null |
user_message | sent | timestamp | 19 |  |  | CURRENT_TIMESTAMP |
news_comment | session_id | varchar | 60 | √ |  | null |
calendar | sh_date | char | 10 |  |  |  |
calendar | sh_day | tinyint unsigned | 3 |  |  |  |
calendar | sh_day_name | varchar | 25 |  |  |  |
calendar | sh_month | tinyint unsigned | 3 |  |  |  |
calendar | sh_month_name | varchar | 25 |  |  |  |
calendar | sh_year | smallint unsigned | 5 |  |  |  |
news | short_headline | varchar | 200 | √ |  | null |
news_history | short_headline | varchar | 200 | √ |  | null |
news_comment | show_email | bit | 0 | √ |  | null |
place | show_in_topic | varchar | 255 | √ |  | null | comma-separated topic id list
ads | site_id | int unsigned | 10 | √ |  | null |
api_audit_log | site_id | int unsigned | 10 |  |  |  |
entity_tag | site_id | int unsigned | 10 | √ |  | null |
keyword | site_id | int unsigned | 10 |  |  | 1 |
link | site_id | int unsigned | 10 | √ |  | null |
link_group | site_id | int unsigned | 10 | √ |  | null |
media | site_id | int unsigned | 10 | √ |  | null |
menu | site_id | int | 10 |  |  |  |
news | site_id | int unsigned | 10 | √ |  | null |
news_comment | site_id | int unsigned | 10 |  |  |  |
news_history | site_id | smallint | 5 | √ |  | null |
news_media | site_id | smallint | 5 | √ |  | null |
news_place | site_id | smallint | 5 | √ |  | null |
news_place_archive | site_id | smallint | 5 | √ |  | null |
news_type | site_id | int unsigned | 10 | √ |  | null |
newsletter | site_id | smallint unsigned | 5 | √ |  | 1 |
person | site_id | int unsigned | 10 | √ |  | null |
place | site_id | int unsigned | 10 | √ |  | null |
poll | site_id | int unsigned | 10 |  |  |  |
product | site_id | int unsigned | 10 | √ |  | null |
product_category | site_id | int unsigned | 10 | √ |  | null |
region | site_id | int unsigned | 10 | √ |  | null |
role | site_id | int unsigned | 10 | √ |  | null |
site | site_id | smallint unsigned | 5 | √ |  | null |
site_domain | site_id | int unsigned | 10 |  |  |  |
source | site_id | int unsigned | 10 | √ |  | null |
subscription | site_id | smallint unsigned | 5 | √ |  | 1 |
tag_item | site_id | int unsigned | 10 | √ |  | null |
tag_option | site_id | int unsigned | 10 | √ |  | null |
topic | site_id | int unsigned | 10 | √ |  | null |
user_profile | site_id | int unsigned | 10 | √ |  | null |
user_role | site_id | int unsigned | 10 | √ |  | null |
user_site | site_id | int unsigned | 10 | √ |  | null |
role | site_ids | varchar | 50 | √ |  | null | CSV list of site ids
site | slogon | varchar | 150 | √ |  | null |
place | sort_field | int | 10 | √ |  | null |
news | source_id | mediumint unsigned | 8 | √ |  | null |
news_history | source_id | mediumint unsigned | 8 | √ |  | null |
subscription | source_id | mediumint unsigned | 8 | √ |  | null |
ads | start_date | timestamp | 19 | √ |  | null |
news | start_date | datetime | 19 | √ |  | null | Should Set this after publish
news_history | start_date | timestamp | 19 | √ |  | null | Should Set this after publish
newsletter | start_date | datetime | 19 |  |  |  |
place | start_date | datetime | 19 | √ |  | null |
poll | start_date | datetime | 19 |  |  |  |
news | status | int unsigned | 10 | √ |  | null |
news_history | status | int unsigned | 10 | √ |  | null |
subscription | status | int | 10 |  |  |  |
user_message | status | tinyint | 3 | √ |  | null |
user_profile | status | int unsigned | 10 | √ |  | null |
user_profile | staus | int | 10 | √ |  | null |
news | sub_topic_id | int unsigned | 10 | √ |  | null |
news_history | sub_topic_id | int unsigned | 10 |  |  |  |
news_place | sub_topic_id | int unsigned | 10 | √ |  | null |
news_place_archive | sub_topic_id | int unsigned | 10 | √ |  | null |
news | subhead | varchar | 500 | √ |  | null | zirtitr
news_history | subhead | varchar | 500 | √ |  | null |
place | subject_filter | bit | 0 | √ |  | 0 | if true, joins news box with current subject (if any)
place | subject_id | int unsigned | 10 | √ |  | null | subject/package/portal/parvandeh
subscription_log | subscription | int | 10 |  |  |  |
messaging_log | subscription_id | int unsigned | 10 | √ |  | null |
messaging_log | success | tinyint unsigned | 3 |  |  |  |
keyword | synonym | varchar | 500 | √ |  | null |
place | tab_group | varchar | 30 | √ |  | null |
entity_tag | tag_item_id | tinyint unsigned | 3 |  |  |  |
entity_tag | tag_item_type | tinyint unsigned | 3 |  |  |  |
entity_tag | tag_item_value | varchar | 150 | √ |  | null |
entity_tag | tag_option_id | int unsigned | 10 | √ |  | null |
large_entity | text | mediumtext | 16777215 | √ |  | null |
place | theme | varchar | 255 | √ |  | null |
user_config | theme | varchar | 20 | √ |  | null |
site | theme_folder | varchar | 20 | √ |  | null |
newsletter | time_interval | int | 10 |  |  | 1440 | interval between two alerts (in minute)
ads | title | varchar | 255 |  |  |  |
keyword | title | varchar | 100 |  |  |  |
link | title | varchar | 100 |  |  |  |
link_group | title | varchar | 50 |  |  |  |
media | title | varchar | 255 | √ |  | null |
menu | title | varchar | 50 |  |  |  |
news_media | title | varchar | 255 | √ |  | null |
news_type | title | varchar | 50 |  |  |  |
newsletter | title | varchar | 100 |  |  |  |
place | title | varchar | 150 |  |  |  |
poll | title | varchar | 100 |  |  |  |
poll_option | title | varchar | 300 |  |  |  |
product | title | varchar | 200 |  |  |  |
product_category | title | varchar | 100 |  |  |  |
region | title | varchar | 60 |  |  |  |
role | title | varchar | 50 |  |  |  |
site | title | varchar | 50 |  |  |  |
source | title | varchar | 100 |  |  |  |
tag_item | title | varchar | 50 |  |  |  |
tag_option | title | varchar | 100 |  |  |  |
topic | title | varchar | 50 |  |  |  |
user_message | title | text | 65535 | √ |  | null |
tag_option | title2 | varchar | 100 | √ |  | null |
place | title_limit | int unsigned | 10 | √ |  | null |
news_transition_log | to_state | tinyint unsigned | 3 |  |  |  |
news_transition_log | to_user_id | int unsigned | 10 | √ |  | null |
user_config | topic | int unsigned | 10 | √ |  | null |
place | topic_filter | bit | 0 | √ |  | 0 | if true,contents filtered by topic_id which request from query string of the page.
place | topic_filter_depth | bit | 0 | √ |  | 1 | if topic_filter is true, it should be filtered by topics of this depth
ads | topic_id | int unsigned | 10 | √ |  | null |
news | topic_id | int unsigned | 10 |  |  |  |
news_history | topic_id | int unsigned | 10 |  |  |  |
news_place | topic_id | int unsigned | 10 | √ |  | null |
news_place_archive | topic_id | int unsigned | 10 | √ |  | null |
news_subtopic | topic_id | int unsigned | 10 |  |  |  |
place | topic_id | int unsigned | 10 | √ |  | null |
poll | topic_id | int unsigned | 10 | √ |  | null |
subscription | topic_id | int unsigned | 10 | √ |  | null |
user_profile | topic_ids | varchar | 255 | √ |  | null |
site | topic_top1_id | int | 10 | √ |  | null |
site | topic_top2_id | int | 10 | √ |  | null |
large_entity | type | tinyint unsigned | 3 |  |  | 0 | to which field is this entity bound
media | type | int unsigned | 10 |  |  |  | 0:other, 1:photo ,2:audio ,3:video ,4:flash, 5:document
news_media | type | smallint unsigned | 5 |  |  |  | 1:Gallery(gozaresh tasviri), 2:Attachment
place | type | int unsigned | 10 |  |  | 1 | 1:User Defined,2:Last News,3: Most Visited,4:Mos Commented, 5: Most mailed,6: Ads
poll | type | int unsigned | 10 | √ |  | 0 | for future use, e.g. multi-select polls
news | type_id | int unsigned | 10 |  |  |  |
news_history | type_id | int unsigned | 10 |  |  |  |
api_audit_log | ua | varchar | 150 | √ |  | null |
vote | ua | varchar | 200 | √ |  | null |
user_config | ui_language | varchar | 2 | √ |  | null |
ads | url | varchar | 255 |  |  |  |
api_audit_log | url | varchar | 150 | √ |  | null |
link | url | varchar | 100 |  |  |  |
site | url | varchar | 100 | √ |  | null | e.g. http://sahebkhabar.ir with protocol and no ending slash
topic | url | varchar | 100 | √ |  | null |
place | use_image2 | bit | 0 | √ |  | 0 |
site | use_news_id_in_url | bit | 0 | √ |  | 1 | Use newsId in makeUrl
place | use_related_image2 | bit | 0 | √ |  | 0 |
site | use_search_for_keyword_index | bit | 0 | √ |  | 0 |
user_profile | user_config_id | int unsigned | 10 | √ |  | null |
news_comment | user_email | varchar | 200 | √ |  | null |
entity_audit_log | user_id | int unsigned | 10 | √ |  | null |
user_role | user_id | int unsigned | 10 |  |  |  |
user_site | user_id | int unsigned | 10 | √ |  | null |
news_comment | user_ip | varchar | 60 |  |  |  |
subscription | user_ip | varchar | 50 | √ |  | null |
news_comment | user_name | varchar | 100 | √ |  | null |
user_profile | username | varchar | 100 | √ |  | null |
news_history | version | int unsigned | 10 |  |  |  |
ads | view_count | int | 10 | √ |  | null |
news_history | view_count | int unsigned | 10 | √ |  | null |
news_log | view_count | int unsigned | 10 |  |  | 0 |
user_message | view_count | int | 10 | √ |  | null |
ads | visible | bit | 0 |  |  | 1 |
keyword | visible | bit | 0 |  |  | 1 |
news_type | visible | bit | 0 |  |  |  |
newsletter | visible | bit | 0 |  |  | 1 |
place | visible | bit | 0 |  |  | 1 |
poll | visible | tinyint unsigned | 3 |  |  |  |
product | visible | bit | 1 |  |  |  |
product_category | visible | bit | 1 |  |  |  |
source | visible | bit | 0 | √ |  | 1 |
topic | visible | bit | 0 |  |  | 1 |
api_audit_log | visitor | int unsigned | 10 | √ |  | null |
person | website | varchar | 150 | √ |  | null |
user_profile | website | varchar | 50 | √ |  | null |