from sqlalchemy import BigInteger, String, Date
from sqlalchemy.orm import mapped_column
from app.database import db


class User(db.Model):
    __tablename__ = 'users'

    id = mapped_column(BigInteger, primary_key=True)
    email = mapped_column(String, nullable=False)
    first_name = mapped_column(String, nullable=False)
    last_name = mapped_column(String, nullable=False)
    role = mapped_column(String(10), nullable=False)
    created_at = mapped_column(Date, nullable=False)