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

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

product_price_log.product_id | fk_prodpricelog_product R

active | bit | 1 |  |  |  |  |  |
created | datetime | 19 |  |  |  |  |  |
creator | int unsigned | 10 |  |  |  |  |  |
modified | datetime | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
priority | int unsigned | 10 |  |  |  |  |  |
site_id | int unsigned | 10 | √ |  | null |  |  |
search_title | varchar | 100 | √ |  | null |  |  |
description | varchar | 1000 | √ |  | null |  |  |
price | float | 12 |  |  |  |  |  |
price_max | float | 12 |  |  |  |  |  |
price_min | float | 12 |  |  |  |  |  |
currency | varchar | 3 |  |  |  |  |  |
title | varchar | 200 |  |  |  |  |  |
visible | bit | 1 |  |  |  |  |  |
category_id | int unsigned | 10 |  |  |  |  |

product_category.id | fk_product_category R

icon_id | int unsigned | 10 | √ |  | null |  |

media.id | fk_product_icon R

image_id | int unsigned | 10 | √ |  | null |  |

media.id | fk_product_image R

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
category_id | Performance | Asc | fk_product_category
icon_id | Performance | Asc | fk_product_icon
image_id | Performance | Asc | fk_product_image

Close relationships within one two degrees of separation: