Email field
An email address with validation. Stored as VARCHAR(255). The validator checks for RFC-compliant formatting and a valid TLD.
Configuration
| Setting | Default | Notes |
|---|---|---|
| Required | no | |
| Default value | (none) | |
| Unique | no | Enforce one-email-per-entity |
| Allowed domains | (all) | Comma-separated whitelist of domains |
| Blocked domains | (none) | Comma-separated blacklist (disposable email domains, competitors, etc.) |
| Indexed | no | Recommended if you query by email frequently |
Form rendering
<input type="email"> with native browser validation plus server-side validation on save.
List rendering
As a clickable mailto: link. Truncated at column width with ellipsis.
EQL operators supported
:, !=, ~=, ~^, ~$, is null, is not null. Matching is case-insensitive.