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

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

news.id | FK2C201C9B5A42C676 C

place_id | int unsigned | 10 |  |  |  |  |

place.id | FK2C201C9B9D98A3E R

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

topic.id | FK_news_place_topic R

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

topic.id | FK_news_place_subtopic R

priority | int | 10 | √ |  | null |  |  |
active | bit | 0 | √ |  | 1 |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
site_id | smallint | 5 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
news_id | Performance | Asc | FK2C201C9B5A42C676
place_id | Performance | Asc | FK2C201C9B9D98A3E
sub_topic_id | Performance | Asc | FK_news_place_subtopic
topic_id | Performance | Asc | FK_news_place_topic
news_id | Performance | Asc | Idx_news_id
place_id | Performance | Asc | Idx_place_id
news_id + place_id + priority + created | Performance | Asc/Asc/Asc/Asc | priority
news_id + place_id + sub_topic_id | Must be unique | Asc/Asc/Asc | uk_news_place_subtopic
place_id + news_id + sub_topic_id | Must be unique | Asc/Asc/Asc | uk_place_news_topic

Close relationships within one two degrees of separation: