| Prjct_Exprmt_Context_ID |
| Base Entity | Prjct_Exprmt_Context |
| Attribute Name | Prjct_Exprmt_Context_ID |
| Logical Rolename | |
| ColumnName | Prjct_Exprmt_Context_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Prjct_Exprmt_Context_ID Logical Attribute Properties |
| Logical Attribute Name | Prjct_Exprmt_Context_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Prjct_Exprmt_Context_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Prjct_Exprmt_Context_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Prjct_Exprmt_Context Prjct_Exprmt_Context_ID |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT PRJCT_EXPRMT_CONTEXT_ID |
NO |
| PROJECT_EXPERIMENT_ID |
| Base Entity | Prjct_Exprmt_Context |
| Attribute Name | PROJECT_EXPERIMENT_ID |
| Logical Rolename | |
| ColumnName | PROJECT_EXPERIMENT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| PROJECT_EXPERIMENT_ID Logical Attribute Properties |
| Logical Attribute Name | PROJECT_EXPERIMENT_ID |
| Datatype | NUMERIC(19, 0) |
| Nullable | NO |
| PROJECT_EXPERIMENT_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| PROJECT_EXPERIMENT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Prjct_Exprmt_Context PROJECT_EXPERIMENT_ID |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT PROJECT_EXPERIMENT_ID |
NO |
| Context_Name |
| Base Entity | Prjct_Exprmt_Context |
| Attribute Name | Context_Name |
| Logical Rolename | |
| ColumnName | Context_Name |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | used as a title for the cards in the UI |
| Note |
| Context_Name Logical Attribute Properties |
| Logical Attribute Name | Context_Name |
| Datatype | VARCHAR(128) |
| Nullable | YES |
| Context_Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Context_Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Prjct_Exprmt_Context Context_Name |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT CONTEXT_NAME |
NO |
| Context_Group |
| Base Entity | Prjct_Exprmt_Context |
| Attribute Name | Context_Group |
| Logical Rolename | |
| ColumnName | Context_Group |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Context_Group Logical Attribute Properties |
| Logical Attribute Name | Context_Group |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Context_Group Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Context_Group Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Prjct_Exprmt_Context Context_Group |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT CONTEXT_GROUP |
NO |
| Display_order |
| Base Entity | Prjct_Exprmt_Context |
| Attribute Name | Display_order |
| Logical Rolename | |
| ColumnName | DISPLAY_ORDER |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Display_order Logical Attribute Properties |
| Logical Attribute Name | Display_order |
| Datatype | NUMERIC(5, 0) |
| Nullable | NO |
| Display_order Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 0 | ||
| Bound Default |
| Display_order Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Prjct_Exprmt_Context Display_order |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT DISPLAY_ORDER |
NO |
| Version |
| Base Entity | Prjct_Exprmt_Context |
| 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 Prjct_Exprmt_Context Version |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT VERSION |
NO |
| Date_Created |
| Base Entity | Prjct_Exprmt_Context |
| 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 Prjct_Exprmt_Context Date_Created |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT DATE_CREATED |
NO |
| Last_Updated |
| Base Entity | Prjct_Exprmt_Context |
| 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 Prjct_Exprmt_Context Last_Updated |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT LAST_UPDATED |
NO |
| Modified_by |
| Base Entity | Prjct_Exprmt_Context |
| 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 Prjct_Exprmt_Context Modified_by |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT MODIFIED_BY |
NO |
| CONTEXT_TYPE |
| Base Entity | Prjct_Exprmt_Context |
| Attribute Name | CONTEXT_TYPE |
| Logical Rolename | |
| ColumnName | CONTEXT_TYPE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| CONTEXT_TYPE Logical Attribute Properties |
| Logical Attribute Name | CONTEXT_TYPE |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| CONTEXT_TYPE Domain Restrictions |
| CheckConstraint | CONTEXT_TYPE is not null and CONTEXT_TYPE in ('Biology','Assay Protocol','Assay Design','Assay Readout','Assay Components','Experimental Variables','Unclassified') | ||
| Check Constraint Name | CK_PRJCT_EXPRMT_CTX_TYPE | ||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| CONTEXT_TYPE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Prjct_Exprmt_Context CONTEXT_TYPE |
NO | ||
| BARD_Dev (Oracle) PRJCT_EXPRMT_CONTEXT CONTEXT_TYPE |
NO |