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

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

keyword.parent_id | FK_keyword_keyword R
keyword.preferred_id | fk_keyword_preferred R
media_keyword.keyword_id | FK_bdgw368dhxfhor560wbmnt19b R
news_keyword.keyword_id | fk_news_keyword_keyword_1 C

site_id | int unsigned | 10 |  |  | 1 |  |  |
title | varchar | 100 |  |  |  |  |  |
full_title | varchar | 255 |  |  |  |  |  | full title in the form: parent > title
search_title | varchar | 100 |  |  |  |  |  |
parent_id | int unsigned | 10 | √ |  | null |  |

keyword.id | FK_keyword_keyword R

parent keyword (for multi-level keyword support)
preferred_id | int unsigned | 10 | √ |  | null |  |

keyword.id | fk_keyword_preferred R

preferred keyword
synonym | varchar | 500 | √ |  | null |  |  |
created | timestamp | 19 | √ |  | null |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
active | bit | 0 |  |  | 1 |  |  |
visible | bit | 0 |  |  | 1 |  |  |

Table contained 3,122 rows at Wed Jan 20 16:28 IRST 2016

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
parent_id | Performance | Asc | FK_keyword_keyword
preferred_id | Performance | Asc | fk_keyword_preferred
site_id + title + parent_id | Must be unique | Asc/Asc/Asc | site_id_title_parent_id
site_id + parent_id + title | Must be unique | Asc/Asc/Asc | UK_2vq94ydrbhq24rhyeui2oe4x8

Close relationships within one two degrees of separation: