| 123456789101112131415161718192021222324 |
- """中国节假日日历缓存模型"""
- from datetime import datetime
- from sqlalchemy import Column, Date, DateTime, SmallInteger, String, Text, UniqueConstraint
- from app.core.database import Base
- class SysCnHolidayDay(Base):
- """中国节假日日历缓存 sys_cn_holiday_day"""
- __tablename__ = "sys_cn_holiday_day"
- __table_args__ = (UniqueConstraint("day_date", name="uk_day_date"),)
- id = Column(String(64), primary_key=True, comment="UUID")
- day_date = Column(Date, nullable=False, comment="日历日")
- day_type = Column(SmallInteger, nullable=False, comment="0工作日1周末2节日3调休放假4补班")
- day_name = Column(String(64), nullable=True, comment="名称")
- week = Column(SmallInteger, nullable=True, comment="1-7周一到周日")
- is_rest_day = Column(SmallInteger, nullable=False, default=0, comment="1休息0工作")
- raw_json = Column(Text, nullable=True, comment="原始JSON片段")
- sync_time = Column(DateTime, nullable=True, comment="同步时间")
- create_time = Column(DateTime, nullable=True, default=datetime.now, comment="创建时间")
- update_time = Column(DateTime, nullable=True, default=datetime.now, onupdate=datetime.now, comment="更新时间")
|
