from django.db import models

# Create your models here.

class rrcontrib(models.Model):
  cod_con = models.IntegerField(primary_key=True)
  nom_com = models.CharField(max_length=255)
  codpadron = models.CharField(max_length=20)
  ind_den = models.CharField(max_length=1)
  ced_rif = models.CharField(max_length=15, unique=True, null= False)
  nit_con = models.CharField(max_length=11)
  nom_pro = models.CharField(max_length=255)
  act_con = models.SmallIntegerField()
  act_con2 = models.SmallIntegerField()
  act_con3 = models.SmallIntegerField()
  act_con4 = models.SmallIntegerField()
  per_obr = models.SmallIntegerField()
  cap_sus = models.DecimalField(max_digits=18, decimal_places=2)
  cap_pag = models.DecimalField(max_digits=18, decimal_places=2)
  cod_edo = models.SmallIntegerField()
  cod_mun = models.SmallIntegerField()
  cod_par= models.SmallIntegerField()
  dir_cont = models.CharField(max_length=500)
  num_registro_com = models.CharField(max_length=30)
  nom_rep = models.CharField(max_length=50)
  lem_comercial = models.CharField(max_length=60)
  telf_empresa = models.CharField(max_length=20)
  telf_propietario = models.CharField(max_length=20)
  cod_sector = models.SmallIntegerField()
  ced_rep = models.SmallIntegerField()
  dir_rep = models.CharField(max_length=250)
  tel_rep = models.CharField(max_length=30)
  status = models.TextField(max_length=1)
  persona = models.TextField(max_length=1)
  con_vivienda = models.SmallIntegerField()
  con_acti_economica = models.SmallIntegerField()
  con_vehiculo = models.SmallIntegerField()
  transeunte = models.TextField(max_length=1)
  residente = models.TextField(max_length=1)
  tipo = models.TextField(max_length=1)
  sector = models.CharField(max_length=20)
  centro = models.CharField(max_length=20)
  manzana = models.SmallIntegerField()
  barrio = models.CharField(max_length=30)
  urbanizacion = models.CharField(max_length=30)
  calle = models.CharField(max_length=30)
  avenida = models.CharField(max_length=30)
  carretera = models.CharField(max_length=30)
  fec_notificacion = models.DateField()
  fec_inicio = models.DateField()
  periodo = models.SmallIntegerField()
  fec_final = models.DateField()
  car_rep_legal = models.TextField(max_length=20)
  declaracion = models.SmallIntegerField()
  telefono = models.CharField(max_length = 11)
  email = models.EmailField()
  pagweb = models.TextField()
  fax = models.TextField()
  numpatente = models.CharField(max_length=255)
  razon_comer = models.TextField(max_length=255)
  con_pubypro = models.CharField(max_length=255)
  fecha_inscripcion = models.DateField()
  tomo = models.TextField()
  protocolo = models.CharField(max_length=6)
  cuenta_castral = models.TextField()
  arrendatario = models.TextField()
  tipo_empresa = models.CharField(max_length=8)
  sucursal = models.SmallIntegerField()
  fecha_fin_registro = models.DateField()
  numero_acta = models.CharField(max_length=50)
  fecha_regis_acta = models.DateField()
  fecha_fin_acta = models.DateField()
  correo_empresa = models.EmailField()
  correo_contacto = models.EmailField()
  whatsapp = models.CharField(max_length=20)
  fecha_fin_junta = models.DateField()
  aumentocapital = models.DecimalField(max_digits=18, decimal_places=2)
  fecha_aumento_capital = models.DateField()
  objetoempresa_acta = models.TextField()
  usu_reg = models.SmallIntegerField()
  usu_apro = models.SmallIntegerField()