from utils.db_connect import BaseModelForTable
from sqlalchemy import Column, String, Integer, ForeignKey, UUID
from sqlalchemy.orm import relationship

class ProjectWorkflowStatus(BaseModelForTable):
    __tablename__ = 'project_workflow_statuses'

    project_id = Column(
        UUID(as_uuid=True),
        ForeignKey('projects.id', ondelete='CASCADE'),
        nullable=False,
        index=True
    )

    status_key = Column(String(50), nullable=False)
    label = Column(String(100), nullable=False)
    color = Column(String(50), nullable=False)
    order = Column(Integer, default=0, nullable=False)

    project = relationship("Project", back_populates="workflow_statuses")