create table CATALOG_RETURNS
(
    CR_RETURNED_DATE_SK      INTEGER,
    CR_RETURNED_TIME_SK      INTEGER,
    CR_ITEM_SK               INTEGER not null,
    CR_REFUNDED_CUSTOMER_SK  INTEGER,
    CR_REFUNDED_CDEMO_SK     INTEGER,
    CR_REFUNDED_HDEMO_SK     INTEGER,
    CR_REFUNDED_ADDR_SK      INTEGER,
    CR_RETURNING_CUSTOMER_SK INTEGER,
    CR_RETURNING_CDEMO_SK    INTEGER,
    CR_RETURNING_HDEMO_SK    INTEGER,
    CR_RETURNING_ADDR_SK     INTEGER,
    CR_CALL_CENTER_SK        INTEGER,
    CR_CATALOG_PAGE_SK       INTEGER,
    CR_SHIP_MODE_SK          INTEGER,
    CR_WAREHOUSE_SK          INTEGER,
    CR_REASON_SK             INTEGER,
    CR_ORDER_NUMBER          INTEGER not null,
    CR_RETURN_QUANTITY       INTEGER,
    CR_RETURN_AMOUNT         NUMERIC(7, 2),
    CR_RETURN_TAX            NUMERIC(7, 2),
    CR_RETURN_AMT_INC_TAX    NUMERIC(7, 2),
    CR_FEE                   NUMERIC(7, 2),
    CR_RETURN_SHIP_COST      NUMERIC(7, 2),
    CR_REFUNDED_CASH         NUMERIC(7, 2),
    CR_REVERSED_CHARGE       NUMERIC(7, 2),
    CR_STORE_CREDIT          NUMERIC(7, 2),
    CR_NET_LOSS              NUMERIC(7, 2),
    constraint CATALOG_RETURNS_PK
        primary key (CR_ITEM_SK, CR_ORDER_NUMBER)
);
