| Result |
| EntityType | Independent |
| Logical Entity Name | Result |
| Default Table Name | Result |
| Logical Only | NO |
| Owner | |
| Definition | |
| Note |
| Result Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Result_ID |
Identifier | BIGINT | NO | |
Parent_Result_ID |
Identifier | BIGINT | YES | |
| Parent_child_relationship | VARCHAR(20) | YES | two types of hierarchy are allowed: parent/child where one result is dependant on or grouped with another; derived from where aresult is used to claculate another (e.g. PI used for IC50). The hierarchy types are mutually exclusive. |
|
| Result_Status | VARCHAR(20) | NO | ||
| Ready_For_Extraction | dirty flag | VARCHAR(20) | NO | |
| Experiment_ID |
Identifier | BIGINT | NO | |
| Result_Type_ID |
Identifier | BIGINT | NO | |
| Stats_Modifier_ID |
Identifier | BIGINT | YES | |
| Substance_ID | BIGINT | NO | Has external reference to the PubChem SID |
|
| Replicate_No | NUMERIC(5, 0) | YES | ||
| Qualifier | qualifier | CHAR(2) | YES | |
| Value_ID |
Identifier | BIGINT | YES | |
| value_num | NUMERIC(30, 15) | YES | ||
| value_min | NUMERIC(30, 15) | YES | ||
| Value_Max | NUMERIC(30, 15) | YES | ||
| Value_Display | VARCHAR(256) | YES | ||
| Version | Version | INTEGER | NO | |
| Date_Created | Date_Created | TIMESTAMP/DATE | NO | |
| Last_Updated | Last_Updated | DATETIME | YES | |
| Modified_by | Modified_by | VARCHAR(40) | YES |
| Result Keys |
| Key Name | Key Type | Keys |
| PK_Result | PrimaryKey | Result_ID |
| FK_RESULT_EXPERIMENT | Inversion Entry | Experiment_ID |
| FK_RESULT_RESULT_TYPE | Inversion Entry | Result_Type_ID |
| FK_RESULT_STATS_MODIFIER | Inversion Entry | Stats_Modifier_ID |
| Result Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Element | Non-Identifying | Zero or One to Zero or More | value | Value_ID | NO | ||
| Experiment | Non-Identifying | One To Zero or More | value | Experiment_ID | NO | ||
| Result | Non-Identifying | Zero or One to Zero or More | value | Parent_Result_ID | NO | ||
| 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 | Stats_Modifier_ID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| Result | Non-Identifying | One To Zero or More | NO |
| Result Check Constraints |
| Check Constraint Name | CheckConstraint |
| CK_result_parentage | (HIERARCHY_TYPE IS NOT NULL AND PARENT_RESULT_ID IS NOT NULL)\line OR\line (HIERARCHY_TYPE IS NULL AND PARENT_RESULT_ID IS NULL)\line |
| Result Security Types |
| Name | Current Value |
| Result Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical Result |
NO | |||
| BARD - MySQL (MySQL) Result |
NO | |||
| BARD_Dev (Oracle) RESULT |
NO | |||
| Current Production (Oracle) Does Not Exist |
NO |
| Result Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Results |
| Logical | RI hierarchy |
| BARD - MySQL (MySQL) | Main Model |
| BARD - MySQL (MySQL) | Data Entry |
| BARD_Dev (Oracle) | Main Model |
| BARD_Dev (Oracle) | Results |
| BARD_Dev (Oracle) | RI hierarchy |