CS = (numeric value of first 16 digits) mod 97

-- Primary key (UUID)
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),

-- Taxonomy ID (auto-generated, unique)
taxonomy_id TEXT UNIQUE NOT NULL,

CREATE OR REPLACE FUNCTION set_taxonomy_id()
RETURNS TRIGGER
LANGUAGE plpgsql
AS $$
DECLARE
  v_type_code TEXT;
BEGIN
  -- Determine type code based on table name
  CASE TG_TABLE_NAME
    WHEN 'sellable_products' THEN v_type_code := '13';
    WHEN 'sweeps' THEN v_type_code := '14';
    WHEN 'inventory_groups' THEN v_type_code := '22';
    WHEN 'staff' THEN v_type_code := '23';
    WHEN 'retailer_locations' THEN v_type_code := '24';
    WHEN 'pickup_portals' THEN v_type_code := '25';
    WHEN 'partner_manifests' THEN v_type_code := '27';
    ELSE
      RAISE EXCEPTION 'Unknown table for taxonomy ID trigger: %', TG_TABLE_NAME;
  END CASE;

  -- Only set if not already provided
  IF NEW.taxonomy_id IS NULL THEN
    NEW.taxonomy_id := get_next_taxonomy_id(v_type_code);
  END IF;

  RETURN NEW;
END;
$$;

# Using UUID
GET /v1/products/550e8400-e29b-41d4-a716-446655440000

# Using Taxonomy ID
GET /v1/products/011300000012345042

// In route handlers
const id = await resolveId('sellable_products', idParam)
// Returns UUID regardless of input format

function isTaxonomyId(id: string): boolean {
  // Taxonomy IDs are exactly 18 digits
  return /^\d{18}$/.test(id)
}

function isUUID(id: string): boolean {
  return /^[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}$/i.test(id)
}

┌─────────────────────────────────┐
│  [BARCODE: 011300000012345042]  │
│                                 │
│     ITEM #12345                 │
│     SKU: EXAMPLE-PRODUCT        │
└─────────────────────────────────┘

function validateTaxonomyId(id: string): boolean {
  if (!/^\d{18}$/.test(id)) return false

  const base = id.substring(0, 16)
  const actualChecksum = id.substring(16, 18)

  // Use BigInt for accurate calculation with large numbers
  const expectedChecksum = (BigInt(base) % 97n).toString().padStart(2, '0')

  return actualChecksum === expectedChecksum
}

const taxonomyIdSchema = z.string().refine(
  (val) => /^\d{18}$/.test(val) && validateChecksum(val),
  { message: 'Invalid taxonomy ID' }
)

type EntityType =
  | 'tote'
  | 'robot'
  | 'cart'
  | 'bag'
  | 'product'
  | 'sweep'
  | 'inventory_group'
  | 'staff'
  | 'retailer_location'
  | 'portal'
  | 'manifest'

const TYPE_CODES: Record<EntityType, string> = {
  tote: '10',
  robot: '11',
  product: '13',
  sweep: '14',
  cart: '20',
  bag: '21',
  inventory_group: '22',
  staff: '23',
  retailer_location: '24',
  portal: '25',
  manifest: '27',
}