+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
payment_namechar(60)支付方式名称
refundmenttinyint(1)0退款类型(0原路退回, 1退至钱包, 2手动处理)0
business_typetinyint(1)0业务类型(0默认, 1订单, 2充值, ...)0
return_paramstext支付平台返回参数(以json存储)
user_idint(11)0用户id0
order_idint(11)订单idNormal Index
trade_nochar(100)支付平台交易号
buyer_userchar(60)支付平台用户帐号
refund_pricedecimal(10,2)0.00退款金额0.00
pay_pricedecimal(10,2)0.00订单实际支付金额0.00
msgchar(255)描述
paymentchar(60)支付方式标记Normal Index

Guess You Like

MySQL Table Design okayapi_goods

MySQL Table Design okayapi_goods_comment

MySQL Table Design okayapi_shopxo_s_admin

MySQL Table Design okayapi_shopxo_s_answer

MySQL Table Design okayapi_shopxo_s_app_center_nav

MySQL Table Design okayapi_shopxo_s_app_home_nav

MySQL Table Design okayapi_shopxo_s_article

MySQL Table Design okayapi_shopxo_s_article_category

MySQL Table Design okayapi_shopxo_s_attachment

MySQL Table Design okayapi_shopxo_s_brand

MySQL Table Design okayapi_shopxo_s_brand_category

MySQL Table Design okayapi_shopxo_s_cart

MySQL Table Design okayapi_shopxo_s_config

MySQL Table Design okayapi_shopxo_s_custom_view

MySQL Table Design okayapi_shopxo_s_express

MySQL Table Design okayapi_shopxo_s_goods

MySQL Table Design okayapi_shopxo_s_goods_browse

MySQL Table Design okayapi_shopxo_s_goods_category

MySQL Table Design okayapi_shopxo_s_goods_category_join

MySQL Table Design okayapi_shopxo_s_goods_comments

TOP ↑