SearchCategory


Description

Search category definitions that organize search functionality into categories, enabling categorized search capabilities and improved search result organization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CategoryDescription Unknown 0 null

Category description - Description of the search category

CategoryId Unknown 0 null

Primary key - SearchCategory unique identifier for each search category

CategoryName Unknown 0 null

Category name - Name of the search category

CatSearchID int identity 4 null

Reference identifier - Foreign key reference to related entity or lookup table

CatID int 4 null

Reference identifier - Foreign key reference to related entity or lookup table

IncID int 4 null

Reference identifier - Foreign key reference to related entity or lookup table

Displayorder int 4 null

Numeric value - Quantity, count, or numeric measurement for SearchCategory records

IsActive Unknown 0 null

Active status - Whether this search category is currently available

SearchScope Unknown 0 null

Search scope - Scope of searches in this category

Indexes

Constraint Name Type Sort Column(s)
PK_SearchCategory Primary key Asc CatSearchID

Relationships