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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
user_id | int(11) | 0 | 否 | 用户id | 0 | |
order_id | int(11) | 否 | 订单id | Normal Index | ||
trade_no | char(100) | 否 | 支付平台交易号 | |||
buyer_user | char(60) | 否 | 支付平台用户帐号 | |||
pay_price | decimal(10,2) | 0.00 | 否 | 支付金额 | 0.00 | |
total_price | decimal(10,2) | 0.00 | 否 | 订单实际金额 | 0.00 | |
okayapi_shopxo_s_pay_log_subject | char(255) | 否 | 订单名称 | |||
payment | char(60) | 否 | 支付方式标记 | Normal Index | ||
payment_name | char(60) | 否 | 支付方式名称 | |||
business_type | tinyint(1) | 0 | 否 | 业务类型(0默认, 1订单, 2充值, ...) | 0 |