725 lines
38 KiB
SQL
725 lines
38 KiB
SQL
/*
|
||
Navicat Premium Dump SQL
|
||
|
||
Source Server : 10.10.14.204
|
||
Source Server Type : MySQL
|
||
Source Server Version : 50799 (5.7.99)
|
||
Source Host : 10.10.14.204:9030
|
||
Source Schema : yltcharge
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 50799 (5.7.99)
|
||
File Encoding : 65001
|
||
|
||
Date: 20/01/2026 11:24:55
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_account_recharge
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_account_recharge`;
|
||
CREATE TABLE `t_account_recharge` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`prid` text NOT NULL COMMENT 'prid',
|
||
`order_id` text NULL COMMENT 'order_id',
|
||
`outtradeno` text NULL COMMENT 'outtradeno',
|
||
`pay_time` datetimev2 NULL COMMENT 'pay_time',
|
||
`pay_money` double NULL DEFAULT NULL COMMENT 'pay_money',
|
||
`refund_time` text NULL COMMENT 'refund_time',
|
||
`refund_money` double NULL DEFAULT NULL COMMENT 'refund_money',
|
||
`refund_state` text NULL COMMENT 'refund_state',
|
||
`order_time` text NULL COMMENT 'order_time',
|
||
`pay_xml` text NULL COMMENT 'pay_xml',
|
||
`refund_xml` text NULL COMMENT 'refund_xml',
|
||
`check_xml` text NULL COMMENT 'check_xml',
|
||
`pay_state` text NULL COMMENT 'pay_state',
|
||
`pay_type` text NULL COMMENT 'pay_type',
|
||
`phone` text NULL COMMENT 'phone',
|
||
`check_time` text NULL COMMENT 'check_time',
|
||
`user_id` bigint NULL DEFAULT NULL COMMENT 'user_id',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`donate_money` double NULL DEFAULT NULL COMMENT 'donate_money',
|
||
`memo` text NULL COMMENT 'memo',
|
||
`refund_memo` text NULL COMMENT 'refund_memo',
|
||
`refund_outtradno` text NULL COMMENT 'refund_outtradno',
|
||
`refund_image` text NULL COMMENT 'refund_image',
|
||
`refund_operer` text NULL COMMENT 'refund_operer',
|
||
`rechage_operer` text NULL COMMENT 'rechage_operer',
|
||
`refund_reason` text NULL COMMENT 'refund_reason',
|
||
`vip` int NULL DEFAULT NULL COMMENT 'vip',
|
||
`meal_id` text NULL COMMENT 'meal_id',
|
||
`refund_apply_time` text NULL COMMENT 'refund_apply_time',
|
||
`pay_method` int NULL DEFAULT NULL COMMENT 'pay_method'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_account_recharge` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_account_water
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_account_water`;
|
||
CREATE TABLE `t_account_water` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`cash` decimalv3 NULL COMMENT 'cash',
|
||
`phone` text NULL COMMENT 'phone',
|
||
`txt_desc` text NULL COMMENT 'txt_desc',
|
||
`sign_msg` text NULL COMMENT 'sign_msg',
|
||
`reason` text NULL COMMENT 'reason',
|
||
`sign` tinyint NULL DEFAULT NULL COMMENT 'sign',
|
||
`type` text NULL COMMENT 'type',
|
||
`order_id` text NULL COMMENT 'order_id',
|
||
`treatment` text NULL COMMENT 'treatment',
|
||
`user_id` bigint NULL DEFAULT NULL COMMENT 'user_id',
|
||
`pay_status` text NULL COMMENT 'pay_status',
|
||
`pay_method` text NOT NULL COMMENT 'pay_method',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`pre_balance` decimalv3 NOT NULL COMMENT 'pre_balance',
|
||
`bef_balance` decimalv3 NULL COMMENT 'bef_balance',
|
||
`memo` text NULL COMMENT 'memo',
|
||
`donate_money` decimalv3 NULL COMMENT 'donate_money',
|
||
`ua_balance` decimalv3 NULL COMMENT 'ua_balance',
|
||
`to_user_id` bigint NULL DEFAULT NULL COMMENT 'to_user_id'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_account_water` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_car
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_car`;
|
||
CREATE TABLE `t_car` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`car_plate_no` text NOT NULL COMMENT 'car_plate_no',
|
||
`car_sn` text NULL COMMENT 'car_sn',
|
||
`car_brand_name` text NULL COMMENT 'car_brand_name',
|
||
`car_model_name` text NULL COMMENT 'car_model_name',
|
||
`car_vin` text NULL COMMENT 'car_vin',
|
||
`car_engine` text NULL COMMENT 'car_engine',
|
||
`car_type` tinyint NULL DEFAULT NULL COMMENT 'car_type',
|
||
`car_owner_company_id` bigint NULL DEFAULT NULL COMMENT 'car_owner_company_id',
|
||
`car_business` tinyint NOT NULL COMMENT 'car_business',
|
||
`car_bus_path` text NOT NULL COMMENT 'car_bus_path',
|
||
`is_auto_charge` tinyint NULL DEFAULT NULL COMMENT 'is_auto_charge',
|
||
`user_id` bigint NULL DEFAULT NULL COMMENT 'user_id',
|
||
`user_card_no` text NULL COMMENT 'user_card_no',
|
||
`is_disable` tinyint NULL DEFAULT NULL COMMENT 'is_disable',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`operator_id` text NULL COMMENT 'operator_id'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_car` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_company
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_company`;
|
||
CREATE TABLE `t_company` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`company_no` text NOT NULL COMMENT 'company_no',
|
||
`company_type` tinyint NULL DEFAULT NULL COMMENT 'company_type',
|
||
`company_name` text NOT NULL COMMENT 'company_name',
|
||
`company_state` text NOT NULL COMMENT 'company_state',
|
||
`company_logo` text NULL COMMENT 'company_logo',
|
||
`company_admin_phone` text NULL COMMENT 'company_admin_phone',
|
||
`company_admin_name` text NULL COMMENT 'company_admin_name',
|
||
`balance_remind` double NULL DEFAULT NULL COMMENT 'balance_remind',
|
||
`balance_remind_phone` text NULL COMMENT 'balance_remind_phone',
|
||
`agent_id` bigint NULL DEFAULT NULL COMMENT 'agent_id',
|
||
`station_set_type` tinyint NULL DEFAULT NULL COMMENT 'station_set_type',
|
||
`specified_range` tinyint NULL DEFAULT NULL COMMENT 'specified_range',
|
||
`specified_operator_ids` text NULL COMMENT 'specified_operator_ids',
|
||
`is_company_discount` tinyint NULL DEFAULT NULL COMMENT 'is_company_discount',
|
||
`is_overlay_coupons` tinyint NULL DEFAULT NULL COMMENT 'is_overlay_coupons',
|
||
`station_ids` text NULL COMMENT 'station_ids',
|
||
`no_discount_stationids` text NULL COMMENT 'no_discount_stationids',
|
||
`remark` text NULL COMMENT '备注',
|
||
`invoice_eligible` text NULL COMMENT 'invoice_eligible',
|
||
`refuse_invoice_tip` text NULL COMMENT 'refuse_invoice_tip',
|
||
`is_share_master` tinyint NULL DEFAULT NULL COMMENT 'is_share_master',
|
||
`settlement_method` tinyint NULL DEFAULT NULL COMMENT 'settlement_method',
|
||
`charge_discount_type` tinyint NULL DEFAULT NULL COMMENT 'charge_discount_type',
|
||
`charge_discount` double NULL DEFAULT NULL COMMENT 'charge_discount',
|
||
`settle_status` tinyint NULL DEFAULT NULL COMMENT 'settle_status',
|
||
`charge_unit_service` decimalv3 NULL COMMENT 'charge_unit_service',
|
||
`charge_unit_electric` decimalv3 NULL COMMENT 'charge_unit_electric',
|
||
`is_custom_price` int NULL DEFAULT NULL COMMENT 'is_custom_price',
|
||
`company_order_permission` tinyint NULL DEFAULT NULL COMMENT 'company_order_permission',
|
||
`open_station_ids` text NULL COMMENT 'open_station_ids',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`minimum_recharge_amount` decimalv3 NULL COMMENT 'minimum_recharge_amount',
|
||
`inner_person` text NULL COMMENT 'inner_person'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_company` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_company_info_value
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_company_info_value`;
|
||
CREATE TABLE `t_company_info_value` (
|
||
`id` varchar(255) NOT NULL COMMENT '主键ID',
|
||
`info_value` text NULL COMMENT '信息值',
|
||
`type_id` text NULL COMMENT '类型ID',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`remark` text NULL COMMENT '备注',
|
||
`renzheng_flag` int NULL DEFAULT NULL COMMENT '认证标识：0-未认证，1-已认证'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_company_info_value` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_connector
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_connector`;
|
||
CREATE TABLE `t_connector` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`equipment_id` bigint NOT NULL COMMENT 'equipment_id',
|
||
`connector_sn` text NOT NULL COMMENT 'connector_sn',
|
||
`connector_short_sn` text NOT NULL COMMENT 'connector_short_sn',
|
||
`connector_no` tinyint NULL DEFAULT NULL COMMENT 'connector_no',
|
||
`connector_name` text NULL COMMENT 'connector_name',
|
||
`connector_type` tinyint NOT NULL COMMENT 'connector_type',
|
||
`voltage_upper_limits` smallint NOT NULL COMMENT 'voltage_upper_limits',
|
||
`voltage_lower_limits` smallint NOT NULL COMMENT 'voltage_lower_limits',
|
||
`current` smallint NOT NULL COMMENT 'current',
|
||
`power` double NOT NULL COMMENT 'power',
|
||
`parkno` text NULL COMMENT 'parkno',
|
||
`appointment_id` bigint NULL DEFAULT NULL COMMENT 'appointment_id',
|
||
`appointment_user_id` bigint NULL DEFAULT NULL COMMENT 'appointment_user_id',
|
||
`open_lock_user_id` bigint NULL DEFAULT NULL COMMENT 'open_lock_user_id',
|
||
`detection_type` tinyint NULL DEFAULT NULL COMMENT 'detection_type',
|
||
`is_ground_lock` tinyint NULL DEFAULT NULL COMMENT 'is_ground_lock',
|
||
`is_ground_lock_msg` text NULL COMMENT 'is_ground_lock_msg',
|
||
`is_geomagnetic` tinyint NULL DEFAULT NULL COMMENT 'is_geomagnetic',
|
||
`is_geomagnetic_msg` text NULL COMMENT 'is_geomagnetic_msg',
|
||
`is_appointment` tinyint NULL DEFAULT NULL COMMENT 'is_appointment',
|
||
`is_appointment_msg` text NULL COMMENT 'is_appointment_msg',
|
||
`auto_open_lock_time` datetimev2 NULL COMMENT 'auto_open_lock_time',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_connector` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_equipment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_equipment`;
|
||
CREATE TABLE `t_equipment` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`station_id` bigint NULL DEFAULT NULL COMMENT 'station_id',
|
||
`agreement_id` tinyint NULL DEFAULT NULL COMMENT 'agreement_id',
|
||
`equipment_name` text NULL COMMENT 'equipment_name',
|
||
`equipment_sn` text NOT NULL COMMENT 'equipment_sn',
|
||
`equipment_short_sn` text NOT NULL COMMENT 'equipment_short_sn',
|
||
`equipment_no` bigint NULL DEFAULT NULL COMMENT 'equipment_no',
|
||
`manufacturer_id` text NULL COMMENT 'manufacturer_id',
|
||
`manufacturer_sn` text NULL COMMENT 'manufacturer_sn',
|
||
`manufacturer_name` text NULL COMMENT 'manufacturer_name',
|
||
`equipment_model` text NULL COMMENT 'equipment_model',
|
||
`production_date` datetimev2 NULL COMMENT 'production_date',
|
||
`equipment_type` tinyint NOT NULL COMMENT 'equipment_type',
|
||
`equipment_type_msg` text NULL COMMENT 'equipment_type_msg',
|
||
`equipment_lng` double NULL DEFAULT NULL COMMENT 'equipment_lng',
|
||
`equipment_lat` double NULL DEFAULT NULL COMMENT 'equipment_lat',
|
||
`connector_count` tinyint NULL DEFAULT NULL COMMENT 'connector_count',
|
||
`power` double NOT NULL COMMENT 'power',
|
||
`national_standard` tinyint NULL DEFAULT NULL COMMENT 'national_standard',
|
||
`national_standard_msg` text NULL COMMENT 'national_standard_msg',
|
||
`status` tinyint NULL DEFAULT NULL COMMENT 'status',
|
||
`equipment_business_type` tinyint NULL DEFAULT NULL COMMENT 'equipment_business_type',
|
||
`equipment_business_type_msg` text NULL COMMENT 'equipment_business_type_msg',
|
||
`is_use_card` tinyint NOT NULL COMMENT 'is_use_card',
|
||
`is_use_card_msg` text NULL COMMENT 'is_use_card_msg',
|
||
`charge_host_esn` text NULL COMMENT 'charge_host_esn',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`aux_power` tinyint NULL DEFAULT NULL COMMENT 'aux_power',
|
||
`app_show` tinyint NULL DEFAULT NULL COMMENT 'app_show'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_equipment` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_equipment_charge_order
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_equipment_charge_order`;
|
||
CREATE TABLE `t_equipment_charge_order` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`user_id` bigint NOT NULL COMMENT 'user_id',
|
||
`company_id` bigint NULL DEFAULT NULL COMMENT 'company_id',
|
||
`station_id` bigint NULL DEFAULT NULL COMMENT 'station_id',
|
||
`equipment_id` bigint NOT NULL COMMENT 'equipment_id',
|
||
`connector_id` bigint NOT NULL COMMENT 'connector_id',
|
||
`user_card_no` text NULL COMMENT 'user_card_no',
|
||
`state` tinyint NULL DEFAULT NULL COMMENT 'state',
|
||
`operate_state` tinyint NULL DEFAULT NULL COMMENT 'operate_state',
|
||
`order_no` text NOT NULL COMMENT 'order_no',
|
||
`platform_order_no` text NULL COMMENT 'platform_order_no',
|
||
`platform_sale_type` tinyint NULL DEFAULT NULL COMMENT 'platform_sale_type',
|
||
`platform_driver_id` text NULL COMMENT 'platform_driver_id',
|
||
`platform_phone` text NULL COMMENT 'platform_phone',
|
||
`charging_amt` decimalv3 NULL COMMENT 'charging_amt',
|
||
`order_type` tinyint NULL DEFAULT NULL COMMENT 'order_type',
|
||
`order_time` datetimev2 NULL COMMENT 'order_time',
|
||
`charge_begin_time` datetimev2 NULL COMMENT 'charge_begin_time',
|
||
`charge_end_time` datetimev2 NULL COMMENT 'charge_end_time',
|
||
`charge_begin_degree` double NULL DEFAULT NULL COMMENT 'charge_begin_degree',
|
||
`charge_end_degree` double NULL DEFAULT NULL COMMENT 'charge_end_degree',
|
||
`charge_degree` double NULL DEFAULT NULL COMMENT 'charge_degree',
|
||
`charge_ah` double NULL DEFAULT NULL COMMENT 'charge_ah',
|
||
`charge_times_degree` text NULL COMMENT 'charge_times_degree',
|
||
`charge_begin_soc` int NULL DEFAULT NULL COMMENT 'charge_begin_soc',
|
||
`charge_end_soc` int NULL DEFAULT NULL COMMENT 'charge_end_soc',
|
||
`charge_cur_soc` int NULL DEFAULT NULL COMMENT 'charge_cur_soc',
|
||
`charge_duration` int NULL DEFAULT NULL COMMENT 'charge_duration',
|
||
`charge_settle_type` tinyint NULL DEFAULT NULL COMMENT 'charge_settle_type',
|
||
`charge_unit_price` decimalv3 NULL COMMENT 'charge_unit_price',
|
||
`charge_unit_cost` decimalv3 NULL COMMENT 'charge_unit_cost',
|
||
`charge_unit_service_fee` decimalv3 NULL COMMENT 'charge_unit_service_fee',
|
||
`receivable_electric_fee` decimalv3 NULL COMMENT 'receivable_electric_fee',
|
||
`receivable_service_fee` decimalv3 NULL COMMENT 'receivable_service_fee',
|
||
`receivable_total_fee` decimalv3 NULL COMMENT 'receivable_total_fee',
|
||
`charge_elecfee_amount` decimalv3 NULL COMMENT 'charge_elecfee_amount',
|
||
`charge_elecfee_cost_amount` decimalv3 NULL COMMENT 'charge_elecfee_cost_amount',
|
||
`charge_service_amount` decimalv3 NULL COMMENT 'charge_service_amount',
|
||
`actual_pay_amount` decimalv3 NULL COMMENT 'actual_pay_amount',
|
||
`pay_order_no` text NULL COMMENT 'pay_order_no',
|
||
`pay_amount` decimalv3 NULL COMMENT 'pay_amount',
|
||
`pay_method` tinyint NULL DEFAULT NULL COMMENT 'pay_method',
|
||
`pay_status` tinyint NULL DEFAULT NULL COMMENT 'pay_status',
|
||
`pay_time` datetimev2 NULL COMMENT 'pay_time',
|
||
`user_coupon_id` bigint NULL DEFAULT NULL COMMENT 'user_coupon_id',
|
||
`coupon_name` text NULL COMMENT 'coupon_name',
|
||
`coupon_type` tinyint NULL DEFAULT NULL COMMENT 'coupon_type',
|
||
`coupon_amount` decimalv3 NULL COMMENT 'coupon_amount',
|
||
`elecfee_coupon_amount` decimalv3 NULL COMMENT 'elecfee_coupon_amount',
|
||
`servicefee_coupon_amount` decimalv3 NULL COMMENT 'servicefee_coupon_amount',
|
||
`invoice_id` bigint NULL DEFAULT NULL COMMENT 'invoice_id',
|
||
`invoice_fee` decimalv3 NULL COMMENT 'invoice_fee',
|
||
`ticket_status` tinyint NULL DEFAULT NULL COMMENT 'ticket_status',
|
||
`activity_electric_fee` decimalv3 NULL COMMENT 'activity_electric_fee',
|
||
`activity_service_fee` decimalv3 NULL COMMENT 'activity_service_fee',
|
||
`charge_plate_no` text NULL COMMENT 'charge_plate_no',
|
||
`charge_vin` text NULL COMMENT 'charge_vin',
|
||
`charge_strategy` text NULL COMMENT 'charge_strategy',
|
||
`charge_strategy_param` text NULL COMMENT 'charge_strategy_param',
|
||
`operator_id` bigint NULL DEFAULT NULL COMMENT 'operator_id',
|
||
`operator_income` decimalv3 NULL COMMENT 'operator_income',
|
||
`plat_service_fee` decimalv3 NULL COMMENT 'plat_service_fee',
|
||
`charge_discount_type` tinyint NULL DEFAULT NULL COMMENT 'charge_discount_type',
|
||
`settle_electric_fee` decimalv3 NULL COMMENT 'settle_electric_fee',
|
||
`settle_service_fee` decimalv3 NULL COMMENT 'settle_service_fee',
|
||
`settle_fee` decimalv3 NULL COMMENT 'settle_fee',
|
||
`settle_method` tinyint NULL DEFAULT NULL COMMENT 'settle_method',
|
||
`settle_coupon_amount` decimalv3 NULL COMMENT 'settle_coupon_amount',
|
||
`settle_coupon_electric_fee` decimalv3 NULL COMMENT 'settle_coupon_electric_fee',
|
||
`settle_coupon_service_fee` decimalv3 NULL COMMENT 'settle_coupon_service_fee',
|
||
`settle_status` tinyint NULL DEFAULT NULL COMMENT 'settle_status',
|
||
`cancel_type` int NULL DEFAULT NULL COMMENT 'cancel_type',
|
||
`cancel_code` int NULL DEFAULT NULL COMMENT 'cancel_code',
|
||
`cancel_msg` text NULL COMMENT 'cancel_msg',
|
||
`cancel_time` datetimev2 NULL COMMENT 'cancel_time',
|
||
`finish_type` int NULL DEFAULT NULL COMMENT 'finish_type',
|
||
`finish_code` int NULL DEFAULT NULL COMMENT 'finish_code',
|
||
`finish_msg` text NULL COMMENT 'finish_msg',
|
||
`finish_time` datetimev2 NULL COMMENT 'finish_time',
|
||
`boot_mode` tinyint NULL DEFAULT NULL COMMENT 'boot_mode',
|
||
`settlement_type` tinyint NULL DEFAULT NULL COMMENT 'settlement_type',
|
||
`is_parking_coupon` tinyint NULL DEFAULT NULL COMMENT 'is_parking_coupon',
|
||
`control_source` text NULL COMMENT 'control_source',
|
||
`exception_flag` tinyint NULL DEFAULT NULL COMMENT 'exception_flag',
|
||
`exception_msg` text NULL COMMENT 'exception_msg',
|
||
`report_time` datetimev2 NULL COMMENT 'report_time',
|
||
`com_service_fee` decimalv3 NULL COMMENT 'com_service_fee',
|
||
`com_electric_fee` decimalv3 NULL COMMENT 'com_electric_fee',
|
||
`com_total_fee` decimalv3 NULL COMMENT 'com_total_fee',
|
||
`com_charge_discount_type` tinyint NULL DEFAULT NULL COMMENT 'com_charge_discount_type',
|
||
`com_charge_discount` double NULL DEFAULT NULL COMMENT 'com_charge_discount',
|
||
`has_shallow_report` tinyint NULL DEFAULT NULL COMMENT 'has_shallow_report',
|
||
`has_deep_report` tinyint NULL DEFAULT NULL COMMENT 'has_deep_report',
|
||
`is_exception` tinyint NULL DEFAULT NULL COMMENT 'is_exception',
|
||
`shallow_report_is_received` tinyint NULL DEFAULT NULL COMMENT 'shallow_report_is_received',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`charge_market_id` bigint NULL DEFAULT NULL COMMENT 'charge_market_id',
|
||
`coupon_total_amount` decimalv3 NOT NULL COMMENT 'coupon_total_amount',
|
||
`coupon_service_total_amount` decimalv3 NOT NULL COMMENT 'coupon_service_total_amount',
|
||
`coupon_elecfee_total_amount` decimalv3 NOT NULL COMMENT 'coupon_elecfee_total_amount',
|
||
`activity_name` text NOT NULL COMMENT 'activity_name',
|
||
`activity_total_fee` decimalv3 NOT NULL COMMENT 'activity_total_fee',
|
||
`company_activity_id` bigint NULL DEFAULT NULL COMMENT 'company_activity_id',
|
||
`company_activity_name` text NULL COMMENT 'company_activity_name',
|
||
`company_activity_total_fee` decimalv3 NOT NULL COMMENT 'company_activity_total_fee',
|
||
`company_activity_service_fee` decimalv3 NOT NULL COMMENT 'company_activity_service_fee',
|
||
`company_activity_electric_fee` decimalv3 NOT NULL COMMENT 'company_activity_electric_fee',
|
||
`subsidy_degree` decimalv3 NOT NULL COMMENT 'subsidy_degree',
|
||
`subsidy_fee` decimalv3 NOT NULL COMMENT 'subsidy_fee',
|
||
`special_channel_order_source` tinyint NULL DEFAULT NULL COMMENT 'special_channel_order_source'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_equipment_charge_order` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_equipment_charge_order_detail
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_equipment_charge_order_detail`;
|
||
CREATE TABLE `t_equipment_charge_order_detail` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`order_no` text NULL COMMENT 'order_no',
|
||
`charge_degree` double NULL DEFAULT NULL COMMENT 'charge_degree',
|
||
`service_fee` decimalv3 NULL COMMENT 'service_fee',
|
||
`electric_fee` decimalv3 NULL COMMENT 'electric_fee',
|
||
`cost_fee` decimalv3 NULL COMMENT 'cost_fee',
|
||
`service_fee_unit_price` decimalv3 NULL COMMENT 'service_fee_unit_price',
|
||
`electric_fee_unit_price` decimalv3 NULL COMMENT 'electric_fee_unit_price',
|
||
`cost_fee_unit_price` decimalv3 NULL COMMENT 'cost_fee_unit_price',
|
||
`activity_service_fee` decimalv3 NULL COMMENT 'activity_service_fee',
|
||
`activity_electric_fee` decimalv3 NULL COMMENT 'activity_electric_fee',
|
||
`charge_startr_time` datetimev2 NULL COMMENT 'charge_startr_time',
|
||
`charge_end_time` datetimev2 NULL COMMENT 'charge_end_time',
|
||
`charge_meal_electric_fee` double NULL DEFAULT NULL COMMENT 'charge_meal_electric_fee',
|
||
`charge_meal_service_fee` double NULL DEFAULT NULL COMMENT 'charge_meal_service_fee',
|
||
`charge_meal_total_fee` double NULL DEFAULT NULL COMMENT 'charge_meal_total_fee',
|
||
`electric_card_use_dgree` double NULL DEFAULT NULL COMMENT 'electric_card_use_dgree',
|
||
`check_electric_unit_price` double NULL DEFAULT NULL COMMENT 'check_electric_unit_price',
|
||
`check_service_unit_price` double NULL DEFAULT NULL COMMENT 'check_service_unit_price',
|
||
`time_flag` tinyint NULL DEFAULT NULL COMMENT 'time_flag',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`detail_more` text NULL COMMENT 'detail_more'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_equipment_charge_order_detail` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_ext_hurry_quit
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_ext_hurry_quit`;
|
||
CREATE TABLE `t_ext_hurry_quit` (
|
||
`id` int NOT NULL COMMENT '主键ID',
|
||
`order_no` text NOT NULL COMMENT 'order_no',
|
||
`telephone` text NOT NULL COMMENT 'telephone',
|
||
`user_id` int NOT NULL COMMENT 'user_id',
|
||
`message1` text NOT NULL COMMENT 'message1',
|
||
`message2` text NULL COMMENT 'message2',
|
||
`create_time` datetimev2 NOT NULL COMMENT '创建时间',
|
||
`station_id` int NOT NULL COMMENT 'station_id',
|
||
`equipment_id` int NOT NULL COMMENT 'equipment_id',
|
||
`connector_id` int NOT NULL COMMENT 'connector_id',
|
||
`flag` int NOT NULL COMMENT 'flag',
|
||
`close_time` datetimev2 NULL COMMENT 'close_time',
|
||
`finish_time` datetimev2 NULL COMMENT 'finish_time',
|
||
`minutesDifference` int NULL DEFAULT NULL COMMENT 'minutesDifference',
|
||
`reduce_money` decimalv3 NULL COMMENT 'reduce_money',
|
||
`beforeBalance` decimalv3 NULL COMMENT 'beforeBalance',
|
||
`afterBalance` decimalv3 NULL COMMENT 'afterBalance',
|
||
`fee_station` int NOT NULL COMMENT 'fee_station',
|
||
`manual_count` int NOT NULL COMMENT 'manual_count',
|
||
`last_manual_time` datetimev2 NULL COMMENT 'last_manual_time',
|
||
`last_manual_message` text NULL COMMENT 'last_manual_message',
|
||
`person_id` text NULL COMMENT 'person_id',
|
||
`refund_status` int NULL DEFAULT NULL COMMENT 'refund_status',
|
||
`refund_time` datetimev2 NULL COMMENT 'refund_time',
|
||
`refund_person_id` text NULL COMMENT 'refund_person_id',
|
||
`refund_person_name` text NULL COMMENT 'refund_person_name',
|
||
`refund_amount` decimalv3 NULL COMMENT 'refund_amount',
|
||
`refund_type` text NULL COMMENT 'refund_type',
|
||
`unplug_time` datetimev2 NULL COMMENT 'unplug_time'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_ext_hurry_quit` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_operator
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_operator`;
|
||
CREATE TABLE `t_operator` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`operator_type` tinyint NULL DEFAULT NULL COMMENT 'operator_type',
|
||
`operator_name` text NULL COMMENT 'operator_name',
|
||
`operator_short_name` text NULL COMMENT 'operator_short_name',
|
||
`operator_short_code` text NULL COMMENT 'operator_short_code',
|
||
`operator_code` text NOT NULL COMMENT 'operator_code',
|
||
`operator_logo_picture` text NULL COMMENT 'operator_logo_picture',
|
||
`operator_tel_1` text NULL COMMENT 'operator_tel_1',
|
||
`operator_admin_name` text NULL COMMENT 'operator_admin_name',
|
||
`operator_tel_2` text NULL COMMENT 'operator_tel_2',
|
||
`operator_state` text NULL COMMENT 'operator_state',
|
||
`settle_bank_name` text NULL COMMENT 'settle_bank_name',
|
||
`settle_bank_area` text NULL COMMENT 'settle_bank_area',
|
||
`settle_bank_account` text NULL COMMENT 'settle_bank_account',
|
||
`settle_bank_account_name` text NULL COMMENT 'settle_bank_account_name',
|
||
`auto_create_admin_flag` tinyint NULL DEFAULT NULL COMMENT 'auto_create_admin_flag',
|
||
`operator_login_url` text NULL COMMENT 'operator_login_url',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`create_user_id` text NULL COMMENT 'create_user_id',
|
||
`create_user_name` text NULL COMMENT 'create_user_name',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`update_user_id` text NULL COMMENT 'update_user_id',
|
||
`update_user_name` text NULL COMMENT 'update_user_name',
|
||
`update_remark` text NULL COMMENT 'update_remark',
|
||
`wallet_status` tinyint NULL DEFAULT NULL COMMENT 'wallet_status'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_operator` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_station
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_station`;
|
||
CREATE TABLE `t_station` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`station_sn` text NOT NULL COMMENT 'station_sn',
|
||
`operator_id` bigint NOT NULL COMMENT 'operator_id',
|
||
`equioment_owner_id` text NOT NULL COMMENT 'equioment_owner_id',
|
||
`station_name` text NOT NULL COMMENT 'station_name',
|
||
`country_code` text NOT NULL COMMENT 'country_code',
|
||
`region_id` bigint NULL DEFAULT NULL COMMENT 'region_id',
|
||
`region_code` text NOT NULL COMMENT 'region_code',
|
||
`regional_name` text NULL COMMENT 'regional_name',
|
||
`regional_code` text NULL COMMENT 'regional_code',
|
||
`address` text NOT NULL COMMENT 'address',
|
||
`station_tel` text NULL COMMENT 'station_tel',
|
||
`service_tel` text NOT NULL COMMENT 'service_tel',
|
||
`station_type` smallint NOT NULL COMMENT 'station_type',
|
||
`station_type_msg` text NULL COMMENT 'station_type_msg',
|
||
`station_business_type` tinyint NULL DEFAULT NULL COMMENT 'station_business_type',
|
||
`station_business_type_msg` text NULL COMMENT 'station_business_type_msg',
|
||
`station_status` smallint NOT NULL COMMENT 'station_status',
|
||
`station_status_msg` text NULL COMMENT 'station_status_msg',
|
||
`park_nums` smallint NOT NULL COMMENT 'park_nums',
|
||
`station_lng` double NOT NULL COMMENT 'station_lng',
|
||
`station_lat` double NOT NULL COMMENT 'station_lat',
|
||
`site_guide` text NULL COMMENT 'site_guide',
|
||
`construction` smallint NOT NULL COMMENT 'construction',
|
||
`construction_msg` text NULL COMMENT 'construction_msg',
|
||
`pictures` text NULL COMMENT 'pictures',
|
||
`match_cars` text NULL COMMENT 'match_cars',
|
||
`park_info` text NULL COMMENT 'park_info',
|
||
`business_start_time` smallint NULL DEFAULT NULL COMMENT 'business_start_time',
|
||
`business_end_time` smallint NULL DEFAULT NULL COMMENT 'business_end_time',
|
||
`electricity_fee` text NULL COMMENT 'electricity_fee',
|
||
`service_fee` text NULL COMMENT 'service_fee',
|
||
`is_park_fee` tinyint NULL DEFAULT NULL COMMENT 'is_park_fee',
|
||
`park_fee` text NULL COMMENT 'park_fee',
|
||
`payment` tinyint NULL DEFAULT NULL COMMENT 'payment',
|
||
`payment_msg` text NULL COMMENT 'payment_msg',
|
||
`support_order` tinyint NULL DEFAULT NULL COMMENT 'support_order',
|
||
`support_order_msg` text NULL COMMENT 'support_order_msg',
|
||
`service_item` text NULL COMMENT 'service_item',
|
||
`service_item_image_url` text NULL COMMENT 'service_item_image_url',
|
||
`service_item_msg` text NULL COMMENT 'service_item_msg',
|
||
`station_location_type` tinyint NULL DEFAULT NULL COMMENT 'station_location_type',
|
||
`station_location_type_msg` text NULL COMMENT 'station_location_type_msg',
|
||
`station_charge_type` tinyint NULL DEFAULT NULL COMMENT 'station_charge_type',
|
||
`station_charge_type_msg` text NULL COMMENT 'station_charge_type_msg',
|
||
`station_power` text NULL COMMENT 'station_power',
|
||
`station_voltage` text NULL COMMENT 'station_voltage',
|
||
`station_current` text NULL COMMENT 'station_current',
|
||
`is_open` tinyint NULL DEFAULT NULL COMMENT 'is_open',
|
||
`is_open_msg` text NULL COMMENT 'is_open_msg',
|
||
`is_display` tinyint NULL DEFAULT NULL COMMENT 'is_display',
|
||
`is_display_msg` text NULL COMMENT 'is_display_msg',
|
||
`sharing_code` text NULL COMMENT 'sharing_code',
|
||
`sharing_applet_picture` text NULL COMMENT 'sharing_applet_picture',
|
||
`theme_picture` text NULL COMMENT 'theme_picture',
|
||
`is_barrier_flag` tinyint NULL DEFAULT NULL COMMENT 'is_barrier_flag',
|
||
`is_barrier_flag_msg` text NULL COMMENT 'is_barrier_flag_msg',
|
||
`charge_settle_type` tinyint NULL DEFAULT NULL COMMENT 'charge_settle_type',
|
||
`charge_settle_type_msg` text NULL COMMENT 'charge_settle_type_msg',
|
||
`fast_connector_nums` int NULL DEFAULT NULL COMMENT 'fast_connector_nums',
|
||
`slow_connector_nums` int NULL DEFAULT NULL COMMENT 'slow_connector_nums',
|
||
`transformer_capacity` double NULL DEFAULT NULL COMMENT 'transformer_capacity',
|
||
`installed_capacity` double NULL DEFAULT NULL COMMENT 'installed_capacity',
|
||
`remark` text NULL COMMENT '备注',
|
||
`record_unique_no` text NOT NULL COMMENT 'record_unique_no',
|
||
`equipment_owner_name` text NOT NULL COMMENT 'equipment_owner_name',
|
||
`supply_type` tinyint NOT NULL COMMENT 'supply_type',
|
||
`resident_no` text NOT NULL COMMENT 'resident_no',
|
||
`watt_hour_meter_no` text NOT NULL COMMENT 'watt_hour_meter_no',
|
||
`forward_power` text NOT NULL COMMENT 'forward_power',
|
||
`operation_date` datetimev2 NOT NULL COMMENT 'operation_date',
|
||
`charge_replace_type` tinyint NOT NULL COMMENT 'charge_replace_type',
|
||
`is_hlht` tinyint NOT NULL COMMENT 'is_hlht',
|
||
`is_subsidy` tinyint NOT NULL COMMENT 'is_subsidy',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`area_code_countryside` text NULL COMMENT 'area_code_countryside',
|
||
`business_expand_type` tinyint NULL DEFAULT NULL COMMENT 'business_expand_type',
|
||
`capacity` double NOT NULL COMMENT 'capacity',
|
||
`video_monitor` tinyint NULL DEFAULT NULL COMMENT 'video_monitor',
|
||
`electricity_type` tinyint NULL DEFAULT NULL COMMENT 'electricity_type',
|
||
`receive_shop` tinyint NOT NULL COMMENT 'receive_shop'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_station` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_time_day
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_time_day`;
|
||
CREATE TABLE `t_time_day` (
|
||
`id` bigint NOT NULL,
|
||
`create_time` datetimev2 NULL,
|
||
`update_time` datetimev2 NULL,
|
||
`time_fq` varchar(24) NULL DEFAULT NULL,
|
||
`teme_ve` varchar(25) NULL DEFAULT NULL
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_time_day` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_user`;
|
||
CREATE TABLE `t_user` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`user_name` text NULL COMMENT 'user_name',
|
||
`nicker_name` text NULL COMMENT 'nicker_name',
|
||
`sex` text NULL COMMENT 'sex',
|
||
`phone` text NULL COMMENT 'phone',
|
||
`qk_openid` text NULL COMMENT 'qk_openid',
|
||
`open_id` text NULL COMMENT 'open_id',
|
||
`ali_user_id` text NULL COMMENT 'ali_user_id',
|
||
`birthday` datev2 NULL COMMENT 'birthday',
|
||
`avatar` text NULL COMMENT 'avatar',
|
||
`app_type` text NULL COMMENT 'app_type',
|
||
`password` text NULL COMMENT 'password',
|
||
`upper_user` bigint NULL DEFAULT NULL COMMENT 'upper_user',
|
||
`master_flag` int NULL DEFAULT NULL COMMENT 'master_flag',
|
||
`user_type` text NOT NULL COMMENT 'user_type',
|
||
`multi_charge` int NOT NULL COMMENT 'multi_charge',
|
||
`relation_phone` text NULL COMMENT 'relation_phone',
|
||
`user_owner_id` bigint NULL DEFAULT NULL COMMENT 'user_owner_id',
|
||
`union_id` text NULL COMMENT 'union_id',
|
||
`state` text NOT NULL COMMENT 'state',
|
||
`reg_channel` text NULL COMMENT 'reg_channel',
|
||
`reg_time` datetimev2 NULL COMMENT 'reg_time',
|
||
`city_label_code` text NULL COMMENT 'city_label_code',
|
||
`city_label` text NULL COMMENT 'city_label',
|
||
`reg_source` text NULL COMMENT 'reg_source',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`operator` text NULL COMMENT 'operator',
|
||
`invite_code` text NULL COMMENT 'invite_code',
|
||
`identity_id` text NULL COMMENT 'identity_id',
|
||
`operator_id` bigint NULL DEFAULT NULL COMMENT 'operator_id',
|
||
`address` text NULL COMMENT 'address',
|
||
`vip_level` text NULL COMMENT 'vip_level',
|
||
`province_code` text NULL COMMENT 'province_code',
|
||
`province` text NULL COMMENT 'province',
|
||
`work_company` text NULL COMMENT 'work_company',
|
||
`is_bind_wxinfo` int NULL DEFAULT NULL COMMENT 'is_bind_wxinfo',
|
||
`company_min_charge_balance` decimalv3 NULL COMMENT 'company_min_charge_balance',
|
||
`enable_online_recharge` int NULL DEFAULT NULL COMMENT 'enable_online_recharge',
|
||
`integral` decimalv3 NULL COMMENT 'integral',
|
||
`shared_user` tinyint NULL DEFAULT NULL COMMENT 'shared_user',
|
||
`enable_online_refund` int NULL DEFAULT NULL COMMENT 'enable_online_refund',
|
||
`recommenderId` bigint NULL DEFAULT NULL COMMENT 'recommenderId',
|
||
`lx_wx_user_id` bigint NULL DEFAULT NULL COMMENT 'lx_wx_user_id',
|
||
`phone_area` text NULL COMMENT 'phone_area'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_user` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_user_account
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_user_account`;
|
||
CREATE TABLE `t_user_account` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`user_id` bigint NOT NULL COMMENT 'user_id',
|
||
`ua_balance` decimalv3 NOT NULL COMMENT 'ua_balance',
|
||
`ua_deposit` decimalv3 NULL COMMENT 'ua_deposit',
|
||
`ua_balance_time` datetimev2 NULL COMMENT 'ua_balance_time',
|
||
`ua_password` text NULL COMMENT 'ua_password',
|
||
`ua_state` text NOT NULL COMMENT 'ua_state',
|
||
`ua_real_balance` decimalv3 NOT NULL COMMENT 'ua_real_balance',
|
||
`ua_real_degree` double NULL DEFAULT NULL COMMENT 'ua_real_degree',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间',
|
||
`donate_money` decimalv3 NOT NULL COMMENT 'donate_money',
|
||
`donate_able_money` decimalv3 NOT NULL COMMENT 'donate_able_money',
|
||
`ua_able_balance` decimalv3 NOT NULL COMMENT 'ua_able_balance',
|
||
`refund_money` decimalv3 NULL COMMENT 'refund_money',
|
||
`ua_consume_money` decimalv3 NULL COMMENT 'ua_consume_money',
|
||
`ua_clear_zero_money` decimalv3 NULL COMMENT 'ua_clear_zero_money'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_user_account` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for t_user_upload_fault
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `t_user_upload_fault`;
|
||
CREATE TABLE `t_user_upload_fault` (
|
||
`id` bigint NOT NULL COMMENT '主键ID',
|
||
`equipment_id` int NOT NULL COMMENT 'equipment_id',
|
||
`user_id` int NOT NULL COMMENT 'user_id',
|
||
`fault_config_id` int NULL DEFAULT NULL COMMENT 'fault_config_id',
|
||
`remark` text NULL COMMENT '备注',
|
||
`create_time` datetimev2 NULL COMMENT '创建时间',
|
||
`update_time` datetimev2 NULL COMMENT '更新时间'
|
||
) ENGINE = Doris CHARACTER SET = utf-8 COLLATE = utf-8 PARTITION BY UNPARTITIONED (NULL)
|
||
PARTITIONS 1
|
||
SUBPARTITION BY NULL (NULL)
|
||
SUBPARTITIONS 1
|
||
(PARTITION `t_user_upload_fault` MAX_ROWS = 0 MIN_ROWS = 0 (SUBPARTITION `NULL` MAX_ROWS = 0 MIN_ROWS = 0 ))
|
||
;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|