Table of Contents



pears.DocumentPackType

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

Description

Lists types of Document available in a given pack by default.

Columns

Column Type Null Default Comment
DocumentPackTypeID char(20) NOT NULL
DocumentPackID char(20) NULL
DocumentTypeID char(20) NULL
Redacted smallint NULL
Sortorder smallint NULL
Required smallint NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
DocumentPack DocumentPackID pears.DocumentPack (DocumentPackID) ON DELETE CASCADE
DocumentType DocumentTypeID pears.DocumentType (DocumentTypeID) ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DocumentPackType"
-- Table comment: Lists types of Document available in a given pack by default.
-- Statement count: 4
 
CREATE TABLE "pears"."DocumentPackType" (
    "DocumentPackTypeID"             CHAR(20) NOT NULL
   ,"DocumentPackID"                 CHAR(20) NULL
   ,"DocumentTypeID"                 CHAR(20) NULL
   ,"Redacted"                       SMALLINT NULL
   ,"Sortorder"                      SMALLINT NULL
   ,"Required"                       SMALLINT NULL
   ,PRIMARY KEY ("DocumentPackTypeID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."DocumentPackType" IS 
	'Lists types of Document available in a given pack by default.'
GO
 
 
ALTER TABLE "pears"."DocumentPackType"
    ADD FOREIGN KEY "DocumentPack" ("DocumentPackID" ASC)
    REFERENCES "pears"."DocumentPack" ("DocumentPackID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."DocumentPackType"
    ADD FOREIGN KEY "DocumentType" ("DocumentTypeID" ASC)
    REFERENCES "pears"."DocumentType" ("DocumentTypeID")
    ON DELETE CASCADE
GO