| DDL Code |
CREATE TABLE PRPSL.EXPT_SMPL(
PRPSL_ID NUMBER(10, 0) NOT NULL,
SUBMISS_NBR NUMBER(38, 0) NOT NULL,
SMPL_ID NUMBER(10, 0) NOT NULL,
SMPL_NM VARCHAR2(120) NOT NULL,
SMPL_DESCR VARCHAR2(2000) NOT NULL,
SMPL_FMLA VARCHAR2(2000),
SMPL_LNGTH NUMBER(7, 2),
SMPL_WIDTH NUMBER(7, 2),
SMPL_HGT NUMBER(7, 2),
SMPL_MASS NUMBER(14, 4),
SMPL_TOT_NBR NUMBER(5, 0),
EQUIP VARCHAR2(4000),
LOCAL_EQUIP VARCHAR2(4000),
LEN_UNIT_ID VARCHAR2(3),
MASS_UNIT_ID VARCHAR2(3),
ST_ID VARCHAR2(6),
TEMP VARCHAR2(25),
TEMP_UNIT_ID CHAR(1),
SMPL_DESC_ID VARCHAR2(5),
SMPL_CONTAINMENT VARCHAR2(2000),
IRRAD_HIST VARCHAR2(2000),
SMPL_DISP VARCHAR2(2000),
MIN_MOD_NOTES VARCHAR2(4000),
SMPL_DENS NUMBER(7, 2),
CONT_ID VARCHAR2(25),
SNGL_CRYST_DIM_A NUMBER(10, 2),
SNGL_CRYST_DIM_B NUMBER(10, 2),
SNGL_CRYST_DIM_C NUMBER(10, 2),
SNGL_CRYST_DIM_V NUMBER(10, 2),
SNGL_CRYST_DIM_ALPHA NUMBER(10, 2),
SGNL_CRYST_DIM_BETA NUMBER(10, 2),
SGNL_CRYST_DIM_GAMMA NUMBER(10, 2),
SGNL_CRYST_DIM_SP_GRP VARCHAR2(8),
MOD_DTE DATE DEFAULT SYSDATE,
CONFIRM_DTE DATE,
NEUTRON_BEAM_IND CHAR(1),
JUST_CMNT VARCHAR2(2000),
SGNL_CRYST_ATOM_UNIT_NBR NUMBER(38, 0),
SNGL_CRYST_SKIP_IND CHAR(1) DEFAULT 'N' NOT NULL,
APPRV_ID VARCHAR2(25),
THIN_FILM_SHAPE_SURF VARCHAR2(50),
DEL_IND CHAR(1) DEFAULT 'N' NOT NULL,
CRYST_EXIST_IND CHAR(1),
CRYST_ALIGN_NEED_IND CHAR(1) DEFAULT 'N',
DATA_MIN NUMBER(38, 2),
DATA_MAX NUMBER(38, 2),
CAN_SIZE VARCHAR2(25),
RET_SHIP_ADDR VARCHAR2(1000),
CONSTRAINT CK_SMPL_LNGTH CHECK (SMPL_LNGTH > 0),
CONSTRAINT CK_SMPL_WIDTH CHECK (SMPL_WIDTH > 0),
CONSTRAINT CK_SMPL_HGT CHECK (SMPL_HGT > 0),
CONSTRAINT CK_SMPL_MASS CHECK (SMPL_MASS > 0),
CONSTRAINT PK_EXPT_SMPL PRIMARY KEY (PRPSL_ID, SUBMISS_NBR, SMPL_ID)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE PRPSL
LOGGING
STORAGE(INITIAL 64K
NEXT 1024K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
)
)
PCTFREE 10
INITRANS 1
MAXTRANS 255
TABLESPACE PRPSL
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
NEXT 1024K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
)
NOCACHE
ENABLE ROW MOVEMENT
NOCOMPRESS
;
ALTER TABLE PRPSL.EXPT_SMPL ADD CONSTRAINT FK_EXPT_TO_EXPT_SMPL_APPR_CD
FOREIGN KEY (APPRV_ID)
REFERENCES PRPSL.EXPT_SMPL_APPR_CODE(APPRV_ID)
;
ALTER TABLE PRPSL.EXPT_SMPL ADD CONSTRAINT FK_EXPT_SMPL_TO_PRPSL_SUB
FOREIGN KEY (PRPSL_ID, SUBMISS_NBR)
REFERENCES PRPSL.PRPSL_SUBMISS(PRPSL_ID, SUBMISS_NBR)
;
ALTER TABLE PRPSL.EXPT_SMPL ADD CONSTRAINT RefUNIT_LEN4017
FOREIGN KEY (LEN_UNIT_ID)
REFERENCES XF_ADMIN.UNIT_LEN(LEN_UNIT_ID)
;
ALTER TABLE PRPSL.EXPT_SMPL ADD CONSTRAINT RefUNIT_MASS4018
FOREIGN KEY (MASS_UNIT_ID)
REFERENCES XF_ADMIN.UNIT_MASS(MASS_UNIT_ID)
;
ALTER TABLE PRPSL.EXPT_SMPL ADD CONSTRAINT FK_EXPT_SMPL_TO_TEMP_UNIT
FOREIGN KEY (TEMP_UNIT_ID)
REFERENCES XF_ADMIN.UNIT_TEMP(TEMP_UNIT_ID)
;
|
