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

===== Description =====
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.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **IQXNetUserID** | char(20) | NOT NULL |  | FK → IQXNetUser — the registering user |
| **WizardID** | char(20) | NOT NULL |  | Wizard variant identifier — DEFAULT or a custom division wizard ID |
| Path | long varchar | NULL |  | Current page/step the wizard is on (e.g. EMAILVALIDATION) |
| PreviousCandState | char(4) | NULL |  |  |
| WhenCreated | timestamp | NULL | current timestamp |  |

===== Primary Key =====
  * IQXNetUserID, WizardID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| IQXNetUser | IQXNetUserID | [[database:tables:pears_iqxnetuser|pears.IQXNetUser (IQXNetUserID)]] | NOT NULL; 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"."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
</code>