File size: 837 Bytes
20a519c |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
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)
|