from sqlalchemy import Column, Integer, String, DateTime
from sqlalchemy.ext.declarative import declarative_base
from datetime import datetime

Base = declarative_base()

class SysSscf(Base):
    """
    短句配置表
    """
    __tablename__ = 't_keyword'

    onum = Column(Integer, primary_key=True, autoincrement=True, comment='序号')
    dasset_id = Column(String(500), default=0, comment='数据域名ID')
    keywords = Column(String(500), nullable=True, comment='关键词JSON')  # 根据你的注释，这里使用了String而不是JSON
    keyword = Column(String(500), nullable=True, comment='关键词')
    algorithm = Column(String(500), nullable=True, comment='算法')
    order = Column(String(500), nullable=True, comment='指令')
    whole_sentence = Column(String(500), nullable=True, comment='整句')
    type = Column(String(500), nullable=True, comment='类型')
    supp_expl = Column(String(500), nullable=True, comment='补充说明')
    bak1 = Column(String(500), nullable=True, comment='备注1')
    bak2 = Column(String(500), nullable=True, comment='备注2')
    bak3 = Column(String(500), nullable=True, comment='备注3')
    bak4 = Column(String(500), nullable=True, comment='备注4')
    bak5 = Column(String(500), nullable=True, comment='备注5')
    status = Column(String(1), default='0', comment='有效标志')
    del_flag = Column(String(1), default='0', comment='删除标志')
    update_time = Column(DateTime, default=datetime.now, comment='更新时间')
    update_by = Column(String(50), default='', comment='更新者')
    create_time = Column(DateTime, default=datetime.now, comment='创建时间')
    create_by = Column(String(50), default='', comment='创建者')