# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from django.db import models


class Administracion(models.Model):
    conjunto = models.CharField(max_length=15)
    secuencia = models.IntegerField()
    cedula = models.CharField(max_length=12)
    cargo = models.CharField(max_length=6)
    nombres = models.CharField(max_length=50)
    apellidos = models.CharField(max_length=50)
    estado = models.CharField(max_length=3)
    fechacreacion = models.DateField()

    class Meta:
        managed = False
        db_table = 'administracion'
        unique_together = (('conjunto', 'secuencia', 'cedula'),)


class Administracionperiodo(models.Model):
    conjunto = models.CharField(max_length=15)
    secuencia = models.IntegerField()
    descripcion = models.CharField(max_length=100)
    fechaposesion = models.DateField()
    fechainicio = models.DateField()
    fechafin = models.DateField()
    estado = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'administracionperiodo'
        unique_together = (('conjunto', 'secuencia'),)


class Archivossubir(models.Model):
    conjunto = models.CharField(max_length=15)
    tipo = models.CharField(max_length=10)
    archivo = models.CharField(max_length=100)
    longitud = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'archivossubir'
        unique_together = (('conjunto', 'tipo'),)


class AuthGroup(models.Model):
    name = models.CharField(unique=True, max_length=150)

    class Meta:
        managed = False
        db_table = 'auth_group'


class AuthGroupPermissions(models.Model):
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)
    permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_group_permissions'
        unique_together = (('group', 'permission'),)


class AuthPermission(models.Model):
    name = models.CharField(max_length=255)
    codename = models.CharField(max_length=100)
    content_type_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'auth_permission'
        unique_together = (('content_type_id', 'codename'),)


class Bancos(models.Model):
    id = models.AutoField(db_column='ID', primary_key=True)  # Field name made lowercase.
    pais = models.CharField(max_length=3)
    codigo = models.CharField(max_length=10)
    descripcion = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'bancos'
        unique_together = (('pais', 'codigo'),)


class Cabeceracierreadmi(models.Model):
    conjunto = models.CharField(max_length=15)
    administracion = models.IntegerField()
    fechainicio_a = models.DateField()
    fechafin_a = models.DateField()
    fecha = models.DateField()
    usuario = models.CharField(max_length=20)
    estado = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'cabeceracierreadmi'
        unique_together = (('conjunto', 'administracion'),)


class Cabecerainteres(models.Model):
    conjunto = models.CharField(max_length=15)
    anio = models.IntegerField()
    mes = models.IntegerField()
    interesaplicado = models.DecimalField(max_digits=5, decimal_places=2)
    diasgracia = models.IntegerField()
    valortotal = models.DecimalField(max_digits=8, decimal_places=2)
    fecha = models.DateField()
    usuario = models.CharField(max_length=20)

    class Meta:
        managed = False
        db_table = 'cabecerainteres'
        unique_together = (('conjunto', 'anio', 'mes'),)


class Cambioclave(models.Model):
    conjunto = models.CharField(max_length=15)
    username = models.CharField(max_length=20)
    clave0 = models.CharField(max_length=256)
    clave1 = models.CharField(max_length=256)
    clave2 = models.CharField(max_length=256)

    class Meta:
        managed = False
        db_table = 'cambioclave'
        unique_together = (('conjunto', 'username'),)


class Cierreadministracion(models.Model):
    conjunto = models.CharField(max_length=15)
    administracion = models.IntegerField()
    tipo = models.CharField(max_length=10)
    codigo = models.CharField(max_length=6)
    descripcion = models.CharField(max_length=200)
    valor = models.DecimalField(max_digits=11, decimal_places=2)

    class Meta:
        managed = False
        db_table = 'cierreadministracion'
        unique_together = (('conjunto', 'administracion', 'tipo', 'codigo'),)


