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

Table sahebkhabar.news_history | 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 |  | √ |  |  |  |
news_id | int unsigned | 10 |  |  |  |  |

news.id | fk_news_history_news_id C

version | int unsigned | 10 |  |  |  |  |  |
code | varchar | 50 |  |  |  |  |  |
doc_num | varchar | 50 | √ |  | null |  |  |
type_id | int unsigned | 10 |  |  |  |  |

news_type.id | fk_news_type_id_2 R

headline | varchar | 500 |  |  |  |  |  |
short_headline | varchar | 200 | √ |  | null |  |  |
kicker | varchar | 500 | √ |  | null |  |  |
subhead | varchar | 500 | √ |  | null |  |  |
lead | varchar | 4000 | √ |  | null |  |  |
body_html | mediumtext | 16777215 | √ |  | null |  |  |
body_plain | mediumtext | 16777215 | √ |  | null |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
publish_date | timestamp | 19 | √ |  | null |  |  |
start_date | timestamp | 19 | √ |  | null |  |  | Should Set this after publish
end_date | timestamp | 19 | √ |  | null |  |  |
view_count | int unsigned | 10 | √ |  | null |  |  |
comment_count | int unsigned | 10 | √ |  | null |  |  |
redirect_url | varchar | 250 | √ |  | null |  |  |
status | int unsigned | 10 | √ |  | null |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
source_id | mediumint unsigned | 8 | √ |  | null |  |

source.id | fk_news_history_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 |  |  |
headline_length | int unsigned | 10 | √ |  | null |  |  | to prevent realtime counting for each view cutting.
deleted | bit | 0 | √ |  | null |  |  |
active | bit | 0 | √ |  | null |  |  |
creator | int | 10 |  |  |  |  |  |
site_id | smallint | 5 | √ |  | null |  |  |
entity_tag_ids | varchar | 80 | √ |  | null |  |  |
keyword_ids | varchar | 80 | √ |  | null |  |  |
media_ids | varchar | 200 | √ |  | null |  |  |
news_comment_ids | varchar | 200 | √ |  | null |  |  |
related_news_ids | varchar | 100 | √ |  | null |  |  |
related_sub_topic_ids | varchar | 80 | √ |  | null |  |  |
place_ids | varchar | 80 | √ |  | null |  |  |
score_ed | smallint unsigned | 5 | √ |  | null |  |  |
score_eic | smallint unsigned | 5 | √ |  | null |  |  |
body_html_id | int unsigned | 10 | √ |  | null |  |

large_entity.id | fk_news_history_large_entity_1 C

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

large_entity.id | fk_news_history_large_entity_3 C

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

media.id | fk_news_history_image R

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

user_profile.id | FK_7n0m9sdowho7bahiaxnxl7ijx R

locked | datetime | 19 | √ |  | null |  |  |
region_id | int unsigned | 10 | √ |  | null |  |

region.id | FK_news_history_region R

recipient_id | int unsigned | 10 | √ |  | null |  |

user_profile.id | fk_news_history_recipient R

sub_topic_id | int unsigned | 10 |  |  |  |  |

topic.id | fk_news_history_topic_2 R

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

person.id | fk_news_history_person R

topic_id | int unsigned | 10 |  |  |  |  |

topic.id | fk_news_history_topic R

Table contained 578 rows at Wed Jan 20 16:28 IRST 2016

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
locker_id | Performance | Asc | FK_7n0m9sdowho7bahiaxnxl7ijx
body_html_id | Performance | Asc | fk_news_history_large_entity_1
body_plain_id | Performance | Asc | fk_news_history_large_entity_3
journalist_id | Performance | Asc | fk_news_history_person
region_id | Performance | Asc | FK_news_history_region
topic_id | Performance | Asc | fk_news_history_topic
sub_topic_id | Performance | Asc | fk_news_history_topic_2
news_id | Performance | Asc | fk_news_news_id_2
type_id | Performance | Asc | fk_news_type_id_2
recipient_id | Performance | Asc | FKF9409328379AB268
source_id | Performance | Asc | FKF940932866966A76
image_id | Performance | Asc | FKF940932867A28047
version + news_id | Must be unique | Asc/Asc | UK_kj8fso94hijtvcy89iketh7g

Close relationships within one two degrees of separation: