pears.IQXNetTagGroup
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Questionaire Groups for IQXWeb
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| IQXNetTagGroupID | char(20) | NOT NULL | ||
| Description | char(100) | NOT NULL | ||
| Type | char(1) | NULL | N=Notification |
Primary Key
- IQXNetTagGroupID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.DeletedIQXNetTagGroupMember | IQXNetTagGroup | IQXNetTagGroupID | IQXNetTagGroupID |
| pears.IQXNetTagGroupMember | IQXNetTagGroup | IQXNetTagGroupID | IQXNetTagGroupID |
| pears.NotificationTemplate | IQXNetTagGroup | IQXNetTagGroupID | IQXNetTagGroupID |
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."IQXNetTagGroup" -- Table comment: Questionaire Groups for IQXWeb -- Statement count: 3 CREATE TABLE "pears"."IQXNetTagGroup" ( "IQXNetTagGroupID" CHAR(20) NOT NULL ,"Description" CHAR(100) NOT NULL ,"Type" CHAR(1) NULL ,PRIMARY KEY ("IQXNetTagGroupID" ASC) ) GO COMMENT ON COLUMN "pears"."IQXNetTagGroup"."Type" IS 'N=Notification' GO COMMENT ON TABLE "pears"."IQXNetTagGroup" IS 'Questionaire Groups for IQXWeb' GO