Q: Do you have any documentation related to order and payment tables and schema?

I created some orders but did not find any entry in OrderPaymentGatewayTransaction table. So, if you have any document, I can look into that to clarify doubts like these.


A: We have schema for Orders module in github:
https://github.com/VirtoCommerce/vc-module-order/
Database Model section.

To have entries in OrderPaymentGatewayTransaction you need to add payments to the orders. Some entities have collection properties like this:
https://github.com/VirtoCommerce/vc-module-order/blob/63d1295ce39e440f35dfd614b49c3e0071dc7298/VirtoCommerce.OrderModule.Data/Model/CustomerOrderEntity.cs

To add them, you should add payments to the cart:
https://github.com/VirtoCommerce/vc-module-order/blob/9755044a7ec4d21dbb8ab69e8ba4d22b362d2213/VirtoCommerce.OrderModule.Data/Services/CustomerOrderBuilderImpl.cs#L96

You need to install and configure some payment gateway module for payment creation.