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


class Operateur(Base):
    __tablename__ = "operateurs"

    id = Column(Integer, primary_key=True, index=True)
    nom = Column(String, nullable=False)
    prenom = Column(String, nullable=False)
    poste = Column(String, nullable=True)
    couleur = Column(String, default="#4facfe")
    categorie = Column(String, default="production")
    actif = Column(Integer, default=1)
    date_creation = Column(String, nullable=True)


class AbsenceOperateur(Base):
    __tablename__ = "absences_operateurs"

    id = Column(Integer, primary_key=True, index=True)
    operateur_id = Column(Integer, nullable=False)
    type = Column(String, nullable=False)  # conge, absence, formation
    date_debut = Column(String, nullable=False)
    date_fin = Column(String, nullable=False)
    commentaire = Column(String, nullable=True)