| 12345678910111213141516171819202122232425262728293031 |
- from datetime import datetime
- from typing import Optional
- from sqlalchemy import BigInteger, String, DateTime, Integer, CHAR
- from sqlalchemy.orm import Mapped, mapped_column
- from app.database import Base
- class CrmSupplierInfo(Base):
- __tablename__ = "crm_supplier_info"
- id: Mapped[int] = mapped_column(BigInteger, primary_key=True, autoincrement=False, comment="主键ID")
- supplier_name: Mapped[Optional[str]] = mapped_column(String(200), comment="供应商名称")
- short_name: Mapped[Optional[str]] = mapped_column(String(100), comment="简称")
- supplier_code: Mapped[Optional[str]] = mapped_column(String(50), comment="供应商编码")
- supplier_address: Mapped[Optional[str]] = mapped_column(String(500), comment="供应商地址")
- legal_person: Mapped[Optional[str]] = mapped_column(String(100), comment="法人代表")
- agent: Mapped[Optional[str]] = mapped_column(String(100), comment="代理人")
- phone_fax: Mapped[Optional[str]] = mapped_column(String(100), comment="电话传真")
- bank_name: Mapped[Optional[str]] = mapped_column(String(200), comment="开户银行")
- bank_account: Mapped[Optional[str]] = mapped_column(String(100), comment="银行账号")
- status: Mapped[Optional[str]] = mapped_column(CHAR(1), default="0", comment="状态(0正常 1停用)")
- remark: Mapped[Optional[str]] = mapped_column(String(500), comment="备注")
- create_dept: Mapped[Optional[int]] = mapped_column(BigInteger, comment="创建部门")
- create_by: Mapped[Optional[int]] = mapped_column(BigInteger, comment="创建者")
- create_time: Mapped[Optional[datetime]] = mapped_column(DateTime, comment="创建时间")
- update_by: Mapped[Optional[int]] = mapped_column(BigInteger, comment="更新者")
- update_time: Mapped[Optional[datetime]] = mapped_column(DateTime, comment="更新时间")
- tenant_id: Mapped[Optional[str]] = mapped_column(String(20), default="000000", comment="租户编号")
- del_flag: Mapped[Optional[str]] = mapped_column(CHAR(1), default="0", comment="删除标志(0存在 2删除)")
|
