pears.agencydetails

Branch details. A branch usually represents a physical location.

• agencyid

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."agencydetails"
-- Table comment: Branch details. A branch usually represents a physical location.
-- Statement count: 9
 
CREATE TABLE "pears"."agencydetails" (
    "agencyid"                       CHAR(20) NOT NULL
   ,"name"                           CHAR(30) NULL
   ,"defaultreportdirectory"         CHAR(100) NULL
   ,"wpdocdirectory"                 CHAR(100) NULL
   ,"currency"                       CHAR(3) NULL
   ,"AddressEtc1"                    long VARCHAR NULL
   ,"AddressEtc2"                    long VARCHAR NULL
   ,"AddressEtc3"                    long VARCHAR NULL
   ,"AddressEtc4"                    long VARCHAR NULL
   ,"AddressEtc5"                    long VARCHAR NULL
   ,"AddressEtc6"                    long VARCHAR NULL
   ,"Analysis"                       CHAR(50) NULL
   ,"divisionid"                     CHAR(20) NULL
   ,"docstoragefolder"               CHAR(100) NULL
   ,"SMTPServer"                     CHAR(20) NULL
   ,"IMAPServer"                     CHAR(20) NULL
   ,"Extra1"                         long VARCHAR NULL
   ,"Extra2"                         long VARCHAR NULL
   ,"Extra3"                         long VARCHAR NULL
   ,"IQXNetEmailDetailsID"           CHAR(20) NULL
   ,PRIMARY KEY ("agencyid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."agencydetails" IS 
	'Branch details. A branch usually represents a physical location.'
GO
 
 
-------------------------------------------------
--   Create foreign keys
-------------------------------------------------
 
ALTER TABLE "pears"."agencydetails"
    ADD FOREIGN KEY "division" ("divisionid" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."agencydetails"
    ADD FOREIGN KEY "SMTPServer" ("SMTPServer" ASC)
    REFERENCES "pears"."MailServer" ("MailServerID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."agencydetails"
    ADD FOREIGN KEY "IMAPServer" ("IMAPServer" ASC)
    REFERENCES "pears"."MailServer" ("MailServerID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."agencydetails"
    ADD FOREIGN KEY "IQXNetEmailDetails" ("IQXNetEmailDetailsID" ASC)
    REFERENCES "pears"."IQXNetEmailDetails" ("IQXNetEmailDetailsID")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "agencydetails_name" ON "pears"."agencydetails"
    ( "name" )
GO
 
 
CREATE TRIGGER "WPK_agencydetails_BRANCH" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."agencydetails"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('P','BRANCH')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."agencydetails"."WPK_agencydetails_BRANCH" IS 
{CREATE TRIGGER WPK_agencydetails_BRANCH 
 after INSERT,DELETE,UPDATE ORDER 1 ON
agencydetails
FOR each statement
BEGIN
  CALL WPKTrackChange('P','BRANCH')
END
}
GO