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

Table sahebkhabar.news_comment | 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_comment.parent_id | FK_news_comment_news_comment R

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

news_comment.id | FK_news_comment_news_comment R

news_id | int unsigned | 10 |  |  |  |  |

news.id | FK_io1bbopmg4bder9jfwk52ubk9 R

site_id | int unsigned | 10 |  |  |  |  |  |
creator | int unsigned | 10 | √ |  | null |  |  | publisher
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
session_id | varchar | 60 | √ |  | null |  |  |
user_ip | varchar | 60 |  |  |  |  |  |
user_email | varchar | 200 | √ |  | null |  |  |
user_name | varchar | 100 | √ |  | null |  |  |
show_email | bit | 0 | √ |  | null |  |  |
body | text | 65535 | √ |  | null |  |  |
is_read | bit | 0 | √ |  | 0 |  |  |
published | bit | 0 | √ |  | 0 |  |  |
reply_body | varchar | 500 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  | reply_user_id
modified | timestamp | 19 | √ |  | null |  |  | reply_date
edited_body | text | 65535 | √ |  | null |  |  |
edited_username | varchar | 30 | √ |  | null |  |  |
positive | int unsigned | 10 | √ |  | null |  |  |
negative | int unsigned | 10 | √ |  | null |  |  |
like_count | int unsigned | 10 | √ |  | null |  |  |
active | bit | 0 | √ |  | null |  |  |
country_code | char | 2 | √ |  | null |  |  |

Table contained 30 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 | FK_news_comment_news
parent_id | Performance | Asc | FK_news_comment_news_comment

Close relationships within one two degrees of separation: