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

from ..database import Base


class Cliente(Base):
    __tablename__ = "cliente"

    id = Column(Integer, primary_key=True, name="cli_id")
    usuario_id = Column(Integer, ForeignKey("usuario.usu_id"), name="usu_id")
    cep = Column(String, name="cli_cep")
    logradouro = Column(String, name="cli_logradouro")
    bairro = Column(String, name="cli_bairro")
    cidade = Column(String, name="cli_cidade")
    estado = Column(String, name="cli_estado")
    numero = Column(Integer, name="cli_numero")
    complemento = Column(String, name="cli_complemento")
    licenca_operacional = Column(String, name="cli_licenca_operacional")
    email = Column(String, name="cli_email")
    telefone = Column(String, name="cli_telefone")

    usuario = relationship("Usuario", back_populates="clientes")
    orcamentos = relationship("Orcamento", back_populates="cliente")