regular_expressions
Purpose
Section titled “Purpose”Stores named regex patterns used in pattern-type custom format conditions. The optional regex101_id links to regex101.com for interactive testing; description documents the pattern purpose.
Columns
Section titled “Columns”| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
id |
INTEGER | Yes | — | — |
name |
VARCHAR(100) | No | — | — |
pattern |
TEXT | No | — | — |
regex101_id |
VARCHAR(50) | Yes | — | Optional link to regex101.com for testing |
description |
TEXT | Yes | — | — |
created_at |
TEXT | No | CURRENT_TIMESTAMP | — |
updated_at |
TEXT | No | CURRENT_TIMESTAMP | — |
Relationships
Section titled “Relationships”Referenced by:
Constraints
Section titled “Constraints”- Primary key: (id)
- Unique: UNIQUE (name)