+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_box_transaction:/tablelist/okayapi_box_transaction.html


-- MySQL Table okayapi_box_transaction
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_transaction` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `invoice_id` bigint(20) NULL COMMENT '',
    `gateway_id` int(11) NULL COMMENT '',
    `txn_id` varchar(255) NULL COMMENT '',
    `txn_status` varchar(255) NULL COMMENT '',
    `s_id` varchar(255) NULL COMMENT '',
    `s_period` varchar(255) NULL COMMENT '',
    `amount` varchar(255) NULL COMMENT '',
    `currency` varchar(10) NULL COMMENT '',
    `type` varchar(255) NULL COMMENT '',
    `status` varchar(255) NULL DEFAULT 'received' COMMENT '',
    `ip` varchar(45) NULL COMMENT '',
    `error` text NULL COMMENT '',
    `error_code` int(11) NULL COMMENT '',
    `validate_ipn` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `ipn` text NULL COMMENT '',
    `output` text NULL COMMENT '',
    `note` text NULL COMMENT '',
    KEY `invoice_id` (`invoice_id`),
    KEY `gateway_id` (`gateway_id`),
    KEY `txn_id` (`txn_id`),
    KEY `txn_status` (`txn_status`),
    KEY `s_id` (`s_id`),
    KEY `s_period` (`s_period`),
    KEY `amount` (`amount`),
    KEY `currency` (`currency`),
    KEY `type` (`type`),
    KEY `status` (`status`),
    KEY `ip` (`ip`),
    KEY `error` (`error`),
    KEY `error_code` (`error_code`),
    KEY `validate_ipn` (`validate_ipn`),
    KEY `ipn` (`ipn`),
    KEY `output` (`output`),
    KEY `note` (`note`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-交易';

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


MySQL database table structure design

Displaying 1-17 of 17 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
invoice_idbigint(20)Normal Index
gateway_idint(11)
txn_idvarchar(255)
txn_statusvarchar(255)
s_idvarchar(255)
s_periodvarchar(255)
amountvarchar(255)
currencyvarchar(10)
typevarchar(255)
statusvarchar(255)receivedreceived
ipvarchar(45)
errortext
error_codeint(11)
validate_ipntinyint(1)11
ipntext
outputtext
notetext

Guess You Like

MySQL Table Design okayapi_activity_admin_history

MySQL Table Design okayapi_activity_client_email

MySQL Table Design okayapi_activity_client_history

MySQL Table Design okayapi_activity_system

MySQL Table Design okayapi_box_admin

MySQL Table Design okayapi_box_admin_group

MySQL Table Design okayapi_box_cart

MySQL Table Design okayapi_box_cart_product

MySQL Table Design okayapi_box_client

MySQL Table Design okayapi_box_client_balance

MySQL Table Design okayapi_box_client_group

MySQL Table Design okayapi_box_client_order

MySQL Table Design okayapi_box_client_order_meta

MySQL Table Design okayapi_box_client_order_status

MySQL Table Design okayapi_box_client_password_reset

MySQL Table Design okayapi_box_currency

MySQL Table Design okayapi_box_email_template

MySQL Table Design okayapi_box_extension

MySQL Table Design okayapi_box_extension_meta

MySQL Table Design okayapi_box_form

TOP ↑