Table of Contents



pears.ConsentTypeOption

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

Description

Options for each Consent Type (GDPR)

Columns

Column Type Null Default Comment
ConsentTypeOptionID char(20) NOT NULL
ConsentTypeID char(20) NULL
Name char(100) NOT NULL
Notes long varchar NULL
IsWithdraw smallint NULL 0
SortOrder smallint NULL
HidePersonDetails smallint NULL 0 Do not allow selecting, automatic only
NeedsDate smallint NULL 0 ask withdraw date flag

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
ConsentType ConsentTypeID pears.ConsentType (ConsentTypeID) ON DELETE CASCADE

Referenced By

Table Constraint Columns Referenced columns
pears.ConsentPersonOption ConsentTypeOption ConsentTypeOptionID ConsentTypeOptionID
pears.ConsentPersonOptionHistory ConsentTypeOption ConsentTypeOptionID ConsentTypeOptionID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ConsentTypeOption"
-- Table comment: Options for each Consent Type (GDPR)
-- Statement count: 5
 
CREATE TABLE "pears"."ConsentTypeOption" (
    "ConsentTypeOptionID"            CHAR(20) NOT NULL
   ,"ConsentTypeID"                  CHAR(20) NULL
   ,"Name"                           CHAR(100) NOT NULL
   ,"Notes"                          long VARCHAR NULL
   ,"IsWithdraw"                     SMALLINT NULL DEFAULT 0
   ,"SortOrder"                      SMALLINT NULL
   ,"HidePersonDetails"              SMALLINT NULL DEFAULT 0
   ,"NeedsDate"                      SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("ConsentTypeOptionID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."ConsentTypeOption"."HidePersonDetails" IS 
	'Do not allow selecting, automatic only'
GO
 
 
COMMENT ON COLUMN "pears"."ConsentTypeOption"."NeedsDate" IS 
	'ask withdraw date flag'
GO
 
 
COMMENT ON TABLE "pears"."ConsentTypeOption" IS 
	'Options for each Consent Type (GDPR)'
GO
 
 
ALTER TABLE "pears"."ConsentTypeOption"
    ADD FOREIGN KEY "ConsentType" ("ConsentTypeID" ASC)
    REFERENCES "pears"."ConsentType" ("ConsentTypeID")
    ON DELETE CASCADE
GO