class Cierrescabecera(models.Model):
    conjunto = models.CharField(max_length=15)
    anio = models.IntegerField()
    mes = models.IntegerField()
    alicuota = models.CharField(max_length=6)
    administracion = models.IntegerField()
    afectacioninmueble = models.CharField(max_length=2)
    numerocondominos = models.IntegerField()
    numerozonas = models.IntegerField()
    numeroedificios = models.IntegerField()
    numeroinmuebles = models.IntegerField()
    valorrecargos = models.DecimalField(max_digits=10, decimal_places=2)
    valorcuota = models.DecimalField(max_digits=8, decimal_places=2)
    usuario = models.CharField(max_length=20)
    fecha = models.DateField()
    hora = models.TimeField(blank=True, null=True)
    usuariocierre = models.CharField(max_length=20, blank=True, null=True)
    fechacierre = models.DateField(blank=True, null=True)
    estado = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'cierrescabecera'
        unique_together = (('conjunto', 'anio', 'mes', 'alicuota'),)


class Ciudad(models.Model):
    ciudadid = models.IntegerField(db_column='CiudadID')  # Field name made lowercase.
    ciudadnombre = models.CharField(db_column='CiudadNombre', max_length=35)  # Field name made lowercase.
    paiscodigo = models.CharField(db_column='PaisCodigo', max_length=3)  # Field name made lowercase.
    ciudaddistrito = models.CharField(db_column='CiudadDistrito', max_length=20)  # Field name made lowercase.
    ciudadpoblacion = models.IntegerField(db_column='CiudadPoblacion')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'ciudad'
        unique_together = (('paiscodigo', 'ciudadid'),)


class Cobrorecargos(models.Model):
    conjunto = models.CharField(max_length=15)
    cedula = models.CharField(max_length=12)
    secuencia = models.IntegerField()
    anio = models.IntegerField()
    periodo = models.IntegerField()
    administracion = models.IntegerField()
    valorcobrado = models.DecimalField(max_digits=8, decimal_places=2)
    mediopago = models.CharField(max_length=5)
    banco = models.CharField(max_length=4)
    chequenumero = models.CharField(max_length=10)
    referencia = models.CharField(max_length=200)
    fechacobro = models.DateField()
    fechacreacion = models.DateField()
    usuario = models.CharField(max_length=20)
    secuenciareferente = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'cobrorecargos'
        unique_together = (('conjunto', 'secuencia'),)


class Condomino(models.Model):
    conjunto = models.CharField(max_length=15)
    cedula = models.CharField(max_length=12)
    nombres = models.CharField(max_length=50)
    apellidos = models.CharField(max_length=50)
    genero = models.CharField(max_length=10)
    correo_electronico = models.CharField(max_length=70)
    telefono = models.CharField(max_length=10)
    movil = models.CharField(max_length=12)
    fecha_nacimiento = models.DateField()
    estado_civil = models.CharField(max_length=10)
    integrantes = models.IntegerField()
    permitircorreo = models.IntegerField()
    permitirmsn = models.IntegerField()
    clave = models.CharField(max_length=128)
    activo = models.CharField(max_length=3)
    fecha_creacion = models.DateField()
    fecha_modificacion = models.DateField()
    fecha_eliminacion = models.DateField()

    class Meta:
        managed = False
        db_table = 'condomino'
        unique_together = (('conjunto', 'cedula'),)


class Condominoo(models.Model):
    conjunto = models.CharField(max_length=10)
    cedula = models.CharField(max_length=12)
    nombres = models.CharField(max_length=50)
    apellidos = models.CharField(max_length=50)
    genero = models.CharField(max_length=10)
    correo_electronico = models.CharField(max_length=70)
    telefono = models.CharField(max_length=10)
    movil = models.CharField(max_length=10)
    fecha_nacimiento = models.DateField()
    estado_civil = models.CharField(max_length=10)
    integrantes = models.IntegerField()
    saldo = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)
    clave = models.CharField(max_length=128)
    activo = models.CharField(max_length=3)
    fecha_creacion = models.DateField()
    fecha_modificacion = models.DateField()
    fecha_eliminacion = models.DateField()

    class Meta:
        managed = False
        db_table = 'condominoo'
        unique_together = (('conjunto', 'cedula'),)


