+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_member_datas_log:/tablelist/okayapi_member_datas_log.html


-- MySQL Table okayapi_member_datas_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_member_datas_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `member_id` int(11) NULL COMMENT '用户id',
    `credit_type` varchar(30) NULL COMMENT '变动类型[integral:积分;money:余额]',
    `credit_group` varchar(30) NULL COMMENT '变动的详细组别',
    `old_num` double NULL DEFAULT '0' COMMENT '之前的数据',
    `new_num` double NULL DEFAULT '0' COMMENT '变动后的数据',
    `num` double NULL DEFAULT '0' COMMENT '变动的数据',
    `remark` varchar(200) NULL COMMENT '备注',
    `status` tinyint(4) NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    KEY `member_id` (`member_id`),
    KEY `credit_type` (`credit_type`),
    KEY `credit_group` (`credit_group`),
    KEY `old_num` (`old_num`),
    KEY `new_num` (`new_num`),
    KEY `num` (`num`),
    KEY `remark` (`remark`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '会员数据变动记录表';

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


MySQL database table structure design

Displaying 1-8 of 8 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
member_idint(11)用户id
credit_typevarchar(30)变动类型[integral:积分;money:余额]
credit_groupvarchar(30)变动的详细组别
old_numdouble0之前的数据0
new_numdouble0变动后的数据0
numdouble0变动的数据0
remarkvarchar(200)备注
statustinyint(4)1状态[-1:删除;0:禁用;1启用]1

Guess You Like

MySQL Table Design okayapi_file_uploads

MySQL Table Design okayapi_framework_log

MySQL Table Design okayapi_provinces_log

MySQL Table Design okayapi_sms_log

MySQL Table Design okayapi_member_vip

MySQL Table Design okayapi_sys_message

MySQL Table Design okayapi_sys_notice_manage

MySQL Table Design okayapi_sys_menu_manage

MySQL Table Design okayapi_sys_config_manage

MySQL Table Design okayapi_sys_addon_manage

MySQL Table Design okayapi_server_manage

TOP ↑