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

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

poll_option.poll_id | FK_poll_option_poll R
vote.poll_id | fk_poll R

title | varchar | 100 |  |  |  |  |  |
question | varchar | 1000 |  |  |  |  |  |
language | varchar | 2 |  |  |  |  |  |
priority | int unsigned | 10 |  |  | 0 |  |  |
type | int unsigned | 10 | √ |  | 0 |  |  | for future use, e.g. multi-select polls
visible | tinyint unsigned | 3 |  |  |  |  |  |
active | tinyint unsigned | 3 |  |  |  |  |  |
start_date | datetime | 19 |  |  |  |  |  |
end_date | datetime | 19 |  |  |  |  |  |
place_id | int unsigned | 10 |  |  |  |  |

place.id | fk_place R

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

topic.id | fk_topic R

site_id | int unsigned | 10 |  |  |  |  |

site.id | ft_site R

creator | int unsigned | 10 |  |  |  |  |  |
created | datetime | 19 |  |  |  |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
modified | datetime | 19 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
place_id | Performance | Asc | fk_place
topic_id | Performance | Asc | fk_topic
site_id | Performance | Asc | ft_site

Close relationships within one two degrees of separation: