CREATE TABLE irc_ai_gig_filters (
    GIG_FILTER_ID            NUMBER(18, 0),
    LEGAL_EMPLOYER_ID        NUMBER(18, 0),
    JOB_ID                   NUMBER(18, 0),
    BUSINESS_UNIT_ID         NUMBER(18, 0),
    DEPARTMENT_ID            NUMBER(18, 0),
    JOB_GRADE_CODE           VARCHAR2(128),
    LOCATION_ID              NUMBER(18, 0),
    FILTER_TYPE_CODE         VARCHAR2(128),
    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),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    GIG_FILTER_ID            NUMBER(18, 0),
    LEGAL_EMPLOYER_ID        NUMBER(18, 0),
    JOB_ID                   NUMBER(18, 0),
    BUSINESS_UNIT_ID         NUMBER(18, 0),
    DEPARTMENT_ID            NUMBER(18, 0),
    JOB_GRADE_CODE           VARCHAR2(128),
    LOCATION_ID              NUMBER(18, 0),
    FILTER_TYPE_CODE         VARCHAR2(128),
    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),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    CONSTRAINT pk_irc_ai_gig_filters PRIMARY KEY (GIG_FILTER_ID, GIG_FILTER_ID)
);
