Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
||||||
| location_business_line_id | VARCHAR | 36 | null |
|
|
||||||
| rule_key | VARCHAR | 100 | null |
|
|
Unique key e.g., MAX_HOURS_AFTER_SERVICE |
|||||
| name | VARCHAR | 200 | null |
|
|
Display name |
|||||
| description | TEXT | 65535 | √ | null |
|
|
Description of what this rule validates |
||||
| parameters_schema_json | JSON | 1073741824 | √ | null |
|
|
JSON Schema for rule parameters e.g., {“maxHours”: “number”} |
||||
| default_error_message | VARCHAR | 500 | √ | null |
|
|
Default message when rule fails |
||||
| is_active | BIT | 1 | 1 |
|
|
||||||
| created_at | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
||||||
| updated_at | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
||||||
| created_by | VARCHAR | 36 | √ | null |
|
|
|||||
| updated_by | VARCHAR | 36 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_encounter_rule_types_is_active | Performance | Asc | is_active |
| idx_encounter_rule_types_key | Performance | Asc | rule_key |
| idx_encounter_rule_types_location | Performance | Asc | location_business_line_id |
| uk_encounter_rule_types_key_location | Must be unique | Asc/Asc | location_business_line_id + rule_key |