from sqlalchemy import Column, String, DateTime, func
from sqlalchemy.orm import relationship
from app.models.base import BaseModel


class Role(BaseModel):
    __tablename__ = "roles"

    slug = Column(String(255), nullable=False)
    name = Column(String(255), nullable=False)
    users = relationship("User", back_populates="role")
    permissions = relationship(
        "PermissionRole", back_populates="role", cascade="all, delete-orphan"
    )