class FounderDomain(BaseDomain):
    __tablename__: str = 'founder'

    cpf = Column(String, unique=True, nullable=False, index=True)
    name = Column(String, unique=False, nullable=False, index=True)
    surname = Column(String, unique=False, nullable=False, index=True)
    age = Column(Integer, nullable=True, index=False)

    company = relationship('CompanyDomain', back_populates='founder')
    leader = relationship('LeaderDomain', uselist=False, back_populates='founder')

    FIELDS = {
        'id': int,
        'name': str,
        'surname': str,
        'cpf': str,
        'age': int,
        'deleted': bool
    }

    FIELDS.update(BaseDomain.FIELDS)

class CompanyDomain(BaseDomain):
    __tablename__: str = 'company'

    company_name = Column(String, unique=True, nullable=False, index=True)
    cnpj = Column(String, unique=True, nullable=False, index=True)
    foundation_date = Column(DateTime, nullable=True, index=False)

    founder_id = Column('founder', Integer, ForeignKey(FounderDomain.id))
    founder = relationship(FounderDomain, back_populates='company')

    FIELDS = {
        'id': int,
        'company_name': str,
        'cnpj': str,
        'foundation_date': datetime,
        'founder': int,
        'deleted': bool
    }

    FIELDS.update(BaseDomain.FIELDS)

class LeaderDomain(BaseDomain):
    __tablename__: str = 'leader'

    cpf = Column(String, unique=True, nullable=False, index=True)
    name = Column(String, unique=False, nullable=False, index=True)
    surname = Column(String, unique=False, nullable=False, index=False)
    work_sector = Column(String, unique=False, nullable=False, index=False)
    age = Column(Integer, nullable=True, index=False)

    founder_id = Column('founder', Integer, ForeignKey(FounderDomain.id))
    founder = relationship(FounderDomain, back_populates='leader')

    FIELDS = {
        'id': int,
        'name': str,
        'surname': str,
        'cpf': str,
        'age': int,
        'work_sector': str,
        'founder': int,
        'deleted': bool
    }

    FIELDS.update(BaseDomain.FIELDS)