Base
The minimal schema for ONE ERP startup.
- 1 Schema
- 2 Organization and security
- 2.1 organization
- 2.2 business_unit
- 2.3 role
- 2.4 privilege
- 2.5 role_security
- 2.6 entity_security
- 2.7 user
- 2.8 user_role
- 2.9 user_organization
- 2.10 user_business_unit
- 3 Storage
- 4 Workflows
- 4.1 wf
- 4.2 wf_event
- 4.3 wf_listener
- 4.4 wfi
- 4.5 wfi_stack_trace
Schema
customization_set
Read-Only system entity.
Field | Type | Description |
|---|---|---|
name | String | The name of the customization set |
prefix | String |
customization_set_dependency
Read-Only system entity.
Field | Type | Description |
|---|---|---|
id_customization_set | Foreign Key | |
id_customization_set_parent | Foreign Key |
customization_set_entity
Read-Only system entity.
Field | Type | Description | Since |
|---|---|---|---|
name | String | ||
is_public | Int | ||
is_customizable | Int | ||
id_customization_set | Foreign Key | ||
is_acl_enabled | Int | 1.6.0 |
customization_set_property
Read-Only system entity.
Field | Type | Description | Since |
|---|---|---|---|
name | String | ||
is_required | Int | ||
is_customizable | Int | ||
default_value | String | ||
property_type | String | ||
id_customization_set | Foreign Key | ||
id_customization_set_entity | Foreign Key |
customization_set_relationship
Read-Only system entity.
Field | Type | Description | Since |
|---|---|---|---|
name | String | ||
is_required | Int | ||
relationship_type | String | ||
cascading_rule | String | ||
property_name | String | ||
foreign_property_name | String | ||
sort_property_name | String | ||
sort_asc | Int | ||
id_customization_set_entity | Foreign Key | ||
id_foreign_entity | Foreign Key | ||
id_customization_set | Foreign Key |
cs_entity_alter
Read-Only system entity.
Since 1.6.0
Field | Type | Description | Since |
|---|---|---|---|
name | String | n/a - planned | |
id_customization_set | Foreign Key | 1.6.0 | |
is_acl_enabled | Int | 1.6.0 | |
original_is_acl_enabled | Int | 1.6.0 | |
original_name | String | n/a - planned |
cs_property_alter
Read-Only system entity.
n/a - planned
Field | Type | Description | Since |
|---|---|---|---|
name | String | n/a - planned | |
is_required | Int | n/a - planned | |
default_value | String | n/a - planned | |
property_type | String | n/a - planned | |
id_customization_set | Foreign Key | n/a - planned | |
id_customization_set_entity | Foreign Key | n/a - planned | |
original_name | Int | n/a - planned | |
original_is_required | Int | n/a - planned | |
original_default_value | String | n/a - planned | |
original_property_type | String | n/a - planned |
cs_relationship_alter
Read-Only system entity.
n/a - planned
Field | Type | Description | Since |
|---|---|---|---|
name | String | n/a - planned | |
is_required | Int | n/a - planned | |
relationship_type | String | n/a - planned | |
property_name | String | n/a - planned | |
foreign_property_name | String | n/a - planned | |
sort_property_name | String | n/a - planned | |
sort_asc | Int | n/a - planned | |
id_customization_set_entity | Foreign Key | n/a - planned | |
id_foreign_entity | Foreign Key | n/a - planned | |
id_customization_set | Foreign Key | n/a - planned | |
original_is_required | Int | n/a - planned | |
original_relationship_type | String | n/a - planned | |
original_property_name | String | n/a - planned | |
original_foreign_property_name | String | n/a - planned | |
original_sort_property_name | String | n/a - planned | |
original_sort_asc | Int | n/a - planned |
entity
Read-Only system entity.
Field | Type | Description |
|---|---|---|
name | String | |
is_public | Int | |
is_customizable | Int | |
id_customization_set | Int |
entity_property
Read-Only system entity.
Field | Type | Description |
|---|---|---|
name | String | |
is_required | Int | |
is_customizable | Int | |
default_value | String | |
property_type | String | |
id_customization_set | Foreign Key | |
id_entity | Foreign Key |
entity_relationship
Read-Only system entity.
Field | Type | Description |
|---|---|---|
name | String | |
is_required | Int | |
relationship_type | String | |
cascading_rule | String | |
property_name | String | |
foreign_property_name | String | |
sort_property_name | String | |
sort_asc | Int | |
id_entity | Foreign Key | |
id_foreign_entity | Foreign Key | |
id_customization_set | Foreign Key |
Organization and security
organization
Writable system entity.
Field | Type | Description |
|---|---|---|
name | String | The name of the organization. |
business_unit
Writable system entity.
Field | Type | Description | Since |
|---|---|---|---|
name | String | The name of the business unit. | 1.0.0 |
x | Int | 1.6.0 | |
y | Int | 1.6.0 | |
id_parent_business_unit | Foreign Key | 1.6.0 |
role
Writable system entity.
Field | Type | Description |
|---|---|---|
name | String | The name of the role. |
privilege
Writable system entity.
Field | Type | Description |
|---|---|---|
name | String | The name of the privilege. |
role_security
Writable system entity.
Field | Type | Description |
|---|---|---|
allow | Int | |
id_role | Foreign Key | |
id_privilege | Foreign Key |
entity_security
Writable system entity.
Field | Type | Description |
|---|---|---|
scope | String | |
allow | Int | |
id_entity | Foreign Key | |
id_role | Foreign Key | |
id_privilege | Foreign Key |
user
Writable system entity.
Field | Type | Description |
|---|---|---|
name | STRING | |
password | STRING | |
authentication_provider | STRING | |
full_name | STRING | |
id_organization | Foreign Key | |
id_business_unit | Foreign Key |
user_role
Writable system entity.
Field | Type | Description |
|---|---|---|
id_user | Foreign Key | |
id_role | Foreign Key |
user_organization
Field | Type | Description | Since |
|---|---|---|---|
id_user | Foreign Key | 1.6.0 | |
id_organization | Foreign Key | 1.6.0 |
user_business_unit
Field | Type | Description | Since |
|---|---|---|---|
id_user | Foreign Key | 1.6.0 | |
id_business_unit | Foreign Key | 1.6.0 |
Storage
storage_file
Field | Type | Description |
|---|---|---|
uuid | String | Global unique identifier. |
storage_name | String | The name of the file as is found in the local storage. Changes with every version. |
file_name | String | The file name as uploaded by the user. |
file_hash | String | MD5 hash of the file content. |
file_size | Int | The size in bytes. |
content_type | String | The content type. |
version | Int | The version. |
storage_indexed_content | String31 | The indexed content. |
invalid_content | Int | If the file is unavailable for indexing or has an invalid content. |
storage_file_version
Field | Type | Description | Since |
|---|---|---|---|
uuid | String | ||
storage_name | String | The name of the file as is found in the local storage. Changes with every version. | |
file_name | String | The file name as uploaded by the user. | |
file_hash | String | MD5 hash of the file content. | |
file_size | Int | The size in bytes. | 1.4.1 |
content_type | String | The content type. | |
version | Int | The version. | |
id_storage_file | Foreign Key | Relation to the file being versioned. |
storage_file_meta
The entity is not corectly related to storage_file and is no longer part of the Storage service.
Field | Type | Description |
|---|---|---|
tag | String | The label name |
value | String | The label value |
id_storage_file | Foreign Key | Relation to the file being metadated. |
storage_file_tag
Replacement for the storage_file_meta entity and is part of the optional Storage Indexing service. The entity is not corectly related to storage_file.
Field | Type | Description |
|---|---|---|
tag | String | The label name |
value | String | The label value |
id_storage_file | Foreign Key | Relation to the file being metadated. |
Workflows
wf
Field | Type | Description |
|---|---|---|
uuid | String | |
name | String | |
source | String31 | |
code | BLOB |
wf_event
Key | Name | UUID |
|---|---|---|
1 | onBeforeInsert | 6a1422d5-ed8f-45f3-b3db-60d8ccba8ffd |
2 | onBeforeUpdate | b270ac92-7f11-4aa4-850b-af3691bc92f9 |
3 | onBeforeDelete | 836b72a3-df57-4c4e-86ac-24a81b0f0d05 |
4 | onAfterInsert | 6c34eed3-fceb-467e-961c-9f51bcbe727a |
5 | onAfterUpdate | b0d642b0-b669-4ed8-b177-910732de98ff |
6 | onAfterDelete | 62c57dcd-a762-4284-8127-391f33ff21dc |
7 | onCompleteInsert | c86d5415-3187-4a3c-850e-783e89a2c266 |
8 | onCompleteUpdate | d6082b49-893f-4ba8-b2e2-84561092ed5c |
9 | onCompleteDelete | d886ce8a-af38-446e-826f-abec1f520bdb |
wf_listener
Field | Type | Description |
|---|---|---|
entity_name | String | |
uuid | String | |
id_wf | Foreign Key | |
id_wf_event | Foreign Key | |
id_entity | Foreign Key |
wfi
Field | Type | Description |
|---|---|---|
last_error | String31 | |
id_wf | Foreign Key |
wfi_stack_trace
Field | Type | Description |
|---|---|---|
workflow | String | |
method | String | |
line_number | Int | |
id_wfi | Foreign Key | |
id_wf | Foreign Key |