applicationassets
Static assets and files belonging to ZeyOS applications.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | bigint | Asset ID | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
creationdate | bigint | EXTRACT(epoch FROM 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) | |
application applications.ID | integer | Application ID (**dependency**) | ||
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_applicationassets_binfile | btree | binfile | ||||
| pk_applicationassets | btree | ID | ||||
| u_applicationassets_application_filename | btree | application, filename |
| Name | Type |
|---|---|
| dc_applicationassets_filename | check |
| dc_applicationassets_mimetype | check |
| fk_applicationassets_application | foreign_key |
| fk_applicationassets_binfile | foreign_key |
| pk_applicationassets | primary_key |
| u_applicationassets_application_filename | unique |
Loading...