from sqlalchemy import Column, String,Integer, Boolean, DateTime 
from sqlalchemy.sql import func
from src.models.base import Base
from src.db.mixins import AuditMixin
from sqlalchemy.orm import relationship
#from src.models.module.models import Module

class Project(AuditMixin, Base):
    __tablename__ = "proman_project"
    id = Column(Integer, primary_key=True)
    name = Column(String(100), nullable=False, unique=True)
    status = Column(String(120), nullable=False)
    is_active = Column(Boolean, default=True)        
    created_at = Column(DateTime(timezone=True), default=func.now())
    updated_at = Column(DateTime(timezone=True), nullable=False, default=func.now(), onupdate=func.now())

    #modules = relationship("Module", back_populates="projects")