table DEP_DATA_SET table DEP_DFFRN_IMAGE table DEP_DFFRN_MEAS table DEP_EXT_COEF table DEP_ISOMORPHOUS table DEP_MAP_AVGNG table DEP_EXPTL_XTAL
create table DEP_DATA_SET ( ID number(38) not null, DEP_DEP_ID number(10,0) not null, DDS_ID number(10,0) not null, DDS_TYPE varchar2(10) not null, RSG_RSG_ID number(10,0) null, RNDT_RNDT_ID number(10,0) null, NC_NC_ID number(10,0) null, HARVEST_DATASET_NAME varchar2(80) null, Z_PDB number(38) null, FORMULA_UNITS_Z number(38) null, NUM_CRYSTALS number(38) null, B_ISO_WILSON_ESTIMATE number(8,0) null, ANGLE_ALPHA float(27) null, ANGLE_ALPHA_ESD float(27) null, ANGLE_BETA float(27) null, ANGLE_BETA_ESD float(27) null, ANGLE_GAMMA float(27) null, ANGLE_GAMMA_ESD float(27) null, LENGTH_A float(27) null, LENGTH_A_ESD float(27) null, LENGTH_B float(27) null, LENGTH_B_ESD float(27) null, LENGTH_C float(27) null, LENGTH_C_ESD float(27) null, VOLUME float(27) null, VOLUME_ESD float(27) null, CELL_DETAILS varchar2(2000) null, UNIQUE_AXIS varchar2(240) null, DATE_MEASUREMENT varchar2(240) null, DETAILS varchar2(2000) null, FINAL_REFINEMENT char(1) default 'N' null, MERGE_REJECT_CRITERIA varchar2(255) null, OBSERVED_CRITERION varchar2(2000) null, DATA_SET_DETAILS varchar2(240) null, DATA_TEXT varchar2(18) null, DATA_TEXT_FORMAT varchar2(18) null ) ;
create table DEP_DFFRN_IMAGE ( DDS_DDS_ID number(10,0) not null, DDI_ID number(10,0) not null, IMAGE_SERIAL number(38) not null, I_BY_SIG_I_RES_HIGH number(8,0) null, INTENT_R_SYMM_REFLECT number(8,0) null, MEAN_I_OVER_SIGMAI number(8,0) null, NUM_SYMM_RELATED_OBS number(38) null, AGRMNT_SYMM_I_TO_ESD number(8,0) null, RMS_POSIT_RESIDUAL number(8,0) null, WGHT_RMS_POSIT_RESID number(8,0) null ) ;
create table DEP_DFFRN_MEAS ( DDS_DDS_ID number(10,0) not null, DEX_DEX_ID number(10,0) not null, DDM_ID number(10,0) not null, RW_RW_ID number(10,0) not null, RDS_RDS_ID number(10,0) not null, RDMD_RDMD_ID number(10,0) null, RDD_RDD_ID number(10,0) null, RDMT_RDMT_ID number(10,0) null, RDST_RDST_ID number(10,0) null, RDT_RDT_ID number(10,0) null, THETA_MAX number(8,0) null, THETA_MIN number(8,0) null, AMBIENT_TEMP number(8,0) null, AMBIENT_TEMP_ESD number(8,0) null, BEAM_DIVERG_HOR_MEAN number(8,0) null, BEAM_DIVERG_VER_MEAN number(8,0) null, AV_R_EQUIVALENTS number(8,0) null, AV_SIGMAI_OVER_NETI number(8,0) null, AMBIENT_PRESSURE number(8,0) null, AMBIENT_PRESSURE_ESD number(8,0) null, MEAS_D_RES_HIGH number(8,0) null, MEAS_D_RES_LOW number(8,0) null, IMAGES_MOSAICITY_MEAN number(8,0) null, DETECTOR_DISTANCE number(8,0) null, IMAGES_MOSAICITY_MIN number(8,0) null, IMAGES_MOSAICITY_MAX number(8,0) null, REFLNS_NUMBER number(38) null, SOURCE_CURRENT varchar2(240) null, SOURCE_DETAILS varchar2(240) null, SOURCE_POWER varchar2(240) null, SOURCE_SIZE varchar2(240) null, SOURCE_VOLTAGE varchar2(240) null, DATE_COLLECTION varchar2(240) null, MONOCHROMATIC_OR_LAUE varchar2(240) null, PROTOCOL varchar2(240) null, REDUCTION_PROCESS varchar2(80) null, AMBIENT_TEMP_DETAILS varchar2(80) null, CRYSTAL_SUPPORT varchar2(80) null, CRYSTAL_TREATMENT varchar2(80) null, DETAILS varchar2(80) null, MEASU_DETAILS varchar2(80) null, AMBIENT_ENVIRON varchar2(80) null, MEAS_SPECIMEN_SUPPORT varchar2(80) null, MEAS_METHOD varchar2(80) null, DEVICE_DETAILS varchar2(255) null, MEASUREMENT_ID varchar2(255) null ) ;
create table DEP_EXT_COEF ( DDS_DDS_ID number(10,0) not null, DEC1_ID number(10,0) not null, EXT_COEF number(8,0) not null, EXT_METHOD varchar2(1000) null, EXT_COEF_ESD number(8,0) null, EXT_EXPRESSION varchar2(1000) null ) ;
create table DEP_ISOMORPHOUS ( DI_ID number(10,0) not null, DDS_DDS_ID number(10,0) not null, DETAILS varchar2(1000) null, METHOD varchar2(80) null ) ;
create table DEP_MAP_AVGNG ( DMA_ID number(10,0) not null, DDS_DDS_ID number(10,0) not null, DETAILS varchar2(1000) null, METHOD varchar2(80) null ) ;
create table DEP_EXPTL_XTAL ( CRYSTAL_ID varchar2(255) not null, DEP_DEP_ID number(10,0) not null, DEX_ID number(10,0) not null, RXGM_RXGM_ID number(10,0) null, RSM_RSM_ID number(10,0) null, F_000 number(38) null, SIZE_MAX float(27) null, SIZE_MID float(27) null, SIZE_MIN float(27) null, SIZE_RAD float(27) null, DENSITY_MEAS float(27) null, DENSITY_MEAS_TEMP float(27) null, DENSITY_METHOD float(27) null, DENSITY_PERCENT_SOL float(27) null, GROW_PRESSURE float(27) null, GROW_PRESSURE_ESD float(27) null, GROW_TEMP_ESD float(27) null, GROW_TIME float(27) null, DENSITY_MATTHEWS float(27) null, DENSITY_DIFFRN float(27) null, GROW_TEMP float(27) null, GROW_PH float(27) null, GROW_TEMP_DETAILS varchar2(700) null, GROW_DETAILS varchar2(700) null, GROW_APPARATUS varchar2(700) null, GROW_ATMOSPHERE varchar2(700) null, BMCD_CRYSTAL_IMAGE varchar2(240) null, BMCD_X_RAY_IMAGE varchar2(240) null, BMCD_X_RAY_IMAGE_TYPE varchar2(240) null, BMCD_CRYSTAL_DIFFRN_LIMIT varchar2(240) null, BMCD_CRYSTAL_DIFFRN_LIFETIME varchar2(240) null, BMCD_CRYSTAL_DIRECTION_1 varchar2(240) null, BMCD_CRYSTAL_DIRECTION_2 varchar2(240) null, BMCD_CRYSTAL_DIRECTION_3 varchar2(240) null, COLOUR varchar2(255) null, PREPARATION varchar2(2000) null, DESCRIPTION varchar2(2000) null ) ;
alter table DEP_DATA_SET add (constraint DDS_PK primary key (DDS_ID)) alter table DEP_DATA_SET add ( constraint DDS_DDS1_UK unique (DEP_DEP_ID ,ID)) alter table DEP_DATA_SET add (constraint AVCON_1611748_FINAL_000 check (FINAL_REFINEMENT IN ('Y', 'N'))) add (constraint AVCON_1611748_DDS_T_000 check (DDS_TYPE IN ('DXD', 'NDS'))) alter table DEP_DATA_SET add constraint DDS_RSG_FK foreign key (RSG_RSG_ID) references REF_SPACE_GROUP (RSG_ID) on delete cascade add constraint DDS_RNDT_FK foreign key (RNDT_RNDT_ID) references REF_NMR_DATA_TYPE (RNDT_ID) on delete cascade add constraint DDS_NC_FK foreign key (NC_NC_ID) references NMR_CONDITION (NC_ID) on delete cascade add constraint DDS_DEP_FK foreign key (DEP_DEP_ID) references DEPOSITION (DEP_ID) on delete cascade alter table DEP_DFFRN_IMAGE add (constraint DDI_PK primary key (DDI_ID)) alter table DEP_DFFRN_IMAGE add ( constraint DDI_DDI1_UK unique (DDS_DDS_ID ,IMAGE_SERIAL)) alter table DEP_DFFRN_IMAGE add constraint DDI_DDS_FK foreign key (DDS_DDS_ID) references DEP_DATA_SET (DDS_ID) on delete cascade alter table DEP_EXT_COEF add (constraint DEC1_PK primary key (DEC1_ID)) alter table DEP_EXT_COEF add ( constraint DEC1_DEC11_UK unique (DDS_DDS_ID)) alter table DEP_EXT_COEF add constraint DEC1_DDS_FK foreign key (DDS_DDS_ID) references DEP_DATA_SET (DDS_ID) on delete cascade alter table DEP_ISOMORPHOUS add (constraint DI_PK primary key (DI_ID)) alter table DEP_ISOMORPHOUS add ( constraint DI_DI1_UK unique (DDS_DDS_ID)) alter table DEP_ISOMORPHOUS add constraint DI_DDS_FK foreign key (DDS_DDS_ID) references DEP_DATA_SET (DDS_ID) on delete cascade alter table DEP_MAP_AVGNG add (constraint DMA_PK primary key (DMA_ID)) alter table DEP_MAP_AVGNG add ( constraint DMA_DMA1_UK unique (DDS_DDS_ID)) alter table DEP_MAP_AVGNG add constraint DMA_DDS_FK foreign key (DDS_DDS_ID) references DEP_DATA_SET (DDS_ID) on delete cascade alter table DEP_EXPTL_XTAL add (constraint DEX_PK primary key (DEX_ID)) alter table DEP_EXPTL_XTAL add ( constraint DEX_DEX1_UK unique (DEP_DEP_ID ,CRYSTAL_ID)) alter table DEP_EXPTL_XTAL add constraint DEX_DEP_FK foreign key (DEP_DEP_ID) references DEPOSITION (DEP_ID) on delete cascade add constraint DEX_RXGM_FK foreign key (RXGM_RXGM_ID) references REF_XTAL_GROW_METH (RXGM_ID) on delete cascade add constraint DEX_RSM_FK foreign key (RSM_RSM_ID) references REF_SEEDING_METH (RSM_ID) on delete cascade alter table DEP_DFFRN_MEAS add (constraint DDM_PK primary key (DDM_ID)) alter table DEP_DFFRN_MEAS add ( constraint DDM_DDM1_UK unique (DDS_DDS_ID ,DEX_DEX_ID ,MEASUREMENT_ID)) alter table DEP_DFFRN_MEAS add constraint DDM_RDT_FK foreign key (RDT_RDT_ID) references REF_DFFRN_TARGET (RDT_ID) on delete cascade add constraint DDM_DEX_FK foreign key (DEX_DEX_ID) references DEP_EXPTL_XTAL (DEX_ID) on delete cascade add constraint DDM_RDD_FK foreign key (RDD_RDD_ID) references REF_DFFRN_DETECTOR (RDD_ID) on delete cascade add constraint DDM_RW_FK foreign key (RW_RW_ID) references REF_WAVELENGTH (RW_ID) on delete cascade add constraint DDM_DDS_FK foreign key (DDS_DDS_ID) references DEP_DATA_SET (DDS_ID) on delete cascade add constraint DDM_RDMD_FK foreign key (RDMD_RDMD_ID) references REF_DFFRN_MEAS_DEV (RDMD_ID) on delete cascade add constraint DDM_RDMT_FK foreign key (RDMT_RDMT_ID) references REF_DFFRN_MEAS_DEV_TYPE (RDMT_ID) on delete cascade add constraint DDM_RDST_FK foreign key (RDST_RDST_ID) references REF_DFFRN_SOURCE_TYPE (RDST_ID) on delete cascade add constraint DDM_RDS_FK foreign key (RDS_RDS_ID) references REF_DFFRN_SOURCE (RDS_ID) on delete cascade