Preparing your database

Table Design

Here is an example of creating a new table. The minimum required fields would be as follows. In brief, the following operations are to be performed on this table. The APIs you implement according to this guide will be ones that perform these operations.

• INSERT a record when payment is initiated.
• UPDATE record when payment is completed
• SELECT a record when confirming payment completion

MySQL DDL

create table nodex_orders (
	order_code char(xx) not null unique,
		-- You HAVE TO generate per Nodex "Payment Request API"
		-- Per cart if the business client uses a cart system

	amount decimal(31,18),
		-- Amount of this order

	fiat_symbol char(3)
		-- Fiat of this amount

	payment_token unique char(32) not null unique,
		-- Unique value per payment request api that Nodex returns

	order_status varchar not null,
		-- such as [initiated, started, settled, failed]

	transaction_hash varchar
		-- tx of payment
);

Python Django

Amazon DynamoDB