RegExp


Description

Regular expression validation patterns managing validation rules and patterns for data input validation across the healthcare system. This table stores regular expression patterns with names, descriptions, and warning messages, supporting data validation, input formatting, and data quality control for forms, fields, and user input throughout the healthcare application.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkRegExpID int identity 4 √ null
FlexFormSettings.fkRegExpID FK_FlexFormSettings_RegExp R

Primary key - Unique identifier for each regular expression pattern
RegExpName varchar 50 √ null

Pattern name - Descriptive name for the regular expression pattern
RegExpDesc varchar 200 √ null

Pattern description - Detailed description of what the regular expression validates
RegExpPattern varchar 1000 √ null

Regular expression - The actual regular expression pattern used for validation
WarningMessage varchar 300 √ null

Validation message - Warning or error message displayed when validation fails

Indexes

Constraint Name Type Sort Column(s)
PK__RegExp__D221A83A0C422042 Primary key Asc pkRegExpID

Relationships

Close relationships within degrees of separation