Registry schema reference

Your account's registry view exposes the following columns:

Column	Type	Description
`id`	STRING	Unique identifier of the registry entry
`identifier_type`	STRING	What the hashed identifier was derived from — for example `email`, `DROP_email`, `DROP_phone`, `DROP_NDZ`, `DROP_vin`
`identifier_hash`	STRING	SHA-256 hash of the normalized identifier (see hashing convention below)
`deleted`	BOOL	Deletion requested or applied for this user
`opt_out_sale`	BOOL	Opted out of the sale of personal data
`opt_out_targeted_ads`	BOOL	Opted out of targeted advertising / cross-context sharing
`opt_out_marketing`	BOOL	Opted out of direct marketing
`opt_out_automated_decisions`	BOOL	Opted out of automated decision-making and profiling
`opt_out_ai_training`	BOOL	Opted out of the use of their data for AI model training
`limit_spi`	BOOL	Requested to limit the use of sensitive personal information
`extra_signals`	JSON	Additional choice signals beyond the standard set
`last_request_id`	STRING	The most recent request that touched this entry
`last_source`	STRING	Channel of the most recent update: `dsr`, `drop`, `api`, `import`, `cmp`, `gpc`, or `manual`
`resolution`	STRING	Processing outcome: `DELETED`, `NOT_FOUND`, `OPT_OUT_APPLIED`, `PARTIALLY_DELETED`, or `SUPPRESSED`
`audit_note`	STRING	Human-readable context for the entry, for audit and review
`created_at`	TIMESTAMP	When the entry was first created
`updated_at`	TIMESTAMP	When the entry was last updated

Hashing convention. Identifiers are hashed with SHA-256 after normalization — email addresses are lowercased and trimmed, phone numbers are formatted to E.164 — and stored as lowercase hex. To match registry entries against identifiers in your own systems, apply the same normalization and hashing on your side.

Resolution values. DELETED — the identifier was matched and the data erased. NOT_FOUND — no match existed at processing time; the entry is retained to match future data. OPT_OUT_APPLIED — opt-out choices were applied with no deletion involved. PARTIALLY_DELETED — deletion completed in some systems and is pending in others. SUPPRESSED — proactively added to prevent future collection or processing.