CREATE TABLE gtg_usr_result_summary (
    CONTROL_ID           NUMBER(18, 0),
    USER_GUID            VARCHAR2(256),
    RESULT_COUNT         NUMBER(18, 0)    NOT NULL,
    IS_INVESTIGATOR      VARCHAR2(80)     NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    CONTROL_ID           NUMBER(18, 0),
    USER_GUID            VARCHAR2(256),
    RESULT_COUNT         NUMBER(18, 0)    NOT NULL,
    IS_INVESTIGATOR      VARCHAR2(80)     NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    CONSTRAINT pk_gtg_usr_result_summary PRIMARY KEY (CONTROL_ID, USER_GUID, CONTROL_ID, USER_GUID)
);
