Files
fastapi-demo/app/models/form.py
2023-11-04 18:10:56 +08:00

27 lines
946 B
Python

#!/usr/bin/env python3
# -*- coding:utf-8 -*-
from sqlalchemy import Column, Integer, String, Float, TIMESTAMP, text, func
from app.db.base import Base
class Form(Base):
__tablename__ = 'form'
id = Column(Integer, primary_key=True, nullable=False)
base_prompt = Column(String(length=1024))
prompt = Column(String(length=2048))
p_choice = Column(String(length=255))
role = Column(String(length=255))
name = Column(String(length=1024))
uuid = Column(String(length=1024))
desc = Column(String(length=2048))
price = Column(Float)
favorable = Column(String(length=1024))
remark = Column(String(length=1024))
otherPrompt = Column(String(length=1024))
lang = Column(String(length=1024))
type = Column(String(length=1024))
created_at = Column(TIMESTAMP, server_default=func.now())
updated_at = Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'))