< Extension:CentralNotice

Fields

Associates banners to campaigns and sets any banner metadata that is campaign specific and not many to one.

Key Name Type Default Description
primaryasn_idint(11) NOT NULL AUTO_INCREMENTNULLAssignment ID
not_idint(11) NOT NULLNULLForeign key to the cn_notices table; identifying the campaign.
tmp_idint(11) NOT NULLNULLForeign key to the cn_templates table; identifying the banner.
tmp_weightint(11) NOT NULLNULLInteger weight that shows the priority that this banner has relative to others. As of v2.3 this is restricted to the range 1 - 100 inclusive and is relative only within the associated campaign.
asn_buckettinyint(1)0Foreign key. Bucket this banner is assigned. Should not be greater than not_buckets in the cn_notices table.

Schema

+------------+------------+------+-----+---------+----------------+
| Field      | Type       | Null | Key | Default | Extra          |
+------------+------------+------+-----+---------+----------------+
| asn_id     | int(11)    | NO   | PRI | NULL    | auto_increment |
| not_id     | int(11)    | NO   | MUL | NULL    |                |
| tmp_id     | int(11)    | NO   | MUL | NULL    |                |
| tmp_weight | int(11)    | NO   |     | NULL    |                |
| asn_bucket | tinyint(1) | YES  | MUL | 0       |                |
+------------+------------+------+-----+---------+----------------+

Indexes

+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table          | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| cn_assignments |          0 | PRIMARY    |            1 | asn_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| cn_assignments |          1 | asn_not    |            1 | not_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| cn_assignments |          1 | asn_tmp    |            1 | tmp_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| cn_assignments |          1 | asn_bucket |            1 | asn_bucket  | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.