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

Table sahebkhabar.topic | 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.topic_id | FK178B06237393E R
news.sub_topic_id | fk_news_sub_topic R
news.topic_id | fk_news_topic R
news_history.sub_topic_id | fk_news_history_topic_2 R
news_history.topic_id | fk_news_history_topic R
news_place.sub_topic_id | FK_news_place_subtopic R
news_place.topic_id | FK_news_place_topic R
news_place_archive.sub_topic_id | FK_archive_news_place_subtopic R
news_place_archive.topic_id | FK_archive_news_place_topic R
news_subtopic.topic_id | FK_news_subtopic_topic R
place.topic_id | FK_place_topic R
poll.topic_id | fk_topic R
topic.parent_id | FK_topic_topic R

parent_id | int unsigned | 10 | √ |  | null |  |

topic.id | FK_topic_topic R

site_id | int unsigned | 10 | √ |  | null |  |  |
title | varchar | 50 |  |  |  |  |  |
full_title | varchar | 200 |  |  |  |  |  | full title in the form: parent > title
search_title | varchar | 200 |  |  |  |  |  |
priority | int unsigned | 10 | √ |  | null |  |  |
depth | tinyint unsigned | 3 |  |  | 1 |  |  | topic: 1, subtopic: 2, sub-subtopic: 3, etc.
url | varchar | 100 | √ |  | null |  |  |
meta_keyword | varchar | 300 | √ |  | null |  |  |
meta_des | varchar | 500 | √ |  | null |  |  |
keyword | varchar | 500 | √ |  | null |  |  | keyword meta in html page of this topic
description | varchar | 500 | √ |  | null |  |  | description meta in html page of this topic
visible | bit | 0 |  |  | 1 |  |  |
active | bit | 0 |  |  | 1 |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | PRIMARY |
parent_id | Performance | Asc | FK_topic_topic |
full_title + site_id | Must be unique | Asc/Asc | unq_topic_full_title |
url + site_id | Must be unique | Asc/Asc | unq_topic_url | These unique columns are also nullable

Close relationships within one two degrees of separation: