pears.TrengoMessage

• TrengoMessageID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TrengoMessage"
-- Table comment: 
-- Statement count: 2
 
CREATE TABLE "pears"."TrengoMessage" (
    "TrengoMessageID"                CHAR(20) NOT NULL
   ,"Ticket"                         CHAR(20) NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"MessageText"                    long VARCHAR NULL
   ,"Created_At"                     TIMESTAMP NULL
   ,"MessageJson"                    long VARCHAR NULL
   ,"Messagetype"                    CHAR(20) NULL
   ,"WhenReceived"                   TIMESTAMP NULL
   ,"ID"                             CHAR(20) NULL
   ,PRIMARY KEY ("TrengoMessageID" ASC) 
)
GO
 
 
ALTER TABLE "pears"."TrengoMessage"
    ADD FOREIGN KEY "Person" ("PersonID" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE SET NULL
GO