okayapi_openant_user_transaction - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_user_transaction：/tablelist/okayapi_openant_user_transaction.html


-- MySQL Table okayapi_openant_user_transaction
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_user_transaction` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_transaction_id` int(11) NOT NULL COMMENT '',
    `user_id` int(11) NOT NULL COMMENT '',
    `order_id` int(11) NOT NULL COMMENT '',
    `description` text NOT NULL COMMENT '',
    `amount` decimal(15,4) NOT NULL COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    KEY `user_transaction_id` (`user_transaction_id`),
    KEY `user_id` (`user_id`),
    KEY `order_id` (`order_id`),
    KEY `description` (`description`),
    KEY `amount` (`amount`),
    KEY `date_added` (`date_added`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-用户事务';

After replication, you can go to the database to create the database table.