Narrative

About

Description

A postal or ZIP code as the source gave it, in its country's format: `94107`, `94107-1234`, `SW1A 1AA`. The format isn't checked, because it depends on the country. Never empty or only spaces.

Unique Name

postal_code

Type

string

Validations

[ "TRIM($this) <> ''" ]

Related Attributes

SHA-256 Hashed Email

SHA-256 of a normalized email, `SHA2(NORMALIZE_EMAIL(email), 256)`: lowercase hex, 64 characters. Hashes of un-normalized emails won't join. The SHA-256 of an empty string, `e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855`, isn't a hash of any email and reads as NULL.

View

Name (Person)

The name of a person.

View

Person Identifier

An identifier a source assigns to a person, such as a member, customer or user id, as the source gives it. Ids join only within the same id space. Never empty or only spaces.

View

Country Code (ISO 3166-1 alpha-2)

The ISO 3166-1 alpha-2 country code

View

Mobile Unique Identifier for Advertising

A mobile advertising identifier (MAID): Apple's IDFA (`type` `idfa`) or Google's advertising id (`type` `adid`), as a lower-case UUID. `00000000-0000-0000-0000-000000000000` means the user opted out of tracking; every opted-out device shares it, so it identifies no device. `00000000-0000-0000-0000-000000000000` is a valid value and can appear in outputs.

View

Related Datasets