Spaces:
Configuration error
Configuration error
File size: 1,014 Bytes
419bd6e | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | from sqlalchemy.orm import relationship
from sqlalchemy import Column, Integer, String, Text, DateTime, ForeignKey
from datetime import datetime
from app.database import Base
class ContactMessage(Base):
__tablename__ = "contact_messages"
id = Column(Integer, primary_key=True, index=True)
name = Column(String(255), nullable=False)
email = Column(String(255), nullable=False)
subject = Column(String(1000), nullable=True)
message = Column(Text, nullable=False)
created_at = Column(DateTime, default=datetime.utcnow)
# Many replies
replies = relationship("ContactReply", back_populates="message")
class ContactReply(Base):
__tablename__ = "contact_replies"
id = Column(Integer, primary_key=True, index=True)
message_id = Column(Integer, ForeignKey("contact_messages.id"), nullable=False)
content = Column(Text, nullable=False)
created_at = Column(DateTime, default=datetime.utcnow)
message = relationship("ContactMessage", back_populates="replies")
|