Wikibase
MediaWiki Wikibase extension
wbc_entity_usage

Part of the Usage tracking system on a Client.

Fields:

  • eu_row_id - auto-increment row ID for internal use. Primary key.
  • eu_entity_id - Serialized entity ID for the entity that has usage
  • eu_aspect - Which aspect of the entity is being used. (See Usage tracking)
  • eu_page_id - the ID of the page using the entity; refers to page.page_id.
+--------------+----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------+------+-----+---------+----------------+
| eu_row_id | bigint(20) | NO | PRI | NULL | auto_increment |
| eu_entity_id | varbinary(255) | NO | MUL | NULL | |
| eu_aspect | varbinary(37) | NO | | NULL | |
| eu_page_id | int(11) | NO | MUL | NULL | |
+--------------+----------------+------+-----+---------+----------------+

Implied relations:

dot_inline_dotgraph_2.png

Extra Indexes:

  • UNIQUE eu_entity_id , eu_aspect, eu_page_id - record one usage per page per aspect of an entity
  • eu_page_id, eu_entity_id - look up (and especially, delete) usage entries by page id

Example data:

eu_row_id eu_entity_id eu_aspect eu_page_id
158829644 Q99 O 73443972
88145275 L10102 L 56193021
157778764 L10151-S1 L 53636569
91511974 Q645 D.en 3334
96856295 P455 L.en 3334
39020318 Q6339058 C.P625 13831293