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

Table sahebkhabar.ads | 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 | mediumint | 7 |  | √ |  |  |  |
image_media_id | int unsigned | 10 | √ |  | null |  |

media.id | FK_ads_media_image R

flash_media_id | int unsigned | 10 | √ |  | null |  |

media.id | FK_ads_media_flash R

topic_id | int unsigned | 10 | √ |  | null |  |

topic.id | FK178B06237393E R

title | varchar | 255 |  |  |  |  |  |
customer | varchar | 255 | √ |  | null |  |  |
start_date | timestamp | 19 | √ |  | null |  |  |
end_date | timestamp | 19 | √ |  | null |  |  |
click_count | int unsigned | 10 | √ |  | null |  |  |
url | varchar | 255 |  |  |  |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
site_id | int unsigned | 10 | √ |  | null |  |  |
active | bit | 0 |  |  | 1 |  |  |
visible | bit | 0 |  |  | 1 |  |  |
created | timestamp | 19 | √ |  | null |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
last_click | datetime | 19 | √ |  | null |  |  |
last_view | datetime | 19 | √ |  | null |  |  |
max_click | int | 10 | √ |  | null |  |  |
max_view | int | 10 | √ |  | null |  |  |
priority | int | 10 |  |  |  |  |  |
view_count | int | 10 | √ |  | null |  |  |
place_id | int unsigned | 10 |  |  |  |  |

place.id | FK_ads_place R

aspect_ratio | float | 12 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
topic_id | Performance | Asc | FK178B06237393E
image_media_id | Performance | Asc | FK_ads_media
flash_media_id | Performance | Asc | FK_ads_media_flash
place_id | Performance | Asc | FK_ads_place

Close relationships within one two degrees of separation: