嗨玩后端开发规范

数据库表调整记录


易公会数据库v1.7调整记录

<pre><code class="language-sql">-- ---------------  已上线  ----------------- v1.7.3 ----------------- -- 新增权限 INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01004', 'EGH-API-FRONT-INFO-01004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08010', 'EGH-API-FRONT-TEAM-08010'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01013', 'EGH-API-FRONT-WAL-01013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01014', 'EGH-API-FRONT-WAL-01014'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01015', 'EGH-API-FRONT-WAL-01015'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_EARNINGS_01007', 'EGH-API-FRONT-EARNINGS-01007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WALLET_01001', 'EGH-API-FRONT-WALLET-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WALLET_01002', 'EGH-API-FRONT-WALLET-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05004', 'EGH-API-FRONT-MANAGE-05004'); ALTER TABLE `withdrawl_astrict` ADD COLUMN `min_withdrawl_limit` decimal(13,2) NOT NULL DEFAULT 0 COMMENT '最小提现额度限制'; ALTER TABLE `user` ADD COLUMN `entry_time` int(11) DEFAULT NULL COMMENT '入职时间'; -- 开户行查询 CREATE TABLE `bank_address_request_rec` ( `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增', `order_no` varchar(128) NOT NULL COMMENT '订单号', `bank_num` varchar(128) NOT NULL COMMENT '银行卡号', `bank` varchar(128) NULL COMMENT '银行名称', `province` varchar(128) NULL COMMENT '开户省', `city` varchar(128) NULL COMMENT '开户市', `card_name` varchar(128) NULL COMMENT '卡名称', `type` varchar(128) NULL COMMENT '卡类型', `abbreviation` varchar(128) NULL COMMENT '银联支付网关简码', `is_available` tinyint(1) unsigned NOT NULL DEFAULT '1', `creation_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间', PRIMARY KEY (`no_`) USING BTREE, UNIQUE KEY `uk_bank_num` (`bank_num`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- 收益发放记录 CREATE TABLE `view_earnings_grant_bat_grant_rec` ( `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增', `id` varchar(128) NOT NULL COMMENT '收益发放记录ID', `plf_biz_id` varchar(128) NOT NULL COMMENT '平台业务ID', `stl_cycle` tinyint(1) NOT NULL DEFAULT '1' COMMENT '结算模式', `start_stl_date` int(11) NOT NULL COMMENT '结算开始时间', `end_stl_date` int(11) NOT NULL COMMENT '结算结束时间', `grant_amount_sum` decimal(13,2) NOT NULL COMMENT '发放总金额', `grant_time` int(11) NOT NULL COMMENT '发放时间', `grant_sucess_amount` decimal(13,2) NOT NULL COMMENT '发放成功金额', `grant_fail_amount` decimal(13,2) NOT NULL COMMENT '发放失败金额', `grant_status` tinyint(1) NOT NULL COMMENT '发放结果', `grant_status_remark` varchar(256) DEFAULT NULL COMMENT '发放结果说明', `grant_bat_id` varchar(256) DEFAULT NULL COMMENT '发放批次ID', `is_available` tinyint(1) unsigned NOT NULL DEFAULT '1', `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间', PRIMARY KEY (`no_`) USING BTREE, UNIQUE KEY `uk_view_earnings_grant_bat` (`id`) USING BTREE, KEY `k_plf_biz_id` (`plf_biz_id`) USING BTREE, KEY `k_stl_cycle` (`stl_cycle`) USING BTREE, KEY `k_start_stl_date` (`start_stl_date`) USING BTREE, KEY `k_end_stl_date` (`end_stl_date`) USING BTREE, KEY `k_grant_time` (`grant_time`) USING BTREE, KEY `k_grant_status` (`grant_status`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------  已上线  ----------------- v1.7.2 ----------------- -- 新增权限 INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04023', 'EGH-API-FRONT-STL-04023'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06108', 'EGH-API-FRONT-STL-06108'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06109', 'EGH-API-FRONT-STL-06109'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06120', 'EGH-API-FRONT-STL-06120'); CREATE TABLE `stl_acct_income_and_stl_data` (   `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `id` varchar(64) NOT NULL COMMENT 'id',   `data_id` varchar(64) NOT NULL COMMENT '结算数据ID stl_stm',   `income_id` varchar(64) NOT NULL COMMENT '钱包收入ID',   `stl_income_id` varchar(64) NOT NULL COMMENT '结算账户收入ID',   `pack_id` varchar(64) NOT NULL COMMENT '手动划款打包批次ID',   `is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',   `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',   PRIMARY KEY (`no_`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=960 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------  已上线  ----------------- v1.7.1.2 ----------------- CREATE TABLE `bank_three_elements_request_rec` (   `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `id` varchar(128) NOT NULL COMMENT 'id',   `name` varchar(32) NOT NULL COMMENT '姓名',   `id_card_num` varchar(32) NOT NULL COMMENT '身份证号码',   `bank_card_num` varchar(32) NOT NULL COMMENT '银行卡号',   `response_code` varchar(16) NOT NULL COMMENT '请求返回错误码 200正常 200以上 错误',   `request_id` varchar(32) DEFAULT NULL COMMENT '请求ID',   `result_state` tinyint(1) DEFAULT NULL COMMENT '返回值为 0 : 一致 返回值为 1 : 不一致  返回值为 2:卡状态异常',   `result_msg` varchar(128) DEFAULT NULL COMMENT '错误码为200以上时会有',   `is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',   `creation_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,   `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',   PRIMARY KEY (`no_`) USING BTREE,   UNIQUE KEY `uk_bank_account_id` (`id`) USING BTREE,   UNIQUE KEY `uk_three_elements` (`name`,`id_card_num`,`bank_card_num`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- 新增权限 INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03017', 'EGH-API-FRONT-STL-03017'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03018', 'EGH-API-FRONT-STL-03018'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04020', 'EGH-API-FRONT-STL-04020'); -- ---------------  已上线  ----------------- V1.7.1.1 ----------------- -- 新增权限 INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_01001', 'EGH-API-FRONT-MANAGE-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_01002', 'EGH-API-FRONT-MANAGE-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_02001', 'EGH-API-FRONT-MANAGE-02001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_03001', 'EGH-API-FRONT-MANAGE-03001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_03002', 'EGH-API-FRONT-MANAGE-03002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_04001', 'EGH-API-FRONT-MANAGE-04001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05001', 'EGH-API-FRONT-MANAGE-05001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05002', 'EGH-API-FRONT-MANAGE-05002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05003', 'EGH-API-FRONT-MANAGE-05003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_06001', 'EGH-API-FRONT-MANAGE-06001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_06002', 'EGH-API-FRONT-MANAGE-06002');</code></pre>

页面列表

ITEM_HTML