
    create table STAKEHOLDERPORTFOLIO (
        "UUID" raw(16),
        "ASSIGNMENT_ID" number(10,0),
        "MEMBER_ID" varchar2(20 char),
        "PORTFOLIO_ID" varchar2(18 char),
        "OS_CREATED_ON" date,
        "OS_MODIFIED_ON" date,
        "OS_RWDU" number(5,0),
        "OS_CREATED_BY" varchar2(20 char),
        "OS_MODIFIED_BY" varchar2(20 char),
        "OS_LICENSE" varchar2(4 char),
        "OS_OPC" varchar2(8 char),
        "OS_OWNER" number(5,0),
        "OS_GROUP" number(5,0),
        "OS_ANY" number(5,0),
        "ROLE" number(10,0),
        "COMMENT" clob,
        "MOD_ACCESS" number(5,0),
        "ALLOCATOR" number(10,0),
        "CATEGORY" number(10,0),
        "MAIN_EXECUTIVE" number(5,0)
    );

    alter table STAKEHOLDERPORTFOLIO add constraint PID533DT533 primary key ("ASSIGNMENT_ID");

    alter table STAKEHOLDERPORTFOLIO
        add constraint FKSTAKEHOLDERPORTFOLIOID870
        foreign key ("PORTFOLIO_ID")
        references DT870
        on delete cascade
        deferrable
        novalidate;

    alter table STAKEHOLDERPORTFOLIO enable validate constraint FKSTAKEHOLDERPORTFOLIOID870;

    alter table STAKEHOLDERPORTFOLIO
        add constraint FKSTAKEHOLDERPORTFOLIOID525
        foreign key ("MEMBER_ID")
        references DT525
        on delete cascade
        deferrable
        novalidate;

    alter table STAKEHOLDERPORTFOLIO enable validate constraint FKSTAKEHOLDERPORTFOLIOID525;

    create index IDX_ITEXT_DT533ROLE on STAKEHOLDERPORTFOLIO ("ROLE");

    create index IDX_STAKEHOLDERPORTFOLIOID870 on STAKEHOLDERPORTFOLIO ("PORTFOLIO_ID");

    create index IDX_STAKEHOLDERPORTFOLIOID525 on STAKEHOLDERPORTFOLIO ("MEMBER_ID");

    alter table STAKEHOLDERPORTFOLIO
        add constraint UUID_UNIQUE_533  unique ("UUID")
        deferrable;

    alter table STAKEHOLDERPORTFOLIO MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table STAKEHOLDERPORTFOLIO
        add constraint DT533UUID_NOT_NULL check("UUID" is not null);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("ASSIGNMENT_ID" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO
        add constraint DT533ASSIGNMENT_ID_NOT_NULL check("ASSIGNMENT_ID" is not null);

    alter table STAKEHOLDERPORTFOLIO
        add constraint DT533MEMBER_ID_NOT_NULL check("MEMBER_ID" is not null);

    alter table STAKEHOLDERPORTFOLIO
        add constraint DT533PORTFOLIO_ID_NOT_NULL check("PORTFOLIO_ID" is not null);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("OS_CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table STAKEHOLDERPORTFOLIO MODIFY ("OS_MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table STAKEHOLDERPORTFOLIO MODIFY ("OS_RWDU" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("OS_OWNER" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("OS_GROUP" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("OS_ANY" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("MOD_ACCESS" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("ALLOCATOR" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("CATEGORY" DEFAULT 0);

    alter table STAKEHOLDERPORTFOLIO MODIFY ("MAIN_EXECUTIVE" DEFAULT 0);
