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

Table sahebkhabar.site | 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.site_id | fk_news_site R
poll.site_id | ft_site R
site.master_site_id | fk_site_master R
site_domain.site_id | fk_site_domain_site_id R

lang_code | char | 5 |  |  |  |  |  |
title | varchar | 50 |  |  |  |  |  |
slogon | varchar | 150 | √ |  | null |  |  |
url | varchar | 100 | √ |  | null |  |  | e.g. http://sahebkhabar.ir with protocol and no ending slash
media_url | varchar | 100 |  |  |  |  |  | base url address for media
flags | bigint | 19 | √ |  | null |  |  | site boolean flags
master_site_id | int unsigned | 10 | √ |  | null |  |

site.id | fk_site_master R

maste site of this site
page_title | varchar | 100 | √ |  | null |  |  |
home_page_title | varchar | 100 | √ |  | null |  |  |
lang_direction | char | 3 |  |  |  |  |  |
copyright_clause | varchar | 1000 | √ |  | null |  |  |
meta_copyright | varchar | 250 | √ |  | null |  |  |
info_email | varchar | 100 | √ |  | null |  |  |
sender_email | varchar | 100 | √ |  | null |  |  |
limit_news_days | int | 10 | √ |  | null |  |  |
limit_start_date | datetime | 19 | √ |  | null |  |  |
email_username | varchar | 100 | √ |  | null |  |  |
email_password | varchar | 100 | √ |  | null |  |  |
imap_server | varchar | 100 | √ |  | null |  |  |
meta_keyword | varchar | 300 | √ |  | null |  |  |
meta_des | varchar | 500 | √ |  | null |  |  |
meta_frontpage | varchar | 500 | √ |  | null |  |  |
google_meta_verification | varchar | 200 | √ |  | null |  |  |
alexa_meta_verification | varchar | 200 | √ |  | null |  |  |
google_analytic_js | varchar | 1000 | √ |  | null |  |  |
theme_folder | varchar | 20 | √ |  | null |  |  |
data_folder | varchar | 100 | √ |  | null |  |  |
db_connection_string | varchar | 150 | √ |  | null |  |  |
path_seperator | char | 1 | √ |  | null |  |  |
active | bit | 0 |  |  | 1 |  |  |
has_subscription | bit | 0 | √ |  | null |  |  |
topic_top1_id | int | 10 | √ |  | null |  |  |
topic_top2_id | int | 10 | √ |  | null |  |  |
site_id | smallint unsigned | 5 | √ |  | null |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
max_headline_chars | int unsigned | 10 | √ |  | null |  |  |
max_lead_chars | int unsigned | 10 | √ |  | null |  |  |
max_body_chars | int unsigned | 10 | √ |  | 25000 |  |  |
max_kicker_chars | int unsigned | 10 | √ |  | null |  |  |
max_short_headline_chars | int unsigned | 10 | √ |  | null |  |  |
mandatory_short_headline | int unsigned | 10 | √ |  | 0 |  |  | 0 means optional. Greater than zero means at least that number of characters are required.
mandatory_headline | int unsigned | 10 | √ |  | 1 |  |  | 0 means optional. Greater than zero means at least that number of characters are required.
mandatory_lead | int unsigned | 10 | √ |  | 0 |  |  | 0 means optional. Greater than zero means at least that number of characters are required.
mandatory_body | int unsigned | 10 | √ |  | 0 |  |  | 0 means optional. Greater than zero means at least that number of characters are required.
mandatory_keyword | int unsigned | 10 | √ |  | 0 |  |  | 0 means optional. Greater than zero means at least that number of keywords are required.
mandatory_source | bit | 0 | √ |  | 0 |  |  |
mandatory_journalist | bit | 0 | √ |  | 0 |  |  |
mandatory_region | bit | 0 | √ |  | 0 |  |  |
use_news_id_in_url | bit | 0 | √ |  | 1 |  |  | Use newsId in makeUrl
use_search_for_keyword_index | bit | 0 | √ |  | 0 |  |  |
render_news_source | bit | 0 | √ |  | 0 |  |  |
backlink_phrase_list | varchar | 1000 | √ |  | null |  |  |
backlink_phrase_url | varchar | 100 | √ |  | null |  |  |
about_us_news_id | int | 10 | √ |  | null |  |  |
contact_us_news_id | int | 10 | √ |  | null |  |  |
links_news_id | int | 10 | √ |  | null |  |  |
ads_news_id | int | 10 | √ |  | null |  |  |
password_expire_days | int unsigned | 10 | √ |  | 0 |  |  |
permissions | varchar | 200 | √ |  | null |  |  | comma separated list of permissions enabled on this website
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
master_site_id | Performance | Asc | fk_site_master

Close relationships within one two degrees of separation: