NCS

 table DEP_NCS_DOMAIN 
 table DEP_NCS_REFINE_REST    
 table DEP_GEN_NCS_ENS  
 table DEP_NCS_DOM_LIMIT   
 table DEP_NCS_ENS   
 table DEP_NCS_MATRIX   
 table DEP_NCS_DOM_LIMIT



create table DEP_NCS_DOMAIN   (
             CIF_ID        varchar2(255) not null,
             DND_ID        number(10,0)  not null,
             DA_DA_ID      number(10,0)  not null,
             DETAILS       varchar2(240)     null
)   ;

create table DEP_NCS_REFINE_REST      (
             DNRR_ID          number(10,0) not null,
             DND_DND_ID       number(10,0) not null,
             DXR_DXR_ID       number(10,0) not null,
             WGHT_XYZ         number(8,0)      null,
             WGHT_B_ISO       number(8,0)      null,
             RMS_B_ISO        number(8,0)      null,
             RMS_XYZ          number(8,0)      null,
             DETAILS          varchar2(240)    null
)   ;

create table DEP_GEN_NCS_ENS    (
             DGNE_ID            number(10,0) not null,
             DNE2_DNE2_ID       number(10,0) not null,
             DND_DND_ID         number(10,0) not null,
             DNM1_DNM1_ID       number(10,0) not null,
             DND_DND_ID_CP671   number(10,0) not null
)   ;

create table DEP_NCS_DOM_LIMIT     (
             DNDL_ID            number(10,0) not null,
             DND_DND_ID         number(10,0) not null,
             DEIC_DEIC_ID       number(10,0) not null,
             DEIC_DEIC_ID_ID    number(10,0) not null
)   ;

create table DEP_NCS_ENS     (
             DNE2_ID           number(10,0)  not null,
             DEP_DEP_ID         number(10,0)  not null,
             POINT_GROUP       varchar2(80)      null,
             DETAILS           varchar2(240)     null
)   ;

create table DEP_NCS_MATRIX     (
             DNM1_ID      number(10,0)  not null,
             DEP_DEP_ID    number(10,0)  not null,
             VEC_1        number(8,0)   not null,
             VEC_2        number(8,0)   not null,
             VEC_3        number(8,0)   not null,
             MAT_11       number(8,0)   not null,
             MAT_12       number(8,0)   not null,
             MAT_13       number(8,0)   not null,
             MAT_21       number(8,0)   not null,
             MAT_22       number(8,0)   not null,
             MAT_23       number(8,0)   not null,
             MAT_31       number(8,0)   not null,
             MAT_32       number(8,0)   not null,
             MAT_33       number(8,0)   not null,
             CODE_TYPE    varchar2(80)      null,
             DETAILS      varchar2(80)      null
)   ;

create table DEP_NCS_DOM_LIMIT  (
             DNDL_ID          number(10,0) not null,
             DND_DND_ID       number(10,0) not null,
             DEIC_DEIC_ID     number(10,0) not null,
             DEIC_DEIC_ID_ID  number(10,0) not null
) ;



alter table DEP_NCS_DOMAIN
 add (constraint DND_PK primary key   (DND_ID))
alter table DEP_NCS_DOMAIN 
 add constraint DND_DA_FK foreign key   (DA_DA_ID) 
     references DEP_ASSEMBLY  (DA_ID) on delete cascade


alter table DEP_NCS_REFINE_REST
 add (constraint DNRR_PK primary key   (DNRR_ID))
alter table DEP_NCS_REFINE_REST 
 add constraint DNRR_DXR_FK foreign key   (DXR_DXR_ID) 
     references DEP_XRAY_REFINEMENT  (DXR_ID) on delete cascade 
 add constraint DNRR_DND_FK foreign key   (DND_DND_ID) 
     references DEP_NCS_DOMAIN  (DND_ID) on delete cascade

alter table DEP_GEN_NCS_ENS
 add (constraint DGNE_PK primary key   (DGNE_ID))
alter table DEP_GEN_NCS_ENS 
 add constraint DGNE_DND_CP671_FK foreign key   (DND_DND_ID_CP671) 
     references DEP_NCS_DOMAIN  (DND_ID) on delete cascade 
 add constraint DGNE_DNE2_FK foreign key   (DNE2_DNE2_ID) 
     references DEP_NCS_ENS  (DNE2_ID) on delete cascade 
 add constraint DGNE_DND_FK foreign key   (DND_DND_ID) 
     references DEP_NCS_DOMAIN  (DND_ID) on delete cascade 
 add constraint DGNE_DNM1_FK foreign key   (DNM1_DNM1_ID) 
     references DEP_NCS_MATRIX  (DNM1_ID) on delete cascade


alter table DEP_NCS_ENS
 add (constraint DNE2_PK primary key   (DNE2_ID))
alter table DEP_NCS_ENS 
 add constraint DNE2_DEP_FK foreign key   (DEP_DEP_ID ) 
     references DEPOSITION  (DEP_ID ) on delete cascade


alter table DEP_NCS_MATRIX
 add (constraint DNM1_PK primary key   (DNM1_ID))
alter table DEP_NCS_MATRIX 
 add constraint DNM1_DEP_FK foreign key   (DEP_DEP_ID ) 
     references DEPOSITION  (DEP_ID ) on delete cascade

alter table DEP_NCS_DOM_LIMIT
 add (constraint DNDL_PK primary key   (DNDL_ID))
alter table DEP_NCS_DOM_LIMIT 
 add constraint DNDL_DEIC_FK foreign key   (DEIC_DEIC_ID) 
     references DEP_ENTITY_INST_CMPNT  (DEIC_ID) on delete cascade 
 add constraint DNDL_DEIC_ID_FK foreign key   (DEIC_DEIC_ID_ID) 
     references DEP_ENTITY_INST_CMPNT  (DEIC_ID) on delete cascade 
 add constraint DNDL_DND_FK foreign key   (DND_DND_ID) 
     references DEP_NCS_DOMAIN  (DND_ID) on delete cascade