cif/store/sqlite/message.py
from sqlalchemy import Column, Integer, ForeignKey, UnicodeText
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from .indicator import Indicator
Base = declarative_base()
class Message(Base):
__tablename__ = 'messages'
id = Column(Integer, primary_key=True)
message = Column(UnicodeText)
indicator_id = Column(Integer, ForeignKey('indicators.id', ondelete='CASCADE'))
indicator = relationship(
Indicator,
)