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

# -*- coding: utf-8 -*-
from sqlalchemy import String, Column, Integer,DateTime,Text,BigInteger,Boolean,PrimaryKeyConstraint,Index,UniqueConstraint,CHAR,LargeBinary,TIMESTAMP,Float
from sqlalchemy.dialects.mysql import TINYINT
from sqlalchemy.sql import func
from database import Base
from datetime import datetime



class TpVideoLog(Base):
    __tablename__ = 'tp_video_log'

    name = Column(String(255, collation='utf8mb4_bin'), autoincrement=True, primary_key=True, nullable=True, default=None)
    area = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)
    ip = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)
    status = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)
    status_lifetime = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)
    record_status = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)
    inspection_datetime = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)
    video_code_int = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)
    video_code = Column(String(255, collation='utf8mb4_bin'), nullable=True, default=None)

    class Config:
        orm_mode = True


class TpVideoBase(Base):
    __tablename__ = 'tp_video_base'

    cameraid = Column(String(100), autoincrement=True, primary_key=True, nullable=True)
    indexcode = Column(String(100), nullable=True)
    name = Column(String(255), nullable=True)
    manufacturer = Column(String(50), nullable=True)
    model = Column(String(50), nullable=True)
    owner = Column(String(50), nullable=True)
    civilcode = Column(String(255), nullable=True)
    block = Column(String(100), nullable=True)
    address = Column(String(255), nullable=True)
    parental = Column(String(2), nullable=True)
    parentid = Column(String(255), nullable=True)
    safetyway = Column(String(2), nullable=True)
    registerway = Column(String(2), nullable=True)
    certnum = Column(String(2), nullable=True)
    certifiable = Column(String(2), nullable=True)
    errorcode = Column(String(10), nullable=True)
    endtime = Column(String(255), nullable=True)
    secrecy = Column(String(2), nullable=True)
    ipaddress = Column(String(255), nullable=True)
    port = Column(String(10), nullable=True)
    password = Column(String(10), nullable=True)
    status = Column(String(10), nullable=True)
    recordpos = Column(String(10), nullable=True)
    cameratype = Column(String(2), nullable=True)
    decodetag = Column(String(10), nullable=True)
    longitude = Column(Float, nullable=True)
    latitude = Column(Float, nullable=True)
    elevation = Column(String(5), nullable=True)
    targettype = Column(String(2), nullable=True)
    targetsubtype = Column(String(2), nullable=True)
    cascadeid = Column(String(10), nullable=True)
    cascadecode = Column(String(100), nullable=True)
    querystatus = Column(String(2), nullable=True)
    privilege = Column(String(5), nullable=True)
    updatatime = Column(String(255), nullable=True)
    elseex = Column(String(255), nullable=True)
    recordstate = Column(String(2), nullable=True)
    extrafield = Column(String(255), nullable=True)
    internalindexcode = Column(String(255), nullable=True)
    positioncode = Column(String(10), nullable=True)
    bstandard = Column(String(2), nullable=True)
    pushpath = Column(String(255), nullable=True)

    class Config:
        orm_mode = True

class TpVideoTag(Base):
    __tablename__ = 'tp_video_tag'

    id = Column(String(255), primary_key=True)
    video_code = Column(String(255), nullable=True, comment='视频编号')
    dict_value = Column(BigInteger, nullable=True, comment='字典映射值')
    dict_type = Column(BigInteger, nullable=True, comment='字典映射类型')
    del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    update_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='数据更新时间')
    create_dept = Column(BigInteger, default=None, comment='创建部门')
    create_by = Column(BigInteger, default=None, comment='创建者')
    update_by = Column(BigInteger, default=None, comment='更新者')
    class Config:
        orm_mode = True