from django.db import models

class Pessoa(models.Model):
    class Meta:
        db_table = "Pessoa"
        ordering = ('nome',)
        unique_together = (('nome', 'email'),)
    nome = models.CharField(max_length=400)
    email = models.EmailField(max_length=255, unique=True)

class PessoaFisica(models.Model):
    class Meta:
        abstract = True
        unique_together = (('pessoa', 'cpf','rg'),)
    pessoa = models.ForeignKey('Pessoa', unique=True)
    sobrenome = models.CharField(max_length=100)

class Cliente(PessoaFisica):
    limite_de_credito = models.DecimalField(max_digits=15, decimal_places=2, blank=True, null=True)
    renda_mensal = models.DecimalField(max_digits=15, decimal_places=2, blank=True, null=True)
    class Meta:
        db_table = 'Cliente'