class Conjunto(models.Model):
    codigo = models.CharField(unique=True, max_length=15)
    razon_social = models.CharField(max_length=100)
    fecha_constitucion = models.DateField()
    direccion = models.CharField(max_length=100)
    pais = models.CharField(max_length=4)
    ciudad = models.CharField(max_length=30)
    imagenconjunto = models.CharField(max_length=255, blank=True, null=True)
    observaciones = models.TextField(blank=True, null=True)
    estado_eliminacion = models.IntegerField()
    fecha_creacion = models.DateField()
    fecha_modificacion = models.DateField()
    fecha_eliminacion = models.DateField(blank=True, null=True)
    activo = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'conjunto'


class Detallecobrorecargos(models.Model):
    conjunto = models.CharField(max_length=15)
    cedula = models.CharField(max_length=12)
    secuencia = models.IntegerField()
    secuenciarecargo = models.IntegerField()
    valorcubierto = models.DecimalField(max_digits=8, decimal_places=2)
    cruce = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'detallecobrorecargos'
        unique_together = (('conjunto', 'cedula', 'secuencia', 'secuenciarecargo'),)


class Detalleinteres(models.Model):
    conjunto = models.CharField(max_length=15)
    anio = models.IntegerField()
    mes = models.IntegerField()
    secuenciarr = models.IntegerField()
    secuenciar = models.IntegerField()
    saldo = models.DecimalField(max_digits=7, decimal_places=2)
    diasimpago = models.IntegerField()
    valor = models.DecimalField(max_digits=7, decimal_places=2)

    class Meta:
        managed = False
        db_table = 'detalleinteres'
        unique_together = (('conjunto', 'anio', 'mes', 'secuenciarr'),)


