SchemaSpy Analysis of tariqa3 Generated by
SchemaSpy
Generated by SchemaSpy on Wed Apr 25 13:30 CEST 2012
Database Type: MySQL - 5.5.16 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
ajax_call_urls 1 14
ajax_calls 1 1 3
app_log 1 1 4
app_log_accessedarticlespertype 2
app_log_countriesperday 6
app_log_d 6
app_log_datehitsperuser 3
app_log_datestats 4
app_log_details 1 6
app_log_dt 5
app_log_enginefullactivity 10
app_log_enginesaccesstotal 2
app_log_enginesarticlesaccesstotal 2
app_log_enginesperday 5
app_log_enginesperhour 6
app_log_individualusersperday 1
app_log_pagesaccessperday 5
app_log_pagesaccessperhour 6
app_log_pagesaccesspermonth 4
app_log_pagesaccessperuser 3
app_log_pagesaccessperweekday 3
app_log_pagesaccessperyear 3
app_log_pagesaccesstotal 2
app_log_pageslist 1
app_log_realusage 10
app_log_themesperday 6
app_log_totalnumberofcountrypagesaccess 2
app_log_unvoluntarysearches 10
app_log_usageofbriefcase 4
app_log_usageofexport 3
app_log_usageoffiltering 2
app_log_usageoffiltering_inner 2
app_log_usageofpreferencespage 2
app_log_usageofsharing 3
app_log_useractions 2
app_log_userhitsperdate 3
app_log_userslist 1
app_log_userspages_crossstatistics 3
app_log_usersperday 5
app_log_usersperhour 6
app_log_userstats 4
app_log_userstotal 4
app_log_voluntaryarticles 10
app_log_voluntarysearches 10
app_log_voluntarysearchesandarticles 10
briefcase_content 1 3 11 The briefcase content
briefcase_content_backup 11 The briefcase content backup
briefcase_contents_types 2 3 The list of type contents from the briefcase
briefcase_folder_rss 1 1 3
briefcase_folder_rss_users 2 2
briefcase_folders 3 2 8 The briefcase folders
briefcase_templates 1 4
contact_lists 1 1 3
contact_lists_details 1 3
external_articles 3
known_users 8 10
languages 1 7 List of languages (iso 639-2/b)
languages_sections 1 2 Sections of the translation mechanism
rss_log 1 6 Log the access to the tariqa RSS feeds
translation 2 1 3 Keys of the translation mechanism
translation_values 3 4 Translated texts for each key
user_articles 1 4
user_preferences 1 3
         
22 Tables     117  
41 Views     181