python-fastapi-mm-zhcs-yj-api/models/danger_base.py

# -*- 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