Saltar a contenido

MetodosPago — fuerza_ventas.cat_metodos_pago

catálogos de cobranza de campo

from datetime import datetime
import uuid
from typing import Optional
from sqlalchemy import String, Boolean, DateTime, BigInteger, ForeignKey, ForeignKeyConstraint, UniqueConstraint, Index, Numeric, Integer, Text
from sqlalchemy.dialects.postgresql import UUID, JSONB
from sqlalchemy.orm import Mapped, mapped_column, DeclarativeBase

class Base(DeclarativeBase):
    pass

class MetodosPago(Base):
    __tablename__ = 'cat_metodos_pago'
    __table_args__ = (
        UniqueConstraint('empresa_id', 'id', name='uq_cat_metodos_pago_empresa_id'),
        UniqueConstraint('empresa_id', 'codigo', name='uq_cat_metodos_pago_empresa_codigo'),
        Index('ix_cat_metodos_pago_empresa_activo', 'empresa_id', 'is_activo'),
        {'schema': 'fuerza_ventas'}
    )

    id: Mapped[uuid.UUID] = mapped_column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
    empresa_id: Mapped[int] = mapped_column(
        BigInteger, nullable=False)
    codigo: Mapped[str] = mapped_column(String(30), nullable=False)
    nombre: Mapped[str] = mapped_column(String(100), nullable=False)
    requiere_banco_referencia: Mapped[bool] = mapped_column(Boolean, default=True, nullable=False)
    requiere_imagen_comprobante: Mapped[bool] = mapped_column(Boolean, default=True, nullable=False)

    # Auditoría
    is_activo: Mapped[bool] = mapped_column(Boolean, default=True, nullable=False)
    created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=datetime.utcnow, nullable=False)
    updated_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False)
    deleted_at: Mapped[Optional[datetime]] = mapped_column(DateTime(timezone=True), nullable=True)
    created_by: Mapped[Optional[uuid.UUID]] = mapped_column(UUID(as_uuid=True), nullable=True)
    updated_by: Mapped[Optional[uuid.UUID]] = mapped_column(UUID(as_uuid=True), nullable=True)