pears.DataManagementLog

GDPR - Records which records have been anonomised for GDPR - and what actions happened. Data cannot be recovered from here.

• DMLogID

• 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"."DataManagementLog"
-- Table comment: GDPR - Records which records have been anonomised for GDPR - and what actions happened.  Data cannot be recovered from here.
-- Statement count: 4
 
CREATE TABLE "pears"."DataManagementLog" (
    "DMLogID"                        CHAR(20) NOT NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"Name"                           CHAR(30) NULL
   ,"Appnumber"                      CHAR(12) NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"WhoEntered"                     CHAR(20) NULL
   ,"Action"                         CHAR(20) NULL
   ,"OtherDetail"                    long VARCHAR NULL
   ,"Outcome"                        long VARCHAR NULL
   ,"OutcomeDetail"                  long VARCHAR NULL
   ,PRIMARY KEY ("DMLogID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."DataManagementLog"."Action" IS 
	'View, Email, Print, Delete, Other'
GO
 
 
COMMENT ON COLUMN "pears"."DataManagementLog"."Outcome" IS 
	'Success or Fail'
GO
 
 
COMMENT ON TABLE "pears"."DataManagementLog" IS 
	'GDPR - Records which records have been anonomised for GDPR - and what actions happened.  Data cannot be recovered from here.'
GO