MySQL Create Table SQL
Table Structure: okayapi_mall_ums_member_statistics_info:/tablelist/okayapi_mall_ums_member_statistics_info.html
-- MySQL Table okayapi_mall_ums_member_statistics_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_mall_ums_member_statistics_info` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`member_id` bigint(20) NULL COMMENT '',
`consume_amount` decimal(10,2) NULL COMMENT '累计消费金额',
`order_count` int(11) NULL COMMENT '订单数量',
`coupon_count` int(11) NULL COMMENT '优惠券数量',
`comment_count` int(11) NULL COMMENT '评价数',
`return_order_count` int(11) NULL COMMENT '退货数量',
`login_count` int(11) NULL COMMENT '登录次数',
`attend_count` int(11) NULL COMMENT '关注数量',
`fans_count` int(11) NULL COMMENT '粉丝数量',
`collect_product_count` int(11) NULL COMMENT '',
`collect_subject_count` int(11) NULL COMMENT '',
`collect_topic_count` int(11) NULL COMMENT '',
`collect_comment_count` int(11) NULL COMMENT '',
`invite_friend_count` int(11) NULL COMMENT '',
`recent_order_time` datetime NULL COMMENT '最后一次下订单时间',
KEY `member_id` (`member_id`),
KEY `consume_amount` (`consume_amount`),
KEY `order_count` (`order_count`),
KEY `coupon_count` (`coupon_count`),
KEY `comment_count` (`comment_count`),
KEY `return_order_count` (`return_order_count`),
KEY `login_count` (`login_count`),
KEY `attend_count` (`attend_count`),
KEY `fans_count` (`fans_count`),
KEY `collect_product_count` (`collect_product_count`),
KEY `collect_subject_count` (`collect_subject_count`),
KEY `collect_topic_count` (`collect_topic_count`),
KEY `collect_comment_count` (`collect_comment_count`),
KEY `invite_friend_count` (`invite_friend_count`),
KEY `recent_order_time` (`recent_order_time`),
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-15 of 15 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
member_id | bigint(20) | 是 | ||||
consume_amount | decimal(10,2) | 是 | 累计消费金额 | |||
order_count | int(11) | 是 | 订单数量 | |||
coupon_count | int(11) | 是 | 优惠券数量 | |||
comment_count | int(11) | 是 | 评价数 | |||
return_order_count | int(11) | 是 | 退货数量 | |||
login_count | int(11) | 是 | 登录次数 | |||
attend_count | int(11) | 是 | 关注数量 | |||
fans_count | int(11) | 是 | 粉丝数量 | |||
collect_product_count | int(11) | 是 | ||||
collect_subject_count | int(11) | 是 | ||||
collect_topic_count | int(11) | 是 | ||||
collect_comment_count | int(11) | 是 | ||||
invite_friend_count | int(11) | 是 | ||||
recent_order_time | datetime | 是 | 最后一次下订单时间 |