from datetime import datetime

from sqlalchemy import Column, Integer, String, DateTime, Text

from app.db import EntityBase


class Role(EntityBase):
    __tablename__ = "roles"

    id = Column(Integer, primary_key=True)
    name = Column(String(64), unique=True, nullable=False)
    description = Column(Text)
    creation_date = Column(DateTime, nullable=False, default=datetime.utcnow())