EXPRMT_MEASURE 
Logical Entity Name  EXPRMT_MEASURE 
Default Table Name  EXPRMT_MEASURE 
Physical Only  NO 
Do Not Generate  False 
Owner  BARD_CAP_PROD 
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE BARD_CAP_PROD.EXPRMT_MEASURE(
     EXPRMT_MEASURE_ID             NUMBER(19, 0)     NOT NULL,
     PARENT_EXPRMT_MEASURE_ID      NUMBER(19, 0),
     PARENT_CHILD_RELATIONSHIP     VARCHAR2(20),
     EXPERIMENT_ID                 NUMBER(19, 0)     NOT NULL,
     VERSION                       NUMBER(38, 0)     DEFAULT 0 NOT NULL,
     DATE_CREATED                  TIMESTAMP(6)      DEFAULT sysdate NOT NULL,
     LAST_UPDATED                  TIMESTAMP(6),
     MODIFIED_BY                   VARCHAR2(40),
     PRIORITY_ELEMENT              NUMBER(1, 0)      DEFAULT 0,
     RESULT_TYPE_ID                NUMBER(19, 0),
     STATS_MODIFIER_ID             NUMBER(19, 0),
     CONSTRAINT CK_EXPRMT_MEASURE_RELATIONSHIP CHECK (PARENT_CHILD_RELATIONSHIP in ('supported by', 'calculated from')),
     CONSTRAINT CK_EXPRMT_MEASURE_PARENT CHECK ((PARENT_CHILD_RELATIONSHIP IS NOT NULL AND PARENT_EXPRMT_MEASURE_ID IS NOT NULL)
                                     OR
                                     (PARENT_CHILD_RELATIONSHIP IS NULL AND PARENT_EXPRMT_MEASURE_ID IS NULL)),
     CONSTRAINT CK_EXPM_RESULT_TYPE_ID CHECK (RESULT_TYPE_ID IS NOT NULL),
     CONSTRAINT PK_EXPRMT_MEASURE PRIMARY KEY (EXPRMT_MEASURE_ID)
     USING INDEX
         PCTFREE 10
         INITRANS 2
         MAXTRANS 255
         TABLESPACE BARD_CAP_PROD
         LOGGING
         STORAGE(INITIAL 64K
                 NEXT 1024K
                 MINEXTENTS 1
                 MAXEXTENTS UNLIMITED
                 PCTINCREASE 0
                 BUFFER_POOL DEFAULT
                 ),
     CONSTRAINT FK_EXPRMT_MEASURE_EXPRMT FOREIGN KEY (EXPERIMENT_ID)
     REFERENCES BARD_CAP_PROD.EXPERIMENT(EXPERIMENT_ID),
     CONSTRAINT FK_EXPRMT_MEASURE_PARENT FOREIGN KEY (PARENT_EXPRMT_MEASURE_ID)
     REFERENCES BARD_CAP_PROD.EXPRMT_MEASURE(EXPRMT_MEASURE_ID)   DEFERRABLE INITIALLY DEFERRED,
     CONSTRAINT FK_EXP_MEASURE_STATS_MOD FOREIGN KEY (STATS_MODIFIER_ID)
     REFERENCES BARD_CAP_PROD.ELEMENT(ELEMENT_ID),
     CONSTRAINT FK_EXP_MEASURE_RESULT_TYPE FOREIGN KEY (RESULT_TYPE_ID)
     REFERENCES BARD_CAP_PROD.ELEMENT(ELEMENT_ID)
)
PCTFREE 10
INITRANS 1
MAXTRANS 255
TABLESPACE BARD_CAP_PROD
LOGGING
STORAGE(INITIAL 64K
         NEXT 1024K
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         BUFFER_POOL DEFAULT
         )
;
 
PostSQL   

EXPRMT_MEASURE Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXPRMT_MEASURE_ID(PK)    NUMBER(19, 0)  NO 
 
