CREATE TABLE msc_bm_item_resources (
    ORGANIZATION_ID      NUMBER       ,
    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),
    INVENTORY_ITEM_ID    NUMBER       ,
    RESOURCE_ID          NUMBER       ,
    DEPARTMENT_ID        NUMBER       ,
    ORGANIZATION_ID      NUMBER       ,
    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),
    INVENTORY_ITEM_ID    NUMBER       ,
    RESOURCE_ID          NUMBER       ,
    DEPARTMENT_ID        NUMBER       ,
    CONSTRAINT pk_msc_bm_item_resources PRIMARY KEY (ORGANIZATION_ID, INVENTORY_ITEM_ID, RESOURCE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, RESOURCE_ID)
);
