shanxia/crm/py-backend/app/models/crm_contact.py

from datetime import datetime, date
from typing import Optional

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

from app.database import Base


class CrmContact(Base):
    __tablename__ = "crm_contact"

    id: Mapped[int] = mapped_column(BigInteger, primary_key=True, autoincrement=False, comment="主键ID")
    customer_id: Mapped[Optional[int]] = mapped_column(BigInteger, comment="客户ID")
    customer_name: Mapped[Optional[str]] = mapped_column(String(200), comment="客户名称")
    contact_name: Mapped[Optional[str]] = mapped_column(String(50), comment="联系人姓名")
    gender: Mapped[Optional[str]] = mapped_column(String(10), comment="性别")
    mobile: Mapped[Optional[str]] = mapped_column(String(20), comment="手机号")
    telephone: Mapped[Optional[str]] = mapped_column(String(30), comment="固定电话")
    email: Mapped[Optional[str]] = mapped_column(String(100), comment="邮箱")
    wechat: Mapped[Optional[str]] = mapped_column(String(50), comment="微信")
    qq: Mapped[Optional[str]] = mapped_column(String(20), comment="QQ")
    department: Mapped[Optional[str]] = mapped_column(String(100), comment="部门")
    position: Mapped[Optional[str]] = mapped_column(String(50), comment="职位")
    role: Mapped[Optional[str]] = mapped_column(String(20), comment="角色")
    birthday: Mapped[Optional[date]] = mapped_column(Date, comment="生日")
    address: Mapped[Optional[str]] = mapped_column(String(255), comment="地址")
    is_key: Mapped[Optional[int]] = mapped_column(SmallInteger, default=0, comment="是否关键人(0否 1是)")
    is_primary: Mapped[Optional[int]] = mapped_column(SmallInteger, default=0, comment="是否首要联系人(0否 1是)")
    status: Mapped[Optional[str]] = mapped_column(String(20), default="1", comment="状态(1正常 0停用)")
    tenant_id: Mapped[Optional[str]] = mapped_column(String(20), default="000000", 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="更新时间")
    del_flag: Mapped[Optional[int]] = mapped_column(SmallInteger, default=0, comment="删除标志(0存在 1删除)")
    version: Mapped[Optional[int]] = mapped_column(Integer, default=0, comment="版本号")
    remark: Mapped[Optional[str]] = mapped_column(String(500), comment="备注")