+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_mall_ums_member_rule_setting:/tablelist/okayapi_mall_ums_member_rule_setting.html


-- MySQL Table okayapi_mall_ums_member_rule_setting
-- From: OkayAPI.com
CREATE TABLE `okayapi_mall_ums_member_rule_setting` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `continue_sign_day` int(11) NULL COMMENT '连续签到天数',
    `continue_sign_point` int(11) NULL COMMENT '连续签到赠送数量',
    `consume_per_point` decimal(10,2) NULL COMMENT '每消费多少元获取1个点',
    `low_order_amount` decimal(10,2) NULL COMMENT '最低获取点数的订单金额',
    `max_point_per_order` int(11) NULL COMMENT '每笔订单最高获取点数',
    `okayapi_mall_ums_member_rule_setting_type` int(1) NULL COMMENT '类型:0->积分规则;1->成长值规则',
    KEY `continue_sign_day` (`continue_sign_day`),
    KEY `continue_sign_point` (`continue_sign_point`),
    KEY `consume_per_point` (`consume_per_point`),
    KEY `low_order_amount` (`low_order_amount`),
    KEY `max_point_per_order` (`max_point_per_order`),
    KEY `okayapi_mall_ums_member_rule_setting_type` (`okayapi_mall_ums_member_rule_setting_type`),
    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-6 of 6 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
continue_sign_dayint(11)连续签到天数
continue_sign_pointint(11)连续签到赠送数量
consume_per_pointdecimal(10,2)每消费多少元获取1个点
low_order_amountdecimal(10,2)最低获取点数的订单金额
max_point_per_orderint(11)每笔订单最高获取点数
okayapi_mall_ums_member_rule_setting_typeint(1)类型:0->积分规则;1->成长值规则

Guess You Like

MySQL Table Design okayapi_mall_ums_member_receive_address

MySQL Table Design okayapi_mall_ums_member_statistics_info

MySQL Table Design okayapi_mall_ums_role_permission_relation

MySQL Table Design okayapi_cloud_image_sync

MySQL Table Design okayapi_hc_act_re_model

MySQL Table Design okayapi_hc_group_buy

TOP ↑