CREATE TABLE irc_service_scan_status (
    SCAN_TYPE            VARCHAR2(120),
    SCAN_NAME            VARCHAR2(400),
    SCAN_STATUS          VARCHAR2(80)     NOT NULL,
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    SCAN_TYPE            VARCHAR2(120),
    SCAN_NAME            VARCHAR2(400),
    SCAN_STATUS          VARCHAR2(80)     NOT NULL,
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    CONSTRAINT pk_irc_service_scan_status PRIMARY KEY (SCAN_TYPE, SCAN_NAME, SCAN_TYPE, SCAN_NAME)
);
