Measure Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Measure_ID	Identifier	BIGINT	NO
Assay_ID	Identifier	BIGINT	NO
Result_Type_ID	Identifier	BIGINT	NO
Parent_Measure_ID	Identifier	BIGINT	YES
Parent_Child_Relationship		VARCHAR(20)	YES
Entry_Unit_ID	Identifier	BIGINT	YES
Stats_Modifier_ID	Identifier	BIGINT	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

Measure Keys

Key Name	Key Type	Keys
PK_Measure	PrimaryKey	Measure_ID
FK_MEASURE_RESULT_TYPE	Inversion Entry	Result_Type_ID
FK_MEASURE_PARENT_MEASURE_ID	Inversion Entry	Parent_Measure_ID
AK_Measure	Alternate Key	Assay_ID, Result_Type_ID, Stats_Modifier_ID, Parent_Measure_ID
FK_MEASURE_STATS_MODIFIER	Inversion Entry	Stats_Modifier_ID
FK_MEASURE_ASSAY	Inversion Entry	Assay_ID

Measure 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
Element	Non-Identifying	Zero or One to Zero or More	UNIT			Entry_Unit_ID	NO
Measure	Non-Identifying	Zero or One to Zero or More	UNIT			Parent_Measure_ID	NO
Element	Non-Identifying	One To Zero or More	UNIT			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
Assay_Context_Measure	Non-Identifying	One To Zero or More					NO
Measure	Non-Identifying	One To Zero or More					NO

Measure Check Constraints

Check Constraint Name	CheckConstraint
CK_MEASURE_PARENT	(PARENT_CHILD_RELATIONSHIP IS NOT NULL AND PARENT_MEASURE_ID IS NOT NULL)\line OR\line (PARENT_CHILD_RELATIONSHIP IS NULL AND PARENT_MEASURE_ID IS NULL)\line

Measure Security Types

Name	Current Value

Measure Where Used - Model Usage

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

Measure Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	RI hierarchy
BARD - MySQL (MySQL)	Main Model
BARD - MySQL (MySQL)	CAP
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	RI hierarchy