from sqlalchemy import Column, Integer, String, Boolean, DateTime, func, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship


Base = declarative_base()
class Messages(Base):
    __tablename__ = "message"

    id_message = Column(Integer, primary_key=True,autoincrement=True)
    sujet = Column(String, nullable=False)
    message = Column(String, nullable=False)
    id_source = Column(Integer, nullable=False)
    id_dest = Column(Integer, nullable=False)
    generated_at = Column(DateTime, nullable=False, server_default=func.now())