Extension:WikimediaEditorTasks/Schema/wikimedia editor tasks entity description exists

From mediawiki.org


Stores intermediary data, derived from longer-running queries, about whether descriptions exist for entities in the languages of their sitelinks.

Fields[edit]

wetede_entity_id[edit]

  • Wikibase ID number for the entity (minus the 'Q' prefix)

wetede_language[edit]

  • Wiki language code for this entry

wetede_description_exists[edit]

  • Whether a description exists in this language for the entity

wetede_rand[edit]

  • A random floating-point number between 0 and 1 (used for retrieving random results)
+---------------------------+------------------+------+-----+---------+-------+
| Field                     | Type             | Null | Key | Default | Extra |
+---------------------------+------------------+------+-----+---------+-------+
| wetede_entity_id          | int(10) unsigned | NO   | PRI | NULL    |       |
| wetede_language           | varbinary(255)   | NO   | PRI | NULL    |       |
| wetede_description_exists | tinyint(4)       | NO   |     | 0       |       |
| wetede_rand               | float            | NO   | MUL | NULL    |       |
+---------------------------+------------------+------+-----+---------+-------+