Table of Contents



pears.DocumentPack

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

Description

Master records for the defined Document Packs.

Columns

Column Type Null Default Comment
DocumentPackID char(20) NOT NULL
Description char(100) NOT NULL
ReportID char(20) NULL
Sortorder smallint NULL
Defunct smallint NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
Report ReportID pears.report (reportid) ON DELETE SET NULL

Referenced By

Table Constraint Columns Referenced columns
pears.DocPackValidation DocumentPack DocumentPackID DocumentPackID
pears.DocumentPackDepartment DocumentPack DocumentPackID DocumentPackID
pears.DocumentPackReport DocumentPack DocumentPackID DocumentPackID
pears.DocumentPackType DocumentPack DocumentPackID DocumentPackID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DocumentPack"
-- Table comment: Master records for the defined Document Packs.
-- Statement count: 3
 
CREATE TABLE "pears"."DocumentPack" (
    "DocumentPackID"                 CHAR(20) NOT NULL
   ,"Description"                    CHAR(100) NOT NULL
   ,"ReportID"                       CHAR(20) NULL
   ,"Sortorder"                      SMALLINT NULL
   ,"Defunct"                        SMALLINT NULL
   ,PRIMARY KEY ("DocumentPackID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."DocumentPack" IS 
	'Master records for the defined Document Packs.'
GO
 
 
ALTER TABLE "pears"."DocumentPack"
    ADD FOREIGN KEY "Report" ("ReportID" ASC)
    REFERENCES "pears"."report" ("reportid")
    ON DELETE SET NULL
GO