CREATE TABLE atc_pop_poprelationships (
    POPRELATIONSHIP_ID         NUMBER(18, 0) ,
    POPRELATIONSHIP_PUID       VARCHAR2(120)     NOT NULL,
    POPRELATIONSHIP_NAME       VARCHAR2(800) ,
    POPRELATIONSHIP_HREF       VARCHAR2(4000),
    POPRELATIONSHIP_VERSION    VARCHAR2(80)  ,
    REUSABLE_TYPE_FLAG         VARCHAR2(4)   ,
    REL_TYPE_CODE              VARCHAR2(800) ,
    POP_RELATIONSHIP_ROLE      VARCHAR2(800) ,
    ENTITY_NAME                VARCHAR2(400)     NOT NULL,
    AT_TYPE                    VARCHAR2(800) ,
    AT_BASE_TYPE               VARCHAR2(800) ,
    AT_REFERRED_TYPE           VARCHAR2(800) ,
    AT_SCHEMA_LOCATION         VARCHAR2(4000),
    VERSION_STATE              NUMBER(2, 0)  ,
    PROD_OFFER_PRICE_ID        NUMBER(18, 0)     NOT NULL,
    DISCOUNT_MODE_CODE         VARCHAR2(120) ,
    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,
    POPRELATIONSHIP_ID         NUMBER(18, 0) ,
    POPRELATIONSHIP_PUID       VARCHAR2(120)     NOT NULL,
    POPRELATIONSHIP_NAME       VARCHAR2(800) ,
    POPRELATIONSHIP_HREF       VARCHAR2(4000),
    REL_TYPE_CODE              VARCHAR2(800) ,
    AT_TYPE                    VARCHAR2(800) ,
    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,
    POPRELATIONSHIP_VERSION    VARCHAR2(80)  ,
    AT_BASE_TYPE               VARCHAR2(800) ,
    AT_SCHEMA_LOCATION         VARCHAR2(4000),
    PROD_OFFER_PRICE_ID        NUMBER(18, 0)     NOT NULL,
    ENTITY_NAME                VARCHAR2(400)     NOT NULL,
    REUSABLE_TYPE_FLAG         VARCHAR2(4)   ,
    VERSION_STATE              NUMBER(2, 0)  ,
    POP_RELATIONSHIP_ROLE      VARCHAR2(800) ,
    AT_REFERRED_TYPE           VARCHAR2(800) ,
    DISCOUNT_MODE_CODE         VARCHAR2(120) ,
    CONSTRAINT pk_atc_pop_poprelationships PRIMARY KEY (POPRELATIONSHIP_ID, POPRELATIONSHIP_ID)
);
