Extension:MachineVision/Schema/machine vision freebase mapping

Stores concept mappings used to translate Freebase IDs to Wikidata IDs. Many of these Freebase IDs are still in use in the Google Knowledge Graph.

Mapping source: https://developers.google.com/freebase/#freebase-wikidata-mappings

Fields edit

mvfm_freebase_id edit

  • Freebase ID

mvfm_wikidata_id edit

  • Wikidata ID
 +------------------+---------------+------+-----+---------+-------+
 | Field            | Type          | Null | Key | Default | Extra |
 +------------------+---------------+------+-----+---------+-------+
 | mvfm_freebase_id | varbinary(32) | NO   | PRI | NULL    |       |
 | mvfm_wikidata_id | varbinary(32) | NO   | PRI | NULL    |       |
 +------------------+---------------+------+-----+---------+-------+

Indexes edit

+---------------------------------+------------+----------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
 | Table                           | Non_unique | Key_name | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 +---------------------------------+------------+----------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
 | machine_vision_freebase_mapping |          0 | PRIMARY  |            1 | mvfm_freebase_id | A         |     2387053 |     NULL | NULL   |      | BTREE      |         |               |
 | machine_vision_freebase_mapping |          0 | PRIMARY  |            2 | mvfm_wikidata_id | A         |     2387053 |     NULL | NULL   |      | BTREE      |         |               |
 +---------------------------------+------------+----------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+