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

from ..database import Base


class Fornecedor(Base):
    __tablename__ = "fornecedor"

    id = Column(Integer, primary_key=True, name="for_id")
    usuario_id = Column(Integer, ForeignKey("usuario.usu_id"), name="usu_id")
    razao_social = Column(String, name="for_razao_social")
    nome_fantasia = Column(String, name="for_nome_fantasia")
    email = Column(String, name="for_email")
    telefone = Column(String, name="for_telefone")
    responsavel = Column(String, name="for_responsavel")
    cep = Column(String, name="for_cep")
    logradouro = Column(String, name="for_logradouro")
    bairro = Column(String, name="for_bairro")
    cidade = Column(String, name="for_cidade")
    estado = Column(String, name="for_estado")
    numero = Column(Integer, name="for_numero")
    complemento = Column(String, name="for_complemento")
    banco = Column(String, name="for_banco")
    agencia = Column(String, name="for_agencia")
    conta = Column(String, name="for_conta")
    titular = Column(String, name="for_titular")
    pix = Column(String, name="for_pix")
    observacoes = Column(Text, name="for_observacoes")
    cnpj = Column(String, name="for_cnpj")

    usuario = relationship("Usuario", back_populates="fornecedores")