# -*- coding: utf-8 -*- from sqlalchemy import String, Column, Integer, DateTime, Text, Float, JSON from sqlalchemy.dialects.mysql import TINYINT from sqlalchemy.sql import func from database import Base from datetime import datetime class DangerAppInfo(Base): __tablename__ = 'danger_app_info' client_id = Column(String, primary_key=True) client_secret = Column(String, comment="") grant_type = Column(String, comment="") scope = Column(String, comment="") class Config: orm_mode = True class DangerUploadFile(Base): __tablename__ = 'danger_upload_file' id = Column(String, primary_key=True) certificate_no = Column(String) file_name = Column(String, comment="") save_filepath = Column(String, comment="") file_type = Column(String, comment="") from_type = Column(String, comment="") upload_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') class Config: orm_mode = True class DangerBaseCompanyInfo(Base): __tablename__ = 'danger_base_company_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') park_code = Column(String, default='', server_default='', comment='') is_inpark = Column(Integer, default='0', server_default='0', comment='') company_code = Column(String, default='', server_default='', comment='') parent_code = Column(String, default='', server_default='', comment='') company_status = Column(Integer, default='0', server_default='0', comment='') firm_name = Column(String, default='', server_default='', comment='') short_name = Column(String, default='', server_default='', comment='') area_code = Column(String, default='', server_default='', comment='') firm_type = Column(Integer, default='0', server_default='0', comment='') firm_secondary_type = Column(Integer, default='0', server_default='0', comment='') import_type = Column(Integer, default='0', server_default='0', comment='') is_import = Column(Integer, default='0', server_default='0', comment='') eco_type = Column(String, default='', server_default='', comment='') business_type = Column(String, default='', server_default='', comment='') business_class_type = Column(String, default='', server_default='', comment='') legal_repr_name = Column(String, default='', server_default='', comment='') legal_repr_tel = Column(String, default='', server_default='', comment='') link_name = Column(String, default='', server_default='', comment='') link_tel = Column(String, default='', server_default='', comment='') firm_register_capital = Column(String, default='', server_default='', comment='') firm_address = Column(String, default='', server_default='', comment='') firm_register_time = Column(DateTime, comment='') lng = Column(String, default='', server_default='', comment='') lat = Column(String, default='', server_default='', comment='') produce_address_code = Column(String, default='', server_default='', comment='') produce_address = Column(Text, comment='') firm_num = Column(Integer, default='0', server_default='0', comment='') employee_num = Column(Integer, default='0', server_default='0', comment='') firm_scale = Column(Integer, default='0', server_default='0', comment='') firm_url = Column(String, default='', server_default='', comment='') firm_run_scope = Column(Text, comment='') major_run = Column(String, default='', server_default='', comment='') firm_build_area = Column(String, default='', server_default='', comment='') factory_area = Column(String, default='', server_default='', comment='') range_geometry_data = Column(Text, comment='') store_build_area = Column(String, default='', server_default='', comment='') pot_cubage = Column(String, default='', server_default='', comment='') counsel_phone = Column(String, default='', server_default='', comment='') duty_phone = Column(String, default='', server_default='', comment='') firm_level = Column(Integer, default='0', server_default='0', comment='') is_contain = Column(Integer, default='0', server_default='0', comment='') instrument_num = Column(Integer, default='0', server_default='0', comment='') safty_manage_dept = Column(String, default='', server_default='', comment='') safety_director_name = Column(String, default='', server_default='', comment='') safety_director_tel = Column(String, default='', server_default='', comment='') principal = Column(String, default='', server_default='', comment='') principal_tel = Column(String, default='', server_default='', comment='') principal_mobile = Column(String, default='', server_default='', comment='') safety_principal = Column(String, default='', server_default='', comment='') safety_principal_tel = Column(String, default='', server_default='', comment='') safety_principal_mobile = Column(String, default='', server_default='', comment='') safety_principal_duty_phone = Column(String, default='', server_default='', comment='') dept_principal = Column(String, default='', server_default='', comment='') dept_principal_tel = Column(String, default='', server_default='', comment='') post_code = Column(String, default='', server_default='', comment='') establish_date = Column(DateTime, comment='') safety_standard_grad = Column(Integer, default='0', server_default='0', comment='') safety_license_no = Column(String, default='', server_default='', comment='') safety_license_start = Column(DateTime, comment='') safety_license_end = Column(DateTime, comment='') special_num = Column(Integer, default='0', server_default='0', comment='') fulltime_safety_num = Column(Integer, default='0', server_default='0', comment='') parttime_safety_num = Column(Integer, default='0', server_default='0', comment='') fulltime_emergency_num = Column(Integer, default='0', server_default='0', comment='') cse_num = Column(Integer, default='0', server_default='0', comment='') fulltime_rescue_num = Column(Integer, default='0', server_default='0', comment='') parttime_rescue_num = Column(Integer, default='0', server_default='0', comment='') toxic_job_psn_num = Column(Integer, default='0', server_default='0', comment='') chemical_job_psn_num = Column(Integer, default='0', server_default='0', comment='') people_hazard = Column(Integer, default='0', server_default='0', comment='') process_files = Column(String, default='', server_default='', comment='') production_status = Column(Integer, default='0', server_default='0', comment='') personnel_slience_area = Column(String, default='', server_default='', comment='') is_safety_license = Column(Integer, default='0', server_default='0', comment='') safety_license_first_date = Column(DateTime, comment='') safety_license_range = Column(Text, comment='') business_license_code = Column(String, default='', server_default='', comment='') business_license_begin = Column(DateTime, comment='') business_license_end = Column(DateTime, comment='') business_license_range = Column(Text, comment='') business_license_first_date = Column(DateTime, comment='') business_license_gov = Column(String, default='', server_default='', comment='') is_business_license = Column(Integer, default='0', server_default='0', comment='') is_use_license = Column(Integer, default='0', server_default='0', comment='') use_license_code = Column(Text, comment='') use_license_begin = Column(DateTime, comment='') use_license_end = Column(DateTime, comment='') use_license_first_date = Column(DateTime, comment='') use_license_gov = Column(Text, comment='') safety_license_gov = Column(String, default='', server_default='', comment='') safety_standard_code = Column(String, default='', server_default='', comment='') safety_standard_auth_date = Column(DateTime, comment='') safety_standard_auth_machiner = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseCompanyIndustry(Base): __tablename__ = 'danger_base_company_industry' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') chemical_industry_code = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseCompanyKeyIndustry(Base): __tablename__ = 'danger_base_company_keyindustry' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') key_industry_code = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseCompanyChemical(Base): __tablename__ = 'danger_base_company_chemical' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') chemical_name = Column(String, default='', server_default='', comment='') chemical_alias = Column(String, default='', server_default='', comment='') chemical_type = Column(Integer, default='0', server_default='0', comment='') cas = Column(String, default='', server_default='', comment='') capacity = Column(String, default='', server_default='', comment='') capacity_gas = Column(String, default='', server_default='', comment='') reserve = Column(String, default='', server_default='', comment='') reserve_gas = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseCompanyCrafts(Base): __tablename__ = 'danger_base_company_crafts' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') process_code = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseCertificateInfo(Base): __tablename__ = 'danger_base_certificate_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') cert_name = Column(String, default='', server_default='', comment='') cert_type = Column(String, default='', server_default='', comment='') send_time = Column(DateTime, comment='') over_time = Column(DateTime, comment='') is_valid = Column(Integer, default='1', server_default='1', comment='') next_checktime = Column(DateTime, comment='') cert_file = Column(Text, comment='') class Config: orm_mode = True class DangerBaseDeviceInfo(Base): __tablename__ = 'danger_base_device_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') device_code = Column(String, default='', server_default='', comment='') device_name = Column(String, default='', server_default='', comment='') device_type = Column(Integer, default='1', server_default='1', comment='') throw_in_time = Column(String, default='', server_default='', comment='') last_inspect_time = Column(String, default='', server_default='', comment='') last_inspect_result = Column(String, default='', server_default='', comment='') next_inspect_time = Column(String, default='', server_default='', comment='') last_inspect_name = Column(String, default='', server_default='', comment='') is_special = Column(Integer, default='1', server_default='1', comment='') last_inspect_file = Column(String, default='', server_default='', comment='') address = Column(String, default='', server_default='', comment='') use_years = Column(Integer, comment='') use_status = Column(Integer, comment='') describe = Column(Text, comment='') class Config: orm_mode = True class DangerBaseDeviceSpecial(Base): __tablename__ = 'danger_base_device_special' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') device_id = Column(String, default='', server_default='', comment='') reg_date = Column(DateTime, comment='') reg_file = Column(Text, comment='') list_file = Column(Text, comment='') class Config: orm_mode = True class DangerBaseDeviceSafetyValve(Base): __tablename__ = 'danger_base_device_safety_valve' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') device_id = Column(String, default='', server_default='', comment='') list_file = Column(Text,comment='') check_file = Column(Text, comment='') class Config: orm_mode = True class DangerBaseDeviceBurst(Base): __tablename__ = 'danger_base_device_burst' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') device_id = Column(String, default='', server_default='', comment='') list_file = Column(Text,comment='') change_file = Column(Text, comment='') class Config: orm_mode = True class DangerBaseDeviceInstrument(Base): __tablename__ = 'danger_base_device_instrument' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') device_id = Column(String, default='', server_default='', comment='') file = Column(Text,comment='') class Config: orm_mode = True class DangerProcessInfo(Base): __tablename__ = 'danger_process_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') hazard_code = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') type = Column(String, default='', server_default='', comment='') introduce = Column(Text, comment='') features = Column(Text, comment='') important_process = Column(String, default='', server_default='', comment='') important_unit = Column(String, default='', server_default='', comment='') important_unit_type = Column(String, default='', server_default='', comment='') msds = Column(Text, comment='') safety_control = Column(Text, comment='') safety_control_type = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseStaffInfo(Base): __tablename__ = 'danger_base_staff_info' id = Column(String, primary_key=True) type = Column(Integer, default='1', server_default='1', comment='') credit_code = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') job_code = Column(String, default='', server_default='', comment='') birth_date = Column(DateTime, comment='') idcard = Column(String, default='', server_default='', comment='') mobile = Column(String, default='', server_default='', comment='') gender = Column(Integer, default='1', server_default='1', comment='') department_name = Column(String, default='', server_default='', comment='') last_grad_college = Column(String, default='', server_default='', comment='') duties = Column(String, default='', server_default='', comment='') station = Column(String, default='', server_default='', comment='') professional = Column(String, default='', server_default='', comment='') education = Column(Integer, default='1', server_default='1', comment='') entry_date = Column(DateTime, comment='') personnel_type = Column(Integer, default='1', server_default='1', comment='') profession_type = Column(String, default='', server_default='', comment='') user_category = Column(String, default='', server_default='', comment='') majortype = Column(Integer, default='0', server_default='0', comment='') chemical_diploma = Column(Integer, default='0', server_default='0', comment='') is_safety_produce_manage_people = Column(Integer, default='0', server_default='0', comment='') is_security_builder_people = Column(Integer, default='0', server_default='0', comment='') is_working_people = Column(Integer, default='0', server_default='0', comment='') is_register_security_people = Column(Integer, default='0', server_default='0', comment='') security_certi_name = Column(String, default='', server_default='', comment='') security_certi_num = Column(String, default='', server_default='', comment='') security_first_issu_date = Column(String, comment='') security_eff_stime = Column(String, comment='') security_eff_etime = Column(String, comment='') status = Column(Integer, default='1', server_default='1', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDutyInfo(Base): __tablename__ = 'danger_base_duty_info' id = Column(String, primary_key=True) type = Column(Integer, default='1', server_default='1', comment='') credit_code = Column(String, default='', server_default='', comment='') park_code = Column(String, default='', server_default='', comment='') park_worker_name = Column(String, default='', server_default='', comment='') worker_type = Column(String, default='', server_default='', comment='') park_position_name = Column(String, default='', server_default='', comment='') park_worker_job_number = Column(String, default='', server_default='', comment='') leader_mobile = Column(String, default='', server_default='', comment='') leader_phone = Column(String, default='', server_default='', comment='') park_worker_work_time = Column(DateTime, comment='') park_worker_leave_time = Column(DateTime, comment='') park_worker_status = Column(Integer, default='1', server_default='1', comment='') watch_records = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseCompanyAccident(Base): __tablename__ = 'danger_base_company_accident' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') accident_id = Column(String, default='', server_default='', comment='') accident_name = Column(String, default='', server_default='', comment='') accident_source = Column(Integer, comment='') type_of_accident = Column(String, default='', server_default='', comment='') accident_level = Column(Integer, comment='') longitude = Column(String, default='', server_default='', comment='') latitude = Column(String, default='', server_default='', comment='') death_toll = Column(Integer, comment='') seriously_injured_number = Column(Integer, comment='') minor_injuries_number = Column(Integer, comment='') accident_description = Column(Text, comment='') disposition_status = Column(Integer, comment='') registration_status = Column(Integer, comment='') reporting_time = Column(DateTime, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseVideoInfo(Base): __tablename__ = 'danger_base_video_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') hazard_code = Column(String, default='', server_default='', comment='') video_code = Column(String, default='', server_default='', comment='') video_name = Column(String, default='', server_default='', comment='') video_type = Column(Integer, comment='') longitude = Column(String, default='', server_default='', comment='') latitude = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceDetect(Base): __tablename__ = 'danger_base_device_detect' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') hazard_code = Column(String, default='', server_default='', comment='') equip_name = Column(String, default='', server_default='', comment='') equip_describe = Column(Text, comment='') equip_type = Column(String, default='', server_default='', comment='') equip_status = Column(Integer, comment='') longitude = Column(String, default='', server_default='', comment='') latitude = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceTank(Base): __tablename__ = 'danger_base_device_tank' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') tank_type = Column(String, default='', server_default='', comment='') pressure_type = Column(String, default='', server_default='', comment='') pressure_desing = Column(String, default='', server_default='', comment='') pressure_max = Column(String, default='', server_default='', comment='') temperature_type = Column(String, default='', server_default='', comment='') temprature_min = Column(String, default='', server_default='', comment='') temprature_max = Column(String, default='', server_default='', comment='') medium = Column(Text, comment='') medium_status = Column(String, default='', server_default='', comment='') reserves = Column(String, default='', server_default='', comment='') liquid_level = Column(String, default='', server_default='', comment='') liquid_level_unit = Column(Integer, comment='') build_date = Column(DateTime, comment='') use_date = Column(DateTime, comment='') maintenance_date = Column(DateTime, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceSystem(Base): __tablename__ = 'danger_base_device_system' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') chemprocess_type = Column(String, default='', server_default='', comment='') interlocking_count = Column(Integer, comment='') main_switch_status_target_code = Column(String, default='', server_default='', comment='') bypass_switch_total_target_code = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceGas(Base): __tablename__ = 'danger_base_device_gas' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') monitor_type = Column(Integer, comment='') monitor_gas = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceStore(Base): __tablename__ = 'danger_base_device_store' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') build_date = Column(DateTime, comment='') start_date = Column(DateTime, comment='') floor_area = Column(String, default='', server_default='', comment='') store_type = Column(String, default='', server_default='', comment='') design_reserve = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceDock(Base): __tablename__ = 'danger_base_device_dock' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') build_date = Column(DateTime, comment='') start_date = Column(DateTime, comment='') store_type = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceStop(Base): __tablename__ = 'danger_base_device_stop' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') hazard_code = Column(String, default='', server_default='', comment='') stop_date = Column(DateTime, comment='') plan_enable_date = Column(DateTime, comment='') enable_date = Column(DateTime, comment='') stop_type = Column(Integer, comment='') stop_reason = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceMedium(Base): __tablename__ = 'danger_base_device_medium' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') medium = Column(String, default='', server_default='', comment='') alias = Column(String, default='', server_default='', comment='') medium_status = Column(Integer, comment='') cas = Column(String, default='', server_default='', comment='') reserves = Column(String, default='', server_default='', comment='') is_fill_component = Column(Integer, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceMediumGroup(Base): __tablename__ = 'danger_base_device_medium_group' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') medium_id = Column(String, default='', server_default='', comment='') medium = Column(String, default='', server_default='', comment='') alias = Column(String, default='', server_default='', comment='') cas = Column(String, default='', server_default='', comment='') concentration = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseMediumMenu(Base): __tablename__ = 'danger_base_medium_menu' id = Column(String, primary_key=True) medium = Column(String, default='', server_default='', comment='') alias = Column(String, default='', server_default='', comment='') cas = Column(String, default='', server_default='', comment='') description = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseCompanySupervise(Base): __tablename__ = 'danger_base_company_supervise' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') plant_code = Column(String, default='', server_default='', comment='') plant_name = Column(String, default='', server_default='', comment='') project_name = Column(String, default='', server_default='', comment='') project_type = Column(Integer, default='1', server_default='1', comment='') project_begin_date = Column(DateTime, comment='') project_end_date = Column(DateTime, comment='') project_desc = Column(Text, comment='') project_status = Column(Integer, default='0', server_default='0', comment='') approval_apply_for_date = Column(DateTime, comment='') approval_pass_date = Column(DateTime, comment='') design_begin_date = Column(DateTime, comment='') design_end_date = Column(DateTime, comment='') build_begin_date = Column(DateTime, comment='') build_end_date = Column(DateTime, comment='') test_production_begin_date = Column(DateTime, comment='') test_production_end_date = Column(DateTime, comment='') acceptance_begin_date = Column(DateTime, comment='') acceptance_end_date = Column(DateTime, comment='') approval_status = Column(Integer, default='0', server_default='0', comment='') design_status = Column(Integer, default='0', server_default='0', comment='') build_status = Column(Integer, default='0', server_default='0', comment='') test_production_status = Column(Integer, default='0', server_default='0', comment='') acceptance_status = Column(Integer, default='0', server_default='0', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceSystemMaintenance(Base): __tablename__ = 'danger_base_device_system_maintenance' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') plant_code = Column(String, default='', server_default='', comment='') plant_name = Column(String, default='', server_default='', comment='') device_owner = Column(String, default='', server_default='', comment='') device_owner_tel = Column(String, default='', server_default='', comment='') check_name = Column(String, default='', server_default='', comment='') check_content = Column(String, default='', server_default='', comment='') check_start = Column(DateTime, comment='') check_end_plan = Column(DateTime, comment='') check_end = Column(DateTime, comment='') check_owner = Column(String, default='', server_default='', comment='') check_owner_tel = Column(String, default='', server_default='', comment='') plan_status = Column(Integer, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseDeviceSystemStartstop(Base): __tablename__ = 'danger_base_device_system_startstop' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') plant_code = Column(String, default='', server_default='', comment='') plant_name = Column(String, default='', server_default='', comment='') start_stop_type = Column(Integer, comment='') operation_status = Column(Integer, comment='') start_time = Column(DateTime, comment='') expire_time = Column(DateTime, comment='') end_time = Column(DateTime, comment='') responsible_person = Column(String, default='', server_default='', comment='') responsible_person_tel = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseThirdCompany(Base): __tablename__ = 'danger_base_third_company' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') certificateno = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') type = Column(Integer, comment='') service_type = Column(Integer, comment='') legal_person = Column(String, default='', server_default='', comment='') qualifications = Column(String, default='', server_default='', comment='') responsible_person = Column(String, default='', server_default='', comment='') responsible_mobile = Column(String, default='', server_default='', comment='') addr = Column(String, default='', server_default='', comment='') status = Column(Integer, comment='') area_code = Column(String, default='', server_default='', comment='') description = Column(Text, comment='') service_start = Column(String, default='', server_default='', comment='') service_end = Column(String, default='', server_default='', comment='') business_license = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseThirdStaff(Base): __tablename__ = 'danger_base_third_staff' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') certificateno = Column(String, default='', server_default='', comment='') username = Column(String, default='', server_default='', comment='') person_code = Column(String, default='', server_default='', comment='') age = Column(Integer, comment='') idcard = Column(String, default='', server_default='', comment='') mobile = Column(String, default='', server_default='', comment='') gender = Column(Integer, comment='') is_black_list = Column(Integer, comment='') description = Column(Text, comment='') department_name = Column(String, default='', server_default='', comment='') duties = Column(String, default='', server_default='', comment='') station = Column(String, default='', server_default='', comment='') high_risk_position = Column(Integer, comment='') person_picture = Column(Text, comment='') professional = Column(String, default='', server_default='', comment='') education = Column(Integer, comment='') work_life = Column(Integer, comment='') personnel_type = Column(String, default='', server_default='', comment='') profession_type = Column(String, default='', server_default='', comment='') user_category = Column(String, default='', server_default='', comment='') majortype = Column(String, default='', server_default='', comment='') is_safety_produce_manage_people = Column(Integer, comment='') is_security_builder_people = Column(Integer, comment='') is_working_people = Column(Integer, comment='') is_register_security_people = Column(Integer, comment='') status = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseThirdStaffCertificate(Base): __tablename__ = 'danger_base_third_staff_certificate' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') certificateno = Column(String, default='', server_default='', comment='') cert_code = Column(String, default='', server_default='', comment='') cert_name = Column(String, default='', server_default='', comment='') is_valid = Column(Integer, comment='') certificate_level = Column(String, default='', server_default='', comment='') cert_type = Column(String, default='', server_default='', comment='') send_time = Column(DateTime, comment='') over_time = Column(DateTime, comment='') next_checktime = Column(DateTime, comment='') cert_file = Column(String, default='', server_default='', comment='') username = Column(String, default='', server_default='', comment='') idcard = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseThirdCompanyCertificate(Base): __tablename__ = 'danger_base_third_company_certificate' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') certificateno = Column(String, default='', server_default='', comment='') code = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') level = Column(String, default='', server_default='', comment='') starttime = Column(DateTime, comment='') endtime = Column(DateTime, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseThirdStaffTrain(Base): __tablename__ = 'danger_base_third_staff_train' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') certificateno = Column(String, default='', server_default='', comment='') train_name = Column(String, default='', server_default='', comment='') traintime = Column(DateTime, comment='') train_content = Column(Text, comment='') training_type = Column(Integer, comment='') person_code = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') id_number = Column(String, default='', server_default='', comment='') training_result = Column(Integer, comment='') qualified = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseThirdViolation(Base): __tablename__ = 'danger_base_third_violation' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') certificateno = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') place = Column(String, default='', server_default='', comment='') violation_time = Column(DateTime, comment='') type = Column(String, default='', server_default='', comment='') violation_content = Column(Text, comment='') dispose_process = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerBaseThirdServe(Base): __tablename__ = 'danger_base_third_serve' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') certificateno = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') serve_time = Column(DateTime, comment='') type = Column(String, default='', server_default='', comment='') serve_content = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerManagerPromise(Base): __tablename__ = 'danger_manager_promise' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') commit_date = Column(DateTime, comment='') units_number = Column(Integer, default='0', server_default='0', comment='') run_number = Column(Integer, default='0', server_default='0', comment='') park_number = Column(Integer, default='0', server_default='0', comment='') fires_number = Column(Integer, default='0', server_default='0', comment='') fire1_number = Column(Integer, default='0', server_default='0', comment='') fire2_number = Column(Integer, default='0', server_default='0', comment='') roadwork_number = Column(Integer, default='0', server_default='0', comment='') soilwork_number = Column(Integer, default='0', server_default='0', comment='') highwork_number = Column(Integer, default='0', server_default='0', comment='') electricitywork_number = Column(Integer, default='0', server_default='0', comment='') liftingwork_number = Column(Integer, default='0', server_default='0', comment='') blindplate_number = Column(Integer, default='0', server_default='0', comment='') spacework_number = Column(Integer, default='0', server_default='0', comment='') inspection_number = Column(Integer, default='0', server_default='0', comment='') pour_out_number = Column(Integer, default='0', server_default='0', comment='') clean_tank_number = Column(Integer, default='0', server_default='0', comment='') draining_number = Column(Integer, default='0', server_default='0', comment='') contractor_number = Column(Integer, default='0', server_default='0', comment='') changed_task_number = Column(Integer, default='0', server_default='0', comment='') contractor = Column(Integer, default='0', server_default='0', comment='') trial_production = Column(Integer, default='0', server_default='0', comment='') open_parking = Column(Integer, default='0', server_default='0', comment='') open_parking_number = Column(Integer, default='0', server_default='0', comment='') work_number = Column(Integer, default='0', server_default='0', comment='') not_work_number = Column(Integer, default='0', server_default='0', comment='') test = Column(Integer, default='0', server_default='0', comment='') test_number = Column(Integer, default='0', server_default='0', comment='') overhaul_work_number = Column(Integer, default='0', server_default='0', comment='') danger_process_number = Column(Integer, default='0', server_default='0', comment='') m_hazards = Column(Integer, default='0', server_default='0', comment='') risk_grade = Column(Integer, default='0', server_default='0', comment='') commitment = Column(String, default='', server_default='', comment='') commit_content = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerWarnEvent(Base): __tablename__ = 'danger_warn_event' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') reason = Column(Text, comment='') measure = Column(Text, comment='') message = Column(Text, comment='') start_time = Column(DateTime, comment='') rank = Column(Integer, default='0', server_default='0', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerSourceEvaluation(Base): __tablename__ = 'danger_source_evaluation' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') hazard_code = Column(String, default='', server_default='', comment='') certificate_type = Column(Integer, default='0', server_default='0', comment='') file = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') regtime = Column(DateTime, comment='') endtime = Column(DateTime, comment='') organization_name = Column(String, default='', server_default='', comment='') agent_name = Column(String, default='', server_default='', comment='') contact_phone = Column(String, default='', server_default='', comment='') is_deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerSourceInfo(Base): __tablename__ = 'danger_source_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') short_name = Column(String, default='', server_default='', comment='') area_code = Column(String, default='', server_default='', comment='') code = Column(String, default='', server_default='', comment='') type = Column(String, default='', server_default='', comment='') level = Column(String, default='', server_default='', comment='') rvalue = Column(String, default='', server_default='', comment='') address = Column(Text, comment='') lng = Column(String, default='', server_default='', comment='') lat = Column(String, default='', server_default='', comment='') use_time = Column(DateTime, comment='') include_platform = Column(Integer, comment='') content = Column(Text, comment='') factory = Column(String, default='', server_default='', comment='') distance = Column(Float, default='0', server_default='0', comment='') people_500m = Column(Integer, comment='') is_inpark = Column(Integer, default='0', server_default='0', comment='') park_name = Column(String, default='', server_default='', comment='') produce_ability = Column(String, default='', server_default='', comment='') is_hazard_crafts = Column(String, default='', server_default='', comment='') hazard_crafts = Column(String, default='', server_default='', comment='') responsible = Column(String, default='', server_default='', comment='') responsible_phone = Column(String, default='', server_default='', comment='') responsible_post = Column(String, default='', server_default='', comment='') technical = Column(String, default='', server_default='', comment='') technical_phone = Column(String, default='', server_default='', comment='') technical_post = Column(String, default='', server_default='', comment='') operation = Column(String, default='', server_default='', comment='') operation_phone = Column(String, default='', server_default='', comment='') operation_post = Column(String, default='', server_default='', comment='') accident = Column(Text, comment='') people_num = Column(String, default='', server_default='', comment='') area = Column(String, default='', server_default='', comment='') high_count = Column(String, default='', server_default='', comment='') point_json = Column(Text, comment='') status = Column(Integer, default='0', server_default='0', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerMonitorInfo(Base): __tablename__ = 'danger_monitor_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') target_code = Column(String, default='', server_default='', comment='') equip_code = Column(String, default='', server_default='', comment='') target_name = Column(String, default='', server_default='', comment='') target_type = Column(String, default='', server_default='', comment='') unit = Column(String, default='', server_default='', comment='') parameter_desc = Column(String, default='', server_default='', comment='') threshold_up = Column(String, default='', server_default='', comment='') threshold_up2 = Column(String, default='', server_default='', comment='') threshold_down = Column(String, default='', server_default='', comment='') threshold_down2 = Column(String, default='', server_default='', comment='') range_up = Column(String, default='', server_default='', comment='') range_down = Column(String, default='', server_default='', comment='') tag_code = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerMonitorData(Base): __tablename__ = 'danger_monitor_data' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') target_code = Column(String, default='', server_default='', comment='') gateway_id = Column(String, default='', server_default='', comment='') collect_time = Column(DateTime, comment='') is_connect_data_source = Column(String, default='', server_default='', comment='') report_type = Column(String, default='', server_default='', comment='') value = Column(String, default='', server_default='', comment='') is_valid = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerMonitorAlarm(Base): __tablename__ = 'danger_monitor_alarm' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') target_code = Column(String, default='', server_default='', comment='') gateway_id = Column(String, default='', server_default='', comment='') collect_time = Column(DateTime, comment='') is_connect_data_source = Column(String, default='', server_default='', comment='') report_type = Column(String, default='', server_default='', comment='') value = Column(String, default='', server_default='', comment='') alarm_type = Column(String, default='', server_default='', comment='') threshold = Column(String, default='', server_default='', comment='') alarm_time = Column(DateTime, comment='') class Config: orm_mode = True class DangerMonitorVideo(Base): __tablename__ = 'danger_monitor_video' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') video_code = Column(String, default='', server_default='', comment='') video_alarm_type = Column(String, default='', server_default='', comment='') alarm_start_time = Column(DateTime, comment='') alarm_end_time = Column(DateTime, comment='') alarm_picture = Column(Text, comment='') alarm_video = Column(Text, comment='') alarm_status = Column(Integer, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerSourceWarning(Base): __tablename__ = 'danger_source_warning' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') hazard_code = Column(String, default='', server_default='', comment='') type = Column(Text, comment='') content = Column(Text, comment='') handler = Column(Text, comment='') class Config: orm_mode = True class DangerSourceProblem(Base): __tablename__ = 'danger_source_problem' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') hd_level = Column(String, default='', server_default='', comment='') check_according = Column(String, default='', server_default='', comment='') check_style = Column(String, default='', server_default='', comment='') fit_place = Column(String, default='', server_default='', comment='') deduct_score = Column(String, default='', server_default='', comment='') check_type = Column(String, default='', server_default='', comment='') type = Column(Text, comment='') content = Column(Text, comment='') date = Column(DateTime, comment='') neaten_limit_date = Column(DateTime, comment='') change_date = Column(DateTime, comment='') neaten_situation = Column(String, default='', server_default='', comment='') problem_status = Column(Integer, comment='') class Config: orm_mode = True class DangerSourceTakes(Base): __tablename__ = 'danger_source_takes' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') hazard_code = Column(String, default='', server_default='', comment='') responsible_type = Column(Integer, default=0, server_default='0', comment='') responsible = Column(String, default='', server_default='', comment='') responsible_phone = Column(String, default='', server_default='', comment='') responsible_post = Column(String, default='', server_default='', comment='') responsible_duty = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerWorkerActivityInfo(Base): __tablename__ = 'danger_worker_activity_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') work_type = Column(String, default='', server_default='', comment='') start_time = Column(DateTime, comment='') end_time = Column(DateTime, comment='') work_location = Column(String, default='', server_default='', comment='') work_content = Column(Text, comment='') supervisor_name = Column(String, default='', server_default='', comment='') worker_name = Column(String, default='', server_default='', comment='') work_departmen = Column(String, default='', server_default='', comment='') person_id = Column(String, default='', server_default='', comment='') social_credit_code = Column(Text, comment='') work_principal = Column(String, default='', server_default='', comment='') work_principal_mobile = Column(String, default='', server_default='', comment='') is_contractor_work = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerWorkerTicketInfo(Base): __tablename__ = 'danger_worker_ticket_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') job_id = Column(String, default='', server_default='', comment='') work_type = Column(Integer, comment='') work_no = Column(String, default='', server_default='', comment='') work_dept = Column(String, default='', server_default='', comment='') user_name = Column(String, default='', server_default='', comment='') work_date = Column(DateTime, comment='') supervisor_id = Column(Text, comment='') worker_id = Column(Text, comment='') work_status = Column(Integer, comment='') work_content = Column(Text, comment='') work_location = Column(String, default='', server_default='', comment='') work_lat = Column(String, default='', server_default='', comment='') work_lng = Column(String, default='', server_default='', comment='') work_unit = Column(Text, comment='') work_credit_code = Column(Text, comment='') is_contractor_work = Column(String, default='', server_default='', comment='') work_principal = Column(String, default='', server_default='', comment='') work_principal_mobile = Column(String, default='', server_default='', comment='') issue_time = Column(DateTime, comment='') starttime = Column(DateTime, comment='') endtime = Column(DateTime, comment='') checked_time = Column(DateTime, comment='') identify_result = Column(Integer, comment='') other_work_type = Column(String, default='', server_default='', comment='') measure_editor = Column(String, default='', server_default='', comment='') ext_data = Column(Text, comment='') work_file = Column(String, default='', server_default='', comment='') ticket_status = Column(String, default='', server_default='', comment='') is_changed = Column(String, default='', server_default='', comment='') changed_cause = Column(Text, comment='') is_cancelled = Column(String, default='', server_default='', comment='') cancelled_cause = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerWorkerJsaAnalysis(Base): __tablename__ = 'danger_worker_jsa_analysis' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') work_no = Column(String, default='', server_default='', comment='') job_step = Column(Integer, comment='') hazard_factor = Column(Text, comment='') result_in = Column(Text, comment='') control_measures = Column(Text, comment='') type = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerWorkerTicketVideo(Base): __tablename__ = 'danger_worker_ticket_video' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') work_no = Column(String, default='', server_default='', comment='') video_code = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerInspectionPlanInfo(Base): __tablename__ = 'danger_inspection_plan_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') status = Column(Integer, comment='') plan_name = Column(String, default='', server_default='', comment='') plan_type = Column(Integer, comment='') frequency_type = Column(Integer, comment='') plan_num = Column(Integer, comment='') user_role = Column(String, default='', server_default='', comment='') plan_objective = Column(String, default='', server_default='', comment='') fault_tolerant_time = Column(Integer, comment='') replenish_time = Column(Integer, comment='') plan_start_time = Column(DateTime, comment='') plan_stop_time = Column(DateTime, comment='') cross_switch = Column(String, default='', server_default='', comment='') plan_create_time = Column(DateTime, comment='') class Config: orm_mode = True class DangerInspectionPlanPoint(Base): __tablename__ = 'danger_inspection_plan_point' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') status = Column(Integer, comment='') plan_id = Column(String, default='', server_default='', comment='') point_name = Column(String, default='', server_default='', comment='') lon = Column(String, default='', server_default='', comment='') lat = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerInspectionPlanRule(Base): __tablename__ = 'danger_inspection_plan_rule' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') status = Column(Integer, comment='') name = Column(String, default='', server_default='', comment='') check_position = Column(String, default='', server_default='', comment='') category = Column(Integer, comment='') seltext = Column(Text, comment='') mode = Column(Text, comment='') maxdata = Column(Float, comment='') mindata = Column(Float, comment='') photo_switch = Column(Integer, comment='') data_switch = Column(Integer, comment='') class Config: orm_mode = True class DangerInspectionPlanObj(Base): __tablename__ = 'danger_inspection_plan_obj' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') status = Column(Integer, comment='') name = Column(String, default='', server_default='', comment='') rule_id = Column(String, default='', server_default='', comment='') rule_name = Column(String, default='', server_default='', comment='') point_id = Column(String, default='', server_default='', comment='') system_code = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerInspectionTaskInfo(Base): __tablename__ = 'danger_inspection_task_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') status = Column(Integer, comment='') plan_id = Column(String, default='', server_default='', comment='') user_name = Column(String, default='', server_default='', comment='') user_department_name = Column(String, default='', server_default='', comment='') task_start_time = Column(DateTime, comment='') task_end_time = Column(DateTime, comment='') trigger_start_time = Column(DateTime, comment='') trigger_end_time = Column(DateTime, comment='') result_status = Column(Integer, comment='') class Config: orm_mode = True class DangerInspectionTaskRecord(Base): __tablename__ = 'danger_inspection_task_record' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') name = Column(String, default='', server_default='', comment='') status = Column(Integer, comment='') plan_id = Column(String, default='', server_default='', comment='') user_name = Column(String, default='', server_default='', comment='') task_id = Column(String, default='', server_default='', comment='') point_id = Column(String, default='', server_default='', comment='') point_name = Column(String, default='', server_default='', comment='') obj_id = Column(String, default='', server_default='', comment='') obj_name = Column(String, default='', server_default='', comment='') obj_type = Column(String, default='', server_default='', comment='') check_id = Column(String, default='', server_default='', comment='') user_role = Column(String, default='', server_default='', comment='') check_start_time = Column(DateTime, comment='') check_end_time = Column(DateTime, comment='') check_rule = Column(Text, comment='') check_value = Column(String, default='', server_default='', comment='') check_details = Column(Text, comment='') check_file = Column(Text, comment='') check_result = Column(Integer, comment='') rectification_time = Column(DateTime, comment='') rectification_content = Column(Text, comment='') rectification_result = Column(Integer, comment='') class Config: orm_mode = True class DangerInspectionTaskStatistics(Base): __tablename__ = 'danger_inspection_task_statistics' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') count_type = Column(String, default='', server_default='', comment='') total_task = Column(Integer, comment='') finish_task = Column(Integer, comment='') miss_task = Column(Integer, comment='') append_task = Column(Integer, comment='') problem_task = Column(Integer, comment='') rectify_task = Column(Integer, comment='') not_rectify_task = Column(Integer, comment='') start_time = Column(DateTime, comment='') end_time = Column(DateTime, comment='') class Config: orm_mode = True class DangerLocationZoneInfo(Base): __tablename__ = 'danger_location_zone_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') zone_type = Column(Integer, comment='') zone_name = Column(String, default='', server_default='', comment='') geo = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerLocationPersonInfo(Base): __tablename__ = 'danger_location_person_info' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') person_id = Column(String, default='', server_default='', comment='') time = Column(DateTime, comment='') lat = Column(String, default='', server_default='', comment='') lon = Column(String, default='', server_default='', comment='') altitude = Column(String, default='', server_default='', comment='') floor = Column(String, default='', server_default='', comment='') speed = Column(String, default='', server_default='', comment='') direction = Column(String, default='', server_default='', comment='') device_code = Column(String, default='', server_default='', comment='') zone_id = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerLocationPersonArea(Base): __tablename__ = 'danger_location_person_area' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') time = Column(DateTime, comment='') alarm_area = Column(JSON, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerLocationPersonAlarm(Base): __tablename__ = 'danger_location_person_alarm' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') person_id = Column(String, default='', server_default='', comment='') zone_id = Column(String, default='', server_default='', comment='') time = Column(DateTime, comment='') lat = Column(String, default='', server_default='', comment='') lon = Column(String, default='', server_default='', comment='') alarm_type = Column(Integer, comment='') dispel_time = Column(DateTime, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerLocationZoneAlarm(Base): __tablename__ = 'danger_location_zone_alarm' id = Column(String, primary_key=True) credit_code = Column(String, default='', server_default='', comment='') zone_id = Column(String, default='', server_default='', comment='') time = Column(DateTime, comment='') lat = Column(String, default='', server_default='', comment='') lon = Column(String, default='', server_default='', comment='') alarm_type = Column(Integer, comment='') dispel_time = Column(DateTime, comment='') describe = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerTopinfoInsularVisitorInfo(Base): __tablename__ = 'danger_topinfo_insular_visitor_info' id = Column(String, primary_key=True) staff_code = Column(String, default='', server_default='', comment='') staff_name = Column(String, default='', server_default='', comment='') staff_type = Column(Integer, default='0', server_default='0', comment='') affiliation = Column(String, default='', server_default='', comment='') staff_position = Column(String, default='', server_default='', comment='') staff_gender = Column(Integer, default='0', server_default='0', comment='') staff_major = Column(String, default='', server_default='', comment='') id_card = Column(String, default='', server_default='', comment='') papers = Column(String, default='', server_default='', comment='') telephone = Column(String, default='', server_default='', comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerTopinfoInsularOtherCarInfo(Base): __tablename__ = 'danger_topinfo_insular_other_car_info' id = Column(String, primary_key=True) license_plate = Column(String, default='', server_default='', comment='') license_plate_color = Column(String, default='', server_default='', comment='') driver_name = Column(String, default='', server_default='', comment='') driver_id_card = Column(String, default='', server_default='', comment='') driving_license = Column(String, default='', server_default='', comment='') len_start_date = Column(DateTime, comment='') len_end_date = Column(DateTime, comment='') whether_len = Column(Integer, comment='') company_code = Column(String, default='', server_default='', comment='') vehicle_type = Column(Integer, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True class DangerTopinfoInsularEmergenceRecord(Base): __tablename__ = 'danger_topinfo_insular_emergence_record' id = Column(String, primary_key=True) record_id = Column(String, default='', server_default='', comment='') emergence_drill_name = Column(String, default='', server_default='', comment='') drill_type = Column(Integer, comment='') plan_id = Column(String, default='', server_default='', comment='') drill_start = Column(DateTime, comment='') drill_end = Column(DateTime, comment='') partic_num = Column(Integer, comment='') drill_process = Column(Text, comment='') drill_estimate = Column(String, default='', server_default='', comment='') problem = Column(String, default='', server_default='', comment='') improve_meansure = Column(String, default='', server_default='', comment='') drill_plan = Column(String, default='', server_default='', comment='') drill_assement_report = Column(Text, comment='') drill_script = Column(Text, comment='') deleted = Column(String, default='', server_default='', comment='') create_date = Column(DateTime, default=datetime.now, comment='') create_by = Column(String, default='', server_default='', comment='') update_date = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='') update_by = Column(String, default='', server_default='', comment='') class Config: orm_mode = True