okayapi_eduwind_ew_order - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_order：/tablelist/okayapi_eduwind_ew_order.html


-- MySQL Table okayapi_eduwind_ew_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_order` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_eduwind_ew_order_status` enum('created','paid','cancelled') NOT NULL COMMENT '',
    `okayapi_eduwind_ew_order_subject` char(255) NOT NULL COMMENT '',
    `produceEntityId` int(11) NOT NULL COMMENT '',
    `userId` int(11) NOT NULL COMMENT '',
    `meansOfPayment` enum('none','alipay','tenpay','aliGuaran') NOT NULL COMMENT '',
    `price` float NOT NULL DEFAULT '0' COMMENT '',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `paidTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `tradeNo` char(32) NOT NULL COMMENT '',
    KEY `okayapi_eduwind_ew_order_status` (`okayapi_eduwind_ew_order_status`),
    KEY `okayapi_eduwind_ew_order_subject` (`okayapi_eduwind_ew_order_subject`),
    KEY `produceEntityId` (`produceEntityId`),
    KEY `userId` (`userId`),
    KEY `meansOfPayment` (`meansOfPayment`),
    KEY `price` (`price`),
    KEY `addTime` (`addTime`),
    KEY `paidTime` (`paidTime`),
    KEY `tradeNo` (`tradeNo`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'EW在线教育-订单';

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

MySQL database table structure design

Displaying 1-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Demo Data
okayapi_eduwind_ew_order_status	enum('created','paid','cancelled')		否
okayapi_eduwind_ew_order_subject	char(255)		否
produceEntityId	int(11)		否
userId	int(11)		否
meansOfPayment	enum('none','alipay','tenpay','aliGuaran')		是
price	float	0	否	0
addTime	int(11)	0	否	0
paidTime	int(11)	0	否	0
tradeNo	char(32)		否