🗄️ Enderecos de Cilindro

{
  "table-id": "cilindros_enderecos",
  "data-table-ondevou": "cilindros_enderecos",
  "readonly": "sim",
  "table-class": "highlight",
  "controls": [
    "add",
    "copy",
    "save",
    "qrcode",
    "delete",
    "remove"
  ],
  "html": {
    "div": {
      "before": "",
      "after": ""
    }
  },
  "search": {
    "id_search_cilindro_endereco": {
      "data-type-ondevou": "number",
      "texto_label": "Endereço",
      "data-field-ondevou": "id_search_cilindro_endereco",
      "data-table-ondevou": "view_cilindros_enderecos",
      "getcollector": "{\"qrcode\":\"{\\\"qrcode-type\\\":[\\\"clend\\\"]}\",\"table-setups\":\"{\\\"search\\\":\\\"nao\\\",\\\"html\\\":\\\"nao\\\",\\\"controls\\\":[\\\"info\\\",\\\"remove\\\"]}\"}",
      "getdata": "{\"view\":\"view_cilindros_enderecos\",\"data\":\"view_cilindros_enderecos\",\"text-empty-search\":\"sim\",\"data-update-full-fields\":\"sim\",\"campo-data-id\":\"id_endereco\",\"campo-data-value-input\":\"id_endereco,nome_endereco,referencia_endereco\",\"campo-data-input-select-view\":\"id_endereco,nome_endereco,referencia_endereco\",\"query\":{\"select\":\"* from view_cilindros_enderecos\",\"where\":{\"and\":{\"texto_digitado\":{\"left\":\"(unaccent(LOWER(concat(id_endereco,` `,nome_endereco,` `,referencia_endereco))) ilike `%\",\"right\":\"%`) and (participante=`1`)\"}}},\"order\":\"id_endereco desc\"}}"
    }
  },
  "headers": {
    "Id": {
      "width": "7%"
    },
    "qrcode": {
      "width": "100px",
      "align": "left",
      "class": "qrcode"
    },
    "Participante": {
      "width": "10%"
    },
    "Referência": {
      "width": "10%"
    },
    "Nome": {
      "width": "50%"
    }
  },
  "columns": {
    "Id": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "number",
        "data-field-ondevou": "id",
        "data-field-alias-ondevou": "id_endereco",
        "data-table-ondevou": "cilindros_enderecos",
        "controls-acao": {
          "qrcode": {
            "acao": "getQRcode",
            "messagem": "Gerar QR Code"
          }
        },
        "formsearch": {
          "required": "",
          "getcollector": "{\"qrcode\":\"{\\\"qrcode-type\\\":[\\\"clend\\\"]}\",\"table-setups\":\"{\\\"search\\\":\\\"nao\\\",\\\"html\\\":\\\"nao\\\",\\\"controls\\\":[\\\"info\\\",\\\"remove\\\"]}\"}"
        }
      }
    },
    "qrcode": {
      "input": {
        "readonly": "readonly",
        "type": "canvas",
        "qrcode-type": "clend",
        "qrcode-text-fields": "referencia",
        "data-type-ondevou": "text",
        "data-field-ondevou": "qrcode",
        "data-table-ondevou": "qrcode"
      }
    },
    "Participante": {
      "input": {
        "readonly": "readonly",
        "required": "required",
        "data-type-ondevou": "text",
        "value": "1",
        "data-field-ondevou": "participante",
        "data-table-ondevou": "cilindros_enderecos"
      }
    },
    "Referência": {
      "input": {
        "required": "required",
        "data-type-ondevou": "text",
        "data-field-ondevou": "referencia",
        "data-field-alias-ondevou": "referencia_endereco",
        "data-table-ondevou": "cilindros_enderecos",
        "formsearch": {
          "required": ""
        }
      }
    },
    "Nome": {
      "input": {
        "required": "required",
        "data-type-ondevou": "text",
        "data-field-ondevou": "nome",
        "data-field-alias-ondevou": "nome_endereco",
        "data-table-ondevou": "cilindros_enderecos",
        "formsearch": {
          "required": ""
        }
      }
    }
  },
  "formsearch": {
    "data-table-ondevou": "view_cilindros_enderecos",
    "data-where-fixed": "participante=`1`",
    "data-where-order": "order by id_endereco desc",
    "input": {}
  },
  "url_documentacao": "/docs/ondevou-db-cilindros_enderecos.html",
  "nome_tabela": "cilindros_enderecos"
}

-- ============================================================
-- ESTRUTURA COMPLETA DA TABELA cilindros_enderecos
-- Fonte: PostgreSQL - 12/08/2026 10:24:07
-- ============================================================

CREATE TABLE public.cilindros_enderecos (
    id integer NOT NULL DEFAULT nextval('cilindros_enderecos_id_seq'::regclass),
    participante integer,
    nome varchar(255),
    referencia varchar(255),
    CONSTRAINT cilindros_enderecos_pkey PRIMARY KEY (id),
    CONSTRAINT 2200_221050_1_not_null CHECK (id IS NOT NULL)
);

-- ============================================================
-- ÍNDICES
-- ============================================================
CREATE UNIQUE INDEX cilindros_enderecos_pk_id ON public.cilindros_enderecos USING btree (id);
CREATE INDEX idx_cilindros_enderecos_p_id ON public.cilindros_enderecos USING btree (participante, id DESC);
CREATE INDEX idx_cilindros_enderecos_participante ON public.cilindros_enderecos USING btree (participante);

✅ SQL extraído DIRETAMENTE do banco de dados