WackoWiki: referrer table

https://wackowiki.org/doc     Version: 22.06.2020 11:10
Dev[link1]/Database[link2]/Layout[link3]/referrer

Fields

Schema summary

 DESCRIBE referrer;

6.0

+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| referrer_id   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| page_id       | int(10) unsigned | NO   | MUL | 0       |                |
| referrer      | varchar(255)     | NO   |     | NULL    |                |
| referrer_time | datetime         | YES  | MUL | NULL    |                |
| ip            | varchar(45)      | NO   |     | NULL    |                |
| user_agent    | varchar(150)     | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN referrer;

+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table          | Non_unique | Key_name          | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_referrer |          0 | PRIMARY           |            1 | referrer_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_referrer |          1 | idx_page_id       |            1 | page_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_referrer |          1 | idx_referrer_time |            1 | referrer_time | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+