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

Table sahebkhabar.source | 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 | mediumint unsigned | 8 |  | √ |  |

news.source_id | fk_news_source R
news_history.source_id | fk_news_history_source R

title | varchar | 100 |  |  |  |  |  |
search_title | varchar | 100 |  |  |  |  |  |
code | varchar | 30 |  |  |  |  |  |
authority | varchar | 100 | √ |  | null |  |  |
flags | int unsigned | 10 |  |  |  |  |  |
site_id | int unsigned | 10 | √ |  | null |  |  |
active | bit | 0 | √ |  | null |  |  |
visible | bit | 0 | √ |  | 1 |  |  |
priority | int unsigned | 10 | √ |  | null |  |  | used for ordering
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
code + site_id | Must be unique | Asc/Asc | code
title + site_id | Must be unique | Asc/Asc | title
code + site_id | Must be unique | Asc/Asc | UK_3vn98w64b71capgwhf8bpoabk

Close relationships within one two degrees of separation: