Extension:CentralNotice/cn assignments table

Fields

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.