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

Table sahebkhabar.place | 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 |  | √ |  |

ads.place_id | FK_ads_place R
news_place.place_id | FK2C201C9B9D98A3E R
news_place_archive.place_id | FKADABD91E9D98A3E R
newsletter.place_id | FK_newsletter_place R
place.archive_place_id | FK_place_place R
poll.place_id | fk_place R

code | varchar | 50 | √ |  | null |  |  |
site_id | int unsigned | 10 | √ |  | null |  |  |
auto_fill | bit | 0 |  |  | 0 |  |  |
is_main | bit | 0 |  |  | 0 |  |  |
archive_place_id | int unsigned | 10 | √ |  | null |  |

place.id | FK_place_place R

topic_id | int unsigned | 10 | √ |  | null |  |

topic.id | FK_place_topic R

news_type_id | int unsigned | 10 | √ |  | null |  |

news_type.id | FK_place_news_type R

subject_id | int unsigned | 10 | √ |  | null |  |

news.id | FK_place_news R

subject/package/portal/parvandeh
title | varchar | 150 |  |  |  |  |  |
box_title | varchar | 150 | √ |  | null |  |  |
priority | int unsigned | 10 | √ |  | null |  |  |
news_count | int unsigned | 10 |  |  | 1 |  |  |
active | bit | 0 |  |  | 1 |  |  |
visible | bit | 0 |  |  | 1 |  |  |
news_age | int unsigned | 10 | √ |  | 7 |  |  | Maximum new age in day
start_date | datetime | 19 | √ |  | null |  |  |
end_date | datetime | 19 | √ |  | null |  |  |
filter_topic | varchar | 100 | √ |  | null |  |  |
filter_source | varchar | 500 | √ |  | null |  |  |
filter_news_type | varchar | 50 | √ |  | null |  |  |
html_container_id | varchar | 150 | √ |  | null |  |  |
theme | varchar | 255 | √ |  | null |  |  |
tab_group | varchar | 30 | √ |  | null |  |  |
news_age_unit | smallint unsigned | 5 |  |  | 3 |  |  | {1: MINUTE, 2: HOUR, 3: DAY}
module_path | varchar | 2000 | √ |  | null |  |  |
link | varchar | 500 | √ |  | null |  |  | box custom link
has_related_news | tinyint unsigned | 3 | √ |  | null |  |  |
has_related_image | bit | 0 | √ |  | 0 |  |  |
use_related_image2 | bit | 0 | √ |  | 0 |  |  |
related_news_count | int unsigned | 10 | √ |  | null |  |  |
relation_type | varchar | 50 | √ |  | null |  |  | comma-separated relation type
box_bg_color | char | 7 | √ |  | null |  |  |
header_bg_color | char | 7 | √ |  | null |  |  |
box_shadow | varchar | 50 | √ |  | null |  |  |
allow_ips | varchar | 500 | √ |  | null |  |  |
deny_ips | varchar | 500 | √ |  | null |  |  |
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.
query | varchar | 500 | √ |  | null |  |  |
sort_field | int | 10 | √ |  | null |  |  |
keywords | varchar | 50 | √ |  | null |  |  | cvs list of keyword ids
any_keyword | tinyint unsigned | 3 | √ |  | null |  |  | true: or between keyword ids, false: and between keyword ids
title_limit | int unsigned | 10 | √ |  | null |  |  |
lead_limit | int unsigned | 10 | √ |  | null |  |  |
type | int unsigned | 10 |  |  | 1 |  |  | 1:User Defined,2:Last News,3: Most Visited,4:Mos Commented, 5: Most mailed,6: Ads
topic_filter | bit | 0 | √ |  | 0 |  |  | if true,contents filtered by topic_id which request from query string of the page.
topic_filter_depth | bit | 0 | √ |  | 1 |  |  | if topic_filter is true, it should be filtered by topics of this depth
show_in_topic | varchar | 255 | √ |  | null |  |  | comma-separated topic id list
subject_filter | bit | 0 | √ |  | 0 |  |  | if true, joins news box with current subject (if any)
has_image | bit | 0 | √ |  | 0 |  |  |
use_image2 | bit | 0 | √ |  | 0 |  |  |
image_size | int | 10 | √ |  | null |  |  | 1 to 5
has_lead | bit | 0 | √ |  | 0 |  |  |
cross_site | bit | 0 | √ |  | 0 |  |  | 0 or null: site-specific, 1: cross-site.
creator | int unsigned | 10 |  |  |  |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
carousel_items | int unsigned | 10 | √ |  | null |  |  |
has_carousel | bit | 0 | √ |  | null |  |  |
carousel_autostart | bit | 0 | √ |  | null |  |  |
carousel_delay | int unsigned | 10 | √ |  | null |  |  |
carousel_item | int unsigned | 10 | √ |  | null |  |  |
carousel_paging | bit | 0 | √ |  | null |  |  |
carousel_control | bit | 0 | √ |  | null |  |  |
has_titr1 | bit | 0 | √ |  | 0 |  |  |
has_kicker | bit | 0 | √ |  | null |  |  |
has_subhead | bit | 0 | √ |  | null |  |  |
has_publish_date | tinyint unsigned | 3 | √ |  | null |  |  |
publish_date_format | varchar | 20 | √ |  | null |  |  |
has_short_headline | bit | 0 | √ |  | 1 |  |  |
has_source | bit | 0 | √ |  | 0 |  |  |
has_journalist | bit | 0 | √ |  | 0 |  |  |
has_player | bit | 0 | √ |  | 0 |  |  |
has_comment | bit | 0 | √ |  | 0 |  |  |
comment_count | int unsigned | 10 | √ |  | null |  |  |
has_archive | bit | 0 | √ |  | 1 |  |  |
mosaic_archive | int unsigned | 10 | √ |  | null |  |  |
has_feed | bit | 0 | √ |  | 0 |  |  |
has_telegram | bit | 0 | √ |  | 0 |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
subject_id | Performance | Asc | FK_place_news
news_type_id | Performance | Asc | FK_place_news_type
archive_place_id | Performance | Asc | FK_place_place
topic_id | Performance | Asc | FK_place_topic

Close relationships within one two degrees of separation: