Data Models
This section provides the entity relationship tables with the details of the entities and relationships among them. Data Model is an abstract model that organizes elements of data and standardizes how they relate to one another and to the properties of real-world entities.
Viewing ms_inbox_events
Inbox table helps microservice to log all the incoming event records received in the database. Inbox plays critical role in achieving idempotency by handling duplicates using Inbox infrastructure.
|
Name |
Java Data type |
Remarks |
|---|---|---|
|
eventId |
java.lang.String |
Primary Key Identifier of the event, Unique identifier (UUID) |
|
commandType |
java.lang.String |
Identifier of the Command type |
|
creationTime |
java.util.Date |
Indicates the creation time of event |
|
eventDetails |
java.lang.String |
Additional Event metadata (as name-value pair) |
|
eventSourceId |
java.lang.String |
Indicates source of event |
|
eventType |
java.lang.String |
Identifier of type of event |
|
organizationId |
java.lang.String |
Identifier of the Organization |
|
payload |
java.lang.String |
Payload data of the event |
|
priority |
java.lang.Integer |
Indicates event's Priority for delivery |
|
processedTime |
java.util.Date |
Indicates the processed time of event |
|
status |
java.lang.String |
Possible Values “NEW”, PROCESSED”, “FAILED” |
|
tenantId |
java.lang.String |
Identifier of the tenant |
|
userId |
java.lang.String |
Identifier of the user |
Viewing ms_outbox_events
Outbox table maintains all the events raised from the microservice. The events records get deleted once the events are successfully delivered to the target application. This table is used to store the processed business or command events inside the database. The below entity relationship tables depict the details of the entities and relationships among them.
|
Name |
Java Data type |
Remarks |
|---|---|---|
|
eventId |
java.lang.String |
Primary Key Identifier of the event, Unique identifier (UUID) |
|
correlationId |
java.lang.String |
Identifier of the Command type |
|
creationTime |
java.util.Date |
Indicates the creation time of event |
|
eventDetails |
java.lang.String |
Additional Event metadata (as name-value pair) |
|
eventType |
java.lang.String |
Identifier of type of event |
|
eventDate |
java.util.Date |
Indicates the date of event |
|
organizationId |
java.lang.String |
Identifier of the Organization |
|
payload |
java.lang.String |
Payload data of the event |
|
priority |
java.lang.Integer |
Indicates event's Priority for delivery |
|
processedTime |
java.util.Date |
Indicates the processed time of event |
|
status |
java.lang.String |
Possible Values “NEW”, DELIVERED”, “FAILED” |
|
tenantId |
java.lang.String |
Identifier of the tenant |
|
userId |
java.lang.String |
Identifier of the user |
The following are the microservice tables.
ms_entitlements_entitlement:
|
Name |
NOSQL Data Type |
Java Data type |
Remarks |
|---|---|---|---|
|
userId |
text |
java.lang.String |
Partition Key |
|
accountEntitlementList |
text |
java.lang.String |
|
ms_entitlements_entitlementdata:
|
Name |
NOSQL Data Type |
Java Data type |
Remarks |
|---|---|---|---|
|
partitionKey |
text |
java.lang.String |
Partition Key |
|
resourceField |
text |
java.lang.String |
Sort Key |
|
roleId |
list<text> |
ArrayList<java.lang.String> |
|
|
userId |
text |
java.lang.String |
|
|
resourceId |
text |
java.lang.String |
|
|
resourceCategory |
text |
java.lang.String |
|
|
resourceFilter |
text |
java.lang.String |
|
|
serviceid |
text |
java.lang.String |
|
|
channelid |
text |
java.lang.String |
|
|
customfilterid |
text |
java.lang.String |
|
In this topic
