View source for Extension:CentralNotice/cn assignments table

== Fields ==

{{CentralNotice/DbTable
  |table-desc=Associates banners to campaigns and sets any banner metadata that is campaign specific and not many to one.
}}
{{CentralNotice/DbTableRow
  |key=primary
  |name=asn_id
  |type=int(11) NOT NULL AUTO_INCREMENT
  |default=NULL
  |desc=Assignment ID
}}

{{CentralNotice/DbTableRow
  |key=
  |name=not_id
  |type=int(11) NOT NULL
  |default=NULL
  |desc=Foreign key to the <code>cn_notices</code> table; identifying the campaign.
}}

{{CentralNotice/DbTableRow
  |key=
  |name=tmp_id
  |type=int(11) NOT NULL
  |default=NULL
  |desc=Foreign key to the <code>cn_templates</code> table; identifying the banner.
}}

{{CentralNotice/DbTableRow
  |key=
  |name=tmp_weight
  |type=int(11) NOT NULL
  |default=NULL
  |desc=Integer 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.
}}

{{CentralNotice/DbTableRow
  |key=
  |name=asn_bucket
  |type=tinyint(1)
  |default=0
  |desc=Foreign key. Bucket this banner is assigned. Should not be greater than <code>not_buckets</code> in the <code>cn_notices</code> table.
}}
|}

== Schema ==
<pre>
+------------+------------+------+-----+---------+----------------+
| 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       |                |
+------------+------------+------+-----+---------+----------------+
</pre>

== Indexes ==
<pre>
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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      |         |               |
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
</pre>

{{databases}}
{{Wikimedia extension database tables}}

[[Category:Wikimedia extension database tables{{#translation:}}|cn_assignments table]]