A curated catalogue of human genomic structural variation




DeZign for Databases v5.2 - HTML Report
Logical model
Relationship details
Relationship: Analysis_Dataset_Analysis
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentAnalysis (Analysis_ID)
ChildDataset_Analysis (Analysis_ID)
Update ruleNone
Delete ruleNone
Relationship: Analysis_Sub_Analysis
Relationship details:
DescriptionThis 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".
TypeNon Identifying
CardinalityZero Or More
ParentAnalysis (Analysis_ID)
ChildMerged_Analysis (Sub_Analysis_ID)
Update ruleNone
Delete ruleNone
Relationship: Analysis_Super_Analysis
Relationship details:
DescriptionThis 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".
TypeNon Identifying
CardinalityZero Or More
ParentAnalysis (Analysis_ID)
ChildMerged_Analysis (Super_Analysis_ID)
Update ruleNone
Delete ruleNone
Relationship: Cohort_Sample
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentCohort (Cohort_ID)
ChildSample (Cohort_ID)
Update ruleNone
Delete ruleNone
Relationship: Dataset_Analysis_Variant_Analysis
Relationship details:
DescriptionThis relationship resolves the M:M relationship between the 'Dataset_Analysis' and 'Variant' tables.
TypeNon Identifying
CardinalityZero Or More
ParentDataset_Analysis (Dataset_Analysis_ID)
ChildVariant_Analysis (Dataset_Analysis_ID)
Update ruleNone
Delete ruleNone
Relationship: Dataset_Dataset_Analysis
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentDataset (Dataset_ID)
ChildDataset_Analysis (Dataset_ID)
Update ruleNone
Delete ruleNone
Relationship: Dataset_Dataset_Xref
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentDataset (Dataset_ID)
ChildDataset_Xref (Dataset_ID)
Update ruleNone
Delete ruleNone
Relationship: Dataset_Method_Platform_Sample
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentDataset (Dataset_ID)
ChildMethod_Platform_Sample (Dataset_ID)
Update ruleNone
Delete ruleNone
Relationship: Dataset_Reference
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentDataset (Dataset_ID)
ChildReference (Dataset_ID)
Update ruleNone
Delete ruleNone
Relationship: Method_Study_Method_Platform_Sample
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentMethod_Study (Method_Study_ID)
ChildMethod_Platform_Sample (Method_Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Platform_Study_Method_Platform_Sample
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentPlatform_Study (Platform_Study_ID)
ChildMethod_Platform_Sample (Platform_Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Reference_Dataset_Analysis
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentReference (Reference_ID)
ChildDataset_Analysis (Reference_ID)
Update ruleNone
Delete ruleNone
Relationship: Sample_Individual_to_Pooled
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentSample_Study (Sample_Study_ID)
ChildSample_Pooled (Individual_Sample_ID)
Update ruleNone
Delete ruleNone
Relationship: Sample_Level
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentVariant (Variant_ID)
ChildSupporting_Merged_Variant (Supporting_Variant_ID)
Update ruleNone
Delete ruleNone
Relationship: Sample_Pooled_to_Pooled
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentSample_Study (Sample_Study_ID)
ChildSample_Pooled (Pooled_Sample_ID)
Update ruleNone
Delete ruleNone
Relationship: Sample_Sample_Study
Relationship details:
Description
TypeNon Identifying
CardinalityOne Or More
ParentSample (Sample_ID)
ChildSample_Study (Sample_ID)
Update ruleNone
Delete ruleNone
Relationship: Sample_Sample_Xref
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentSample (Sample_ID)
ChildSample_Xref (Sample_ID)
Update ruleNone
Delete ruleNone
Relationship: Sample_Study_Method_Platform_Sample
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentSample_Study (Sample_Study_ID)
ChildMethod_Platform_Sample (Sample_Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Study_Analysis
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentStudy (Study_ID)
ChildAnalysis (Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Study_Dataset
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentStudy (Study_ID)
ChildDataset (Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Study_Dataset_Analysis
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentStudy (Study_ID)
ChildDataset_Analysis (Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Study_Method_Study
Relationship details:
Description
TypeNon Identifying
CardinalityOne Or More
ParentStudy (Study_ID)
ChildMethod_Study (Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Study_Platform_Study
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentStudy (Study_ID)
ChildPlatform_Study (Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Study_Reference
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentStudy (Study_ID)
ChildReference (Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Study_Sample_Study
Relationship details:
Description
TypeNon Identifying
CardinalityOne Or More
ParentStudy (Study_ID)
ChildSample_Study (Study_ID)
Update ruleNone
Delete ruleNone
Relationship: Variant_Supporting_Merged_Variant
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentVariant (Variant_ID)
ChildSupporting_Merged_Variant (Merged_ID)
Update ruleNone
Delete ruleNone
Relationship: Variant_Translocation_Mapping
Relationship details:
DescriptionThis relationship represents the parent-child, or one-to-many relationship between a Translocation Variant and its multiple mappings.
TypeNon Identifying
CardinalityZero Or More
ParentVariant (Variant_ID)
ChildTranslocation_Mapping (Variant_ID)
Update ruleNone
Delete ruleNone
Relationship: Variant_Type_Copy_Number
Relationship details:
DescriptionThis 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.
TypeNon Identifying
CardinalityZero Or More
ParentVariant_Type (Variant_Type_ID)
ChildCopy_Number (Variant_Type_ID)
Update ruleNone
Delete ruleNone
Relationship: Variant_Variant_Analysis
Relationship details:
DescriptionThis relationship resolves the M:M relationship between the 'Dataset_Analysis' and 'Variant' tables.
TypeNon Identifying
CardinalityZero Or More
ParentVariant (Variant_ID)
ChildVariant_Analysis (Variant_ID)
Update ruleNone
Delete ruleNone
Relationship: Variant_Variant_Mapping
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentVariant (Variant_ID)
ChildVariant_Mapping (Variant_ID)
Update ruleNone
Delete ruleNone
Relationship: Variant_Variant_Type
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentVariant (Variant_ID)
ChildVariant_Type (Variant_ID)
Update ruleNone
Delete ruleNone
Relationship: Variant_Variant_Xref
Relationship details:
Description
TypeNon Identifying
CardinalityZero Or More
ParentVariant (Variant_ID)
ChildVariant_Xref (Variant_ID)
Update ruleNone
Delete ruleNone


Hosted by The Centre for Applied Genomics
Grant support for DGV
Please read the usage disclaimer