pears.globaldocument

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

• globaldocumentID

• No indexes found.

• No triggers found.

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