Table tariqa3.known_users Generated by
SchemaSpy
Legend: SourceForge.net
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
user_id varchar 16
ajax_calls.user_id FK_ajax_calls_users C
app_log.user_id app_log_ibfk_1 N
app_log_d.user_id Implied Constraint R
app_log_dt.user_id Implied Constraint R
app_log_enginefullactivity.user_id Implied Constraint R
app_log_individualusersperday.user_id Implied Constraint R
app_log_realusage.user_id Implied Constraint R
app_log_unvoluntarysearches.user_id Implied Constraint R
app_log_useractions.user_id Implied Constraint R
app_log_userslist.user_id Implied Constraint R
app_log_voluntaryarticles.user_id Implied Constraint R
app_log_voluntarysearches.user_id Implied Constraint R
app_log_voluntarysearchesandarticles.user_id Implied Constraint R
briefcase_content.user_id FK_briefcase_content_users C
briefcase_content_backup.user_id Implied Constraint R
briefcase_folder_rss_users.user_id fk_briefcase_folder_rss_to_users R
briefcase_folders.user_id Implied Constraint R
briefcase_templates.user_id briefcase_templates_ibfk_1 R
contact_lists.user_id contact_lists_ibfk_1 R
rss_log.user_id Implied Constraint R
user_articles.user_id FK_user_articles_users C
user_preferences.user_id fk_user_preferences_known_users R
first_access datetime 19  √  null
functional_mailbox varchar 255  √  null
is_ecas enum 2  √  y
first_name varchar 255  √  null
last_name varchar 255  √  null
e_mail varchar 255  √  null
password varchar 32  √  null
login_attempt int 10  √  0
groups varchar 255  √  null

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc PRIMARY

Close relationships  within of separation: