pears.MasterRosterChangeReason

Look-up of allowed change reasons for Master Rosters.

• MasterRosterChangeReasonID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."MasterRosterChangeReason"
-- Table comment: Look-up of allowed change reasons for Master Rosters.
-- Statement count: 4
 
CREATE TABLE "pears"."MasterRosterChangeReason" (
    "MasterRosterChangeReasonID"     CHAR(20) NOT NULL
   ,"Reason"                         CHAR(30) NOT NULL
   ,"SortOrder"                      SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("MasterRosterChangeReasonID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."MasterRosterChangeReason" IS 
	'Look-up of allowed change reasons for Master Rosters.'
GO
 
 
CREATE TRIGGER "WPK_masterrosterchangereason_MASTERROSTERREASON" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."masterrosterchangereason"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('P','MASTERROSTERREASON')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."MasterRosterChangeReason"."WPK_masterrosterchangereason_MASTERROSTERREASON" IS 
{CREATE TRIGGER WPK_masterrosterchangereason_MASTERROSTERREASON 
 after INSERT,DELETE,UPDATE ORDER 1 ON
masterrosterchangereason
FOR each statement
BEGIN
  CALL WPKTrackChange('P','MASTERROSTERREASON')
END
}
GO