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

Table sahebkhabar.news_log | 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 |  | √ |  |  |  |
view_count | int unsigned | 10 |  |  | 0 |  |  |
positive | int unsigned | 10 |  |  | 0 |  |  |
negative | int unsigned | 10 |  |  | 0 |  |  |
like_count | int unsigned | 10 |  |  | 0 |  |  |
news_id | int unsigned | 10 |  |  | 0 |  |

news.id | FK_news_log_news C

comment_count | int unsigned | 10 |  |  | 0 |  |  |
pub_comment_count | int unsigned | 10 |  |  | 0 |  |  |
data | varchar | 1000 | √ |  | null |  |  |
last_view | datetime | 19 | √ |  | null |  |  |
last_comment | datetime | 19 | √ |  | null |  |  |
last_publish_date | datetime | 19 | √ |  | null |  |  | When news is published, unpublished, and then published again this field holds the last publish date.
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |

Table contained 7,520 rows at Wed Jan 20 16:28 IRST 2016

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
comment_count | Performance | Asc | comment_count
news_id | Performance | Asc | FK_news_log_news
news_id | Must be unique | Asc | news_id
news_id | Must be unique | Asc | UK_j3m21xv080vi5afyx06b2gjb7
view_count | Performance | Asc | view_count

Close relationships within one two degrees of separation: