| DDL Code |
CREATE TABLE SMPL.SAMPLE(
SMPL_ID NUMBER(38, 0) NOT NULL,
FAM_SMPL_ID NUMBER(38, 0),
SMPL_TYPE_IND CHAR(1) DEFAULT 'L' NOT NULL,
SMPL_NM VARCHAR2(120) NOT NULL,
SMPL_FMLA VARCHAR2(2000),
SMPL_DESCR VARCHAR2(2000) NOT NULL,
VOL_WGT_AMT NUMBER(8, 2) NOT NULL,
MASS_UNIT_ID VARCHAR2(3) NOT NULL,
SMPL_HGT VARCHAR2(5),
LEN_UNIT_ID VARCHAR2(3),
NEUTRON_BEAM_IND CHAR(1) DEFAULT 'N' NOT NULL,
CTRL_AREA_ID NUMBER(38, 0) NOT NULL,
SUBAREA_ID NUMBER(38, 0),
SUBAREA1_ID NUMBER(38, 0),
SUBAREA2_ID NUMBER(38, 0),
SMPL_DISP VARCHAR2(2000),
CONT_ID VARCHAR2(25) NOT NULL,
STAT_ID VARCHAR2(25) NOT NULL,
ST_ID VARCHAR2(6) NOT NULL,
REQ_ID VARCHAR2(25) NOT NULL,
GRP_ID VARCHAR2(128),
CMNT VARCHAR2(2000),
MOD_DTE DATE DEFAULT sysdate NOT NULL,
MOD_BY_USERID VARCHAR2(64) NOT NULL,
DISP_ID VARCHAR2(25) NOT NULL,
RCRA_WASTE_CD VARCHAR2(50),
UN_ID VARCHAR2(50),
DOT_DIV_NBR CHAR(3),
DOT_SUB_HAZ_DIV_NBR CHAR(3),
PKG_GRP_ID VARCHAR2(3),
WASTE_CHAR_CMNT VARCHAR2(2000),
LWS_IND CHAR(1) DEFAULT 'N' NOT NULL,
DOT_CLASS_NBR CHAR(1),
DOT_SUB_CLASS_NBR CHAR(1),
smpl_owner_person_id VARCHAR2(10),
DISP_VERIF_IND CHAR(1) DEFAULT 'N' NOT NULL,
SMPL_RET_NM VARCHAR2(75),
SMPL_RET_ADDR VARCHAR2(500),
CAN_ID VARCHAR2(20),
DISP_CMNT VARCHAR2(2000),
SPEC_HAND_PLAN_IND CHAR(1) DEFAULT 'N' NOT NULL,
THEOR_MASS_DENS VARCHAR2(5),
CHECK (SMPL_TYPE_IND IN('L','B')),
CONSTRAINT PK_SAMPLE PRIMARY KEY (SMPL_ID),
CONSTRAINT RefSAMPLE4214 FOREIGN KEY (FAM_SMPL_ID)
REFERENCES SMPL.SAMPLE(SMPL_ID),
CONSTRAINT fk_smpl_to_person FOREIGN KEY (smpl_owner_person_id)
REFERENCES XF_ADMIN.PERSON(PERSON_ID)
)
NOCOMPRESS
;
COMMENT ON COLUMN SMPL.SAMPLE.SMPL_NM IS 'Name: A long description name usually accompanied by an abbreviated code.'
;
COMMENT ON COLUMN SMPL.SAMPLE.SMPL_FMLA IS 'Sample Formula: Any sensible chemical formula.'
;
COMMENT ON COLUMN SMPL.SAMPLE.SMPL_DESCR IS 'Description: Often used in validation tables accompanying an abbreviated identifer.'
;
COMMENT ON COLUMN SMPL.SAMPLE.MASS_UNIT_ID IS 'Unit Identifier: Abbreviated unit of mass.'
;
COMMENT ON COLUMN SMPL.SAMPLE.LEN_UNIT_ID IS 'Length Unit Identifier: Abbreviated unit of length.'
;
COMMENT ON COLUMN SMPL.SAMPLE.ST_ID IS 'State Identifier: The material state.'
;
COMMENT ON COLUMN SMPL.SAMPLE.CMNT IS 'Comment: General comments.'
;
COMMENT ON COLUMN SMPL.SAMPLE.MOD_DTE IS 'Date: Date and time to seconds.'
;
COMMENT ON COLUMN SMPL.SAMPLE.RCRA_WASTE_CD IS 'Resource Conservation and Recovery Act Waste Code:'
;
COMMENT ON COLUMN SMPL.SAMPLE.UN_ID IS 'UN Identifier: '
;
COMMENT ON COLUMN SMPL.SAMPLE.WASTE_CHAR_CMNT IS 'Comment: General comments.'
;
COMMENT ON COLUMN SMPL.SAMPLE.smpl_owner_person_id IS 'Person Identifier: Unique identifier for a person derived from XCAMS.'
;
COMMENT ON COLUMN SMPL.SAMPLE.DISP_VERIF_IND IS 'Disposition Verified Indicator: Simple placeholder indicating that all sample disposition items have been checked.'
;
COMMENT ON COLUMN SMPL.SAMPLE.SMPL_RET_NM IS 'Item Return Name: The name of the person to which the experiment samples are to be returned.'
;
COMMENT ON COLUMN SMPL.SAMPLE.SMPL_RET_ADDR IS 'Item Return Address: The address to which the experiment samples ae to be returned.'
;
COMMENT ON COLUMN SMPL.SAMPLE.DISP_CMNT IS 'Comment: General comments.'
;
COMMENT ON COLUMN SMPL.SAMPLE.THEOR_MASS_DENS IS 'Theoretical Mass Density: Measured in grams per centimeter cube (g/cm^3)'
;
COMMENT ON TABLE SMPL.SAMPLE IS 'Experiment Sample: Information on the sample material that will be use in the experiment.'
;
|
