zlwl-algos-new/COMMON/orm/models.py

# 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'
)