Table of Contents



pears.WPKRole

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

Description

Woodpecker Role definitions.

Columns

Column Type Null Default Comment
WPKRoleID char(20) NOT NULL
Name char(50) NOT NULL
Notes long varchar NULL
RoleGroup char(30) NULL
SortOrder smallint NULL
CriteriaGroup smallint NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
RoleMaint Index RoleGroup, SortOrder, Name

Triggers

Name Timing Event
WPKTrackRoleChange after insert,delete,update order 1

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKRole"
-- Table comment: Woodpecker Role definitions.
-- Statement count: 5
 
CREATE TABLE "pears"."WPKRole" (
    "WPKRoleID"                      CHAR(20) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"Notes"                          long VARCHAR NULL
   ,"RoleGroup"                      CHAR(30) NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"CriteriaGroup"                  SMALLINT NULL
   ,PRIMARY KEY ("WPKRoleID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."WPKRole" IS 
	'Woodpecker Role definitions.'
GO
 
 
CREATE INDEX "RoleMaint" ON "pears"."WPKRole"
    ( "RoleGroup","SortOrder","Name" )
GO
 
 
CREATE TRIGGER "WPKTrackRoleChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKRole"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('R','*')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKRole"."WPKTrackRoleChange" IS 
{CREATE TRIGGER WPKTrackRoleChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKRole
FOR each statement
BEGIN
  CALL WPKTrackChange('R','*')
END
}
GO