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 | | |
+---------------------------------+------------+----------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+