backend/workspace/models.py

from sqlalchemy import Column, Integer, String, DateTime, Text, JSON, Boolean, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from datetime import datetime

Base = declarative_base()

class Workspace(Base):
    __tablename__ = "workspaces"
    id = Column(Integer, primary_key=True)
    workspace_id = Column(String(64), unique=True, nullable=False)
    name = Column(String(128), nullable=False)
    owner = Column(String(64), nullable=True)
    created_at = Column(DateTime, default=datetime.utcnow)
    updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    files = relationship("WorkspaceFile", back_populates="workspace")

class WorkspaceFile(Base):
    __tablename__ = "workspace_files"
    id = Column(Integer, primary_key=True)
    file_id = Column(String(64), unique=True, nullable=False)
    workspace_id = Column(Integer, ForeignKey("workspaces.id"))
    path = Column(String(512), nullable=False)          # relative path
    content = Column(Text, nullable=True)
    language = Column(String(32), nullable=True)        # e.g., python, javascript, etc.
    version = Column(Integer, default=1)
    created_at = Column(DateTime, default=datetime.utcnow)
    updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    workspace = relationship("Workspace", back_populates="files")
    dependencies = relationship("FileDependency", foreign_keys="FileDependency.from_file_id", back_populates="from_file")
    dependents = relationship("FileDependency", foreign_keys="FileDependency.to_file_id", back_populates="to_file")

class FileDependency(Base):
    __tablename__ = "file_dependencies"
    id = Column(Integer, primary_key=True)
    from_file_id = Column(Integer, ForeignKey("workspace_files.id"))
    to_file_id = Column(Integer, ForeignKey("workspace_files.id"))
    dep_type = Column(String(32), default="import")    # import, require, include, etc.
    created_at = Column(DateTime, default=datetime.utcnow)
    from_file = relationship("WorkspaceFile", foreign_keys=[from_file_id], back_populates="dependencies")
    to_file = relationship("WorkspaceFile", foreign_keys=[to_file_id], back_populates="dependents")