page_link table

Fields

Schema summary

 DESCRIBE page_link;

+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| link_id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| from_page_id | int(10) unsigned | NO   | MUL | 0       |                |
| to_page_id   | int(10) unsigned | NO   |     | 0       |                |
| to_tag       | varchar(250)     | NO   | MUL | NULL    |                |
| to_supertag  | varchar(250)     | NO   |     | NULL    |                |
+--------------+------------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN page_link;

+---------------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name         | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_page_link |          0 | PRIMARY          |            1 | link_id      | A         |          52 |     NULL | NULL   |      | BTREE      |         |               |
| dev_page_link |          1 | idx_from_tag     |            1 | from_page_id | A         |          52 |     NULL | NULL   |      | BTREE      |         |               |
| dev_page_link |          1 | idx_from_tag     |            2 | to_tag       | A         |          52 |       78 | NULL   |      | BTREE      |         |               |
| dev_page_link |          1 | idx_from_page_id |            1 | from_page_id | A         |          52 |     NULL | NULL   |      | BTREE      |         |               |
| dev_page_link |          1 | idx_to           |            1 | to_tag       | A         |          52 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+