pears.IQXNetWizardState

Tracks where a candidate is in the registration wizard so they can resume mid-flow (e.g. after email validation). A row is created when a candidate begins registration and deleted once registration completes (“NetV2RegistrationComplete”). “WizardID” allows multiple distinct wizard variants (e.g. per division) to run independently; “DEFAULT” is used when no custom wizard is configured.

• IQXNetUserID, WizardID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetWizardState"
-- Table comment: Tracks where a candidate is in the registration wizard so they can resume mid-flow (e.g. after email validation). A row is created when a candidate begins registration and deleted once registration completes ("NetV2RegistrationComplete"). "WizardID" allows multiple distinct wizard variants (e.g. per division) to run independently; "DEFAULT" is used when no custom wizard is configured.
-- Statement count: 6
 
CREATE TABLE "pears"."IQXNetWizardState" (
    "IQXNetUserID"                   CHAR(20) NOT NULL
   ,"WizardID"                       CHAR(20) NOT NULL
   ,"Path"                           long VARCHAR NULL
   ,"PreviousCandState"              CHAR(4) NULL
   ,"WhenCreated"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,PRIMARY KEY ("IQXNetUserID" ASC,"WizardID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetWizardState"."IQXNetUserID" IS 
	'FK → IQXNetUser — the registering user'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetWizardState"."WizardID" IS 
	'Wizard variant identifier — DEFAULT or a custom division wizard ID'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetWizardState"."Path" IS 
	'Current page/step the wizard is on (e.g. EMAILVALIDATION)'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetWizardState" IS 
	'Tracks where a candidate is in the registration wizard so they can resume mid-flow (e.g. after email validation). A row is created when a candidate begins registration and deleted once registration completes ("NetV2RegistrationComplete"). "WizardID" allows multiple distinct wizard variants (e.g. per division) to run independently; "DEFAULT" is used when no custom wizard is configured.'
GO
 
 
ALTER TABLE "pears"."IQXNetWizardState"
    ADD NOT NULL FOREIGN KEY "IQXNetUser" ("IQXNetUserID" ASC)
    REFERENCES "pears"."IQXNetUser" ("IQXNetUserID")
    ON DELETE CASCADE
GO