contactVerificationIdidentifierrequiredWhat identifies the verification, made by the application
Becomes the column contact_verification_id of contact_verification.
Written at commons/data/models/identity/concepts.ts:88
The proof that an address is a person's
Model identity. Written in commons/data/models/identity/concepts.ts:85. Identified by contactVerificationId.
contactVerificationIdidentifierrequiredWhat identifies the verification, made by the application
Becomes the column contact_verification_id of contact_verification.
Written at commons/data/models/identity/concepts.ts:88
methodcode of verificationMethodrequiredHow it was proved
Becomes the column method of contact_verification.
Written at commons/data/models/identity/concepts.ts:90
verifiedAtinstantrequiredWhen the address was proved to be the person's
Becomes the column verified_at of contact_verification.
Written at commons/data/models/identity/concepts.ts:89
contactoneThe address that was proved To electronicContact. Written at commons/data/models/identity/concepts.ts:85
Projects to the table contact_verification with the primary key contact_verification_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
contact_electronic_contact_id | text | false | reference | contactVerification.contact |
contact_verification_id | text | false | attribute | contactVerification.contactVerificationId |
method | text | false | attribute | contactVerification.method |
verified_at | timestamp | false | attribute | contactVerification.verifiedAt |
CREATE TABLE IF NOT EXISTS "contact_verification" (
"contact_verification_id" VARCHAR NOT NULL PRIMARY KEY,
"verified_at" TIMESTAMPTZ NOT NULL,
"method" VARCHAR NOT NULL,
"contact_electronic_contact_id" VARCHAR NOT NULL,
CONSTRAINT "contact_verification_contact_electronic_contact_id_fk" FOREIGN KEY ("contact_electronic_contact_id") REFERENCES "electronic_contact" ("electronic_contact_id"),
CONSTRAINT "contact_verification_contact_electronic_contact_id_uq" UNIQUE ("contact_electronic_contact_id"),
CONSTRAINT "contact_verification_method_ck" CHECK ("method" IN ('email_link', 'otp', 'directory_asserted', 'admin'))
);CREATE TABLE IF NOT EXISTS "contact_verification" (
"contact_verification_id" TEXT NOT NULL PRIMARY KEY,
"verified_at" TIMESTAMPTZ NOT NULL,
"method" TEXT NOT NULL,
"contact_electronic_contact_id" TEXT NOT NULL,
CONSTRAINT "contact_verification_contact_electronic_contact_id_fk" FOREIGN KEY ("contact_electronic_contact_id") REFERENCES "electronic_contact" ("electronic_contact_id"),
CONSTRAINT "contact_verification_contact_electronic_contact_id_uq" UNIQUE ("contact_electronic_contact_id"),
CONSTRAINT "contact_verification_method_ck" CHECK ("method" IN ('email_link', 'otp', 'directory_asserted', 'admin'))
);CREATE TABLE IF NOT EXISTS "contact_verification" (
"contact_verification_id" TEXT NOT NULL PRIMARY KEY,
"verified_at" TEXT NOT NULL,
"method" TEXT NOT NULL,
"contact_electronic_contact_id" TEXT NOT NULL,
CONSTRAINT "contact_verification_contact_electronic_contact_id_fk" FOREIGN KEY ("contact_electronic_contact_id") REFERENCES "electronic_contact" ("electronic_contact_id"),
CONSTRAINT "contact_verification_contact_electronic_contact_id_uq" UNIQUE ("contact_electronic_contact_id"),
CONSTRAINT "contact_verification_method_ck" CHECK ("method" IN ('email_link', 'otp', 'directory_asserted', 'admin'))
);Read and written from TypeScript with the types the model gives: import { contactVerification } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/identity.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { contactVerification } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(contactVerification).select((s) => ({ contactVerificationId: s.contactVerification.contactVerificationId, verifiedAt: s.contactVerification.verifiedAt })).run(runner);