PARENT_EXPRMT_MEASURE_ID(FK)    NUMBER(19, 0)  YES 
 
PARENT_CHILD_RELATIONSHIP    VARCHAR2(20)  YES 
 
EXPERIMENT_ID(FK)    NUMBER(19, 0)  NO 
 
VERSION    NUMBER(38, 0)  NO 
 
DATE_CREATED    TIMESTAMP(6)  NO 
 
LAST_UPDATED    TIMESTAMP(6)  YES 
 
MODIFIED_BY    VARCHAR2(40)  YES 
 
PRIORITY_ELEMENT    NUMBER(1, 0)  YES 
 
RESULT_TYPE_ID(FK)  Identifier  NUMBER(19, 0)  YES 
 
STATS_MODIFIER_ID(FK)  Identifier  NUMBER(19, 0)  YES 
 

EXPRMT_MEASURE Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_EXPRMT_MEASURE  PrimaryKey  EXPRMT_MEASURE_ID 

EXPRMT_MEASURE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
ELEMENT  Non-Identifying  Zero or One to Zero or More  FK_EXP_MEASURE_RESULT_TYPE      RESULT_TYPE_ID  NO  NO  NO 
ELEMENT  Non-Identifying  Zero or One to Zero or More  FK_EXP_MEASURE_STATS_MOD      STATS_MODIFIER_ID  NO  NO  NO 
EXPERIMENT  Non-Identifying  One To Zero or More  FK_EXPRMT_MEASURE_EXPRMT      EXPERIMENT_ID  NO  NO  NO 
EXPRMT_MEASURE  Non-Identifying  Zero or One to Zero or More  FK_EXPRMT_MEASURE_PARENT      PARENT_EXPRMT_MEASURE_ID  NO  YES  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
EXPRMT_MEASURE  Non-Identifying  One To Zero or More  FK_EXPRMT_MEASURE_PARENT        NO  YES  YES 

EXPRMT_MEASURE Check Constraints 
Check Constraint Name  CheckConstraint 
CK_EXPRMT_MEASURE_PARENT  (PARENT_CHILD_RELATIONSHIP IS NOT NULL AND PARENT_EXPRMT_MEASURE_ID IS NOT NULL)\line OR\line (PARENT_CHILD_RELATIONSHIP IS NULL AND PARENT_EXPRMT_MEASURE_ID IS NULL) 
CK_EXPM_RESULT_TYPE_ID  RESULT_TYPE_ID IS NOT NULL 

EXPRMT_MEASURE Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  BARD_CAP_PROD 
PctFree  10 
PCTUSED   0 
MinExtents  1 
MaxExtents  2147483645 
Initial  64 
Next  1024 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging  Logged 
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS  FreeLists 
FREELIST GROUPS  FreeList Groups 
Buffer Pool  DEFAULT 
Table Compression  NO 
Row Movement  Disabled 

EXPRMT_MEASURE Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  0 
Growth  Static 
Growth Type  N/A 
Growth Period  N/A 
Maximum Rows  0 

EXPRMT_MEASURE Security Types 
Name  Current Value 

EXPRMT_MEASURE Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
Exprmt_Measure 		 NO       
BARD - MySQL (MySQL)
Does Not Exist 		 NO       
BARD_Dev (Oracle)
EXPRMT_MEASURE 		 NO       
Current Production (Oracle)
BARD_CAP_PROD.EXPRMT_MEASURE 		 NO       

EXPRMT_MEASURE Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Assay Definition 
Logical  Experiment Specification 
Logical  RI hierarchy 
BARD_Dev (Oracle)  Main Model 
BARD_Dev (Oracle)  Assay Definition 
BARD_Dev (Oracle)  Experiment Specification 
BARD_Dev (Oracle)  RI hierarchy 
Current Production (Oracle)  Main Model 
Current Production (Oracle)  Results Deposition 
Current Production (Oracle)  RI hierarchy