pears.DocumentType

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

• DocumentTypeID

• No outgoing foreign keys found.

• No indexes found.

• No triggers found.

-- 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