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