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