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