from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import relationship

from ..database import Base

from . import Produto, Servico, Cliente, Funcionario, Fornecedor, VisitaComercial, Despesa


class Usuario(Base):
    __tablename__ = "usuario"

    id = Column(Integer, primary_key=True, name="usu_id")
    nome = Column(String, name="usu_nome")
    login = Column(String, name="usu_login")
    senha = Column(String, name="usu_senha")

    produtos = relationship("Produto", back_populates="usuario")
    servicos = relationship("Servico", back_populates="usuario")
    clientes = relationship("Cliente", back_populates="usuario")
    funcionarios = relationship("Funcionario", back_populates="usuario")
    fornecedores = relationship("Fornecedor", back_populates="usuario")
    visitas_comerciais = relationship("VisitaComercial", back_populates="usuario")
    despesas = relationship("Despesa", back_populates="usuario")
    orcamentos = relationship("Orcamento", back_populates="usuario")