Entity Designer Sender and Consumer Details
Save Schema:
Processing of save_schema:
When you are click the save button, it will internally invokes the save_schema API.
Save_schema API url : https://arangodbservice.dev.ainqaplatform.in/api/save_schema
The save schema related entities are stored into metadatadb.
Below mentioned collections are Consumes in save_schema API.
client_vs_db_stg
entity_fields_stg
entity_group_stg
entity_relationship_stg
entity_grouprelation_stg
Then in UI background, it will invoke the getschema API, this API will return the stored entity details.
get_schema API url : https://arangodbservice.dev.ainqaplatform.in/api/get_schema
Publish Schema:
Processing of publish_schema:
After getting the result from get schema API(UI).
Then we have to click the publish schema button, This API will create the database and collections with schema in ArangoDB server.
Below mentioned collections are consumes in publish_schema API.
client_vs_db_stg
entity_fields_published
entity_relationship_published
entity_grouprelation_published
publish_schema API :https://arangodbservice.dev.ainqaplatform.in/api/publish_schema
Collections with details
| Collection Name | Usage |
| client_vs_db_stg | This collection used to store the metadata details after processing the save schema |
| entity_fields_stg | This collection used to store the entity field properties after processing the save schema |
| entity_group_stg | This collection used to store the entity group group properties after processing the save schema |
| entity_relationship_stg | This collection used to store the entity relationship properties after processing the save schema |
| entity_grouprelation_stg | This collection used to store entity group relation properties after processing the save schema |
| entity_fields_published | This collection used to store entity fields properties after processing the publish schema |
| entity_relationship_published | This collection used to store entity relationship published properties after processing the publish schema |
| entity_grouprelation_published | This collection used to store entity group relation published properties after processing the publish schema |
Collection attributes with details
Collection Name: client_vs_db_stg
| Attributes | Usage |
| client | This attribute used to store the client name. |
| db_name | This attribute used to stote the db name |
| metadataId | This attribute used to store the entity designer metadataid |
| projectId | This attribute used to store the projectid |
| clientId | This attribute used to store the clientid |
| active | This attribute stores the value of(Y/N) which makes metadataId active or inactive. |
| metadbname | This attribute used to store the clientid metadata dbname |
| activestatus | This attribute stores the boolen value of(true/false) which makes metadataId active or inactive. |
Collection Name: entity_fields_stg
| Attributes | Usage |
| entity | This attribute used to store the entity name. |
| status | This attribute used to store the draft value |
| db_objectname | This attribute used to store entity name |
| fields | This attribute used to stores the entity fields and its properties |
| indexes | This attribute used to store the indexes |
| entity_group_name | This attribute used to store entity group name |
| isActivity | This attribute used to stores the boolean value(true/false) |
| type | This attribute used to store the entity group name. |
| activity | This attribute used to store the boolean value of create,delete,update |
| attributes | This attribute used to store the entity properties |
| client | This attribute used to store the client name |
| metadataId | This attribute used to store the metadataid |
| projectId | This attribute used to store the projectid |
| clientId | This attribute used to store the clientid |
| entitycode | This attribute used to store the entitycode |
| active | This attribute used to store the store value(Y/N) active or not |
| activestatus | This attribute used to store boolean value(true/false) is active or not. |
Collection Name: entity_fields_published
| Attributes | Usage |
| active | This attribute used to store the store value(Y/N) active or not |
| activity | This attribute used to store the boolean value of create,delete,update |
| attributes | This attribute used to store the entity properties |
| client | This attribute stores the client name |
| clientId | This attribute store the clientId |
| db_objectname | This attribute store the entity name |
| entity | This attribute stores the entity name |
| entity_group_name | This attribute store the entity group name |
| entitycode | This attribute store the entitycode |
| fields | This attribute store the entity fields and its properties |
| indexes | This attribute store the indexes |
| isActivity | This attribute store the boolean value of create,delete,update |
| metadataId | This attribute store the metadataId |
| projectId | This attribute store the projectId |
| Status | This attribute store the publish or not |
| version | This attribute store the version of entity_fields_published |
Collection Name: entity_relationship_stg
| Attributes | Usage |
| attributes | This attribute used to store the entity properties |
| status | This attribute used to stote the publish or not |
| entity | This attribute used to store the entity name |
| version | This attribute stores the the version of entity_relationship_stg |
| target_entity | This attribute stores the destination relation entity |
| relationship | This attribute stores the relationship between to two entities. |
| entity_objectname | This attribute stores the entityname |
| target_entity_objectname | This attribute stores the destination relation entity |
| db_objectname | This attribute stores the entity name |
| sourceColumn | This attribute stores the source column relation id |
| sourceDatatype | This attribute stores the source relation id datatype |
| targetColumn | This attribute stores the destination column relation id |
| targetDatatype | This attribute stores the destination relation id datatype |
| operator | This attribute stores the relationship operator For example(“==”) |
| client | This attribute stores the client name |
| active | This attribute stores the value(Y/N) active or not |
| metadataId | This attribute stores the metadataid |
| projectId | This attribute stores the projectid |
| relationId | This attribute stores the unique relationid |
| activestatus | This attribute stores the boolean value(true/false) is active or not. |
Collection Name: entity_relationship_published
| Attributes | Usage |
| active | This attribute used to store the value(Y/N) active or not. |
| attributes | This attribute used to store the entity properties |
| client | This attribute used to store the client name |
| db_objectname | This attribute stores the entity name |
| entity | This attribute stores the entity name |
| entity_objectname | This attribute stores the entity name |
| metadataId | This attribute stores the metadataid |
| operator | This attribute stores the relationship operator For example(“==”) |
| projectId | This attribute stores the projectid |
| relationId | This attribute stores the unique relationid |
| relationship | This attribute stores the relationship between to two entities. |
| sourceColumn | This attribute stores the source column relation id |
| sourceDatatype | This attribute stores the source relation id datatype |
| status | This attribute stores the publish or not |
| targetColumn | This attribute stores the destination column relation id |
| targetDatatype | This attribute stores the destination relation id datatype |
| target_entity | This attribute stores the destination relation entity |
| target_entity_objectname | This attribute stores the destination relation entity |
| version | This attribute stores the version of entity_relationship_published |
Collection Name: entity_group_stg
| Attributes | Usage |
| client | This attribute used to store the client name. |
| clientId | This attribute used to stote the clientId |
| entity_group_name | This attribute used to store the entity group name |
| entity | This attribute stores the entityname |
| status | This attribute stores the role uniqueid |
| metadbname | This attribute stores the metadatadbname |
| version | This attribute stores the version of entity_group_stg |
| active | This attribute stores the value(Y/N) active or not |
| db_objectname | This attribute stores the entityname |
| metadataId | This attribute stores the metadataId |
| projectId | This attribute stores the projectId |
| activestatus | This attribute stores the boolean value(true/false) is active or not |
Collection Name: entity_grouprelation_stg
| Attributes | Usage |
| status | This attribute used to store the publish or not. |
| entity | This attribute used to stote the entityname |
| version | This attribute used to store the version of entity_grouprelation_stg |
| FromCollection | This attribute stores the source collection name |
| ToCollection | This attribute stores the destination collection name |
| FromColumnName | This attribute stores the source collection relation field |
| ToColumnName | This attribute stores the destination collection relation field |
| SeqNo | This attribute stores Seqno of entity_grouprelation_stg collection records |
| client | This attribute stores the client name |
| active | This attribute stores the value(Y/N) active or not |
| metadataId | This attribute stores the metadataId |
| projectId | This attribute stores the projectid |
| activestatus | This attribute stores the boolean value(true/false) is active or not |
| groupId | This attribute stores the groupId |
| FromColumnDataType | This attribute stores the source field data type |
| ToColumnDataType | This attribute stores the destination field data types |
Collection Name: entity_grouprelation_published
| Attributes | Usage |
| status | This attribute used to store the publish or not. |
| entity | This attribute used to store the entityname |
| version | This attribute used to store the version of entity_grouprelation_published |
| FromCollection | This attribute stores the source collection name |
| ToCollection | This attribute stores the destination collection name |
| FromColumnName | This attribute stores the source collection relation field |
| ToColumnName | This attribute stores the destination collection relation field |
| SeqNo | This attribute stores Seqno of entity_grouprelation_published collection records |
| client | This attribute stores the client name |
| active | This attribute stores the value(Y/N) active or not |
| metadataId | This attribute stores the metadataid |
| projectId | This attribute stores the projectid |
| activestatus | This attribute stores the boolean value(true/false) is active or not. |
| groupId | This attribute stores the groupId |
| FromColumnDataType | This attribute stores the source field data type |
| ToColumnDataType | This attribute stores the destination field data types |
Production Collection
client_vs_db_stg
entity_fields_published
entity_relationship_published
entity_grouprelation_published