file_link table

Fields

Schema summary

 DESCRIBE file_link;

+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| file_link_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| page_id      | int(10) unsigned | NO   | MUL | 0       |                |
| file_id      | int(10) unsigned | NO   | MUL | 0       |                |
+--------------+------------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN file_link;

+---------------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name    | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_file_link |          0 | PRIMARY     |            1 | file_link_id | A         |          15 |     NULL | NULL   |      | BTREE      |         |               |
| dev_file_link |          1 | idx_page_id |            1 | page_id      | A         |          15 |     NULL | NULL   |      | BTREE      |         |               |
| dev_file_link |          1 | idx_file_id |            1 | file_id      | A         |          15 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+