AgencyAddons


Description

Agency add-on assignments that track which add-on modules are enabled for specific agencies. This junction table manages the many-to-many relationship between agencies and available add-ons.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkAddonAgencyID int identity 4 null

Primary key - AgencyAddons unique identifier for each record

fkAddonID int 4 null
Addons.pkAddonID FK_AgencyAddon_Addon R

Add-on reference - Reference to the add-on module (foreign key to Addons.pkAddonID)

fkAgencyID int 4 null
Agency.AgencyID FK_AgencyAddon_Agency R

Agency reference - Reference to the agency (foreign key to Agency.AgencyID)

Indexes

Constraint Name Type Sort Column(s)
PK_AgencyAddon Primary key Asc pkAddonAgencyID

Relationships