====== pears.IQXNetYoti ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **IQXNetYotiID** | char(20) | NOT NULL |  |  |
| URLRequestCode | char(20) | NOT NULL |  |  |
| PersonID | char(20) | NULL |  |  |
| WhenRequested | timestamp | NOT NULL | current timestamp |  |
| sessionID | char(50) | NULL |  | Yoti Session ID after completing a yoti session |
| ID_DOCUMENT_AUTHENTICITY | char(50) | NULL |  | ID_DOCUMENT_AUTHENTICITY check recommendation |
| ID_DOCUMENT_TEXT_DATA_CHECK | char(50) | NULL |  | ID_DOCUMENT_TEXT_DATA_CHECK check recommendation |
| LIVENESS | char(50) | NULL |  | LIVENESS check recommendation |
| ID_DOCUMENT_FACE_MATCH | char(50) | NULL |  | ID_DOCUMENT_FACE_MATCH check recommendation |
| THIRD_PARTY_IDENTITY | char(50) | NULL |  | THIRD_PARTY_IDENTITY check recommendation |
| WATCHLIST_SCREENING | char(50) | NULL |  | WATCHLIST_SCREENING check recommendation |
| WATCHLIST_ADVANCED_CA | char(50) | NULL |  | When the results have come back from yoti |
| CandidateCompleted | timestamp | NULL |  |  |
| YotiCompleted | timestamp | NULL |  |  |
| RightToWork | smallint | NULL |  | Requirements met field from the yoti report |
| WhenSent | timestamp | NULL |  |  |

===== Primary Key =====
  * IQXNetYotiID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| Person | PersonID | [[database:tables:pears_person|pears.Person (personid)]] | ON DELETE CASCADE |

===== Referenced By =====
  * No incoming foreign keys found.

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetYoti"
-- Table comment: 
-- Statement count: 11

CREATE TABLE "pears"."IQXNetYoti" (
    "IQXNetYotiID"                   char(20) NOT NULL
   ,"URLRequestCode"                 char(20) NOT NULL
   ,"PersonID"                       char(20) NULL
   ,"WhenRequested"                  timestamp NOT NULL DEFAULT current timestamp
   ,"sessionID"                      char(50) NULL
   ,"ID_DOCUMENT_AUTHENTICITY"       char(50) NULL
   ,"ID_DOCUMENT_TEXT_DATA_CHECK"    char(50) NULL
   ,"LIVENESS"                       char(50) NULL
   ,"ID_DOCUMENT_FACE_MATCH"         char(50) NULL
   ,"THIRD_PARTY_IDENTITY"           char(50) NULL
   ,"WATCHLIST_SCREENING"            char(50) NULL
   ,"WATCHLIST_ADVANCED_CA"          char(50) NULL
   ,"CandidateCompleted"             timestamp NULL
   ,"YotiCompleted"                  timestamp NULL
   ,"RightToWork"                    smallint NULL
   ,"WhenSent"                       timestamp NULL
   ,PRIMARY KEY ("IQXNetYotiID" ASC) 
)
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."sessionID" IS 
	'Yoti Session ID after completing a yoti session'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."ID_DOCUMENT_AUTHENTICITY" IS 
	'ID_DOCUMENT_AUTHENTICITY check recommendation'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."ID_DOCUMENT_TEXT_DATA_CHECK" IS 
	'ID_DOCUMENT_TEXT_DATA_CHECK check recommendation'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."LIVENESS" IS 
	'LIVENESS check recommendation'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."ID_DOCUMENT_FACE_MATCH" IS 
	'ID_DOCUMENT_FACE_MATCH check recommendation'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."THIRD_PARTY_IDENTITY" IS 
	'THIRD_PARTY_IDENTITY check recommendation'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."WATCHLIST_SCREENING" IS 
	'WATCHLIST_SCREENING check recommendation'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."WATCHLIST_ADVANCED_CA" IS 
	'When the results have come back from yoti'
go


COMMENT ON COLUMN "pears"."IQXNetYoti"."RightToWork" IS 
	'Requirements met field from the yoti report'
go


ALTER TABLE "pears"."IQXNetYoti"
    ADD FOREIGN KEY "Person" ("PersonID" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE CASCADE
go
</code>