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

Table sahebkhabar.media | 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.flash_media_id | FK_ads_media_flash R
ads.image_media_id | FK_ads_media_image R
entity_tag.media_id | FKA7A0293E652E411E R
media_keyword.media_id | FK_fwjt2wyfe2g7qc8v6oc10kq17 R
news.image2_id | fk_news_media2 R
news.image_id | fk_news_image R
news_history.image_id | fk_news_history_image R
news_media.media_id | FK2BF2B378652E411E C
product.icon_id | fk_product_icon R
product.image_id | fk_product_image R
product_category.icon_id | fk_prodcat_icon R

type | int unsigned | 10 |  |  |  |  |  | 0:other, 1:photo ,2:audio ,3:video ,4:flash, 5:document
site_id | int unsigned | 10 | √ |  | null |  |  |
photographer_id | int unsigned | 10 | √ |  | null |  |

person.id | FK_media_person R

title | varchar | 255 | √ |  | null |  |  |
search_title | varchar | 255 | √ |  | null |  |  |
des | varchar | 1000 | √ |  | null |  |  |
repos | tinyint unsigned | 3 | √ |  | 1 |  |  | repository version, 0: old, 1 or null is current
entity | int unsigned | 10 |  |  | 1 |  |  | 1: news, 2: ads, 3: person
original_filename | varchar | 255 |  |  |  |  |  |
original_size | int unsigned | 10 | √ |  | null |  |  |
original_format | varchar | 5 |  |  |  |  |  |
original_width | int unsigned | 10 | √ |  | null |  |  | in pixels
original_height | int unsigned | 10 | √ |  | null |  |  | in pixels
original_bitrate | int unsigned | 10 | √ |  | null |  |  | kbps
duration | int unsigned | 10 | √ |  | null |  |  | ms
owner | varchar | 50 | √ |  | null |  |  | interviewer, camera man, author, etc.
personals | varchar | 250 | √ |  | null |  |  |
places | varchar | 250 | √ |  | null |  |  |
active | bit | 0 | √ |  | 1 |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
deleted | bit | 0 | √ |  | null |  |  |

Table contained 4,909 rows at Wed Jan 20 16:28 IRST 2016

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
photographer_id | Performance | Asc | FK_media_person
type | Performance | Asc | type

Close relationships within one two degrees of separation: