| from sqlmodel import SQLModel, Field | |
| from datetime import datetime, date | |
| from typing import Optional | |
| class Task(SQLModel, table=True): | |
| """Task entity representing a to-do item.""" | |
| __tablename__ = "tasks" | |
| id: Optional[int] = Field(default=None, primary_key=True) | |
| user_id: int = Field(foreign_key="users.id", nullable=False, index=True) | |
| title: str = Field(max_length=200, nullable=False) | |
| description: Optional[str] = Field(default=None, max_length=1000) | |
| completed: bool = Field(default=False, nullable=False, index=True) | |
| due_date: Optional[date] = Field(default=None) | |
| priority: str = Field(default="medium", max_length=20) | |
| created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False, index=True) | |
| updated_at: datetime = Field(default_factory=datetime.utcnow, nullable=False) | |