Assay_Context Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Assay_Context_ID	Identifier	BIGINT	NO
Assay_ID	Identifier	BIGINT	NO
Context_Name		VARCHAR(128)	YES	used as a title for the cards in the UI
Context_Group		VARCHAR(256)	YES
Version	Version	INTEGER	NO
Display_order		NUMERIC(5, 0)	NO
Date_Created	Date_Created	TIMESTAMP/DATE	NO
Last_Updated	Last_Updated	DATETIME	YES
Modified_by	Modified_by	VARCHAR(40)	YES
CONTEXT_TYPE		VARCHAR(25)	YES

Assay_Context Keys

Key Name	Key Type	Keys
PK_Assay_Context	PrimaryKey	Assay_Context_ID
UK_ASSAY_CONTEXT_ORDER	Inversion Entry	Assay_ID, Display_order
FK_ASSAY_CONTEXT_ASSAY	Inversion Entry	Assay_ID
UK_ASSAY_CONTEXT	Inversion Entry	Assay_ID, Context_Group, Display_order

Assay_Context Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Assay	Non-Identifying	One To Zero or More				Assay_ID	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Rslt_Context_Item	Non-Identifying	One To Zero or More					NO
Assay_Context_Item	Non-Identifying	One To Zero or More					NO
Assay_Context_Measure	Non-Identifying	One To Zero or More					NO
ASSAY_CTXT_EXP_MEASURE	Non-Identifying	One To Zero or More					NO

Assay_Context Check Constraints

Check Constraint Name

CheckConstraint

Assay_Context Security Types

Name	Current Value

Assay_Context Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical Assay_Context	NO
BARD - MySQL (MySQL) Does Not Exist	NO
BARD_Dev (Oracle) Assay_Context	NO
Current Production (Oracle) Does Not Exist	NO

Assay_Context 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