| Result_ID |
| Base Entity | Result |
| Attribute Name | Result_ID |
| Logical Rolename | |
| ColumnName | Result_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Result_ID Logical Attribute Properties |
| Logical Attribute Name | Result_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Result_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Result_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Result_ID |
NO | ||
| BARD - MySQL (MySQL) Result Result_ID |
NO | ||
| BARD_Dev (Oracle) RESULT RESULT_ID |
NO |
| Parent_Result_ID |
| Base Entity | Result |
| Attribute Name | Result_ID |
| Logical Rolename | Parent_Result_ID |
| ColumnName | Parent_Result_ID |
| RoleName | Parent_Result_ID |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Parent_Result_ID Logical Attribute Properties |
| Logical Attribute Name | Result_ID |
| Datatype | BIGINT |
| Nullable | YES |
| Parent_Result_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Parent_Result_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Result_ID |
NO | ||
| BARD - MySQL (MySQL) Result Result_ID |
NO | ||
| BARD_Dev (Oracle) RESULT PARENT_RESULT_ID |
NO |
| Parent_child_relationship |
| Base Entity | Result |
| Attribute Name | Parent_child_relationship |
| Logical Rolename | |
| ColumnName | Parent_child_relationship |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | 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. |
| Note |
| Parent_child_relationship Logical Attribute Properties |
| Logical Attribute Name | Parent_child_relationship |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Parent_child_relationship Domain Restrictions |
| CheckConstraint | @var in('calculated from', 'supported by') | ||
| Check Constraint Name | CK_result_Hierarchy_type | ||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Parent_child_relationship Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Parent_child_relationship |
NO | ||
| BARD - MySQL (MySQL) Result Parent_child_relationship |
NO | ||
| BARD_Dev (Oracle) RESULT Parent_child_relationship |
NO |
| Result_Status |
| Base Entity | Result |
| Attribute Name | Result_Status |
| Logical Rolename | |
| ColumnName | Result_Status |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Result_Status Logical Attribute Properties |
| Logical Attribute Name | Result_Status |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Result_Status Domain Restrictions |
| CheckConstraint | @var IN ('Pending', 'Approved', 'Rejected', 'Mark for Deletion') | ||
| Check Constraint Name | CK_RESULT_STATUS | ||
| Bound Rule | |||
| Declared Default | 'Pending' | ||
| Bound Default |
| Result_Status Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Result_Status |
NO | ||
| BARD - MySQL (MySQL) Result Result_Status |
NO | ||
| BARD_Dev (Oracle) RESULT RESULT_STATUS |
NO |
| Ready_For_Extraction |
| Base Entity | Result |
| Attribute Name | Ready_For_Extraction |
| Logical Rolename | |
| ColumnName | Ready_For_Extraction |
| RoleName | |
| Domain | dirty flag |
| Logical Only | NO |
| Definition | |
| Note |
| Ready_For_Extraction Logical Attribute Properties |
| Logical Attribute Name | Ready_For_Extraction |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Ready_For_Extraction Domain Restrictions |
| CheckConstraint | @var IN ('Not Ready', 'Ready', 'Started', 'Complete') |
| Check Constraint Name | CK_RESULT_EXTRACTION |
| Bound Rule | |
| Declared Default | 'Not Ready' |
| Bound Default |
| Ready_For_Extraction Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Ready_For_Extraction |
NO | ||
| BARD - MySQL (MySQL) Result Ready_For_Extraction |
NO | ||
| BARD_Dev (Oracle) RESULT READY_FOR_EXTRACTION |
NO |
| Experiment_ID |
| Base Entity | Result |
| Attribute Name | Experiment_ID |
| Logical Rolename | |
| ColumnName | Experiment_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Experiment_ID Logical Attribute Properties |
| Logical Attribute Name | Experiment_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Experiment_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Experiment_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Experiment_ID |
NO | ||
| BARD - MySQL (MySQL) Result Experiment_ID |
NO | ||
| BARD_Dev (Oracle) RESULT EXPERIMENT_ID |
NO |
| Result_Type_ID |
| Base Entity | Result |
| Attribute Name | Element_ID |
| Logical Rolename | Result_Type_ID |
| ColumnName | Result_Type_ID |
| RoleName | Result_Type_ID |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Result_Type_ID Logical Attribute Properties |
| Logical Attribute Name | Element_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Result_Type_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Result_Type_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Element_ID |
NO | ||
| BARD - MySQL (MySQL) Result Result_Type_ID |
NO | ||
| BARD_Dev (Oracle) RESULT RESULT_TYPE_ID |
NO |
| Stats_Modifier_ID |
| Base Entity | Result |
| Attribute Name | Element_ID |
| Logical Rolename | Stats_Modifier_ID |
| ColumnName | Stats_Modifier_ID |
| RoleName | Stats_Modifier_ID |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Stats_Modifier_ID Logical Attribute Properties |
| Logical Attribute Name | Element_ID |
| Datatype | BIGINT |
| Nullable | YES |
| Stats_Modifier_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Stats_Modifier_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Element_ID |
NO | ||
| BARD - MySQL (MySQL) Result Stats_Modifier_ID |
NO | ||
| BARD_Dev (Oracle) RESULT STATS_MODIFIER_ID |
NO |
| Substance_ID |
| Base Entity | Result |
| Attribute Name | Substance_ID |
| Logical Rolename | |
| ColumnName | Substance_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Has external reference to the PubChem SID |
| Note |
| Substance_ID Logical Attribute Properties |
| Logical Attribute Name | Substance_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Substance_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Substance_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Substance_ID |
NO | ||
| BARD - MySQL (MySQL) Result Substance_ID |
NO | ||
| BARD_Dev (Oracle) RESULT SUBSTANCE_ID |
NO |
| Replicate_No |
| Base Entity | Result |
| Attribute Name | Replicate_No |
| Logical Rolename | |
| ColumnName | Replicate_No |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Replicate_No Logical Attribute Properties |
| Logical Attribute Name | Replicate_No |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| Replicate_No Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Replicate_No Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Replicate_No |
NO | ||
| BARD - MySQL (MySQL) Result Replicate_No |
NO | ||
| BARD_Dev (Oracle) RESULT REPLICATE_NO |
NO |
| Qualifier |
| Base Entity | Result |
| Attribute Name | Qualifier |
| Logical Rolename | |
| ColumnName | Qualifier |
| RoleName | |
| Domain | qualifier |
| Logical Only | NO |
| Definition | |
| Note |
| Qualifier Logical Attribute Properties |
| Logical Attribute Name | Qualifier |
| Datatype | CHAR(2) |
| Nullable | YES |
| Qualifier Domain Restrictions |
| CheckConstraint | @var IN ('= ', '< ', '<=', '> ', '>=', '<<', '>>', '~ ') |
| Check Constraint Name | CK_RESULT_QUALIFIER |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Qualifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Qualifier |
NO | ||
| BARD - MySQL (MySQL) Result Qualifier |
NO | ||
| BARD_Dev (Oracle) RESULT QUALIFIER |
NO |
| Value_ID |
| Base Entity | Result |
| Attribute Name | Element_ID |
| Logical Rolename | Value_ID |
| ColumnName | Value_ID |
| RoleName | Value_ID |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Value_ID Logical Attribute Properties |
| Logical Attribute Name | Element_ID |
| Datatype | BIGINT |
| Nullable | YES |
| Value_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Value_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Element_ID |
NO | ||
| BARD - MySQL (MySQL) Result Value_ID |
NO | ||
| BARD_Dev (Oracle) RESULT Value_ID |
NO |
| value_num |
| Base Entity | Result |
| Attribute Name | value_num |
| Logical Rolename | |
| ColumnName | value_num |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| value_num Logical Attribute Properties |
| Logical Attribute Name | value_num |
| Datatype | NUMERIC(30, 15) |
| Nullable | YES |
| value_num Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| value_num Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result value_num |
NO | ||
| BARD - MySQL (MySQL) Result value_num |
NO | ||
| BARD_Dev (Oracle) RESULT VALUE_NUM |
NO |
| value_min |
| Base Entity | Result |
| Attribute Name | value_min |
| Logical Rolename | |
| ColumnName | value_min |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| value_min Logical Attribute Properties |
| Logical Attribute Name | value_min |
| Datatype | NUMERIC(30, 15) |
| Nullable | YES |
| value_min Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| value_min Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result value_min |
NO | ||
| BARD - MySQL (MySQL) Result value_min |
NO | ||
| BARD_Dev (Oracle) RESULT VALUE_MIN |
NO |
| Value_Max |
| Base Entity | Result |
| Attribute Name | Value_Max |
| Logical Rolename | |
| ColumnName | Value_Max |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Value_Max Logical Attribute Properties |
| Logical Attribute Name | Value_Max |
| Datatype | NUMERIC(30, 15) |
| Nullable | YES |
| Value_Max Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Value_Max Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Value_Max |
NO | ||
| BARD - MySQL (MySQL) Result Value_Max |
NO | ||
| BARD_Dev (Oracle) RESULT VALUE_MAX |
NO |
| Value_Display |
| Base Entity | Result |
| Attribute Name | Value_Display |
| Logical Rolename | |
| ColumnName | Value_Display |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Value_Display Logical Attribute Properties |
| Logical Attribute Name | Value_Display |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Value_Display Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Value_Display Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Value_Display |
NO | ||
| BARD - MySQL (MySQL) Result Value_Display |
NO | ||
| BARD_Dev (Oracle) RESULT VALUE_DISPLAY |
NO |
| Version |
| Base Entity | Result |
| Attribute Name | Version |
| Logical Rolename | |
| ColumnName | Version |
| RoleName | |
| Domain | Version |
| Logical Only | NO |
| Definition | |
| Note |
| Version Logical Attribute Properties |
| Logical Attribute Name | Version |
| Datatype | INTEGER |
| Nullable | NO |
| Version Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Version Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Version |
NO | ||
| BARD - MySQL (MySQL) Result Version |
NO | ||
| BARD_Dev (Oracle) RESULT VERSION |
NO |
| Date_Created |
| Base Entity | Result |
| Attribute Name | Date_Created |
| Logical Rolename | |
| ColumnName | Date_Created |
| RoleName | |
| Domain | Date_Created |
| Logical Only | NO |
| Definition | |
| Note |
| Date_Created Logical Attribute Properties |
| Logical Attribute Name | Date_Created |
| Datatype | TIMESTAMP/DATE |
| Nullable | NO |
| Date_Created Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Date_Created Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Date_Created |
NO | ||
| BARD - MySQL (MySQL) Result Date_Created |
NO | ||
| BARD_Dev (Oracle) RESULT Date_Created |
NO |
| Last_Updated |
| Base Entity | Result |
| Attribute Name | Last_Updated |
| Logical Rolename | |
| ColumnName | Last_Updated |
| RoleName | |
| Domain | Last_Updated |
| Logical Only | NO |
| Definition | |
| Note |
| Last_Updated Logical Attribute Properties |
| Logical Attribute Name | Last_Updated |
| Datatype | DATETIME |
| Nullable | YES |
| Last_Updated Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Last_Updated Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Last_Updated |
NO | ||
| BARD - MySQL (MySQL) Result Last_Updated |
NO | ||
| BARD_Dev (Oracle) RESULT Last_Updated |
NO |
| Modified_by |
| Base Entity | Result |
| Attribute Name | Modified_by |
| Logical Rolename | |
| ColumnName | Modified_by |
| RoleName | |
| Domain | Modified_by |
| Logical Only | NO |
| Definition | |
| Note |
| Modified_by Logical Attribute Properties |
| Logical Attribute Name | Modified_by |
| Datatype | VARCHAR(40) |
| Nullable | YES |
| Modified_by Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modified_by Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Result Modified_by |
NO | ||
| BARD - MySQL (MySQL) Result Modified_by |
NO | ||
| BARD_Dev (Oracle) RESULT MODIFIED_BY |
NO |