|
Relationship: Analysis_Dataset_Analysis
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Analysis (Analysis_ID) |
| Child | Dataset_Analysis (Analysis_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Analysis_Sub_Analysis
Relationship details:
| Description | This is the relationshjp between a lower-level Analysis in the 'Analysis' table and its corresponding record in the 'Merged_Analysis' table.
Some Analyses are merged so that further Analyses can be performed. The Analyses that are merged are called "Sub Analyses" and the higher-level Analysis that is created in this merged is called a "Super Analysis". |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Analysis (Analysis_ID) |
| Child | Merged_Analysis (Sub_Analysis_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Analysis_Super_Analysis
Relationship details:
| Description | This is the relationshjp between a higher-level Analysis in the 'Analysis' table and its corresponding record in the 'Merged_Analysis' table.
Some Analyses are merged so that further Analyses can be performed. The Analyses that are merged are called "Sub Analyses" and the higher-level Analysis that is created in this merged is called a "Super Analysis". |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Analysis (Analysis_ID) |
| Child | Merged_Analysis (Super_Analysis_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Cohort_Sample
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Cohort (Cohort_ID) |
| Child | Sample (Cohort_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Dataset_Analysis_Variant_Analysis
Relationship details:
| Description | This relationship resolves the M:M relationship between the 'Dataset_Analysis' and 'Variant' tables. |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Dataset_Analysis (Dataset_Analysis_ID) |
| Child | Variant_Analysis (Dataset_Analysis_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Dataset_Dataset_Analysis
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Dataset (Dataset_ID) |
| Child | Dataset_Analysis (Dataset_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Dataset_Dataset_Xref
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Dataset (Dataset_ID) |
| Child | Dataset_Xref (Dataset_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Dataset_Method_Platform_Sample
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Dataset (Dataset_ID) |
| Child | Method_Platform_Sample (Dataset_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Dataset_Reference
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Dataset (Dataset_ID) |
| Child | Reference (Dataset_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Method_Study_Method_Platform_Sample
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Method_Study (Method_Study_ID) |
| Child | Method_Platform_Sample (Method_Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Platform_Study_Method_Platform_Sample
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Platform_Study (Platform_Study_ID) |
| Child | Method_Platform_Sample (Platform_Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Reference_Dataset_Analysis
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Reference (Reference_ID) |
| Child | Dataset_Analysis (Reference_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Sample_Individual_to_Pooled
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Sample_Study (Sample_Study_ID) |
| Child | Sample_Pooled (Individual_Sample_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Sample_Level
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant (Variant_ID) |
| Child | Supporting_Merged_Variant (Supporting_Variant_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Sample_Pooled_to_Pooled
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Sample_Study (Sample_Study_ID) |
| Child | Sample_Pooled (Pooled_Sample_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Sample_Sample_Study
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | One Or More |
| Parent | Sample (Sample_ID) |
| Child | Sample_Study (Sample_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Sample_Sample_Xref
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Sample (Sample_ID) |
| Child | Sample_Xref (Sample_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Sample_Study_Method_Platform_Sample
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Sample_Study (Sample_Study_ID) |
| Child | Method_Platform_Sample (Sample_Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Study_Analysis
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Study (Study_ID) |
| Child | Analysis (Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Study_Dataset
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Study (Study_ID) |
| Child | Dataset (Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Study_Dataset_Analysis
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Study (Study_ID) |
| Child | Dataset_Analysis (Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Study_Method_Study
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | One Or More |
| Parent | Study (Study_ID) |
| Child | Method_Study (Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Study_Platform_Study
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Study (Study_ID) |
| Child | Platform_Study (Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Study_Reference
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Study (Study_ID) |
| Child | Reference (Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Study_Sample_Study
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | One Or More |
| Parent | Study (Study_ID) |
| Child | Sample_Study (Study_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Variant_Supporting_Merged_Variant
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant (Variant_ID) |
| Child | Supporting_Merged_Variant (Merged_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Variant_Translocation_Mapping
Relationship details:
| Description | This relationship represents the parent-child, or one-to-many relationship between a Translocation Variant and its multiple mappings. |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant (Variant_ID) |
| Child | Translocation_Mapping (Variant_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Variant_Type_Copy_Number
Relationship details:
| Description | This relationship allows for a given Variant Type to be associated with information about the Copies of that Variant Type in a 1:M Variant_Type:Copy_Number ratio. |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant_Type (Variant_Type_ID) |
| Child | Copy_Number (Variant_Type_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Variant_Variant_Analysis
Relationship details:
| Description | This relationship resolves the M:M relationship between the 'Dataset_Analysis' and 'Variant' tables. |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant (Variant_ID) |
| Child | Variant_Analysis (Variant_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Variant_Variant_Mapping
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant (Variant_ID) |
| Child | Variant_Mapping (Variant_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Variant_Variant_Type
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant (Variant_ID) |
| Child | Variant_Type (Variant_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: Variant_Variant_Xref
Relationship details:
| Description | |
| Type | Non Identifying |
| Cardinality | Zero Or More |
| Parent | Variant (Variant_ID) |
| Child | Variant_Xref (Variant_ID) |
| Update rule | None |
| Delete rule | None |
|