ibit-java/doge/database/_raw_schema.txt

Total tables: 145
---
=== TABLE: activity (rows: 0) ===
CREATE TABLE `activity` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `activity_link` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `notice_link` varchar(255) DEFAULT NULL,
  `progress` int(11) NOT NULL,
  `settings` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `step` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL,
  `accept_unit` varchar(255) NOT NULL,
  `amount_scale` int(11) NOT NULL,
  `banner_image_url` varchar(255) DEFAULT NULL,
  `content` text,
  `contenten` text,
  `detailen` varchar(255) DEFAULT NULL,
  `end_time` varchar(30) NOT NULL DEFAULT '2000-01-01 01:00:00' COMMENT '结束时间',
  `limit_times` int(11) NOT NULL,
  `max_limit_amout` decimal(24,8) DEFAULT NULL,
  `min_limit_amout` decimal(24,8) DEFAULT NULL,
  `price` decimal(18,8) DEFAULT NULL,
  `price_scale` int(11) NOT NULL,
  `small_image_url` varchar(255) DEFAULT NULL,
  `start_time` varchar(30) NOT NULL DEFAULT '2000-01-01 01:00:00' COMMENT '开始时间',
  `titleen` varchar(255) DEFAULT NULL,
  `total_supply` decimal(24,8) NOT NULL,
  `traded_amount` decimal(24,8) DEFAULT NULL,
  `unit` varchar(255) NOT NULL,
  `freeze_amount` decimal(26,8) DEFAULT NULL,
  `levelone_count` int(11) NOT NULL,
  `mining_days` int(11) NOT NULL,
  `mining_daysprofit` decimal(24,8) DEFAULT NULL,
  `mining_invite` decimal(24,8) DEFAULT NULL,
  `mining_invitelimit` decimal(24,8) DEFAULT NULL,
  `mining_unit` varchar(255) NOT NULL,
  `mining_period` int(11) NOT NULL,
  `hold_limit` decimal(24,8) DEFAULT NULL,
  `hold_unit` varchar(255) DEFAULT NULL,
  `locked_days` int(11) NOT NULL,
  `locked_fee` decimal(24,8) DEFAULT NULL,
  `locked_period` int(11) NOT NULL,
  `locked_unit` varchar(255) DEFAULT NULL,
  `release_amount` decimal(24,8) DEFAULT NULL,
  `release_percent` decimal(24,8) DEFAULT NULL,
  `release_times` decimal(24,8) DEFAULT NULL,
  `release_type` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='创新实验室'

=== TABLE: activity_copy1 (rows: 0) ===
CREATE TABLE `activity_copy1` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `activity_link` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `notice_link` varchar(255) DEFAULT NULL,
  `progress` int(11) NOT NULL,
  `settings` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `step` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL,
  `accept_unit` varchar(255) NOT NULL,
  `amount_scale` int(11) NOT NULL,
  `banner_image_url` varchar(255) DEFAULT NULL,
  `content` text,
  `contenten` text,
  `detailen` varchar(255) DEFAULT NULL,
  `end_time` varchar(30) NOT NULL DEFAULT '2000-01-01 01:00:00' COMMENT '结束时间',
  `limit_times` int(11) NOT NULL,
  `max_limit_amout` decimal(24,8) DEFAULT NULL,
  `min_limit_amout` decimal(24,8) DEFAULT NULL,
  `price` decimal(18,8) DEFAULT NULL,
  `price_scale` int(11) NOT NULL,
  `small_image_url` varchar(255) DEFAULT NULL,
  `start_time` varchar(30) NOT NULL DEFAULT '2000-01-01 01:00:00' COMMENT '开始时间',
  `titleen` varchar(255) DEFAULT NULL,
  `total_supply` decimal(24,8) NOT NULL,
  `traded_amount` decimal(24,8) DEFAULT NULL,
  `unit` varchar(255) NOT NULL,
  `freeze_amount` decimal(26,8) DEFAULT NULL,
  `levelone_count` int(11) NOT NULL,
  `mining_days` int(11) NOT NULL,
  `mining_daysprofit` decimal(24,8) DEFAULT NULL,
  `mining_invite` decimal(24,8) DEFAULT NULL,
  `mining_invitelimit` decimal(24,8) DEFAULT NULL,
  `mining_unit` varchar(255) NOT NULL,
  `mining_period` int(11) NOT NULL,
  `hold_limit` decimal(24,8) DEFAULT NULL,
  `hold_unit` varchar(255) DEFAULT NULL,
  `locked_days` int(11) NOT NULL,
  `locked_fee` decimal(24,8) DEFAULT NULL,
  `locked_period` int(11) NOT NULL,
  `locked_unit` varchar(255) DEFAULT NULL,
  `release_amount` decimal(24,8) DEFAULT NULL,
  `release_percent` decimal(24,8) DEFAULT NULL,
  `release_times` decimal(24,8) DEFAULT NULL,
  `release_type` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='创新实验室'

=== TABLE: activity_order (rows: 0) ===
CREATE TABLE `activity_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `activity_id` bigint(20) DEFAULT NULL,
  `amount` decimal(24,8) DEFAULT NULL,
  `base_symbol` varchar(255) DEFAULT NULL,
  `coin_symbol` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `freeze_amount` decimal(24,8) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `price` decimal(24,8) DEFAULT NULL,
  `state` int(11) NOT NULL,
  `turnover` decimal(26,16) DEFAULT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: admin (rows: 2) ===
CREATE TABLE `admin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `avatar` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `enable` int(11) DEFAULT NULL,
  `last_login_ip` varchar(255) DEFAULT NULL,
  `last_login_time` datetime DEFAULT NULL,
  `mobile_phone` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `qq` varchar(255) DEFAULT NULL,
  `real_name` varchar(255) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `username` varchar(255) NOT NULL,
  `department_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_gfn44sntic2k93auag97juyij` (`username`) USING BTREE,
  KEY `FKibjnyhe6m46qfkc6vgbir1ucq` (`department_id`) USING BTREE,
  CONSTRAINT `FKnmmt6f2kg0oaxr11uhy7qqf3w` FOREIGN KEY (`department_id`) REFERENCES `department` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='管理员'

=== TABLE: admin_access_log (rows: 0) ===
CREATE TABLE `admin_access_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `access_ip` varchar(255) DEFAULT NULL,
  `access_method` varchar(255) DEFAULT NULL,
  `access_time` datetime DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `module` int(11) DEFAULT NULL,
  `operation` varchar(255) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4023250 DEFAULT CHARSET=utf8 COMMENT='管理员访问日志'

=== TABLE: admin_permission (rows: 277) ===
CREATE TABLE `admin_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='后台菜单'

=== TABLE: admin_role (rows: 2) ===
CREATE TABLE `admin_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) DEFAULT NULL,
  `role` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COMMENT='后台角色'

=== TABLE: admin_role_permission (rows: 478) ===
CREATE TABLE `admin_role_permission` (
  `role_id` bigint(20) NOT NULL,
  `rule_id` bigint(20) NOT NULL,
  UNIQUE KEY `UKplesprlvm1sob8nl9yc5rgh3m` (`role_id`,`rule_id`) USING BTREE,
  KEY `FK52rddd3qje4p49iubt08gplb5` (`role_id`) USING BTREE,
  KEY `FKqf3fhgl5mjqqb0jeupx7yafh0` (`rule_id`) USING BTREE,
  CONSTRAINT `FK52rddd3qje4p49iubt08gplb5` FOREIGN KEY (`role_id`) REFERENCES `admin_role` (`id`),
  CONSTRAINT `FKqf3fhgl5mjqqb0jeupx7yafh0` FOREIGN KEY (`rule_id`) REFERENCES `admin_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台用户权限'

=== TABLE: advertise (rows: 0) ===
CREATE TABLE `advertise` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `advertise_type` int(11) NOT NULL,
  `auto` int(11) DEFAULT NULL,
  `autoword` varchar(255) DEFAULT NULL,
  `coin_unit` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `deal_amount` decimal(18,8) DEFAULT NULL COMMENT '交易中数量',
  `level` int(11) DEFAULT NULL,
  `limit_money` varchar(255) DEFAULT NULL,
  `max_limit` decimal(18,2) DEFAULT NULL COMMENT '最高单笔交易额',
  `min_limit` decimal(18,2) DEFAULT NULL COMMENT '最低单笔交易额',
  `number` decimal(18,8) DEFAULT NULL COMMENT '计划数量',
  `pay_mode` varchar(255) DEFAULT NULL,
  `premise_rate` decimal(18,6) DEFAULT NULL COMMENT '溢价百分比',
  `price` decimal(18,2) DEFAULT NULL COMMENT '交易价格',
  `price_type` int(11) NOT NULL,
  `remain_amount` decimal(18,8) DEFAULT NULL COMMENT '计划剩余数量',
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `audit_status` int(2) DEFAULT '0' COMMENT '审核状态0待审核1审核通过2不通过',
  `audit_remark` varchar(255) DEFAULT NULL COMMENT '审核不通过备注',
  `time_limit` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `version` bigint(20) DEFAULT NULL,
  `coin_id` bigint(20) NOT NULL,
  `country` varchar(255) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK75rse9iecdnimf8ugtf20c43l` (`coin_id`) USING BTREE,
  KEY `FK9lueh92242ckyajg17xr9tcie` (`country`) USING BTREE,
  KEY `FKspoip5yq9ednwwondsga9c9k6` (`member_id`) USING BTREE,
  CONSTRAINT `FK75rse9iecdnimf8ugtf20c43l` FOREIGN KEY (`coin_id`) REFERENCES `otc_coin` (`id`),
  CONSTRAINT `FK9lueh92242ckyajg17xr9tcie` FOREIGN KEY (`country`) REFERENCES `country` (`zh_name`),
  CONSTRAINT `FKspoip5yq9ednwwondsga9c9k6` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: agent_daily_info (rows: 0) ===
CREATE TABLE `agent_daily_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `balance` decimal(19,8) NOT NULL,
  `recharge` decimal(19,8) NOT NULL,
  `withdraw` decimal(19,8) NOT NULL,
  `profit` decimal(19,8) NOT NULL,
  `loss` decimal(19,8) NOT NULL,
  `fee` decimal(19,8) NOT NULL,
  `award` decimal(19,8) NOT NULL,
  `create_time` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=439220 DEFAULT CHARSET=utf8mb4

=== TABLE: agent_info (rows: 0) ===
CREATE TABLE `agent_info` (
  `id` bigint(20) NOT NULL,
  `name` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `address` varchar(4000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: agent_level (rows: 0) ===
CREATE TABLE `agent_level` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `level` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: airdrop_event (rows: 0) ===
CREATE TABLE `airdrop_event` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `source_member_id` bigint(20) NOT NULL,
  `source_user_name` varchar(200) NOT NULL,
  `type` int(1) NOT NULL,
  `source_type` int(2) NOT NULL,
  `amount` int(6) NOT NULL,
  `content` varchar(200) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: airdrop_mission (rows: 0) ===
CREATE TABLE `airdrop_mission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` int(20) DEFAULT NULL,
  `source_member_id` int(20) NOT NULL,
  `max_recharge` decimal(18,8) NOT NULL,
  `order_count` int(6) NOT NULL,
  `type` int(1) NOT NULL,
  `sign_count` int(6) NOT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_status` int(1) NOT NULL,
  `remind_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `source_member_id` (`source_member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: airdrop_wallet (rows: 0) ===
CREATE TABLE `airdrop_wallet` (
  `id` bigint(20) NOT NULL,
  `balance` decimal(18,8) NOT NULL,
  `frozen_balance` decimal(18,8) NOT NULL,
  `total_balance` decimal(18,8) NOT NULL,
  `thawed_balance` decimal(18,8) NOT NULL,
  `sign_clear` int(1) NOT NULL,
  `order_clear` int(1) NOT NULL,
  `first_recharge` decimal(18,8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: android_log (rows: 0) ===
CREATE TABLE `android_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `error` varchar(2000) DEFAULT NULL,
  `os` varchar(2000) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5618427 DEFAULT CHARSET=utf8

=== TABLE: announcement (rows: 4) ===
CREATE TABLE `announcement` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` mediumtext,
  `create_time` datetime DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `is_show` bit(1) DEFAULT NULL,
  `is_popup` bit(1) DEFAULT NULL,
  `is_top` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `lang` varchar(255) DEFAULT NULL,
  `announcement_classification` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='公告'

=== TABLE: app_revision (rows: 2) ===
CREATE TABLE `app_revision` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `download_url` varchar(255) DEFAULT NULL,
  `platform` int(11) DEFAULT NULL,
  `publish_time` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `version` varchar(255) DEFAULT NULL,
  `lowest_version` varchar(255) DEFAULT NULL,
  `update_description` text,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='APP版本'

=== TABLE: appeal (rows: 0) ===
CREATE TABLE `appeal` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `associate_id` bigint(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `deal_with_time` datetime DEFAULT NULL,
  `initiator_id` bigint(20) DEFAULT NULL,
  `is_success` int(11) DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `order_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_todwxorutclquf69bwow70kml` (`order_id`) USING BTREE,
  KEY `FKanmcnj859x2tv3y0pv7u05cqa` (`admin_id`) USING BTREE,
  CONSTRAINT `FKanmcnj859x2tv3y0pv7u05cqa` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`),
  CONSTRAINT `FKs3vo8h01sq39icylq1qdwekn1` FOREIGN KEY (`order_id`) REFERENCES `otc_order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OTC投诉'

=== TABLE: bug_report (rows: 0) ===
CREATE TABLE `bug_report` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `report_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `bug_content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: business_auth_apply (rows: 0) ===
CREATE TABLE `business_auth_apply` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(19,2) DEFAULT NULL,
  `auditing_time` datetime DEFAULT NULL,
  `auth_info` text,
  `certified_business_status` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `deposit_record_id` varchar(255) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `business_auth_deposit_id` bigint(20) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKds72omottejlk5isd34ha5i10` (`business_auth_deposit_id`) USING BTREE,
  KEY `FKdghp8ri44t77ntuw06gicphuu` (`member_id`) USING BTREE,
  CONSTRAINT `FKdghp8ri44t77ntuw06gicphuu` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FKds72omottejlk5isd34ha5i10` FOREIGN KEY (`business_auth_deposit_id`) REFERENCES `business_auth_deposit` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OTC商家申请'

=== TABLE: business_auth_deposit (rows: 0) ===
CREATE TABLE `business_auth_deposit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,8) DEFAULT NULL COMMENT '保证金数额',
  `create_time` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKfj3hxtr3ae1yma9bxeuqc29pj` (`admin_id`) USING BTREE,
  KEY `FKjx7799a3pwdtnu43fkpn27kj6` (`coin_id`) USING BTREE,
  CONSTRAINT `FKfj3hxtr3ae1yma9bxeuqc29pj` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`),
  CONSTRAINT `FKjx7799a3pwdtnu43fkpn27kj6` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OTC商家质押币种'

