Service Design Specification
ebaycclone-ordermanagement-service documentation
-Version:1.0.16
Scope
This document provides a structured architectural overview of the
orderManagement
microservice, detailing its configuration, data model,
authorization logic, business rules, and API design. It has been
automatically generated based on the service definition within
Mindbricks, ensuring that the information reflects the source of
truth used during code generation and deployment.
The document is intended to serve multiple audiences:
- Service architects can use it to validate design decisions and ensure alignment with broader architectural goals.
- Developers and maintainers will find it useful for understanding the structure and behavior of the service, facilitating easier debugging, feature extension, and integration with other systems.
- Stakeholders and reviewers can use it to gain a clear understanding of the service's capabilities and domain logic.
Note for Frontend Developers: While this document is valuable for understanding business logic and data interactions, please refer to the Service API Documentation for endpoint-level specifications and integration details.
Note for Backend Developers: Since the code for this service is automatically generated by Mindbricks, you typically won't need to implement or modify it manually. However, this document is especially valuable when you're building other services—whether within Mindbricks or externally—that need to interact with or depend on this service. It provides a clear reference to the service's data contracts, business rules, and API structure, helping ensure compatibility and correct integration.
OrderManagement
Service Settings
Edit
Handles all marketplace orders, manual checkout flows for fixed-price/offer/auction settlements, Stripe payment processing and webhook reconciliation, explicit status updates (shipping, delivery, cancellation), and feedback eligibility via orderItems.
Service Overview
This service is configured to listen for HTTP requests on port
3004, serving both the main API interface and default administrative
endpoints.
The following routes are available by default:
-
API Test Interface (API Face):
/ -
Swagger Documentation:
/swagger -
Postman Collection Download:
/getPostmanCollection -
Health Checks:
/healthand/admin/health -
Current Session Info:
/currentuser -
Favicon:
/favicon.ico
The service uses a PostgreSQL database for data
storage, with the database name set to
ebaycclone-ordermanagement-service.
This service is accessible via the following environment-specific URLs:
-
Preview:
https://ebaycclone.prw.mindbricks.com/ordermanagement-api -
Staging:
https://ebaycclone-stage.mindbricks.co/ordermanagement-api -
Production:
https://ebaycclone.mindbricks.co/ordermanagement-api
Authentication & Security
- Login Required: Yes
This service requires user authentication for access. It supports both JWT and RSA-based authentication mechanisms, ensuring secure user sessions and data integrity. If a crud route also is configured to require login, it will check a valid JWT token in the request query/header/bearer/cookie. If the token is valid, it will extract the user information from the token and make the fetched session data available in the request context.
Service Data Objects
The service uses a PostgreSQL database for data
storage, with the database name set to
ebaycclone-ordermanagement-service.
Data deletion is managed using a
soft delete strategy. Instead of removing records
from the database, they are flagged as inactive by setting the
isActive
field to
false.
| Object Name | Description | Public Access |
|---|---|---|
orderManagementOrder
|
Marketplace order record. Stores buyer, shipping, status, items, Stripe payment data, and manual shipment/delivery events. Only accessible to admins or the buyer/seller of order items. | accessPrivate |
orderManagementOrderItem
|
Order line item representing purchase of a single product from a specific seller as part of an order. Enables feedback, delivery, and per-seller analytics. Immutable after order creation. | accessPrivate |
sys_orderManagementOrderPayment
|
A payment storage object to store the payment life cyle of orders based on orderManagementOrder object. It is autocreated based on the source object's checkout config | accessPrivate |
sys_paymentCustomer
|
A payment storage object to store the customer values of the payment platform | accessPrivate |
sys_paymentMethod
|
A payment storage object to store the payment methods of the platform customers | accessPrivate |
orderManagementOrder Data Object
Object Overview
Description: Marketplace order record. Stores buyer, shipping, status, items, Stripe payment data, and manual shipment/delivery events. Only accessible to admins or the buyer/seller of order items.
This object represents a core data structure within the service
and acts as the blueprint for database interaction, API
generation, and business logic enforcement. It is defined using
the
ObjectSettings
pattern, which governs its behavior, access control, caching
strategy, and integration points with other systems such as Stripe
and Redis.
Core Configuration
-
Soft Delete: Enabled — Determines whether
records are marked inactive (
isActive = false) instead of being physically deleted. - Public Access: accessPrivate — If enabled, anonymous users may access this object’s data depending on API-level rules.
Composite Indexes
- orderNumberUniqueIdx: [orderNumber] This composite index is defined to optimize query performance for complex queries involving multiple fields.
The index also defines a conflict resolution strategy for duplicate key violations.
When a new record would violate this composite index, the following action will be taken:
On Duplicate:
throwError
An error will be thrown, preventing the insertion of conflicting data.
Stripe Integration
This data object is configured to integrate with Stripe for order
management of
orderManagementOrder. It is designed to handle payment processing and order tracking.
To manage payments, Mindbricks will design additional Business API
routes arround this data object, which will be used checkout
orders and charge customers.
-
Order Name:
orderManagementOrder -
Order Id Property: this.orderManagementOrder.id This MScript expression is used to extract the order's unique identifier from the data object.
-
Order Amount Property: this.orderManagementOrder.summary.total This MScript expression is used to determine the order amount for payment. It should return a numeric value representing the total amount to be charged.
-
Order Currency Property: this.orderManagementOrder.summary.currency This MScript expression is used to determine the currency for the order. It should return a string representing the currency code (e.g., "USD", "EUR").
-
Order Description Property:
Order #${this.orderManagementOrder.orderNumber} for buyerId ${this.orderManagementOrder.buyerId}This MScript expression is used to provide a description for the order, which will be shown in Stripe and on customer receipts. It should return a string that describes the order. -
Order Status Property: status This property is selected as the order status property, which will be used to track the current status of the order. It will be automatically updated based on payment results from Stripe.
-
Order Status Update Date Property: updatedAt This property is selected to record the timestamp of the last order status update. It will be automatically managed during payment events to reflect when the status was last changed.
-
Order Owner Id Property: buyerId This property is selected as the order owner property, which will be used to track the user who owns the order. It will be used to ensure correct access control in payment flows, allowing only the owner to manage their orders.
-
Map Payment Result to Order Status: This configuration defines how Stripe's payment results (e.g., started, success, failed, canceled) map to internal order statuses.,
paymentResultStartedstatus will be mapped to a local value using"PENDING_PAYMENT"and will be set tostatusproperty.paymentResultCanceledstatus will be mapped to a local value using"CANCELLED"and will be set tostatusproperty.paymentResultFailedstatus will be mapped to a local value using"CANCELLED"and will be set tostatusproperty.paymentResultSuccessstatus will be mapped to a local value using"PAID"and will be set tostatusproperty. -
On Checkout Error: continueRoute
if an error occurs during the checkout process, the API will continue to execute, allowing for custom error handling. In this case, the payment error will ve recorded as a status update. To make a retry a new checkout, a new order will be created with the same data as the original order.
Properties Schema
| Property | Type | Required | Description |
|---|---|---|---|
orderNumber
|
String | Yes | Unique, human-friendly order number (displayed to users); enforced unique. |
items
|
ID | No | Array of orderManagementOrderItem ids representing items in this order. |
buyerId
|
ID | Yes | User ID of the buyer placing the order. |
status
|
Enum | Yes | Order lifecycle: PENDING_PAYMENT, PAID, PROCESSING, SHIPPED, DELIVERED, CANCELLED, REFUNDED |
paymentMethodId
|
String | Yes | Stripe paymentMethodId used for payment. Not stored if cash or other payment (future). |
stripeCustomerId
|
String | Yes | Stripe customerId of buyer; enables saved/paymentMethodId flows. |
paymentIntentId
|
String | No | Stripe paymentIntentId; enables webhook correlation and status sync. |
shippingAddress
|
Object | Yes | Shipping address for the order (copy of buyer address at purchase time). |
summary
|
Object | Yes | Object with total, subtotal, currency, shipping, discount breakdown as snapshot of order at time of purchase. |
trackingNumber
|
String | No | Optional tracking number entered by seller when marking as shipped. |
estimatedDelivery
|
Date | No | Estimated delivery date for order; copied from fastest estimated item or seller input. |
cancelledAt
|
Date | No | Timestamp when cancelled by buyer, seller, or admin before shipment. |
paidAt
|
Date | No | Timestamp when payment confirmed via Stripe or manual admin update. |
deliveredAt
|
Date | No | Timestamp when buyer confirms delivery. |
shippedAt
|
Date | No | Timestamp when seller marks as shipped. |
carrier
|
String | No | Optional carrier name entered by seller when marking as shipped. |
_paymentConfirmation
|
Enum | Yes | An automatic property that is used to check the confirmed status of the payment set by webhooks. |
- Required properties are mandatory for creating objects and must be provided in the request body if no default value is set.
Array Properties
items
Array properties can hold multiple values and are indicated by the
[]
suffix in their type. Avoid using arrays in properties that are
used for relations, as they will not work correctly. Note that
using connection objects instead of arrays is recommended for
relations, as they provide better performance and flexibility.
Default Values
Default values are automatically assigned to properties when a new object is created, if no value is provided in the request body. Since default values are applied on db level, they should be literal values, not expressions.If you want to use expressions, you can use transposed parameters in any business API to set default values dynamically.
- orderNumber: 'default'
- buyerId: '00000000-0000-0000-0000-000000000000'
- status: PENDING_PAYMENT
- paymentMethodId: 'default'
- stripeCustomerId: 'default'
- shippingAddress: {}
- summary: {}
- _paymentConfirmation: pending
Always Create with Default Values
Some of the default values are set to be always used when creating a new object, even if the property value is provided in the request body. It ensures that the property is always initialized with a default value when the object is created.
-
status: Will be created with value
PENDING_PAYMENT -
_paymentConfirmation: Will be created with value
pending
Constant Properties
orderNumber
items
buyerId
paymentMethodId
stripeCustomerId
shippingAddress
summary
Constant properties are defined to be immutable after creation,
meaning they cannot be updated or changed once set. They are
typically used for properties that should remain constant
throughout the object's lifecycle. A property is set to be
constant if the
Allow Update
option is set to
false.
Auto Update Properties
status
paymentIntentId
trackingNumber
estimatedDelivery
cancelledAt
paidAt
deliveredAt
shippedAt
carrier
An update crud API created with the option
Auto Params
enabled will automatically update these properties with the
provided values in the request body. If you want to update any
property in your own business logic not by user input, you can set
the
Allow Auto Update
option to false. These properties will be added to the update
API's body parameters and can be updated by the user if any value
is provided in the request body.
Enum Properties
Enum properties are defined with a set of allowed values, ensuring that only valid options can be assigned to them. The enum options value will be stored as strings in the database, but when a data object is created an addtional property with the same name plus an idx suffix will be created, which will hold the index of the selected enum option. You can use the index property to sort by the enum value or when your enum options represent a sequence of values.
-
status: [PENDING_PAYMENT, PAID, PROCESSING, SHIPPED, DELIVERED, CANCELLED, REFUNDED]
-
_paymentConfirmation: [pending, processing, paid, canceled]
Elastic Search Indexing
orderNumber
buyerId
status
cancelledAt
paidAt
deliveredAt
shippedAt
_paymentConfirmation
Properties that are indexed in Elastic Search will be searchable via the Elastic Search API. While all properties are stored in the elastic search index of the data object, only those marked for Elastic Search indexing will be available for search queries.
Database Indexing
orderNumber
buyerId
status
paymentIntentId
cancelledAt
paidAt
deliveredAt
shippedAt
_paymentConfirmation
Properties that are indexed in the database will be optimized for query performance, allowing for faster data retrieval. Make a property indexed in the database if you want to use it frequently in query filters or sorting.
Unique Properties
orderNumber
Unique properties are enforced to have distinct values across all
instances of the data object, preventing duplicate entries. Note
that a unique property is automatically indexed in the database so
you will not need to set the
Indexed in DB
option.
Redis Cluster Properties
orderNumber
Cluster properties are used to group related data in Redis, and
used to invalidate the query cache more precisely. If no cluster
property is set, the data object query cache will be invalidated
for all instances of the data object when any instance is created,
updated or deleted. For example, if you have a
userId
property that is used to cluster a task data query in Redis, when
a new task is created, the query caches which have different
userId filters will be reserved, and only the queries that have
the same userId filter or have no filter at all will be
invalidated.
Secondary Key Properties
orderNumber
paymentIntentId
_paymentConfirmation
Secondary key properties are used to create an additional indexed identifiers for the data object, allowing for alternative access patterns. Different than normal indexed properties, secondary keys will act as primary keys and Mindbricks will provide automatic secondary key db utility functions to access the data object by the secondary key.
Relation Properties
items
buyerId
Mindbricks supports relations between data objects, allowing you to define how objects are linked together. You can define relations in the data object properties, which will be used to create foreign key constraints in the database. For complex joins operations, Mindbricks supportsa BFF pattern, where you can view dynamic and static views based on Elastic Search Indexes. Use db level relations for simple one-to-one or one-to-many relationships, and use BFF views for complex joins that require multiple data objects to be joined together.
-
items: ID Relation to
orderManagementOrderItem.id
The target object is a parent object, meaning that the relation is a one-to-many relationship from target to this object.
On Delete: Set Null Required: No
-
buyerId: ID Relation to
user.id
The target object is a parent object, meaning that the relation is a one-to-many relationship from target to this object.
On Delete: Set Null Required: Yes
Session Data Properties
buyerId
Session data properties are used to store data that is specific to the user session, allowing for personalized experiences and temporary data storage. If a property is configured as session data, it will be automatically mapped to the related field in the user session during CRUD operations. Note that session data properties can not be mutated by the user, but only by the system.
-
buyerId: ID property will be mapped to the
session parameter
userId.
This property is also used to store the owner of the session data, allowing for ownership checks and access control.
Filter Properties
orderNumber
status
_paymentConfirmation
Filter properties are used to define parameters that can be used in query filters, allowing for dynamic data retrieval based on user input or predefined criteria. These properties are automatically mapped as API parameters in the listing API's that have "Auto Params" enabled.
-
orderNumber: String has a filter named
orderNumber -
status: Enum has a filter named
status -
_paymentConfirmation: Enum has a filter named
_paymentConfirmation
orderManagementOrderItem Data Object
Object Overview
Description: Order line item representing purchase of a single product from a specific seller as part of an order. Enables feedback, delivery, and per-seller analytics. Immutable after order creation.
This object represents a core data structure within the service
and acts as the blueprint for database interaction, API
generation, and business logic enforcement. It is defined using
the
ObjectSettings
pattern, which governs its behavior, access control, caching
strategy, and integration points with other systems such as Stripe
and Redis.
Core Configuration
-
Soft Delete: Enabled — Determines whether
records are marked inactive (
isActive = false) instead of being physically deleted. - Public Access: accessPrivate — If enabled, anonymous users may access this object’s data depending on API-level rules.
Composite Indexes
- uniqueOrderItemInOrder: [orderId, productId] This composite index is defined to optimize query performance for complex queries involving multiple fields.
The index also defines a conflict resolution strategy for duplicate key violations.
When a new record would violate this composite index, the following action will be taken:
On Duplicate:
throwError
An error will be thrown, preventing the insertion of conflicting data.
Properties Schema
| Property | Type | Required | Description |
|---|---|---|---|
shipping
|
Double | Yes | Shipping cost for this product (may be 0 for free shipping). |
orderId
|
ID | Yes | Parent order this item belongs to; enables join and lifecycle tracking. |
quantity
|
Integer | Yes | Number of units purchased for this product. |
productId
|
ID | Yes | ID of product purchased in this line item. |
price
|
Double | Yes | Unit price for this product at purchase time. |
sellerId
|
ID | Yes | UserId of seller (owner of product at purchase time). |
title
|
String | Yes | Product title at purchase time (copied for convenience/audit). |
currency
|
String | Yes | Currency code for price/shipping (ISO 4217). |
- Required properties are mandatory for creating objects and must be provided in the request body if no default value is set.
Default Values
Default values are automatically assigned to properties when a new object is created, if no value is provided in the request body. Since default values are applied on db level, they should be literal values, not expressions.If you want to use expressions, you can use transposed parameters in any business API to set default values dynamically.
- shipping: 0.0
- orderId: '00000000-0000-0000-0000-000000000000'
- quantity: 1
- productId: '00000000-0000-0000-0000-000000000000'
- price: 0.0
- sellerId: '00000000-0000-0000-0000-000000000000'
- title: 'default'
- currency: 'default'
Constant Properties
shipping
orderId
quantity
productId
price
sellerId
title
currency
Constant properties are defined to be immutable after creation,
meaning they cannot be updated or changed once set. They are
typically used for properties that should remain constant
throughout the object's lifecycle. A property is set to be
constant if the
Allow Update
option is set to
false.
Elastic Search Indexing
orderId
productId
sellerId
title
Properties that are indexed in Elastic Search will be searchable via the Elastic Search API. While all properties are stored in the elastic search index of the data object, only those marked for Elastic Search indexing will be available for search queries.
Database Indexing
orderId
productId
sellerId
Properties that are indexed in the database will be optimized for query performance, allowing for faster data retrieval. Make a property indexed in the database if you want to use it frequently in query filters or sorting.
Relation Properties
orderId
productId
sellerId
Mindbricks supports relations between data objects, allowing you to define how objects are linked together. You can define relations in the data object properties, which will be used to create foreign key constraints in the database. For complex joins operations, Mindbricks supportsa BFF pattern, where you can view dynamic and static views based on Elastic Search Indexes. Use db level relations for simple one-to-one or one-to-many relationships, and use BFF views for complex joins that require multiple data objects to be joined together.
-
orderId: ID Relation to
orderManagementOrder.id
The target object is a parent object, meaning that the relation is a one-to-many relationship from target to this object.
On Delete: Set Null Required: Yes
-
productId: ID Relation to
productListingProduct.id
The target object is a parent object, meaning that the relation is a one-to-many relationship from target to this object.
On Delete: Set Null Required: Yes
-
sellerId: ID Relation to
user.id
The target object is a parent object, meaning that the relation is a one-to-many relationship from target to this object.
On Delete: Set Null Required: Yes
sys_orderManagementOrderPayment Data Object
Object Overview
Description: A payment storage object to store the payment life cyle of orders based on orderManagementOrder object. It is autocreated based on the source object's checkout config
This object represents a core data structure within the service
and acts as the blueprint for database interaction, API
generation, and business logic enforcement. It is defined using
the
ObjectSettings
pattern, which governs its behavior, access control, caching
strategy, and integration points with other systems such as Stripe
and Redis.
Core Configuration
-
Soft Delete: Enabled — Determines whether
records are marked inactive (
isActive = false) instead of being physically deleted. - Public Access: accessPrivate — If enabled, anonymous users may access this object’s data depending on API-level rules.
Properties Schema
| Property | Type | Required | Description |
|---|---|---|---|
ownerId
|
ID | No | An ID value to represent owner user who created the order |
orderId
|
ID | Yes | an ID value to represent the orderId which is the ID parameter of the source orderManagementOrder object |
paymentId
|
String | Yes | A String value to represent the paymentId which is generated on the Stripe gateway. This id may represent different objects due to the payment gateway and the chosen flow type |
paymentStatus
|
String | Yes | A string value to represent the payment status which belongs to the lifecyle of a Stripe payment. |
statusLiteral
|
String | Yes | A string value to represent the logical payment status which belongs to the application lifecycle itself. |
redirectUrl
|
String | No | A string value to represent return page of the frontend to show the result of the payment, this is used when the callback is made to server not the client. |
- Required properties are mandatory for creating objects and must be provided in the request body if no default value is set.
Default Values
Default values are automatically assigned to properties when a new object is created, if no value is provided in the request body. Since default values are applied on db level, they should be literal values, not expressions.If you want to use expressions, you can use transposed parameters in any business API to set default values dynamically.
- orderId: '00000000-0000-0000-0000-000000000000'
- paymentId: 'default'
- paymentStatus: 'default'
- statusLiteral: started
Constant Properties
orderId
Constant properties are defined to be immutable after creation,
meaning they cannot be updated or changed once set. They are
typically used for properties that should remain constant
throughout the object's lifecycle. A property is set to be
constant if the
Allow Update
option is set to
false.
Auto Update Properties
ownerId
orderId
paymentId
paymentStatus
statusLiteral
redirectUrl
An update crud API created with the option
Auto Params
enabled will automatically update these properties with the
provided values in the request body. If you want to update any
property in your own business logic not by user input, you can set
the
Allow Auto Update
option to false. These properties will be added to the update
API's body parameters and can be updated by the user if any value
is provided in the request body.
Elastic Search Indexing
ownerId
orderId
paymentId
paymentStatus
statusLiteral
redirectUrl
Properties that are indexed in Elastic Search will be searchable via the Elastic Search API. While all properties are stored in the elastic search index of the data object, only those marked for Elastic Search indexing will be available for search queries.
Database Indexing
ownerId
orderId
paymentId
paymentStatus
statusLiteral
redirectUrl
Properties that are indexed in the database will be optimized for query performance, allowing for faster data retrieval. Make a property indexed in the database if you want to use it frequently in query filters or sorting.
Unique Properties
orderId
Unique properties are enforced to have distinct values across all
instances of the data object, preventing duplicate entries. Note
that a unique property is automatically indexed in the database so
you will not need to set the
Indexed in DB
option.
Secondary Key Properties
orderId
Secondary key properties are used to create an additional indexed identifiers for the data object, allowing for alternative access patterns. Different than normal indexed properties, secondary keys will act as primary keys and Mindbricks will provide automatic secondary key db utility functions to access the data object by the secondary key.
Session Data Properties
ownerId
Session data properties are used to store data that is specific to the user session, allowing for personalized experiences and temporary data storage. If a property is configured as session data, it will be automatically mapped to the related field in the user session during CRUD operations. Note that session data properties can not be mutated by the user, but only by the system.
-
ownerId: ID property will be mapped to the
session parameter
userId.
This property is also used to store the owner of the session data, allowing for ownership checks and access control.
Filter Properties
ownerId
orderId
paymentId
paymentStatus
statusLiteral
redirectUrl
Filter properties are used to define parameters that can be used in query filters, allowing for dynamic data retrieval based on user input or predefined criteria. These properties are automatically mapped as API parameters in the listing API's that have "Auto Params" enabled.
-
ownerId: ID has a filter named
ownerId -
orderId: ID has a filter named
orderId -
paymentId: String has a filter named
paymentId -
paymentStatus: String has a filter named
paymentStatus -
statusLiteral: String has a filter named
statusLiteral -
redirectUrl: String has a filter named
redirectUrl
sys_paymentCustomer Data Object
Object Overview
Description: A payment storage object to store the customer values of the payment platform
This object represents a core data structure within the service
and acts as the blueprint for database interaction, API
generation, and business logic enforcement. It is defined using
the
ObjectSettings
pattern, which governs its behavior, access control, caching
strategy, and integration points with other systems such as Stripe
and Redis.
Core Configuration
-
Soft Delete: Enabled — Determines whether
records are marked inactive (
isActive = false) instead of being physically deleted. - Public Access: accessPrivate — If enabled, anonymous users may access this object’s data depending on API-level rules.
Properties Schema
| Property | Type | Required | Description |
|---|---|---|---|
userId
|
ID | No | An ID value to represent the user who is created as a stripe customer |
customerId
|
String | Yes | A string value to represent the customer id which is generated on the Stripe gateway. This id is used to represent the customer in the Stripe gateway |
platform
|
String | Yes | A String value to represent payment platform which is used to make the payment. It is stripe as default. It will be used to distinguesh the payment gateways in the future. |
- Required properties are mandatory for creating objects and must be provided in the request body if no default value is set.
Default Values
Default values are automatically assigned to properties when a new object is created, if no value is provided in the request body. Since default values are applied on db level, they should be literal values, not expressions.If you want to use expressions, you can use transposed parameters in any business API to set default values dynamically.
- customerId: 'default'
- platform: stripe
Constant Properties
customerId
platform
Constant properties are defined to be immutable after creation,
meaning they cannot be updated or changed once set. They are
typically used for properties that should remain constant
throughout the object's lifecycle. A property is set to be
constant if the
Allow Update
option is set to
false.
Auto Update Properties
userId
customerId
platform
An update crud API created with the option
Auto Params
enabled will automatically update these properties with the
provided values in the request body. If you want to update any
property in your own business logic not by user input, you can set
the
Allow Auto Update
option to false. These properties will be added to the update
API's body parameters and can be updated by the user if any value
is provided in the request body.
Elastic Search Indexing
userId
customerId
platform
Properties that are indexed in Elastic Search will be searchable via the Elastic Search API. While all properties are stored in the elastic search index of the data object, only those marked for Elastic Search indexing will be available for search queries.
Database Indexing
userId
customerId
platform
Properties that are indexed in the database will be optimized for query performance, allowing for faster data retrieval. Make a property indexed in the database if you want to use it frequently in query filters or sorting.
Unique Properties
userId
customerId
Unique properties are enforced to have distinct values across all
instances of the data object, preventing duplicate entries. Note
that a unique property is automatically indexed in the database so
you will not need to set the
Indexed in DB
option.
Secondary Key Properties
userId
customerId
Secondary key properties are used to create an additional indexed identifiers for the data object, allowing for alternative access patterns. Different than normal indexed properties, secondary keys will act as primary keys and Mindbricks will provide automatic secondary key db utility functions to access the data object by the secondary key.
Session Data Properties
userId
Session data properties are used to store data that is specific to the user session, allowing for personalized experiences and temporary data storage. If a property is configured as session data, it will be automatically mapped to the related field in the user session during CRUD operations. Note that session data properties can not be mutated by the user, but only by the system.
-
userId: ID property will be mapped to the
session parameter
userId.
This property is also used to store the owner of the session data, allowing for ownership checks and access control.
Filter Properties
userId
customerId
platform
Filter properties are used to define parameters that can be used in query filters, allowing for dynamic data retrieval based on user input or predefined criteria. These properties are automatically mapped as API parameters in the listing API's that have "Auto Params" enabled.
-
userId: ID has a filter named
userId -
customerId: String has a filter named
customerId -
platform: String has a filter named
platform
sys_paymentMethod Data Object
Object Overview
Description: A payment storage object to store the payment methods of the platform customers
This object represents a core data structure within the service
and acts as the blueprint for database interaction, API
generation, and business logic enforcement. It is defined using
the
ObjectSettings
pattern, which governs its behavior, access control, caching
strategy, and integration points with other systems such as Stripe
and Redis.
Core Configuration
-
Soft Delete: Enabled — Determines whether
records are marked inactive (
isActive = false) instead of being physically deleted. - Public Access: accessPrivate — If enabled, anonymous users may access this object’s data depending on API-level rules.
Properties Schema
| Property | Type | Required | Description |
|---|---|---|---|
paymentMethodId
|
String | Yes | A string value to represent the id of the payment method on the payment platform. |
userId
|
ID | Yes | An ID value to represent the user who owns the payment method |
customerId
|
String | Yes | A string value to represent the customer id which is generated on the payment gateway. |
cardHolderName
|
String | No | A string value to represent the name of the card holder. It can be different than the registered customer. |
cardHolderZip
|
String | No | A string value to represent the zip code of the card holder. It is used for address verification in specific countries. |
platform
|
String | Yes | A String value to represent payment platform which teh paymentMethod belongs. It is stripe as default. It will be used to distinguesh the payment gateways in the future. |
cardInfo
|
Object | Yes | A Json value to store the card details of the payment method. |
- Required properties are mandatory for creating objects and must be provided in the request body if no default value is set.
Default Values
Default values are automatically assigned to properties when a new object is created, if no value is provided in the request body. Since default values are applied on db level, they should be literal values, not expressions.If you want to use expressions, you can use transposed parameters in any business API to set default values dynamically.
- paymentMethodId: 'default'
- userId: '00000000-0000-0000-0000-000000000000'
- customerId: 'default'
- platform: stripe
- cardInfo: {}
Constant Properties
paymentMethodId
userId
customerId
cardHolderName
cardHolderZip
platform
Constant properties are defined to be immutable after creation,
meaning they cannot be updated or changed once set. They are
typically used for properties that should remain constant
throughout the object's lifecycle. A property is set to be
constant if the
Allow Update
option is set to
false.
Auto Update Properties
paymentMethodId
userId
customerId
cardHolderName
cardHolderZip
platform
cardInfo
An update crud API created with the option
Auto Params
enabled will automatically update these properties with the
provided values in the request body. If you want to update any
property in your own business logic not by user input, you can set
the
Allow Auto Update
option to false. These properties will be added to the update
API's body parameters and can be updated by the user if any value
is provided in the request body.
Elastic Search Indexing
paymentMethodId
userId
customerId
cardHolderName
cardHolderZip
platform
cardInfo
Properties that are indexed in Elastic Search will be searchable via the Elastic Search API. While all properties are stored in the elastic search index of the data object, only those marked for Elastic Search indexing will be available for search queries.
Database Indexing
paymentMethodId
userId
customerId
platform
cardInfo
Properties that are indexed in the database will be optimized for query performance, allowing for faster data retrieval. Make a property indexed in the database if you want to use it frequently in query filters or sorting.
Unique Properties
paymentMethodId
Unique properties are enforced to have distinct values across all
instances of the data object, preventing duplicate entries. Note
that a unique property is automatically indexed in the database so
you will not need to set the
Indexed in DB
option.
Secondary Key Properties
paymentMethodId
userId
customerId
Secondary key properties are used to create an additional indexed identifiers for the data object, allowing for alternative access patterns. Different than normal indexed properties, secondary keys will act as primary keys and Mindbricks will provide automatic secondary key db utility functions to access the data object by the secondary key.
Session Data Properties
userId
Session data properties are used to store data that is specific to the user session, allowing for personalized experiences and temporary data storage. If a property is configured as session data, it will be automatically mapped to the related field in the user session during CRUD operations. Note that session data properties can not be mutated by the user, but only by the system.
-
userId: ID property will be mapped to the
session parameter
userId.
This property is also used to store the owner of the session data, allowing for ownership checks and access control.
Filter Properties
paymentMethodId
userId
customerId
cardHolderName
cardHolderZip
platform
cardInfo
Filter properties are used to define parameters that can be used in query filters, allowing for dynamic data retrieval based on user input or predefined criteria. These properties are automatically mapped as API parameters in the listing API's that have "Auto Params" enabled.
-
paymentMethodId: String has a filter named
paymentMethodId -
userId: ID has a filter named
userId -
customerId: String has a filter named
customerId -
cardHolderName: String has a filter named
cardHolderName -
cardHolderZip: String has a filter named
cardHolderZip -
platform: String has a filter named
platform -
cardInfo: Object has a filter named
cardInfo
Business Logic
orderManagement has got 27 Business APIs to manage its internal and crud logic. For the details of each business API refer to its chapter.
Edge Controllers
No edge controllers defined for this service.
Service Library
Functions
generateOrderId.js
module.exports=function(){return 'ORD-' + Date.now().toString(36) + Math.floor(Math.random()*1000).toString(36);}
calculateOrderSummary.js
module.exports=function(products,quantities){
let subtotal=0; let shipping=0; let currency='USD';
products.forEach(p => {
let qty=quantities[p.id]||1;
subtotal+=p.price*qty;
shipping+=p.shipping*qty;
if(p.currency) currency=p.currency;
});
return {subtotal,shipping,total:subtotal+shipping,currency};
};
Hook Functions
No hook functions defined.
Edge Functions
No edge functions defined.
Templates
No templates defined.
Assets
No assets defined.
Public Assets
No public assets defined.
Event Emission
Integration Patterns
Deployment Considerations
Environment Configuration
-
HTTP Port:
3004 - Database Type: MongoDB
- Global Soft Delete: Enabled
Implementation Guidelines
Development Workflow
- Data Model Implementation: Generate database schema from data object definitions
- CRUD Route Generation: Implement auto-generated routes with custom logic
- Custom Logic Integration: Implement hook functions and edge functions
- Authentication Integration: Configure with project-level authentication
- Testing: Unit and integration testing for all components
Code Generation Expectations
- Database Schema: Auto-generated from data objects and relationships
- API Routes: REST endpoints with customizable behavior
- Validation Logic: Input validation from property definitions
- Access Control: Authentication and authorization middleware
Custom Code Integration Points
- Hook Functions: Lifecycle-specific custom logic
- Edge Functions: Full request/response control
- Library Functions: Reusable business logic
- Templates: Dynamic content rendering
Testing Strategy
Unit Testing
- Test all custom library functions
- Test validation logic and business rules
- Test hook function implementations
Integration Testing
- Test API endpoints with authentication scenarios
- Test database operations and transactions
- Test external integrations
- Test event emission and Kafka integration
Performance Testing
- Load test high-traffic endpoints
- Test caching effectiveness
- Monitor database query performance
- Test scalability under load
Appendices
Data Type Reference
| Type | Description | Storage |
|---|---|---|
| ID | Unique identifier | UUID (SQL) / ObjectID (NoSQL) |
| String | Short text (≤255 chars) | VARCHAR |
| Text | Long-form text | TEXT |
| Integer | 32-bit whole numbers | INT |
| Boolean | True/false values | BOOLEAN |
| Double | 64-bit floating point | DOUBLE |
| Float | 32-bit floating point | FLOAT |
| Short | 16-bit integers | SMALLINT |
| Object | JSON object | JSONB (PostgreSQL) / Object (MongoDB) |
| Date | ISO 8601 timestamp | TIMESTAMP |
| Enum | Fixed numeric values | SMALLINT with lookup |
Enum Value Mappings
Request Locations
-
0: Bearer token in Authorization header -
1: Cookie value -
2: Custom HTTP header -
3: Query parameter -
4: Request body property -
5: URL path parameter -
6: Session data -
7: Root request object
HTTP Methods
-
0: GET -
1: POST -
2: PUT -
3: PATCH -
4: DELETE
Edge Function Signature
async function edgeFunction(request) {
// Custom request processing
// Return response object or throw error
return {
data: {},
status: 200,
message: "Success"
};
}
This document was generated from the service architecture definition and should be kept in sync with implementation changes.