okayapi_lvyou_jee_convert_money_list - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_convert_money_list：/tablelist/okayapi_lvyou_jee_convert_money_list.html


-- MySQL Table okayapi_lvyou_jee_convert_money_list
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_convert_money_list` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL COMMENT '',
    `okayapi_lvyou_jee_convert_money_list_types` varchar(20) NOT NULL COMMENT '',
    `totypes` varchar(20) NOT NULL COMMENT '',
    `addtime` datetime NOT NULL COMMENT '',
    `amount` decimal(10,2) NOT NULL COMMENT '',
    `okayapi_lvyou_jee_convert_money_list_status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '',
    KEY `user_id` (`user_id`),
    KEY `okayapi_lvyou_jee_convert_money_list_types` (`okayapi_lvyou_jee_convert_money_list_types`),
    KEY `totypes` (`totypes`),
    KEY `addtime` (`addtime`),
    KEY `amount` (`amount`),
    KEY `okayapi_lvyou_jee_convert_money_list_status` (`okayapi_lvyou_jee_convert_money_list_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-货币转换';

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

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Demo Data
user_id	int(11)		否
okayapi_lvyou_jee_convert_money_list_types	varchar(20)		否
totypes	varchar(20)		否
addtime	datetime		否
amount	decimal(10,2)		否
okayapi_lvyou_jee_convert_money_list_status	tinyint(2)	0	否	0