Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| serviceTypeid | int identity | 4 | √ | null |
|
|
Type classification - Category or classification type for ServiceType records, ensuring consistent service categorization across the multi-tenant system |
||||
| ServiceType | varchar | 10 | √ | null |
|
|
Service type code - Short code or abbreviation for the service type, used in cross-database views for standardized service identification and billing |
||||
| ServiceDesc | varchar | 100 | √ | null |
|
|
Service description - Detailed description of the service type, displayed in client database views for comprehensive service documentation |
||||
| display | int | 4 | √ | null |
|
|
Display flag - Whether this service type is displayed in user interfaces across all integrated client systems |
||||
| sCode | nvarchar | 10 | √ | null |
|
|
Service code - Additional service code for billing or reporting purposes, used for regulatory compliance and standardized reporting across all databases |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ServiceType | Primary key | Asc | serviceTypeid |