class DjangoAdminLog(models.Model):
    action_time = models.DateTimeField()
    object_id = models.TextField(blank=True, null=True)
    object_repr = models.CharField(max_length=200)
    action_flag = models.PositiveSmallIntegerField()
    change_message = models.TextField()
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)
    user = models.ForeignKey('UsuariosUsuario', models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'django_admin_log'


class DjangoContentType(models.Model):
    app_label = models.CharField(max_length=100)
    model = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'django_content_type'
        unique_together = (('app_label', 'model'),)


class DjangoMigrations(models.Model):
    app = models.CharField(max_length=255)
    name = models.CharField(max_length=255)
    applied = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_migrations'


class DjangoSession(models.Model):
    session_key = models.CharField(primary_key=True, max_length=40)
    session_data = models.TextField()
    expire_date = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_session'


class Edificio(models.Model):
    conjunto = models.CharField(max_length=15)
    codigoedificio = models.CharField(max_length=6)
    descripcion = models.CharField(max_length=80)
    contacto = models.CharField(max_length=40)
    telefono = models.CharField(max_length=12)
    direccion = models.CharField(max_length=80)
    presenta = models.CharField(max_length=2)

    class Meta:
        managed = False
        db_table = 'edificio'
        unique_together = (('conjunto', 'codigoedificio'),)


class Empresaguardiania(models.Model):
    conjunto = models.CharField(max_length=15)
    codigo = models.CharField(max_length=10)
    ruc = models.CharField(max_length=18)
    razonsocial = models.CharField(max_length=100)
    correo = models.CharField(max_length=100)
    telefono = models.CharField(max_length=12)
    contacto = models.CharField(max_length=50)
    estado = models.CharField(max_length=3)
    fechacreacion = models.DateField()

    class Meta:
        managed = False
        db_table = 'empresaguardiania'
        unique_together = (('conjunto', 'codigo', 'ruc'),)


class Gastos(models.Model):
    conjunto = models.CharField(max_length=15)
    proveedor = models.CharField(max_length=6)
    secuencia = models.IntegerField()
    tipogasto = models.CharField(max_length=6)
    secuenciap = models.IntegerField()
    administracion = models.IntegerField()
    documento = models.CharField(max_length=40)
    fechadocumento = models.DateField()
    fechapago = models.DateField()
    observaciones = models.CharField(db_column='Observaciones', max_length=150)  # Field name made lowercase.
    valor = models.DecimalField(max_digits=8, decimal_places=2)
    fechaingreso = models.DateField()
    anio = models.IntegerField()
    mes = models.IntegerField()
    usuario = models.CharField(max_length=20)

    class Meta:
        managed = False
        db_table = 'gastos'
        unique_together = (('conjunto', 'proveedor', 'secuencia'),)


class Guardiania(models.Model):
    conjunto = models.CharField(max_length=15)
    empresa = models.CharField(max_length=10)
    cedula = models.CharField(max_length=12)
    nombres = models.CharField(max_length=50)
    apellidos = models.CharField(max_length=50)
    correo = models.CharField(max_length=100)
    clave = models.CharField(max_length=20)
    telefono = models.CharField(max_length=12)
    fechacreacion = models.DateField()
    estado = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'guardiania'
        unique_together = (('conjunto', 'cedula'), ('conjunto', 'empresa', 'cedula'),)


class Inmueble(models.Model):
    conjunto = models.CharField(max_length=15)
    cedula = models.CharField(max_length=12)
    unico = models.CharField(max_length=22)
    codigoedificio = models.CharField(max_length=10)
    tipoedificacion = models.CharField(max_length=6)
    piso = models.IntegerField()
    numeracion = models.CharField(max_length=6)
    area = models.DecimalField(max_digits=6, decimal_places=2)
    agrupacion = models.CharField(max_length=3)
    direccion = models.CharField(max_length=50)
    zona = models.CharField(max_length=6)
    propietario = models.CharField(max_length=50)
    fechacreacion = models.DateField()

    class Meta:
        managed = False
        db_table = 'inmueble'
        unique_together = (('conjunto', 'cedula', 'unico'), ('conjunto', 'unico'),)


class Inmueble1(models.Model):
    conjunto = models.CharField(max_length=10)
    cedula = models.CharField(max_length=12)
    unico = models.CharField(max_length=22)
    codigoedificio = models.CharField(max_length=10)
    tipoedificacion = models.CharField(max_length=6)
    piso = models.IntegerField()
    numeracion = models.CharField(max_length=6)
    area = models.DecimalField(max_digits=6, decimal_places=2)
    descripcion = models.CharField(max_length=50)
    direccion = models.CharField(max_length=50)
    zona = models.CharField(max_length=6)
    propietario = models.CharField(max_length=50)
    fechacreacion = models.DateField()

    class Meta:
        managed = False
        db_table = 'inmueble1'
        unique_together = (('conjunto', 'cedula', 'unico'), ('conjunto', 'unico'),)


class Mediopago(models.Model):
    codigo = models.CharField(unique=True, max_length=5)
    descripcion = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'mediopago'


class Novedadesgc(models.Model):
    conjunto = models.CharField(max_length=15)
    empresa = models.CharField(max_length=10)
    cedula = models.CharField(max_length=12)
    secuencia = models.IntegerField()
    cedulamodifica = models.CharField(max_length=12, blank=True, null=True)
    documentoi = models.CharField(max_length=10)
    tipo = models.CharField(max_length=10)
    cedulavisita = models.CharField(max_length=12)
    placa = models.CharField(max_length=10)
    condomino = models.CharField(max_length=12)
    observaciones = models.CharField(max_length=5000)
    cedulacierra = models.CharField(max_length=12)
    fechacreacion = models.DateTimeField()
    fechamodifica = models.DateTimeField(blank=True, null=True)
    fehacierre = models.DateTimeField()
    estado = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'novedadesgc'
        unique_together = (('conjunto', 'empresa', 'cedula', 'secuencia'),)


class Pais(models.Model):
    paiscodigo = models.CharField(db_column='PaisCodigo', unique=True, max_length=3)  # Field name made lowercase.
    paisnombre = models.CharField(db_column='PaisNombre', max_length=52)  # Field name made lowercase.
    paiscontinente = models.CharField(db_column='PaisContinente', max_length=50)  # Field name made lowercase.
    paisregion = models.CharField(db_column='PaisRegion', max_length=26)  # Field name made lowercase.
    paisnombrelocal = models.CharField(db_column='PaisNombreLocal', max_length=45)  # Field name made lowercase.
    diasconsulta = models.IntegerField(blank=True, null=True)
    moneda = models.CharField(max_length=3)
    bandera = models.TextField()
    prefijo = models.CharField(max_length=4)
    zona = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'pais'


class Paiso(models.Model):
    paiscodigo = models.CharField(db_column='PaisCodigo', unique=True, max_length=3)  # Field name made lowercase.
    paisnombre = models.CharField(db_column='PaisNombre', max_length=52)  # Field name made lowercase.
    paiscontinente = models.CharField(db_column='PaisContinente', max_length=50)  # Field name made lowercase.
    paisregion = models.CharField(db_column='PaisRegion', max_length=26)  # Field name made lowercase.
    paisnombrelocal = models.CharField(db_column='PaisNombreLocal', max_length=45)  # Field name made lowercase.
    paiscapital = models.IntegerField(db_column='PaisCapital', blank=True, null=True)  # Field name made lowercase.
    paiscodigo2 = models.CharField(db_column='PaisCodigo2', max_length=2)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'paiso'


class Parametros(models.Model):
    conjunto = models.CharField(unique=True, max_length=15)
    nusuarios = models.IntegerField()
    numerico1 = models.IntegerField()
    numerico2 = models.DecimalField(max_digits=7, decimal_places=2)
    intereses = models.DecimalField(max_digits=5, decimal_places=2)
    diasespera = models.IntegerField()
    texto1 = models.CharField(max_length=10)
    texto2 = models.CharField(max_length=200)
    fecha = models.DateField()
    usuario = models.CharField(max_length=20)

    class Meta:
        managed = False
        db_table = 'parametros'


class Parametrosg(models.Model):
    sistema = models.CharField(unique=True, max_length=20)
    tiempo = models.IntegerField()
    numerico1 = models.IntegerField()
    numerico2 = models.DecimalField(max_digits=10, decimal_places=0)
    texto1 = models.CharField(max_length=10)
    texto2 = models.CharField(max_length=200)
    clave = models.CharField(max_length=200)
    servidor = models.CharField(max_length=100)
    usuario = models.CharField(max_length=50)
    base = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'parametrosg'


class Perfildefecto(models.Model):
    perfil = models.CharField(max_length=20)
    codigopermiso = models.CharField(max_length=10)
    tipoproceso = models.CharField(max_length=10)
    descripcion = models.CharField(db_column='Descripcion', max_length=60)  # Field name made lowercase.
    modulo = models.CharField(max_length=20)
    funcion = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'perfildefecto'
        unique_together = (('perfil', 'codigopermiso'),)


class Perfildefecto1(models.Model):
    perfil = models.CharField(max_length=20)
    codigopermiso = models.CharField(max_length=10)
    tipoproceso = models.CharField(max_length=10)
    descripcion = models.CharField(db_column='Descripcion', max_length=60)  # Field name made lowercase.
    modulo = models.CharField(max_length=20)
    funcion = models.CharField(max_length=100)
    url = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'perfildefecto1'
        unique_together = (('perfil', 'codigopermiso'),)


class Periodo(models.Model):
    conjunto = models.CharField(max_length=15)
    anio = models.IntegerField()
    mes = models.IntegerField()
    fecha_inicio = models.DateField()
    fecha_fin = models.DateField()
    usuario = models.CharField(max_length=255)
    activo = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'periodo'
        unique_together = (('conjunto', 'anio', 'mes'),)


class Periodoaux(models.Model):
    anio = models.IntegerField()
    mes = models.IntegerField()
    semestre = models.IntegerField()
    fecha_inicio = models.DateField()
    fecha_fin = models.DateField()

    class Meta:
        managed = False
        db_table = 'periodoaux'
        unique_together = (('anio', 'mes'),)


class Periodoo(models.Model):
    conjunto = models.CharField(max_length=10)
    anio = models.IntegerField()
    mes = models.IntegerField()
    fecha_inicio = models.DateField()
    fecha_fin = models.DateField()
    usuario = models.CharField(max_length=255)
    activo = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'periodoo'
        unique_together = (('conjunto', 'anio', 'mes'),)


class Permisossistema(models.Model):
    codigopermiso = models.CharField(unique=True, max_length=10)
    tipoproceso = models.CharField(max_length=10)
    descripcion = models.CharField(db_column='Descripcion', max_length=60)  # Field name made lowercase.
    modulo = models.CharField(max_length=20)
    funcion = models.CharField(max_length=100)
    url = models.CharField(max_length=100)
    secmenu = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'permisossistema'


class Presupuesto(models.Model):
    conjunto = models.CharField(max_length=15)
    tipopresupuesto = models.CharField(max_length=5)
    anio = models.IntegerField()
    semestre = models.IntegerField()
    secuencia = models.IntegerField()
    descripcion = models.CharField(max_length=100)
    fechaingreso = models.DateField()
    valor = models.DecimalField(max_digits=9, decimal_places=2)
    valoro = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)
    activo = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'presupuesto'
        unique_together = (('conjunto', 'tipopresupuesto', 'anio', 'semestre'),)


