🗄️ Lojas

{
  "table-id": "lojas",
  "data-table-ondevou": "lojas",
  "table-class": "highlight",
  "controls": [
    "add",
    "copy",
    "edit",
    "save",
    "qrcode",
    "delete",
    "remove"
  ],
  "html": {
    "div": {
      "before": "",
      "after": ""
    }
  },
  "search": {
    "id_search_loja": {
      "data-type-ondevou": "number",
      "texto_label": "Loja",
      "title": "Digite parte do descrição",
      "data-field-ondevou": "id_search_loja",
      "data-table-ondevou": "view_lojas",
      "getcollector": "{\"qrcode\":\"{\\\"qrcode-type\\\":[\\\"loja\\\"]}\",\"table-setups\":\"{\\\"search\\\":\\\"nao\\\",\\\"html\\\":\\\"nao\\\",\\\"controls\\\":[\\\"info\\\",\\\"remove\\\"]}\"}",
      "getdata": "{\"view\":\"view_lojas\",\"data\":\"view_lojas\",\"text-empty-search\":\"sim\",\"campo-data-id\":\"id_loja\",\"campo-data-value-input\":\"nome_loja\",\"campo-data-input-select-view\":\"nome_loja\",\"query\":{\"select\":\"* from view_lojas\",\"where\":{\"and\":{\"texto_digitado\":{\"left\":\"(unaccent(LOWER(concat(id_loja,` `,nome_loja))) ilike `%\",\"right\":\"%`) and (participante=`1`)\"}}}}}"
    }
  },
  "routines": {
    "add": "665",
    "edit": "666"
  },
  "headers": {
    "Id": {
      "width": "10%"
    },
    "qrcode": {
      "width": "100px",
      "align": "left",
      "class": "qrcode"
    },
    "Participante": {
      "width": "10%"
    },
    "Nome": {
      "width": "30%"
    },
    "Descrição": {
      "width": "50%"
    }
  },
  "columns": {
    "Id": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "number",
        "data-field-ondevou": "id",
        "data-field-alias-ondevou": "id_loja",
        "data-table-ondevou": "lojas",
        "getpage": "{\"page\":\"loja\",\"campo\":\"id\"}",
        "controls-acao": {
          "qrcode": {
            "acao": "getQRcode",
            "messagem": "Gerar QR Code"
          }
        },
        "formsearch": {
          "required": ""
        }
      }
    },
    "qrcode": {
      "input": {
        "readonly": "readonly",
        "type": "canvas",
        "qrcode-type": "loja",
        "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": "lojas"
      }
    },
    "Nome": {
      "input": {
        "required": "required",
        "data-type-ondevou": "text",
        "data-field-ondevou": "nome",
        "data-field-alias-ondevou": "nome_loja",
        "data-table-ondevou": "lojas",
        "formsearch": {
          "required": ""
        }
      }
    },
    "Descrição": {
      "input": {
        "required": "required",
        "data-type-ondevou": "text",
        "data-field-ondevou": "descricao",
        "data-field-alias-ondevou": "descricao_loja",
        "data-table-ondevou": "lojas",
        "formsearch": {
          "required": ""
        }
      }
    }
  },
  "formsearch": {
    "data-table-ondevou": "view_lojas",
    "data-where-order": "order by id_loja desc",
    "data-where-fixed": "participante in (`1`)",
    "input": {}
  },
  "url_documentacao": "/docs/ondevou-db-lojas.html",
  "nome_tabela": "lojas"
}

-- ============================================================
-- ESTRUTURA COMPLETA DA TABELA lojas
-- Fonte: PostgreSQL - 12/08/2026 10:24:28
-- ============================================================

CREATE TABLE public.lojas (
    id integer NOT NULL DEFAULT nextval('lojas_id_seq'::regclass),
    participante integer NOT NULL,
    nome varchar(255) NOT NULL,
    descricao varchar(255),
    CONSTRAINT lojas_pkey PRIMARY KEY (id),
    CONSTRAINT 2200_221505_1_not_null CHECK (id IS NOT NULL),
    CONSTRAINT 2200_221505_2_not_null CHECK (participante IS NOT NULL),
    CONSTRAINT 2200_221505_3_not_null CHECK (nome IS NOT NULL)
);

-- ============================================================
-- ÍNDICES
-- ============================================================
CREATE INDEX idx_lojas_p_id ON public.lojas USING btree (participante, id DESC);
CREATE INDEX idx_lojas_participante ON public.lojas USING btree (participante);
CREATE UNIQUE INDEX lojas_pk_id ON public.lojas USING btree (id);

✅ SQL extraído DIRETAMENTE do banco de dados