CategoryTypeAssigned


Description

Category type assignments linking categories to specific category types for classification and organization. This table manages the assignment of categories to type classifications, enabling hierarchical category organization and type-based filtering for healthcare service categorization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
typeID int 4 √ null

Type reference - Links to the type being assigned to the category
catID int 4 √ null
Category.catID FK__CategoryT__catID__6E17311D C

Category reference - Links to Category table for the category being assigned

Relationships

Close relationships within degrees of separation