Platform Foundation Database Tables

pf_organizations (1) ──< (many) pf_sites
pf_organizations (1) ──< (many) pf_departments
pf_profiles (many) >── (1) pf_organizations

// Check permission
const hasPermission = await supabase.rpc('pf_user_has_permission', {
  p_user_id: userId,
  p_permission_key: 'hr.employees.view'
});

// Documents stored in Supabase Storage
const bucket = 'pf-documents';
const path = `${organizationId}/${documentId}/${version}`;

// Fetch picklist items
const { data } = await supabase
  .from('pf_picklist_items')
  .select('*')
  .eq('picklist_id', picklistId)
  .eq('is_active', true)
  .order('display_order');

const { data } = await supabase
  .from('pf_profiles')
  .select(`
    *,
    organization:pf_organizations(*)
  `)
  .eq('user_id', userId);

const { data } = await supabase.rpc('pf_get_user_permissions', {
  p_user_id: userId,
  p_organization_id: orgId
});

const { data } = await supabase
  .from('pf_notifications')
  .select('*')
  .eq('user_id', userId)
  .eq('is_read', false)
  .order('created_at', { ascending: false });