Saltar a contenido

ClientePromotor — clientes.rel_clientes_promotores

Asignación cliente/promotor.

"""``clientes.rel_clientes_promotores``: asignación cliente/promotor."""

import uuid

from sqlalchemy import (
    BigInteger,
    ForeignKeyConstraint,
    Index,
    UniqueConstraint,
    text,
)
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.orm import Mapped, mapped_column

from app.db.base import Base
from app.models.mixins import AuditMixin


class ClientePromotor(AuditMixin, Base):
    __tablename__ = "rel_clientes_promotores"
    __table_args__ = (
        UniqueConstraint(
            "empresa_id", "id", name="uq_rel_clientes_promotores_empresa_id"
        ),
        ForeignKeyConstraint(
            ["empresa_id", "cliente_id"],
            ["clientes.mae_clientes.empresa_id", "clientes.mae_clientes.id"],
            name="fk_rel_clientes_promotores_cliente",
        ),
        Index(
            "ix_rel_clientes_promotores_empresa_cliente", "empresa_id", "cliente_id"
        ),
        Index(
            "ix_rel_clientes_promotores_empresa_promotor", "empresa_id", "promotor_id"
        ),
        {"schema": "clientes"},
    )

    id: Mapped[uuid.UUID] = mapped_column(
        UUID(as_uuid=True),
        primary_key=True,
        server_default=text("gen_random_uuid()"),
    )
    empresa_id: Mapped[int] = mapped_column(BigInteger, nullable=False)
    cliente_id: Mapped[uuid.UUID] = mapped_column(UUID(as_uuid=True), nullable=False)
    promotor_id: Mapped[uuid.UUID] = mapped_column(UUID(as_uuid=True), nullable=False)