# 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
#   * 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.
#
# Also note: You'll have to insert the output of 'django-admin.py sqlcustom [app_label]'
# into your database.
from __future__ import unicode_literals

from django.db import models


class AuthGroup(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    name = models.CharField(unique=True, max_length=80)

    class Meta:
        managed = False
        db_table = 'auth_group'


class AuthGroupPermissions(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    group = models.ForeignKey(AuthGroup)
    permission = models.ForeignKey('AuthPermission')

    class Meta:
        managed = False
        db_table = 'auth_group_permissions'


class AuthPermission(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    name = models.CharField(max_length=50)
    content_type = models.ForeignKey('DjangoContentType')
    codename = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'auth_permission'


class AuthUser(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    password = models.CharField(max_length=128)
    last_login = models.DateTimeField()
    is_superuser = models.BooleanField()
    username = models.CharField(unique=True, max_length=30)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    email = models.CharField(max_length=75)
    is_staff = models.BooleanField()
    is_active = models.BooleanField()
    date_joined = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'auth_user'


class AuthUserGroups(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    user = models.ForeignKey(AuthUser)
    group = models.ForeignKey(AuthGroup)

    class Meta:
        managed = False
        db_table = 'auth_user_groups'


class AuthUserUserPermissions(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    user = models.ForeignKey(AuthUser)
    permission = models.ForeignKey(AuthPermission)

    class Meta:
        managed = False
        db_table = 'auth_user_user_permissions'


class BuzonProveedores(models.Model):
    id_buzon = models.AutoField(primary_key=True)
    comentarios = models.CharField(max_length=4000)
    id_proveedor = models.ForeignKey('CatProveedores', db_column='id_proveedor')
    fecha_registro = models.DateTimeField(blank=True, null=True)
    fecha_modificacion = models.DateTimeField(blank=True, null=True)
    id_usuario_captura = models.IntegerField(blank=True, null=True)
    cve_estatus = models.CharField(max_length=3, blank=True)
    id_unidad_administrativa = models.ForeignKey('CatUnidadesAdministrativas', db_column='id_unidad_administrativa', blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'buzon_proveedores'


class CatDependencias(models.Model):
    id_dependencia = models.IntegerField(primary_key=True)
    desc_dependencia = models.CharField(max_length=100, blank=True)

    class Meta:
        managed = False
        db_table = 'cat_dependencias'


class CatEstatus(models.Model):
    cve_estatus = models.CharField(primary_key=True, max_length=3)
    desc_estatus = models.CharField(max_length=50)

    class Meta:
        managed = False
        db_table = 'cat_estatus'


class CatPersonas(models.Model):
    id_persona = models.AutoField(primary_key=True)
    nombre_persona = models.CharField(max_length=45, blank=True)
    desc_cargo = models.CharField(max_length=45, blank=True)
    id_organizacion = models.IntegerField(blank=True, null=True)
    tipo_persona = models.IntegerField(blank=True, null=True)
    cve_estatus = models.CharField(max_length=3, blank=True)
    id_unidad = models.ForeignKey('CatUnidadesAdministrativas', db_column='id_unidad', blank=True, null=True)
    fecha_registro = models.DateTimeField(blank=True, null=True)
    fecha_modificacion = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cat_personas'


class CatPersonasTitulares(models.Model):
    id_cat_titular = models.IntegerField(primary_key=True)
    id_persona_titular = models.IntegerField(blank=True, null=True)
    id_usuario = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cat_personas_titulares'


class CatProveedores(models.Model):
    id_proveedor = models.AutoField(primary_key=True)
    desc_proveedor = models.CharField(max_length=200, blank=True)
    id_persona = models.IntegerField(blank=True, null=True)
    fecha_registro = models.DateTimeField(blank=True, null=True)
    fecha_modificacion = models.DateTimeField(blank=True, null=True)
    id_usuario_captura = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cat_proveedores'


class CatTipoVale(models.Model):
    id_tipo_vale = models.IntegerField(primary_key=True)
    desc_tipo_vale = models.CharField(max_length=80, blank=True)

    class Meta:
        managed = False
        db_table = 'cat_tipo_vale'


class CatUnidadesAdministrativas(models.Model):
    id_unidad_administrativa = models.AutoField(primary_key=True)
    desc_unidad = models.CharField(max_length=150, blank=True)
    id_unidad_padre = models.IntegerField(blank=True, null=True)
    id_dependencia = models.ForeignKey(CatDependencias, db_column='id_dependencia')
    cve_estatus = models.CharField(max_length=3, blank=True)

    class Meta:
        managed = False
        db_table = 'cat_unidades_administrativas'


class CatUsuarios(models.Model):
    id_usuario = models.AutoField(primary_key=True)
    usuario = models.CharField(max_length=45, blank=True)
    contrasena = models.CharField(max_length=45, blank=True)
    correo_electronico = models.CharField(max_length=90, blank=True)
    telefono = models.CharField(max_length=45, blank=True)
    tipo_usuario = models.CharField(max_length=1, blank=True)
    id_persona = models.ForeignKey(CatPersonas, db_column='id_persona', blank=True, null=True)
    cve_estatus = models.CharField(max_length=45, blank=True)
    fecha_registro = models.DateTimeField(blank=True, null=True)
    fecha_modificacion = models.DateTimeField(blank=True, null=True)
    id_usuario_captura = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cat_usuarios'


class DjangoAdminLog(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    action_time = models.DateTimeField()
    object_id = models.TextField(blank=True)
    object_repr = models.CharField(max_length=200)
    action_flag = models.SmallIntegerField()
    change_message = models.TextField()
    content_type = models.ForeignKey('DjangoContentType', blank=True, null=True)
    user = models.ForeignKey(AuthUser)

    class Meta:
        managed = False
        db_table = 'django_admin_log'


class DjangoContentType(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    name = models.CharField(max_length=100)
    app_label = models.CharField(max_length=100)
    model = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'django_content_type'


class DjangoMigrations(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    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 Modulos(models.Model):
    id_modulo = models.IntegerField(primary_key=True)
    modulo = models.CharField(max_length=80, blank=True)

    class Meta:
        managed = False
        db_table = 'modulos'


class Pedidos(models.Model):
    id_pedido = models.AutoField(primary_key=True)
    desc_pedido = models.CharField(max_length=2000, blank=True)
    fecha_vigencia = models.DateTimeField(blank=True, null=True)
    id_dependencia = models.ForeignKey(CatDependencias, db_column='id_dependencia', blank=True, null=True)
    id_tipo_vale = models.ForeignKey(CatTipoVale, db_column='id_tipo_vale', blank=True, null=True)
    fecha_autorizacion = models.DateTimeField(blank=True, null=True)
    observaciones = models.CharField(max_length=2000, blank=True)
    fecha_contrarecibo = models.DateTimeField(blank=True, null=True)
    id_usuario_autoriza = models.IntegerField(blank=True, null=True)
    id_unidad_administrativa = models.ForeignKey(CatUnidadesAdministrativas, db_column='id_unidad_administrativa', blank=True, null=True)
    num_factura = models.CharField(max_length=20, blank=True)
    id_proveedor = models.ForeignKey(CatProveedores, db_column='id_proveedor', blank=True, null=True)
    fecha_envio = models.DateTimeField(blank=True, null=True)
    comentarios = models.CharField(max_length=5000, blank=True)
    fecha_registro = models.DateTimeField(blank=True, null=True)
    fecha_modificacion = models.DateTimeField(blank=True, null=True)
    id_usuario_captura = models.IntegerField(blank=True, null=True)
    cve_estatus = models.CharField(max_length=3, blank=True)

    class Meta:
        managed = False
        db_table = 'pedidos'


class PrivilegiosUsuarios(models.Model):
    id_privilegio = models.IntegerField(primary_key=True)
    id_usuario = models.ForeignKey(CatUsuarios, db_column='id_usuario')
    id_modulo = models.ForeignKey(Modulos, db_column='id_modulo')
    cve_estatus = models.CharField(max_length=3, blank=True)

    class Meta:
        managed = False
        db_table = 'privilegios_usuarios'


class Vales(models.Model):
    id_vale = models.AutoField(primary_key=True)
    num_vale = models.IntegerField(blank=True, null=True)
    id_pedido = models.ForeignKey(Pedidos, db_column='id_pedido', blank=True, null=True)
    fecha_vigencia = models.DateTimeField(blank=True, null=True)
    id_tipo_vale = models.IntegerField(blank=True, null=True)
    beneficiario = models.CharField(max_length=100, blank=True)
    id_usuario = models.IntegerField(blank=True, null=True)
    cve_estatus = models.CharField(max_length=3, blank=True)
    codigo_solicitante = models.CharField(max_length=5, blank=True)
    codigo_proveedor = models.CharField(max_length=5, blank=True)
    cve_estatus_comprobacion = models.CharField(max_length=3, blank=True)
    cve_estatus_verificacion = models.CharField(max_length=3, blank=True)
    fecha_registro = models.DateTimeField(blank=True, null=True)
    fecha_modificacion = models.DateTimeField(blank=True, null=True)
    id_usuario_captura = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'vales'