| id | binary(16) | NO | Primary Key |
| name | varchar(255) | NO | Unique |
| path | varchar(4096) | YES | |
| author | varchar(255) | YES | |
| copyright | varchar(255) | YES | |
| license | varchar(255) | YES | |
| privacy | varchar(255) | YES | |
| version | varchar(255) | NO | |
| base_app_url | varchar(1024) | YES | |
| active | tinyint(1) | NO | Default: 0 |
| allow_disable | tinyint(1) | NO | Default: 1 |
| configurable | tinyint(1) | NO | Default: 0 |
| icon | mediumblob | YES | |
| app_secret | varchar(255) | YES | |
| modules | json | YES | |
| main_module | json | YES | |
| cookies | json | YES | |
| allowed_hosts | json | YES | |
| integration_id | binary(16) | NO | Index
Foreign Key → integration.id |
| acl_role_id | binary(16) | NO | Index
Foreign Key → acl_role.id |
| created_at | datetime(3) | NO | |
| updated_at | datetime(3) | YES | |
| template_load_priority | int | YES | Default: 0 |
| checkout_gateway_url | varchar(255) | YES | |
| self_managed | tinyint(1) | NO | Default: 0 |
| source_type | varchar(20) | NO | Default: local |
| source_config | json | NO | Default: json_object(), DEFAULT_GENERATED |
| in_app_purchases_gateway_url | varchar(255) | YES | |
| requested_privileges | json | NO | Default: json_array(), DEFAULT_GENERATED |
| context_gateway_url | varchar(255) | YES | |
