from django.db import models

class EmpresaVetorh(models.Model):
    id = models.IntegerField(primary_key=True, db_column='numemp')
    nome = models.CharField(max_length=40, db_column='nomemp')

    class Meta:
        managed = False
        db_table = 'r030emp'

    def __str__(self):
        return self.nome

class FilialVetorh(models.Model):
    empresa = models.ForeignKey(EmpresaVetorh, db_column='numemp', related_name='filial_empresa')
    id = models.IntegerField(primary_key=True, db_column='codfil')
    nome = models.CharField(max_length=40, db_column='nomfil')

    class Meta:
        managed = False
        db_table = 'r030fil'
        unique_together = ('empresa', 'id',)

    def __str__(self):
        return self.nome

class FuncionarioVetorh(models.Model):
    id = models.IntegerField(primary_key=True, db_column='numcad')
    empresa = models.ForeignKey(EmpresaVetorh, db_column='numemp', related_name='funcionario_empresa')
    filial = models.ForeignKey(FilialVetorh, db_column='codfil', related_name='funcionario_filial')
    tipo = models.IntegerField(db_column='tipcol')
    nome = models.CharField(max_length=40, db_column='nomfun')
    nascimento = models.DateField(db_column='datnas')
    admissao = models.DateField(db_column='datadm')
    situacao = models.IntegerField(db_column='sitafa')

    class Meta:
        managed = False
        db_table = 'r034fun'
        unique_together = ('empresa', 'tipo', 'id')

    def __str__(self):
        return self.nome