+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_shopxo_s_pay_log:/tablelist/okayapi_shopxo_s_pay_log.html


-- MySQL Table okayapi_shopxo_s_pay_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_pay_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `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 '支付平台用户帐号',
    `pay_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额',
    `total_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单实际金额',
    `okayapi_shopxo_s_pay_log_subject` char(255) NOT NULL COMMENT '订单名称',
    `payment` char(60) NOT NULL COMMENT '支付方式标记',
    `payment_name` char(60) NOT NULL COMMENT '支付方式名称',
    `business_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '业务类型(0默认, 1订单, 2充值, ...)',
    KEY `user_id` (`user_id`),
    KEY `order_id` (`order_id`),
    KEY `trade_no` (`trade_no`),
    KEY `buyer_user` (`buyer_user`),
    KEY `pay_price` (`pay_price`),
    KEY `total_price` (`total_price`),
    KEY `okayapi_shopxo_s_pay_log_subject` (`okayapi_shopxo_s_pay_log_subject`),
    KEY `payment` (`payment`),
    KEY `payment_name` (`payment_name`),
    KEY `business_type` (`business_type`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_idint(11)0用户id0
order_idint(11)订单idNormal Index
trade_nochar(100)支付平台交易号
buyer_userchar(60)支付平台用户帐号
pay_pricedecimal(10,2)0.00支付金额0.00
total_pricedecimal(10,2)0.00订单实际金额0.00
okayapi_shopxo_s_pay_log_subjectchar(255)订单名称
paymentchar(60)支付方式标记Normal Index
payment_namechar(60)支付方式名称
business_typetinyint(1)0业务类型(0默认, 1订单, 2充值, ...)0

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 ↑