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

Table sahebkhabar.news | Generated by SchemaSpy

Related columns Constraints Comments Legend |

Legend: |

Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | int unsigned | 10 |  | √ |  |

entity_tag.news_id | FKA7A0293E5A42C676 R
news_comment.news_id | FK_io1bbopmg4bder9jfwk52ubk9 R
news_history.news_id | fk_news_history_news_id C
news_keyword.news_id | fk_news_keyword_news_1 C
news_log.news_id | FK_news_log_news C
news_media.news_id | FK2BF2B3785A42C676 C
news_news.news_id | FK_news_news_news C
news_news.related_news_id | FK_news_news_news_2 C
news_place.news_id | FK2C201C9B5A42C676 C
news_place_archive.news_id | FK_news_id C
news_subtopic.news_id | FK_news_subtopic_news C
news_transition_log.news_id | FK_j8mhh7jtx34ce164ja68wuv5a C
place.subject_id | FK_place_news R

code | varchar | 100 |  |  |  |  |  |
doc_num | varchar | 20 | √ |  | null |  |  |
language | varchar | 2 | √ |  | fa |  |  |
flags | int | 10 | √ |  | null |  |  |
site_id | int unsigned | 10 | √ |  | null |  |

site.id | fk_news_site R

type_id | int unsigned | 10 |  |  |  |  |

news_type.id | fk_news_type_id R

topic_id | int unsigned | 10 |  |  |  |  |

topic.id | fk_news_topic R

sub_topic_id | int unsigned | 10 | √ |  | null |  |

topic.id | fk_news_sub_topic R

journalist_id | int unsigned | 10 | √ |  | null |  |

person.id | fk_news_person R

headline | varchar | 500 | √ |  | null |  |  | title
short_headline | varchar | 200 | √ |  | null |  |  |
search_title | varchar | 500 | √ |  | null |  |  | normalized headline for searching
kicker | varchar | 500 | √ |  | null |  |  | routitr
subhead | varchar | 500 | √ |  | null |  |  | zirtitr
lead | varchar | 4000 | √ |  | null |  |  | chekideh
redirect_url | varchar | 250 | √ |  | null |  |  |
publish_date | datetime | 19 | √ |  | null |  |  |
start_date | datetime | 19 | √ |  | null |  |  | Should Set this after publish
end_date | datetime | 19 | √ |  | null |  |  |
status | int unsigned | 10 | √ |  | null |  |  |
recipient_id | int unsigned | 10 | √ |  | null |  |

user_profile.id | fk_news_recipient R

creator | int unsigned | 10 | √ |  | null |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
locker_id | int unsigned | 10 | √ |  | null |  |

user_profile.id | fk_news_locker R

locked | datetime | 19 | √ |  | null |  |  |
source_id | mediumint unsigned | 8 | √ |  | null |  |

source.id | fk_news_source R

note | varchar | 400 | √ |  | null |  |  | json crawlpartdata
event_date | datetime | 19 | √ |  | null |  |  | date of news event
has_comment | bit | 0 | √ |  | null |  |  |
comment_approval | bit | 0 | √ |  | null |  |  |
comment_headline | varchar | 250 | √ |  | null |  |  |
invisible_top | bit | 0 |  |  | 0 |  |  | Invisible in top places, ex: invisble in top-visited place
body_wcount | int unsigned | 10 | √ |  | null |  |  |
body_html_id | int unsigned | 10 | √ |  | null |  |

large_entity.id | fk_news_large_entity C

body_plain_id | int unsigned | 10 | √ |  | null |  |

large_entity.id | fk_news_large_entity_2 C

image_id | int unsigned | 10 | √ |  | null |  |

media.id | fk_news_image R

image2_id | int unsigned | 10 | √ |  | null |  |

media.id | fk_news_media2 R

region_id | int unsigned | 10 | √ |  | null |  |

region.id | fk_news_region R

active | bit | 0 | √ |  | null |  |  |
score_ed | smallint unsigned | 5 | √ |  | null |  |  |
score_eic | smallint unsigned | 5 | √ |  | null |  |  |

Table contained 5,597 rows at Wed Jan 20 16:28 IRST 2016

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
code | Must be unique | Asc | code
created + creator + site_id + modified | Performance | Asc/Asc/Asc/Asc | crd_crr_st_mdd
body_html_id | Performance | Asc | fk_body_html_id
body_plain_id | Performance | Asc | fk_body_plain_id
image_id | Performance | Asc | fk_image_id
locker_id | Performance | Asc | fk_locker
image2_id | Performance | Asc | FK_news_media2
journalist_id | Performance | Asc | fk_news_person
region_id | Performance | Asc | FK_news_region
source_id | Performance | Asc | fk_news_source
recipient_id | Performance | Asc | fk_recipient
site_id | Performance | Asc | fk_site
source_id | Performance | Asc | fk_source
sub_topic_id | Performance | Asc | fk_sub_topic_id
topic_id | Performance | Asc | fk_topic_id
type_id | Performance | Asc | fk_type
site_id + type_id + topic_id + source_id + image_id + status + publish_date + start_date + end_date | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | idx_st_ty_tp_sr_im_st_pd_sd_ed
publish_date | Performance | Asc | publish_date
created | Performance | Asc | register_date

Close relationships within one two degrees of separation: