# coding: utf-8 from sqlalchemy import CHAR, Column, DECIMAL, Date, DateTime, Float, Index, String, TIMESTAMP, Table, Text, text from sqlalchemy.dialects.mysql import BIGINT, DATETIME, INTEGER, LONGBLOB, LONGTEXT, TEXT, TINYINT, VARCHAR from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata t_algo_adjustable_param = Table( 'algo_adjustable_param', metadata, Column('id', BIGINT(20), comment='id'), Column('algo_id', INTEGER(11), comment='算法ID'), Column('pack_code', String(255), comment='电池包包号'), Column('param', String(510), comment='可调报警参数'), Column('param_ai', String(255), comment='AI算法可调报警参数'), Column('create_time', DateTime, comment='算法创建时间'), Column('create_by', String(255), comment='算法创建人'), Column('update_by', String(255), comment='算法更新人'), Column('is_delete', String(255), comment='是否删除'), Column('update_time', DateTime, comment='更新时间'), Column('remark', String(255), comment='备注'), comment='算法可调参数表' ) class AlgoAilipltdResult(Base): __tablename__ = 'algo_ailipltd_result' __table_args__ = {'comment': '电池析锂信息统计表'} id = Column(BIGINT(255), primary_key=True) create_time = Column(DateTime, comment='创建时间') time_cal = Column(String(55), comment='开始计算时间') imei = Column(String(55), comment='imei') sn = Column(String(55), comment='sn') num = Column(String(255), comment='电芯序号') liplted_amount_temp = Column(String(255), comment='单次析锂时长') chrgr_rest = Column(String(255), comment='充电序号') y_pred = Column(String(255), comment='是否析锂') liplted_amount = Column(String(255), comment='累计析锂次数') liplted_amount_10 = Column(String(255), comment='近十次累计析锂次数') mean_liplted_amount = Column(String(255), comment='历史平均析锂量') liplted_forget = Column(String(255), comment='各指标不再超出报警阈值的时长') cusum_10 = Column(String(255), comment='近十次累计析锂量') diff_liplted = Column(String(255), comment='近十次平均析锂量-总平均析锂量') cusum = Column(String(255), comment='累计析锂量') index_score = Column(Float(50), comment='析锂指数') class AlgoAllFaultInfoDone(Base): __tablename__ = 'algo_all_fault_info_done' __table_args__ = {'comment': '已结束故障统计表'} id = Column(BIGINT(11), primary_key=True, nullable=False, comment='id') date_info = Column(DateTime, primary_key=True, nullable=False, server_default=text("'1900-01-01 00:00:00'"), comment='时间分区字段') start_time = Column(DateTime, comment='结束时间') end_time = Column(DateTime, comment='结束时间') sn = Column(String(255), comment='sn') imei = Column(String(255), comment='vin') model = Column(String(255), comment='车型') fault_level = Column(TINYINT(1), comment='故障级别') fault_code = Column(String(255), comment='故障码') fault_info = Column(String(2550), comment='故障信息') fault_location = Column(String(255), comment='故障位置') fault_advice = Column(String(255), comment='故障建议') fault_reason = Column(String(255), comment='故障归因') device_status = Column(TINYINT(1), comment='电池状态 0-充电 1-放电 2-静置 3-离线') odo = Column(Float(10), comment='里程') create_time = Column(DateTime, comment='创建时间') create_by = Column(String(255), comment='创建人') update_time = Column(DateTime, comment='更新时间') update_by = Column(String(255), comment='更新人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') comment = Column(String(2000), comment='备注') class AlgoAllFaultInfoIng(Base): __tablename__ = 'algo_all_fault_info_ing' __table_args__ = {'comment': '正在进行故障统计表'} id = Column(BIGINT(11), primary_key=True, nullable=False, comment='id') date_info = Column(DateTime, primary_key=True, nullable=False, server_default=text("'1900-01-01 00:00:00'"), comment='时间分区字段') start_time = Column(DateTime, comment='开始时间') end_time = Column(String(255), comment='结束时间') sn = Column(String(255), comment='sn') imei = Column(String(255), comment='vin') model = Column(String(255), comment='车型') fault_level = Column(TINYINT(1), comment='故障级别') fault_code = Column(String(255), comment='故障码') fault_info = Column(VARCHAR(2550), comment='故障信息') fault_reason = Column(String(255), comment='故障归因') fault_location = Column(String(255), comment='故障位置') fault_advice = Column(String(255), comment='故障建议') device_status = Column(TINYINT(1), comment='电池状态 0-静置 1=快充; 2=慢充; 3=行车 4=离线') odo = Column(Float(10), comment='里程') create_time = Column(DateTime, comment='创建时间') create_by = Column(String(255), comment='创建人') update_time = Column(DateTime, comment='更新时间') update_by = Column(String(255), comment='更新人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') comment = Column(String(2000), comment='备注') class AlgoChargeInfo(Base): __tablename__ = 'algo_charge_info' id = Column(BIGINT(11), primary_key=True) add_time = Column(String(255)) update_time = Column(String(255)) sn = Column(String(255)) time_st = Column(String(255), comment='起始时间') time_end = Column(String(255), comment='结束时间') status = Column(String(255), comment='行程状态') delta_time = Column(Float(255), comment='相对时间') soc_st = Column(Float(255), comment='起始SOC') soc_end = Column(Float(255), comment='结束SOC') volt_st = Column(Float(255), comment='起始电压') volt_end = Column(Float(255), comment='结束电压') diffvolt_st = Column(Float(255), comment='起始压差') diffvolt_end = Column(Float(255), comment='结束压差') temp_max = Column(Float(255), comment='行程最大温度') temp_min = Column(Float(255), comment='行程最小温度') temp_incr = Column(Float(255), comment='行程温升') temp_mean = Column(Float(255), comment='行程温度均值') temp_st_mean = Column(Float(255), comment='起始温度均值') temp_end_mean = Column(Float(255), comment='结束温度均值') difftem_max = Column(Float(255), comment='最大温差') meancrnt = Column(Float(255), comment='电流倍率') max_meancrnt = Column(Float(255), comment='最大电流倍率') chrgah = Column(Float(255), comment='累计充电安时容量') chrgkwh = Column(Float(255), comment='累计充电能量') sts_flg = Column(INTEGER(255), comment='充电类型标志位 0-慢充 1-快充') full_chrg_flg = Column(INTEGER(255), comment='满充标志位 0-非满充 1-满充') ovchrg_flg = Column(INTEGER(255), comment='过充标志位 0-未过充 1-过充') ovchrg_prop = Column(INTEGER(255), comment='过充量') gps_lon = Column(Float(255), comment='经度') gps_lat = Column(Float(255), comment='纬度') standtime_f = Column(Float(255), comment='充电前静置时长') standtime_b = Column(Float(255), comment='充电后静置时长') city = Column(VARCHAR(255), comment='电池所在城市') airtemp_st = Column(Float(255), comment='行程起始环境温度') airtemp_end = Column(Float(255), comment='行程结束环境温度') charge_env = Column(INTEGER(255), comment='0 室外 1 疑似室内 2 室内\\r\\n') class AlgoDwdDfChargeStaticBase(Base): __tablename__ = 'algo_dwd_df_charge_static_base' id = Column(BIGINT(20), primary_key=True, comment='主键') sn = Column(String(255), comment='电池标号') charge_block = Column(INTEGER(11), comment='充电时段编号') Time_b = Column(DateTime, comment='开始时间') Time_e = Column(DateTime, comment='结束时间') PackCrnt_b = Column(Float, comment='开始电流') PackCrnt_e = Column(Float, comment='结束电流') PackVolt_b = Column(Float, comment='开始电压') PackVolt_e = Column(Float, comment='结束电压') PackSoc_b = Column(INTEGER(11), comment='开始SOC') PackSoc_e = Column(INTEGER(11), comment='结束SOC') latitude_b = Column(Float, comment='开始纬度') longitude_b = Column(Float, comment='开始经度') latitude_e = Column(Float, comment='结束经度') longitude_e = Column(Float, comment='结束纬度') time_diff = Column(Float, comment='充电时间') Date_b = Column(DateTime, comment='开始日期') Date_e = Column(DateTime, comment='结束日期') Day_b = Column(INTEGER(11)) Day_e = Column(INTEGER(11)) Hour_b = Column(INTEGER(11), comment='开始时刻') Hour_e = Column(INTEGER(11), comment='结束时刻') Time_slot_b = Column(String(255), comment='开始小时段') Time_slot_e = Column(String(255), comment='结束小时段') Pv_b = Column(String(255), comment='开始峰谷段') Pv_e = Column(String(255), comment='结束峰谷段') soc_diff = Column(INTEGER(11), comment='SOC变化') class AlgoDwdDfDriveStaticBase(Base): __tablename__ = 'algo_dwd_df_drive_static_base' id = Column(BIGINT(20), primary_key=True, comment='主键') sn = Column(String(255), comment='电池编号') drive_block = Column(INTEGER(11), comment='行驶段') Time_b = Column(DateTime, comment='行驶段开始时间') Time_e = Column(DateTime, comment='行驶段结束时间') PackCrnt_b = Column(Float(255), comment='行驶段开始的电流') PackCrnt_e = Column(Float(255), comment='行驶段结束的电流') PackVolt_b = Column(Float(255), comment='行驶段开始的电压') PackVolt_e = Column(Float, comment='行驶段结束的电压') PackSoc_b = Column(INTEGER(11), comment='行驶段开始的SOC') PackSoc_e = Column(INTEGER(11), comment='行驶段结束的SOC') latitude_b = Column(Float, comment='行驶段开始的纬度') longitude_b = Column(Float, comment='行驶段开始的经度') latitude_e = Column(Float, comment='行驶度结束的纬度') longitude_e = Column(Float, comment='行驶度结束的经度') time_diff = Column(Float, comment='行驶段时长') Day_b = Column(INTEGER(11), comment='行驶段开始所在日') Day_e = Column(INTEGER(11), comment='行驶段结束所在日') Hour_b = Column(INTEGER(11), comment='行驶段开始所在时刻') Hour_e = Column(INTEGER(11), comment='行驶段结束所在时刻') Date_b = Column(DateTime, comment='行驶段开始日期') Date_e = Column(DateTime, comment='行驶段结束日期') Time_slot_b = Column(String(255), comment='行驶段开始的半小时段') Time_slot_e = Column(String(255), comment='行驶段结束的半小时段') Pv_b = Column(String(255), comment='行驶段开始的峰谷') Pv_e = Column(String(255), comment='行驶段结束的峰谷') soc_diff = Column(Float, comment='行驶段SOC变化') end_change = Column(INTEGER(11), comment='行驶段结束是否充换电') begin_change = Column(INTEGER(11), comment='行驶段开始是否充换电') charge_block = Column(INTEGER(11), comment='充换电周期编号') class AlgoDwdDfDriveStaticPeriod(Base): __tablename__ = 'algo_dwd_df_drive_static_period' id = Column(BIGINT(20), primary_key=True, comment='主键') sn = Column(String(255), comment='电池编号') charge_block = Column(INTEGER(8), comment='充换电周期编号') Time_b = Column(DateTime, comment='开始时间') Time_e = Column(DateTime, comment='结束时间') PackSoc_b = Column(INTEGER(8), comment='开始的SOC') PackSoc_e = Column(INTEGER(8), comment='结束的SOC') time_diff = Column(Float, comment='时长') Date_b = Column(DateTime, comment='开始日期') Date_e = Column(DateTime, comment='结束日期') Day_b = Column(INTEGER(8), comment='开始日') Day_e = Column(INTEGER(8), comment='结束日') Hour_b = Column(INTEGER(8), comment='开始时刻') Hour_e = Column(INTEGER(8), comment='结束时刻') Time_slot_b = Column(String(255), comment='开始的半小段') Time_slot_e = Column(String(255), comment='结束的半小时段') Pv_b = Column(String(255), comment='开始的峰谷段') Pv_e = Column(String(255), comment='结束的峰谷段') soc_diff = Column(Float, comment='SOC变化值') time_free = Column(Float, comment='空闲时间') class AlgoDwdDfStandStaticBase(Base): __tablename__ = 'algo_dwd_df_stand_static_base' id = Column(BIGINT(20), primary_key=True, comment='主键') sn = Column(String(255), comment='电池编号') stand_block = Column(INTEGER(11), comment='静置分段编号') Time_b = Column(DateTime, comment='开始时间') Time_e = Column(DateTime, comment='结束时间') PackCrnt_b = Column(Float, comment='开始电流') PackCrnt_e = Column(Float, comment='结束电流') PackVolt_b = Column(Float, comment='开始电压') PackVolt_e = Column(Float, comment='结束电压') PackSoc_b = Column(INTEGER(11), comment='开始SOC') PackSoc_e = Column(INTEGER(11), comment='结束SOC') latitude_b = Column(Float, comment='开始纬度') longitude_b = Column(Float, comment='开始经度') latitude_e = Column(Float, comment='结束纬度') longitude_e = Column(Float, comment='结束经度') time_diff = Column(Float, comment='静置时长') class AlgoDwdIndicator(Base): __tablename__ = 'algo_dwd_indicator' id = Column(BIGINT(20), primary_key=True, comment='ID') create_time = Column(DateTime) sn = Column(String(255)) start_time = Column(DateTime, comment='过程开始时间') end_time = Column(DateTime, comment='过程结束时间') delta_time = Column(Float, comment='过程时长') soc_st = Column(Float, comment='过程起始SOC') soc_end = Column(Float, comment='过程结束SOC') temp_max = Column(Float, comment='过程最大温度') temp_min = Column(Float, comment='过程最低温度') temp_incr = Column(Float, comment='过程最大温升') chrgah = Column(Float, comment='充电过程累计安时数') chrgkwh = Column(Float, comment='充电过程累计千瓦时数') meancrnt = Column(Float, comment='等效倍率') sts_flg = Column(INTEGER(255), comment='状态值：0为静置，1为快充，2位慢充，3为放电') full_chrg_flg = Column(INTEGER(255), comment='状态值：1为满充，0为非满充') status = Column(VARCHAR(255), comment='充放电状态') volt_st = Column(Float, comment='开始电压') volt_end = Column(Float, comment='结束电压') diffvolt_st = Column(Float, comment='开始压差') diffvolt_end = Column(Float, comment='结束压差') temp_mean = Column(Float, comment='全程平均单体温度') temp_st_mean = Column(Float, comment='起始平均单体温度') temp_end_mean = Column(Float, comment='结束平均单体温度') difftem_max = Column(Float, comment='全程最大单体温差\\r\\n') max_meancrnt = Column(Float, comment='最大倍率\\r\\n') ovchrg_flg = Column(INTEGER(11), comment='过充\\r\\n') ovchrg_prop = Column(INTEGER(11), comment='过充量\\r\\n') gps_lon = Column(Float, comment='经度\\r\\n') gps_lat = Column(Float, comment='纬度\\r\\n纬度') standtime_f = Column(Float, comment='充电前静置时长') standtime_b = Column(Float, comment='充电后静置时长') city = Column(VARCHAR(255), comment='城市') airtemp_st = Column(Float, comment='起始气温') airtemp_end = Column(Float, comment='结束气温') t_algo_dwd_sheduling_base = Table( 'algo_dwd_sheduling_base', metadata, Column('sn', Text), Column('time_date', Date), Column('time_slot', Text), Column('slot_first', DateTime), Column('slot_last', DateTime), Column('charge_first', Float(asdecimal=True)), Column('soc_first', Float(asdecimal=True)), Column('lat_first', Float(asdecimal=True)), Column('lon_first', Float(asdecimal=True)), Column('charge_last', Float(asdecimal=True)), Column('soc_last', Float(asdecimal=True)), Column('lat_last', Float(asdecimal=True)), Column('lon_last', Float(asdecimal=True)), Column('full_unused', BIGINT(20)), Column('charge_ing', BIGINT(20)), Column('c_time', Float(asdecimal=True)), Column('charge_full_next', BIGINT(20)), Column('charge_full_next2', BIGINT(20)), Column('charge_full', BIGINT(20)), Column('full_out', BIGINT(20)), Column('charge_out', BIGINT(20)), Column('charge_in', BIGINT(20)), Column('dist', Float(asdecimal=True)), Column('soc_low_1', BIGINT(20)), Column('soc_low_2', BIGINT(20)), Column('soc_low_3', BIGINT(20)), Column('dist_close_1', BIGINT(20)), Column('dist_close_2', BIGINT(20)), Column('dist_close_3', BIGINT(20)), Column('in_pro_1', BIGINT(20)), Column('in_pro_2', BIGINT(20)), Column('in_pro_3', BIGINT(20)) ) class AlgoDwdShedulingStatic(Base): __tablename__ = 'algo_dwd_sheduling_static' id = Column(BIGINT(20), primary_key=True) time_date = Column(DateTime) time_slot = Column(String(255)) full_unused = Column(INTEGER(8)) charge_ing = Column(INTEGER(8)) charge_full = Column(INTEGER(8)) full_out = Column(INTEGER(8)) charge_out = Column(INTEGER(8)) charge_in = Column(INTEGER(8)) charge_full_next = Column(INTEGER(8)) charge_full_next2 = Column(INTEGER(8)) soc_low_1 = Column(INTEGER(8)) soc_low_2 = Column(INTEGER(8)) soc_low_3 = Column(INTEGER(8)) dist_close_1 = Column(INTEGER(8)) dist_close_2 = Column(INTEGER(8)) dist_close_3 = Column(INTEGER(8)) in_pro_1 = Column(INTEGER(8)) in_pro_2 = Column(INTEGER(8)) in_pro_3 = Column(INTEGER(8)) load_rate = Column(Float) class AlgoExchangeStationChargeNeed(Base): __tablename__ = 'algo_exchange_station_charge_need' id = Column(BIGINT(20), primary_key=True, comment='主键') Time = Column(DateTime) time_slot = Column(String(255), comment='时间段') charge_need = Column(String(255), comment='充电调度值') charge_need_remain = Column(INTEGER(11), comment='延后充电的数量') class AlgoHealthScore(Base): __tablename__ = 'algo_health_score' __table_args__ = {'comment': '电池健康评分'} id = Column(BIGINT(20), primary_key=True, comment='ID') time = Column(DateTime, comment='更新时间') health_state = Column(Float, comment='健康评分') reason = Column(VARCHAR(255), comment='扣分原因') sn = Column(VARCHAR(255), comment='SN') class AlgoHoursStatu(Base): __tablename__ = 'algo_hours_status' id = Column(INTEGER(11), primary_key=True) create_time = Column(DateTime, comment='创建时间') update_time = Column(DateTime, comment='更新时间') sn = Column(String(255), comment='sn') bat_status = Column(INTEGER(2), comment='电池状态 0-静置 1=快充; 2=慢充; 3=行车 4=离线') hour_state = Column(INTEGER(2), comment='统计时间 0至23时') class AlgoList(Base): __tablename__ = 'algo_list' __table_args__ = {'comment': '电池报警项列表'} id = Column(BIGINT(20), primary_key=True, comment='ID') create_time = Column(DateTime, comment='创建时间') create_by = Column(VARCHAR(255), comment='创建人') update_by = Column(VARCHAR(255), comment='更新人') algo_id = Column(INTEGER(3), comment='算法ID') update_time = Column(DateTime, comment='更新时间') algo_name = Column(VARCHAR(255), comment='算法名称') is_activate = Column(TINYINT(4), comment='是否启动') global_param = Column(VARCHAR(255), comment='不可调参数') fault_level = Column(INTEGER(1), comment='故障等级') fault_code = Column(VARCHAR(4), comment='故障代码') fault_influence = Column(VARCHAR(255), comment='故障影响') model_type = Column(VARCHAR(255), comment='模型类型') configurable_flag = Column(VARCHAR(255), comment='是否可配') is_delete = Column(TINYINT(4), server_default=text("'0'"), comment='是否删除') model_alarm_type = Column(TINYINT(1), nullable=False, server_default=text("'1'"), comment='故障类型 0-风险 1-故障 2-事故') dept_id_list = Column(String(255), comment='机构列表') remark = Column(String(255), comment='备注') class AlgoMidIntershortResult(Base): __tablename__ = 'algo_mid_intershort_result' __table_args__ = {'comment': '电池内短路统计详情'} id = Column(BIGINT(20), primary_key=True, nullable=False, comment='ID') add_time = Column(TIMESTAMP, primary_key=True, nullable=False, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"), comment='添加时间') update_time = Column(TIMESTAMP, comment='更新时间') time_st = Column(TIMESTAMP, comment='计算开始时间') time_sp = Column(TIMESTAMP, comment='计算结束时间') sn = Column(VARCHAR(255), comment='SN') method = Column(INTEGER(11), comment='计算方法') short_current = Column(TEXT, comment='内短路电流') baltime = Column(TEXT, comment='均衡时间') class AlgoMidSorout(Base): __tablename__ = 'algo_mid_sorout' __table_args__ = {'comment': '内阻计算结果表单'} id = Column(BIGINT(20), primary_key=True, nullable=False) add_time = Column(DateTime, comment='添加时间') update_time = Column(DateTime, comment='更新时间') sn = Column(String(64), comment='sn') time = Column(DateTime, primary_key=True, nullable=False, comment='内阻计算时间') sor = Column(Text, comment='内阻值') sor_diff = Column(Float, comment='内阻差') sor_sigma = Column(Text, comment='内阻3sigma值') soc = Column(Text, comment='计算内阻时的SOC') temp = Column(Text, comment='计算内阻时的温度') delta_time = Column(Float, comment='计算时间段') class AlgoMidUniformResult(Base): __tablename__ = 'algo_mid_uniform_result' id = Column(BIGINT(20), primary_key=True) add_time = Column(DateTime, comment='添加时间') update_time = Column(DateTime, comment='更新时间') time = Column(TIMESTAMP, comment='计算时间') sn = Column(VARCHAR(255), comment='sn') bmssoc = Column(Float(5), comment='计算一致性时的bmssoc') cellsoc_diff = Column(Float, comment='soc一致性结果') cellvolt_diff = Column(Float, comment='电压一致性结果') cellmin_num = Column(INTEGER(11), comment='最小电压序号') cellmax_num = Column(INTEGER(11), comment='最大电压序号') cellsocmax = Column(Float(5), comment='最低soc') cellsocmin = Column(Float(5), comment='最高soc') cellvolt_rank = Column(String(255), comment='电压排名') celltemp_diff = Column(Float(5), comment='温差') class AlgoPackParam(Base): __tablename__ = 'algo_pack_param' id = Column(BIGINT(255), primary_key=True, comment='ID') pack_code = Column(VARCHAR(255), comment='电池包型号') param = Column(LONGTEXT, comment='参数') create_time = Column(DateTime, comment='创建时间') create_by = Column(VARCHAR(255), comment='创建人') update_by = Column(VARCHAR(255), comment='更新人') is_delete = Column(TINYINT(255), comment='是否删除') update_time = Column(DateTime, comment='更新时间') class AlgoSafetyScoreD(Base): __tablename__ = 'algo_safety_score_d' id = Column(BIGINT(255), primary_key=True) create_time = Column(DateTime) update_time = Column(DateTime) sn = Column(VARCHAR(255)) score_d = Column(Float(5)) risk_index = Column(LONGTEXT) class AlgoSafetyScoreH(Base): __tablename__ = 'algo_safety_score_h' id = Column(BIGINT(255), primary_key=True) create_time = Column(DateTime) update_time = Column(DateTime) sn = Column(VARCHAR(255)) hour_h = Column(INTEGER(2)) score_h = Column(Float(5)) risk_index = Column(LONGTEXT) t_algo_soc_cor = Table( 'algo_soc_cor', metadata, Column('sn', String(255), comment='sn号'), Column('time', DateTime, comment='校准时刻'), Column('soc', Float, comment='校准时自身SOC'), Column('soc_real', Float, comment='校准后SOC'), Column('soc_delta', Float, comment='SOC差值'), Column('method', INTEGER(10), comment='SOC校准方法'), Column('odo', Float, comment='使用里程'), comment='soc校准' ) class AlgoSoh(Base): __tablename__ = 'algo_soh' id = Column(BIGINT(20), primary_key=True) create_time = Column(DateTime) update_time = Column(DateTime) sn = Column(String(255)) time_st = Column(DateTime) time_sp = Column(DateTime) method = Column(INTEGER(2)) soh = Column(Float) soh_real = Column(Float) cellsoh_diff = Column(Float) cellsoh = Column(Text) charge_ah = Column(Float) discharge_ah = Column(Float) odo = Column(Float(10)) class RBatteryFolder(Base): __tablename__ = 'r_battery_folder' __table_args__ = {'comment': '电池-故障-数据集'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(VARCHAR(255), comment='创建人') update_by = Column(VARCHAR(255), comment='更新人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') battery_id = Column(BIGINT(20), comment='电池id') folder_id = Column(BIGINT(20), comment='收藏文件夹id') folder_type = Column(TINYINT(1), comment='文件夹类型 0-电池收藏 1-故障收藏 2-数据集收藏') sn = Column(VARCHAR(255), comment='电池编号') vin = Column(VARCHAR(255), comment='车架号') remark = Column(VARCHAR(255), comment='备注') user_id = Column(BIGINT(11), comment='用户id') alarm_name = Column(VARCHAR(255), comment='故障名称') class RBatteryTag(Base): __tablename__ = 'r_battery_tag' __table_args__ = {'comment': '电池标签表'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(VARCHAR(255), comment='创建人') update_by = Column(VARCHAR(255), comment='更新人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') object_id = Column(BIGINT(20), comment='电池id') tag_id = Column(BIGINT(11), comment='标签id') child_tag_list = Column(VARCHAR(255), comment='子标签，多个逗号隔开') tag_remark = Column(VARCHAR(255), comment='标签说明') tag_type = Column(TINYINT(1), comment='标签类型 1-故障标签 0-电池标签 2-数据集标签') remark = Column(String(255), comment='备注') class RDeptMenu(Base): __tablename__ = 'r_dept_menu' __table_args__ = {'comment': '机构关联菜单'} id = Column(BIGINT(20), primary_key=True, comment='自增主键') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='删除标识1-删除 0-未删除') dept_id = Column(BIGINT(20), comment='机构id') menu_id = Column(BIGINT(20), comment='菜单id') class RDeptModel(Base): __tablename__ = 'r_dept_model' __table_args__ = {'comment': '机构关联模型表'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(String(255), comment='创建人') update_by = Column(String(255), comment='更新人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') dept_id = Column(BIGINT(20), comment='机构id') model_id = Column(BIGINT(20), comment='模型编码') remark = Column(String(255), comment='备注') model_alarm_type = Column(TINYINT(1), server_default=text("'1'"), comment='预警类型 0-风险 1-故障 2-事故') flag = Column(TINYINT(1), server_default=text("'0'"), comment='是否选中 0-未选中 1-选中') class RDeptModelSelf(Base): __tablename__ = 'r_dept_model_self' __table_args__ = {'comment': '机构关联模型表'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(String(255), comment='创建人') update_by = Column(String(255), comment='更新人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') dept_id = Column(BIGINT(20), comment='机构id') model_id = Column(BIGINT(20), comment='模型编码') remark = Column(String(255), comment='备注') class RRiskModel(Base): __tablename__ = 'r_risk_model' __table_args__ = {'comment': '风险关联模型表'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(String(255), comment='创建人') update_by = Column(String(255), comment='更新人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') risk_code = Column(String(255), comment='风险类型编码') model_id = Column(BIGINT(20), comment='模型id') remark = Column(String(255), comment='备注') enabled = Column(TINYINT(1), server_default=text("'0'"), comment='是否启用 0-否 1-是') model_alarm_type = Column(TINYINT(1), server_default=text("'1'"), comment='预警类型 0-风险 1-故障 2-事故') risk_type = Column(String(255), comment='风险类型') dept_id = Column(BIGINT(20), comment='机构id') class SysDept(Base): __tablename__ = 'sys_dept' __table_args__ = {'comment': '部门表'} dept_id = Column(BIGINT(20), primary_key=True, comment='部门id') parent_id = Column(BIGINT(20), server_default=text("'0'"), comment='父部门id') ancestors = Column(String(50), server_default=text("''"), comment='祖级列表') dept_name = Column(String(30), server_default=text("''"), comment='部门名称') order_num = Column(INTEGER(4), server_default=text("'0'"), comment='显示顺序') leader = Column(String(20), comment='负责人') phone = Column(String(11), comment='联系电话') email = Column(String(50), comment='邮箱') status = Column(CHAR(1), server_default=text("'0'"), comment='部门状态（0正常 1停用）') del_flag = Column(CHAR(1), server_default=text("'0'"), comment='删除标志（0代表存在 2代表删除）') create_by = Column(String(64), server_default=text("''"), comment='创建者') create_time = Column(DateTime, comment='创建时间') update_by = Column(String(64), server_default=text("''"), comment='更新者') update_time = Column(DateTime, comment='更新时间') organ_code = Column(String(255), comment='机构编码') province_code = Column(String(255), comment='省份编码') city_code = Column(String(255), comment='市区编码') province = Column(String(255), comment='省份') city = Column(String(255), comment='市区') address_detail = Column(String(1000), comment='详细地址') parent_name = Column(String(255), comment='父级机构名称') dead_line = Column(DateTime, comment='有效期至') logo = Column(String(255), comment='公司logo') platform = Column(String(255), comment='平台名称') remark = Column(String(255), comment='备注') dept_level = Column(TINYINT(1), comment='部门等级') class SysDictDatum(Base): __tablename__ = 'sys_dict_data' __table_args__ = {'comment': '字典数据表'} dict_code = Column(BIGINT(20), primary_key=True, comment='字典编码') dict_sort = Column(INTEGER(4), server_default=text("'0'"), comment='字典排序') dict_label = Column(String(100), server_default=text("''"), comment='字典标签') dict_value = Column(String(100), server_default=text("''"), comment='字典键值') dict_type = Column(String(100), server_default=text("''"), comment='字典类型') css_class = Column(String(100), comment='样式属性（其他样式扩展）') list_class = Column(String(100), comment='表格回显样式') is_default = Column(CHAR(1), server_default=text("'N'"), comment='是否默认（Y是 N否）') status = Column(CHAR(1), server_default=text("'0'"), comment='状态（0正常 1停用）') create_by = Column(String(64), server_default=text("''"), comment='创建者') create_time = Column(DateTime, comment='创建时间') update_by = Column(String(64), server_default=text("''"), comment='更新者') update_time = Column(DateTime, comment='更新时间') remark = Column(String(500), comment='备注') class TAlgoAlarmDataTag(Base): __tablename__ = 't_algo_alarm_data_tag' __table_args__ = {'comment': '算法标签记录'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(String(255), comment='创建人') update_by = Column(String(255), comment='更新人') factory = Column(String(255), comment='厂家') sn = Column(String(255), comment='电池编号') start_time = Column(DateTime, comment='开始时间') end_time = Column(DateTime, comment='结束时间') tag = Column(INTEGER(11), comment='标签') tag_child = Column(INTEGER(11), comment='子标签') remark = Column(VARCHAR(255), comment='备注') organ_code = Column(String(255), comment='机构编码') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') class TDevice(Base): __tablename__ = 't_device' __table_args__ = {'comment': '设备信息表'} device_status = Column(TINYINT(1), comment='电池运行状态') id = Column(BIGINT(20), primary_key=True, comment='主键') create_time = Column(DateTime) update_time = Column(DateTime) update_by = Column(String(255), comment='更新人') create_by = Column(String(255), comment='创建人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='删除标识') remark = Column(String(500), comment='备注') status = Column(TINYINT(4), comment='当前状态（1:正常，2：异常)）') omp_status = Column(TINYINT(4), comment='运维状态（0: 正常, 1：待处理， 2：待回调，3：待售后， 4：已完结)）') sn = Column(VARCHAR(32), nullable=False, comment='sn号') imei = Column(VARCHAR(255), comment='imei号') producer = Column(VARCHAR(255), comment='品牌') device_type = Column(INTEGER(11), server_default=text("'1'"), comment='设备类型（1：产品， 2：配件）') product_type = Column(INTEGER(11), server_default=text("'1'"), comment='产品/配件 类型（1：电池， 2：电动车 3:充电器') model = Column(VARCHAR(255), comment='型号') third_sn = Column(VARCHAR(50), comment='第三方电池编号') vin = Column(String(50), comment='车架号') organ_code = Column(VARCHAR(255), comment='机构编码') battery_model = Column(String(255), comment='电池型号') factory = Column(String(255), comment='品牌') device_cell_type = Column(String(255), comment='电芯类型') pack_model = Column(String(255), comment='电池包型号') cell_model = Column(String(255), comment='电芯型号') capacity = Column(DECIMAL(11, 2), comment='容量') scrap_status = Column(TINYINT(1), server_default=text("'1'"), comment='报废状态 0-禁用 1-正常 2-故障 3-返修 4-损毁 5-丢失已赔偿 6-丢失未赔偿 7-测试') class TFactory(Base): __tablename__ = 't_factory' id = Column(INTEGER(11), primary_key=True) create_time = Column(DateTime) update_time = Column(DateTime, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP")) factory = Column(String(255), comment='厂家') create_by = Column(String(255), comment='创建人') update_by = Column(String(255), comment='更新人') class TProductType(Base): __tablename__ = 't_product_type' __table_args__ = {'comment': '电池类型'} id = Column(BIGINT(11), primary_key=True, comment='主键id') create_time = Column(DateTime, comment='创建时间') update_time = Column(DateTime, comment='更新时间') create_by = Column(VARCHAR(255), comment='创建人') update_by = Column(VARCHAR(255), comment='更新人') sn_type = Column(String(255), nullable=False, comment='sn切片对应的类型') sn_type_code = Column(String(255), nullable=False, comment='sn切片对应类型的实际数据编号') sn_type_desc = Column(String(255), nullable=False, comment='sn切片对应类型的实际数据描述') operator = Column(String(255), nullable=False, comment='操作者') status = Column(INTEGER(255), comment='状态码，停用为0') sn_type_en = Column(INTEGER(1), comment='sn类型编码 1=产品类型代码,2=PACK制造商简称,3=电芯厂家名称,4=化学体系,5=电压,6=电量,7=产品扩展代码,8=生产日期,9=序列号') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='删除标识') remark = Column(String(255), comment='备注') class TScrapDevice(Base): __tablename__ = 't_scrap_device' __table_args__ = {'comment': '设备报废信息表'} id = Column(BIGINT(20), primary_key=True, comment='主键') create_time = Column(DateTime) update_time = Column(DateTime) update_by = Column(String(255), comment='更新人') create_by = Column(String(255), comment='创建人') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='删除标识') remark = Column(String(500), comment='备注') sn = Column(String(55), comment='报废电池sn') reason = Column(String(255), comment='报废原因') scrap_time = Column(DateTime, comment='报废时间') organ_code = Column(VARCHAR(255), comment='机构编码') scrap_status = Column(TINYINT(1), comment='状态 1-已回收 2-已退回 3-已报废 4-丢失') class TTag(Base): __tablename__ = 't_tag' __table_args__ = {'comment': '标签表'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(VARCHAR(255), comment='创建人') update_by = Column(VARCHAR(255), comment='更新人') tag_name = Column(VARCHAR(255), comment='标签名称') tag_type = Column(TINYINT(1), comment='标签类型 1-故障标签 2-电池标签 3-数据集标签') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') remark = Column(String(255), comment='备注') tag_remark = Column(VARCHAR(255), comment='标签备注') status = Column(TINYINT(1), server_default=text("'1'"), comment='状态 1-启用 0-停用') organ_code = Column(String(255), comment='机构id') class TTagChild(Base): __tablename__ = 't_tag_child' __table_args__ = {'comment': '子标签表'} id = Column(BIGINT(11), primary_key=True, comment='主键id') update_time = Column(DateTime, comment='更新时间') create_time = Column(DateTime, comment='创建时间') create_by = Column(VARCHAR(255), comment='创建人') update_by = Column(VARCHAR(255), comment='更新人') parent_id = Column(BIGINT(11), comment='父标签id') name = Column(VARCHAR(255), comment='子标签名称') is_delete = Column(TINYINT(1), server_default=text("'0'"), comment='是否删除 0-否 1-是') type = Column(VARCHAR(255), comment='子标签类别') status = Column(TINYINT(1), server_default=text("'1'"), comment='子标签状态 1-启用 0-停用') tag_type = Column(TINYINT(1), comment='标签类型 1-故障标签 2-电池标签 3-数据集标签') remark = Column(String(255), comment='备注') organ_code = Column(String(255), comment='机构id') class Test2(Base): __tablename__ = 'test2' id = Column(INTEGER(11), primary_key=True) field1 = Column(VARCHAR(255)) field2 = Column(VARCHAR(255)) t_undo_log = Table( 'undo_log', metadata, Column('branch_id', BIGINT(20), nullable=False, comment='branch transaction id'), Column('xid', String(100), nullable=False, comment='global transaction id'), Column('context', String(128), nullable=False, comment='undo_log context,such as serialization'), Column('rollback_info', LONGBLOB, nullable=False, comment='rollback info'), Column('log_status', INTEGER(11), nullable=False, comment='0:normal status,1:defense status'), Column('log_created', DATETIME(fsp=6), nullable=False, comment='create datetime'), Column('log_modified', DATETIME(fsp=6), nullable=False, comment='modify datetime'), Index('ux_undo_log', 'xid', 'branch_id', unique=True), comment='AT transaction mode undo table' )