Extension:CentralNotice/cn assignments table

From mediawiki.org
Jump to navigation Jump to search


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.