"""ORM mapping for the additive customer benefit catalog.

只映射新增的 `fin_customer_benefit`（层级 → 权益条目）。
**不映射"某客户享有哪些权益"** —— 那可由客户层级实时推出，落库会造成双份真相。
客户层级本身仍以 `sys_user.customer_tier`（`app.model.fund`）与
`fin_customer_profile.total_asset` 为准，本模块不改它们。
"""

from datetime import datetime

from sqlalchemy import BigInteger, DateTime, Integer, String
from sqlalchemy.orm import Mapped, mapped_column

from app.model.base import Base


class CustomerBenefit(Base):
    """客户权益目录：一条 = 某个层级享有的一项权益。"""

    __tablename__ = "fin_customer_benefit"

    id: Mapped[int] = mapped_column(BigInteger, primary_key=True)
    benefit_code: Mapped[str] = mapped_column(String(64), nullable=False)
    #: 英文层级码（gold/platinum/diamond/private）；中文名由接口层映射。
    customer_tier: Mapped[str] = mapped_column(String(16), nullable=False)
    #: financial / non_financial
    category: Mapped[str] = mapped_column(String(16), nullable=False)
    name: Mapped[str] = mapped_column(String(128), nullable=False)
    description: Mapped[str] = mapped_column(String(512), nullable=False)
    display_order: Mapped[int] = mapped_column(Integer, nullable=False, default=0)
    status: Mapped[str] = mapped_column(String(16), nullable=False)
    created_at: Mapped[datetime] = mapped_column(DateTime, nullable=False)
    updated_at: Mapped[datetime] = mapped_column(DateTime, nullable=False)