🗄️ Files de Post

{
  "table-id": "posts_files",
  "data-table-ondevou": "posts_files",
  "data-table-update": "sim",
  "readonly": "nao",
  "table-class": "highlight",
  "putdata": {
    "inputsExtras": "participante,latitude,longitude,ip,id_membro",
    "trigger": "uploadFilesEntidadeSend(this)"
  },
  "controls": [
    "info",
    "marker",
    "cloud_upload",
    "add",
    "copy",
    "save",
    "delete",
    "remove"
  ],
  "html": {
    "div": {
      "before": "",
      "after": ""
    }
  },
  "headers": {
    "Id": {
      "width": "10%"
    },
    "Participante": {
      "width": "100px"
    },
    "Data hora inclusão": {
      "width": "10%"
    },
    "Id post": {
      "width": "10%"
    },
    "Descrição": {
      "type": "text",
      "width": "20%"
    },
    "Nome do arquivo": {
      "width": "20%"
    },
    "arquivo_old": {
      "width": "20%"
    },
    "Membro": {
      "width": "20%"
    },
    "Pasta destino": {
      "type": "hidden"
    },
    "Latitude": {
      "type": "hidden"
    },
    "Longitude": {
      "type": "hidden"
    },
    "Ip": {
      "type": "hidden"
    },
    "Data": {
      "type": "hidden"
    }
  },
  "columns": {
    "Id": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "number",
        "data-field-ondevou": "id",
        "data-field-alias-ondevou": "id_post_file",
        "data-table-ondevou": "posts_files",
        "controls-acao": {
          "cloud_upload": {
            "acao": "uploadFilesEntidadeSelect",
            "messagem": "Vínculos"
          }
        }
      }
    },
    "Participante": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "text",
        "data-field-ondevou": "participante",
        "value": "1",
        "data-table-ondevou": "posts_files"
      }
    },
    "Data hora inclusão": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "date",
        "data-field-ondevou": "data_hora_inclusao",
        "data-table-ondevou": "view_posts_files"
      }
    },
    "Id post": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "number",
        "data-field-ondevou": "id_post",
        "data-table-ondevou": "posts_files"
      }
    },
    "Descrição": {
      "input": {
        "data-type-ondevou": "text",
        "data-field-ondevou": "descricao",
        "placeholder": "Digite algo sobre a foto ou video..",
        "autofocus": "autofocus",
        "data-table-ondevou": "posts_files"
      }
    },
    "Nome do arquivo": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "text",
        "data-field-ondevou": "nome_arquivo",
        "data-table-ondevou": "posts_files"
      }
    },
    "arquivo_old": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "text",
        "data-field-ondevou": "arquivo_old",
        "data-field-alias-ondevou": "nome_arquivo",
        "data-table-ondevou": "posts_files"
      }
    },
    "Membro": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "number",
        "data-id-field-ondevou": "id_membro",
        "data-field-ondevou": "nome_membro",
        "data-table-ondevou": "posts_files",
        "formsearch": {
          "required": ""
        },
        "getdata": "{\"view\":\"view_membros\",\"data\":\"view_membros\",\"campo-data-id\":\"id_membro\",\"campo-data-value-input\":\"nome_membro\",\"campo-data-input-select-view\":\"nome_membro,email_membro\",\"query\":{\"select\":\"* from view_membros\",\"where\":{\"and\":{\"texto_digitado\":{\"left\":\"(unaccent(LOWER(concat(id_membro,` `,nome_membro,` `,email_membro))) ilike `%\",\"right\":\"%`)\"}}}}}"
      }
    },
    "Pasta destino": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "text",
        "data-field-ondevou": "pasta_destino",
        "value": "/files/posts/",
        "data-table-ondevou": "no_database"
      }
    },
    "Latitude": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "number",
        "data-field-ondevou": "latitude",
        "data-table-ondevou": "posts_files"
      }
    },
    "Longitude": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "number",
        "data-field-ondevou": "longitude",
        "data-table-ondevou": "posts_files"
      }
    },
    "Ip": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "text",
        "data-field-ondevou": "ip",
        "data-table-ondevou": "posts_files"
      }
    },
    "Data": {
      "input": {
        "readonly": "readonly",
        "data-type-ondevou": "date",
        "data-field-ondevou": "data_inclusao",
        "data-table-ondevou": "view_posts_files"
      }
    }
  },
  "formsearch": {
    "data-table-ondevou": "view_posts_files",
    "data-view-ondevou": "view_posts_files",
    "data-where-fixed": "participante=`1`",
    "input": {
      "data_inicial": {
        "data-field-ondevou": "data_inicial",
        "data-type-ondevou": "date",
        "type": "date",
        "class": "datepicker",
        "texto_label": "Data Inicial",
        "data-field-where": "data"
      },
      "data_final": {
        "data-field-ondevou": "data_final",
        "data-type-ondevou": "date",
        "type": "date",
        "class": "datepicker",
        "texto_label": "Data Final",
        "data-field-where": "data"
      }
    }
  },
  "url_documentacao": "/docs/ondevou-db-posts_files.html",
  "nome_tabela": "posts_files"
}

-- ============================================================
-- ESTRUTURA COMPLETA DA TABELA posts_files
-- Fonte: PostgreSQL - 12/08/2026 10:24:39
-- ============================================================

CREATE TABLE public.posts_files (
    id integer NOT NULL DEFAULT nextval('posts_files_id_seq'::regclass),
    id_post integer,
    participante integer,
    id_membro integer,
    latitude numeric(25, 20),
    longitude numeric(25, 20),
    ip varchar(255),
    descricao text,
    nome_arquivo text,
    data timestamp DEFAULT now(),
    ordem integer,
    CONSTRAINT posts_files_pkey PRIMARY KEY (id),
    CONSTRAINT 2200_221843_1_not_null CHECK (id IS NOT NULL)
);

-- ============================================================
-- ÍNDICES
-- ============================================================
CREATE INDEX idx_posts_files_id_membro ON public.posts_files USING btree (id_membro);
CREATE INDEX idx_posts_files_id_post ON public.posts_files USING btree (id_post);
CREATE INDEX idx_posts_files_p_data ON public.posts_files USING btree (participante, data DESC);
CREATE INDEX idx_posts_files_p_id ON public.posts_files USING btree (participante, id DESC);
CREATE INDEX idx_posts_files_participante ON public.posts_files USING btree (participante);
CREATE UNIQUE INDEX posts_files_pk_id ON public.posts_files USING btree (id);

✅ SQL extraído DIRETAMENTE do banco de dados