from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship

from ..database import Base
from .Cliente import Cliente


class PessoaJuridica(Cliente):
    __tablename__ = "pessoa_juridica"

    cliente_id = Column(Integer, ForeignKey(Cliente.id), primary_key=True, name="cli_id")
    __mapper_args__ = {
        'polymorphic_identity': 'pessoa_juridica',
        'inherit_condition': (cliente_id == Cliente.id)
    }
    razao_social = Column(String, name="pj_razao_social")
    cnpj = Column(String, name="pj_cnpj")
    contato = Column(String, name="pj_contato")
    responsavel = Column(String, name="pj_responsavel")