class Proveedor(models.Model):
    conjunto = models.CharField(max_length=15)
    codigoproveedor = models.CharField(max_length=6)
    razonsocial = models.CharField(max_length=100)
    contacto = models.CharField(max_length=100)
    email = models.CharField(unique=True, max_length=100)
    telefonooficina = models.IntegerField()
    movil = models.CharField(max_length=12)
    fechacreacion = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'proveedor'
        unique_together = (('conjunto', 'codigoproveedor'),)


class Recargocondominos(models.Model):
    conjunto = models.CharField(max_length=15)
    anio = models.IntegerField()
    mes = models.IntegerField()
    unico = models.CharField(max_length=22)
    cedulacondomino = models.CharField(max_length=12)
    cargo = models.CharField(max_length=6)
    secuenciar = models.IntegerField()
    administracion = models.IntegerField()
    valor = models.DecimalField(max_digits=8, decimal_places=2)
    saldo = models.DecimalField(max_digits=8, decimal_places=2)
    usuariocrea = models.CharField(max_length=20)
    fechacreacion = models.DateField()
    usuariocierra = models.CharField(max_length=10)
    fechacierre = models.DateField()

    class Meta:
        managed = False
        db_table = 'recargocondominos'
        unique_together = (('conjunto', 'secuenciar'), ('conjunto', 'anio', 'mes', 'unico', 'cedulacondomino', 'cargo'),)


