28 lines
726 B
Python
28 lines
726 B
Python
from sqlalchemy import Column, Integer, String
|
|
from app.models.database import Base
|
|
from pydantic import BaseModel
|
|
from typing import Optional
|
|
|
|
class MerchantCategoryDB(Base):
|
|
__tablename__ = "merchant_categories"
|
|
|
|
id = Column(Integer, primary_key=True, index=True, autoincrement=True)
|
|
name = Column(String(50), nullable=False, comment="分类名称")
|
|
sort = Column(Integer, default=0, comment="排序")
|
|
|
|
|
|
class MerchantCategoryCreate(BaseModel):
|
|
name: str
|
|
sort: int = 0
|
|
|
|
class MerchantCategoryUpdate(BaseModel):
|
|
name: Optional[str] = None
|
|
sort: Optional[int] = None
|
|
|
|
class MerchantCategory(BaseModel):
|
|
id: int
|
|
name: str
|
|
sort: int
|
|
|
|
class Config:
|
|
from_attributes = True |