pears.BlobStoreDeleteQueue

External Blob files awaiting deletion

• BlobStoreDeleteQueueID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BlobStoreDeleteQueue"
-- Table comment: External Blob files awaiting deletion
-- Statement count: 2
 
CREATE TABLE "pears"."BlobStoreDeleteQueue" (
    "BlobStoreDeleteQueueID"         BIGINT NOT NULL DEFAULT autoincrement
   ,"Class"                          CHAR(1) NOT NULL
   ,"ID"                             CHAR(20) NOT NULL
   ,"WhoDeleted"                     CHAR(20) NULL
   ,"WhenMarkedForDeletion"          TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP
   ,"WhenDeleted"                    TIMESTAMP NULL
   ,"ExternalFilePath"               CHAR(250) NOT NULL
   ,PRIMARY KEY ("BlobStoreDeleteQueueID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."BlobStoreDeleteQueue" IS 
	'External Blob files awaiting deletion'
GO