pears.IQXNetTagGroupMember

The Questions that go into the above groups

• IQXNetTagGroupID, TagLocation, TagID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetTagGroupMember"
-- Table comment: The Questions that go into the above groups
-- Statement count: 7
 
CREATE TABLE "pears"."IQXNetTagGroupMember" (
    "IQXNetTagGroupID"               CHAR(20) NOT NULL
   ,"TagLocation"                    CHAR(3) NOT NULL
   ,"TagID"                          CHAR(3) NOT NULL
   ,"SortOrder"                      INTEGER NULL
   ,"Description"                    CHAR(100) NULL
   ,"Required"                       SMALLINT NULL
   ,"ReadOnly"                       SMALLINT NULL
   ,PRIMARY KEY ("IQXNetTagGroupID" ASC,"TagLocation" ASC,"TagID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetTagGroupMember"."Description" IS 
	'Null indicates use tag description'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetTagGroupMember"."Required" IS 
	'Null indicates take default from tag table'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetTagGroupMember"."ReadOnly" IS 
	'Allows readonly fields mixed with editable in a tag group'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetTagGroupMember" IS 
	'The Questions that go into the above groups'
GO
 
 
ALTER TABLE "pears"."IQXNetTagGroupMember"
    ADD NOT NULL FOREIGN KEY "IQXNetTagGroup" ("IQXNetTagGroupID" ASC)
    REFERENCES "pears"."IQXNetTagGroup" ("IQXNetTagGroupID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."IQXNetTagGroupMember"
    ADD NOT NULL FOREIGN KEY "tag" ("TagLocation" ASC,"TagID" ASC)
    REFERENCES "pears"."tag" ("taglocation","tagid")
    ON DELETE CASCADE
GO