class Event(Base):
    __tablename__ = "stat_calendar_events"

    id = Column(Integer, primary_key=True)
    gid = Column(String(30), index=True, unique=True, nullable=True, default=None, server_default=None)

    type_id = Column(Integer, ForeignKey("stat_calendar_types.id", onupdate="CASCADE", ondelete="RESTRICT"), nullable=False)

    caption = Column(String(100), index=True, nullable=False)
    description = Column(String(200), nullable=True)
    rrule = Column(String(250), nullable=True)
    date = column_property(func.unnest(func.get_occurrences(cast(rrule, RRule), cast(func.now(), TIMESTAMP))).label("date"))

    type = relationship(EventType, uselist=False, backref="events")

    is_import = Column(Boolean, server_default="false", default=False)