Table of Contents



pears.DocumentType

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

Description

Classification of Documents (including definition of Compliance & Non-Compliance Documents).

Columns

Column Type Null Default Comment
DocumentTypeID char(20) NOT NULL
Description char(50) NULL
Class char(1) NULL
SortOrder integer NULL
CanLoadFromWeb smallint NULL
NotifyStaffOfWebUploads smallint NULL
CanCVSendOut smallint NULL
Defunct smallint NULL
IsCompliance smallint NULL
IsRestricted smallint NULL
CanSign smallint NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.CompanyDeptDocType documenttype documenttypeid DocumentTypeID
pears.ComplianceDocumentType DocumentType DocumentTypeID DocumentTypeID
pears.DeletedDocumentTag DocumentType DocumentTypeID DocumentTypeID
pears.DocPackValidation DocumentType DocumentTypeID DocumentTypeID
pears.DocumentPackType DocumentType DocumentTypeID DocumentTypeID
pears.DocumentTag DocumentType DocumentTypeID DocumentTypeID
pears.DocumentTypeDepartment DocumentType DocumentTypeID DocumentTypeID
pears.globaldocument DocumentType DocumentTypeID DocumentTypeID
pears.NotificationDocuments DocumentType DocumentTypeid DocumentTypeID
pears.NotificationReports Documenttype DocumentTypeID DocumentTypeID
pears.oledocument DocumentType DocumentTypeID DocumentTypeID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DocumentType"
-- Table comment: Classification of Documents (including definition of Compliance & Non-Compliance Documents).
-- Statement count: 2
 
CREATE TABLE "pears"."DocumentType" (
    "DocumentTypeID"                 CHAR(20) NOT NULL
   ,"Description"                    CHAR(50) NULL
   ,"Class"                          CHAR(1) NULL
   ,"SortOrder"                      INTEGER NULL
   ,"CanLoadFromWeb"                 SMALLINT NULL
   ,"NotifyStaffOfWebUploads"        SMALLINT NULL
   ,"CanCVSendOut"                   SMALLINT NULL
   ,"Defunct"                        SMALLINT NULL
   ,"IsCompliance"                   SMALLINT NULL
   ,"IsRestricted"                   SMALLINT NULL
   ,"CanSign"                        SMALLINT NULL
   ,PRIMARY KEY ("DocumentTypeID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."DocumentType" IS 
	'Classification of Documents (including definition of Compliance & Non-Compliance Documents).'
GO