page_link table

Fields

Schema summary

 DESCRIBE page_link;	

6.0

+--------------+------------------+------+-----+---------+----------------+
| 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(191)     | NO   | MUL |         |                |
+--------------+------------------+------+-----+---------+----------------+	

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 |
+-----------------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_page_link |          0 | PRIMARY          |            1 | link_id      | A         |          58 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_page_link |          1 | idx_from_page_id |            1 | from_page_id | A         |          58 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_page_link |          1 | idx_to           |            1 | to_tag       | A         |          58 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_page_link |          1 | idx_from_tag     |            1 | from_page_id | A         |          58 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_page_link |          1 | idx_from_tag     |            2 | to_tag       | A         |          58 |     NULL | NULL   |      | BTREE      |         |               |
+-----------------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+