| PKID | bigint | plain | | | File ID |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| creationdate | bigint | plain | | | Default: date_part('epoch', 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) |
| record | bigint | plain | | records.ID | Record ID (**dependency**); is mutually exclusive to `comment` (either one is required) |
| comment | bigint | plain | | comments.ID | Comment ID (**dependency**); is mutually exclusive to `record` (either one is required) |
| filename | text | main | | | Default: ''Filename |
| mimetype | text | main | | | Default: 'application/octet-stream'MIME type (RFC 2045) |
| binfile | integer | plain | | binfiles.ID | Binary file ID; is read-only (not for `PUT` or `PATCH`) |