okayapi_smpss_member

-- MySQL Table okayapi_smpss_member
-- From: OkayAPI.com
CREATE TABLE `okayapi_smpss_member` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `membercardid` varchar(16) NOT NULL COMMENT '会员卡ID',
    `realname` varchar(32) NOT NULL COMMENT '真实名字',
    `phone` varchar(16) NOT NULL COMMENT '座机',
    `mobile` varchar(16) NOT NULL COMMENT '手机',
    `email` varchar(32) NOT NULL COMMENT '邮箱',
    `prov_id` int(10) NOT NULL COMMENT '省份ID',
    `prov_name` varchar(32) NOT NULL COMMENT '省份名称',
    `city_id` int(10) NOT NULL COMMENT '城市ID',
    `city_name` varchar(32) NOT NULL COMMENT '城市名称',
    `address` varchar(200) NOT NULL COMMENT '地址',
    `zipcode` int(7) NOT NULL COMMENT '邮编',
    `cardid` varchar(18) NOT NULL COMMENT '身份证',
    `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态0停用 1可用',
    `grade` tinyint(1) NOT NULL DEFAULT '1' COMMENT '会员等级',
    `credit` int(10) NOT NULL DEFAULT '0' COMMENT '购物积分',
    `regdateymd` date NOT NULL COMMENT '注册时间YMD',
    `regdateline` int(10) NOT NULL COMMENT '注册时间',
    `lastdateline` int(10) NOT NULL COMMENT '最后购物时间',
    KEY `membercardid` (`membercardid`),
    KEY `realname` (`realname`),
    KEY `phone` (`phone`),
    KEY `mobile` (`mobile`),
    KEY `email` (`email`),
    KEY `prov_id` (`prov_id`),
    KEY `prov_name` (`prov_name`),
    KEY `city_id` (`city_id`),
    KEY `city_name` (`city_name`),
    KEY `address` (`address`),
    KEY `zipcode` (`zipcode`),
    KEY `cardid` (`cardid`),
    KEY `state` (`state`),
    KEY `grade` (`grade`),
    KEY `credit` (`credit`),
    KEY `regdateymd` (`regdateymd`),
    KEY `regdateline` (`regdateline`),
    KEY `lastdateline` (`lastdateline`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '进销存-会员信息表';

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