SET NAMES utf8mb4;
|
|
-- 补齐 Mycat 四个业务库的中文表注释和字段注释。
|
-- 仅修改 COMMENT 元数据，完整保留字段类型、可空性、默认值及扩展属性。
|
|
-- 中文表注释（排除框架事务日志表 undo_log）
|
ALTER TABLE `charging_pile_account`.`t_app_user_whitelist` COMMENT = '小程序用户白名单';
|
ALTER TABLE `charging_pile_account`.`t_app_user_site_favorite` COMMENT = '小程序用户收藏站点';
|
ALTER TABLE `charging_pile_account`.`t_app_user_tag` COMMENT = '小程序用户标签关联';
|
ALTER TABLE `charging_pile_account`.`t_app_user_sign` COMMENT = '小程序用户签到记录';
|
ALTER TABLE `charging_pile_account`.`t_app_user_vip_detail` COMMENT = '小程序用户会员权益明细';
|
ALTER TABLE `charging_pile_account`.`t_app_user_car` COMMENT = '小程序用户车辆信息';
|
ALTER TABLE `charging_pile_account`.`t_app_user_integral_change` COMMENT = '小程序用户积分变更记录';
|
ALTER TABLE `charging_pile_account`.`t_app_user_whitelist_site` COMMENT = '小程序用户白名单站点关联';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` COMMENT = 'VIN码管理';
|
ALTER TABLE `charging_pile_account`.`t_app_coupon` COMMENT = '小程序用户优惠券';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` COMMENT = '充电卡';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` COMMENT = '充电卡余额变更记录';
|
ALTER TABLE `charging_pile_account`.`t_app_user` COMMENT = '小程序用户';
|
ALTER TABLE `charging_pile_account`.`t_invite_user` COMMENT = '邀请用户记录';
|
ALTER TABLE `charging_pile_account`.`t_invoice_information` COMMENT = '用户发票抬头信息';
|
ALTER TABLE `charging_pile_account`.`t_app_user_address` COMMENT = '小程序用户收货地址';
|
ALTER TABLE `charging_pile_order`.`t_charging_settlement_bill` COMMENT = '充电结算账单';
|
ALTER TABLE `charging_pile_order`.`t_vip_order_refund` COMMENT = '会员订单退款记录';
|
ALTER TABLE `charging_pile_order`.`t_card_accounting_strategy_detail_order` COMMENT = '充电卡订单计费策略明细快照';
|
ALTER TABLE `charging_pile_order`.`t_settlement_confirm` COMMENT = '结算确认记录';
|
ALTER TABLE `charging_pile_order`.`t_accounting_strategy_order` COMMENT = '充电订单计费策略快照';
|
ALTER TABLE `charging_pile_order`.`t_order_appeal` COMMENT = '订单申诉记录';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_refund` COMMENT = '充电卡充电订单退款记录';
|
ALTER TABLE `charging_pile_order`.`t_evaluation_auto_reply` COMMENT = '评价自动回复规则';
|
ALTER TABLE `charging_pile_order`.`t_vip_order` COMMENT = '会员订单';
|
ALTER TABLE `charging_pile_order`.`t_card_accounting_strategy_order` COMMENT = '充电卡订单计费策略快照';
|
ALTER TABLE `charging_pile_order`.`t_vin_accounting_strategy_detail_order` COMMENT = 'VIN充电订单计费策略明细快照';
|
ALTER TABLE `charging_pile_order`.`t_shopping_order` COMMENT = '商城订单';
|
ALTER TABLE `charging_pile_order`.`t_vin_accounting_strategy_order` COMMENT = 'VIN充电订单计费策略快照';
|
ALTER TABLE `charging_pile_order`.`t_order_evaluate_tag` COMMENT = '订单评价标签关联记录';
|
ALTER TABLE `charging_pile_order`.`t_grant_vip` COMMENT = '赠送会员记录';
|
ALTER TABLE `charging_pile_order`.`t_charging_bill` COMMENT = '充电账单';
|
ALTER TABLE `charging_pile_order`.`t_account_settlement_statement` COMMENT = '账户结算单';
|
ALTER TABLE `charging_pile_order`.`t_shopping_order_refund` COMMENT = '商城订单退款记录';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_summary_data` COMMENT = '充电订单汇总数据';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice` COMMENT = '订单发票';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order` COMMENT = 'VIN充电订单';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_refund` COMMENT = 'VIN充电订单退款记录';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` COMMENT = '充电卡充电订单分账记录';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_refund` COMMENT = '充电订单退款记录';
|
ALTER TABLE `charging_pile_order`.`t_accounting_strategy_detail_order` COMMENT = '充电订单计费策略明细快照';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order` COMMENT = '充电卡充电订单';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` COMMENT = '充电订单全渠道分账记录';
|
ALTER TABLE `charging_pile_order`.`t_order_evaluate` COMMENT = '订单评价';
|
ALTER TABLE `charging_pile_order`.`t_charging_order` COMMENT = '充电订单';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` COMMENT = 'VIN充电订单分账记录';
|
ALTER TABLE `charging_pile_order`.`t_large_screen_site_stat` COMMENT = '数据大屏站点统计';
|
ALTER TABLE `charging_pile_order`.`t_large_screen_user_site` COMMENT = '数据大屏用户站点关联';
|
ALTER TABLE `charging_pile_order`.`t_exchange_order` COMMENT = '兑换订单';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_accounting_strategy` COMMENT = '充电卡订单计费策略关联';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_accounting_strategy` COMMENT = '充电订单计费策略关联';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice_detail` COMMENT = '订单开票明细';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_accounting_strategy` COMMENT = 'VIN充电订单计费策略关联';
|
ALTER TABLE `charging_pile_other`.`t_emind_station` COMMENT = 'eMind储能电站本地信息';
|
ALTER TABLE `charging_pile_other`.`t_screen_content` COMMENT = '数据大屏内容配置';
|
ALTER TABLE `charging_pile_other`.`t_activity` COMMENT = '活动';
|
ALTER TABLE `charging_pile_other`.`t_invoice_type` COMMENT = '发票类型';
|
ALTER TABLE `charging_pile_other`.`t_exchange_code_package_spec` COMMENT = '兑换码套餐规格';
|
ALTER TABLE `charging_pile_other`.`t_goods` COMMENT = '商品';
|
ALTER TABLE `charging_pile_other`.`t_integral_rule` COMMENT = '积分规则';
|
ALTER TABLE `charging_pile_other`.`t_company` COMMENT = '单位';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_curve` COMMENT = 'eMind储能看板当日功率曲线';
|
ALTER TABLE `charging_pile_other`.`t_evaluation_tag` COMMENT = '评价标签';
|
ALTER TABLE `charging_pile_other`.`t_role_site` COMMENT = '角色站点关联';
|
ALTER TABLE `charging_pile_other`.`sys_role` COMMENT = '角色信息';
|
ALTER TABLE `charging_pile_other`.`t_screen_carport` COMMENT = '数据大屏车位信息';
|
ALTER TABLE `charging_pile_other`.`t_general_screen_content` COMMENT = '通用数据大屏内容配置';
|
ALTER TABLE `charging_pile_other`.`t_app_user_whitelist_site` COMMENT = '小程序用户白名单站点关联';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` COMMENT = 'eMind储能看板日统计历史';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` COMMENT = 'eMind储能看板最新快照';
|
ALTER TABLE `charging_pile_other`.`t_advertising` COMMENT = '广告';
|
ALTER TABLE `charging_pile_other`.`gen_table_column` COMMENT = '代码生成业务表字段';
|
ALTER TABLE `charging_pile_other`.`sys_job` COMMENT = '定时任务调度';
|
ALTER TABLE `charging_pile_other`.`sys_login_log` COMMENT = '登录日志';
|
ALTER TABLE `charging_pile_other`.`sys_user_post` COMMENT = '用户与岗位关联';
|
ALTER TABLE `charging_pile_other`.`t_exchange_code_detail` COMMENT = '兑换码明细';
|
ALTER TABLE `charging_pile_other`.`sys_role_dept` COMMENT = '角色和部门关联';
|
ALTER TABLE `charging_pile_other`.`t_user_site` COMMENT = '用户站点关联';
|
ALTER TABLE `charging_pile_other`.`sys_menu` COMMENT = '菜单权限';
|
ALTER TABLE `charging_pile_other`.`t_emind_energy_chain` COMMENT = 'eMind能源链';
|
ALTER TABLE `charging_pile_other`.`sys_job_log` COMMENT = '定时任务调度日志';
|
ALTER TABLE `charging_pile_other`.`sys_role_menu` COMMENT = '角色和菜单关联';
|
ALTER TABLE `charging_pile_other`.`t_system_configuration` COMMENT = '系统配置';
|
ALTER TABLE `charging_pile_other`.`t_html` COMMENT = 'H5文本';
|
ALTER TABLE `charging_pile_other`.`sys_faq` COMMENT = '常见问题';
|
ALTER TABLE `charging_pile_other`.`t_enterprise_user_application` COMMENT = '企业用户申请';
|
ALTER TABLE `charging_pile_other`.`sys_user` COMMENT = '用户信息';
|
ALTER TABLE `charging_pile_other`.`t_station_collect` COMMENT = '站点收藏';
|
ALTER TABLE `charging_pile_other`.`sys_dept` COMMENT = '部门';
|
ALTER TABLE `charging_pile_other`.`t_station_base` COMMENT = '站点基础信息';
|
ALTER TABLE `charging_pile_other`.`sys_config` COMMENT = '参数配置';
|
ALTER TABLE `charging_pile_other`.`t_operator` COMMENT = '运营商';
|
ALTER TABLE `charging_pile_other`.`t_vip` COMMENT = '会员规则';
|
ALTER TABLE `charging_pile_other`.`t_user_tag` COMMENT = '用户标签';
|
ALTER TABLE `charging_pile_other`.`t_region` COMMENT = '行政区域信息';
|
ALTER TABLE `charging_pile_other`.`t_station_earn` COMMENT = '站点收益';
|
ALTER TABLE `charging_pile_other`.`sys_dict_type` COMMENT = '字典类型';
|
ALTER TABLE `charging_pile_other`.`t_app_user_whitelist` COMMENT = '小程序用户白名单';
|
ALTER TABLE `charging_pile_other`.`gen_table` COMMENT = '代码生成业务表';
|
ALTER TABLE `charging_pile_other`.`sys_dict_data` COMMENT = '字典数据';
|
ALTER TABLE `charging_pile_other`.`t_coupon` COMMENT = '优惠券';
|
ALTER TABLE `charging_pile_other`.`t_exchange_code_use_record` COMMENT = '兑换码使用记录';
|
ALTER TABLE `charging_pile_other`.`t_device_management` COMMENT = '设备管理';
|
ALTER TABLE `charging_pile_other`.`t_exchange_code_package` COMMENT = '兑换码套餐';
|
ALTER TABLE `charging_pile_other`.`sys_oper_log` COMMENT = '操作日志';
|
ALTER TABLE `charging_pile_other`.`sys_user_role` COMMENT = '用户和角色关联';
|
ALTER TABLE `charging_pile_other`.`t_emind_energy_block` COMMENT = 'eMind能量块';
|
ALTER TABLE `charging_pile_other`.`sys_post` COMMENT = '岗位信息';
|
ALTER TABLE `charging_pile_other`.`t_station_info` COMMENT = '站点信息';
|
ALTER TABLE `charging_pile_other`.`t_icbc_payment_flow_record` COMMENT = '工商银行支付流水记录';
|
ALTER TABLE `charging_pile_other`.`t_notice` COMMENT = '公告';
|
ALTER TABLE `charging_pile_other`.`sys_notice` COMMENT = '通知公告';
|
ALTER TABLE `charging_pile_service`.`t_charging_gun` COMMENT = '充电枪';
|
ALTER TABLE `charging_pile_service`.`t_fault_message` COMMENT = '故障信息';
|
ALTER TABLE `charging_pile_service`.`t_charging_pile` COMMENT = '充电桩';
|
ALTER TABLE `charging_pile_service`.`t_partner_app_user` COMMENT = '合作商小程序用户关联';
|
ALTER TABLE `charging_pile_service`.`sys_faq` COMMENT = '常见问题';
|
ALTER TABLE `charging_pile_service`.`t_charging_pile_notification` COMMENT = '充电桩系统通知';
|
ALTER TABLE `charging_pile_service`.`t_partner_site` COMMENT = '合作商站点关联';
|
ALTER TABLE `charging_pile_service`.`t_accounting_strategy` COMMENT = '充电计费策略';
|
ALTER TABLE `charging_pile_service`.`t_apply_charging_pile` COMMENT = '建桩申请';
|
ALTER TABLE `charging_pile_service`.`t_site` COMMENT = '充电站点';
|
ALTER TABLE `charging_pile_service`.`t_vehicle_ramp` COMMENT = '车辆道闸';
|
ALTER TABLE `charging_pile_service`.`t_partner` COMMENT = '合作商';
|
ALTER TABLE `charging_pile_service`.`t_accounting_strategy_detail` COMMENT = '充电计费策略明细';
|
ALTER TABLE `charging_pile_service`.`t_carport` COMMENT = '停车位';
|
ALTER TABLE `charging_pile_service`.`t_parking_record` COMMENT = '停车记录';
|
ALTER TABLE `charging_pile_service`.`t_site_menu` COMMENT = '站点菜单关联';
|
ALTER TABLE `charging_pile_service`.`t_monitoring_equipment` COMMENT = '监控设备';
|
ALTER TABLE `charging_pile_service`.`t_repair` COMMENT = '维修记录';
|
ALTER TABLE `charging_pile_service`.`t_parking_lot` COMMENT = '停车场';
|
|
-- 中文字段注释
|
-- 修正历史纯英文、乱码或空白字段注释
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `app_user_id` bigint NULL DEFAULT NULL COMMENT '绑定的小程序用户ID';
|
ALTER TABLE `charging_pile_order`.`t_vip_order_refund` MODIFY COLUMN `pay_type` int NULL DEFAULT NULL COMMENT '支付方式：1微信，2支付宝';
|
ALTER TABLE `charging_pile_order`.`t_shopping_order_refund` MODIFY COLUMN `pay_type` int NULL DEFAULT NULL COMMENT '支付方式：1微信，2支付宝';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_refund` MODIFY COLUMN `pay_type` int NULL DEFAULT NULL COMMENT '支付方式：1微信，2支付宝';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice` MODIFY COLUMN `site_id` int NULL DEFAULT NULL COMMENT '站点ID';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice` MODIFY COLUMN `partner_id` int NULL DEFAULT NULL COMMENT '合作商ID';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice` MODIFY COLUMN `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice` MODIFY COLUMN `cancel_time` datetime NULL DEFAULT NULL COMMENT '取消时间';
|
ALTER TABLE `charging_pile_order`.`t_large_screen_site_stat` MODIFY COLUMN `period` varchar(16) NOT NULL COMMENT '统计周期：日为yyyy-MM-dd，月为yyyy-MM，全局为ALL';
|
ALTER TABLE `charging_pile_other`.`t_emind_energy_chain` MODIFY COLUMN `soc` decimal(8,4) NULL DEFAULT NULL COMMENT '电池荷电状态（%）';
|
ALTER TABLE `charging_pile_other`.`t_emind_energy_chain` MODIFY COLUMN `source_type` tinyint NOT NULL DEFAULT 1 COMMENT '数据来源：1远程同步，2手工录入';
|
ALTER TABLE `charging_pile_other`.`t_emind_energy_chain` MODIFY COLUMN `management_deleted` tinyint NOT NULL DEFAULT 0 COMMENT '管理端删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_other`.`t_emind_energy_block` MODIFY COLUMN `soc` decimal(8,4) NULL DEFAULT NULL COMMENT '电池荷电状态（%）';
|
ALTER TABLE `charging_pile_other`.`sys_user` MODIFY COLUMN `operation_password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作密码';
|
ALTER TABLE `charging_pile_other`.`sys_user` MODIFY COLUMN `login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间';
|
ALTER TABLE `charging_pile_service`.`t_accounting_strategy` MODIFY COLUMN `partner_id` int NULL DEFAULT NULL COMMENT '合作商ID';
|
ALTER TABLE `charging_pile_service`.`t_accounting_strategy` MODIFY COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间';
|
ALTER TABLE `charging_pile_service`.`t_site` MODIFY COLUMN `venue_partner_id` int NULL DEFAULT NULL COMMENT '场地方合作商ID';
|
ALTER TABLE `charging_pile_service`.`t_partner` MODIFY COLUMN `partner_type` int NULL DEFAULT NULL COMMENT '合作商类型：1普通合作商，2场地方，3服务商';
|
ALTER TABLE `charging_pile_service`.`t_partner` MODIFY COLUMN `venue_share_amount` decimal(10,2) NULL DEFAULT NULL COMMENT '场地方合作商分账金额（元）';
|
ALTER TABLE `charging_pile_service`.`t_parking_lot` MODIFY COLUMN `barrier_brand` int NULL DEFAULT NULL COMMENT '道闸品牌：1顺捷，2吉莲';
|
|
|
ALTER TABLE `charging_pile_account`.`t_app_user_car` MODIFY COLUMN `pic` varchar(255) NULL COMMENT '车辆图片';
|
ALTER TABLE `charging_pile_account`.`t_app_user_vip_detail` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_account`.`t_app_user_vip_detail` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_account`.`t_app_user_vip_detail` MODIFY COLUMN `send_charge_num` int NULL COMMENT '赠送充电次数';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `card_no` varchar(64) NOT NULL COMMENT '充电卡卡号';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `balance` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '卡内可用余额（元）';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `status` tinyint NOT NULL DEFAULT 1 COMMENT '启用状态：1启用，2禁用';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `del_flag` tinyint NOT NULL DEFAULT 0 COMMENT '删除状态：0正常，2删除';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `create_by` bigint NULL COMMENT '创建人ID';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `update_time` datetime NULL COMMENT '最后修改时间';
|
ALTER TABLE `charging_pile_account`.`t_charging_card` MODIFY COLUMN `update_by` bigint NULL COMMENT '最后修改人ID';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` MODIFY COLUMN `card_id` bigint NOT NULL COMMENT '充电卡ID';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` MODIFY COLUMN `change_type` tinyint NOT NULL COMMENT '余额变更类型';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` MODIFY COLUMN `amount` decimal(12,2) NOT NULL COMMENT '余额变更金额（元）';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` MODIFY COLUMN `remark` varchar(255) NULL COMMENT '备注';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` MODIFY COLUMN `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';
|
ALTER TABLE `charging_pile_account`.`t_charging_card_balance_record` MODIFY COLUMN `create_by` bigint NULL COMMENT '创建人ID';
|
ALTER TABLE `charging_pile_account`.`t_invoice_information` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `vin` varchar(64) NOT NULL COMMENT '车辆识别代号（VIN码）';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `plate_number` varchar(32) NULL COMMENT '车牌号';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `phone` varchar(32) NULL COMMENT '联系手机号';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `company_name` varchar(128) NULL COMMENT '所属公司名称';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `remark` varchar(255) NULL COMMENT '备注';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `status` tinyint NOT NULL DEFAULT 1 COMMENT '启用状态：1启用，2禁用';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `del_flag` tinyint NOT NULL DEFAULT 0 COMMENT '删除状态：0正常，2删除';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `create_by` bigint NULL COMMENT '创建人ID';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `update_time` datetime NULL COMMENT '最后修改时间';
|
ALTER TABLE `charging_pile_account`.`t_vin_management` MODIFY COLUMN `update_by` bigint NULL COMMENT '最后修改人ID';
|
ALTER TABLE `charging_pile_order`.`t_accounting_strategy_detail_order` MODIFY COLUMN `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_accounting_strategy_detail_order` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_card_accounting_strategy_detail_order` MODIFY COLUMN `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_card_accounting_strategy_detail_order` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_refund` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_refund` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `channel_pay_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道实付金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `channel_gift_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道赠送金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `channel_pay_ratio` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '渠道实付金额占比';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `channel_electricity_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道分摊电费金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `channel_service_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道分摊服务费金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `electricity_share_ratio` decimal(5,2) NULL COMMENT '电费分账比例';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `service_share_ratio` decimal(5,2) NULL COMMENT '服务费分账比例';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `electricity_share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '电费分账金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `service_share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '服务费分账金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '分账总金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `need_online_share` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要线上分账：0否，1是';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `online_share_status` varchar(16) NOT NULL DEFAULT 'RECORDED' COMMENT '线上分账状态';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `seq_no` varchar(50) NULL COMMENT '交易流水号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `busi_type` varchar(1) NULL COMMENT '业务类型';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `ori_mer_id` varchar(20) NULL COMMENT '原交易商户号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `ori_trx_date` date NULL COMMENT '原交易日期';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `sub_order_id` varchar(50) NULL COMMENT '子订单号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `sub_mer_id` varchar(20) NULL COMMENT '子商户号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `sub_mer_prtcl_no` varchar(20) NULL COMMENT '子商户协议号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `mer_acct` varchar(34) NULL COMMENT '商户结算账号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `icbc_order_id` varchar(64) NULL COMMENT '工商银行订单号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `sub_order_seq` varchar(32) NULL COMMENT '子订单序号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `sub_order_trxid` varchar(64) NULL COMMENT '子订单交易流水号';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `rec_result` varchar(8) NULL COMMENT '受理结果';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `request_json` text NULL COMMENT '请求报文';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `response_json` text NULL COMMENT '响应报文';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `fail_reason` varchar(512) NULL COMMENT '失败原因';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `retry_count` int NOT NULL DEFAULT 0 COMMENT '重试次数';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `last_retry_time` datetime NULL COMMENT '最后重试时间';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_card_charging_order_share_record` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_refund` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_refund` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `channel_pay_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道实付金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `channel_gift_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道赠送金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `channel_pay_ratio` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '渠道实付金额占比';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `channel_electricity_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道分摊电费金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `channel_service_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道分摊服务费金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `electricity_share_ratio` decimal(5,2) NULL COMMENT '电费分账比例';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `service_share_ratio` decimal(5,2) NULL COMMENT '服务费分账比例';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `electricity_share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '电费分账金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `service_share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '服务费分账金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '分账总金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `need_online_share` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要线上分账：0否，1是';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `online_share_status` varchar(16) NOT NULL DEFAULT 'RECORDED' COMMENT '线上分账状态';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `seq_no` varchar(50) NULL COMMENT '交易流水号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `busi_type` varchar(1) NULL COMMENT '业务类型';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `ori_mer_id` varchar(20) NULL COMMENT '原交易商户号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `ori_trx_date` date NULL COMMENT '原交易日期';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `sub_order_id` varchar(50) NULL COMMENT '子订单号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `sub_mer_id` varchar(20) NULL COMMENT '子商户号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `sub_mer_prtcl_no` varchar(20) NULL COMMENT '子商户协议号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `mer_acct` varchar(34) NULL COMMENT '商户结算账号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `icbc_order_id` varchar(64) NULL COMMENT '工商银行订单号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `sub_order_seq` varchar(32) NULL COMMENT '子订单序号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `sub_order_trxid` varchar(64) NULL COMMENT '子订单交易流水号';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `rec_result` varchar(8) NULL COMMENT '受理结果';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `request_json` text NULL COMMENT '请求报文';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `response_json` text NULL COMMENT '响应报文';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `fail_reason` varchar(512) NULL COMMENT '失败原因';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `retry_count` int NOT NULL DEFAULT 0 COMMENT '重试次数';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `last_retry_time` datetime NULL COMMENT '最后重试时间';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_charging_order_share_record` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_order_evaluate_tag` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_order_evaluate_tag` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice_detail` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_order_invoice_detail` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_shopping_order_refund` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_shopping_order_refund` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_vin_accounting_strategy_detail_order` MODIFY COLUMN `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_vin_accounting_strategy_detail_order` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_refund` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_refund` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `channel_pay_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道实付金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `channel_gift_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道赠送金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `channel_pay_ratio` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '渠道实付金额占比';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `channel_electricity_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道分摊电费金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `channel_service_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道分摊服务费金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `electricity_share_ratio` decimal(5,2) NULL COMMENT '电费分账比例';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `service_share_ratio` decimal(5,2) NULL COMMENT '服务费分账比例';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `electricity_share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '电费分账金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `service_share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '服务费分账金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `share_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '分账总金额（元）';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `need_online_share` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要线上分账：0否，1是';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `online_share_status` varchar(16) NOT NULL DEFAULT 'RECORDED' COMMENT '线上分账状态';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `seq_no` varchar(50) NULL COMMENT '交易流水号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `busi_type` varchar(1) NULL COMMENT '业务类型';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `ori_mer_id` varchar(20) NULL COMMENT '原交易商户号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `ori_trx_date` date NULL COMMENT '原交易日期';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `sub_order_id` varchar(50) NULL COMMENT '子订单号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `sub_mer_id` varchar(20) NULL COMMENT '子商户号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `sub_mer_prtcl_no` varchar(20) NULL COMMENT '子商户协议号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `mer_acct` varchar(34) NULL COMMENT '商户结算账号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `icbc_order_id` varchar(64) NULL COMMENT '工商银行订单号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `sub_order_seq` varchar(32) NULL COMMENT '子订单序号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `sub_order_trxid` varchar(64) NULL COMMENT '子订单交易流水号';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `rec_result` varchar(8) NULL COMMENT '受理结果';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `request_json` text NULL COMMENT '请求报文';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `response_json` text NULL COMMENT '响应报文';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `fail_reason` varchar(512) NULL COMMENT '失败原因';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `retry_count` int NOT NULL DEFAULT 0 COMMENT '重试次数';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `last_retry_time` datetime NULL COMMENT '最后重试时间';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_vin_charging_order_share_record` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_order`.`t_vip_order_refund` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_order`.`t_vip_order_refund` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_curve` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_curve` MODIFY COLUMN `station_id` bigint NOT NULL COMMENT 'eMind平台站点ID';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_curve` MODIFY COLUMN `record_time` varchar(64) NOT NULL COMMENT '数据记录时间';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_curve` MODIFY COLUMN `power` decimal(18,4) NULL COMMENT '实时功率（kW）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_curve` MODIFY COLUMN `soc` decimal(8,4) NULL COMMENT '电池荷电状态（%）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_curve` MODIFY COLUMN `synced_at` datetime NOT NULL COMMENT '最后同步时间';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `station_id` bigint NOT NULL COMMENT 'eMind平台站点ID';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `stat_date` date NOT NULL COMMENT '统计日期';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `price` decimal(18,4) NULL COMMENT '电价（元/kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `price_name` varchar(128) NULL COMMENT '电价名称';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `income` decimal(18,4) NULL COMMENT '收益（元）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `charged_energy` decimal(18,4) NULL COMMENT '充电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `charged_energy_sharp` decimal(18,4) NULL COMMENT '尖时段充电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `charged_energy_peak` decimal(18,4) NULL COMMENT '峰时段充电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `charged_energy_flat` decimal(18,4) NULL COMMENT '平时段充电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `charged_energy_valley` decimal(18,4) NULL COMMENT '谷时段充电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `discharged_energy` decimal(18,4) NULL COMMENT '放电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `discharged_energy_sharp` decimal(18,4) NULL COMMENT '尖时段放电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `discharged_energy_peak` decimal(18,4) NULL COMMENT '峰时段放电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `discharged_energy_flat` decimal(18,4) NULL COMMENT '平时段放电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `discharged_energy_valley` decimal(18,4) NULL COMMENT '谷时段放电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_daily` MODIFY COLUMN `synced_at` datetime NOT NULL COMMENT '最后同步时间';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `id` bigint NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `station_local_id` bigint NOT NULL COMMENT '本地储能站点ID';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `station_id` bigint NOT NULL COMMENT 'eMind平台站点ID';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `station_name` varchar(255) NOT NULL COMMENT '站点名称';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `platform_name` varchar(64) NOT NULL COMMENT '平台名称';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `income_sum` decimal(18,4) NULL COMMENT '累计收益（元）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `income_today` decimal(18,4) NULL COMMENT '当日收益（元）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `charged_energy_sum` decimal(18,4) NULL COMMENT '累计充电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `discharged_energy_sum` decimal(18,4) NULL COMMENT '累计放电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `charged_energy_today` decimal(18,4) NULL COMMENT '当日充电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `discharged_energy_today` decimal(18,4) NULL COMMENT '当日放电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `real_time_power` decimal(18,4) NULL COMMENT '实时功率（kW）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `surplus_energy` decimal(18,4) NULL COMMENT '剩余电量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `soc` decimal(8,4) NULL COMMENT '电池荷电状态（%）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `capacity` decimal(18,4) NULL COMMENT '设计容量（kWh）';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `elink_total` int NULL DEFAULT 0 COMMENT '能源链总数';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `elink_online` int NULL DEFAULT 0 COMMENT '在线能源链数量';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `eblock_total` int NULL DEFAULT 0 COMMENT '能量块总数';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `eblock_online` int NULL DEFAULT 0 COMMENT '在线能量块数量';
|
ALTER TABLE `charging_pile_other`.`t_emind_dashboard_snapshot` MODIFY COLUMN `synced_at` datetime NOT NULL COMMENT '最后同步时间';
|
ALTER TABLE `charging_pile_other`.`t_emind_station` MODIFY COLUMN `platform_name` varchar(100) NOT NULL DEFAULT '利普芯' COMMENT '平台名称';
|
ALTER TABLE `charging_pile_other`.`t_emind_station` MODIFY COLUMN `source_type` tinyint NOT NULL DEFAULT 1 COMMENT '数据来源：1远程同步，2手工录入';
|
ALTER TABLE `charging_pile_other`.`t_emind_station` MODIFY COLUMN `management_deleted` tinyint NOT NULL DEFAULT 0 COMMENT '管理端删除状态：0正常，1删除';
|
ALTER TABLE `charging_pile_other`.`t_general_screen_content` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_other`.`t_general_screen_content` MODIFY COLUMN `update_time` datetime NULL COMMENT '最后修改时间';
|
ALTER TABLE `charging_pile_other`.`t_region` MODIFY COLUMN `code` varchar(100) NULL COMMENT '行政区划编码';
|
ALTER TABLE `charging_pile_other`.`t_region` MODIFY COLUMN `citycode` varchar(100) NULL COMMENT '城市编码';
|
ALTER TABLE `charging_pile_other`.`t_screen_carport` MODIFY COLUMN `id` int NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_other`.`t_screen_content` MODIFY COLUMN `id` int NOT NULL COMMENT '主键ID';
|
ALTER TABLE `charging_pile_service`.`t_accounting_strategy_detail` MODIFY COLUMN `create_time` datetime NULL COMMENT '创建时间';
|
ALTER TABLE `charging_pile_service`.`t_accounting_strategy_detail` MODIFY COLUMN `del_flag` int NULL DEFAULT 0 COMMENT '删除状态：0正常，1删除';
|
