peewee Coletando dados das classes no PostgreSQL

data_class_peewee.py

# Criando as classes com PeeWee

#Conectando ao PostgreSQL

python -m pwiz -e postgresql -u postgres -s wshop -P 5432 ALTERDATA_WSHOP

# Classes do Shop


from peewee import *

database = PostgresqlDatabase('ALTERDATA_WSHOP', **{'user': 'postgres', 'password': '#abc123#'})

class UnknownField(object):
    def __init__(self, *_, **__): pass

class BaseModel(Model):
    class Meta:
        database = database

class Bairro(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    idbairro = CharField(primary_key=True)
    nmbairro = CharField(index=True, null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'bairro'
        schema = 'wshop'

class Caracpd(BaseModel):
    alsazonalidade = CharField(null=True)
    cdchamada = CharField(null=True, unique=True)
    cdexterno = CharField(null=True)
    dscaracteristica = CharField(null=True)
    idcaracteristica = CharField(primary_key=True)
    sazonalidade = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stobrigatoria = BooleanField(null=True)

    class Meta:
        table_name = 'caracpd'
        schema = 'wshop'

class Caracps(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    cdexterno = CharField(null=True)
    dscaracpessoa = CharField(null=True)
    idcaracpessoa = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'caracps'
        schema = 'wshop'

class Categoria(BaseModel):
    cdcategoria = CharField(index=True, null=True)
    dscategoria = CharField(index=True, null=True)
    idcategoria = CharField(primary_key=True)
    idcategoriapai = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'categoria'
        schema = 'wshop'

class CategoriaProduto(BaseModel):
    idcategoria = CharField(index=True)
    idproduto = CharField(index=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'categoria_produto'
        indexes = (
            (('idproduto', 'idcategoria'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idcategoria', 'idproduto')

class Cdfscal(BaseModel):
    cdfiscal = CharField(null=True, unique=True)
    dsfiscal = CharField(null=True)
    idcdfiscal = CharField(primary_key=True)
    idcdfiscaldev = CharField(null=True)
    idfiscalequivalente = CharField(null=True)
    idmensagem = CharField(null=True)
    stdevolucaovenda = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stoperacao = CharField(null=True)
    stsubstinterna = BooleanField(null=True)
    tpmovimento = CharField(null=True)

    class Meta:
        table_name = 'cdfscal'
        schema = 'wshop'

class Cep(BaseModel):
    cdcep = CharField(primary_key=True)
    cduf = CharField(null=True)
    idbairro = CharField(null=True)
    idcidade = CharField(null=True)
    idtplogradouro = CharField(null=True)
    nmlogradouro = CharField(index=True, null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'cep'
        schema = 'wshop'

class Cidade(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    cdpaisbacen = CharField(null=True)
    cduf = CharField()
    idcidade = CharField()
    nmcidade = CharField(index=True, null=True)
    nmpaisbacen = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'cidade'
        indexes = (
            (('idcidade', 'cduf'), True),
            (('nmcidade', 'cduf'), False),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cduf', 'idcidade')

class Codigo(BaseModel):
    fieldname = CharField(index=True, null=True)
    lastcode = DoubleField(null=True)

    class Meta:
        table_name = 'codigo'
        schema = 'wshop'
        primary_key = False

class Codigos(BaseModel):
    cdexterno = CharField(null=True)
    cod_anterior = CharField(null=True)
    data_cod_anterior = DateTimeField(null=True)
    dscodigo = CharField(index=True)
    iddetalhe = CharField(index=True, null=True)
    idproduto = CharField(null=True)
    stexp = CharField(index=True, null=True)
    tpcodigo = CharField()

    class Meta:
        table_name = 'codigos'
        indexes = (
            (('iddetalhe', 'tpcodigo'), False),
            (('tpcodigo', 'dscodigo'), True),
            (('tpcodigo', 'dscodigo', 'iddetalhe'), False),
        )
        schema = 'wshop'
        primary_key = CompositeKey('dscodigo', 'tpcodigo')

class Crediar(BaseModel):
    cdexterno = CharField(null=True)
    cdliberacaospc = CharField(null=True)
    cdufant = CharField(null=True)
    conceito = CharField(null=True)
    dsalugcasa = CharField(null=True)
    dsapelido = CharField(null=True)
    dsatividade = CharField(null=True)
    dsbairro = CharField(null=True)
    dsbairrosocio1 = CharField(null=True)
    dsbairrosocio2 = CharField(null=True)
    dscargo = CharField(null=True)
    dscargoavalista = CharField(null=True)
    dscargoconj = CharField(null=True)
    dscargosocio1 = CharField(null=True)
    dscargosocio2 = CharField(null=True)
    dscartfunci = CharField(null=True)
    dscartprof = CharField(null=True)
    dscartprofavalista = CharField(null=True)
    dscartprofconj = CharField(null=True)
    dscepant = CharField(null=True)
    dscidad_ant = CharField(null=True)
    dscidadesocio1 = CharField(null=True)
    dscidadesocio2 = CharField(null=True)
    dscomplementoendant = CharField(null=True)
    dscomplementosocio1 = CharField(null=True)
    dscomplementosocio2 = CharField(null=True)
    dscpfavalista = CharField(null=True)
    dscpfconj = CharField(null=True)
    dscpfconjsocio1 = CharField(null=True)
    dscpfconjsocio2 = CharField(null=True)
    dscpfsocio1 = CharField(null=True)
    dscpfsocio2 = CharField(null=True)
    dsendant = CharField(null=True)
    dsendavalista = CharField(null=True)
    dsendfirma = CharField(null=True)
    dsendfirmavalista = CharField(null=True)
    dsendfirmconj = CharField(null=True)
    dsendlocador = CharField(null=True)
    dsendref1 = CharField(null=True)
    dsendref2 = CharField(null=True)
    dsendrefcomercial = CharField(null=True)
    dsendsocio1 = CharField(null=True)
    dsendsocio2 = CharField(null=True)
    dsestadocivilsocio1 = CharField(null=True)
    dsestadocivilsocio2 = CharField(null=True)
    dsestcivil = CharField(null=True)
    dsidentavalista = CharField(null=True)
    dsidentconj = CharField(null=True)
    dsidentconjsocio1 = CharField(null=True)
    dsidentconjsocio2 = CharField(null=True)
    dsidentsocio1 = CharField(null=True)
    dsidentsocio2 = CharField(null=True)
    dsimoveis = CharField(null=True)
    dsmotivo = TextField(null=True)
    dsnatural = CharField(null=True)
    dsoutrrenconj = CharField(null=True)
    dsoutrrenda = CharField(null=True)
    dsoutrrendavalista = CharField(null=True)
    dsregcivil = CharField(null=True)
    dsregjunta = CharField(null=True)
    dssecao = CharField(null=True)
    dssecaoavalista = CharField(null=True)
    dssecaoconj = CharField(null=True)
    dstempavalista = CharField(null=True)
    dstempcasaconj = CharField(null=True)
    dstempfirma = CharField(null=True)
    dstempo_res = CharField(null=True)
    dsufsocio1 = CharField(null=True)
    dsufsocio2 = CharField(null=True)
    dtcadbanco = DateTimeField(null=True)
    dtcadrefcom = DateTimeField(null=True)
    dtdatanasc = DateTimeField(null=True)
    dtemiciaval = DateTimeField(null=True)
    dtemiciconj = DateTimeField(null=True)
    dtinicativ = DateTimeField(null=True)
    dtnascavalista = DateTimeField(null=True)
    dtnascconjsocio1 = DateTimeField(null=True)
    dtnascconjsocio2 = DateTimeField(null=True)
    dtnascsocio1 = DateTimeField(null=True)
    dtnascsocio2 = DateTimeField(null=True)
    dtultcompra = DateTimeField(null=True)
    dtvalidade = DateTimeField(null=True)
    idbairroendant = CharField(null=True)
    idbairrosocio1 = CharField(null=True)
    idbairrosocio2 = CharField(null=True)
    idcidadeendant = CharField(null=True)
    idcidadesocio1 = CharField(null=True)
    idcidadesocio2 = CharField(null=True)
    idpessoa = CharField(primary_key=True)
    idtplogradouroendant = CharField(null=True)
    idtplogradourosocio1 = CharField(null=True)
    idtplogradourosocio2 = CharField(null=True)
    nmavalista = CharField(null=True)
    nmbanco = CharField(null=True)
    nmconjavalista = CharField(null=True)
    nmconjsocio1 = CharField(null=True)
    nmconjsocio2 = CharField(null=True)
    nmconjuge = CharField(null=True)
    nmfirma = CharField(null=True)
    nmfirmaavalista = CharField(null=True)
    nmfirmatrab = CharField(null=True)
    nmfirmatrabconj = CharField(null=True)
    nmlocador = CharField(null=True)
    nmmae = CharField(null=True)
    nmmaeconjuge = CharField(null=True)
    nmnragencia = CharField(null=True)
    nmorgciaval = CharField(null=True)
    nmorgciconj = CharField(null=True)
    nmpai = CharField(null=True)
    nmpaiconjuge = CharField(null=True)
    nmrefcomercial = CharField(null=True)
    nmreferenc1 = CharField(null=True)
    nmreferenc2 = CharField(null=True)
    nmsocio1 = CharField(null=True)
    nmsocio2 = CharField(null=True)
    nrcepsocio1 = CharField(null=True)
    nrcepsocio2 = CharField(null=True)
    nrconta = CharField(null=True)
    nrdependentes = IntegerField(null=True)
    nrlogradouroendant = CharField(null=True)
    nrlogradourosocio1 = CharField(null=True)
    nrlogradourosocio2 = CharField(null=True)
    nrtelagencia = CharField(null=True)
    nrtelrefcom = CharField(null=True)
    qtfuncionarios = IntegerField(null=True)
    sexo = CharField(null=True)
    stchequeespecial = CharField(null=True)
    stcredautorizado = BooleanField(null=True)
    stcredbloqueado = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stpredio = CharField(null=True)
    stseguro = CharField(null=True)
    telefonefirma = CharField(null=True)
    telefonefirmavalista = CharField(null=True)
    telefonefirmconj = CharField(null=True)
    telefonesocio1 = CharField(null=True)
    telefonesocio2 = CharField(null=True)
    vlcapitalatual = DoubleField(null=True)
    vlcapitalestoque = DoubleField(null=True)
    vlcapitalgiro = DoubleField(null=True)
    vlcapitalpatrim = DoubleField(null=True)
    vlcapitalreg = DoubleField(null=True)
    vlfaturamentomensal = DoubleField(null=True)
    vloutrrenconj = DoubleField(null=True)
    vlsalarconj = DoubleField(null=True)
    vlsalario = DoubleField(null=True)
    vlsalarioavalista = DoubleField(null=True)
    vlultcompra = DoubleField(null=True)
    vlvaloralug = DoubleField(null=True)
    vlvaloroutr = DoubleField(null=True)
    vroutrrenavalista = DoubleField(null=True)

    class Meta:
        table_name = 'crediar'
        schema = 'wshop'

class Detalhe(BaseModel):
    alcargatributaria = DoubleField(null=True)
    alcofinscompra = DoubleField(null=True)
    alcomissao = DoubleField(null=True)
    alctest = DoubleField(null=True)
    alctfedimp = DoubleField(null=True)
    alctfednac = DoubleField(null=True)
    alctmun = DoubleField(null=True)
    alfcp = DoubleField(null=True)
    alipivenda = DoubleField(null=True)
    aliss = DoubleField(null=True)
    allucro = DoubleField(null=True)
    allucrodesejada = DoubleField(null=True)
    alpiscompra = DoubleField(null=True)
    alroyalties = DoubleField(null=True)
    cdcombustivelanp = CharField(null=True)
    cdexterno = CharField(null=True)
    cdnatoperservico = CharField(null=True)
    cdnaturezareceita = CharField(null=True)
    cdprincipal = CharField(index=True, null=True)
    cdprodfiscal = CharField(index=True, null=True)
    cdsittribcofins = CharField(null=True)
    cdsittribcofinsentrada = CharField(null=True)
    cdsittribpis = CharField(null=True)
    cdsittribpisentrada = CharField(null=True)
    cdsituacaooperacao = CharField(null=True)
    cdsituacaooperacaost = CharField(null=True)
    cdtratamentoespecial = CharField(null=True)
    cdtribmunicipio = CharField(null=True)
    classeenquadraipi = CharField(null=True)
    cod_seloipi = CharField(null=True)
    dsdesccomplementar = CharField(null=True)
    dsdetalhe = CharField(index=True, null=True)
    dsfatorconvetiqueta = CharField(null=True)
    dsimagem = CharField(null=True)
    dslocalizacao = CharField(null=True)
    dtaltallucrodesejada = DateTimeField(null=True)
    dtaltidunidadetransf = DateTimeField(null=True)
    dtaltnrrankloja = DateTimeField(null=True)
    dtaltpercentvendaloja = DateTimeField(null=True)
    dtaltqtcritica = DateTimeField(null=True)
    dtaltqtexpmaxima = DateTimeField(null=True)
    dtaltqtexpminima = DateTimeField(null=True)
    dtaltqtminima = DateTimeField(null=True)
    dtalttpclassifabcloja = DateTimeField(null=True)
    dtaltvloutros = DateTimeField(null=True)
    dtaltvlprecocusto = DateTimeField(null=True)
    dtaltvlprecovenda = DateTimeField(index=True, null=True)
    dtcadastro = DateTimeField(null=True)
    dtconciliacaouniversosped = DateTimeField(null=True)
    fatorconvetiqueta = DoubleField(null=True)
    fci = CharField(null=True)
    ftconvunidtributaria = DoubleField(null=True)
    idcaracteristica = CharField(null=True)
    iddetalhe = CharField(primary_key=True)
    iddetgradeh = CharField(null=True)
    iddetgradev = CharField(null=True)
    idfamilia = CharField(null=True)
    idproduto = CharField(null=True)
    idunidadecompra = CharField(null=True)
    idunidadetransf = CharField(null=True)
    naturezaoperacao = IntegerField(null=True)
    nrrankloja = IntegerField(null=True)
    nrrankrede = IntegerField(null=True)
    obs = TextField(null=True)
    origemmercadoria = CharField(null=True)
    percentvendaloja = DoubleField(null=True)
    percentvendarede = DoubleField(null=True)
    percgasnaturalglp = DoubleField(null=True)
    percgasnaturalglpimp = DoubleField(null=True)
    percgaspetroleo = DoubleField(null=True)
    pesobruto = DoubleField(null=True)
    pesoembalagem = DoubleField(null=True)
    pesoliquido = DoubleField(null=True)
    qtcritica = DoubleField(null=True)
    qtembalagem = DoubleField(null=True)
    qtestoque = DoubleField(null=True)
    qtestoque2 = DoubleField(null=True)
    qtestoquecentral = IntegerField(null=True)
    qtexpmaxima = DoubleField(null=True)
    qtexpminima = DoubleField(null=True)
    qtmaxima = DoubleField(null=True)
    qtminima = DoubleField(null=True)
    qtvendaabc = DoubleField(null=True)
    qtvendaabcrede = DoubleField(null=True)
    qtvolumes = IntegerField(null=True)
    selofiscal = BooleanField(null=True)
    stapurapiscofins = BooleanField(null=True)
    statusalt = CharField(null=True)
    stbalanca = BooleanField(null=True)
    stcardapio = BooleanField(null=True)
    stcomissionado = BooleanField(null=True)
    stconciliacaouniversosped = IntegerField(null=True)
    stdesccomplementar = BooleanField(null=True)
    stdetalheativo = BooleanField(null=True)
    steditadesc = CharField(null=True)
    stetiqgondola = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stexpimg = CharField(null=True)
    stinativo = BooleanField(null=True)
    stlojavirtual = CharField(null=True)
    stmovimentaestoque = BooleanField(null=True)
    stpesado = CharField(null=True)
    ststretchimagem = BooleanField(null=True)
    sttrabalhaiss = BooleanField(null=True)
    tpclassifabcloja = CharField(null=True)
    tpclassifabcrede = CharField(null=True)
    tpdesc2 = CharField(null=True)
    tprecolhimentoiss = CharField(null=True)
    tpunidtributaria = CharField(null=True)
    vldesc1 = DoubleField(null=True)
    vldesc2 = DoubleField(null=True)
    vllucroabc = DoubleField(null=True)
    vllucroabcrede = DoubleField(null=True)
    vloutros = DoubleField(null=True)
    vlpartidaglp = DoubleField(null=True)
    vlpercofins = DoubleField(null=True)
    vlperfrete = DoubleField(null=True)
    vlpericms = DoubleField(null=True)
    vlperipi = DoubleField(null=True)
    vlpermarkup = DoubleField(null=True)
    vlperpis = DoubleField(null=True)
    vlprecocusto = DoubleField(null=True)
    vlprecovenda = DoubleField(null=True)
    vlprecovendaant = DoubleField(null=True)
    vlvendaabc = DoubleField(null=True)
    vlvendaabcrede = DoubleField(null=True)

    class Meta:
        table_name = 'detalhe'
        indexes = (
            (('idproduto', 'iddetgradev', 'iddetgradeh'), False),
            (('sttrabalhaiss', 'dsdetalhe'), False),
        )
        schema = 'wshop'

class DetalheEncargos(BaseModel):
    cdempresa = CharField()
    dsencargos = CharField()
    iddetalhe = CharField()
    stexp = CharField(index=True, null=True)
    vlencargos = DoubleField(null=True)

    class Meta:
        table_name = 'detalhe_encargos'
        indexes = (
            (('cdempresa', 'iddetalhe', 'dsencargos'), True),
            (('iddetalhe', 'cdempresa', 'dsencargos'), False),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cdempresa', 'dsencargos', 'iddetalhe')

class DetalheMontagem(BaseModel):
    dsmontagem = CharField(null=True)
    iddetalhe = CharField(index=True, null=True)
    idmontagem = CharField(primary_key=True)
    nrordem = SmallIntegerField(null=True)
    stdesmembracomposicao = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stpercentual = BooleanField(null=True)
    tpmontagem = CharField(null=True)

    class Meta:
        table_name = 'detalhe_montagem'
        schema = 'wshop'

class DetalheMontagemitem(BaseModel):
    idmontagem = CharField(index=True, null=True)
    idmontagemitem = CharField(primary_key=True)
    idreferencia = CharField(null=True)
    nrquantidade = DoubleField(null=True)
    stexp = CharField(index=True, null=True)
    stitens = BooleanField(null=True)
    stopcional = BooleanField(null=True)

    class Meta:
        table_name = 'detalhe_montagemitem'
        schema = 'wshop'

class DetalheOutros(BaseModel):
    cdempresa = CharField()
    dsoutros = CharField()
    iddetalhe = CharField()
    stexp = CharField(index=True, null=True)
    vloutros = DoubleField(null=True)

    class Meta:
        table_name = 'detalhe_outros'
        indexes = (
            (('cdempresa', 'iddetalhe', 'dsoutros'), True),
            (('iddetalhe', 'cdempresa', 'dsoutros'), False),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cdempresa', 'dsoutros', 'iddetalhe')

class Detalheadicional(BaseModel):
    idadicional = CharField()
    iddetalhe = CharField()
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'detalheadicional'
        indexes = (
            (('iddetalhe', 'idadicional'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idadicional', 'iddetalhe')

class Detalhefoto(BaseModel):
    dsfoto = CharField(null=True)
    foto = BlobField(null=True)
    iddetalhe = CharField(null=True)
    iddetalhefoto = CharField(primary_key=True)
    miniatura = BlobField(null=True)
    stautomatica = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stexplojavirtual = CharField(index=True, null=True)
    stlojavirtual = BooleanField(null=True)
    stprincipal = BooleanField(null=True)

    class Meta:
        table_name = 'detalhefoto'
        indexes = (
            (('iddetalhe', 'stprincipal'), False),
        )
        schema = 'wshop'

class Detalheprecos(BaseModel):
    cdempresa = CharField()
    iddetalhe = CharField()
    idtabela = CharField()
    qtminima = DoubleField(null=True)
    stexp = CharField(index=True, null=True)
    vlpreco = DoubleField(null=True)

    class Meta:
        table_name = 'detalheprecos'
        indexes = (
            (('iddetalhe', 'cdempresa', 'idtabela'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cdempresa', 'iddetalhe', 'idtabela')

class Detcar(BaseModel):
    idcaracteristica = CharField()
    iddetalhe = CharField(index=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'detcar'
        indexes = (
            (('idcaracteristica', 'iddetalhe'), True),
            (('iddetalhe', 'idcaracteristica'), False),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idcaracteristica', 'iddetalhe')

class Detfor(BaseModel):
    codprodfor = CharField(null=True)
    iddetalhe = CharField(index=True, null=True)
    iddetfor = CharField(primary_key=True)
    idpessoa = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'detfor'
        indexes = (
            (('idpessoa', 'codprodfor'), False),
        )
        schema = 'wshop'

class Detgrad(BaseModel):
    dsposicao = CharField(null=True)
    dssigla = CharField(null=True)
    iddetgrade = CharField(primary_key=True)
    idgrade = CharField(index=True, null=True)
    nrposicao = IntegerField(null=True)
    numparticao = IntegerField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'detgrad'
        indexes = (
            (('idgrade', 'dssigla'), True),
            (('idgrade', 'nrposicao'), False),
        )
        schema = 'wshop'

class Dettran(BaseModel):
    capacidadekg = DoubleField(null=True)
    capacidademetrocubico = DoubleField(null=True)
    cdchamada = CharField(null=True, unique=True)
    cnpjcpfpropietario = CharField(null=True)
    dsespecie = CharField(null=True)
    dsmarca = CharField(null=True)
    dsplaca = CharField(null=True)
    dsufveiculo = CharField(null=True)
    iddettransp = CharField(primary_key=True)
    idtransportador = CharField(index=True, null=True)
    nmpropietario = CharField(null=True)
    nrinscestadual = CharField(null=True)
    renavam = CharField(null=True)
    rntrcpropietario = CharField(null=True)
    stexp = CharField(index=True, null=True)
    streboque = BooleanField(null=True)
    tarakg = DoubleField(null=True)
    tpcarroceria = CharField(null=True)
    tppessoapropietario = CharField(null=True)
    tppropietario = CharField(null=True)
    tprodado = CharField(null=True)
    ufproprietario = CharField(null=True)
    veiculoproprio = CharField(null=True)

    class Meta:
        table_name = 'dettran'
        schema = 'wshop'

class Empcxp(BaseModel):
    cdcaixapostal = CharField()
    cdedi = CharField(null=True)
    cdempresa = CharField()
    dircaixaentrada = CharField(null=True)
    dircaixasaida = CharField(null=True)
    dsarquivosexp = CharField(null=True)
    dsarquivosimp = CharField(null=True)
    idempresabase = CharField(null=True)
    idterminalintegracao = CharField(null=True)
    nmbase = CharField(null=True)
    nrdiasrec = IntegerField(null=True)
    nrdiaswait = IntegerField(null=True)
    nrintercheck = IntegerField(null=True)
    nrproximopacote = IntegerField(null=True)
    spysystem = CharField(null=True)
    stempresageral = BooleanField(null=True)
    stfluxogeral = BooleanField(null=True)
    stloja = IntegerField(null=True)
    stprocessadbf = CharField(null=True)
    stwsched = BooleanField(null=True)
    stxml = BooleanField(null=True)

    class Meta:
        table_name = 'empcxp'
        indexes = (
            (('cdempresa', 'cdcaixapostal'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cdcaixapostal', 'cdempresa')

class Empshop(BaseModel):
    alcalculocredito = DoubleField(null=True)
    alcofins = DoubleField(null=True)
    alicms = DoubleField(null=True)
    alipi = DoubleField(null=True)
    aliss = DoubleField(null=True)
    allucro = DoubleField(null=True)
    alpis = DoubleField(null=True)
    cdempresa = CharField(primary_key=True)
    cdexternodeposito = CharField(null=True)
    cdexternoprateleira = CharField(null=True)
    cdmunicipioibge = CharField(null=True)
    cdregimetributario = CharField(null=True)
    cdtratamentoespecial = CharField(null=True)
    cduf = CharField(null=True)
    chamadaempresa = CharField(index=True, null=True)
    cnae = CharField(null=True)
    cronsu = IntegerField(null=True)
    csosnisentost = CharField(null=True)
    csosnisentotributados = CharField(null=True)
    csosnnaotributados = CharField(null=True)
    cta_cliente_padrao = IntegerField(null=True)
    cta_desc_acres = IntegerField(null=True)
    cta_desc_acres_pag = IntegerField(null=True)
    cta_desp_bancaria = IntegerField(null=True)
    cta_desp_bancaria_pag = IntegerField(null=True)
    cta_fornecedor_padrao = IntegerField(null=True)
    cta_juros = IntegerField(null=True)
    cta_juros_pag = IntegerField(null=True)
    cta_multa = IntegerField(null=True)
    cta_multa_pag = IntegerField(null=True)
    dsendereco = CharField(null=True)
    dspastamidas = CharField(null=True)
    dtjunta = DateField(null=True)
    dtnsu = DateTimeField(null=True)
    email = CharField(null=True)
    gerasped = BooleanField(null=True)
    idfornectransf = CharField(null=True)
    idmensagemstnaodestacado = CharField(null=True)
    idterminaltransfloja = CharField(null=True)
    idtransportador = CharField(null=True)
    inscricaomunicipal = CharField(null=True)
    intsupplychain = BooleanField(null=True)
    intsupplychainproduto = BooleanField(null=True)
    logo = BlobField(null=True)
    nmbairro = CharField(null=True)
    nmcidade = CharField(null=True)
    nmempresa = CharField(index=True, null=True)
    nrcep = CharField(null=True)
    nrcgc = CharField(null=True)
    nrinscrestadual = CharField(null=True)
    nrjunta = CharField(null=True)
    nrnsu = CharField(null=True)
    nrtelefone = CharField(null=True)
    perfil = CharField(null=True)
    razaosocial = CharField(null=True)
    stapuraicms = BooleanField(null=True)
    stapuraipi = BooleanField(null=True)
    stapurapiscofins = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stintegradomidas = BooleanField(null=True)
    stisencaofaixabruta = BooleanField(null=True)
    stpiscofinscumulativo = BooleanField(null=True)
    sttrabalhaecommerce = BooleanField(null=True)
    token = CharField(null=True)
    tpconversaotransferencia = IntegerField(null=True)
    tpempresa = CharField(null=True)
    tprelacionamentoproduto = IntegerField(null=True)
    tsregimeespecialtributacao = IntegerField(null=True)
    urlloja = CharField(null=True)
    urlservico = CharField(null=True)
    versaowshop = CharField(null=True)
    vlmetamensal = DoubleField(null=True)
    vlmetamensal10 = DoubleField(null=True)
    vlmetamensal11 = DoubleField(null=True)
    vlmetamensal12 = DoubleField(null=True)
    vlmetamensal2 = DoubleField(null=True)
    vlmetamensal3 = DoubleField(null=True)
    vlmetamensal4 = DoubleField(null=True)
    vlmetamensal5 = DoubleField(null=True)
    vlmetamensal6 = DoubleField(null=True)
    vlmetamensal7 = DoubleField(null=True)
    vlmetamensal8 = DoubleField(null=True)
    vlmetamensal9 = DoubleField(null=True)
    vlpercroyalties = DoubleField(null=True)

    class Meta:
        table_name = 'empshop'
        schema = 'wshop'

class Faixas(BaseModel):
    cdexterno = CharField(null=True)
    idfaixa = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)
    vlfinal = DoubleField(index=True, null=True)
    vlinicial = DoubleField(null=True)

    class Meta:
        table_name = 'faixas'
        indexes = (
            (('vlinicial', 'vlfinal'), False),
        )
        schema = 'wshop'

class Faixasipi(BaseModel):
    cdipi = CharField()
    vlfinal = DoubleField()
    vlinicial = DoubleField()
    vlipi = DoubleField(null=True)

    class Meta:
        table_name = 'faixasipi'
        indexes = (
            (('cdipi', 'vlinicial', 'vlfinal'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cdipi', 'vlfinal', 'vlinicial')

class Familia(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    dsfamilia = CharField(index=True, null=True)
    dssigla = CharField(null=True)
    idfamilia = CharField(primary_key=True)
    idpadrao = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'familia'
        schema = 'wshop'

class Feriadoemp(BaseModel):
    cdempresa = CharField()
    idferiado = CharField()
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'feriadoemp'
        indexes = (
            (('idferiado', 'cdempresa'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cdempresa', 'idferiado')

class Feriados(BaseModel):
    dsferiado = CharField(null=True)
    dtferiado = DateField(index=True, null=True)
    idferiado = CharField(primary_key=True)
    stdiafixo = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    tpferiado = IntegerField(null=True)

    class Meta:
        table_name = 'feriados'
        schema = 'wshop'

class Grade(BaseModel):
    cdexterno = CharField(null=True)
    cdgrade = CharField(null=True, unique=True)
    dsgrade = CharField(null=True)
    idgrade = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)
    stpreenchedetalhe = BooleanField(null=True)
    sttamanho = BooleanField(null=True)

    class Meta:
        table_name = 'grade'
        schema = 'wshop'

class Grupo(BaseModel):
    alcomissao = DoubleField(null=True)
    allucro = DoubleField(null=True)
    alroyalties = DoubleField(null=True)
    cdclassif = CharField(null=True)
    cdexterno = CharField(null=True)
    cdgrupo = CharField(null=True, unique=True)
    dsimagem = CharField(null=True)
    dsobservacao = TextField(null=True)
    dssigla = CharField(null=True)
    idgrupo = CharField(primary_key=True)
    idpadrao = CharField(null=True)
    nmgrupo = CharField(index=True, null=True)
    qtcritica = DoubleField(null=True)
    qtmaxima = DoubleField(null=True)
    qtminima = DoubleField(null=True)
    stexp = CharField(index=True, null=True)
    stexpimg = CharField(null=True)

    class Meta:
        table_name = 'grupo'
        schema = 'wshop'

class Grupoempreajuste(BaseModel):
    cdgrupoempresa = CharField(null=True)
    idgrupoempresa = CharField(null=True)
    nmgrupoempresa = CharField(null=True)
    percdesc = DoubleField(null=True)
    vlmultiplicador = DoubleField(null=True)

    class Meta:
        table_name = 'grupoempreajuste'
        schema = 'wshop'
        primary_key = False

class Icms(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    cdexterno = CharField(null=True)
    dscalculoicms = CharField(null=True)
    idcalculoicms = CharField(primary_key=True)
    idproduto = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'icms'
        schema = 'wshop'

class IcmsUf(BaseModel):
    aldiferimentoicms = DoubleField(null=True)
    alicms = DoubleField(null=True)
    alicmscontribuinte = DoubleField(null=True)
    alicmsefetivo = DoubleField(null=True)
    allucro = DoubleField(null=True)
    allucrodistr = DoubleField(null=True)
    alreducaobaseicms = DoubleField(null=True)
    alreducaobaseicmscontrib = DoubleField(null=True)
    alreducaobasest = DoubleField(null=True)
    alreducaobasestcontrib = DoubleField(null=True)
    alreducaoicmsefetivo = DoubleField(null=True)
    cdsituacaotributaria = CharField(null=True)
    cdsituacaotributariajur = CharField(null=True)
    codreceita = CharField(null=True)
    idcalculoicms = CharField()
    idcfop = CharField()
    idmensagem = CharField(null=True)
    iduf = CharField()
    idufdestino = CharField()
    stcalculasubsttributaria = CharField(null=True)
    stcustoreposicao = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stgeracreditopiscofins = BooleanField(null=True)
    stnaodestacaicms = BooleanField(null=True)
    stnaodestacasubsttributaria = BooleanField(null=True)
    stvendaconsumidorfinal = BooleanField(null=True)
    tributacaopfisica = CharField(null=True)
    tributacaopjur = CharField(null=True)
    tributacaopjurcontrib = CharField(null=True)

    class Meta:
        table_name = 'icms_uf'
        indexes = (
            (('idcalculoicms', 'iduf', 'idufdestino', 'idcfop'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idcalculoicms', 'idcfop', 'iduf', 'idufdestino')

class Imagem(BaseModel):
    dsfonte = CharField(null=True)
    exibicaoimagem = IntegerField(null=True)
    mensagem = CharField(null=True)
    nmimagem = CharField(null=True)
    ordem = AutoField()
    pathimagem = CharField(null=True)

    class Meta:
        table_name = 'imagem'
        schema = 'wshop'

class Informacoesgerais(BaseModel):
    cdinfogeral = CharField(index=True, null=True)
    dsinfogeral = CharField(null=True)
    idinfogeral = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)
    tpinfogeral = CharField(null=True)

    class Meta:
        table_name = 'informacoesgerais'
        schema = 'wshop'

class MdCadastro(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    dsfiltro = CharField(null=True)
    idmd_cadastro = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'md_cadastro'
        schema = 'wshop'

class MdFiltro(BaseModel):
    dsandor = CharField(null=True)
    dscampo = CharField(null=True)
    dsoperador = CharField(null=True)
    dsvalor = CharField(null=True)
    idmd_cadastro = CharField(null=True)
    idmd_filtro = CharField(primary_key=True)
    parfim = CharField(null=True)
    parini = CharField(null=True)

    class Meta:
        table_name = 'md_filtro'
        schema = 'wshop'

class Messnf(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    dsmensagem = CharField(null=True)
    idmensagem = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'messnf'
        schema = 'wshop'

class Modelofiscal(BaseModel):
    cdmodelofiscal = CharField(primary_key=True)
    dsmodelofiscal = CharField(null=True)
    stconhecimentotransp = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stmunicipal = BooleanField(null=True)

    class Meta:
        table_name = 'modelofiscal'
        schema = 'wshop'

class Municipiosibge(BaseModel):
    codmunicipio = CharField(null=True, unique=True)
    codmunicipio2 = CharField(null=True)
    idmunicipio = AutoField()
    nmmunicipio = CharField(null=True)
    nmmunicipiosemacento = CharField(null=True)
    numtabela = CharField(null=True)
    sguf = CharField(null=True)
    tpcaracteres = IntegerField(null=True)

    class Meta:
        table_name = 'municipiosibge'
        indexes = (
            (('sguf', 'nmmunicipio'), False),
            (('sguf', 'nmmunicipiosemacento'), False),
        )
        schema = 'wshop'

class Natlanc(BaseModel):
    cdchamada = CharField(null=True, unique=True)
    dsnatlanc = CharField(null=True)
    idnatlanc = CharField(primary_key=True)
    stcustofixo = BooleanField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'natlanc'
        schema = 'wshop'

class Operaca(BaseModel):
    alfixaicms = DoubleField(null=True)
    alredbaseicms = DoubleField(null=True)
    cdexterno = CharField(null=True)
    cdfiscal = CharField(null=True)
    cdfiscalalternativo = CharField(null=True)
    cdfiscalsubstituicao = CharField(null=True)
    cdoperacao = CharField(null=True, unique=True)
    cstpisnaoapurado = CharField(null=True)
    idoperacao = CharField(primary_key=True)
    idoperacaodevolucao = CharField(null=True)
    idtabela = CharField(null=True)
    modcalcbasest = IntegerField(null=True)
    nmoperacao = CharField(index=True, null=True)
    stabateicmscustomedio = BooleanField(null=True)
    stabateicmspis = BooleanField(null=True)
    stabateicmssubstituicao = BooleanField(null=True)
    stabatepisbaseicms = BooleanField(null=True)
    stabatepiscustomedio = BooleanField(null=True)
    stabaterdescbaseicms = BooleanField(null=True)
    stabaterdescbaseipi = BooleanField(null=True)
    stabaterdescbasest = BooleanField(null=True)
    stabaterdesonicmsdabcdifal = BooleanField(null=True)
    stabateretencao = BooleanField(null=True)
    stacerto = CharField(null=True)
    stativo = BooleanField(null=True)
    statualizacusto = CharField(null=True)
    statualizaicms = BooleanField(null=True)
    statualizaipi = BooleanField(null=True)
    stbasereduzidasubst = CharField(null=True)
    stcalculaicms = CharField(null=True)
    stcalculaipi = CharField(null=True)
    stcalculapis = BooleanField(null=True)
    stcalculasubst = CharField(null=True)
    stcustodespesas = BooleanField(null=True)
    stcustofrete = BooleanField(null=True)
    stcustoseguro = BooleanField(null=True)
    stdasomaipi = CharField(null=True)
    stdeduzicms = CharField(null=True)
    stdespaduaneirascusto = BooleanField(null=True)
    stdespesasfluxo = BooleanField(null=True)
    stdevolucaocompra = BooleanField(null=True)
    steditavalorimpostos = BooleanField(null=True)
    stexigecliente = BooleanField(null=True)
    stexigeprazo = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stfretefluxo = BooleanField(null=True)
    stfretesomaipi = CharField(null=True)
    sthabilitamotivodesoneracao = BooleanField(null=True)
    sticmsvlagregado = CharField(null=True)
    stiimportacaocusto = BooleanField(null=True)
    stincluifornec = BooleanField(null=True)
    stintfiscal = CharField(null=True)
    stiofcusto = BooleanField(null=True)
    stipireducaobase = BooleanField(null=True)
    stipisomaicms = CharField(null=True)
    stipisomast = CharField(null=True)
    stipivlagregado = CharField(null=True)
    stmovimentaestoque = BooleanField(null=True)
    stnaoalterarcustomedio = BooleanField(null=True)
    stnaocalculadiferimento = BooleanField(null=True)
    stoutrassaidas = CharField(null=True)
    stredbaseicms = CharField(null=True)
    stressarcimento = BooleanField(null=True)
    stsegurofluxo = BooleanField(null=True)
    stsomadescitemicmsred = CharField(null=True)
    stsomadespaduacustomedio = BooleanField(null=True)
    stsomadespbaseicms = CharField(null=True)
    stsomadespbasesubst = CharField(null=True)
    stsomafretebaseicms = CharField(null=True)
    stsomafretebasesubst = CharField(null=True)
    stsomafreteoutros = BooleanField(null=True)
    stsomafretepiscustomedio = BooleanField(null=True)
    stsomaicmsanota = BooleanField(null=True)
    stsomaicmscustomedio = BooleanField(null=True)
    stsomaiimportacaocustomedio = BooleanField(null=True)
    stsomaiofcustomedio = BooleanField(null=True)
    stsomaipicustomedio = BooleanField(null=True)
    stsomaoutroscustomedio = BooleanField(null=True)
    stsomapiscofinsanota = BooleanField(null=True)
    stsomapiscustomedio = BooleanField(null=True)
    stsomasubstanota = CharField(null=True)
    stsomasubstcustomedio = BooleanField(null=True)
    stsubstituicaocusto = BooleanField(null=True)
    stsubstituicaocustoliquido = BooleanField(null=True)
    sttituloconhecimento = BooleanField(null=True)
    sttitulofrete = BooleanField(null=True)
    sttituloseguro = BooleanField(null=True)
    stutilizacfopoperacaoimpnf = BooleanField(null=True)
    stvendaconsumidorfinal = BooleanField(null=True)
    tp12 = CharField(null=True)
    tpallucro = CharField(null=True)
    tpoperacao = CharField(null=True)
    tpprecomovimentacao = IntegerField(null=True)

    class Meta:
        table_name = 'operaca'
        indexes = (
            (('stativo', 'cdoperacao'), False),
        )
        schema = 'wshop'

class Pautafiscal(BaseModel):
    cdpautafiscal = CharField(null=True, unique=True)
    descricao = CharField(null=True)
    idpautafiscal = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'pautafiscal'
        schema = 'wshop'

class Pautafiscald(BaseModel):
    idpautafiscal = CharField(index=True)
    idufdestino = CharField()
    iduforigem = CharField()
    stexp = CharField(index=True, null=True)
    sticms = BooleanField(null=True)
    stsubsttributaria = BooleanField(null=True)
    vlcompra = DoubleField(null=True)
    vlvenda = DoubleField(null=True)

    class Meta:
        table_name = 'pautafiscald'
        indexes = (
            (('idpautafiscal', 'iduforigem', 'idufdestino'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idpautafiscal', 'idufdestino', 'iduforigem')

class Personalizadetalhe(BaseModel):
    dspersonalizadetalhe = CharField(null=True)
    idpersonalizadetalhe = CharField(primary_key=True)
    idpersonalizamaster = CharField(index=True, null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'personalizadetalhe'
        indexes = (
            (('idpersonalizamaster', 'dspersonalizadetalhe'), False),
        )
        schema = 'wshop'

class Personalizamaster(BaseModel):
    dspersonalizamaster = CharField(index=True, null=True)
    idpersonalizamaster = CharField(primary_key=True)
    nmidmaster = CharField(null=True)
    nmtabela = CharField(null=True)
    nrordenacao = IntegerField(null=True)
    nrtamanho = IntegerField(null=True)
    stexp = CharField(index=True, null=True)
    stlista = BooleanField(null=True)
    stobrigatorio = BooleanField(null=True)
    tpcampo = IntegerField(null=True)

    class Meta:
        table_name = 'personalizamaster'
        indexes = (
            (('nmtabela', 'nrordenacao', 'dspersonalizamaster'), False),
        )
        schema = 'wshop'

class Personalizaresult(BaseModel):
    dsvalor = CharField(index=True, null=True)
    idpersonalizadetalhe = CharField(null=True)
    idpersonalizamaster = CharField(null=True)
    idpersonalizaresult = CharField(primary_key=True)
    idregistrotabelaorigem = CharField(index=True, null=True)
    nomedatabelaorigem = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'personalizaresult'
        indexes = (
            (('idpersonalizamaster', 'idregistrotabelaorigem', 'dsvalor'), False),
            (('idpersonalizamaster', 'idregistrotabelaorigem', 'nomedatabelaorigem'), False),
        )
        schema = 'wshop'

class Pesscar(BaseModel):
    idcaracpessoa = CharField()
    idpessoa = CharField(index=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'pesscar'
        indexes = (
            (('idcaracpessoa', 'idpessoa'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idcaracpessoa', 'idpessoa')

class Pessctaemp(BaseModel):
    cdempresa = CharField()
    ctawcash = IntegerField(null=True)
    idpessoa = CharField()
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'pessctaemp'
        indexes = (
            (('idpessoa', 'cdempresa'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cdempresa', 'idpessoa')

class Pessoas(BaseModel):
    alcomissao = DoubleField(null=True)
    aldesconto = DoubleField(null=True)
    alicmssimples = DoubleField(null=True)
    campostelwhatsapp = CharField(null=True)
    cdchamada = CharField(null=True)
    cdcontabil = CharField(null=True)
    cdempresa = CharField(null=True)
    cdempresacorresp = CharField(null=True)
    cdexterno = CharField(null=True)
    cdsenha = CharField(null=True)
    cta_wcash = IntegerField(null=True)
    diafaturamento = IntegerField(null=True)
    diavencimento = CharField(null=True)
    dscomplemento = CharField(null=True)
    dscomplementocobranca = CharField(null=True)
    dscomplementoentrega = CharField(null=True)
    dssenha = CharField(null=True)
    dtadmissao = DateTimeField(null=True)
    dtalteracao = DateTimeField(null=True)
    dtcadastro = DateTimeField(null=True)
    dtultimacompra = DateTimeField(null=True)
    email = CharField(null=True)
    email2 = CharField(null=True)
    email3 = CharField(null=True)
    id_metacomissao = CharField(null=True)
    idbairro = CharField(null=True)
    idbairrocobranca = CharField(null=True)
    idbairroentrega = CharField(null=True)
    idcidade = CharField(null=True)
    idcidadecobranca = CharField(null=True)
    idcidadeentrega = CharField(null=True)
    idestrangeiro = CharField(null=True)
    idpessoa = CharField(primary_key=True)
    idpessoamaster = CharField(null=True)
    idprazo = CharField(null=True)
    idtabela = CharField(null=True)
    idtplogradouro = CharField(null=True)
    idtplogradourocobranca = CharField(null=True)
    idtplogradouroentrega = CharField(null=True)
    iduf = CharField(null=True)
    idufcobranca = CharField(null=True)
    idufentrega = CharField(null=True)
    idusuario = IntegerField(null=True)
    idvendedorpadrao = CharField(null=True)
    inscest_pfisica = CharField(null=True)
    inscricaosuframa = CharField(null=True)
    lstcpfcnpj = CharField(null=True)
    nmbairro = CharField(null=True)
    nmbairrocobranca = CharField(null=True)
    nmbairroentrega = CharField(null=True)
    nmcep = CharField(null=True)
    nmcepcobranca = CharField(null=True)
    nmcepentrega = CharField(null=True)
    nmcidade = CharField(null=True)
    nmcidadecobranca = CharField(null=True)
    nmcidadeentrega = CharField(null=True)
    nmcurto = CharField(index=True, null=True)
    nmendereco = CharField(null=True)
    nmenderecocobranca = CharField(null=True)
    nmenderecoentrega = CharField(null=True)
    nmfantasia = CharField(null=True)
    nmobservacao = TextField(null=True)
    nmpessoa = CharField(index=True, null=True)
    nrcartaofidelidade = CharField(index=True, null=True)
    nrcgc_cic = CharField(index=True, null=True)
    nrcodpager = CharField(null=True)
    nrincrest_rg = CharField(null=True)
    nrinscrmun = CharField(null=True)
    nrlogradouro = CharField(null=True)
    nrlogradourocobranca = CharField(null=True)
    nrlogradouroentrega = CharField(null=True)
    nrpager = CharField(null=True)
    nrtelcomercial = CharField(null=True)
    nrtelcontato = CharField(null=True)
    nrtelefone = CharField(null=True)
    nrtelefonecobranca = CharField(null=True)
    nrtelefoneentrega = CharField(null=True)
    nrtelfax = CharField(null=True)
    praticadescchk = BooleanField(null=True)
    referenciaendereco = CharField(null=True)
    referenciaenderecocobranca = CharField(null=True)
    referenciaenderecoentrega = CharField(null=True)
    regularidade = IntegerField(null=True)
    site = CharField(null=True)
    stapuraicms = BooleanField(null=True)
    stapuraipi = BooleanField(null=True)
    stativo = CharField(null=True)
    stcalculacsrf = BooleanField(null=True)
    stcomissao = BooleanField(null=True)
    stcontribicms = BooleanField(null=True)
    stconvenio = BooleanField(index=True, null=True)
    stexp = CharField(index=True, null=True)
    stfabricante = BooleanField(null=True)
    stgerente = BooleanField(null=True)
    sticmssimples = BooleanField(null=True)
    stnaoaplicareducaoprazo = BooleanField(null=True)
    stnaocalculadiferimento = BooleanField(null=True)
    stnaogeramorto = BooleanField(null=True)
    stnegativo = CharField(null=True)
    stpermissoes = TextField(null=True)
    stpessoa = CharField(null=True)
    stsubsttribiss = BooleanField(null=True)
    sttipopessoa = CharField(index=True, null=True)
    sttrabalhapedidoeletronico = BooleanField(null=True)
    sttransferencia = BooleanField(null=True)
    stusardesccliusu = BooleanField(null=True)
    stvendedor = BooleanField(null=True)
    tpcontribuinte = IntegerField(null=True)
    vlemaberto = DoubleField(null=True)
    vlematraso = DoubleField(null=True)
    vllimitecompra = DoubleField(null=True)
    vlmeta = DoubleField(null=True)
    vlmetamensal10 = DoubleField(null=True)
    vlmetamensal11 = DoubleField(null=True)
    vlmetamensal12 = DoubleField(null=True)
    vlmetamensal2 = DoubleField(null=True)
    vlmetamensal3 = DoubleField(null=True)
    vlmetamensal4 = DoubleField(null=True)
    vlmetamensal5 = DoubleField(null=True)
    vlmetamensal6 = DoubleField(null=True)
    vlmetamensal7 = DoubleField(null=True)
    vlmetamensal8 = DoubleField(null=True)
    vlmetamensal9 = DoubleField(null=True)
    vlpercdesc = DoubleField(null=True)
    vlsalario = DoubleField(null=True)

    class Meta:
        table_name = 'pessoas'
        indexes = (
            (('sttipopessoa', 'cdchamada'), False),
            (('sttipopessoa', 'stativo', 'cdchamada'), False),
        )
        schema = 'wshop'

class PharmaDados(BaseModel):
    cd_inf_anvisa = CharField(null=True)
    ds_informacao = CharField(null=True)
    tp_informacao = IntegerField(null=True)

    class Meta:
        table_name = 'pharma_dados'
        schema = 'wshop'
        primary_key = False

class PharmaMedicos(BaseModel):
    nm_conselho = CharField()
    nmmedico = CharField(index=True, null=True)
    nrcrm = CharField()
    stexp = CharField(index=True, null=True)
    uf_conselho = CharField(null=True)

    class Meta:
        table_name = 'pharma_medicos'
        indexes = (
            (('nrcrm', 'nm_conselho'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('nm_conselho', 'nrcrm')

class Prazo(BaseModel):
    alacresc = DoubleField(null=True)
    alprimeira = DoubleField(null=True)
    alprimeirotitulo = DoubleField(null=True)
    cdexterno = CharField(null=True)
    cdprazo = CharField(null=True, unique=True)
    dsprazo = CharField(null=True)
    idprazo = CharField(primary_key=True)
    idtprecdemais = CharField(null=True)
    idtprecvista = CharField(null=True)
    intervalo = IntegerField(null=True)
    mesmodiaemissao = BooleanField(null=True)
    nrdiasprim = IntegerField(null=True)
    nrparcelas = IntegerField(null=True)
    qttitulosporparcela = IntegerField(null=True)
    stbaixaprim = CharField(null=True)
    stexp = CharField(index=True, null=True)
    stlojavirtual = CharField(null=True)
    stprazopessoa = CharField(null=True)
    stprimavista = CharField(null=True)
    stvencfixo = CharField(null=True)
    tpdocumento = CharField(null=True)
    vlacrescdemais = DoubleField(null=True)
    vlacrescimogeral = DoubleField(null=True)
    vlacrescprim = DoubleField(null=True)
    vlminimo = DoubleField(null=True)
    vlreducaocomissao = DoubleField(null=True)

    class Meta:
        table_name = 'prazo'
        schema = 'wshop'

class Precos(BaseModel):
    dtaltvlpreco = DateTimeField(index=True, null=True)
    iddetalhe = CharField(index=True, null=True)
    idpreco = CharField(primary_key=True)
    statusalt = CharField(null=True)
    stexp = CharField(index=True, null=True)
    vlpreco = DoubleField(null=True)
    vlprecoant = DoubleField(null=True)

    class Meta:
        table_name = 'precos'
        schema = 'wshop'

class Prodequivalente(BaseModel):
    iddetalhe = CharField(null=True)
    iddetalheequivalente = CharField(null=True)
    idprodequivalente = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'prodequivalente'
        indexes = (
            (('iddetalhe', 'iddetalheequivalente'), False),
        )
        schema = 'wshop'

class Prodfor(BaseModel):
    cdprodutofornecedor = CharField(index=True, null=True)
    dtultimacompra = DateTimeField(null=True)
    idpessoa = CharField(index=True, null=True)
    idproduto = CharField(index=True, null=True)
    idprodutofornecedor = CharField(primary_key=True)
    qtultimacompra = DoubleField(null=True)
    stexp = CharField(index=True, null=True)
    tpfornecedor = CharField(null=True)
    vlultimacompra = DoubleField(null=True)

    class Meta:
        table_name = 'prodfor'
        indexes = (
            (('idproduto', 'idpessoa'), False),
        )
        schema = 'wshop'

class Prodroy(BaseModel):
    alreducao1 = DoubleField(null=True)
    alreducao2 = DoubleField(null=True)
    alroyaltie = DoubleField(null=True)
    idproduto = CharField()
    idroyalties = CharField()
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'prodroy'
        indexes = (
            (('idproduto', 'idroyalties'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idproduto', 'idroyalties')

class Produto(BaseModel):
    alicmsvenda = DoubleField(null=True)
    alipivenda = DoubleField(null=True)
    alretencaocofins = DoubleField(null=True)
    alretencaocsll = DoubleField(null=True)
    alretencaoinss = DoubleField(null=True)
    alretencaoirrf = DoubleField(null=True)
    alretencaopis = DoubleField(null=True)
    alroyaties = DoubleField(null=True)
    cdchamada = CharField(null=True, unique=True)
    cdclassfiscal = CharField(null=True)
    cdexterno = CharField(null=True)
    cdgenero = CharField(null=True)
    cdipi = CharField(null=True)
    cdlistaservicolc = IntegerField(null=True)
    cdsittrib = CharField(null=True)
    cdsittribjuridica = CharField(null=True)
    cdsttribipientrada = CharField(null=True)
    cdsttribipisaida = CharField(null=True)
    cdtratamentoespecial = CharField(null=True)
    cest = CharField(null=True)
    dsdescricaoecommerce = TextField(null=True)
    dsobservacao = TextField(null=True)
    dtaltalicmsvenda = DateTimeField(null=True)
    dtaltalipivenda = DateTimeField(null=True)
    dtalttemporeposicao = DateTimeField(null=True)
    iat = CharField(null=True)
    idcalculoicms = CharField(null=True)
    idcategoria = CharField(null=True)
    idfornecprincipal = CharField(null=True)
    idgradeh = CharField(null=True)
    idgradev = CharField(null=True)
    idgrupo = CharField(index=True, null=True)
    idmarca = CharField(null=True)
    idpadrao = CharField(null=True)
    idpautafiscal = CharField(index=True, null=True)
    idproduto = CharField(primary_key=True)
    idunidade = CharField(null=True)
    ippt = CharField(null=True)
    nmproduto = CharField(index=True, null=True)
    nrdiasreposicao = IntegerField(null=True)
    qtmaximavenda = DoubleField(null=True)
    qtminimavenda = DoubleField(null=True)
    stabate = BooleanField(null=True)
    stadicional = BooleanField(null=True)
    stalicmsinterna2 = CharField(null=True)
    stativo = CharField(null=True)
    stautoatendimento = BooleanField(null=True)
    stcdfiscalalternativo = BooleanField(null=True)
    stcestabasica = BooleanField(null=True)
    stcombustivel = BooleanField(null=True)
    stecommerce = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stfotounicacoluna = BooleanField(null=True)
    stfotounicalinha = BooleanField(null=True)
    stisentotaxaservico = BooleanField(null=True)
    stprecounico = BooleanField(null=True)
    tipoitem = CharField(null=True)
    tpformatoemabalagem = IntegerField(null=True)
    tpproduto = IntegerField(null=True)
    tptaxa = IntegerField(null=True)
    tributacao = CharField(null=True)
    vlaltura = DoubleField(null=True)
    vlcomprimento = DoubleField(null=True)
    vlcusto = DoubleField(null=True)
    vllargura = DoubleField(null=True)
    vlpreco = DoubleField(null=True)

    class Meta:
        table_name = 'produto'
        schema = 'wshop'

class ProdutoBalanca(BaseModel):
    cddepartamento = CharField(null=True)
    iddetalhe = CharField(primary_key=True)
    idnutricional = CharField(null=True)
    idreceita = CharField(null=True)
    nrdiasvalidade = IntegerField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'produto_balanca'
        schema = 'wshop'

class ProdutoBalancaInfNutricional(BaseModel):
    cdnutricional = CharField(index=True, null=True)
    dsinteiromedidacaseira = IntegerField(null=True)
    idnutricional = CharField(primary_key=True)
    nmnutricional = CharField(null=True)
    perccalcio = DoubleField(null=True)
    perccarboidratos = DoubleField(null=True)
    perccolesterol = DoubleField(null=True)
    percferro = DoubleField(null=True)
    percfibras = DoubleField(null=True)
    percgordurassaturadas = DoubleField(null=True)
    percgordurastotais = DoubleField(null=True)
    percgordurastrans = DoubleField(null=True)
    percproteinas = DoubleField(null=True)
    percsodio = DoubleField(null=True)
    percvalorcalorico = DoubleField(null=True)
    stexp = CharField(index=True, null=True)
    tpdecinalmedidacaseira = IntegerField(null=True)
    tpmedidacaseira = IntegerField(null=True)
    tpunidadeporcao = IntegerField(null=True)
    vlcalcio = DoubleField(null=True)
    vlcarboidratos = DoubleField(null=True)
    vlcolesterol = DoubleField(null=True)
    vlferro = DoubleField(null=True)
    vlfibras = DoubleField(null=True)
    vlgordurassaturadas = DoubleField(null=True)
    vlgordurastotais = DoubleField(null=True)
    vlgordurastrans = DoubleField(null=True)
    vlproteinas = DoubleField(null=True)
    vlquantidade = DoubleField(null=True)
    vlsodio = DoubleField(null=True)
    vlvalorcalorico = DoubleField(null=True)

    class Meta:
        table_name = 'produto_balanca_inf_nutricional'
        schema = 'wshop'

class ProdutoBalancaReceitas(BaseModel):
    cdreceita = CharField(index=True, null=True)
    dsreceita = TextField(null=True)
    idreceita = CharField(primary_key=True)
    nmreceita = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'produto_balanca_receitas'
        schema = 'wshop'

class ProdutoPharma(BaseModel):
    cddcb = CharField(null=True)
    dsapresentacao = CharField(null=True)
    dsdcb = CharField(null=True)
    dsprincipioativo = CharField(null=True)
    iddetalhe = CharField(primary_key=True)
    registroms = CharField(null=True)
    stexp = CharField(index=True, null=True)
    stfarmaciapopular = BooleanField(index=True, null=True)
    stpsicotropico = BooleanField(null=True)
    vlpercdescpopular = DoubleField(null=True)

    class Meta:
        table_name = 'produto_pharma'
        indexes = (
            (('stpsicotropico', 'dsprincipioativo'), False),
        )
        schema = 'wshop'

class Produtouf(BaseModel):
    codbeneficiofiscal = CharField(null=True)
    cst = CharField()
    idproduto = CharField()
    iduf = CharField()
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'produtouf'
        indexes = (
            (('idproduto', 'iduf', 'cst'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('cst', 'idproduto', 'iduf')

class Royalties(BaseModel):
    alreducao1 = DoubleField(null=True)
    alreducao2 = DoubleField(null=True)
    alroyaltie = DoubleField(null=True)
    cdchamada = CharField(index=True, null=True)
    dsendereco = CharField(null=True)
    idroyalties = CharField(primary_key=True)
    nmbairro = CharField(null=True)
    nmcidade = CharField(null=True)
    nmdetentor = CharField(null=True)
    nrcep = CharField(null=True)
    nrtelefone = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'royalties'
        schema = 'wshop'

class Situacaodocumento(BaseModel):
    cdsped = CharField(null=True)
    descricao = CharField(null=True)
    idsituacaodoc = CharField(primary_key=True)
    stcancelado = IntegerField(null=True)
    stregular = IntegerField(null=True)

    class Meta:
        table_name = 'situacaodocumento'
        schema = 'wshop'

class Tabelaprecos(BaseModel):
    cdchamada = CharField(index=True, null=True)
    dstabela = CharField(index=True, null=True)
    formula = CharField(null=True)
    idtabela = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'tabelaprecos'
        schema = 'wshop'

class Tabelatprec(BaseModel):
    idtabela = CharField()
    idtprecebimento = CharField()
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'tabelatprec'
        indexes = (
            (('idtabela', 'idtprecebimento'), True),
        )
        schema = 'wshop'
        primary_key = CompositeKey('idtabela', 'idtprecebimento')

class Tplogr(BaseModel):
    cdtplogradouro = CharField(null=True, unique=True)
    idtplogradouro = CharField(primary_key=True)
    nmtplogradouro = CharField(index=True, null=True)
    stexp = CharField(index=True, null=True)
    tplogradouro = CharField(index=True, null=True)

    class Meta:
        table_name = 'tplogr'
        schema = 'wshop'

class Tprec(BaseModel):
    al_percabatimentoadmcartao = DoubleField(null=True)
    al_percabatimentoadmcartaoparc = DoubleField(null=True)
    al_percacresparcelaadmcartao = DoubleField(null=True)
    alreducaocomissao = DoubleField(null=True)
    cdempresa = CharField(index=True, null=True)
    cdexterno = CharField(null=True)
    cdtiporec = CharField(null=True, unique=True)
    cnpjadmcartao = CharField(null=True)
    idcontaentrada = CharField(null=True)
    idcontasaida = CharField(null=True)
    idnatlanctituloadm = CharField(null=True)
    idoperacaoestoque = CharField(null=True)
    idpessoaadmcartao = CharField(null=True)
    idtprecebimento = CharField(primary_key=True)
    indexcertificada = SmallIntegerField(null=True)
    nmtprecebimento = CharField(null=True)
    nr_diasparapagamentoadmcartao = IntegerField(null=True)
    nr_maximoparcelamentosadmcartao = IntegerField(null=True)
    nr_parcelassemjurosadmcartao = IntegerField(null=True)
    nrparcabatcomissao = IntegerField(null=True)
    stabatepontoscards = BooleanField(null=True)
    stativo = BooleanField(null=True)
    stchequepre = BooleanField(null=True)
    stclientecheckout = CharField(null=True)
    stcontrolacartacredito = BooleanField(null=True)
    stexp = CharField(index=True, null=True)
    stgarantiacheque = BooleanField(null=True)
    stlojavirtual = CharField(null=True)
    stnumerario = CharField(null=True)
    stparcadm = BooleanField(null=True)
    stpgtounicaparcela = BooleanField(null=True)
    strecebaltcards = BooleanField(null=True)
    sttef = BooleanField(null=True)
    sttrabalhaadministradora = BooleanField(null=True)
    tp12 = CharField(null=True)
    tpmodalidade = IntegerField(null=True)
    tprecebimento = CharField(index=True, null=True)
    vlminimo = DoubleField(null=True)
    wcash_contacredito = IntegerField(null=True)
    wcash_contadebito = IntegerField(null=True)

    class Meta:
        table_name = 'tprec'
        indexes = (
            (('tp12', 'tprecebimento'), False),
        )
        schema = 'wshop'

class Transp(BaseModel):
    cdcep = CharField(null=True)
    cdchamada = CharField(null=True, unique=True)
    cdrntrc = CharField(null=True)
    dscomplemento = CharField(null=True)
    dsendereco = CharField(null=True)
    dsestado = CharField(null=True)
    dsmunicipio = CharField(null=True)
    email = CharField(null=True)
    idbairro = CharField(null=True)
    idcidade = CharField(null=True)
    idtplogradouro = CharField(null=True)
    idtransportador = CharField(primary_key=True)
    idtransportadorredespacho = CharField(null=True)
    nmcontato = CharField(null=True)
    nmtransportador = CharField(null=True)
    nrcgccpf = CharField(index=True, null=True)
    nrinscestadual = CharField(null=True)
    nrlogradouro = CharField(null=True)
    nrtelefone = CharField(null=True)
    stexp = CharField(index=True, null=True)
    transportepelaempresa = BooleanField(null=True)

    class Meta:
        table_name = 'transp'
        schema = 'wshop'

class Uf(BaseModel):
    alfcp = DoubleField(null=True)
    alicmsinterna = DoubleField(null=True)
    alicmsinterna2 = DoubleField(null=True)
    alicmsinterna3 = DoubleField(null=True)
    alicmsinterna4 = DoubleField(null=True)
    alicmsinterna5 = DoubleField(null=True)
    alicmsinterna6 = DoubleField(null=True)
    alicmsinterna7 = DoubleField(null=True)
    alicmsinterna8 = DoubleField(null=True)
    alicmsinterna9 = DoubleField(null=True)
    iduf = CharField(primary_key=True)
    nmuf = CharField(null=True)
    stexp = CharField(index=True, null=True)

    class Meta:
        table_name = 'uf'
        schema = 'wshop'

class Unidade(BaseModel):
    cdexterno = CharField(null=True)
    dssigla = CharField(index=True, null=True)
    dsunidade = CharField(null=True)
    fatorconversao = DoubleField(null=True)
    fracionamento = DoubleField(null=True)
    idunidade = CharField(primary_key=True)
    stexp = CharField(index=True, null=True)
    stunitario = BooleanField(null=True)
    tipocalculovolume = IntegerField(null=True)
    usadun14 = BooleanField(null=True)

    class Meta:
        table_name = 'unidade'
        schema = 'wshop'

class Wshop(BaseModel):
    ident = CharField()
    indice = AutoField()
    memo = BlobField(null=True)
    name = CharField()
    regtype = SmallIntegerField(null=True)
    section = CharField()
    value = CharField(null=True)

    class Meta:
        table_name = 'wshop'
        indexes = (
            (('name', 'section', 'ident'), False),
        )
        schema = 'wshop'