Saltar al contenido

app.organization_verification_requests

TablaSeguridad a nivel de fila activa

An org's request to verify its business identity (Section 4.8.3): a Stripe Identity verification session or a business registry entry, checked by the verifier job, which records a passed check through A30's app.record_organization_verification.

Clave primaria: id

Columnas de app.organization_verification_requests
ColumnaTipoAdmite nulosDescripción
iduuidNoPrimary key, UUID v7.
org_iduuidNoOrg asking to be verified.Hace referencia a app.organizations.id
methodtextNoStripe Identity or Business Registry: the labels of A30's app.organization_verification_method (0860), which migrates after this range.
provider_referencetextNoStripe Identity verification session id, or the registry entry as <jurisdiction>/<company number>.
request_stateapp.verification_request_stateNoPending, Passed or Failed. Written by the verifier.
last_checked_attimestamp with time zoneSíWhen the verifier last checked.
failure_reasontextSíWhy the check failed.
deleted_attimestamp with time zoneSíSoft delete time. A row with deleted_at set is ignored by every access helper.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidSíPerson who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidSíPerson who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id