22 lines
912 B
Python
22 lines
912 B
Python
"""Rückmeldungen zu Antworten: hilfreich oder nicht, mit optionalem Kommentar (Bewertung des PoC)."""
|
|
|
|
from datetime import datetime
|
|
|
|
from sqlalchemy import ForeignKey, SmallInteger, String
|
|
from sqlalchemy.orm import Mapped, mapped_column
|
|
|
|
from app.core.database import Base, now
|
|
|
|
UP, DOWN = 1, -1
|
|
|
|
|
|
class AnswerFeedback(Base):
|
|
__tablename__ = "answer_feedback"
|
|
|
|
# Eine Rückmeldung je Person und Antwort; ändern überschreibt
|
|
message_id: Mapped[int] = mapped_column(ForeignKey("messages.id", ondelete="CASCADE"), primary_key=True)
|
|
user_id: Mapped[int] = mapped_column(ForeignKey("users.id", ondelete="CASCADE"), primary_key=True, index=True)
|
|
rating: Mapped[int] = mapped_column(SmallInteger)
|
|
comment: Mapped[str] = mapped_column(String(1000), default="")
|
|
created: Mapped[datetime] = mapped_column(default=now, index=True)
|
|
updated: Mapped[datetime] = mapped_column(default=now)
|