CREATE TABLE IF NOT EXISTS clientes_master (
  id BIGSERIAL PRIMARY KEY,
  nombre_canonico TEXT NOT NULL,
  cuit TEXT,
  cuit_es_placeholder BOOLEAN DEFAULT FALSE,
  alias_facturacion TEXT[] DEFAULT '{}',
  alias_cobranzas TEXT[] DEFAULT '{}',
  alias_aging TEXT[] DEFAULT '{}',
  aging_codigos BIGINT[] DEFAULT '{}',
  estado TEXT DEFAULT 'auto',
  notas TEXT,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW(),
  deleted_at TIMESTAMPTZ
);
CREATE INDEX IF NOT EXISTS idx_cm_cuit ON clientes_master(cuit) WHERE deleted_at IS NULL;
CREATE INDEX IF NOT EXISTS idx_cm_estado ON clientes_master(estado) WHERE deleted_at IS NULL;
CREATE INDEX IF NOT EXISTS idx_cm_alias_fact ON clientes_master USING GIN(alias_facturacion);
CREATE INDEX IF NOT EXISTS idx_cm_alias_cob ON clientes_master USING GIN(alias_cobranzas);
CREATE INDEX IF NOT EXISTS idx_cm_alias_ag ON clientes_master USING GIN(alias_aging);
ALTER TABLE clientes_master ENABLE ROW LEVEL SECURITY;
CREATE POLICY cm_all ON clientes_master FOR ALL USING (true) WITH CHECK (true);