Spaces:
Sleeping
Sleeping
File size: 1,378 Bytes
daeb635 ed0670a daeb635 3d2c240 daeb635 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | from sqlmodel import SQLModel, Field, Relationship
from typing import Optional, List
import uuid
from datetime import datetime
class Note(SQLModel, table=True):
id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
user_id: uuid.UUID = Field(index=True)
category_id: Optional[uuid.UUID] = Field(default=None, foreign_key="category.id")
title: Optional[str] = None
content: Optional[str] = None # Text content (Markdown)
order_index: float = Field(default=0.0)
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)
# Relationship to MediaAsset
media_assets: List["MediaAsset"] = Relationship(back_populates="note", sa_relationship_kwargs={"cascade": "all, delete-orphan"})
class MediaAsset(SQLModel, table=True):
__tablename__ = "media_asset" # Explicit table name to avoid potential conflicts
id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
note_id: uuid.UUID = Field(foreign_key="note.id")
mime_type: str
data: bytes # BLOB storage
created_at: datetime = Field(default_factory=datetime.utcnow)
# Relationship back to Note
note: Optional[Note] = Relationship(back_populates="media_assets")
|