from sqlalchemy import Column, Integer, String, ForeignKey
from app.database import Base


class TachePlanning(Base):
    __tablename__ = "taches_planning"

    id = Column(Integer, primary_key=True, index=True)
    projet_id = Column(Integer, ForeignKey("projets.id", ondelete="CASCADE"), nullable=False)
    niveau_id = Column(Integer, ForeignKey("niveaux.id", ondelete="SET NULL"), nullable=True)
    piece_id = Column(Integer, ForeignKey("pieces.id", ondelete="SET NULL"), nullable=True)
    operateur_id = Column(Integer, ForeignKey("operateurs.id", ondelete="SET NULL"), nullable=True)
    date_debut = Column(String, nullable=False)
    date_fin = Column(String, nullable=False)
    statut = Column(String, default="planifie")
    commentaire = Column(String, nullable=True)
    date_creation = Column(String, nullable=True)