mirror of
https://github.com/insistence/RuoYi-Vue3-FastAPI.git
synced 2026-09-22 05:02:58 +00:00
61 lines
2.2 KiB
Python
61 lines
2.2 KiB
Python
from sqlalchemy import CHAR, BigInteger, Column, Integer, LargeBinary, String, UniqueConstraint
|
|
from sqlalchemy.dialects import mysql
|
|
|
|
from common.mixin import AuditTimeMixin
|
|
from common.types import DbUtcDateTime
|
|
from config.database import Base
|
|
from config.env import DataBaseConfig
|
|
from utils.common_util import SqlalchemyUtil
|
|
from utils.time_util import TimezoneUtil
|
|
|
|
|
|
class SysNotice(AuditTimeMixin, Base):
|
|
"""
|
|
通知公告表
|
|
"""
|
|
|
|
__tablename__ = 'sys_notice'
|
|
__table_args__ = {'comment': '通知公告表'}
|
|
|
|
notice_id = Column(Integer, primary_key=True, nullable=False, autoincrement=True, comment='公告ID')
|
|
notice_title = Column(String(50), nullable=False, comment='公告标题')
|
|
notice_type = Column(CHAR(1), nullable=False, comment='公告类型（1通知 2公告）')
|
|
notice_content = Column(
|
|
mysql.LONGBLOB if DataBaseConfig.default_source.db_type == 'mysql' else LargeBinary,
|
|
nullable=True,
|
|
server_default=SqlalchemyUtil.get_server_default_null(DataBaseConfig.default_source.db_type, False),
|
|
comment='公告内容',
|
|
)
|
|
status = Column(CHAR(1), nullable=True, server_default='0', comment='公告状态（0正常 1关闭）')
|
|
create_by = Column(String(64), nullable=True, server_default="''", comment='创建者')
|
|
update_by = Column(String(64), nullable=True, server_default="''", comment='更新者')
|
|
remark = Column(
|
|
String(255),
|
|
nullable=True,
|
|
server_default=SqlalchemyUtil.get_server_default_null(DataBaseConfig.default_source.db_type),
|
|
comment='备注',
|
|
)
|
|
|
|
|
|
class SysNoticeRead(Base):
|
|
"""
|
|
公告已读记录表
|
|
"""
|
|
|
|
__tablename__ = 'sys_notice_read'
|
|
__table_args__ = (
|
|
UniqueConstraint('user_id', 'notice_id', name='uk_user_notice'),
|
|
{'comment': '公告已读记录表'},
|
|
)
|
|
|
|
read_id = Column(
|
|
BigInteger().with_variant(Integer, 'sqlite'),
|
|
primary_key=True,
|
|
nullable=False,
|
|
autoincrement=True,
|
|
comment='已读主键',
|
|
)
|
|
notice_id = Column(Integer, nullable=False, comment='公告ID')
|
|
user_id = Column(BigInteger, nullable=False, comment='用户ID')
|
|
read_time = Column(DbUtcDateTime(), nullable=False, default=TimezoneUtil.utc_now, comment='阅读时间')
|