agencyInCategoryType


Description

Agency category type assignments that associate agencies with specific category types for business classification, reporting, and operational grouping purposes.

Columns

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

Primary key - agencyInCategoryType unique identifier for each record

fkAgencyID int 4 null
Agency.AgencyID FK__agencyInCategoryType__AgencyId C

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

fkCatTypeID int 4 null
CategoryType.CatTypeID FK__agencyInCategoryType__catTypeID C

Category type reference - Reference to the category type (foreign key to CategoryType.CatTypeID)

Indexes

Constraint Name Type Sort Column(s)
PK_pkAgencyCatTypeID Primary key Asc pkAgencyCatTypeID

Relationships