SchemaSpy Analysis of tariqa3 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Apr 25 13:30 CEST 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

tariqa3 contains 298 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
app_log_enginesaccesstotal Accessed bigint 19 0
app_log_enginesperday Accessed bigint 19 0
app_log_enginesperhour Accessed bigint 19 0
app_log_pagesaccessperday Accessed bigint 19 0
app_log_pagesaccessperhour Accessed bigint 19 0
app_log_pagesaccesspermonth Accessed bigint 19 0
app_log_pagesaccessperuser Accessed bigint 19 0
app_log_pagesaccessperweekday Accessed bigint 19 0
app_log_pagesaccessperyear Accessed bigint 19 0
app_log_pagesaccesstotal Accessed bigint 19 0
app_log_totalnumberofcountrypagesaccess Accessed bigint 19 0
app_log_usersperday Accessed pages bigint 19 0
app_log_usersperhour Accessed pages bigint 19 0
app_log_useractions c bigint 19 0
app_log_accessedarticlespertype Count bigint 19 0
app_log_enginesarticlesaccesstotal Count bigint 19 0
app_log_usageofbriefcase Count bigint 19 0
app_log_usageofexport Count bigint 19 0
app_log_usageofpreferencespage Count bigint 19 0
app_log_usageofsharing Count bigint 19 0
app_log_userstats Days bigint 19 0
app_log_usersperday Distinct users bigint 19 0
app_log_usersperhour Distinct users bigint 19 0
app_log_datehitsperuser Hits bigint 19 0
app_log_userhitsperdate Hits bigint 19 0
app_log_userspages_crossstatistics Hits bigint 19 0
app_log_countriesperday No accesses bigint 19 0
app_log_themesperday No accesses bigint 19 0
app_log_userstotal Total bigint 19 0
app_log_datestats Users bigint 19 0
briefcase_content name blob 65535 The content name
briefcase_content_backup name blob 65535 The content name
ajax_calls call_time datetime 19  √  null Date/time at which the call was issued
rss_log date datetime 19
known_users first_access datetime 19  √  null
ajax_call_urls last_update datetime 19  √  null Date/time at which the URL process was ended
app_log_datestats HitAverage decimal 24,4  √  null
app_log_userstats HitAverage decimal 24,4  √  null
app_log_datestats TotalHits decimal 42  √  null
app_log_userstats TotalHits decimal 42  √  null
briefcase_folders archived enum 2  √  n
known_users is_ecas enum 2  √  y
ajax_call_urls method enum 4 get Only GET is implemented at the moment
app_log_details type enum 4  √  get
app_log_enginefullactivity type enum 4  √  get
app_log_realusage type enum 4  √  get
app_log_unvoluntarysearches type enum 4  √  get
app_log_voluntaryarticles type enum 4  √  get
app_log_voluntarysearches type enum 4  √  get
app_log_voluntarysearchesandarticles type enum 4  √  get
ajax_call_urls use_proxy enum 4 no If set to yes, uses the HTTP Proxy
ajax_call_urls duration float 12  √  null Duration in seconds of the download
external_articles article_id int 10  √ 
app_log_countriesperday Day int 10  √  null
app_log_d Day int 10  √  null
app_log_enginesperday Day int 10  √  null
app_log_enginesperhour Day int 10  √  null
app_log_pagesaccessperday Day int 10  √  null
app_log_pagesaccessperhour Day int 10  √  null
app_log_themesperday Day int 10  √  null
app_log_usersperday Day int 10  √  null
app_log_usersperhour Day int 10  √  null
app_log_pagesaccessperweekday Day of week int 10  √  null
app_log_details detail_id int 10  √ 
briefcase_content display_order int 10 0
briefcase_content_backup display_order int 10 0
app_log_enginesperhour Hour int 10  √  null
app_log_pagesaccessperhour Hour int 10  √  null
app_log_usersperhour Hour int 10  √  null
contact_lists list_id int 10  √ 
contact_lists_details list_id int 10
app_log log_id int 10  √ 
app_log_d log_id int 10 0
app_log_details log_id int 10
app_log_dt log_id int 10 0
app_log_enginefullactivity log_id int 10 0
app_log_realusage log_id int 10 0
app_log_unvoluntarysearches log_id int 10 0
app_log_usageoffiltering_inner log_id int 10
app_log_voluntaryarticles log_id int 10 0
app_log_voluntarysearches log_id int 10 0
app_log_voluntarysearchesandarticles log_id int 10 0
rss_log log_id int 10  √ 
known_users login_attempt int 10  √  0
app_log_countriesperday Month int 10  √  null
app_log_d Month int 10  √  null
app_log_enginesperday Month int 10  √  null
app_log_enginesperhour Month int 10  √  null
app_log_pagesaccessperday Month int 10  √  null
app_log_pagesaccessperhour Month int 10  √  null
app_log_pagesaccesspermonth Month int 10  √  null
app_log_themesperday Month int 10  √  null
app_log_usersperday Month int 10  √  null
app_log_usersperhour Month int 10  √  null
rss_log source_id int 10  √  null
briefcase_templates template_id int 10  √ 
app_log_countriesperday Year int 10  √  null
app_log_d Year int 10  √  null
app_log_enginesperday Year int 10  √  null
app_log_enginesperhour Year int 10  √  null
app_log_pagesaccessperday Year int 10  √  null
app_log_pagesaccessperhour Year int 10  √  null
app_log_pagesaccesspermonth Year int 10  √  null
app_log_pagesaccessperyear Year int 10  √  null
app_log_themesperday Year int 10  √  null
app_log_usersperday Year int 10  √  null
app_log_usersperhour Year int 10  √  null
user_articles assoc_id int unsigned 10  √ 
ajax_call_urls call_content_length int unsigned 10  √  null Length of the data
ajax_call_urls call_id int unsigned 10 Id of the Ajax Call
ajax_calls call_id int unsigned 10  √  Id of the Ajax Call
briefcase_content content_id int unsigned 10  √  The content identifier
briefcase_content_backup content_id int unsigned 10 The content identifier
rss_log content_id int unsigned 10  √  null
briefcase_content folder_id int unsigned 10  √  null The content folder
briefcase_content_backup folder_id int unsigned 10  √  null The content folder
briefcase_folder_rss folder_id int unsigned 10
briefcase_folder_rss_users folder_id int unsigned 10
briefcase_folders folder_id int unsigned 10  √  The folder identifier
briefcase_content length int unsigned 10  √  null The content length or NULL
briefcase_content_backup length int unsigned 10  √  null The content length or NULL
briefcase_folders parent_id int unsigned 10  √  null The parent identifier
briefcase_content type_id int unsigned 10 The content type
briefcase_content_backup type_id int unsigned 10 The content type
briefcase_contents_types type_id int unsigned 10  √  The type identifier
briefcase_folders type_id int unsigned 10  √  null The type identifier
ajax_call_urls call_content longblob 2147483647  √  null Data returned by the URL
external_articles content longblob 2147483647  √  null
briefcase_content data longblob 2147483647  √  null The content data
briefcase_content_backup data longblob 2147483647  √  null The content data
ajax_call_urls post_fields longtext 2147483647  √  null the full data to post in an HTTP POST operation. You must make sure that the data is formatted the way you want the server to receive it
ajax_call_urls http_code smallint unsigned 5  √  null HTTP return code once the URL has been retrieved
ajax_call_urls url_id smallint unsigned 5 Id of the URL in the current multi-call
app_log_usageofbriefcase Action text 65535  √  null
ajax_call_urls call_error text 65535  √  null Error data or NULL
ajax_call_urls call_header text 65535  √  null HTTP Header of the document at the given URL
translation_values data text 65535  √  null
user_preferences data text 65535  √  null
briefcase_content description text 65535  √  null The content descirption
briefcase_content_backup description text 65535  √  null The content descirption
briefcase_contents_types description text 65535  √  null The type description
briefcase_folders description text 65535  √  null The folder description
languages_sections description text 65535  √  null
translation description text 65535  √  null
app_log_pagesaccessperday Page text 65535  √  null
app_log_pagesaccessperhour Page text 65535  √  null
app_log_pagesaccesspermonth Page text 65535  √  null
app_log_pagesaccessperuser Page text 65535  √  null
app_log_pagesaccessperweekday Page text 65535  √  null
app_log_pagesaccessperyear Page text 65535  √  null
app_log_pagesaccesstotal Page text 65535  √  null
app_log_pageslist page text 65535  √  null
app_log_userspages_crossstatistics Page text 65535  √  null
briefcase_templates path text 65535
app_log_usageoffiltering Query text 65535  √  null
briefcase_folder_rss title text 65535  √  null
app_log_usageofexport Type text 65535  √  null
app_log_usageofsharing Type text 65535  √  null
app_log url text 65535
app_log_d url text 65535
app_log_dt url text 65535
app_log_details value text 65535  √  null
app_log_enginefullactivity value text 65535  √  null
app_log_realusage value text 65535  √  null
app_log_unvoluntarysearches value text 65535  √  null
app_log_usageoffiltering_inner value text 65535  √  null
app_log_voluntaryarticles value text 65535  √  null
app_log_voluntarysearches value text 65535  √  null
app_log_voluntarysearchesandarticles value text 65535  √  null
app_log_userstotal First access timestamp 19  √  null
app_log_userstotal Last Access timestamp 19  √  null
app_log time timestamp 19 CURRENT_TIMESTAMP
app_log_details time timestamp 19 CURRENT_TIMESTAMP
app_log_enginefullactivity time timestamp 19 0000-00-00 00:00:00
app_log_realusage time timestamp 19 0000-00-00 00:00:00
app_log_unvoluntarysearches time timestamp 19 0000-00-00 00:00:00
app_log_voluntaryarticles time timestamp 19 0000-00-00 00:00:00
app_log_voluntarysearches time timestamp 19 0000-00-00 00:00:00
app_log_voluntarysearchesandarticles time timestamp 19 0000-00-00 00:00:00
briefcase_folders time timestamp 19 CURRENT_TIMESTAMP
user_articles ts timestamp 19 CURRENT_TIMESTAMP The current time
languages iso_639_1 varchar 2  √  null ISO 639-1
languages language_id varchar 2 ISO 639-1
languages dir varchar 3 rtl Horizontal direction of the text
languages iso_639_2 varchar 3  √  null ISO 639-2
translation_values language_id varchar 3
app_log_dt Time varchar 8  √  null
app_log_datehitsperuser Date varchar 10  √  null
app_log_datestats Date varchar 10  √  null
app_log_dt Date varchar 10  √  null
app_log_userhitsperdate Date varchar 10  √  null
contact_lists_details uid varchar 16
app_log_userspages_crossstatistics User varchar 16  √  null
app_log_countriesperday User ID varchar 16  √  null
app_log_datehitsperuser User ID varchar 16  √  null
app_log_pagesaccessperuser User ID varchar 16  √  null
app_log_themesperday User ID varchar 16  √  null
app_log_usageofbriefcase User ID varchar 16  √  null
app_log_usageofexport User ID varchar 16  √  null
app_log_usageoffiltering User ID varchar 16  √  null
app_log_usageofpreferencespage User ID varchar 16  √  null
app_log_usageofsharing User ID varchar 16  √  null
app_log_userhitsperdate User ID varchar 16  √  null
app_log_userstats User ID varchar 16  √  null
app_log_userstotal User ID varchar 16  √  null
ajax_calls user_id varchar 16  √  null The user which is requesting the URL
app_log user_id varchar 16  √  null
app_log_d user_id varchar 16  √  null
app_log_dt user_id varchar 16  √  null
app_log_enginefullactivity user_id varchar 16  √  null
app_log_individualusersperday user_id varchar 16  √  null
app_log_realusage user_id varchar 16  √  null
app_log_unvoluntarysearches user_id varchar 16  √  null
app_log_useractions user_id varchar 16  √  null
app_log_userslist user_id varchar 16  √  null
app_log_voluntaryarticles user_id varchar 16  √  null
app_log_voluntarysearches user_id varchar 16  √  null
app_log_voluntarysearchesandarticles user_id varchar 16  √  null
briefcase_content user_id varchar 16 The user identifier
briefcase_content_backup user_id varchar 16 The user identifier
briefcase_folder_rss_users user_id varchar 16
briefcase_folders user_id varchar 16 The user identifier
briefcase_templates user_id varchar 16
contact_lists user_id varchar 16
known_users user_id varchar 16
rss_log user_id varchar 16
user_articles user_id varchar 16
user_preferences user_id varchar 16
rss_log engine_id varchar 25
app_log_enginefullactivity delegation varchar 32  √  null
app_log_realusage delegation varchar 32  √  null
app_log_unvoluntarysearches delegation varchar 32  √  null
app_log_voluntaryarticles delegation varchar 32  √  null
app_log_voluntarysearches delegation varchar 32  √  null
app_log_voluntarysearchesandarticles delegation varchar 32  √  null
app_log_enginefullactivity directorate varchar 32  √  null
app_log_realusage directorate varchar 32  √  null
app_log_unvoluntarysearches directorate varchar 32  √  null
app_log_voluntaryarticles directorate varchar 32  √  null
app_log_voluntarysearches directorate varchar 32  √  null
app_log_voluntarysearchesandarticles directorate varchar 32  √  null
app_log_enginesaccesstotal Engine varchar 32 Search engine to which the current source is relying on
app_log_enginesperday Engine varchar 32 Search engine to which the current source is relying on
app_log_enginesperhour Engine varchar 32 Search engine to which the current source is relying on
known_users password varchar 32  √  null
briefcase_contents_types name varchar 100 The type name
briefcase_folders name varchar 100 The folder name
user_articles article_id varchar 255 The article identifier
ajax_call_urls call_content_type varchar 255  √  application/binary
app_log_countriesperday Country varchar 255 ISO 3166-2
app_log_totalnumberofcountrypagesaccess Country varchar 255 ISO 3166-2
app_log_enginefullactivity displayname varchar 255  √  null Display name (ldap attribute: cn)
app_log_realusage displayname varchar 255  √  null Display name (ldap attribute: cn)
app_log_unvoluntarysearches displayname varchar 255  √  null Display name (ldap attribute: cn)
app_log_voluntaryarticles displayname varchar 255  √  null Display name (ldap attribute: cn)
app_log_voluntarysearches displayname varchar 255  √  null Display name (ldap attribute: cn)
app_log_voluntarysearchesandarticles displayname varchar 255  √  null Display name (ldap attribute: cn)
contact_lists_details e_mail varchar 255
known_users e_mail varchar 255  √  null
app_log_accessedarticlespertype Engine varchar 255  √  null
app_log_enginefullactivity engine varchar 255  √  null
app_log_enginesarticlesaccesstotal Engine varchar 255  √  null
app_log_realusage engine varchar 255  √  null
app_log_unvoluntarysearches engine varchar 255  √  null
app_log_voluntaryarticles engine varchar 255  √  null
app_log_voluntarysearches engine varchar 255  √  null
app_log_voluntarysearchesandarticles engine varchar 255  √  null
known_users first_name varchar 255  √  null
known_users functional_mailbox varchar 255  √  null
known_users groups varchar 255  √  null
briefcase_content item_id varchar 255  √  null The item identifier (e.g.: article id)
briefcase_content_backup item_id varchar 255  √  null The item identifier (e.g.: article id)
app_log_details key varchar 255
app_log_enginefullactivity key varchar 255
app_log_realusage key varchar 255
app_log_unvoluntarysearches key varchar 255
app_log_voluntaryarticles key varchar 255
app_log_voluntarysearches key varchar 255
app_log_voluntarysearchesandarticles key varchar 255
user_preferences key varchar 255
translation keyword varchar 255
translation_values keyword varchar 255
known_users last_name varchar 255  √  null
contact_lists list_name varchar 255
briefcase_content mime_type varchar 255  √  null The content mime type or NULL
briefcase_content_backup mime_type varchar 255  √  null The content mime type or NULL
briefcase_templates name varchar 255
languages name varchar 255 Name in original language
languages name_en varchar 255 ISO 639-2/B
languages name_fr varchar 255 ISO 639-2/B
app_log_usageofbriefcase Section varchar 255
languages_sections section_id varchar 255
translation section_id varchar 255
translation_values section_id varchar 255
briefcase_folder_rss template varchar 255
app_log_themesperday Theme varchar 255
external_articles url varchar 512  √  null
ajax_call_urls url varchar 2048