role_assignment.py 875 B

123456789101112131415161718
  1. from datetime import datetime
  2. from uuid import uuid4
  3. from core_db import AuditMixin, Base, VersionMixin
  4. from sqlalchemy import DateTime, String
  5. from sqlalchemy.orm import Mapped, mapped_column
  6. class RoleAssignment(Base, AuditMixin, VersionMixin):
  7. __tablename__ = "auth_role_assignment"
  8. id: Mapped[str] = mapped_column(String(36), primary_key=True, default=lambda: str(uuid4()))
  9. user_id: Mapped[str] = mapped_column(String(36), index=True)
  10. role_id: Mapped[str] = mapped_column(String(36), index=True)
  11. status: Mapped[str] = mapped_column(String(32), default="active", index=True)
  12. scope_type: Mapped[str | None] = mapped_column(String(64), nullable=True, index=True)
  13. scope_id: Mapped[str | None] = mapped_column(String(64), nullable=True, index=True)
  14. expires_time: Mapped[datetime | None] = mapped_column(DateTime, nullable=True, index=True)