Forms & Workflow Database Tables

type FieldType = 
  | 'text' | 'textarea' | 'number' | 'email' | 'phone'
  | 'date' | 'datetime' | 'time'
  | 'select' | 'multiselect' | 'radio' | 'checkbox'
  | 'file' | 'image' | 'signature'
  | 'address' | 'lookup' | 'calculated'
  | 'section' | 'repeater' | 'table';

interface FormField {
  id: string;
  name: string;
  label: string;
  type: FieldType;
  required: boolean;
  validation?: ValidationRule[];
  options?: SelectOption[];      // For select/radio/checkbox
  lookup_config?: LookupConfig;  // For lookup fields
  calculated_formula?: string;   // For calculated fields
  conditional_logic?: ConditionalRule[];
}

interface Submission {
  id: string;
  form_id: string;
  form_version_id: string;
  data: Record<string, any>;  // JSONB field data
  status: 'draft' | 'submitted' | 'processing' | 'completed';
  submitted_at?: string;
  submitted_by?: string;
}

interface WorkflowDefinition {
  id: string;
  name: string;
  trigger_type: 'form_submission' | 'schedule' | 'event' | 'manual';
  trigger_config: TriggerConfig;
  steps: WorkflowStep[];
  variables: WorkflowVariable[];
}

interface WorkflowStep {
  id: string;
  type: 'action' | 'condition' | 'approval' | 'delay' | 'subflow';
  config: StepConfig;
  next_steps: string[];  // Step IDs
  on_error?: string;     // Error handler step
}

fw_approval_requests (pending)
        ↓
fw_approval_assignments (assigned to approvers)
        ↓
fw_approval_history (decision recorded)
        ↓
fw_approval_requests (approved/rejected)

type ActionType = 
  | 'send_email' | 'send_notification'
  | 'create_record' | 'update_record' | 'delete_record'
  | 'call_api' | 'call_webhook'
  | 'assign_task' | 'start_workflow'
  | 'calculate' | 'transform';

const { data } = await supabase
  .from('fw_forms')
  .select(`
    *,
    fields:fw_form_fields(*)
  `)
  .eq('id', formId)
  .single();

const { data } = await supabase
  .from('fw_approval_requests')
  .select(`
    *,
    assignments:fw_approval_assignments(
      *,
      approver:pf_profiles(first_name, last_name)
    )
  `)
  .eq('status', 'pending')
  .contains('assignments.approver_id', [userId]);

const { data } = await supabase
  .from('fw_workflow_executions')
  .select(`
    *,
    logs:fw_execution_logs(*)
  `)
  .eq('id', executionId)
  .single();

const { data } = await supabase
  .from('fw_form_submissions')
  .select(`
    *,
    form:fw_forms(name),
    submitter:pf_profiles(first_name, last_name)
  `)
  .eq('form_id', formId)
  .order('submitted_at', { ascending: false });

// ✅ CORRECT - Use platform layer
import { FormEmbed, useFormSubmission } from '@/platform/forms';

// ❌ WRONG - Direct core import
import { FormEmbed } from '@/cores/fw/components';