CREATE TABLE FEE
(
  USER_FEE_ID                   NUMBER          NOT NULL,
  USER_ID                       NUMBER          NOT NULL,
  FEE_PLAN_ID                   NUMBER          NOT NULL,
  USER_FEE_STATUS_ID            NUMBER          NOT NULL,
  EFFECTIVE_DT                  DATE            NOT NULL,
  EXPIRATION_DT                 DATE            NOT NULL,
  CREATE_DATETIME               DATE            DEFAULT sysdate               NOT NULL,
  MODIFY_DATETIME               DATE            DEFAULT sysdate               NOT NULL,
  SYSTEM_MODIFY_USER            NUMBER          NOT NULL,
  SCHEMA_MODIFY_USER            NUMBER          DEFAULT uid                   NOT NULL,
  EXPIRY_USER_FEE_ID            NUMBER,
  PREVIOUS_FEE_CATALOG_ITEM_ID  NUMBER,
  SUPPLEMENTAL LOG GROUP GGS_FEE_145605 (USER_FEE_ID) ALWAYS
)

CREATE INDEX FEE_ESUF_IDX ON FEE
(EXPIRATION_DT, USER_FEE_STATUS_ID, USER_FEE_ID)

CREATE UNIQUE INDEX FEE_PK ON FEE
(USER_FEE_ID)

CREATE INDEX FEE_USERID_X ON FEE
(USER_ID)

ALTER TABLE FEE ADD (
  CONSTRAINT FEE_EXPDT_CK
  CHECK (expiration_dt >= effective_dt)
  ENABLE VALIDATE,
  CONSTRAINT FEE_PK
  PRIMARY KEY
  (USER_FEE_ID)
  USING INDEX FEE_PK
  ENABLE VALIDATE)

ALTER TABLE FEE ADD (
  FOREIGN KEY (EXPIRY_USER_FEE_ID) 
  REFERENCES FEE (USER_FEE_ID)
  ENABLE NOVALIDATE)

CREATE TABLE CART_ITEM_FEE
(
  CART_ITEM_FEE_ID    NUMBER                    NOT NULL,
  CART_ITEM_ID        NUMBER                    NOT NULL,
  USER_FEE_ID         NUMBER                    NOT NULL,
  CREATE_DATETIME     DATE                      DEFAULT SYSDATE               NOT NULL,
  MODIFY_DATETIME     DATE                      DEFAULT SYSDATE               NOT NULL,
  SYSTEM_MODIFY_USER  NUMBER                    DEFAULT 0,
  SUPPLEMENTAL LOG GROUP GGS_CAR_145869 (CART_ITEM_FEE_ID) ALWAYS
)

CREATE INDEX SHAPSP_SPID_X ON CART_ITEM_FEE
(CART_ITEM_ID)

CREATE UNIQUE INDEX CARTITEMFEE_CIFID_X ON CART_ITEM_FEE
(CART_ITEM_ID, USER_FEE_ID)

CREATE UNIQUE INDEX CART_ITEM_FEE_CIFID_PK ON CART_ITEM_FEE
(CART_ITEM_FEE_ID)

ALTER TABLE CART_ITEM_FEE ADD (
  CONSTRAINT CART_ITEM_FEE_CIFID_PK
  PRIMARY KEY
  (CART_ITEM_FEE_ID)
  USING INDEX CART_ITEM_FEE_CIFID_PK
  ENABLE VALIDATE)

ALTER TABLE CART_ITEM_FEE ADD (
  CONSTRAINT CART_ITEM_FEE_UFID_FK 
  FOREIGN KEY (USER_FEE_ID) 
  REFERENCES FEE (USER_FEE_ID)
  ENABLE NOVALIDATE)