MySQL Create Table SQL
Table Structure: okayapi_shopxo_s_refund_log:/tablelist/okayapi_shopxo_s_refund_log.html
-- MySQL Table okayapi_shopxo_s_refund_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_refund_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`payment_name` char(60) NOT NULL COMMENT '支付方式名称',
`refundment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '退款类型(0原路退回, 1退至钱包, 2手动处理)',
`business_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '业务类型(0默认, 1订单, 2充值, ...)',
`return_params` text NOT NULL COMMENT '支付平台返回参数(以json存储)',
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
`order_id` int(11) NOT NULL COMMENT '订单id',
`trade_no` char(100) NOT NULL COMMENT '支付平台交易号',
`buyer_user` char(60) NOT NULL COMMENT '支付平台用户帐号',
`refund_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额',
`pay_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单实际支付金额',
`msg` char(255) NOT NULL COMMENT '描述',
`payment` char(60) NOT NULL COMMENT '支付方式标记',
KEY `payment_name` (`payment_name`),
KEY `refundment` (`refundment`),
KEY `business_type` (`business_type`),
KEY `return_params` (`return_params`),
KEY `user_id` (`user_id`),
KEY `order_id` (`order_id`),
KEY `trade_no` (`trade_no`),
KEY `buyer_user` (`buyer_user`),
KEY `refund_price` (`refund_price`),
KEY `pay_price` (`pay_price`),
KEY `msg` (`msg`),
KEY `payment` (`payment`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-退款日志';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
payment_name | char(60) | 否 | 支付方式名称 | |||
refundment | tinyint(1) | 0 | 否 | 退款类型(0原路退回, 1退至钱包, 2手动处理) | 0 | |
business_type | tinyint(1) | 0 | 否 | 业务类型(0默认, 1订单, 2充值, ...) | 0 | |
return_params | text | 是 | 支付平台返回参数(以json存储) | |||
user_id | int(11) | 0 | 否 | 用户id | 0 | |
order_id | int(11) | 否 | 订单id | Normal Index | ||
trade_no | char(100) | 否 | 支付平台交易号 | |||
buyer_user | char(60) | 否 | 支付平台用户帐号 | |||
refund_price | decimal(10,2) | 0.00 | 否 | 退款金额 | 0.00 | |
pay_price | decimal(10,2) | 0.00 | 否 | 订单实际支付金额 | 0.00 | |
msg | char(255) | 否 | 描述 | |||
payment | char(60) | 否 | 支付方式标记 | Normal Index |