Table of Contents



pears.globaldocument

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

Description

List of standard documents for IQXWeb - contracts - terms of engagement - etc.

Columns

Column Type Null Default Comment
globaldocumentID char(20) NOT NULL
description char(50) NOT NULL
IQXNetUserClassID char(20) NULL
AgencyID char(20) NULL
FileExtension char(5) NULL
DocumentTypeID char(20) NULL
PublishToWeb tinyint NULL
Defunct tinyint NULL 0
ExternalFilePath long varchar NULL
WhenEntered date NULL current date

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
DocumentType DocumentTypeID pears.DocumentType (DocumentTypeID) ON DELETE SET NULL
IQXNetUserClass IQXNetUserClassID pears.IQXNetUserClass (IQXNetUserClassID) ON DELETE SET NULL
AgencyDetails AgencyID pears.agencydetails (agencyid) ON DELETE SET NULL

Referenced By

Table Constraint Columns Referenced columns
pears.GlobalDocumentLink GlobalDocument GlobalDocumentID globaldocumentID
pears.NotificationDocuments GlobalDocument GlobalDocumentID globaldocumentID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."globaldocument"
-- Table comment: List of standard documents for IQXWeb - contracts - terms of engagement - etc.
-- Statement count: 5
 
CREATE TABLE "pears"."globaldocument" (
    "globaldocumentID"               CHAR(20) NOT NULL
   ,"description"                    CHAR(50) NOT NULL
   ,"IQXNetUserClassID"              CHAR(20) NULL
   ,"AgencyID"                       CHAR(20) NULL
   ,"FileExtension"                  CHAR(5) NULL
   ,"DocumentTypeID"                 CHAR(20) NULL
   ,"PublishToWeb"                   tinyint NULL
   ,"Defunct"                        tinyint NULL DEFAULT 0
   ,"ExternalFilePath"               long VARCHAR NULL
   ,"WhenEntered"                    DATE NULL DEFAULT CURRENT DATE
   ,PRIMARY KEY ("globaldocumentID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."globaldocument" IS 
	'List of standard documents for IQXWeb - contracts - terms of engagement - etc.'
GO
 
 
ALTER TABLE "pears"."globaldocument"
    ADD FOREIGN KEY "DocumentType" ("DocumentTypeID" ASC)
    REFERENCES "pears"."DocumentType" ("DocumentTypeID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."globaldocument"
    ADD FOREIGN KEY "IQXNetUserClass" ("IQXNetUserClassID" ASC)
    REFERENCES "pears"."IQXNetUserClass" ("IQXNetUserClassID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."globaldocument"
    ADD FOREIGN KEY "AgencyDetails" ("AgencyID" ASC)
    REFERENCES "pears"."agencydetails" ("agencyid")
    ON DELETE SET NULL
GO