SchemaSpy Analysis of tariqa3 - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Apr 25 13:30 CEST 2012 |
| ||||||
|
tariqa3 contains 298 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
briefcase_folders | archived | enum | 2 | √ | n | ||
known_users | is_ecas | enum | 2 | √ | y | ||
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 | ||||
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 | 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_dt | Time | varchar | 8 | √ | null | ||
external_articles | article_id | int | 10 | √ | |||
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 | ||
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 | ||
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 | |||
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 | ||
app_log_enginesperhour | Hour | int | 10 | √ | null | ||
app_log_pagesaccessperhour | Hour | int | 10 | √ | null | ||
app_log_usersperhour | Hour | int | 10 | √ | null | ||
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 | |
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 | ||
briefcase_folders | parent_id | int unsigned | 10 | √ | null | The parent identifier | |
rss_log | source_id | int | 10 | √ | null | ||
briefcase_templates | template_id | int | 10 | √ | |||
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 | |
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 | ||
ajax_call_urls | duration | float | 12 | √ | null | Duration in seconds of the download | |
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 | ||||
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 | |||
ajax_calls | call_time | datetime | 19 | √ | null | Date/time at which the call was issued | |
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 | |||
rss_log | date | datetime | 19 | ||||
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_userstotal | First access | timestamp | 19 | √ | null | ||
known_users | first_access | datetime | 19 | √ | null | ||
app_log_datehitsperuser | Hits | bigint | 19 | 0 | |||
app_log_userhitsperdate | Hits | bigint | 19 | 0 | |||
app_log_userspages_crossstatistics | Hits | bigint | 19 | 0 | |||
app_log_userstotal | Last Access | timestamp | 19 | √ | null | ||
ajax_call_urls | last_update | datetime | 19 | √ | null | Date/time at which the URL process was ended | |
app_log_countriesperday | No accesses | bigint | 19 | 0 | |||
app_log_themesperday | No accesses | bigint | 19 | 0 | |||
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 | |||
app_log_userstotal | Total | bigint | 19 | 0 | |||
user_articles | ts | timestamp | 19 | CURRENT_TIMESTAMP | The current time | ||
app_log_datestats | Users | bigint | 19 | 0 | |||
app_log_datestats | HitAverage | decimal | 24,4 | √ | null | ||
app_log_userstats | HitAverage | decimal | 24,4 | √ | null | ||
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 | ||
app_log_datestats | TotalHits | decimal | 42 | √ | null | ||
app_log_userstats | TotalHits | decimal | 42 | √ | 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 | ||||
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 | ||
briefcase_content | name | blob | 65535 | The content name | |||
briefcase_content_backup | name | blob | 65535 | The content name | |||
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 | ||
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 |