| Num
|
Table_name
|
Main table_important field
|
Description
|
Whether it exists in toyhouse.cc
|
| 1
|
actor
|
- actor_id PRI
- actor_user UNI
- actor_name UNI
|
|
Y
|
| 2
|
archive
|
- ar_id PRI auto_increment(Extra)
- ar_namespace MUL ?
- ar_title
- ar_comment
- ar_user (=user.user_id)
- ar_user_text (=user.user_name)
- ar_timestamp
- ar_len
- ar_deleted
- ar_sha1
|
|
Y
|
| 3
|
babel
|
|
|
|
| 4
|
bot_passwords
|
|
|
Y
|
| 5
|
category
|
- cat_id PRI auto_increment(Extra)
- cat_title UNI
- cat_pages MUL
- cat_subcats
- cat_files
|
- How many categories? "cat_title"
- How many times has a specific category been played?
- "cat_pages" + "cat_subcats"
|
Y
|
| 6
|
categorylinks
|
- cl_from PRI (type number)
- cl_to PRI (=category.cat_title)
- cl_sortkey (type name)
- cl_timestamp
- cl_type (page or subcat)
|
- Which categories are referenced on a type(page/subcat)？
- “cl_from=xx, cl_to PRI”
- Which types(pages/subcats) are referenced by a specific category？
- “cl_to PRI=xx, cl_from”
- and When was it quoted? “cl_timestamp”
|
Y
|
| 7
|
change_tag
|
- ct_id PRI auto_increment(Extra)
- ct_rc_id MUL
- ct_rev_id MUL
- ct_tag MUL (/Special:Tags)
|
|
Y
|
| 8
|
comment
|
- comment_id PRI auto_increment(Extra)
- comment_hash MUL
- comment_text
- comment_data
|
|
Y
|
| 9
|
content
|
|
|
Y
|
| 10
|
content_models
|
|
|
Y
|
| 11
|
externallinks
|
- el_id PRI auto_increment(Extra)
- el_from MUL
- el_to MUL
- el_index MUL
|
All external links?
|
Y
|
| 12
|
filearchive
|
- fa_id PRI auto_increment(Extra)
- fa_storage_group
- fa_deleted_user (=user.user_id)
- fa_deleted_timestamp MUL
- fa_deleted_reason
- fa_size
- fa_metadata
- fa_media_type
- fa_major_mime
- fa_minor_mime
- fa_description
- fa_user (=user.user_id)
- fa_user_text (=user.user_name)
- fa_timestamp
- fa_sha1
|
The deleted archives.
|
Y
|
| 13
|
image
|
- img_name PRI
- img_size
- img_metadata
- img_media_type
('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO',
'MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D')
('unknown','application','audio','image','text','video',
'message','model','multipart','chemical')
- img_minor_mime
- img_description
- img_user (=user.user_id)
- img_user_text (=user.user_name)
- img_timestamp
- img_sha1
|
The historical picture information classified in the file is shown in “Table: oldimage”.
- How many images of a certain type?
- “img_media_type”/“img_major_mime”/“img_minor_mime”
|
Y
|
| 14
|
image_comment_temp
|
|
|
Y
|
| 15
|
imagelinks
|
- il_from PRI
- il_from_namespace ?
- il_to PRI
|
- How many links are related to the image?
- “number of rows in this table”
- How many connections are linked to the image?
- “il_to PRI=xx，il_from PRI”
|
Y
|
| 16
|
interwiki
|
|
All internal links?
|
Y
|
| 17
|
ip_changes
|
|
|
Y
|
| 18
|
ipblocks
|
|
|
Y
|
| 19
|
iwlinks
|
- iwl_from PRI （page.page_id）
- iwl_prefix PRI (commons/wiki/wikipedia)
- wl_title PRI
|
The article uses “commons:”/”wiki:”/”wikipedia:” as the tag's vocabulary
- How many vocabularies are marked with “commons:”/”wiki:”/”wikipedia:” on the same page?
- “iwl_prefix PRI=xx, iwl_from PRI+ wl_title PRI”
- a vocabulary, how many pages are marked with “commons:”/”wiki:”/”wikipedia:”?
- “wl_title PRI=xx, iwl_from PRI +iwl_prefix PRI”
- Mark “commons:”/”wiki:”/”wikipedia:”, how many times have been used repeatedly (including the same label on different pages , excluding the same label on the same page)？
- “iwl_prefix PRI=xx, iwl_from PRI+ wl_title PRI”
|
Y
|
| 20
|
job
|
|
|
Y
|
| 21
|
l10n_cache
|
|
cache
|
Y
|
| 22
|
langlinks
|
- ll_from PRI
- ll_lang PRI
- ll_title
|
NULL
|
Y
|
| 23
|
log_search
|
- ls_field PRI (associated_rev_id/ ipb_id/ pr_id )
- ls_value PRI
- ls_log_id PRI
|
How many times has the page been searched and viewed?
|
Y
|
| 24
|
logging
|
- log_id PRI auto_increment(Extra)
- log_type MUL
- log_action
- log_timestamp MUL
- log_user MUL (user.user_id)
- log_user_text MUL (user.user_name)
- log_namespace MUL?
- log_title
- log_page MUL (page.page_id)
- log_comment
- log_params
|
- What operations did the key pages do during a certain period of time?
- “log_timestamp =xx, log_page=xx, log_type+ log_action”
|
Y
|
| 25
|
math
|
|
|
|
| 26
|
mathoid
|
|
|
|
| 27
|
module_deps
|
|
|
Y
|
| 28
|
objectcache
|
|
cache
|
Y
|
| 29
|
oldimage
|
- oi_name
- oi_archive_name
- oi_size
- oi_description
- oi_user
- oi_user_text
- oi_timestamp: 20190426071929
- oi_metadata
- oi_media_type
- oi_major_mime
- oi_minor_mime
- oi_sha1
|
Historical image information classified in the archive, like “Table: image”.
|
Y
|
| 30
|
page
|
- page_id PRI auto_increment(Extra)
- page_namespace ?
- page_title
- page_is_redirect MUL
- page_touched
- page_links_updated
- page_latest
- page_len MUL
- page_content_model
|
Page information
- How many pages are there in Wiki as of the current query?
- “row number”
- How many pages in WIKI are deleted due to the current query?
- “page_id - row number”
- How many WIKI pages have been revised during a certain period of time?
- “page_touched”
|
Y
|
| 31
|
page_props
|
- pp_page PRI (=page.page_id)
- pp_propname PRI
- pp_value
- pp_sortkey
|
page properties information
|
Y
|
| 32
|
page_restrictions
|
- pr_id PRI (=page.page_id)
- pr_page MUL
- pr_type MUL
- pr_level MUL
- pr_cascade MUL
- pr_user
- pr_expiry
|
page protection information.
|
Y
|
| 33
|
pagelinks
|
- pl_from PRI (=page.page_id)
- pl_from_namespace
- pl_namespace PRI
- pl_title PRI
|
- How many links are in a page?
- “pl_from=xx, row number”
|
Y
|
| 34
|
protected_titles
|
- pt_namespace PRI
- pt_title PRI
- pt_user
- pt_reason
- pt_reason_id
- pt_timestamp MUL
- pt_expiry
- pt_create_perm
|
Read-only page, cannot be edited ?
|
Y
|
| 35
|
querycache
|
- qcc_type MUL (=querycache_info. qci_type)
- qcc_value
- qcc_namespace?
- qcc_title
|
query cache information
|
Y
|
| 36
|
querycache_info
|
- qci_type PRI (activeusers)
- qci_timestamp
|
query cache type information.
|
Y
|
| 37
|
querycachetwo
|
- qcc_type MUL (=querycache_info. qci_type)
- qcc_value
- qcc_namespace?
- qcc_title
|
query cache information
- Which users are active？ "qcc_type=activeusers"
|
Y
|
| 38
|
recentchanges
|
- rc_id PRI auto_increment(Extra)
- rc_timestamp MUL
- rc_user (=user.user_id)
- rc_user_text MUL (=user.user_name)
- rc_actor MUL
- rc_namespace? MUL
- rc_title
- rc_comment
- rc_comment_id
- rc_cur_id MUL
- rc_this_oldid
- rc_last_oldid
- rc_type
- rc_source
- rc_patrolled
- rc_ip MUL
- rc_old_len
- rc_new_len
- rc_deleted
- rc_logid
- rc_log_type
- rc_log_action
- rc_params
|
Change log for the last 3 months.
|
Y
|
| 39
|
redirect
|
- rd_from PRI (Before redirection page.page_id)
- rd_namespace MUL?
- rd_title
|
Redirect page information.
|
Y
|
| 40
|
revision
|
- rev_id PRI auto_increment(Extra)
- rev_page MUL (=page.page_id)
- rev_text_id
- rev_comment
- rev_user MUL (=user.user_id)
- rev_user_text MUL (=user.user_name)
- rev_timestamp MUL
- rev_minor_edit
- rev_deleted
- rev_len (=page.page_len)
- rev_parent_id
- rev_sha1
|
Version change log
- How many times does a page version change(at a certain time period)?
- ”rev_page=xx (rev_timestamp), row number”
|
Y
|
| 41
|
revision_actor_temp
|
- revactor_rev PRI (=revision.rev_id)
- revactor_actor PRI (=actor.actor_id)
- revactor_timestamp
- revactor_page MUL (=page.page_id)
|
|
Y
|
| 42
|
revision_comment_temp
|
- revcomment_rev PRI (=revision.rev_id)
- revcomment_comment_id PRI (=comment.comment_id)
|
|
Y
|
| 43
|
revtag
|
|
|
|
| 44
|
searchindex
|
|
|
Y
|
| 45
|
site_identifiers
|
- si_site MUL (=sites.site_id)
- si_type PRI (=sites.site_type)
- si_key PRI
|
|
Y
|
| 46
|
site_stats
|
- ss_row_id PRI
- ss_total_edits
- ss_good_articles
- ss_total_pages
- ss_users
- ss_active_users
- ss_images
|
Summary statistics
|
Y
|
| 47
|
sites
|
- site_id PRI auto_increment(Extra)
- site_global_key UNI
- site_type MUL
- site_group MUL
- site_source MUL
- site_data
|
|
Y
|
| 48
|
slot_roles
|
|
|
Y
|
| 49
|
slots
|
|
|
Y
|
| 50
|
smw_concept_cache
|
|
|
|
| 51
|
smw_di_blob
|
|
Glossary information, name, definition, and link
- how many glosssary
- how many pages are referenced by a specific glossary
|
May be related to extension: Semantic Mediawiki
|
| 52
|
smw_di_bool
|
|
|
May be related to extension: Semantic Mediawiki
|
| 53
|
smw_di_coords
|
|
|
May be related to extension: Semantic Mediawiki
|
| 54
|
smw_di_number
|
|
|
May be related to extension: Semantic Mediawiki
|
| 55
|
smw_di_time
|
|
|
May be related to extension: Semantic Mediawiki
|
| 56
|
smw_di_uri
|
|
|
May be related to extension: Semantic Mediawiki
|
| 57
|
smw_di_wikipage
|
|
statistics?
|
May be related to extension: Semantic Mediawiki
|
| 58
|
smw_fpt_ask
|
|
|
May be related to extension: Semantic Mediawiki
|
| 59
|
smw_fpt_askde
|
|
|
May be related to extension: Semantic Mediawiki
|
| 60
|
smw_fpt_askdu
|
|
|
May be related to extension: Semantic Mediawiki
|
| 61
|
smw_fpt_askfo
|
|
|
May be related to extension: Semantic Mediawiki
|
| 62
|
smw_fpt_askpa
|
|
|
May be related to extension: Semantic Mediawiki
|
| 63
|
smw_fpt_asksi
|
|
|
May be related to extension: Semantic Mediawiki
|
| 64
|
smw_fpt_askst
|
|
|
May be related to extension: Semantic Mediawiki
|
| 65
|
smw_fpt_conc
|
|
|
May be related to extension: Semantic Mediawiki
|
| 66
|
smw_fpt_conv
|
|
|
May be related to extension: Semantic Mediawiki
|
| 67
|
smw_fpt_dtitle
|
|
|
May be related to extension: Semantic Mediawiki
|
| 68
|
smw_fpt_impo
|
|
|
May be related to extension: Semantic Mediawiki
|
| 69
|
smw_fpt_inst
|
|
|
May be related to extension: Semantic Mediawiki
|
| 70
|
smw_fpt_lcode
|
|
|
May be related to extension: Semantic Mediawiki
|
| 71
|
smw_fpt_list
|
|
|
May be related to extension: Semantic Mediawiki
|
| 72
|
smw_fpt_mdat
|
|
|
May be related to extension: Semantic Mediawiki
|
| 73
|
smw_fpt_pplb
|
|
|
May be related to extension: Semantic Mediawiki
|
| 74
|
smw_fpt_prec
|
|
|
May be related to extension: Semantic Mediawiki
|
| 75
|
smw_fpt_pval
|
|
|
May be related to extension: Semantic Mediawiki
|
| 76
|
smw_fpt_redi
|
|
|
May be related to extension: Semantic Mediawiki
|
| 77
|
smw_fpt_serv
|
|
|
May be related to extension: Semantic Mediawiki
|
| 78
|
smw_fpt_sobj
|
|
|
May be related to extension: Semantic Mediawiki
|
| 79
|
smw_fpt_subc
|
|
|
May be related to extension: Semantic Mediawiki
|
| 80
|
smw_fpt_subp
|
|
|
May be related to extension: Semantic Mediawiki
|
| 81
|
smw_fpt_text
|
|
|
May be related to extension: Semantic Mediawiki
|
| 82
|
smw_fpt_type
|
|
|
May be related to extension: Semantic Mediawiki
|
| 83
|
smw_fpt_unit
|
|
|
May be related to extension: Semantic Mediawiki
|
| 84
|
smw_fpt_uri
|
|
|
May be related to extension: Semantic Mediawiki
|
| 85
|
smw_ft_search
|
|
|
May be related to extension: Semantic Mediawiki
|
| 86
|
smw_object_ids
|
|
|
May be related to extension: Semantic Mediawiki
|
| 87
|
smw_prop_stats
|
|
statistics?
|
May be related to extension: Semantic Mediawiki
|
| 88
|
smw_query_links
|
|
|
May be related to extension: Semantic Mediawiki
|
| 89
|
tag_summary
|
- ts_id PRI auto_increment(Extra)
- ts_rc_id UNI
- ts_log_id UNI
- ts_rev_id UNI
- ts_tags (/Special:Tags)
|
tagged changes information
- How many times has a certain Tag been changed?
- ”ts_tags=xx, row number”
|
Y
|
| 90
|
templatelinks
|
- tl_from PRI （=page.page_id）
- tl_namespace PRI ?
- tl_namespace PRI ?
- tl_title PRI (=page.page_title)
|
- Which templates are used (link to), and the number of uses?
- "tl_title"
- Which pages are referenced by a template?
- “tl_title=xx, tl_from”
|
Y
|
| 91
|
text
|
|
|
Y
|
| 92
|
transcache
|
|
cache
|
Y
|
| 93
|
translate_groupreviews
|
|
|
|
| 94
|
translate_groupstats
|
|
|
|
| 95
|
translate_messageindex
|
|
|
|
| 96
|
translate_metadata
|
|
|
|
| 97
|
translate_reviews
|
|
|
|
| 98
|
translate_sections
|
|
|
|
| 99
|
translate_stash
|
|
|
|
| 100
|
translate_tmf
|
|
|
|
| 101
|
translate_tms
|
|
|
|
| 102
|
translate_tmt
|
|
|
|
| 103
|
updatelog
|
|
|
Y
|
| 104
|
uploadstash
|
- us_id PRI auto_increment(Extra)
- us_user MUL
- us_key MUL
- us_source_type
- us_timestamp MUL
- us_status
- us_props
- us_size
- us_sha1
- us_mime
- us_media_type
|
Upload information
|
Y
|
| 105
|
user
|
- user_id PRI auto_increment(Extra)
- user_name UNI
- user_touched
- user_token
- user_registration
- editcount
|
User information
- The number of users in the current system? “row number”
- Number of users registered in a certain period of time?
- ”user_registration=xx, row number”
- ”user_touched=xx, row number”
|
Y
|
| 106
|
user_former_groups
|
- ufg_user PRI (=user.user_id)
- ufg_group PRI (=user_groups.ug_group)
|
|
Y
|
| 107
|
user_groups
|
- ug_user PRI (=user.user_id)
- ug_group PRI (/Special:ListGroupRights)
- ug_expiry MUL
|
user group information
- How many user groups? “ug_group(Exclude duplicates)”
- How many user groups are invalid?
- “ug_expiry MUL、ug_group(Exclude duplicates)”
- How many users are in a user group?
- “ug_group=xx, row number”
|
Y
|
| 108
|
user_newtalk
|
|
|
Y
|
| 109
|
user_properties
|
- up_user PRI (=user.user_id)
- up_property PRI
- up_value
|
|
Y
|
| 110
|
valid_tag
|
|
|
Y
|
| 111
|
watchlist
|
- wl_id PRI
- wl_user MUL (=user.user_id)
- wl_namespace MUL ?
- wl_title (=page.page_title)
- wl_notificationtimestamp
|
Monitor user action data
|
Y
|
| 112
|
wiki_globalimagelinks
|
- gil_wiki PRI
- gil_page PRI
- gil_page_namespace_id
- gil_page_namespace
- gil_page_title
- gil_to PRI
|
only exist in toyhouse.cc
|
Y
|