Extension:CentralNotice/cn assignments table

From mediawiki.org
Jump to navigation Jump to search

Fields[edit]

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

Key Name Type Default Description
primary asn_id int(11) NOT NULL AUTO_INCREMENT NULL Assignment ID


not_id int(11) NOT NULL NULL Foreign key to the cn_notices table; identifying the campaign.


tmp_id int(11) NOT NULL NULL Foreign key to the cn_templates table; identifying the banner.


tmp_weight int(11) NOT NULL NULL 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.


asn_bucket tinyint(1) 0 Foreign key. Bucket this banner is assigned. Should not be greater than not_buckets in the cn_notices table.