files
File attachments linked to records or comments.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | bigint | File ID | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | EXTRACT(epoch FROM now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
record records.ID | bigint | Record ID (**dependency**); is mutually exclusive to `comment` (either one is required) | ||
comment comments.ID | bigint | Comment ID (**dependency**); is mutually exclusive to `record` (either one is required) | ||
binfile binfiles.ID | integer | Binary file ID; is read-only (not for `PUT` or `PATCH`) | ||
filename | text | '' | Filename | |
mimetype | text | 'application/octet-stream' | MIME type (RFC 2045) |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_files_binfile | btree | binfile | ||||
| fk_files_comment | btree | comment | ||||
| fk_files_record | btree | record | ||||
| pk_files | btree | ID | ||||
| s_files_filename | gin | filename |
| Name | Type |
|---|---|
| c_files_association | check |
| dc_files_filename | check |
| dc_files_mimetype | check |
| fk_files_binfile | foreign_key |
| fk_files_comment | foreign_key |
| fk_files_record | foreign_key |
| pk_files | primary_key |
Loading...