/
tinypot
/
integr
Обзор
Документация
Войти
/
tinypot
/
integr
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
task_management_api/app/models/category.py
30 строк
1 KB
Tim Polus
lab1
21 янв 2026, 23:15
21 янв 2026, 23:15
dd1578c
Код
Авторство
О чём код?
""" Category model """ from datetime import datetime from sqlalchemy import Column, Integer, String, DateTime, Text, ForeignKey from sqlalchemy.sql import func from sqlalchemy.orm import relationship from app.core.database import Base class Category(Base): """Category model for organizing tasks""" __tablename__ = "categories" id = Column(Integer, primary_key=True, index=True) name = Column(String, nullable=False, index=True) description = Column(Text, nullable=True) color = Column(String(7), nullable=True) # Hex color code like #FF5733 user_id = Column(Integer, ForeignKey("users.id"), nullable=False) created_at = Column(DateTime(timezone=True), server_default=func.now()) updated_at = Column(DateTime(timezone=True), onupdate=func.now()) # Relationship user = relationship("User", back_populates="categories") tasks = relationship("Task", back_populates="category") def __repr__(self): return f"<Category(id={self.id}, name={self.name}, user_id={self.user_id})>"