FW Module Tables Reference

const { count } = await supabase
  .from("fw_forms")
  .select("*", { count: "exact", head: true })
  .eq("organization_id", organizationId)
  .eq("status", "published");

const { data } = await supabase
  .from("fw_form_submissions")
  .select(`
    id,
    submitted_at,
    status,
    form:fw_forms(name),
    submitted_by_profile:pf_profiles!fw_form_submissions_submitted_by_fkey(display_name)
  `)
  .eq("organization_id", organizationId)
  .order("submitted_at", { ascending: false })
  .limit(5);

const { count } = await supabase
  .from("fw_automation_rules")
  .select("*", { count: "exact", head: true })
  .eq("organization_id", organizationId)
  .eq("is_active", true);

const { count } = await supabase
  .from("fw_workflow_approvals")
  .select("*", { count: "exact", head: true })
  .eq("organization_id", organizationId)
  .is("decision", null);

const oneDayAgo = new Date(Date.now() - 24 * 60 * 60 * 1000).toISOString();
const { count } = await supabase
  .from("fw_workflow_executions")
  .select("*", { count: "exact", head: true })
  .eq("organization_id", organizationId)
  .gte("started_at", oneDayAgo);