EXPT_SMPL |
Logical Entity Name | Experiment Sample |
Default Table Name | EXPT_SMPL |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | PRPSL |
Definition | Experiment Sample: Information on the sample material that will be use in the experiment. |
Note | |
PreSQL | |
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_SIZE_UOL                VARCHAR2(3),      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) ) ; ALTER TABLE PRPSL.EXPT_SMPL ADD      CONSTRAINT PK_EXPT_SMPL PRIMARY KEY (PRPSL_ID, SUBMISS_NBR, SMPL_ID) ; 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_LEN4024      FOREIGN KEY (LEN_UNIT_ID)      REFERENCES XF_ADMIN.UNIT_LEN(LEN_UNIT_ID) ; ALTER TABLE PRPSL.EXPT_SMPL ADD CONSTRAINT RefUNIT_MASS4025      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) ; ALTER TABLE PRPSL.EXPT_SMPL ADD CONSTRAINT RefUNIT_LEN4027      FOREIGN KEY (SMPL_SIZE_UOL)      REFERENCES XF_ADMIN.UNIT_LEN(LEN_UNIT_ID) ; |
PostSQL |
EXPT_SMPL Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PRPSL_ID | NUMBER(10, 0) | NO | ||
SUBMISS_NBR | Identifier | NUMBER(38, 0) | NO | |
SMPL_ID | NUMBER(10, 0) | NO | Sample Identifier: A sequential numeric identifier for the proposal samples. |
|
SMPL_NM | Name | VARCHAR2(120) | NO | Name: A long description name usually accompanied by an abbreviated code. |
SMPL_DESCR | Description | VARCHAR2(2000) | NO | Description: Often used in validation tables accompanying an abbreviated identifer. |
SMPL_FMLA | VARCHAR2(2000) | YES | Sample Formula: Any sensible chemical formula. |
|
SMPL_LNGTH | NUMBER(7, 2) | YES | Sample Length: Length of sample in centimeters. |
|
SMPL_WIDTH | NUMBER(7, 2) | YES | Sample Width: Width of sample in centimeters. |
|
SMPL_HGT | NUMBER(7, 2) | YES | Sample Height: Height of sample in centimeters. |
|
SMPL_SIZE_UOL | VARCHAR2(3) | YES | Length Unit Identifier: Abbreviated unit of length. |
|
SMPL_MASS | NUMBER(14, 4) | YES | Sample Mass: Mass of sample in grams. |
|
SMPL_TOT_NBR | NUMBER(5, 0) | YES | Sample Total Number: Total number of samples for this description. |
|
EQUIP | VARCHAR2(4000) | YES | Equipment: Experimenter supplied equipment or sample environments. |
|
LOCAL_EQUIP | VARCHAR2(4000) | YES | Local Equipment: On-site equipment needed for the experiment. |
|
LEN_UNIT_ID | VARCHAR2(3) | YES | Length Unit Identifier: Abbreviated unit of length. |
|
MASS_UNIT_ID | VARCHAR2(3) | YES | Mass Unit Identifier: Abbreviated unit of mass. |
|
ST_ID | VARCHAR2(6) | YES | State Identifier: The material state. |
|
TEMP | VARCHAR2(25) | YES | Temperature: Temperature of which the sample should be mesured. Currently only used by Mail-In BL-11A proposals. |
|
TEMP_UNIT_ID | CHAR(1) | YES | Unit Identifier: Abbreviated unit of mass. |
|
SMPL_DESC_ID | VARCHAR2(5) | YES | ||
SMPL_CONTAINMENT | VARCHAR2(2000) | YES | ||
IRRAD_HIST | VARCHAR2(2000) | YES | ||
SMPL_DISP | VARCHAR2(2000) | YES | ||
MIN_MOD_NOTES | Note | VARCHAR2(4000) | YES | |
SMPL_DENS | NUMBER(7, 2) | YES | ||
CONT_ID | Identifier | VARCHAR2(25) | YES | |
SNGL_CRYST_DIM_A | NUMBER(10, 2) | YES | ||
SNGL_CRYST_DIM_B | NUMBER(10, 2) | YES | ||
SNGL_CRYST_DIM_C | NUMBER(10, 2) | YES | ||
SNGL_CRYST_DIM_V | NUMBER(10, 2) | YES | ||
SNGL_CRYST_DIM_ALPHA | NUMBER(10, 2) | YES | ||
SGNL_CRYST_DIM_BETA | NUMBER(10, 2) | YES | ||
SGNL_CRYST_DIM_GAMMA | NUMBER(10, 2) | YES | ||
SGNL_CRYST_DIM_SP_GRP | VARCHAR2(8) | YES | ||
MOD_DTE | Date | DATE | YES | |
CONFIRM_DTE | Date | DATE | YES | |
NEUTRON_BEAM_IND | Indicator | CHAR(1) | YES | |
JUST_CMNT | Comment | VARCHAR2(2000) | YES | |
SGNL_CRYST_ATOM_UNIT_NBR | NUMBER(38, 0) | YES | ||
SNGL_CRYST_SKIP_IND | Indicator | CHAR(1) | NO | |
APPRV_ID | Identifier | VARCHAR2(25) | YES | |
THIN_FILM_SHAPE_SURF | VARCHAR2(50) | YES | ||
DEL_IND | Indicator | CHAR(1) | NO | |
CRYST_EXIST_IND | Indicator | CHAR(1) | YES | |
CRYST_ALIGN_NEED_IND | Indicator | CHAR(1) | YES | |
DATA_MIN | NUMBER(38, 2) | YES | Data Miniimum: The low value of the data values to be captured on the sample. (Currently used only for BL-11A Mail-In) |
|
DATA_MAX | NUMBER(38, 2) | YES | Data Maximum: The high value of the data values to be captured on the sample. (Currently used only for BL-11A Mail-In) |
|
CAN_SIZE | VARCHAR2(25) | YES | Can Size: The size of can requested for BL-11A Mail-In proposals. |
|
RET_SHIP_ADDR | VARCHAR2(1000) | YES | Return Shipping Address: The sample return shipping address for mail-in proposals. |
EXPT_SMPL Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_EXPT_SMPL | PrimaryKey | PRPSL_ID, SUBMISS_NBR, SMPL_ID |
EXPT_SMPL Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
UNIT_LEN | Non-Identifying | Zero or One to Zero or More | LEN_UNIT_ID | NO | NO | NO | |||
UNIT_MASS | Non-Identifying | Zero or One to Zero or More | MASS_UNIT_ID | NO | NO | NO | |||
UNIT_LEN | Non-Identifying | Zero or One to Zero or More | SMPL_SIZE_UOL | NO | NO | NO | |||
PRPSL_SUBMISS | Identifying | One To Zero or More | FK_EXPT_SMPL_TO_PRPSL_SUB | PRPSL_ID, SUBMISS_NBR | NO | NO | NO | ||
UNIT_TEMP | Non-Identifying | Zero or One to Zero or More | FK_EXPT_SMPL_TO_TEMP_UNIT | TEMP_UNIT_ID | NO | NO | NO | ||
EXPT_SMPL_APPR_CODE | Non-Identifying | Zero or One to Zero or More | FK_EXPT_TO_EXPT_SMPL_APPR_CD | APPRV_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EXPT_SMPL_FORM_ASSC | Identifying | One To Zero or More | FK_ESFA_TO_EXPT_SMPL | NO | NO | NO | |||
EXPT_SMPL_HAZ_ASSC | Identifying | One To Zero or More | FK_ESHA_TO_EXPT_SMPL | NO | NO | NO | |||
EXPT_SMPL_SPEC_REQ_ASSC | Identifying | One To Zero or More | FK_ESSRA_TO_EXPT_SMPL | NO | NO | NO | |||
EXPT_SMPL_SMPL_ENV_ASSC | Identifying | One To Zero or More | FK_EXPT_SMPL_SMPL_ENV | NO | NO | NO | |||
EXPT_SMPL_SMPL_SAFE_ASSC | Identifying | One To Zero or More | FK_EXPT_SMPL_SMPL_SAFE | NO | NO | NO | |||
EXPT_SMPL_SMPL_COND_ASSC | Identifying | One To Zero or More | FK_SMPL_COND_ASSC_TO_EXPT_SMPL | NO | NO | NO |
EXPT_SMPL Check Constraints |
Check Constraint Name | CheckConstraint |
EXPT_SMPL Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
EXPT_SMPL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
EXPT_SMPL Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
EXPT_SMPL Security Types |
Name | Current Value |
EXPT_SMPL Bound Attachments |
Name | Current Value |
EXPT_SMPL Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical PRPSL.Experiment Sample |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) PRPSL.EXPT_SMPL |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) PRPSL.EXPT_SMPL |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
EXPT_SMPL Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Integrated Proposal Tracking System |
IPTSv5 (Oracle) | Main Model |
PRPSL (Oracle) | Main Model |
EXPT_SMPL Data Movement Rules |
Name | Type | Rule Text/Value |