External_Reference 
EntityType  Independent 
Logical Entity Name  External_Reference 
Default Table Name  External_Reference 
Logical Only  NO 
Owner   
Definition 
 
Note 
 

External_Reference Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
External_Reference_ID(PK)  Identifier  BIGINT  NO 
 
External_System_ID(FK)  Identifier  BIGINT  NO 
 
Experiment_ID(FK)  Identifier  BIGINT  YES 
 
Project_ID(FK)  Identifier  BIGINT  YES 
 
Ext_Assay_Ref    VARCHAR(128)  NO 
 
Version  Version  INTEGER  NO 
 
Date_Created  Date_Created  TIMESTAMP/DATE  NO 
 
Last_Updated  Last_Updated  DATETIME  YES 
 
Modified_by  Modified_by  VARCHAR(40)  YES 
 

External_Reference Keys 
Key Name  Key Type  Keys 
PK_External_Reference  PrimaryKey  External_Reference_ID 
FK_Ext_Reference_EXPERIMENT  Inversion Entry  Experiment_ID 
FK_Ext_Reference_EXT_SYSTEM  Inversion Entry  External_System_ID 
FK_Ext_Reference_PROJECT  Inversion Entry  Project_ID 
AK_Ext_Reference  Alternate Key  External_System_ID, Experiment_ID, Project_ID, Ext_Assay_Ref 

External_Reference Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Experiment  Non-Identifying  Zero or One to Zero or More        Experiment_ID  NO 
External_System  Non-Identifying  One To Zero or More        External_System_ID  NO 
Project  Non-Identifying  Zero or One to Zero or More        Project_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

External_Reference Check Constraints 
Check Constraint Name  CheckConstraint 
CK_PROJECT_EXPERIMENT_NULLS  (Project_ID is null and experiment_ID is not null)\line or \line (Project_ID is not null and experiment_ID is null) 

External_Reference Security Types 
Name  Current Value 

External_Reference Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
External_Reference 		 NO       
BARD - MySQL (MySQL)
Does Not Exist 		 NO       
BARD_Dev (Oracle)
EXTERNAL_REFERENCE 		 NO       
Current Production (Oracle)
Does Not Exist 		 NO       

External_Reference Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Project Information 
Logical  RI hierarchy 
BARD_Dev (Oracle)  Main Model 
BARD_Dev (Oracle)  Project Information 
BARD_Dev (Oracle)  RI hierarchy