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

Table sahebkhabar.user_profile | 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_audit_log.user_id | FK_8yd4jgtdnd2x6waxx0w9hospr R
news.locker_id | fk_news_locker R
news.recipient_id | fk_news_recipient R
news_history.locker_id | FK_7n0m9sdowho7bahiaxnxl7ijx R
news_history.recipient_id | fk_news_history_recipient R
news_transition_log.from_user_id | FK_news_transition_log_user R
news_transition_log.to_user_id | FK_news_transition_log_user_2 R
user_role.user_id | FK143BF46AE3778376 R
user_site.user_id | fk_user-site_user_1 R

site_id | int unsigned | 10 | √ |  | null |  |  |
access_level | int unsigned | 10 | √ |  | null |  |  | 0:sysadmin,1:newsadmin
user_config_id | int unsigned | 10 | √ |  | null |  |

user_config.id | FK36EBCBBE740F4D R

topic_ids | varchar | 255 | √ |  | null |  |  |
region_ids | varchar | 1000 | √ |  | null |  |  | comma-separated list of region ids
username | varchar | 100 | √ |  | null |  |  |
password | varchar | 60 | √ |  | null |  |  |
national_code | varchar | 10 | √ |  | null |  |  |
salt | varchar | 30 | √ |  | null |  |  |
first_name | varchar | 25 | √ |  | null |  |  |
last_name | varchar | 25 | √ |  | null |  |  |
search_title | varchar | 100 | √ |  | null |  |  |
country | varchar | 25 | √ |  | null |  |  |
city | varchar | 25 | √ |  | null |  |  |
address | varchar | 150 | √ |  | null |  |  |
cell_number | varchar | 15 | √ |  | null |  |  |
phone_number | varchar | 15 | √ |  | null |  |  |
email | varchar | 50 | √ |  | null |  |  |
website | varchar | 50 | √ |  | null |  |  |
created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
modified | timestamp | 19 | √ |  | null |  |  |
creator | int unsigned | 10 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  |
active | bit | 0 |  |  | 1 |  |  |
avatar | int | 10 | √ |  | null |  |  |
password_expired | bit | 0 |  |  | 0 |  |  |
active_from | datetime | 19 | √ |  | null |  |  | account is non-expired from this datetime
active_to | datetime | 19 | √ |  | null |  |  | account is non-expired to this datetime
last_login_date | datetime | 19 | √ |  | null |  |  |
last_password_change | datetime | 19 | √ |  | null |  |  |
last_login_ip | varchar | 50 | √ |  | null |  |  |
failed_login_date | datetime | 19 | √ |  | null |  |  |
failed_login_count | int unsigned | 10 |  |  | 0 |  |  |
failed_login_ip | varchar | 50 | √ |  | null |  |  |
status | int unsigned | 10 | √ |  | null |  |  |
staus | int | 10 | √ |  | null |  |  |
config | varchar | 1000 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | PRIMARY |
user_config_id | Performance | Asc | FK36EBCBBE740F4D |
username | Must be unique | Asc | username | This unique column is also nullable
username + password | Performance | Asc/Asc | username_password |

Close relationships within one two degrees of separation: