pears.IQXNetYoti

• IQXNetYotiID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- 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