from sqlalchemy import Column, String, Integer, Boolean, Date, Text, DateTime, Float
from lib.Stech import Stech

class ReportesPatente(Stech.Base):
    __tablename__ = 'reportes_patente'


    rpat_id = Column(Integer, primary_key=True)
    id_usuario = Column(Integer)
    group_id = Column(Integer)
    rpat_name = Column(String(50))
    rpat_desc = Column(String(1024))
    rpat_img = Column(String(1024))
    rpat_visible = Column(String(5))
    rpat_lat = Column(Float)
    rpat_lng = Column(Float)
    actualizado_en = Column(Date)
    rpat_rutresp = Column(String(255))
    fecha_reporte = Column(Date)
    notificado = Column(Integer)
    id_comuna = Column(Integer)
    rpat_dir = Column(String(255))
    rpat_confirmado = Column(Integer)
    rpat_info = Column(Text)
    rpat_valido = Column(Boolean)