| 123456789101112131415161718192021222324252627 |
- from datetime import datetime
- from sqlalchemy import BigInteger, DateTime, Integer, String, ForeignKey
- from sqlalchemy.dialects.mysql import LONGTEXT
- from sqlalchemy.orm import Mapped, mapped_column
- from alien_database.base import Base, AuditMixin
- class ContractDocument(Base, AuditMixin):
- """合同文档"""
- __tablename__ = "contract_document"
- id: Mapped[int] = mapped_column(BigInteger, primary_key=True, autoincrement=True, comment="合同文档唯一标识")
- bundle_id: Mapped[int] = mapped_column(BigInteger, ForeignKey("contract_bundle.id"), index=True, comment="所属合同包ID")
- contract_type: Mapped[str] = mapped_column(String(50), comment="合同类型编码(store_agreement/alipay_auth等)")
- contract_name: Mapped[str] = mapped_column(String(100), comment="合同展示名称")
- is_primary: Mapped[int] = mapped_column(Integer, default=0, comment="是否主合同(1是/0否)")
- status: Mapped[int] = mapped_column(Integer, default=0, comment="签署状态(0未签署/1已签署)")
- sign_flow_id: Mapped[str] = mapped_column(String(64), unique=True, comment="e签宝签署流程ID")
- file_id: Mapped[str] = mapped_column(String(64), comment="e签宝文件ID")
- template_url: Mapped[str] = mapped_column(LONGTEXT, comment="合同模板预览URL")
- sign_url: Mapped[str] = mapped_column(LONGTEXT, comment="签署链接URL")
- download_url: Mapped[str] = mapped_column(LONGTEXT, comment="签署完成后的下载URL")
- signing_time: Mapped[datetime | None] = mapped_column(DateTime, nullable=True, comment="签署时间")
- effective_time: Mapped[datetime | None] = mapped_column(DateTime, nullable=True, comment="合同生效时间")
- expiry_time: Mapped[datetime | None] = mapped_column(DateTime, nullable=True, comment="合同到期时间")
|
