from sqlalchemy.orm import Mapped, mapped_column
from presupuestov1.model import Base

from sqlalchemy import (
    Integer,
    String,
    Text,
    Numeric,
    Index,
    MetaData,
)

class UbigeoResumenes(Base):
    __tablename__ = "ubigeo_resumenes"
    __table_args__ = (
        Index("idx_ubigeo_resumenes_gestion", "gestion"),
        {"schema": "web"},
    )

    id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True)

    gestion: Mapped[int] = mapped_column(Integer)
    ubigeo: Mapped[int] = mapped_column(String(9))

    desc_ubigeo: Mapped[str | None] = mapped_column(Text)
    desc_departamento: Mapped[str | None] = mapped_column(Text)
    monto: Mapped[float | None] = mapped_column(Numeric(30, 15))
    per_capita: Mapped[float | None] = mapped_column(Numeric)
    ranking: Mapped[int | None] = mapped_column(Integer)
    n_entidades: Mapped[int | None] = mapped_column(Integer)