from sqlalchemy import ForeignKey
from sqlalchemy import Column, Integer, Boolean, DateTime 
from sqlalchemy.sql import func
from src.models.base import Base
from src.db.mixins import AuditMixin

class Member(AuditMixin, Base):
    __tablename__ = "proman_member"
    id = Column(Integer, primary_key=True)
    project_id = Column(Integer, ForeignKey('proman_project.id'), nullable=False)
    member_hrms_user_id = Column(Integer, ForeignKey('hrms_employee_profile.user_id'), 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())