| Exprmt_Measure |
| EntityType | Independent |
| Logical Entity Name | Exprmt_Measure |
| Default Table Name | EXPRMT_MEASURE |
| Logical Only | NO |
| Owner | |
| Definition | |
| Note |
| Exprmt_Measure Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Exprmt_measure_ID |
NUMERIC(19, 0) | NO | ||
| Parent_Child_Relationship | VARCHAR(20) | YES | ||
Experiment_ID |
Identifier | BIGINT | NO | |
| Version | Version | INTEGER | NO | |
| Date_Created | Date_Created | TIMESTAMP/DATE | NO | |
| Last_Updated | Last_Updated | DATETIME | YES | |
| Modified_by | Modified_by | VARCHAR(40) | YES | |
| PRIORITY_ELEMENT | NUMERIC(1, 0) | YES | ||
RESULT_TYPE_ID |
Identifier | BIGINT | NO | |
STATS_MODIFIER_ID |
Identifier | BIGINT | YES |
| Exprmt_Measure Keys |
| Key Name | Key Type | Keys |
| PK_EXPRMT_MEASURE | PrimaryKey | Exprmt_measure_ID |
| FK_EXPRMT_MEASURE_PARENT | Inversion Entry | Parent_Child_Relationship |
| FK_EXPRMT_MEASURE_EXPRMT | Inversion Entry | Experiment_ID |
| FK_EXP_MEASURE_RESULT_TYPE | Inversion Entry | RESULT_TYPE_ID |
| FK_EXP_MEASURE_STATS_MOD | Inversion Entry | RESULT_TYPE_ID |
| Exprmt_Measure Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Element | Non-Identifying | One To Zero or More | RESULT TYPE | RESULT_TYPE_ID | NO | ||
| Element | Non-Identifying | Zero or One to Zero or More | STATS MODIFIER | STATS_MODIFIER_ID | NO | ||
| Experiment | Non-Identifying | One To Zero or More | STATS MODIFIER | Experiment_ID | NO | ||
| Exprmt_Measure | Non-Identifying | Zero or One to Zero or More | STATS MODIFIER | Exprmt_measure_ID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| ASSAY_CTXT_EXP_MEASURE | Non-Identifying | One To Zero or More | NO | ||||
| Exprmt_Measure | Non-Identifying | One To Zero or More | NO |
| Exprmt_Measure Check Constraints |
| Check Constraint Name | CheckConstraint |
| CK_EXPM_RESULT_TYPE_ID | RESULT_TYPE_ID IS NOT NULL |
| 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)\line |
| 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 |