Fields (28)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | binary(16) | NO | PRI | NULL | |
| name | varchar(255) | NO | UNI | NULL | |
| path | varchar(4096) | YES | NULL | ||
| author | varchar(255) | YES | NULL | ||
| copyright | varchar(255) | YES | NULL | ||
| license | varchar(255) | YES | NULL | ||
| privacy | varchar(255) | YES | NULL | ||
| version | varchar(255) | NO | NULL | ||
| base_app_url | varchar(1024) | YES | NULL | ||
| active | tinyint(1) | NO | 0 | ||
| allow_disable | tinyint(1) | NO | 1 | ||
| configurable | tinyint(1) | NO | 0 | ||
| icon | mediumblob | YES | NULL | ||
| app_secret | varchar(255) | YES | NULL | ||
| modules | json | YES | NULL | ||
| main_module | json | YES | NULL | ||
| cookies | json | YES | NULL | ||
| allowed_hosts | json | YES | NULL | ||
| integration_id | binary(16) | NO | MUL | NULL | |
| acl_role_id | binary(16) | NO | MUL | NULL | |
| created_at | datetime(3) | NO | NULL | ||
| updated_at | datetime(3) | YES | NULL | ||
| template_load_priority | int | YES | 0 | ||
| checkout_gateway_url | varchar(255) | YES | NULL | ||
| self_managed | tinyint(1) | NO | 0 | ||
| source_type | varchar(20) | NO | local | ||
| source_config | json | NO | json_object() | DEFAULT_GENERATED | |
| in_app_purchases_gateway_url | varchar(255) | YES | NULL |
Indexes (4)
| Name | Columns | Unique |
|---|---|---|
| fk.app.acl_role_id | acl_role_id | No |
| fk.app.integration_id | integration_id | No |
| PRIMARY | id | Yes |
| uniq.name | name | Yes |