from core.database import SqlServerBase
from sqlalchemy import Column, String, Integer, DateTime, Boolean, Time

class User(SqlServerBase):
    __tablename__ = "Usuario"
    __table_args__ = {"schema": "dbo"}

    IdUsuario = Column(Integer, primary_key=True, index=True)
    Nome = Column(String(255), nullable=True)
    Senha = Column(String(255), nullable=True)
    Email = Column(String(255), unique=True, index=True, nullable=True)
    Telefone = Column(String(50), nullable=True)
    Celular = Column(String(50), nullable=True)
    Cargo = Column(String(255), nullable=True)
    DataCadastro = Column(DateTime, nullable=True)
    DataAlteracao = Column(DateTime, nullable=True)
    DataUltimoAcesso = Column(DateTime, nullable=True)
    IdCliente = Column(Integer, nullable=True)
    IdContador = Column(Integer, nullable=True)
    IdEstado = Column(Integer, nullable=True)
    IdPerfil = Column(Integer, nullable=True)
    UsuarioMaster = Column(Boolean, nullable=True)
    DataExpiracao = Column(DateTime, nullable=True)
    DiasTrabalho = Column(String(255), nullable=True)
    HoraInicioExpediente = Column(Time, nullable=True)
    HoraFimExpediente = Column(Time, nullable=True)
    IdUsuarioCrm = Column(Integer, nullable=True)
    Mesoregiao = Column(String(255), nullable=True)
    SenhaBCrypt = Column(String(255), nullable=True)
    Status = Column(String(50), nullable=True)
    SenhaNovoPadrao = Column(String(255), nullable=True)
    token = Column(String(255), nullable=True, index=True)