class Recargovalores(models.Model):
    conjunto = models.CharField(max_length=15)
    codigoalicuota = models.CharField(max_length=6)
    descripcion = models.CharField(max_length=100)
    tiporecargo = models.CharField(max_length=6)
    valor = models.DecimalField(max_digits=8, decimal_places=2)
    fechavigencia = models.DateField()
    fechafin = models.DateField()
    activo = models.CharField(max_length=3)
    fechacreacion = models.DateField()
    usuariocreo = models.CharField(max_length=20)
    usuariomodifico = models.CharField(max_length=20, blank=True, null=True)
    fechamodificacion = models.DateField()

    class Meta:
        managed = False
        db_table = 'recargovalores'
        unique_together = (('conjunto', 'codigoalicuota'),)


class Reportes(models.Model):
    codigo = models.CharField(unique=True, max_length=10)
    nombrereporte = models.CharField(max_length=100)
    nombreexcel = models.CharField(max_length=100)
    cabecera = models.CharField(max_length=200, blank=True, null=True)
    cabecera2 = models.CharField(max_length=200)
    piepagina = models.CharField(max_length=200)
    piepagina1 = models.CharField(max_length=200)
    observaciones = models.CharField(max_length=200)
    fecha_creacion = models.DateField()
    activo = models.CharField(max_length=3)
    columna = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'reportes'


class Reporteusuario(models.Model):
    codigo = models.CharField(max_length=10)
    usuario = models.CharField(max_length=20, blank=True, null=True)
    sqlejecutado = models.CharField(max_length=1000)
    variables = models.CharField(max_length=100)
    filtroa = models.CharField(max_length=100)
    fechainicio = models.DateField()
    fechafin = models.DateField()
    filtron = models.CharField(max_length=40)
    parametrossql = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'reporteusuario'
        unique_together = (('codigo', 'usuario'),)


