SQLModel Task Models

This skill providing guidance on defining a robust database schema using SQLModel for the Todo application.

Purpose

Defining a robust, type-safe, and async-compatible database schema for the Todo application using SQLModel, ensuring compatibility with Better Auth and optimized for PostgreSQL.

Capabilities

Implementation Details

Models Definition

```python

from sqlmodel import SQLModel, Field, Relationship

from typing import List, Optional

from datetime import datetime

class User(SQLModel, table=True):

id: str = Field(primary_key=True)

email: str = Field(unique=True, index=True)

name: Optional[str] = None

created_at: datetime = Field(default_factory=datetime.utcnow)

tasks: List["Task"] = Relationship(back_populates="user")

class Task(SQLModel, table=True):

id: Optional[int] = Field(default=None, primary_key=True)

user_id: str = Field(foreign_key="user.id", index=True)

title: str

description: Optional[str] = None

completed: bool = Field(default=False, index=True)

created_at: datetime = Field(default_factory=datetime.utcnow)

updated_at: datetime = Field(default_factory=datetime.utcnow)

user: Optional[User] = Relationship(back_populates="tasks")

```

Best Practices