Spaces:

gitdeem
/

dt

Paused

dt / app /models /prompt.py

Upload 96 files

4e9efe9 verified over 1 year ago

1.42 kB

from datetime import  date

from app.extensions import db


class Prompt(db.Model):
    """ 提示语模板表 """
    __tablename__ = 'prompt'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    title = db.Column(db.String(255), nullable=False)              # 提示语标题
    share_flag = db.Column(db.Enum('N', 'Y'), default='N')         # 共享状态
    added_count = db.Column(db.Integer, default=0)                 # 被添加次数
    content = db.Column(db.Text, nullable=False)                   # 提示语内容
    customer_id = db.Column(db.Integer, default=0)                 # 创建用户ID
    created_at = db.Column(db.Date,default=date.today)                            # 创建时间
    updated_at = db.Column(db.Date,onupdate=date.today)                            # 更新时间
    deleted_flag = db.Column(db.Enum('N', 'Y'), default='N')       # 删除标记

class PromptFav(db.Model):
    """ 提示语收藏表 """
    __tablename__ = 'prompt_fav'
    id = db.Column(db.BigInteger, primary_key=True, autoincrement=True)
    prompt_id = db.Column(db.Integer, nullable=False)              # 提示语ID
    customer_id = db.Column(db.Integer, nullable=False)            # 用户ID
    created_at = db.Column(db.DateTime)                            # 收藏时间
    updated_at = db.Column(db.DateTime)                            # 更新时间

	from datetime import date

	from app.extensions import db


	class Prompt(db.Model):
	""" 提示语模板表 """
	__tablename__ = 'prompt'
	id = db.Column(db.Integer, primary_key=True, autoincrement=True)
	title = db.Column(db.String(255), nullable=False) # 提示语标题
	share_flag = db.Column(db.Enum('N', 'Y'), default='N') # 共享状态
	added_count = db.Column(db.Integer, default=0) # 被添加次数
	content = db.Column(db.Text, nullable=False) # 提示语内容
	customer_id = db.Column(db.Integer, default=0) # 创建用户ID
	created_at = db.Column(db.Date,default=date.today) # 创建时间
	updated_at = db.Column(db.Date,onupdate=date.today) # 更新时间
	deleted_flag = db.Column(db.Enum('N', 'Y'), default='N') # 删除标记

	class PromptFav(db.Model):
	""" 提示语收藏表 """
	__tablename__ = 'prompt_fav'
	id = db.Column(db.BigInteger, primary_key=True, autoincrement=True)
	prompt_id = db.Column(db.Integer, nullable=False) # 提示语ID
	customer_id = db.Column(db.Integer, nullable=False) # 用户ID
	created_at = db.Column(db.DateTime) # 收藏时间
	updated_at = db.Column(db.DateTime) # 更新时间