Table of Contents



pears.IQXSSOAccount

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Columns

Column Type Null Default Comment
SSOID char(100) NOT NULL Unique SSO identity identifier
IQXNetUserID char(20) NOT NULL User ID linked to this SSO account
SSOType char(20) NOT NULL Type/provider of SSO (e.g., apple, google)
Email char(100) NULL Email address associated with this SSO account
EmailVerified smallint NULL Flag for whether the email is verified (1 = yes, 0 = no
AccessToken long varchar NULL Short-lived token from the SSO provider
RefreshToken long varchar NULL Refresh token to renew access
Exp integer NULL Expiration timestamp for the access token (Unix time)

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
IQXSSOAccountSSOTypeIQXNetUserID Unique index SSOType, IQXNetUserID

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXSSOAccount"
-- Table comment: 
-- Statement count: 10
 
CREATE TABLE "pears"."IQXSSOAccount" (
    "SSOID"                          CHAR(100) NOT NULL
   ,"IQXNetUserID"                   CHAR(20) NOT NULL
   ,"SSOType"                        CHAR(20) NOT NULL
   ,"Email"                          CHAR(100) NULL
   ,"EmailVerified"                  SMALLINT NULL
   ,"AccessToken"                    long VARCHAR NULL
   ,"RefreshToken"                   long VARCHAR NULL
   ,"Exp"                            INTEGER NULL
   ,PRIMARY KEY ("SSOID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."SSOID" IS 
	'Unique SSO identity identifier'
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."IQXNetUserID" IS 
	'User ID linked to this SSO account'
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."SSOType" IS 
	'Type/provider of SSO (e.g., apple, google)'
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."Email" IS 
	'Email address associated with this SSO account'
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."EmailVerified" IS 
	'Flag for whether the email is verified (1 = yes, 0 = no'
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."AccessToken" IS 
	'Short-lived token from the SSO provider'
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."RefreshToken" IS 
	'Refresh token to renew access'
GO
 
 
COMMENT ON COLUMN "pears"."IQXSSOAccount"."Exp" IS 
	'Expiration timestamp for the access token (Unix time)'
GO
 
 
CREATE UNIQUE INDEX "IQXSSOAccountSSOTypeIQXNetUserID" ON "pears"."IQXSSOAccount"
    ( "SSOType","IQXNetUserID" )
GO