okuma-app / backend /models /assignment.py
Cihan Emre ŞAHİN
init with lfs
e94bb15
Raw History Blame Contribute Delete
1.15 kB
from sqlalchemy import Column, Integer, String, DateTime, Enum as SQLEnum, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.sql import func
import enum
from database import Base
class AssignmentStatus(str, enum.Enum):
PENDING = "bekliyor"
COMPLETED = "tamamlandi"
OVERDUE = "gecikti"
class Assignment(Base):
__tablename__ = "assignments"
id = Column(Integer, primary_key=True, index=True)
teacher_id = Column(Integer, ForeignKey("users.id"), nullable=False)
student_id = Column(Integer, ForeignKey("users.id"), nullable=False)
story_id = Column(Integer, ForeignKey("stories.id"), nullable=False)
status = Column(SQLEnum(AssignmentStatus), default=AssignmentStatus.PENDING)
assigned_at = Column(DateTime(timezone=True), server_default=func.now())
due_date = Column(DateTime(timezone=True), nullable=True)
completed_at = Column(DateTime(timezone=True), nullable=True)
# Relationships
teacher = relationship("User", foreign_keys=[teacher_id])
student = relationship("User", foreign_keys=[student_id], back_populates="assignments")
story = relationship("Story")