CameraMachine/python/model/photo_record.py

from sqlmodel import SQLModel, Field
from datetime import datetime

class PhotoRecord(SQLModel, table=True):
    __tablename__ = "photo_record"

    id: int = Field(default=None, primary_key=True, index=True)
    goods_art_no: str = Field(max_length=128, nullable=False)
    image_index: int = Field(default=None)
    image_deal_mode: int = Field(default=None)
    photo_create_time: datetime = Field(default=None)
    update_time: datetime = Field(default=None)
    create_time: datetime = Field(default_factory=datetime.utcnow)
    delete_time: datetime = Field(default=None)