File size: 889 Bytes
43e23ba |
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 |
"""
Project Model - Workspaces for organizing investigations
"""
from sqlalchemy import Column, String, Text, DateTime
from datetime import datetime
import uuid
from app.core.database import Base
def generate_uuid():
return str(uuid.uuid4())
class Project(Base):
"""
Projeto/Workspace - agrupa entidades e relacionamentos por investigação
"""
__tablename__ = "projects"
id = Column(String(36), primary_key=True, default=generate_uuid)
name = Column(String(255), nullable=False)
description = Column(Text, nullable=True)
color = Column(String(7), default="#00d4ff") # Hex color for UI
icon = Column(String(50), default="folder") # Icon name
# Timestamps
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|