create table DT532 (
    "UUID" raw(16),
    "ASSIGNMENT_ID_ID" number(10,0),
    "MEMBER_ID" varchar2(20 char),
    "PR_ID" varchar2(18 char),
    "REPORT_ID" varchar2(10 char),
    "CREATED_ON" date,
    "MODIFIED_ON" date,
    "RWDU" number(5,0),
    "CREATED_BY" varchar2(20 char),
    "MODIFIED_BY" varchar2(20 char),
    "OWN_LIC" varchar2(4 char),
    "OPC" varchar2(8 char),
    "OWNER" number(5,0),
    "GROUP" number(5,0),
    "ANY" number(5,0),
    "ROLE" number(10,0),
    "MAX_PER_DAY" number(5,0),
    "WITHOUT_COST_CALC" number(5,0),
    "COMMENT" clob,
    "MOD_ACCESS" number(5,0),
    "WATCHER" number(5,0),
    "NAME_2" number(10,0),
    "ALLOCATOR" number(10,0),
    "CATEGORY" number(10,0),
    "MAIN_EXECUTIVE" number(5,0),
    "TDI_SUB_PROJECT_VIEW" clob
);

alter table DT532 add constraint PID532DT532 primary key ("UUID");

alter table DT532
    add constraint FKDT532ID525
    foreign key ("MEMBER_ID")
    references DT525
    on delete cascade
    deferrable
    novalidate;
alter table DT532 enable validate constraint FKDT532ID525;

alter table DT532
    add constraint FKDT532ID461
    foreign key ("PR_ID")
    references DT461
    on delete cascade
    deferrable
    novalidate;
alter table DT532 enable validate constraint FKDT532ID461;

alter table DT532
    add constraint FKDT532ID823
    foreign key ("PR_ID", "REPORT_ID")
    references DT823
    on delete cascade
    deferrable
    novalidate;
alter table DT532 enable validate constraint FKDT532ID823;

create index IDX_ITEXT_DT532ROLE on DT532 ("ROLE");

create index IDX_ITEXT_DT532NAME_2 on DT532 ("NAME_2");

create index IDX_DT532ID525 on DT532 ("MEMBER_ID");

create index IDX_DT532ID461 on DT532 ("PR_ID");

create index IDX_DT532ID823 on DT532 ("PR_ID", "REPORT_ID");

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

alter table DT532
    add constraint DT532UUID_NOT_NULL check("UUID" is not null);

alter table DT532 MODIFY ("ASSIGNMENT_ID_ID" DEFAULT 0);

alter table DT532
    add constraint DT532ASSIGNMENT_ID_ID_NOT_NULL check("ASSIGNMENT_ID_ID" is not null);

alter table DT532
    add constraint DT532MEMBER_ID_NOT_NULL check("MEMBER_ID" is not null);

alter table DT532
    add constraint DT532REPORT_ID_NOT_NULL check("REPORT_ID" is not null);

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

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

alter table DT532 MODIFY ("RWDU" DEFAULT 0);

alter table DT532 MODIFY ("OWNER" DEFAULT 0);

alter table DT532 MODIFY ("GROUP" DEFAULT 0);

alter table DT532 MODIFY ("ANY" DEFAULT 0);

alter table DT532 MODIFY ("MAX_PER_DAY" DEFAULT 0);

alter table DT532 MODIFY ("WITHOUT_COST_CALC" DEFAULT 0);

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

alter table DT532 MODIFY ("WATCHER" DEFAULT 0);

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

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

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