22 lines
943 B
Python
22 lines
943 B
Python
from __future__ import annotations
|
|
|
|
from sqlalchemy import Text
|
|
from sqlalchemy.orm import Mapped, mapped_column
|
|
|
|
from app.db.base import Base
|
|
|
|
|
|
class ApprovalRequest(Base):
|
|
__tablename__ = "approval_request"
|
|
|
|
approval_id: Mapped[str] = mapped_column(Text, primary_key=True)
|
|
task_id: Mapped[str] = mapped_column(Text, nullable=False, index=True)
|
|
approval_status: Mapped[str] = mapped_column(Text, nullable=False, index=True)
|
|
risk_level: Mapped[str] = mapped_column(Text, nullable=False)
|
|
operator_user_id: Mapped[str | None] = mapped_column(Text, nullable=True)
|
|
operator_user_name: Mapped[str | None] = mapped_column(Text, nullable=True)
|
|
approver_user_ids_json: Mapped[str] = mapped_column(Text, nullable=False)
|
|
reason: Mapped[str | None] = mapped_column(Text, nullable=True)
|
|
created_at: Mapped[str] = mapped_column(Text, nullable=False)
|
|
updated_at: Mapped[str] = mapped_column(Text, nullable=False)
|