| PKID | integer | plain | | | Application 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: date_part('epoch', 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 application identifier |
| version | integer | plain | | | Default: 10000Version number (formatted as 1.00-00) |
| vendor | text | extended | | | Default: ''Vendor (developer or company name) |
| restricted | smallint | plain | | | Default: 0Restricted access via permission with same identifier |
| callbackurls | text[] | extended | | | Array-encoded allowed callback URLs for APIs |
| settingsbinfile | integer | plain | | binfiles.ID | No description provided. |
| usersettingsbinfile | integer | plain | | binfiles.ID | No description provided. |
| secret | bytea | extended | | | No description provided. |
| defaultsettings | json | extended | | | No description provided. |
| settings | json | extended | | | No description provided. |