class Secuencias(models.Model):
    conjunto = models.CharField(unique=True, max_length=15)
    seccobro = models.IntegerField()
    secgasto = models.IntegerField()
    secprocesoalicuota = models.IntegerField()
    secuenciainmueble = models.IntegerField()
    secuenciapresupuesto = models.IntegerField()
    secuenciaperiodoa = models.IntegerField()
    snovedad = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'secuencias'


class Sesion(models.Model):
    usuario = models.CharField(unique=True, max_length=20)
    ultimaaccion = models.DateTimeField()
    accion = models.CharField(max_length=500)
    grafico = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'sesion'


class Tablatablas(models.Model):
    codigo = models.CharField(max_length=10)
    codigo2 = models.CharField(max_length=10)
    descripcion = models.CharField(max_length=50)
    texto1 = models.CharField(max_length=50)
    valor1 = models.IntegerField()
    valor2 = models.DecimalField(max_digits=8, decimal_places=2)
    estado = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'tablatablas'
        unique_together = (('codigo', 'codigo2'),)


class Tipogastopresup(models.Model):
    codigo = models.CharField(unique=True, max_length=5)
    descripcion = models.CharField(max_length=50)

    class Meta:
        managed = False
        db_table = 'tipogastopresup'


class Tiporecargo(models.Model):
    codigo = models.CharField(unique=True, max_length=6)
    descripcion = models.CharField(max_length=100)
    reservado = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'tiporecargo'


class Usuarioempresaa(models.Model):
    usuario = models.CharField(max_length=20)
    codigo = models.CharField(max_length=15)
    estado = models.CharField(max_length=3)

    class Meta:
        managed = False
        db_table = 'usuarioempresaa'
        unique_together = (('usuario', 'codigo'),)


class Usuariopermisos(models.Model):
    conjunto = models.CharField(max_length=15)
    usuario = models.CharField(max_length=20)
    codigopermiso = models.CharField(max_length=10)

    class Meta:
        managed = False
        db_table = 'usuariopermisos'
        unique_together = (('conjunto', 'usuario', 'codigopermiso'),)


class Usuariopermisos1(models.Model):
    conjunto = models.CharField(max_length=15)
    usuario = models.CharField(max_length=20)
    codigopermiso = models.CharField(max_length=10)

    class Meta:
        managed = False
        db_table = 'usuariopermisos1'
        unique_together = (('conjunto', 'usuario', 'codigopermiso'),)


class UsuariosUsuario(models.Model):
    password = models.CharField(max_length=128)
    last_login = models.DateTimeField(blank=True, null=True)
    username = models.CharField(unique=True, max_length=20)
    email = models.CharField(max_length=255)
    nombres = models.CharField(max_length=255, blank=True, null=True)
    apellidos = models.CharField(max_length=255, blank=True, null=True)
    imagen = models.CharField(max_length=255, blank=True, null=True)
    usuario_activo = models.IntegerField()
    usuario_administrador = models.IntegerField()
    conjunto = models.CharField(max_length=15, blank=True, null=True)
    fecha_creacion = models.DateField()
    fecha_modificacion = models.DateField()
    fecha_eliminacion = models.DateField(blank=True, null=True)
    activo = models.CharField(max_length=3)
    tipo = models.CharField(max_length=1)

    class Meta:
        managed = False
        db_table = 'usuarios_usuario'


class Visita(models.Model):
    conjunto = models.CharField(max_length=15)
    cedulavisita = models.CharField(max_length=12)
    nombres = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'visita'
        unique_together = (('conjunto', 'cedulavisita'),)


class Zonas(models.Model):
    conjunto = models.CharField(max_length=15)
    codigozona = models.CharField(max_length=6)
    descripcion = models.CharField(max_length=100)
    presenta = models.CharField(max_length=2)

    class Meta:
        managed = False
        db_table = 'zonas'