嗨玩后端开发规范

数据库表调整记录


易公会Plus v0.4 调整记录

<pre><code class="language-sql">-- --------------- ---------- v0.4.3 ------------------------- -- 新增权限 INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01101', 'EGH-API-FRONT-WD-01101'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01102', 'EGH-API-FRONT-WD-01102'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01103', 'EGH-API-FRONT-WD-01103'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01104', 'EGH-API-FRONT-WD-01104'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01105', 'EGH-API-FRONT-WD-01105'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01106', 'EGH-API-FRONT-WD-01106'); -- 提现记录回单地址记录表 CREATE TABLE `withdrawl_stm_receipt` (   `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `withdrawl_stm_id` varchar(128) NOT NULL COMMENT '提现记录ID',   `grant_receipt_id` varchar(128) NOT NULL COMMENT '发放回单记录ID',   `is_effect` tinyint(4) unsigned NOT NULL COMMENT '是否生效 0失效 1生效',   `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 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- 发放流水回单文件地址记录表 CREATE TABLE `image_file_path` (   `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `grant_receipt_id` varchar(128) NOT NULL COMMENT '发放回单记录ID', `image_domain` varchar(128) COMMENT '文件域名',   `image_path` varchar(128) NOT NULL COMMENT '文件地址',   `image_name` varchar(64) NOT NULL COMMENT '文件名称',   `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 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- --------------- 已上线 ---------- v0.4.2 ------------------------- -- 新增权限 INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_13003', 'EGH-API-FRONT-TEAM-13003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_13002', 'EGH-API-FRONT-TEAM-13002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01501', 'EGH-API-FRONT-STL-01501'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01502', 'EGH-API-FRONT-STL-01502'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01503', 'EGH-API-FRONT-STL-01503'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01504', 'EGH-API-FRONT-STL-01504'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01001', 'EGH-API-FRONT-FAST-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01002', 'EGH-API-FRONT-FAST-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01005', 'EGH-API-FRONT-FAST-01005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01006', 'EGH-API-FRONT-FAST-01006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01007', 'EGH-API-FRONT-FAST-01007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02001', 'EGH-API-FRONT-FAST-02001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02002', 'EGH-API-FRONT-FAST-02002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02003', 'EGH-API-FRONT-FAST-02003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02004', 'EGH-API-FRONT-FAST-02004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02005', 'EGH-API-FRONT-FAST-02005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02006', 'EGH-API-FRONT-FAST-02006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02007', 'EGH-API-FRONT-FAST-02007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02008', 'EGH-API-FRONT-FAST-02008'); -- 新增字段 ALTER TABLE `user` ADD COLUMN  `collect_acct`  tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '收款账户状态 1-未添加, 2-已添加'; -- 更新字段数据 UPDATE user,bank_account SET user.collect_acct = 2 WHERE user.id = bank_account.user_id AND bank_account.is_available = 1; -- 部门结算模式配置 CREATE TABLE `dept_stl_type_conf` (     `no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',     `id` VARCHAR ( 32 ) NOT NULL COMMENT '初始数据ID',     `dept_id` VARCHAR ( 32 ) NOT NULL COMMENT '部门id',     `dept_scope` TINYINT ( 4 )  UNSIGNED NOT NULL COMMENT '部门层级',     `stl_type` TINYINT ( 4 ) UNSIGNED NOT NULL COMMENT '结算模式 1-正常结算  2-快速结算 ',     `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_dept_stl_type_conf_id` ( `id` ) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- 快速发放收益初始数据 CREATE TABLE `fast_stl_gain_data` (   `no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `id` VARCHAR ( 128 ) NOT NULL COMMENT '初始数据ID',   `tab_id` VARCHAR ( 64 ) NOT NULL COMMENT '关联模板表ID',   `bat_id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',   `date` INT ( 11 ) UNSIGNED NOT NULL COMMENT '流水发生日期',   `biz_acct_id` VARCHAR ( 64 ) NOT NULL COMMENT '业务账号ID',   `biz_acct_num` VARCHAR ( 64 ) NOT NULL COMMENT '业务账号num',   `biz_acct_alias` VARCHAR ( 64 ) NOT NULL COMMENT '业务账号花名',   `room_id` VARCHAR ( 64 ) NOT NULL COMMENT '厅ID',   `room_num` VARCHAR ( 64 ) NOT NULL COMMENT '厅num',   `room_name` VARCHAR ( 64 ) NOT NULL COMMENT '厅名称',   `plf_biz_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '平台业务ID',   `tax_rate` DECIMAL ( 4, 3 ) NOT NULL COMMENT '税率',   `stl_dept` TINYINT ( 4 ) UNSIGNED NOT NULL COMMENT '结算部门 20-运营组 25-厅 30-业务账号',   `cus_fields` json DEFAULT NULL COMMENT '可变字段',   `other_fields` json DEFAULT NULL COMMENT '无用字段',   `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_fast_stl_gain_data_id` ( `id` ) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC; -- 快速发放收益批次 CREATE TABLE `fast_stl_gain_data_bat` (   `no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',   `tab_id` VARCHAR ( 64 ) NOT NULL COMMENT '关联模板表ID',   `company_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '公司主体ID',   `plf_biz_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '平台业务ID',   `room_id` VARCHAR ( 64 ) NOT NULL COMMENT '厅ID',   `total` int(11) NOT NULL COMMENT '总数',   `user_id` VARCHAR ( 128 ) DEFAULT NULL COMMENT '导入用户ID',   `import_date` INT ( 11 ) UNSIGNED NOT NULL COMMENT '导入时间',   `start_time` INT ( 11 ) UNSIGNED NOT NULL COMMENT '开始时间',   `end_time` INT ( 11 ) UNSIGNED NOT NULL COMMENT '结束时间',   `status` tinyint(1) NOT NULL DEFAULT '5' COMMENT '审核状态',   `reject_reason` varchar(255) DEFAULT NULL COMMENT '驳回原因',   `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_fast_stl_gain_data_id` ( `id` ) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC; -- 快速发放收益计算数据 CREATE TABLE `fast_stl_gain_stm_data` (   `no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `id` VARCHAR ( 128 ) NOT NULL COMMENT '初始数据ID',   `tab_id` VARCHAR ( 64 ) NOT NULL COMMENT '关联模板表ID',   `bat_id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',   `date` INT ( 11 ) UNSIGNED NOT NULL COMMENT '流水发生日期',   `biz_acct_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '业务账号ID',   `room_id` VARCHAR ( 64 ) NOT NULL COMMENT '厅ID',   `plf_biz_id` VARCHAR ( 64 ) NOT NULL COMMENT '平台业务ID',   `stm_amount` DECIMAL( 13, 2 ) NOT NULL COMMENT '流水',   `stl_dept` TINYINT ( 4 ) UNSIGNED NOT NULL COMMENT '结算部门 20-运营组 25-厅 30-业务账号',   `tax_rate` DECIMAL ( 4, 3 ) NOT NULL COMMENT '税率',   `all_earnings_amount` DECIMAL( 13, 2 ) NOT NULL COMMENT '总收益(税后)',   `pack_id` varchar(64) 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_fast_stl_gain_data_id` ( `id` ) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC; -- 快速发放收益批次状态变化记录 CREATE TABLE `fast_stl_gain_data_bat_status_line` (   `no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',   `id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',   `bat_id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',   `status` tinyint(1) NOT NULL DEFAULT '5' COMMENT '审核状态',   `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_fast_stl_gain_data_id` ( `id` ) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC; -- 结算账户新增收入类型字段, 用于区分是快速结算还是正常结算 1-正常结算 2-快速结算 ALTER TABLE `stl_acct_income` ADD COLUMN `income_type` TINYINT ( 1 ) NOT NULL DEFAULT '1' COMMENT '结算账户收入类型'; -- 收益发放记录展示表新增快速收益字段 ALTER TABLE `view_earnings_grant_detail` ADD COLUMN `fast_stl_earning` DECIMAL ( 13, 2 ) NOT NULL DEFAULT 0 COMMENT '快速收益(税后)'; -- 结算批次对应发放批次新增批次类型 ALTER TABLE `stl_bat_and_grant_bat` ADD COLUMN `bat_type` TINYINT ( 1 ) NOT NULL DEFAULT '1' COMMENT '批次类型'; </code></pre>

页面列表

ITEM_HTML