| PKID | integer | plain | | | Custom field ID |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| creationdate | bigint | plain | | | Default: EXTRACT(epoch FROM now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) |
| lastmodified | bigint | plain | | | Default: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification) |
| activity | smallint | plain | | | Default: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED) |
| name | text | main | | | Name |
| identifier | character varying(200) | main | | | Unique field identifier |
| context | text | main | | | Context (mainly entity) |
| source | smallint | plain | | | Default: 0Data source (`0`=EXTDATA, `1`=TAGS, `2`=INTERNAL) |
| reference | text | main | | | Data reference (extdata field name or tag name) |
| indexed | smallint | plain | | | Default: 0Indexed |
| type | text | main | | | Default: ''Data type |
| entity | t_entity | plain | | | Canonical entity; only for `type`=`entity` |
| options | json | extended | | | JSON-encoded option values and labels (array or object); only relevant for `type`=`list` |
| langaliases | json | extended | | | JSON-encoded language-specific aliases (object); use language code as object key |
| pattern | text | extended | | | Default: ''No description provided. |