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

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

entity_tag.person_id | FKA7A0293EF8FFE836 R
media.photographer_id | FK_media_person R
news.journalist_id | fk_news_person R
news_history.journalist_id | fk_news_history_person R

code | varchar | 50 | √ |  | null |  |  |
gender | tinyint unsigned | 3 | √ |  | null |  |  |
first_name | varchar | 50 | √ |  | null |  |  |
last_name | varchar | 50 |  |  |  |  |  |
prefix_name | varchar | 50 | √ |  | null |  |  |
print_name | varchar | 100 | √ |  | null |  |  |
search_title | varchar | 100 | √ |  | null |  |  |
journalist | bit | 0 | √ |  | null |  |  | is this person a journalist
photographer | bit | 0 | √ |  | null |  |  | is this person a photographer
initial | int unsigned | 10 | √ |  | null |  |  |
job_title | varchar | 75 | √ |  | null |  |  |
b_date | varchar | 10 | √ |  | null |  |  | Maybe contains just year number so its ENGINE is not datetime .
biography | varchar | 4000 | √ |  | null |  |  |
email | varchar | 100 | √ |  | null |  |  |
website | varchar | 150 | √ |  | null |  |  |
cell_phone | varchar | 100 | √ |  | null |  |  |
site_id | int unsigned | 10 | √ |  | null |  |  |
active | bit | 0 | √ |  | 1 |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | PRIMARY |
code | Must be unique | Asc | code | This unique column is also nullable

Close relationships within one two degrees of separation: