✓ Conectado ao PostgreSQL

═══════════════════════════════════════════════════════════
TABELA: cliente
═══════════════════════════════════════════════════════════

Campos:
  id_cliente                     integer              NOT NULL
  cnpj                           character varying(255) NULL
  emailnf                        character varying(255) NULL
  habilitado                     boolean              NOT NULL
  inscestadual                   character varying(255) NULL
  inscmunicipal                  character varying(255) NULL
  nomereferencia                 character varying(255) NULL
  razaosocial                    character varying(255) NOT NULL
  id_endereco                    integer              NULL
  cpf                            character varying(14) NULL
  pessoajuridica                 boolean              NOT NULL

Registro de exemplo:
  id_cliente                     = 1
  cnpj                           = 07.992.621/0001-48
  emailnf                        = andre.abreu@cmmeng.com.br
  habilitado                     = 1
  inscestadual                   = 06.800.836-8
  inscmunicipal                  = 91022
  nomereferencia                 = JCC
  razaosocial                    = JEREISSATI CENTROS COMERCIAIS S/A
  id_endereco                    = 1
  cpf                            = NULL
  pessoajuridica                 = 1


═══════════════════════════════════════════════════════════
TABELA: contato
═══════════════════════════════════════════════════════════

Campos:
  id_contato                     integer              NOT NULL
  email                          character varying(255) NULL
  nome                           character varying(255) NOT NULL
  telefone                       character varying(255) NULL

Registro de exemplo:
  id_contato                     = 1
  email                          = andre.abreu@cmmeng.com.br
  nome                           = ENG ANDRE
  telefone                       = 


═══════════════════════════════════════════════════════════
TABELA: obra
═══════════════════════════════════════════════════════════

Campos:
  id_obra                        integer              NOT NULL
  cei                            character varying(255) NOT NULL
  email                          character varying(255) NULL
  emailengenheiro                character varying(255) NULL
  emailengenheiroimpacto         character varying(255) NULL
  emissaocei                     timestamp without time zone NULL
  engenheiro                     character varying(255) NOT NULL
  engenheiroimpacto              character varying(255) NULL
  iss                            character varying(255) NOT NULL
  nome                           character varying(255) NOT NULL
  precoaluguel                   double precision     NOT NULL
  precoservico                   double precision     NOT NULL
  previsaoinicio                 timestamp without time zone NULL
  previsaotermino                timestamp without time zone NULL
  status                         character varying(255) NOT NULL
  telefoneengenheiro             character varying(255) NULL
  telefoneengenheiroimpacto      character varying(255) NULL
  id_cliente                     integer              NOT NULL
  id_endereco                    integer              NOT NULL
  id_enderecofatura              integer              NULL
  art                            character varying(255) NULL
  engenheiroart                  character varying(255) NULL

Registro de exemplo:
  id_obra                        = 22
  cei                            = 51.216.86909/70 
  email                          = NULL
  emailengenheiro                = pauloestevao@colmeia.com.br
  emailengenheiroimpacto         = protensao@impactoprotensao.com.br
  emissaocei                     = 2013-07-15 00:00:00
  engenheiro                     = PAULO ESTEVÃO GONÇALVES DAMASCENO
  engenheiroimpacto              = GEORGE
  iss                            = 3%
  nome                           = ED. L’ ESSENCE - 214
  precoaluguel                   = 0
  precoservico                   = 3.28
  previsaoinicio                 = 2013-05-01 00:00:00
  previsaotermino                = 2014-06-30 00:00:00
  status                         = ANDAMENTO
  telefoneengenheiro             = (85) 91023584/ (85) 85475366
  telefoneengenheiroimpacto      = 96299566
  id_cliente                     = 27
  id_endereco                    = 56
  id_enderecofatura              = NULL
  art                            = NULL
  engenheiroart                  = NULL