=== TABLE: bussiness_cancel_apply (rows: 0) ===
CREATE TABLE `bussiness_cancel_apply` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cancel_apply_time` datetime DEFAULT NULL,
  `deposit_record_id` varchar(255) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `handle_time` datetime DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKbwtwtm0jd1eqa8dh7e8ychcx1` (`member_id`) USING BTREE,
  CONSTRAINT `FKbwtwtm0jd1eqa8dh7e8ychcx1` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OTC商家退出'

=== TABLE: coin (rows: 38) ===
CREATE TABLE `coin` (
  `id` bigint(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `can_auto_withdraw` int(11) DEFAULT NULL,
  `can_recharge` int(11) DEFAULT NULL,
  `can_transfer` int(11) DEFAULT NULL,
  `can_withdraw` int(11) DEFAULT NULL,
  `cny_rate` double NOT NULL,
  `enable_rpc` int(11) DEFAULT NULL,
  `is_platform_coin` int(11) DEFAULT NULL,
  `max_tx_fee` double NOT NULL,
  `max_withdraw_amount` decimal(18,8) DEFAULT NULL COMMENT '最大提币数量',
  `min_tx_fee` double NOT NULL,
  `min_withdraw_amount` decimal(18,8) DEFAULT NULL COMMENT '最小提币数量',
  `name_cn` varchar(255) NOT NULL,
  `sort` int(11) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `unit` varchar(255) NOT NULL,
  `usd_rate` double NOT NULL,
  `withdraw_threshold` decimal(18,8) DEFAULT NULL COMMENT '提现阈值',
  `has_legal` bit(1) NOT NULL DEFAULT b'0',
  `cold_wallet_address` varchar(255) DEFAULT NULL,
  `miner_fee` decimal(18,8) DEFAULT NULL COMMENT '矿工费',
  `withdraw_scale` int(11) DEFAULT '4' COMMENT '提币精度',
  `information` varchar(255) DEFAULT NULL,
  `infolink` varchar(255) DEFAULT NULL,
  `account_type` int(11) DEFAULT '0' COMMENT '币种账户类型',
  `deposit_address` varchar(255) DEFAULT NULL,
  `min_recharge_amount` decimal(18,8) DEFAULT NULL COMMENT '最小充值数量',
  `withdraw_fee_type` int(2) NOT NULL DEFAULT '0',
  `withdraw_fee_value` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `can_search` int(1) DEFAULT NULL,
  PRIMARY KEY (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='币种'

=== TABLE: contract_coin (rows: 26) ===
CREATE TABLE `contract_coin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `base_coin_scale` int(11) NOT NULL,
  `base_symbol` varchar(255) DEFAULT NULL,
  `close_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '平仓手续费',
  `coin_scale` int(11) NOT NULL,
  `coin_symbol` varchar(255) DEFAULT NULL,
  `enable` int(2) DEFAULT '1' COMMENT '状态',
  `enable_market_buy` int(2) DEFAULT '1' COMMENT '是否启用市价开仓做多',
  `enable_market_sell` int(2) DEFAULT '1' COMMENT '是否启用市价开仓做空',
  `enable_open_buy` int(2) DEFAULT '1' COMMENT '是否允许开仓做多',
  `enable_open_sell` int(2) DEFAULT '1' COMMENT '是否允许开仓做空',
  `enable_trigger_entrust` int(2) DEFAULT '1' COMMENT '是否启用开仓计划委托',
  `exchangeable` int(2) DEFAULT '1' COMMENT '是否可交易',
  `fee_percent` decimal(18,8) DEFAULT '0.00100000' COMMENT '隔夜费率',
  `interval_hour` int(11) DEFAULT '1' COMMENT '点差类型',
  `leverage` varchar(255) DEFAULT NULL,
  `leverage_type` int(2) DEFAULT '1' COMMENT '点差类型',
  `maintenance_margin_rate` decimal(18,8) DEFAULT '0.00500000' COMMENT '维持保证金率',
  `maker_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '平多手续费',
  `max_share` decimal(18,8) DEFAULT '1000.00000000' COMMENT '最大手数',
  `min_share` decimal(18,8) DEFAULT '1.00000000' COMMENT '最小手数',
  `name` varchar(255) DEFAULT NULL,
  `open_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '开仓手续费',
  `share_number` decimal(18,8) DEFAULT '0.00000000' COMMENT '单位手数',
  `sort` int(11) NOT NULL,
  `spread` decimal(18,8) DEFAULT '0.00000000' COMMENT '点差',
  `spread_type` int(2) DEFAULT '1' COMMENT '点差类型',
  `symbol` varchar(255) DEFAULT NULL,
  `taker_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '平空手续费',
  `total_close_fee` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约总平仓手续费',
  `total_loss` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约平台亏损',
  `total_open_fee` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约总开仓手续费',
  `total_profit` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约平台盈利',
  `type` int(11) DEFAULT '0' COMMENT '合约类型',
  `visible` int(2) DEFAULT '1' COMMENT '前台可见状态',
  `max_total_share` decimal(18,8) DEFAULT NULL,
  `max_upper_total_share` decimal(18,8) DEFAULT NULL,
  `leverage_threshold` int(6) DEFAULT NULL,
  `max_top_total_share` decimal(18,8) DEFAULT NULL,
  `top_leverage_threshold` int(6) DEFAULT NULL,
  `follow_fee` decimal(18,8) DEFAULT NULL,
  `min_scale` int(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='永续合约交易对'

=== TABLE: contract_option (rows: 0) ===
CREATE TABLE `contract_option` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `close_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '收盘价格',
  `close_time` bigint(20) DEFAULT NULL,
  `create_time` bigint(20) DEFAULT NULL,
  `init_buy` decimal(18,8) DEFAULT '0.00000000' COMMENT '买涨奖池总金额',
  `init_sell` decimal(18,8) DEFAULT '0.00000000' COMMENT '买涨奖池总金额',
  `open_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '开盘价格',
  `open_time` bigint(20) DEFAULT NULL,
  `option_no` int(11) DEFAULT '0' COMMENT '合约序号',
  `result` int(4) DEFAULT '1' COMMENT '当局结果',
  `status` int(4) DEFAULT '1' COMMENT '本期合约状态',
  `symbol` varchar(255) DEFAULT NULL,
  `total_buy` decimal(18,8) DEFAULT '0.00000000' COMMENT '买涨奖池总金额',
  `total_buy_count` int(11) DEFAULT '0' COMMENT '买涨人数',
  `total_pl` decimal(18,8) DEFAULT '0.00000000' COMMENT '买涨奖池总金额',
  `total_sell` decimal(18,8) DEFAULT '0.00000000' COMMENT '买跌奖池总金额',
  `total_sell_count` int(11) DEFAULT '0' COMMENT '买涨人数',
  `preset_price` decimal(18,8) DEFAULT NULL COMMENT '预设价格',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='期权合约开奖记录'

=== TABLE: contract_option_coin (rows: 0) ===
CREATE TABLE `contract_option_coin` (
  `symbol` varchar(255) NOT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `base_coin_scale` int(11) DEFAULT '4' COMMENT '基币小数精度',
  `base_symbol` varchar(255) DEFAULT NULL,
  `close_time_gap` int(11) DEFAULT '300' COMMENT '开盘到收盘时间间隔',
  `coin_scale` int(11) DEFAULT '4' COMMENT '交易币小数精度',
  `coin_symbol` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `enable` int(2) DEFAULT '1' COMMENT '状态',
  `enable_buy` int(2) DEFAULT '1' COMMENT '是否允许看涨',
  `enable_sell` int(2) DEFAULT '1' COMMENT '是否允许看跌',
  `oods` decimal(8,4) DEFAULT '1.0000' COMMENT '赔率',
  `fee_percent` decimal(8,4) DEFAULT '0.0000' COMMENT '开仓手续费',
  `init_buy_reward` decimal(12,4) DEFAULT '0.0000' COMMENT '初始买涨奖池金额',
  `init_sell_reward` decimal(12,4) DEFAULT '0.0000' COMMENT '初始买跌奖池金额',
  `max_option_no` int(11) DEFAULT '0' COMMENT '最新期号',
  `name` varchar(255) DEFAULT NULL,
  `ngnore_percent` decimal(8,4) DEFAULT '0.0001' COMMENT '忽视涨跌幅度',
  `open_time_gap` int(11) DEFAULT '300' COMMENT '开始到开盘时间间隔',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `tied_type` int(2) DEFAULT '1' COMMENT '平局处理方式',
  `total_profit` decimal(8,4) DEFAULT '0.0000' COMMENT '预测合约总盈利',
  `visible` int(2) DEFAULT '1' COMMENT '前台可见状态',
  `win_fee_percent` decimal(8,4) DEFAULT '0.0010' COMMENT '赢家手续费',
  PRIMARY KEY (`symbol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='期权合约交易对'

=== TABLE: contract_option_order (rows: 0) ===
CREATE TABLE `contract_option_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `base_symbol` varchar(255) DEFAULT NULL,
  `bet_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '投注金额',
  `coin_symbol` varchar(255) DEFAULT NULL,
  `create_time` bigint(20) DEFAULT NULL,
  `direction` int(4) DEFAULT '1' COMMENT '方向',
  `fee` decimal(18,8) DEFAULT '0.00000000' COMMENT '手续费',
  `member_id` bigint(20) DEFAULT NULL,
  `option_id` bigint(20) DEFAULT NULL,
  `option_no` int(11) DEFAULT '0' COMMENT '合约序号',
  `result` int(4) DEFAULT '1' COMMENT '参与结果',
  `reward_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '胜利奖金',
  `status` int(4) DEFAULT '1' COMMENT '订单状态',
  `symbol` varchar(255) DEFAULT NULL,
  `win_fee` decimal(18,8) DEFAULT '0.00000000' COMMENT '抽水',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='期权合约订单'

=== TABLE: contract_order_entrust (rows: 0) ===
CREATE TABLE `contract_order_entrust` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `base_symbol` varchar(255) DEFAULT NULL,
  `close_fee` decimal(18,8) DEFAULT '0.00000000' COMMENT '开仓手续费',
  `coin_symbol` varchar(255) DEFAULT NULL,
  `contract_id` bigint(20) DEFAULT NULL,
  `contract_order_entrust_id` varchar(255) DEFAULT NULL,
  `create_time` bigint(20) DEFAULT NULL,
  `current_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '下单时价',
  `direction` int(11) DEFAULT '1' COMMENT '方向',
  `entrust_price` decimal(18,8) DEFAULT NULL,
  `entrust_type` int(11) DEFAULT '0' COMMENT '委托订单类型',
  `is_blast` int(2) DEFAULT '0' COMMENT '是否是计划委托的委托单',
  `is_from_spot` int(2) DEFAULT '0' COMMENT '是否是计划委托的委托单',
  `member_id` bigint(20) DEFAULT NULL,
  `open_fee` decimal(18,8) DEFAULT '0.00000000' COMMENT '开仓手续费',
  `patterns` int(11) DEFAULT '1' COMMENT '仓位模式',
  `principal_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '本金数量',
  `principal_unit` varchar(255) DEFAULT NULL,
  `profit_and_loss` decimal(18,8) DEFAULT '0.00000000' COMMENT '盈亏',
  `share_number` decimal(18,8) DEFAULT '0.00000000' COMMENT '合约面值',
  `status` int(11) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `traded_price` decimal(18,8) DEFAULT NULL,
  `traded_volume` decimal(18,8) DEFAULT '0.00000000' COMMENT '委托数量',
  `trigger_price` decimal(18,8) DEFAULT NULL,
  `triggering_time` bigint(20) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `volume` decimal(18,8) DEFAULT '0.00000000' COMMENT '委托数量',
  `is_reward` int(2) DEFAULT '0' COMMENT '是否已返佣',
  `loss_price` decimal(18,8) DEFAULT '0.00000000',
  `loss_entrust_price` decimal(18,8) DEFAULT '0.00000000',
  `profit_price` decimal(18,8) DEFAULT '0.00000000',
  `profit_entrust_price` decimal(18,8) DEFAULT '0.00000000',
  `is_cut` int(2) DEFAULT '0',
  `usdt_open_time` bigint(20) DEFAULT '0',
  `usdt_open_price` decimal(19,8) DEFAULT '0.00000000',
  `is_one_close` int(2) DEFAULT '0',
  `is_limit_price` int(2) DEFAULT '0',
  `is_market_all_close` int(2) DEFAULT '0',
  `is_open` int(2) DEFAULT '0',
  `is_reversed_open` int(2) DEFAULT '0',
  `leverage` int(6) DEFAULT NULL,
  `deal_time` bigint(20) DEFAULT '0',
  `position_id` bigint(20) DEFAULT NULL,
  `position_type` int(1) NOT NULL,
  `money_type` int(1) NOT NULL DEFAULT '1',
  `open_type` int(1) DEFAULT NULL,
  `close_type` int(1) DEFAULT NULL,
  `decimal_scale` int(1) NOT NULL DEFAULT '1',
  `is_percentage` int(1) DEFAULT NULL,
  `violate_time` int(1) DEFAULT NULL,
  `follow_id` bigint(20) DEFAULT NULL,
  `follow_system_id` bigint(20) DEFAULT NULL,
  `dividend_percent` decimal(18,8) DEFAULT NULL,
  `is_special` int(1) DEFAULT NULL,
  `percentage_volume` decimal(6,4) DEFAULT NULL,
  `cut_type` int(1) DEFAULT NULL,
  `min_follow_amount` decimal(18,8) DEFAULT NULL,
  `max_follow_amount` decimal(18,8) DEFAULT NULL,
  `trigger_counter` int(6) NOT NULL DEFAULT '0',
  `is_add` int(1) DEFAULT NULL,
  `hedge_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `position_id` (`position_id`),
  KEY `status` (`status`),
  KEY `create_time` (`create_time`),
  KEY `is_reward` (`is_reward`),
  KEY `is_reward_2` (`is_reward`)
) ENGINE=InnoDB AUTO_INCREMENT=1564039 DEFAULT CHARSET=utf8 COMMENT='永续合约委托'

=== TABLE: contract_reward_record (rows: 0) ===
CREATE TABLE `contract_reward_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `num` decimal(18,8) DEFAULT NULL COMMENT '奖励数量',
  `type` int(11) DEFAULT NULL,
  `coin_id` varchar(255) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `from_member_id` bigint(20) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKpealk2hwhjppr85yi2764xhpo` (`coin_id`),
  KEY `FK390fr8sh5bnxuc8q23gat1kcl` (`order_id`),
  KEY `FK5ofrlnudc62tw7cc4ghapkjmp` (`from_member_id`),
  KEY `FKpto449dtrxryaovu5yrg5dm62` (`member_id`),
  KEY `create_time` (`create_time`),
  CONSTRAINT `FK390fr8sh5bnxuc8q23gat1kcl` FOREIGN KEY (`order_id`) REFERENCES `contract_order_entrust` (`id`),
  CONSTRAINT `FK5ofrlnudc62tw7cc4ghapkjmp` FOREIGN KEY (`from_member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FKpealk2hwhjppr85yi2764xhpo` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`),
  CONSTRAINT `FKpto449dtrxryaovu5yrg5dm62` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8586735 DEFAULT CHARSET=utf8 COMMENT='永续合约奖励记录'

=== TABLE: contract_second_coin (rows: 0) ===
CREATE TABLE `contract_second_coin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `base_coin_scale` int(11) NOT NULL,
  `base_symbol` varchar(255) DEFAULT NULL,
  `close_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '平仓手续费',
  `coin_scale` int(11) NOT NULL,
  `coin_symbol` varchar(255) DEFAULT NULL,
  `enable` int(2) DEFAULT '1' COMMENT '状态',
  `enable_market_buy` int(2) DEFAULT '1' COMMENT '是否启用市价开仓做多',
  `enable_market_sell` int(2) DEFAULT '1' COMMENT '是否启用市价开仓做空',
  `enable_open_buy` int(2) DEFAULT '1' COMMENT '是否允许开仓做多',
  `enable_open_sell` int(2) DEFAULT '1' COMMENT '是否允许开仓做空',
  `enable_trigger_entrust` int(2) DEFAULT '1' COMMENT '是否启用开仓计划委托',
  `exchangeable` int(2) DEFAULT '1' COMMENT '是否可交易',
  `fee_percent` decimal(18,8) DEFAULT '0.00100000' COMMENT '隔夜费率',
  `interval_hour` int(11) DEFAULT '1' COMMENT '点差类型',
  `leverage` varchar(255) DEFAULT NULL,
  `leverage_type` int(2) DEFAULT '1' COMMENT '点差类型',
  `maintenance_margin_rate` decimal(18,8) DEFAULT '0.00500000' COMMENT '维持保证金率',
  `maker_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '平多手续费',
  `max_share` decimal(18,8) DEFAULT '1000.00000000' COMMENT '最大手数',
  `min_share` decimal(18,8) DEFAULT '1.00000000' COMMENT '最小手数',
  `name` varchar(255) DEFAULT NULL,
  `open_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '开仓手续费',
  `share_number` decimal(18,8) DEFAULT '0.00000000' COMMENT '单位手数',
  `sort` int(11) NOT NULL,
  `spread` decimal(18,8) DEFAULT '0.00000000' COMMENT '点差',
  `spread_type` int(2) DEFAULT '1' COMMENT '点差类型',
  `symbol` varchar(255) DEFAULT NULL,
  `taker_fee` decimal(18,8) DEFAULT '0.00010000' COMMENT '平空手续费',
  `total_close_fee` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约总平仓手续费',
  `total_loss` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约平台亏损',
  `total_open_fee` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约总开仓手续费',
  `total_profit` decimal(26,8) DEFAULT '0.00000000' COMMENT '合约平台盈利',
  `type` int(11) DEFAULT '0' COMMENT '合约类型',
  `visible` int(2) DEFAULT '1' COMMENT '前台可见状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='秒合约交易对'

=== TABLE: contract_second_cycle (rows: 0) ===
CREATE TABLE `contract_second_cycle` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cycle_rate` decimal(20,8) DEFAULT '0.00000000' COMMENT '周期赔率',
  `cycle_length` bigint(20) DEFAULT NULL COMMENT '周期时长（秒）',
  `min_amount` decimal(20,8) DEFAULT '0.00000000' COMMENT '最小数量',
  `max_amount` decimal(20,8) DEFAULT '0.00000000' COMMENT '最大数量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='秒合约周期'

=== TABLE: contract_second_order (rows: 0) ===
CREATE TABLE `contract_second_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bet_amount` decimal(20,8) DEFAULT '0.00000000' COMMENT '投注金额',
  `coin_symbol` varchar(50) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `direction` int(4) DEFAULT '1' COMMENT '方向',
  `fee` decimal(20,8) DEFAULT '0.00000000' COMMENT '手续费',
  `member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `cycle_id` bigint(20) DEFAULT NULL COMMENT '周期id',
  `cycle_rate` decimal(20,8) DEFAULT NULL COMMENT '周期赔率',
  `cycle_length` bigint(20) DEFAULT NULL COMMENT '周期时长（秒）',
  `open_price` decimal(20,8) DEFAULT '0.00000000' COMMENT '开仓价格',
  `close_price` decimal(20,8) DEFAULT '0.00000000' COMMENT '平仓价格',
  `pre_close_price` decimal(20,8) DEFAULT '0.00000000' COMMENT '预设平仓价格',
  `type` int(2) DEFAULT '0' COMMENT '是否包赔 0否 1是',
  `result` int(4) DEFAULT '0' COMMENT '结果 0无结果 1成功 2失败 3撤销',
  `win_amount` decimal(20,8) DEFAULT '0.00000000' COMMENT '盈利数量',
  `status` int(4) DEFAULT '0' COMMENT '订单状态 0委托中 1持仓中 2平仓 3撤销',
  `close_time` datetime DEFAULT NULL COMMENT '结束时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='秒合约订单'

=== TABLE: contract_second_set (rows: 0) ===
CREATE TABLE `contract_second_set` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `start_time` varchar(50) DEFAULT NULL COMMENT '包赔开始时间（时分 HH:mm:ss）',
  `end_time` varchar(50) DEFAULT NULL COMMENT '包赔结束时间（时分 HH:mm:ss）',
  `order_num` int(4) DEFAULT '0' COMMENT '每天包赔数量',
  `limit_rate` decimal(20,8) DEFAULT '0.00000000' COMMENT '超过余额百分比不包赔（小数）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='秒合约设置'

=== TABLE: country (rows: 235) ===
CREATE TABLE `country` (
  `zh_name` varchar(255) NOT NULL COMMENT '中文名称',
  `area_code` varchar(255) DEFAULT NULL COMMENT '英文名称',
  `en_name` varchar(255) DEFAULT NULL COMMENT '区号',
  `hk_name` varchar(255) DEFAULT NULL,
  `jp_name` varchar(255) NOT NULL,
  `kr_name` varchar(255) NOT NULL,
  `language` varchar(255) DEFAULT NULL COMMENT '语言',
  `local_currency` varchar(255) DEFAULT NULL COMMENT '当地货币缩写',
  `sort` int(11) NOT NULL COMMENT '排序',
  PRIMARY KEY (`zh_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='国家信息表'

=== TABLE: country1 (rows: 0) ===
CREATE TABLE `country1` (
  `zh_name` varchar(255) NOT NULL COMMENT '中文名称',
  `area_code` varchar(255) DEFAULT NULL COMMENT '英文名称',
  `en_name` varchar(255) DEFAULT NULL COMMENT '区号',
  `hk_name` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL COMMENT '语言',
  `local_currency` varchar(255) DEFAULT NULL COMMENT '当地货币缩写',
  `sort` int(11) NOT NULL COMMENT '排序',
  `jp_name` varchar(255) DEFAULT NULL,
  `kr_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`zh_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='国家信息表'

=== TABLE: country2 (rows: 0) ===
CREATE TABLE `country2` (
  `zh_name` varchar(255) NOT NULL,
  `area_code` int(11) DEFAULT NULL,
  `en_name` text,
  `hk_name` text,
  `language` text,
  `local_currency` text,
  `sort` int(11) DEFAULT NULL,
  `jp_name` text,
  `kr_name` text,
  PRIMARY KEY (`zh_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: ctc_acceptor (rows: 0) ===
CREATE TABLE `ctc_acceptor` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `cny_in` decimal(18,2) DEFAULT NULL COMMENT '买入CNY',
  `cny_out` decimal(18,2) DEFAULT NULL COMMENT '售出CNY',
  `usdt_in` decimal(18,2) DEFAULT NULL COMMENT '买入USDT',
  `usdt_out` decimal(18,2) DEFAULT NULL COMMENT '售出USDT',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKk3nfn54patdd6rwa0skk70tq6` (`member_id`) USING BTREE,
  CONSTRAINT `FKk3nfn54patdd6rwa0skk70tq6` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CTC商户（USDT）'

=== TABLE: ctc_order (rows: 0) ===
CREATE TABLE `ctc_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ali_no` varchar(255) DEFAULT NULL,
  `qr_code_url` varchar(255) DEFAULT NULL,
  `amount` decimal(19,2) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `card_no` varchar(255) DEFAULT NULL,
  `cancel_reason` varchar(255) DEFAULT NULL,
  `cancel_time` datetime DEFAULT NULL,
  `complete_time` datetime DEFAULT NULL,
  `confirm_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `direction` int(11) NOT NULL,
  `money` decimal(18,2) DEFAULT NULL COMMENT '交易金额',
  `order_sn` varchar(255) NOT NULL,
  `pay_mode` varchar(255) NOT NULL,
  `pay_time` datetime DEFAULT NULL,
  `price` decimal(18,2) DEFAULT NULL COMMENT '价格',
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `unit` varchar(255) NOT NULL,
  `qr_we_code_url` varchar(255) DEFAULT NULL,
  `wechat` varchar(255) DEFAULT NULL,
  `acceptor_id` bigint(20) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `real_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_t212u5lpa982v4yc0ue7c3eab` (`order_sn`) USING BTREE,
  KEY `FKgk8nq4d3ouoj9eyo1kfqtw0wq` (`acceptor_id`) USING BTREE,
  KEY `FK419ewpncecgofa3j1338d6ma6` (`member_id`) USING BTREE,
  CONSTRAINT `FK419ewpncecgofa3j1338d6ma6` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FKgk8nq4d3ouoj9eyo1kfqtw0wq` FOREIGN KEY (`acceptor_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CTC订单'

=== TABLE: cz (rows: 0) ===
CREATE TABLE `cz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` varchar(255) DEFAULT NULL,
  `uid` varchar(16) DEFAULT NULL,
  `dz` varchar(255) DEFAULT NULL,
  `coinType` varchar(255) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `state` varchar(255) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC

=== TABLE: data_dictionary (rows: 0) ===
CREATE TABLE `data_dictionary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bond` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `creation_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统信息维护'

=== TABLE: department (rows: 0) ===
CREATE TABLE `department` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `leader_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_1t68827l97cwyxo9r1u6t4p7d` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台部门'

=== TABLE: deposit_record (rows: 0) ===
CREATE TABLE `deposit_record` (
  `id` varchar(255) NOT NULL,
  `amount` decimal(19,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK7x5q0lmqqtty5i0w5mq09o8r7` (`coin_id`) USING BTREE,
  KEY `FKji8p5uoc1ad45npyf72rgf2lx` (`member_id`) USING BTREE,
  CONSTRAINT `FK7x5q0lmqqtty5i0w5mq09o8r7` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`),
  CONSTRAINT `FKji8p5uoc1ad45npyf72rgf2lx` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='存款记录'

=== TABLE: dividend_start_record (rows: 0) ===
CREATE TABLE `dividend_start_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,6) DEFAULT NULL COMMENT '数量',
  `date` datetime DEFAULT NULL,
  `end` bigint(20) DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `rate` decimal(18,2) DEFAULT NULL COMMENT '比例',
  `start` bigint(20) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK226c1iy2t1dt9tjjo20pum39d` (`admin_id`) USING BTREE,
  CONSTRAINT `FK226c1iy2t1dt9tjjo20pum39d` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='持币分息记录'

=== TABLE: entrust_change_history (rows: 0) ===
CREATE TABLE `entrust_change_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `type` int(1) NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `create_time` datetime NOT NULL,
  `unfreeze_time` datetime DEFAULT NULL,
  `status` int(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: exchange_asset_flow (rows: 0) ===
CREATE TABLE `exchange_asset_flow` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流水序号,自增主键',
  `transaction_id` bigint(20) DEFAULT NULL COMMENT '交易ID',
  `from_exchange_wallet_id` bigint(20) DEFAULT NULL COMMENT '资金来源钱包id',
  `to_exchange_wallet_id` bigint(20) DEFAULT NULL COMMENT '资金去向钱包id',
  `coin_symbol` varchar(255) NOT NULL COMMENT '币种名称或代码',
  `business_type` int(11) NOT NULL COMMENT '业务类型,具体可取值见上文',
  `amount` decimal(26,8) DEFAULT '0.00000000' COMMENT '变动金额,可为正(入金)或负(出金)',
  `frozen_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '冻结变动量,可为正(冻结)或负(解冻)',
  `available_balance` decimal(26,8) DEFAULT '0.00000000' COMMENT '流水后用户钱包的可用余额',
  `fee` decimal(18,8) DEFAULT '0.00000000' COMMENT '手续费,部分业务类型可能产生的手续费',
  `remark` varchar(255) DEFAULT NULL COMMENT '流水备注,部分业务类型的备注信息',
  `created_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '流水创建时间',
  PRIMARY KEY (`id`),
  KEY `transaction_id` (`transaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1500 DEFAULT CHARSET=utf8 COMMENT='资产流水表'

=== TABLE: exchange_code (rows: 0) ===
CREATE TABLE `exchange_code` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: exchange_coin (rows: 19) ===
CREATE TABLE `exchange_coin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `symbol` varchar(255) NOT NULL,
  `base_coin_scale` int(11) NOT NULL,
  `base_symbol` varchar(255) DEFAULT NULL,
  `coin_scale` int(11) NOT NULL,
  `coin_symbol` varchar(255) DEFAULT NULL,
  `enable` int(11) NOT NULL,
  `fee` decimal(8,4) DEFAULT NULL COMMENT '交易手续费',
  `sell_fee` decimal(8,4) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `enable_market_buy` int(11) DEFAULT '1' COMMENT '是否启用市价买',
  `enable_market_sell` int(11) DEFAULT '1' COMMENT '是否启用市价卖',
  `min_sell_price` decimal(18,8) DEFAULT NULL COMMENT '最低挂单卖价',
  `flag` int(11) DEFAULT '0' COMMENT '默认为0，1表示推荐',
  `max_trading_order` int(11) DEFAULT '0' COMMENT '最大允许同时交易的订单数，0表示不限制',
  `max_trading_time` int(11) DEFAULT '0' COMMENT '委托超时自动下架时间，单位为秒，0表示不过期',
  `instrument` varchar(20) DEFAULT NULL COMMENT '交易类型，B2C2特有',
  `min_turnover` decimal(18,8) DEFAULT NULL COMMENT '最小挂单成交额',
  `max_volume` decimal(18,8) DEFAULT NULL COMMENT '最大下单量',
  `min_volume` decimal(18,8) DEFAULT NULL COMMENT '最小下单量',
  `zone` int(11) DEFAULT '0',
  `clear_time` varchar(30) DEFAULT '1' COMMENT '清盘时间',
  `end_time` varchar(30) DEFAULT '1' COMMENT '结束时间',
  `publish_price` decimal(18,8) DEFAULT NULL COMMENT ' 分摊发行价格',
  `publish_type` int(11) DEFAULT '1' COMMENT '发行活动类型 1:无活动,2:抢购发行,3:分摊发行',
  `start_time` varchar(30) DEFAULT '1' COMMENT '开始时间',
  `exchangeable` int(11) DEFAULT '1' COMMENT ' 是否可交易',
  `publish_amount` decimal(18,8) DEFAULT NULL COMMENT ' 活动发行数量',
  `visible` int(11) DEFAULT '1' COMMENT ' 前台可见状态',
  `max_buy_price` decimal(18,8) DEFAULT NULL COMMENT '最高买单价',
  `robot_type` int(11) DEFAULT '0' COMMENT '机器人类型',
  `enable_buy` int(11) DEFAULT '1' COMMENT '是否允许买',
  `enable_sell` int(11) DEFAULT '1' COMMENT '是否允许卖',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='币币交易对'

=== TABLE: exchange_deal (rows: 0) ===
CREATE TABLE `exchange_deal` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(32,8) NOT NULL COMMENT '金额',
  `price` decimal(32,8) NOT NULL COMMENT '价格',
  `type` int(1) DEFAULT NULL COMMENT '1.买入 2.卖出',
  `volume` decimal(32,8) NOT NULL COMMENT '数量',
  `sell_fee` decimal(16,8) DEFAULT NULL COMMENT '手续费',
  `buy_fee` decimal(16,8) NOT NULL COMMENT '手续费',
  `buy_commission_rate` decimal(16,8) NOT NULL COMMENT '买入手续费比率',
  `sell_commission_rate` decimal(16,8) DEFAULT NULL COMMENT '卖出手续费比列',
  `symbol_name` varchar(20) NOT NULL COMMENT '交易对名称',
  `buy_order_id` bigint(20) NOT NULL COMMENT '买单id',
  `sell_order_id` bigint(20) NOT NULL COMMENT '卖单id',
  `buy_account_id` bigint(20) NOT NULL COMMENT '买家id',
  `sell_account_id` bigint(20) NOT NULL COMMENT '卖家id',
  `deal_time` bigint(20) NOT NULL COMMENT '成交时间',
  `is_wallet_update` int(11) NOT NULL DEFAULT '0' COMMENT '0.未更新钱包  1.已更新钱包',
  `create_time` bigint(20) NOT NULL,
  `coin` varchar(10) NOT NULL COMMENT '交易币种',
  `base_coin` varchar(10) NOT NULL COMMENT '基础币种',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=160631 DEFAULT CHARSET=utf8mb4 COMMENT='成交表'

=== TABLE: exchange_favor_symbol (rows: 0) ===
CREATE TABLE `exchange_favor_symbol` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `add_time` varchar(255) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='交易优先符号'

=== TABLE: exchange_freeze_history (rows: 0) ===
CREATE TABLE `exchange_freeze_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `coin_id` varchar(100) NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `created_time` datetime NOT NULL,
  `updated_time` datetime NOT NULL,
  `unfreeze_time` datetime NOT NULL,
  `status` int(2) NOT NULL,
  `type` int(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: exchange_order (rows: 0) ===
CREATE TABLE `exchange_order` (
  `order_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,8) DEFAULT NULL,
  `base_symbol` varchar(255) DEFAULT NULL,
  `canceled_time` bigint(20) DEFAULT NULL,
  `coin_symbol` varchar(255) DEFAULT NULL,
  `completed_time` bigint(20) DEFAULT NULL,
  `direction` int(11) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `price` decimal(18,8) DEFAULT NULL,
  `deal_price` decimal(18,8) DEFAULT NULL,
  `trigger_price` decimal(18,8) DEFAULT NULL,
  `fee` decimal(18,8) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `traded_amount` decimal(26,16) DEFAULT NULL,
  `turnover` decimal(26,16) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `use_discount` varchar(255) DEFAULT NULL,
  `order_resource` int(11) DEFAULT NULL,
  `fee_rate` decimal(18,8) DEFAULT NULL,
  `trade_status` int(11) NOT NULL DEFAULT '0' COMMENT '撮合状态， 0 待开始 1撮合中 2 撮合停止 3 撮合完成	',
  `is_completed` int(1) NOT NULL DEFAULT '0',
  `frozen_amount` decimal(18,8) DEFAULT NULL,
  PRIMARY KEY (`order_id`) USING BTREE,
  KEY `symbol` (`symbol`,`member_id`,`status`) USING BTREE,
  KEY `member_id` (`member_id`),
  KEY `index_time` (`time`),
  KEY `index_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=365044 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='币币挂单'

=== TABLE: exchange_release_history (rows: 0) ===
CREATE TABLE `exchange_release_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `coin_id` varchar(255) NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `release_time` datetime NOT NULL,
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: exchange_statistics_data (rows: 0) ===
CREATE TABLE `exchange_statistics_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `stat_time` datetime NOT NULL COMMENT '统计时间',
  `member_id` bigint(20) NOT NULL COMMENT '用户ID',
  `stat_type` int(8) NOT NULL COMMENT '统计类别1:零点统计，2:16点统计',
  `coin_symbol` varchar(255) DEFAULT NULL COMMENT '资产币种',
  `position_asset_price_usdt` decimal(26,8) DEFAULT NULL COMMENT '持仓资产价格(USDT计价)',
  `daily_profit_loss_usdt` decimal(26,8) DEFAULT NULL COMMENT '当天盈亏(USDT)',
  `frozen_asset_price_usdt` decimal(26,8) DEFAULT NULL COMMENT '持仓资产价格(USDT计价)',
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`stat_type`,`member_id`,`stat_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=221797 DEFAULT CHARSET=utf8 COMMENT='现货统计数据表'

=== TABLE: exchange_wallet (rows: 0) ===
CREATE TABLE `exchange_wallet` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `balance` decimal(26,8) DEFAULT NULL COMMENT '可用余额',
  `frozen_balance` decimal(26,8) DEFAULT NULL COMMENT '冻结余额',
  `pledged_balance` decimal(18,8) DEFAULT NULL,
  `is_lock` int(11) DEFAULT '0' COMMENT '钱包不是锁定',
  `member_id` bigint(20) DEFAULT NULL,
  `to_released` decimal(18,8) DEFAULT NULL COMMENT '待释放总量',
  `daily_released` decimal(18,8) DEFAULT NULL,
  `version` int(11) NOT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  `release_date` date DEFAULT NULL,
  `open_price` decimal(18,8) DEFAULT '0.00000000',
  `open_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UKm68bscpof0bpnxocxl4qdnvbe` (`member_id`,`coin_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8 COMMENT='会员钱包'

=== TABLE: experience_event (rows: 0) ===
CREATE TABLE `experience_event` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `source_member_id` bigint(20) NOT NULL,
  `source_user_name` varchar(200) NOT NULL,
  `type` int(1) NOT NULL,
  `source_type` int(2) NOT NULL,
  `amount` int(6) NOT NULL,
  `content` varchar(200) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36186 DEFAULT CHARSET=utf8mb4

=== TABLE: experience_mission (rows: 0) ===
CREATE TABLE `experience_mission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` int(20) DEFAULT NULL,
  `source_member_id` int(20) NOT NULL,
  `max_recharge` decimal(18,8) NOT NULL,
  `order_count` int(6) NOT NULL,
  `type` int(1) NOT NULL,
  `sign_count` int(6) NOT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_status` int(1) NOT NULL,
  `remind_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `source_member_id` (`source_member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4

=== TABLE: experience_sign (rows: 0) ===
CREATE TABLE `experience_sign` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `source_member_id` bigint(20) NOT NULL,
  `source_user_name` varchar(200) NOT NULL,
  `sign_count` int(6) NOT NULL,
  `sign_date` date NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: experience_wallet (rows: 0) ===
CREATE TABLE `experience_wallet` (
  `id` bigint(20) NOT NULL,
  `balance` decimal(18,8) NOT NULL,
  `frozen_balance` decimal(18,8) NOT NULL,
  `total_balance` decimal(18,8) NOT NULL,
  `thawed_balance` decimal(18,8) NOT NULL,
  `sign_clear` int(1) NOT NULL,
  `order_clear` int(1) NOT NULL,
  `first_recharge` decimal(18,8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: feedback (rows: 0) ===
CREATE TABLE `feedback` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKmonjtjt92g6gruqyfumtmg8m8` (`member_id`) USING BTREE,
  CONSTRAINT `FKmonjtjt92g6gruqyfumtmg8m8` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='反馈'

=== TABLE: financial_item (rows: 0) ===
CREATE TABLE `financial_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `coin_minnum` decimal(19,2) DEFAULT NULL,
  `coin_name` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `deadline` int(11) NOT NULL,
  `item_desc` varchar(255) DEFAULT NULL,
  `item_id` varchar(255) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_state` int(11) NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `yield` double DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='财务项目'

=== TABLE: financial_order (rows: 0) ===
CREATE TABLE `financial_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `coin_name` varchar(255) DEFAULT NULL,
  `coin_num` decimal(19,2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `frozen_days` int(11) NOT NULL,
  `item_id` varchar(255) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `order_no` bigint(20) DEFAULT NULL,
  `order_state` int(11) NOT NULL,
  `order_usdt_rate` double DEFAULT NULL,
  `plan_revenue_time` datetime DEFAULT NULL,
  `real_income` decimal(19,2) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='财务订单'

=== TABLE: follow_lock_config (rows: 0) ===
CREATE TABLE `follow_lock_config` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `lower_band` int(6) NOT NULL,
  `upper_band` int(6) NOT NULL,
  `lock_amount` int(6) NOT NULL,
  `lock_days` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: follow_sub_wallet (rows: 0) ===
CREATE TABLE `follow_sub_wallet` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `teacher_id` bigint(20) NOT NULL,
  `balance` decimal(18,8) NOT NULL,
  `frozen_balance` decimal(18,8) NOT NULL,
  `frozen_margin` decimal(18,8) NOT NULL,
  `stop_profit` int(6) NOT NULL,
  `stop_loss` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: follow_wallet (rows: 0) ===
CREATE TABLE `follow_wallet` (
  `id` bigint(20) NOT NULL,
  `balance` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `frozen_balance` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `frozen_margin` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `special_balance` decimal(18,8) NOT NULL,
  `special_frozen_balance` decimal(18,8) NOT NULL,
  `special_frozen_margin` decimal(18,8) NOT NULL,
  `leverage` decimal(10,2) NOT NULL DEFAULT '10.00',
  `profit_percent` decimal(10,2) DEFAULT NULL,
  `loss_percent` decimal(10,2) DEFAULT NULL,
  `entrust_status` int(1) DEFAULT NULL,
  `unfreeze_time` datetime DEFAULT NULL,
  `frozen_ct` decimal(18,8) DEFAULT NULL,
  `m_status` int(1) DEFAULT NULL,
  `m_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: follow_wallet_item (rows: 0) ===
CREATE TABLE `follow_wallet_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `contract_id` bigint(20) NOT NULL,
  `principal_amount` decimal(18,8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: funding_rate_history (rows: 0) ===
CREATE TABLE `funding_rate_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `contract_id` bigint(20) NOT NULL,
  `funding_rate` decimal(19,8) NOT NULL,
  `funding_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5460 DEFAULT CHARSET=utf8mb4

=== TABLE: game_admit (rows: 0) ===
CREATE TABLE `game_admit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `profit` decimal(19,8) NOT NULL,
  `create_time` datetime NOT NULL,
  `result` varchar(2000) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `admit_status` int(1) NOT NULL,
  `admit_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKnfc4dntybup7lyxojfvutk4b8` (`order_id`),
  CONSTRAINT `FKnfc4dntybup7lyxojfvutk4b8` FOREIGN KEY (`order_id`) REFERENCES `game_record` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: game_eth (rows: 0) ===
CREATE TABLE `game_eth` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `hashcode` varchar(255) NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: game_record (rows: 0) ===
CREATE TABLE `game_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `username` varchar(200) NOT NULL,
  `amount` decimal(19,8) NOT NULL,
  `fee` decimal(19,8) NOT NULL,
  `remark` varchar(2000) DEFAULT NULL,
  `batch_name` varchar(2000) NOT NULL,
  `create_time` datetime NOT NULL,
  `clear_time` datetime DEFAULT NULL,
  `profit` decimal(19,8) DEFAULT NULL,
  `status` int(1) NOT NULL,
  `reward_status` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: game_wallet (rows: 0) ===
CREATE TABLE `game_wallet` (
  `id` bigint(20) NOT NULL,
  `balance` decimal(19,8) NOT NULL DEFAULT '0.00000000',
  `frozen_balance` decimal(19,8) NOT NULL DEFAULT '0.00000000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: hot_transfer_record (rows: 0) ===
CREATE TABLE `hot_transfer_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `admin_id` bigint(20) DEFAULT NULL,
  `amount` decimal(18,8) DEFAULT NULL COMMENT '转账金额',
  `balance` decimal(18,8) DEFAULT NULL COMMENT '热钱包余额',
  `cold_address` varchar(255) DEFAULT NULL,
  `miner_fee` decimal(18,8) DEFAULT NULL COMMENT '矿工费',
  `transaction_number` varchar(255) DEFAULT NULL,
  `transfer_time` datetime DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='热传输记录'

=== TABLE: imported_country (rows: 0) ===
CREATE TABLE `imported_country` (
  `zh_name` varchar(200) NOT NULL,
  `en_name` varchar(200) NOT NULL,
  `area_code` varchar(200) NOT NULL,
  PRIMARY KEY (`zh_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: init_plate (rows: 0) ===
CREATE TABLE `init_plate` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `final_price` varchar(255) DEFAULT NULL,
  `init_price` varchar(255) DEFAULT NULL,
  `interference_factor` varchar(255) DEFAULT NULL,
  `relative_time` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: legal_wallet_recharge (rows: 0) ===
CREATE TABLE `legal_wallet_recharge` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,2) NOT NULL COMMENT '充值金额',
  `creation_time` datetime DEFAULT NULL,
  `deal_time` datetime DEFAULT NULL,
  `pay_mode` int(11) NOT NULL,
  `payment_instrument` varchar(255) NOT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `state` int(11) NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `coin_name` varchar(255) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKtfjvrkn1oe0yu2tfjh6qcms73` (`admin_id`) USING BTREE,
  KEY `FKsdtoqyvbjpd0bmw4n41ijc0kk` (`coin_name`) USING BTREE,
  KEY `FK170xpb7hoxqoj5ovdrcibs9gn` (`member_id`) USING BTREE,
  CONSTRAINT `FK170xpb7hoxqoj5ovdrcibs9gn` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FKsdtoqyvbjpd0bmw4n41ijc0kk` FOREIGN KEY (`coin_name`) REFERENCES `coin` (`name`),
  CONSTRAINT `FKtfjvrkn1oe0yu2tfjh6qcms73` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='钱包充值记录'

=== TABLE: legal_wallet_withdraw (rows: 0) ===
CREATE TABLE `legal_wallet_withdraw` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,8) DEFAULT NULL COMMENT '申请总数量',
  `create_time` datetime DEFAULT NULL,
  `deal_time` datetime DEFAULT NULL,
  `pay_mode` int(11) NOT NULL,
  `payment_instrument` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `remit_time` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `coin_name` varchar(255) NOT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKe95o0059kwsgmsxxv3amdb0d2` (`admin_id`) USING BTREE,
  KEY `FKbilsav1ug8vjtn4ffghrlogqx` (`coin_name`) USING BTREE,
  KEY `FKcpw5k7o3tchlifu1wqmjhku9t` (`member_id`) USING BTREE,
  CONSTRAINT `FKbilsav1ug8vjtn4ffghrlogqx` FOREIGN KEY (`coin_name`) REFERENCES `coin` (`name`),
  CONSTRAINT `FKcpw5k7o3tchlifu1wqmjhku9t` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FKe95o0059kwsgmsxxv3amdb0d2` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='钱包提币记录'

=== TABLE: locked_order (rows: 0) ===
CREATE TABLE `locked_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `activity_id` bigint(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `current_releaseamount` decimal(18,8) DEFAULT NULL COMMENT '当前周期释放数量',
  `end_time` varchar(30) NOT NULL DEFAULT '2000-01-01 01:00:00' COMMENT '结束时间',
  `image` varchar(255) DEFAULT NULL,
  `locked_days` int(11) NOT NULL,
  `locked_invite` decimal(24,8) DEFAULT NULL,
  `locked_invitelimit` decimal(24,8) DEFAULT NULL,
  `locked_status` int(11) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  `origin_releaseamount` decimal(18,8) DEFAULT NULL COMMENT '原始周期释放数量',
  `period` int(11) NOT NULL,
  `release_currentpercent` decimal(19,2) DEFAULT NULL,
  `release_percent` decimal(19,2) DEFAULT NULL,
  `release_times` decimal(24,8) DEFAULT NULL,
  `release_type` int(11) NOT NULL,
  `release_unit` varchar(255) DEFAULT NULL,
  `released_days` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `total_locked` decimal(18,8) DEFAULT NULL COMMENT '总锁仓',
  `total_release` decimal(18,8) DEFAULT NULL COMMENT '总释放',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='锁仓订单'

=== TABLE: locked_order_detail (rows: 0) ===
CREATE TABLE `locked_order_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `locked_order_id` bigint(20) DEFAULT NULL,
  `member_id` bigint(20) NOT NULL,
  `output` decimal(18,8) DEFAULT NULL COMMENT '矿机当期产出',
  `release_unit` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='锁仓订单明细'

=== TABLE: member (rows: 0) ===
CREATE TABLE `member` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ali_no` varchar(255) DEFAULT NULL,
  `qr_code_url` varchar(255) DEFAULT NULL,
  `appeal_success_times` int(11) NOT NULL,
  `appeal_times` int(11) NOT NULL,
  `application_time` datetime DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `card_no` varchar(255) DEFAULT NULL,
  `certified_business_apply_time` datetime DEFAULT NULL,
  `certified_business_check_time` datetime DEFAULT NULL,
  `certified_business_status` int(11) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `first_level` int(11) NOT NULL,
  `google_date` datetime DEFAULT NULL,
  `google_key` varchar(255) DEFAULT NULL,
  `google_state` int(11) DEFAULT NULL,
  `id_number` varchar(255) DEFAULT NULL,
  `inviter_id` bigint(20) DEFAULT NULL,
  `jy_password` varchar(255) DEFAULT NULL,
  `last_login_time` datetime DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `login_count` int(11) NOT NULL,
  `margin` varchar(255) DEFAULT NULL,
  `member_level` int(11) DEFAULT NULL,
  `mobile_phone` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `promotion_code` varchar(255) DEFAULT NULL,
  `publish_advertise` int(11) DEFAULT NULL,
  `real_name` varchar(255) DEFAULT NULL,
  `real_name_status` int(11) DEFAULT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `family_name` varchar(255) DEFAULT NULL,
  `middle_name` varchar(255) DEFAULT NULL,
  `birthdate` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) DEFAULT NULL,
  `registration_time` datetime DEFAULT NULL,
  `registration_ip` varchar(255) DEFAULT NULL,
  `login_ip` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `second_level` int(11) NOT NULL,
  `sign_in_ability` bit(1) NOT NULL DEFAULT b'1',
  `status` int(11) DEFAULT NULL,
  `super_partner` varchar(255) DEFAULT NULL,
  `third_level` int(11) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `token_expire_time` datetime DEFAULT NULL,
  `transaction_status` int(11) DEFAULT NULL,
  `transactions` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `qr_we_code_url` varchar(255) DEFAULT NULL,
  `wechat` varchar(255) DEFAULT NULL,
  `local` varchar(255) DEFAULT NULL,
  `usdt_balance` decimal(19,2) DEFAULT '0.00',
  `level_id` int(6) DEFAULT NULL,
  `is_lock` int(2) DEFAULT '0',
  `is_money_lock` int(1) DEFAULT NULL,
  `money_lock_time` datetime DEFAULT NULL,
  `is_trade_lock` int(1) DEFAULT NULL,
  `is_trader` int(1) DEFAULT NULL,
  `disable_reward` int(2) DEFAULT '0',
  `is_valid` int(1) DEFAULT NULL,
  `is_service` int(1) DEFAULT NULL,
  `device_type` int(2) DEFAULT NULL,
  `total_recharge` decimal(19,2) DEFAULT NULL,
  `total_withdraw` decimal(19,2) DEFAULT NULL,
  `today_award` decimal(19,2) DEFAULT NULL,
  `total_award` decimal(19,2) DEFAULT NULL,
  `total_balance` decimal(19,2) DEFAULT NULL,
  `today_order` int(8) DEFAULT NULL,
  `total_profit` decimal(19,2) DEFAULT NULL,
  `total_loss` decimal(19,2) DEFAULT NULL,
  `today_profit` decimal(19,2) DEFAULT NULL,
  `today_loss` decimal(19,2) DEFAULT NULL,
  `total_fee` decimal(19,2) DEFAULT NULL,
  `agent_total_recharge` decimal(19,2) DEFAULT NULL,
  `agent_total_withdraw` decimal(19,2) DEFAULT NULL,
  `agent_total_balance` decimal(19,2) DEFAULT NULL,
  `agent_total_award` decimal(19,2) DEFAULT NULL,
  `agent_total_fee` decimal(19,2) DEFAULT NULL,
  `agent_total_profit` decimal(19,2) DEFAULT NULL,
  `agent_total_loss` decimal(19,2) DEFAULT NULL,
  `agent_total_count` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_gc3jmn7c2abyo3wf6syln5t2i` (`username`) USING BTREE,
  UNIQUE KEY `UK_mbmcqelty0fbrvxp1q58dn57t` (`email`) USING BTREE,
  UNIQUE KEY `UK_10ixebfiyeqolglpuye0qb49u` (`mobile_phone`) USING BTREE,
  KEY `FKbt72vgf5myy3uhygc90xna65j` (`local`) USING BTREE,
  KEY `FKog7i1p9vi2jhqfkakv8702exp` (`level_id`),
  CONSTRAINT `FKbt72vgf5myy3uhygc90xna65j` FOREIGN KEY (`local`) REFERENCES `country` (`zh_name`),
  CONSTRAINT `FKog7i1p9vi2jhqfkakv8702exp` FOREIGN KEY (`level_id`) REFERENCES `member_level` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=313988 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='会员表'

=== TABLE: member_address (rows: 0) ===
CREATE TABLE `member_address` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKhcqqqntcf8hqmoa6dpo95okyh` (`coin_id`) USING BTREE,
  CONSTRAINT `FKhcqqqntcf8hqmoa6dpo95okyh` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员提币地址'

=== TABLE: member_api_key (rows: 0) ===
CREATE TABLE `member_api_key` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `api_key` varchar(255) DEFAULT NULL,
  `api_name` varchar(255) DEFAULT NULL,
  `bind_ip` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `expire_time` datetime DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `secret_key` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员OpenKey'

=== TABLE: member_application (rows: 0) ===
CREATE TABLE `member_application` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `audit_status` int(11) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `id_card` varchar(255) DEFAULT NULL,
  `identity_card_img_front` varchar(255) NOT NULL,
  `identity_card_img_in_hand` varchar(255) NOT NULL,
  `identity_card_img_reverse` varchar(255) NOT NULL,
  `real_name` varchar(255) DEFAULT NULL,
  `reject_reason` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `member_id` bigint(20) NOT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `family_name` varchar(255) DEFAULT NULL,
  `middle_name` varchar(255) DEFAULT NULL,
  `birthdate` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK2djx7q0j54th0cgj7153qfbl1` (`member_id`) USING BTREE,
  CONSTRAINT `FK2djx7q0j54th0cgj7153qfbl1` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='会员实名信息照片'

=== TABLE: member_application_config (rows: 0) ===
CREATE TABLE `member_application_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `promotion_on` int(11) DEFAULT NULL,
  `recharge_coin_on` int(11) DEFAULT NULL,
  `transaction_on` int(11) DEFAULT NULL,
  `withdraw_coin_on` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员实名配置'

=== TABLE: member_bonus (rows: 0) ===
CREATE TABLE `member_bonus` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `arrive_time` varchar(255) DEFAULT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  `have_time` varchar(255) DEFAULT NULL,
  `mem_bouns` decimal(18,8) DEFAULT NULL COMMENT '分红数量',
  `member_id` bigint(20) DEFAULT NULL,
  `total` decimal(18,8) DEFAULT NULL COMMENT '当天总手续费',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员奖金'

=== TABLE: member_contract_position (rows: 0) ===
CREATE TABLE `member_contract_position` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `leverage` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '杠杆倍数',
  `total_position` decimal(18,8) NOT NULL DEFAULT '0.00000000' COMMENT '总仓位',
  `open_price` decimal(18,8) NOT NULL DEFAULT '0.00000000' COMMENT '开仓均价',
  `closed_open_price` decimal(18,8) DEFAULT NULL,
  `close_price` decimal(18,8) DEFAULT NULL,
  `current_price` decimal(18,8) DEFAULT NULL,
  `principal_amount` decimal(18,8) NOT NULL DEFAULT '0.00000000' COMMENT '多仓保证金',
  `total_principal_amount` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `frozen_position` decimal(18,8) NOT NULL DEFAULT '0.00000000' COMMENT '开多仓位',
  `closed_position` decimal(18,8) NOT NULL DEFAULT '0.00000000' COMMENT '已平仓',
  `type` int(1) NOT NULL DEFAULT '1',
  `money_type` int(1) NOT NULL DEFAULT '1',
  `direction` int(1) NOT NULL,
  `status` int(1) NOT NULL,
  `usdt_profit` decimal(18,8) NOT NULL DEFAULT '0.00000000' COMMENT 'USDT盈利',
  `share_number` decimal(18,8) DEFAULT '0.00000000',
  `contract_id` bigint(20) NOT NULL,
  `create_time` datetime NOT NULL,
  `open_time` datetime NOT NULL,
  `latest_open_time` datetime NOT NULL,
  `close_time` datetime DEFAULT NULL,
  `open_type` int(2) DEFAULT NULL,
  `close_type` int(2) DEFAULT NULL,
  `is_lock` int(2) DEFAULT '0',
  `decimal_scale` int(1) NOT NULL DEFAULT '1',
  `commission_fee` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `blasted_amount` decimal(18,8) DEFAULT NULL,
  `violate_time` int(1) DEFAULT NULL,
  `follow_order_id` bigint(20) DEFAULT NULL,
  `follow_position_id` bigint(20) DEFAULT NULL,
  `follow_member_id` bigint(20) DEFAULT NULL,
  `dividend_percent` int(6) DEFAULT NULL,
  `is_special` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKni1vfmlpo78vdm4tvr5woqvpo` (`contract_id`),
  KEY `FKrwdi9njy3efu4b8ym36j0gp05` (`member_id`),
  KEY `follow_position_id` (`follow_position_id`),
  KEY `status` (`status`),
  CONSTRAINT `FK7kj14xpujp48j2jwcfwt9gb7t` FOREIGN KEY (`contract_id`) REFERENCES `contract_coin` (`id`),
  CONSTRAINT `FKrwdi9njy3efu4b8ym36j0gp05` FOREIGN KEY (`member_id`) REFERENCES `user_purse` (`id`),
  CONSTRAINT `member_contract_position_ibfk_1` FOREIGN KEY (`contract_id`) REFERENCES `contract_coin` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=476641 DEFAULT CHARSET=utf8 COMMENT='会员合约钱包仓位'

=== TABLE: member_contract_wallet (rows: 0) ===
CREATE TABLE `member_contract_wallet` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `coin_balance` decimal(18,8) DEFAULT '0.00000000' COMMENT '币种余额',
  `coin_buy_leverage` decimal(18,8) DEFAULT '0.00000000' COMMENT '做多杠杆倍数',
  `coin_buy_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开多仓位',
  `coin_buy_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '多仓均价',
  `coin_buy_principal_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '多仓保证金',
  `coin_frozen_balance` decimal(18,8) DEFAULT '0.00000000' COMMENT '冻结余额',
  `coin_frozen_buy_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开多仓位',
  `coin_frozen_sell_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `coin_pattern` int(4) DEFAULT '1' COMMENT '币本位仓位模式',
  `coin_sell_leverage` decimal(18,8) DEFAULT '0.00000000' COMMENT '做空杠杆倍数',
  `coin_sell_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `coin_sell_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '空仓均价',
  `coin_sell_principal_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '空仓保证金',
  `coin_share_number` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `member_id` bigint(20) DEFAULT NULL,
  `usdt_balance` decimal(18,8) DEFAULT '0.00000000' COMMENT 'USDT余额',
  `usdt_buy_leverage` decimal(18,8) DEFAULT '0.00000000' COMMENT '做多杠杆倍数',
  `usdt_buy_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开多仓位',
  `usdt_buy_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '多仓均价',
  `usdt_buy_principal_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '多仓保证金',
  `usdt_frozen_balance` decimal(18,8) DEFAULT '0.00000000' COMMENT '冻结余额',
  `usdt_frozen_buy_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开多仓位',
  `usdt_frozen_sell_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `usdt_loss` decimal(18,8) DEFAULT '0.00000000' COMMENT 'USDT亏损',
  `usdt_pattern` int(4) DEFAULT '1' COMMENT '金本位仓位模式',
  `usdt_profit` decimal(18,8) DEFAULT '0.00000000' COMMENT 'USDT盈利',
  `usdt_sell_leverage` decimal(18,8) DEFAULT '0.00000000' COMMENT '做空杠杆倍数',
  `usdt_sell_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `usdt_sell_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '空仓均价',
  `usdt_sell_principal_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '空仓保证金',
  `usdt_share_number` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `contract_id` bigint(20) DEFAULT NULL,
  `usdt_buy_time` bigint(20) DEFAULT '0',
  `usdt_sell_time` bigint(20) DEFAULT '0',
  `is_lock` int(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UKe17oj0my6ih9ejhlw6m84l1cd` (`member_id`,`contract_id`) USING BTREE,
  KEY `FKni1vfmlpo78vdm4tvr5woqvpo` (`contract_id`) USING BTREE,
  CONSTRAINT `FKni1vfmlpo78vdm4tvr5woqvpo` FOREIGN KEY (`contract_id`) REFERENCES `contract_coin` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=358467 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='会员合约钱包'

=== TABLE: member_contract_wallet统一合约账户bak (rows: 0) ===
CREATE TABLE `member_contract_wallet统一合约账户bak` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) DEFAULT NULL,
  `usdt_balance` decimal(18,8) DEFAULT '0.00000000' COMMENT 'USDT余额',
  `usdt_frozen_balance` decimal(18,8) DEFAULT '0.00000000' COMMENT '冻结余额',
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UKe17oj0my6ih9ejhlw6m84l1` (`member_id`,`coin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员合约钱包'

=== TABLE: member_contract_wallet_position统一合约账户bak (rows: 0) ===
CREATE TABLE `member_contract_wallet_position统一合约账户bak` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) DEFAULT NULL,
  `wallet_id` bigint(20) DEFAULT NULL COMMENT '做多杠杆倍数',
  `usdt_buy_leverage` decimal(18,8) DEFAULT '0.00000000' COMMENT '做多杠杆倍数',
  `usdt_buy_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开多仓位',
  `usdt_buy_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '多仓均价',
  `usdt_buy_principal_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '多仓保证金',
  `usdt_frozen_buy_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开多仓位',
  `usdt_frozen_sell_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `usdt_loss` decimal(18,8) DEFAULT '0.00000000' COMMENT 'USDT亏损',
  `usdt_pattern` int(4) DEFAULT '1' COMMENT '金本位仓位模式',
  `usdt_profit` decimal(18,8) DEFAULT '0.00000000' COMMENT 'USDT盈利',
  `usdt_sell_leverage` decimal(18,8) DEFAULT '0.00000000' COMMENT '做空杠杆倍数',
  `usdt_sell_position` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `usdt_sell_price` decimal(18,8) DEFAULT '0.00000000' COMMENT '空仓均价',
  `usdt_sell_principal_amount` decimal(18,8) DEFAULT '0.00000000' COMMENT '空仓保证金',
  `usdt_share_number` decimal(18,8) DEFAULT '0.00000000' COMMENT '开空仓位',
  `contract_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UKe17oj0my6ih9ejhlw6m84l1cd` (`member_id`,`contract_id`),
  KEY `FKni1vfmlpo78vdm4tvr5woqvpo` (`contract_id`),
  CONSTRAINT `member_contract_wallet_position统一合约账户bak_ibfk_1` FOREIGN KEY (`contract_id`) REFERENCES `contract_coin` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员合约钱包仓位'

=== TABLE: member_deposit (rows: 0) ===
CREATE TABLE `member_deposit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `amount` decimal(18,8) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `txid` varchar(255) DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UKl2ibi99fuxplt8qt3rrpb0q4w` (`txid`,`address`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='会员充值数字币记录'

=== TABLE: member_feedback (rows: 0) ===
CREATE TABLE `member_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `content` mediumtext NOT NULL,
  `contact_information` varchar(255) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  `attachments` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: member_finance_order (rows: 0) ===
CREATE TABLE `member_finance_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `num` decimal(20,8) DEFAULT '0.00000000' COMMENT '理财数量',
  `member_id` bigint(20) DEFAULT NULL,
  `status` int(4) DEFAULT '0' COMMENT '订单状态 0持仓中 1撤销',
  `coin_symbol` varchar(50) DEFAULT NULL COMMENT '币种unit',
  `earn_num` decimal(20,8) DEFAULT NULL COMMENT '盈利',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='理财订单'

=== TABLE: member_finance_statistic (rows: 0) ===
CREATE TABLE `member_finance_statistic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `num` decimal(20,8) DEFAULT '0.00000000' COMMENT '理财数量',
  `member_id` bigint(20) DEFAULT NULL,
  `coin_symbol` varchar(50) DEFAULT NULL COMMENT '币种unit',
  `earn_num` decimal(20,8) DEFAULT NULL COMMENT '累计盈利',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `member_id` (`member_id`,`coin_symbol`),
  UNIQUE KEY `UK22ri1cwm7qg2q7l2cp4q4jcsh` (`member_id`,`coin_symbol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='理财统计表'

=== TABLE: member_history (rows: 0) ===
CREATE TABLE `member_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `statistic_date` date NOT NULL,
  `balance` decimal(19,8) NOT NULL,
  `recharge` decimal(19,8) NOT NULL,
  `withdraw` decimal(19,8) NOT NULL,
  `transfer_in` decimal(19,8) NOT NULL,
  `transfer_out` decimal(19,8) NOT NULL,
  `activity_award` decimal(19,8) NOT NULL,
  `promotion_award` decimal(19,8) NOT NULL,
  `dividend` decimal(19,8) NOT NULL,
  `admin_recharge` decimal(19,8) NOT NULL,
  `award` decimal(19,8) NOT NULL,
  `profit` decimal(19,8) NOT NULL,
  `loss` decimal(19,8) NOT NULL,
  `fee` decimal(19,8) NOT NULL,
  `overnight_fee_in` decimal(19,8) NOT NULL,
  `overnight_fee_out` decimal(19,8) NOT NULL,
  `follow_fee` decimal(19,8) NOT NULL,
  `follow_profit` decimal(19,8) NOT NULL,
  `follow_loss` decimal(19,8) NOT NULL,
  `follow_award` decimal(19,8) NOT NULL,
  `follow_dividend_in` decimal(19,8) NOT NULL,
  `follow_dividend_out` decimal(19,8) NOT NULL,
  `follow_overnight_fee_in` decimal(19,8) NOT NULL,
  `follow_overnight_fee_out` decimal(19,8) NOT NULL,
  `game_fee` decimal(19,8) DEFAULT NULL,
  `game_profit` decimal(19,8) DEFAULT NULL,
  `game_loss` decimal(19,8) DEFAULT NULL,
  `game_award` decimal(19,8) DEFAULT NULL,
  `exchange_profit` decimal(19,8) NOT NULL,
  `exchange_loss` decimal(19,8) NOT NULL,
  `exchange_fee` decimal(19,8) NOT NULL,
  `exchange_award` decimal(19,8) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `statistic_date` (`statistic_date`)
) ENGINE=InnoDB AUTO_INCREMENT=265763 DEFAULT CHARSET=utf8mb4

=== TABLE: member_invite_stastic (rows: 0) ===
CREATE TABLE `member_invite_stastic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `btc_reward` decimal(24,8) DEFAULT NULL,
  `estimated_reward` decimal(24,8) DEFAULT NULL,
  `eth_reward` decimal(24,8) DEFAULT NULL,
  `extra_reward` decimal(24,8) DEFAULT NULL,
  `is_robot` int(11) NOT NULL,
  `level_one` int(11) NOT NULL,
  `level_two` int(11) NOT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `other_reward` varchar(255) DEFAULT NULL,
  `stastic_date` varchar(30) NOT NULL DEFAULT '2000-01-01 01:00:00' COMMENT '统计日期',
  `usdt_reward` decimal(24,8) DEFAULT NULL,
  `user_identify` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `member_id` (`member_id`) USING BTREE,
  UNIQUE KEY `UK4o6jykp20ax1pybxgxcwsxq01` (`member_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14361 DEFAULT CHARSET=utf8 COMMENT='会员邀请记录'

=== TABLE: member_invite_stastic_rank (rows: 0) ===
CREATE TABLE `member_invite_stastic_rank` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `is_robot` int(11) NOT NULL,
  `level_one` int(11) NOT NULL,
  `level_two` int(11) NOT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `stastic_date` datetime DEFAULT NULL,
  `type` int(11) NOT NULL,
  `user_identify` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员邀请等级'

=== TABLE: member_level (rows: 0) ===
CREATE TABLE `member_level` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `is_default` bit(1) NOT NULL,
  `name` varchar(255) NOT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `one_rate` int(6) NOT NULL DEFAULT '0',
  `two_rate` int(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员等级'

=== TABLE: member_promotion (rows: 0) ===
CREATE TABLE `member_promotion` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `invitees_id` bigint(20) DEFAULT NULL,
  `inviter_id` bigint(20) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员推广'

=== TABLE: member_second_wallet (rows: 0) ===
CREATE TABLE `member_second_wallet` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `balance` decimal(18,8) DEFAULT '0.00000000' COMMENT '币种余额',
  `frozen_balance` decimal(18,8) DEFAULT '0.00000000' COMMENT '冻结余额',
  `member_id` bigint(20) DEFAULT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `member_id_and_contract_id` (`member_id`,`coin_id`) USING BTREE,
  KEY `contract_id` (`coin_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员秒合约钱包'

=== TABLE: member_sign_record (rows: 0) ===
CREATE TABLE `member_sign_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(19,2) DEFAULT NULL,
  `creation_time` datetime DEFAULT NULL,
  `coin_name` varchar(255) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `sign_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK7qa42qkaoqxlyvwhxwdstclic` (`coin_name`) USING BTREE,
  KEY `FK2r4i90tejcbf85vhk0d8besle` (`member_id`) USING BTREE,
  KEY `FKq1926wgosqk7ka4kvw8rtxew` (`sign_id`) USING BTREE,
  CONSTRAINT `FK2r4i90tejcbf85vhk0d8besle` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FK7qa42qkaoqxlyvwhxwdstclic` FOREIGN KEY (`coin_name`) REFERENCES `coin` (`name`),
  CONSTRAINT `FKq1926wgosqk7ka4kvw8rtxew` FOREIGN KEY (`sign_id`) REFERENCES `sign` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员签章记录'

=== TABLE: member_stat (rows: 0) ===
CREATE TABLE `member_stat` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `total_recharge` decimal(19,2) DEFAULT NULL,
  `total_withdraw` decimal(19,2) DEFAULT NULL,
  `today_award` decimal(19,2) DEFAULT NULL,
  `total_award` decimal(19,2) DEFAULT NULL,
  `total_balance` decimal(19,2) DEFAULT NULL,
  `today_order` int(8) DEFAULT NULL,
  `total_profit` decimal(19,2) DEFAULT NULL,
  `total_loss` decimal(19,2) DEFAULT NULL,
  `today_profit` decimal(19,2) DEFAULT NULL,
  `today_loss` decimal(19,2) DEFAULT NULL,
  `total_fee` decimal(19,2) DEFAULT NULL,
  `agent_total_recharge` decimal(19,2) DEFAULT NULL,
  `agent_total_withdraw` decimal(19,2) DEFAULT NULL,
  `agent_total_balance` decimal(19,2) DEFAULT NULL,
  `agent_total_award` decimal(19,2) DEFAULT NULL,
  `agent_total_fee` decimal(19,2) DEFAULT NULL,
  `agent_total_profit` decimal(19,2) DEFAULT NULL,
  `agent_total_loss` decimal(19,2) DEFAULT NULL,
  `agent_total_follow_fee` decimal(19,2) DEFAULT NULL,
  `agent_total_follow_reward` decimal(19,2) DEFAULT NULL,
  `agent_total_count` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='会员统计表'

=== TABLE: member_team_info (rows: 0) ===
CREATE TABLE `member_team_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL COMMENT '用户id',
  `inviter_id` bigint(20) DEFAULT NULL COMMENT '邀请人id',
  `team_total_amount` decimal(20,6) DEFAULT '0.000000' COMMENT '团队业绩USDT',
  `level` int(2) DEFAULT '0' COMMENT '等级 0普通  1合约矿工  2节点矿工 3高级矿工 4超级矿工 5矿池 ',
  `sys_level` int(2) DEFAULT '0' COMMENT '系统设定级别',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户团队业绩等级'

=== TABLE: member_team_reward (rows: 0) ===
CREATE TABLE `member_team_reward` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL COMMENT '用户id',
  `source_id` bigint(20) DEFAULT NULL COMMENT '来源用户id',
  `source_type` int(2) DEFAULT '0' COMMENT '来源类型 0永续 1期权',
  `num` decimal(20,6) DEFAULT '0.000000' COMMENT '奖励数量',
  `coin_symbol` varchar(50) DEFAULT NULL,
  `type` int(2) DEFAULT '0' COMMENT '奖励类型 0佣金 1推荐奖励',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户团队奖励记录'

=== TABLE: member_transaction (rows: 0) ===
CREATE TABLE `member_transaction` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `amount` decimal(26,16) DEFAULT NULL COMMENT '充币金额',
  `create_time` datetime DEFAULT NULL,
  `discount_fee` varchar(255) DEFAULT NULL,
  `fee` decimal(26,16) DEFAULT NULL,
  `flag` int(11) NOT NULL DEFAULT '0',
  `member_id` bigint(20) DEFAULT NULL,
  `real_fee` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `direction` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `member_id` (`member_id`),
  KEY `create_time` (`create_time`),
  KEY `type` (`type`),
  KEY `symbol` (`symbol`)
) ENGINE=InnoDB AUTO_INCREMENT=141690792 DEFAULT CHARSET=utf8 COMMENT='会员交易记录'

=== TABLE: member_transaction_history (rows: 0) ===
CREATE TABLE `member_transaction_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `amount` decimal(26,16) DEFAULT NULL COMMENT '充币金额',
  `create_time` datetime DEFAULT NULL,
  `discount_fee` varchar(255) DEFAULT NULL,
  `fee` decimal(26,16) DEFAULT NULL,
  `flag` int(11) NOT NULL DEFAULT '0',
  `member_id` bigint(20) DEFAULT NULL,
  `real_fee` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `direction` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `member_id` (`member_id`),
  KEY `create_time` (`create_time`),
  KEY `type` (`type`),
  KEY `symbol` (`symbol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员交易记录'

=== TABLE: member_wallet (rows: 0) ===
CREATE TABLE `member_wallet` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `balance` decimal(26,8) DEFAULT NULL COMMENT '可用余额',
  `frozen_balance` decimal(26,8) DEFAULT NULL COMMENT '冻结余额',
  `is_lock` int(11) DEFAULT '0' COMMENT '钱包不是锁定',
  `member_id` bigint(20) DEFAULT NULL,
  `to_released` decimal(18,8) DEFAULT NULL COMMENT '待释放总量',
  `version` int(11) NOT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UKm68bscpof0bpnxocxl4qdnvbe` (`member_id`,`coin_id`) USING BTREE,
  KEY `FKf9tgbp9y9py8t9c5xj0lllcib` (`coin_id`) USING BTREE,
  CONSTRAINT `FKf9tgbp9y9py8t9c5xj0lllcib` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=545928 DEFAULT CHARSET=utf8 COMMENT='会员钱包'

=== TABLE: member_wallet_address_backup (rows: 0) ===
CREATE TABLE `member_wallet_address_backup` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  `coin_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ukmemberidcoinid` (`member_id`,`coin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: member_wallet_history (rows: 0) ===
CREATE TABLE `member_wallet_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `coin_id` varchar(255) NOT NULL,
  `before_balance` decimal(18,8) NOT NULL,
  `after_balance` decimal(18,8) DEFAULT NULL,
  `before_frozen_balance` decimal(18,8) DEFAULT NULL,
  `after_frozen_balance` decimal(18,8) DEFAULT NULL,
  `op_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='钱包增删记录'

=== TABLE: member_weight_upper (rows: 0) ===
CREATE TABLE `member_weight_upper` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `first_member_id` bigint(20) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `rate` int(11) DEFAULT NULL,
  `follow_rate` int(11) DEFAULT NULL,
  `dividend_rate` int(11) DEFAULT NULL,
  `wc_rate` int(6) DEFAULT NULL,
  `upper` varchar(255) DEFAULT NULL,
  `all_uppers` varchar(1000) DEFAULT NULL,
  `level` int(2) DEFAULT NULL,
  `is_auto` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14380 DEFAULT CHARSET=utf8

=== TABLE: mine_conf (rows: 1) ===
CREATE TABLE `mine_conf` (
  `id` bigint(20) NOT NULL,
  `pledge_quantity` decimal(26,8) NOT NULL COMMENT '最小质押数量',
  `production_ratio` decimal(10,2) NOT NULL COMMENT '产币比例,单位%',
  `bonus_one` decimal(26,8) NOT NULL COMMENT '银牌分红',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `bonus_two` decimal(26,8) NOT NULL COMMENT '金牌分红',
  `bonus_three` decimal(26,8) NOT NULL COMMENT '合伙人分红',
  `total_quantity` decimal(26,8) NOT NULL COMMENT '矿池总量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='挖矿配置'

=== TABLE: mine_customer_info (rows: 0) ===
CREATE TABLE `mine_customer_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pledge_number` decimal(26,8) NOT NULL COMMENT '质押数量',
  `release_number` decimal(26,8) NOT NULL COMMENT '待解押数量',
  `total_revenue` decimal(26,8) NOT NULL COMMENT '总收益',
  `available_revenue` decimal(26,8) NOT NULL COMMENT '可提取收益',
  `invite_number` int(11) NOT NULL COMMENT '邀请数量',
  `generations` int(11) NOT NULL COMMENT '代',
  `level` int(11) NOT NULL COMMENT '1.银牌商务,2.金牌商务,3.合伙人',
  `member_id` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户质押信息'

=== TABLE: mine_income_records (rows: 0) ===
CREATE TABLE `mine_income_records` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL COMMENT '用户id',
  `type` int(11) NOT NULL COMMENT '类型:1.收益  2.提出',
  `created_time` datetime NOT NULL,
  `updated_time` datetime NOT NULL,
  `quantity` decimal(26,8) NOT NULL COMMENT '数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收益记录'

=== TABLE: mine_pledge_records (rows: 0) ===
CREATE TABLE `mine_pledge_records` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL COMMENT '用户id',
  `type` int(11) NOT NULL COMMENT '类型:1.质押  2.解押',
  `status` int(11) NOT NULL COMMENT '状态:0 待解押  1解押成功',
  `created_time` datetime NOT NULL,
  `updated_time` datetime NOT NULL,
  `quantity` decimal(26,8) NOT NULL COMMENT '数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='质押记录'

=== TABLE: mining_order (rows: 0) ===
CREATE TABLE `mining_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `activity_id` bigint(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `current_daysprofit` decimal(18,8) DEFAULT NULL COMMENT '矿机当前日产出',
  `end_time` varchar(30) NOT NULL DEFAULT '2000-01-01 01:00:00' COMMENT '结束时间',
  `member_id` bigint(20) NOT NULL,
  `mining_days` int(11) NOT NULL,
  `mining_daysprofit` decimal(18,8) DEFAULT NULL COMMENT '矿机原始日产出',
  `mining_unit` varchar(255) DEFAULT NULL,
  `mininged_days` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `mining_status` int(11) NOT NULL,
  `period` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `mining_invite` decimal(24,8) DEFAULT NULL,
  `mining_invitelimit` decimal(24,8) DEFAULT NULL,
  `total_profit` decimal(18,8) DEFAULT NULL COMMENT '矿机总产出',
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='挖矿订单'

=== TABLE: mining_order_detail (rows: 0) ===
CREATE TABLE `mining_order_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `member_id` bigint(20) NOT NULL,
  `mining_order_id` bigint(20) DEFAULT NULL,
  `mining_unit` varchar(255) DEFAULT NULL,
  `output` decimal(18,8) DEFAULT NULL COMMENT '矿机当期产出',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='挖矿订单详情'

=== TABLE: money_operation_record (rows: 0) ===
CREATE TABLE `money_operation_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `business_id` bigint(20) NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `remark` varchar(2000) NOT NULL,
  `status` int(1) NOT NULL,
  `create_time` datetime NOT NULL,
  `admit_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: otc_coin (rows: 0) ===
CREATE TABLE `otc_coin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `buy_min_amount` decimal(18,8) DEFAULT NULL COMMENT '买入广告最低发布数量',
  `is_platform_coin` int(11) DEFAULT NULL,
  `jy_rate` decimal(18,6) DEFAULT NULL COMMENT '交易手续费率',
  `name` varchar(255) NOT NULL,
  `name_cn` varchar(255) NOT NULL,
  `sell_min_amount` decimal(18,8) DEFAULT NULL COMMENT '卖出广告最低发布数量',
  `sort` int(11) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `unit` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='OTC币种'

=== TABLE: otc_order (rows: 0) ===
CREATE TABLE `otc_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `advertise_id` bigint(20) NOT NULL,
  `advertise_type` int(11) NOT NULL,
  `ali_no` varchar(255) DEFAULT NULL,
  `qr_code_url` varchar(255) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `card_no` varchar(255) DEFAULT NULL,
  `cancel_time` datetime DEFAULT NULL,
  `commission` decimal(18,8) DEFAULT NULL COMMENT '手续费',
  `country` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `customer_id` bigint(20) NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_real_name` varchar(255) DEFAULT NULL,
  `max_limit` decimal(18,2) DEFAULT NULL COMMENT '最高交易额',
  `member_id` bigint(20) NOT NULL,
  `member_name` varchar(255) DEFAULT NULL,
  `member_real_name` varchar(255) DEFAULT NULL,
  `min_limit` decimal(18,2) DEFAULT NULL COMMENT '最低交易额',
  `money` decimal(18,2) DEFAULT NULL COMMENT '交易金额',
  `number` decimal(18,8) DEFAULT NULL COMMENT '交易数量',
  `order_sn` varchar(255) NOT NULL,
  `pay_mode` varchar(255) NOT NULL,
  `pay_time` datetime DEFAULT NULL,
  `price` decimal(18,2) DEFAULT NULL COMMENT '价格',
  `release_time` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `time_limit` int(11) DEFAULT NULL,
  `version` bigint(20) DEFAULT NULL,
  `qr_we_code_url` varchar(255) DEFAULT NULL,
  `wechat` varchar(255) DEFAULT NULL,
  `coin_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_qmfpakgu6mowmslv4m5iy43t9` (`order_sn`) USING BTREE,
  KEY `FKjh47nnmiehmu15wqjfwnh8a6u` (`coin_id`) USING BTREE,
  CONSTRAINT `FKjh47nnmiehmu15wqjfwnh8a6u` FOREIGN KEY (`coin_id`) REFERENCES `otc_coin` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OTC订单'

=== TABLE: promotion_card (rows: 0) ===
CREATE TABLE `promotion_card` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,8) DEFAULT NULL COMMENT '单个卡券金额',
  `card_desc` varchar(255) DEFAULT NULL,
  `card_name` varchar(255) NOT NULL,
  `card_no` varchar(255) NOT NULL,
  `count` int(11) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `exchange_count` int(11) NOT NULL,
  `is_enabled` int(11) NOT NULL,
  `is_free` int(11) NOT NULL,
  `is_lock` int(11) NOT NULL,
  `lock_days` int(11) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  `total_amount` decimal(18,8) DEFAULT NULL COMMENT '所有卡券总金额',
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_3781uubel3iuh86ht6yv0n0r7` (`card_no`) USING BTREE,
  KEY `FKem2r42s1av7tfni612176gt9f` (`coin_id`) USING BTREE,
  CONSTRAINT `FKem2r42s1av7tfni612176gt9f` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='合伙人推广卡'

=== TABLE: promotion_card_order (rows: 0) ===
CREATE TABLE `promotion_card_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,8) DEFAULT NULL COMMENT '兑换金额',
  `create_time` datetime DEFAULT NULL,
  `is_free` int(11) NOT NULL,
  `is_lock` int(11) NOT NULL,
  `lock_days` int(11) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  `state` int(11) NOT NULL,
  `card_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK1e6ykywfbw68oodq33no4ao8u` (`card_id`) USING BTREE,
  CONSTRAINT `FK1e6ykywfbw68oodq33no4ao8u` FOREIGN KEY (`card_id`) REFERENCES `promotion_card` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='合伙人推广卡订单'

=== TABLE: quick_exchange (rows: 0) ===
CREATE TABLE `quick_exchange` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(24,8) DEFAULT '0.00000000',
  `create_time` datetime DEFAULT NULL,
  `ex_amount` decimal(24,8) DEFAULT '0.00000000',
  `from_unit` varchar(255) DEFAULT NULL,
  `member_id` bigint(20) NOT NULL,
  `rate` decimal(24,8) DEFAULT '0.00000000',
  `status` int(11) NOT NULL,
  `to_unit` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='快速兑换'

=== TABLE: red_envelope (rows: 0) ===
CREATE TABLE `red_envelope` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bg_image` varchar(255) DEFAULT NULL,
  `count` int(11) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `detail` text,
  `envelope_no` varchar(255) NOT NULL,
  `expired_hours` int(11) NOT NULL,
  `invite` int(11) NOT NULL,
  `logo_image` varchar(255) DEFAULT NULL,
  `max_rand` decimal(18,8) DEFAULT NULL COMMENT '最大随机领取额',
  `member_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `plateform` int(11) NOT NULL,
  `receive_amount` decimal(18,8) DEFAULT NULL COMMENT '领取总额',
  `receive_count` int(11) NOT NULL,
  `state` int(11) NOT NULL,
  `total_amount` decimal(18,8) DEFAULT NULL COMMENT '红包总额',
  `type` int(11) NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `invite_user` varchar(255) DEFAULT NULL,
  `invite_user_avatar` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_kpc525u446ufbpp8a8wxq6b93` (`envelope_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: red_envelope_detail (rows: 0) ===
CREATE TABLE `red_envelope_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,8) DEFAULT NULL COMMENT '领取数额',
  `cate` int(11) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `envelope_id` bigint(20) DEFAULT NULL,
  `member_id` bigint(20) NOT NULL,
  `user_identify` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: reward_activity_setting (rows: 0) ===
CREATE TABLE `reward_activity_setting` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `info` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `coin_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKra9w7qwgbxti55cmkb6kycau7` (`admin_id`) USING BTREE,
  KEY `FKmxq57nrqt4lb9lqpxwc095h1h` (`coin_id`) USING BTREE,
  CONSTRAINT `FKmxq57nrqt4lb9lqpxwc095h1h` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`),
  CONSTRAINT `FKra9w7qwgbxti55cmkb6kycau7` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: reward_promotion_setting (rows: 0) ===
CREATE TABLE `reward_promotion_setting` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `effective_time` int(11) NOT NULL,
  `info` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK7fl96plmj12crmepem7t876u3` (`admin_id`) USING BTREE,
  KEY `FKfhtlsn9g8lj5qecbo596ymhey` (`coin_id`) USING BTREE,
  CONSTRAINT `FK7fl96plmj12crmepem7t876u3` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`),
  CONSTRAINT `FKfhtlsn9g8lj5qecbo596ymhey` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: reward_record (rows: 0) ===
CREATE TABLE `reward_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(18,8) DEFAULT NULL COMMENT '数目',
  `create_time` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `coin_id` varchar(255) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  `from_member_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKtm2ha75hh60am8n7lco838nmo` (`coin_id`) USING BTREE,
  KEY `FK9m2bd6gjgad67vb6of4waxtov` (`member_id`) USING BTREE,
  KEY `FKf4q35is1vi1erauqyw0ul0cy7` (`from_member_id`),
  CONSTRAINT `FK9m2bd6gjgad67vb6of4waxtov` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FKf4q35is1vi1erauqyw0ul0cy7` FOREIGN KEY (`from_member_id`) REFERENCES `member` (`id`),
  CONSTRAINT `FKtm2ha75hh60am8n7lco838nmo` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: risk_control (rows: 0) ===
CREATE TABLE `risk_control` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `type` int(2) NOT NULL,
  `content` varchar(1000) NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4

=== TABLE: robot_match_conf (rows: 1) ===
CREATE TABLE `robot_match_conf` (
  `id` bigint(20) NOT NULL,
  `min_amount` decimal(26,8) NOT NULL COMMENT '最小数量',
  `max_amount` decimal(26,8) NOT NULL COMMENT '最大数量',
  `proportion` decimal(20,8) NOT NULL COMMENT '大盘比例:0.0001btc',
  `fixed_offset` decimal(26,16) NOT NULL COMMENT '价格固定偏移量',
  `random_offset` decimal(26,8) NOT NULL COMMENT '价格随机偏移量',
  `handicap_gap` decimal(18,8) DEFAULT NULL,
  `deal_gap` decimal(18,8) DEFAULT NULL,
  `last_btc_price` decimal(18,8) DEFAULT NULL,
  `last_ct_price` decimal(18,8) DEFAULT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配置名称'

=== TABLE: robot_match_plan (rows: 0) ===
CREATE TABLE `robot_match_plan` (
  `id` bigint(20) NOT NULL,
  `start_time` datetime NOT NULL COMMENT '开盘时间',
  `amplitude` decimal(26,8) NOT NULL COMMENT '幅度:单位%',
  `type` int(11) NOT NULL COMMENT '1涨 2.跌',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `robot_match_plan_pk` (`start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机器人成交计划'

=== TABLE: sign (rows: 0) ===
CREATE TABLE `sign` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(19,2) DEFAULT NULL,
  `creation_time` datetime DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `coin_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK58kn2gi7nvswa8hb76h87wtdl` (`coin_name`) USING BTREE,
  CONSTRAINT `FK58kn2gi7nvswa8hb76h87wtdl` FOREIGN KEY (`coin_name`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: symbol_price_bias (rows: 2) ===
CREATE TABLE `symbol_price_bias` (
  `id` int(10) NOT NULL,
  `symbol` varchar(200) NOT NULL,
  `bias` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: sys_advertise (rows: 0) ===
CREATE TABLE `sys_advertise` (
  `serial_number` varchar(255) NOT NULL,
  `author` varchar(255) DEFAULT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `end_time` varchar(255) NOT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `start_time` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `sys_advertise_location` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `lang` varchar(255) NOT NULL,
  `display_mode` int(11) DEFAULT '0',
  PRIMARY KEY (`serial_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='轮播图'

=== TABLE: sys_config (rows: 1) ===
CREATE TABLE `sys_config` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `promotion_prefix` varchar(255) NOT NULL,
  `contract_margin_rate` int(2) NOT NULL,
  `overnight_rate` int(2) NOT NULL,
  `fine_time_interval` int(6) NOT NULL,
  `follow_special_amount` int(6) NOT NULL,
  `sign_start` decimal(18,8) NOT NULL,
  `sign_type` int(1) NOT NULL,
  `sign_increment` decimal(18,8) NOT NULL,
  `sign_max` decimal(18,8) NOT NULL,
  `promotion_reward` decimal(18,8) NOT NULL,
  `project_name` varchar(200) NOT NULL,
  `project_logo` varchar(1000) NOT NULL,
  `project_avatar` varchar(1000) NOT NULL,
  `project_admin` varchar(1000) NOT NULL,
  `experience_wallet` int(1) NOT NULL,
  `internal_accounts` varchar(2000) DEFAULT NULL,
  `enable_exchange` int(1) NOT NULL,
  `enable_credit` int(1) NOT NULL,
  `funding_rebate` int(2) NOT NULL,
  `system_code` int(1) NOT NULL,
  `special_trader` smallint(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8

=== TABLE: sys_help (rows: 89) ===
CREATE TABLE `sys_help` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `author` varchar(255) DEFAULT NULL,
  `content` longtext,
  `create_time` datetime DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `is_top` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `sys_help_classification` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `lang` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8 COMMENT='系统帮助'

=== TABLE: tb_sms (rows: 0) ===
CREATE TABLE `tb_sms` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key_id` varchar(255) DEFAULT NULL,
  `key_secret` varchar(255) DEFAULT NULL,
  `sign_id` varchar(255) DEFAULT NULL,
  `sms_name` varchar(255) DEFAULT NULL,
  `sms_status` varchar(255) DEFAULT NULL,
  `template_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='短信Key参数表'

=== TABLE: temporary_purse (rows: 0) ===
CREATE TABLE `temporary_purse` (
  `id` int(11) DEFAULT NULL,
  `balance` double DEFAULT NULL,
  `frozen_balance` double DEFAULT NULL,
  `frozen_margin` double DEFAULT NULL,
  `e_usdt_address` text,
  `t_usdt_address` text,
  `position_type` int(11) DEFAULT NULL,
  `leverage` double DEFAULT NULL,
  `buy_leverage` text,
  `sell_leverage` text,
  `money_type` int(11) DEFAULT NULL,
  `is_supervised` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: trading_strategy (rows: 0) ===
CREATE TABLE `trading_strategy` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `volume_type` int(1) NOT NULL,
  `volume_value` decimal(4,2) NOT NULL,
  `profit_count` int(6) NOT NULL,
  `profit_percentage` decimal(4,2) NOT NULL,
  `loss_count` int(6) NOT NULL,
  `loss_percentage` decimal(4,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

=== TABLE: transfer_address (rows: 0) ===
CREATE TABLE `transfer_address` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `min_amount` decimal(18,2) DEFAULT NULL COMMENT '最低转账数目',
  `status` int(11) DEFAULT NULL,
  `transfer_fee` decimal(18,6) DEFAULT NULL COMMENT '转账手续费率',
  `coin_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK7iv0cmmj36ncaw1nx92x15vtu` (`coin_id`) USING BTREE,
  CONSTRAINT `FK7iv0cmmj36ncaw1nx92x15vtu` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='转账地址'

=== TABLE: transfer_record (rows: 0) ===
CREATE TABLE `transfer_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `amount` decimal(19,2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `fee` decimal(18,8) DEFAULT NULL COMMENT '手续费',
  `member_id` bigint(20) DEFAULT NULL,
  `target_member_id` bigint(20) NOT NULL,
  `order_sn` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `coin_id` varchar(255) DEFAULT NULL,
  `status` int(2) NOT NULL,
  `deal_time` datetime DEFAULT NULL,
  `deposit_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKkrlf3bglmf2c51sorq9fpue0g` (`coin_id`) USING BTREE,
  KEY `member_id` (`member_id`),
  CONSTRAINT `FKkrlf3bglmf2c51sorq9fpue0g` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9636 DEFAULT CHARSET=utf8 COMMENT='转账记录'

=== TABLE: user_purse (rows: 0) ===
CREATE TABLE `user_purse` (
  `id` bigint(20) NOT NULL,
  `balance` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `frozen_balance` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `frozen_margin` decimal(18,8) NOT NULL DEFAULT '0.00000000',
  `e_usdt_address` varchar(255) DEFAULT NULL,
  `t_usdt_address` varchar(255) DEFAULT NULL,
  `position_type` int(1) NOT NULL DEFAULT '0',
  `leverage` decimal(10,2) NOT NULL DEFAULT '10.00',
  `buy_leverage` decimal(10,2) DEFAULT '0.00',
  `sell_leverage` decimal(10,2) DEFAULT '0.00',
  `money_type` int(1) NOT NULL DEFAULT '0',
  `is_supervised` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: wallet_trans_record (rows: 0) ===
CREATE TABLE `wallet_trans_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amount` decimal(26,16) DEFAULT NULL COMMENT '划转金额',
  `create_time` datetime DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `source` int(11) DEFAULT '0' COMMENT '从哪里划转',
  `target` int(11) DEFAULT '0' COMMENT '划转到哪里去',
  `unit` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=159461 DEFAULT CHARSET=utf8 COMMENT='钱包交易记录\r\n'

=== TABLE: website_information (rows: 0) ===
CREATE TABLE `website_information` (
  `id` bigint(20) NOT NULL,
  `address_icon` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `copyright` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `other_information` text,
  `postcode` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网站信息\r\n'

=== TABLE: withdraw_backup (rows: 0) ===
CREATE TABLE `withdraw_backup` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `record_id` bigint(20) NOT NULL,
  `address` varchar(255) NOT NULL,
  `member_id` bigint(20) NOT NULL,
  `coin_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ukmemberidcoinid` (`record_id`,`address`,`member_id`,`coin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: withdraw_code_record (rows: 0) ===
CREATE TABLE `withdraw_code_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `deal_time` datetime DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `rmember_id` bigint(20) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `withdraw_amount` decimal(18,8) DEFAULT NULL COMMENT '申请总数量',
  `withdraw_code` varchar(255) DEFAULT NULL,
  `coin_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKa3kybqr5vhpnf5a57ridds671` (`coin_id`) USING BTREE,
  CONSTRAINT `FKa3kybqr5vhpnf5a57ridds671` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

=== TABLE: withdraw_fee_history (rows: 0) ===
CREATE TABLE `withdraw_fee_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `biz_type` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `fee_amount` decimal(28,8) DEFAULT NULL COMMENT '手续费数量',
  `fee_coin` varchar(255) DEFAULT NULL,
  `fee_type` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `u_id` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC

=== TABLE: withdraw_record (rows: 0) ===
CREATE TABLE `withdraw_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `arrived_amount` decimal(18,8) DEFAULT NULL COMMENT '预计到账数量',
  `can_auto_withdraw` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `deal_time` datetime DEFAULT NULL,
  `fee` decimal(18,8) DEFAULT NULL COMMENT '手续费',
  `is_auto` int(11) DEFAULT NULL,
  `member_id` bigint(20) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `total_amount` decimal(18,8) DEFAULT NULL COMMENT '申请总数量',
  `transaction_number` varchar(255) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `coin_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK2lmq6bcbk4nl3hmqcxbnx2kuc` (`admin_id`) USING BTREE,
  KEY `FK6drad9oqabujy0jsre3minxi` (`coin_id`) USING BTREE,
  CONSTRAINT `FK2lmq6bcbk4nl3hmqcxbnx2kuc` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`),
  CONSTRAINT `FK6drad9oqabujy0jsre3minxi` FOREIGN KEY (`coin_id`) REFERENCES `coin` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=13329 DEFAULT CHARSET=utf8