anas-ahmed's picture
Add archiving and notifications features
3d2c240
Raw History Blame Contribute Delete
2.09 kB
from sqlmodel import SQLModel, Field, Relationship
from typing import Optional, List
import uuid
from datetime import datetime
class Project(SQLModel, table=True):
id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
user_id: uuid.UUID = Field(index=True)
name: str
framework: str = Field(default="KANBAN_FIXED") # Enum: KANBAN_FIXED
is_default: bool = Field(default=False)
created_at: datetime = Field(default_factory=datetime.utcnow)
tasks: List["ProjectTask"] = Relationship(back_populates="project", sa_relationship_kwargs={"cascade": "all, delete-orphan"})
members: List["ProjectMember"] = Relationship(back_populates="project", sa_relationship_kwargs={"cascade": "all, delete-orphan"})
class ProjectTask(SQLModel, table=True):
__tablename__ = "project_task"
id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
project_id: uuid.UUID = Field(foreign_key="project.id")
status: str = Field(default="TODO") # Enum: TODO, IN_PROGRESS, DONE
priority: str = Field(default="MEDIUM") # Enum: LOW, MEDIUM, HIGH
due_date: Optional[datetime] = Field(default=None)
content: str
order_index: float = Field(default=0.0)
assignee_id: Optional[uuid.UUID] = Field(default=None, index=True) # user.id of assigned member
is_archived: bool = Field(default=False)
archived_at: Optional[datetime] = Field(default=None)
created_at: datetime = Field(default_factory=datetime.utcnow)
updated_at: datetime = Field(default_factory=datetime.utcnow)
project: Optional[Project] = Relationship(back_populates="tasks")
class ProjectMember(SQLModel, table=True):
__tablename__ = "project_member"
id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
project_id: uuid.UUID = Field(foreign_key="project.id", index=True)
user_id: uuid.UUID = Field(index=True)
role: str = Field(default="member") # "owner" or "member"
joined_at: datetime = Field(default_factory=datetime.utcnow)
project: Optional[Project] = Relationship(back_populates="members")