Logical model
List of attributes
Attribute details
Attribute nameEntity nameKeyData typeNot null
Analysis_CriteriaAnalysisCHARACTER VARYINGNo
Analysis_DescriptionAnalysisCHARACTER VARYINGNo
Analysis_IDDataset_AnalysisFKINTEGERYes
Analysis_IDAnalysisPKSERIALYes
Analysis_NumberAnalysisINTEGERNo
Analysis_ToolAnalysisCHARACTER VARYINGNo
Analysis_Tool_DescriptionAnalysisCHARACTER VARYINGNo
Analysis_Tool_TypeAnalysisCHARACTER VARYINGNo
Analysis_Tool_VersionAnalysisCHARACTER VARYINGNo
Analysis_TypeAnalysisCHARACTER VARYINGNo
ArrayExpress_Accession_NumPlatform_StudyCHARACTER VARYINGNo
Biological_SourceSampleCHARACTER VARYINGNo
Calculated_FrequencyVariant_TypeINTEGERNo
Calc_Frequency_QualifierVariant_TypeCHARACTER VARYINGNo
Case_or_ControlSample_StudyCHARACTER VARYINGNo
ChromosomeCoverageCHARACTER VARYINGNo
Chromosome_LengthCoverageBIGINTNo
Chromosome_NumberTranslocation_MappingCHARACTER VARYINGNo
Chromosome_NumberVariant_MappingCHARACTER VARYINGNo
Chromosome_Random_NumTranslocation_MappingCHARACTER VARYINGNo
Chromosome_Random_NumVariant_MappingCHARACTER VARYINGNo
Cohort_DescriptionCohortCHARACTER VARYINGNo
Cohort_IDSampleFKINTEGERNo
Cohort_IDCohortPKSERIALYes
Cohort_NameVariantCHARACTER VARYINGNo
Cohort_NameSample_XrefCHARACTER VARYINGNo
Cohort_NameCohortCHARACTER VARYINGNo
CommentsVariantCHARACTER VARYINGNo
CommentsVariant_TypeCHARACTER VARYINGNo
Copy_ChromosomeCopy_NumberCHARACTER VARYINGNo
Copy_DescriptionCopy_NumberCHARACTER VARYINGNo
Copy_EndCopy_NumberCHARACTER VARYINGNo
Copy_NumberCopy_NumberCHARACTER VARYINGYes
Copy_Number_CountVariant_TypeINTEGERNo
Copy_Number_IDCopy_NumberPKSERIALYes
Copy_StartCopy_NumberCHARACTER VARYINGNo
CountVariant_TypeINTEGERNo
Curation_CommentsStudyCHARACTER VARYINGNo
Current_Record_FlagStudy_File_PrefixCHARACTER VARYINGNo
Current_Record_FlagVariant_AnalysisCHARACTER VARYINGNo
Current_Record_FlagMerged_AnalysisCHARACTER VARYINGNo
Current_Record_FlagTranslocation_MappingCHARACTER VARYINGNo
Current_Record_FlagFilterCHARACTER VARYINGNo
Current_Record_FlagSample_XrefCHARACTER VARYINGNo
Current_Record_FlagDataset_XrefCHARACTER VARYINGNo
Current_Record_FlagVariant_XrefCHARACTER VARYINGNo
Current_Record_FlagSample_PooledCHARACTER VARYINGNo
Current_Record_FlagVariant_MappingCHARACTER VARYINGNo
Current_Record_FlagCopy_NumberCHARACTER VARYINGNo
Current_Record_FlagStudyCHARACTER VARYINGNo
Current_Record_FlagPlatform_StudyCHARACTER VARYINGNo
Current_Record_FlagMethod_StudyCHARACTER VARYINGNo
Current_Record_FlagReferenceCHARACTER VARYINGNo
Current_Record_FlagVariantCHARACTER VARYINGNo
Current_Record_FlagDataset_AnalysisCHARACTER VARYINGNo
Current_Record_FlagCohortCHARACTER VARYINGNo
Current_Record_FlagAnalysisCHARACTER VARYINGNo
Current_Record_FlagDatasetCHARACTER VARYINGNo
Current_Record_FlagMethod_Platform_SampleCHARACTER VARYINGNo
Current_Record_FlagVariant_TypeCHARACTER VARYINGNo
Current_Record_FlagSupporting_Merged_VariantCHARACTER VARYINGNo
Current_Record_FlagSample_StudyCHARACTER VARYINGNo
Current_Record_FlagSampleCHARACTER VARYINGNo
CytobandCytoband_OverlapCHARACTER VARYINGNo
Dataset_Analysis_IDVariant_AnalysisFKINTEGERYes
Dataset_Analysis_IDDataset_AnalysisPKSERIALYes
Dataset_Analysis_NumberDataset_AnalysisINTEGERYes
Dataset_DescriptionDatasetCHARACTER VARYINGNo
Dataset_IDDataset_XrefFKINTEGERYes
Dataset_IDReferenceFKINTEGERYes
Dataset_IDDataset_AnalysisFKINTEGERYes
Dataset_IDDatasetPKSERIALYes
Dataset_IDMethod_Platform_SampleFKINTEGERYes
Dataset_NameDatasetCHARACTER VARYINGNo
Dataset_NumberDatasetINTEGERNo
Dataset_Xref_IDDataset_XrefPKSERIALYes
DescriptionStudyCHARACTER VARYINGNo
DGVA_Inferred_FlagVariantCHARACTER VARYINGNo
DGV_Calculated_SizeTranslocation_MappingINTEGERNo
DGV_Calculated_SizeVariant_MappingINTEGERNo
DGV_EndTranslocation_MappingINTEGERNo
DGV_EndVariant_MappingINTEGERNo
DGV_Merged_FlagVariantCHARACTER VARYINGNo
DGV_StartTranslocation_MappingINTEGERNo
DGV_StartVariant_MappingINTEGERNo
Display_NameStudyCHARACTER VARYINGYes
End_AVariant_MappingINTEGERNo
End_BTranslocation_MappingINTEGERNo
End_RandomTranslocation_MappingCHARACTER VARYINGNo
End_RandomVariant_MappingCHARACTER VARYINGNo
Estimated_SizeTranslocation_MappingINTEGERNo
Estimated_SizeVariant_MappingINTEGERNo
EthnicitySampleCHARACTER VARYINGNo
EthnicityVariantCHARACTER VARYINGNo
External_Dataset_IDDataset_XrefCHARACTER VARYINGYes
External_ID_SourceSample_XrefCHARACTER VARYINGYes
External_ID_SourceDataset_XrefCHARACTER VARYINGYes
External_ID_SourceVariant_XrefCHARACTER VARYINGYes
External_ID_TypeSample_XrefCHARACTER VARYINGNo
External_ID_TypeVariant_XrefCHARACTER VARYINGNo
External_Sample_IDSample_XrefCHARACTER VARYINGYes
External_Variant_IDVariant_XrefCHARACTER VARYINGYes
Family_IDSampleCHARACTER VARYINGNo
Family_MemberSampleCHARACTER VARYINGNo
Family_TypeSampleCHARACTER VARYINGNo
Father_IDSampleCHARACTER VARYINGNo
FeatureFeature_OverlapCHARACTER VARYINGNo
Filter_IDFilterPKSERIALYes
Filter_ReasonFilterCHARACTER VARYINGYes
Filter_StepFilterINTEGERYes
GenderSampleCHARACTER VARYINGNo
GenderVariantCHARACTER VARYINGNo
GeneGene_OverlapCHARACTER VARYINGNo
GenotypeVariant_TypeCHARACTER VARYINGNo
GEO_Accession_NumPlatform_StudyCHARACTER VARYINGNo
Hold_Until_Publication_FlagStudyCHARACTER VARYINGNo
IDCytoband_OverlapPKSERIALYes
IDGene_OverlapPKSERIALYes
IDCoveragePKSERIALYes
IDFeature_OverlapPKSERIALYes
Individual_Sample_IDSample_PooledFKINTEGERYes
InheritanceVariantCHARACTER VARYINGNo
Inner_End_AVariant_MappingINTEGERNo
Inner_End_BTranslocation_MappingINTEGERNo
Inner_Start_AVariant_MappingINTEGERNo
Inner_Start_BTranslocation_MappingINTEGERNo
KaryotypeSampleCHARACTER VARYINGNo
LandmarkVariantCHARACTER VARYINGNo
Load_DateStudy_File_PrefixTIMESTAMPYes
Load_DateVariant_AnalysisTIMESTAMPYes
Load_DateMerged_AnalysisTIMESTAMPYes
Load_DateReference_AssemblyTIMESTAMPNo
Load_DateAnalysisTIMESTAMPYes
Load_DateCytoband_OverlapTIMESTAMPNo
Load_DateMethod_Platform_SampleTIMESTAMPYes
Load_DateGene_OverlapTIMESTAMPNo
Load_DateCoverageTIMESTAMPNo
Load_DateDatasetTIMESTAMPYes
Load_DateFeature_OverlapTIMESTAMPNo
Load_DateSampleTIMESTAMPYes
Load_DateCohortTIMESTAMPYes
Load_DateDataset_AnalysisTIMESTAMPYes
Load_DateTranslocation_MappingTIMESTAMPNo
Load_DateVariantTIMESTAMPYes
Load_DateSample_StudyTIMESTAMPYes
Load_DateFilterTIMESTAMPYes
Load_DateSample_XrefTIMESTAMPYes
Load_DateDataset_XrefTIMESTAMPYes
Load_DateVariant_XrefTIMESTAMPYes
Load_DateVariant_TypeTIMESTAMPYes
Load_DateSample_PooledTIMESTAMPYes
Load_DateVariant_MappingTIMESTAMPNo
Load_DateReferenceTIMESTAMPYes
Load_DateCopy_NumberTIMESTAMPYes
Load_DateStudyTIMESTAMPYes
Load_DateSupporting_Merged_VariantTIMESTAMPYes
Load_DatePlatform_StudyTIMESTAMPYes
Load_DateMethod_StudyTIMESTAMPYes
Merged_Analysis_IDMerged_AnalysisPKSERIALYes
Merged_IDSupporting_Merged_VariantFKINTEGERYes
Merging_CriteriaVariantTEXTNo
Method_DescriptionMethod_StudyCHARACTER VARYINGNo
Method_NameMethod_StudyCHARACTER VARYINGNo
Method_NumberMethod_StudyINTEGERNo
Method_Platform_Sample_IDMethod_Platform_SamplePKSERIALYes
Method_Study_IDMethod_Platform_SampleFKINTEGERYes
Method_Study_IDMethod_StudyPKSERIALYes
Method_TypeMethod_StudyCHARACTER VARYINGNo
Mother_IDSampleCHARACTER VARYINGNo
NCBI_Tax_IDStudyINTEGERNo
Nucleotides_CoveredCoverageBIGINTNo
Number_of_CNVs_OverlappedFeature_OverlapINTEGERNo
Number_of_FeaturesFeature_OverlapINTEGERNo
Number_of_Features_OverlappedFeature_OverlapINTEGERNo
Number_of_GainsVariant_TypeINTEGERNo
Number_of_Gains_and_LossesVariant_TypeINTEGERNo
Number_of_LossesVariant_TypeINTEGERNo
OneK_Genomes_ProjectStudyCHARACTER VARYINGNo
Original_MethodMethod_StudyCHARACTER VARYINGNo
Originators_of_DataMethod_StudyCHARACTER VARYINGNo
Outer_End_AVariant_MappingINTEGERNo
Outer_End_BTranslocation_MappingINTEGERNo
Outer_Start_AVariant_MappingINTEGERNo
Outer_Start_BTranslocation_MappingINTEGERNo
Percent_CoverageCoverageDOUBLE PRECISIONNo
Percent_of_CNVs_OverlappedFeature_OverlapDOUBLE PRECISIONNo
Percent_of_Features_OverlappedFeature_OverlapDOUBLE PRECISIONNo
Placement_MethodTranslocation_MappingCHARACTER VARYINGNo
Placement_MethodVariant_MappingCHARACTER VARYINGNo
Platform_DescriptionPlatform_StudyCHARACTER VARYINGNo
Platform_NameVariantCHARACTER VARYINGNo
Platform_NamePlatform_StudyCHARACTER VARYINGNo
Platform_NumberPlatform_StudyINTEGERNo
Platform_Study_IDPlatform_StudyPKSERIALYes
Platform_Study_IDMethod_Platform_SampleFKINTEGERYes
Platform_TypePlatform_StudyCHARACTER VARYINGNo
Platform_VersionPlatform_StudyCHARACTER VARYINGNo
Pooled_Sample_IDSample_PooledFKINTEGERYes
Primary_Author_IDStudyCHARACTER VARYINGNo
Primary_Author_NameStudyCHARACTER VARYINGNo
Primary_Data_FlagMethod_StudyCHARACTER VARYINGNo
Principal_InvestigatorStudyCHARACTER VARYINGNo
Probe_CountVariantINTEGERNo
Project_IDStudyCHARACTER VARYINGNo
Publish_DateStudyTIMESTAMPNo
PubMed_IDStudyINTEGERNo
RecipientVariant_MappingCHARACTER VARYINGNo
RecipientTranslocation_MappingCHARACTER VARYINGNo
Reference_AssemblyCytoband_OverlapCHARACTER VARYINGNo
Reference_AssemblyGene_OverlapCHARACTER VARYINGNo
Reference_AssemblyCoverageCHARACTER VARYINGNo
Reference_AssemblyFeature_OverlapCHARACTER VARYINGNo
Reference_AssemblyVariant_MappingCHARACTER VARYINGNo
Reference_AssemblyTranslocation_MappingCHARACTER VARYINGYes
Reference_Assembly_IDReference_AssemblyPKSERIALYes
Reference_Assembly_NameReference_AssemblyCHARACTER VARYINGNo
Reference_DescriptionReferenceCHARACTER VARYINGNo
Reference_IDDataset_AnalysisFKINTEGERYes
Reference_IDReferencePKSERIALYes
Reference_NumberReferenceINTEGERYes
Reference_Sample_IDReferenceCHARACTER VARYINGNo
Reference_SequenceReferenceCHARACTER VARYINGNo
Reference_TypeReferenceCHARACTER VARYINGNo
Remap_StatusVariant_MappingCHARACTER VARYINGNo
Remap_StatusTranslocation_MappingCHARACTER VARYINGNo
Reported_FrequencyVariant_TypeNUMERICNo
Run_IDFilterINTEGERYes
Sample_DescriptionSampleCHARACTER VARYINGNo
Sample_IDSamplePKSERIALYes
Sample_IDSample_StudyFKINTEGERYes
Sample_IDSample_XrefFKINTEGERYes
Sample_Merged_FlagVariantCHARACTER VARYINGYes
Sample_NumberSample_StudyINTEGERNo
Sample_Pooled_IDSample_PooledPKSERIALYes
Sample_SizeStudyINTEGERNo
Sample_Study_IDSample_StudyPKSERIALYes
Sample_Study_IDVariantINTEGERNo
Sample_Study_IDMethod_Platform_SampleFKINTEGERYes
Sample_Xref_IDSample_XrefPKSERIALYes
SequenceVariantCHARACTER VARYINGNo
SiteStudyCHARACTER VARYINGNo
SizeVariant_MappingINTEGERNo
SizeTranslocation_MappingINTEGERNo
Source_SystemStudy_File_PrefixCHARACTER VARYINGYes
Source_SystemReferenceCHARACTER VARYINGYes
Source_SystemAnalysisCHARACTER VARYINGYes
Source_SystemVariant_AnalysisCHARACTER VARYINGYes
Source_SystemVariantCHARACTER VARYINGYes
Source_SystemSample_XrefCHARACTER VARYINGYes
Source_SystemMerged_AnalysisCHARACTER VARYINGYes
Source_SystemMethod_StudyCHARACTER VARYINGYes
Source_SystemStudyCHARACTER VARYINGYes
Source_SystemDatasetCHARACTER VARYINGYes
Source_SystemSampleCHARACTER VARYINGYes
Source_SystemCopy_NumberCHARACTER VARYINGYes
Source_SystemDataset_AnalysisCHARACTER VARYINGYes
Source_SystemPlatform_StudyCHARACTER VARYINGYes
Source_SystemMethod_Platform_SampleCHARACTER VARYINGYes
Source_SystemSample_PooledCHARACTER VARYINGYes
Source_SystemDataset_XrefCHARACTER VARYINGYes
Source_SystemTranslocation_MappingCHARACTER VARYINGNo
Source_SystemCohortCHARACTER VARYINGYes
Source_SystemVariant_MappingCHARACTER VARYINGNo
Source_SystemSupporting_Merged_VariantCHARACTER VARYINGYes
Source_SystemVariant_XrefCHARACTER VARYINGYes
Source_SystemSample_StudyCHARACTER VARYINGYes
Source_SystemVariant_TypeCHARACTER VARYINGYes
Source_TypeSampleCHARACTER VARYINGNo
SpanVariant_MappingINTEGERNo
SpanTranslocation_MappingINTEGERNo
Start_AVariant_MappingINTEGERNo
Start_BTranslocation_MappingINTEGERNo
Start_RandomVariant_MappingCHARACTER VARYINGNo
Start_RandomTranslocation_MappingCHARACTER VARYINGNo
Study_AccessionStudyCHARACTER VARYINGNo
Study_File_PrefixStudy_File_PrefixCHARACTER VARYINGYes
Study_File_Prefix_IDStudy_File_PrefixPKSERIALYes
Study_IDVariant_TypeINTEGERYes
Study_IDSample_StudyFKINTEGERYes
Study_IDStudy_File_PrefixINTEGERYes
Study_IDCopy_NumberINTEGERYes
Study_IDSample_XrefINTEGERNo
Study_IDVariant_AnalysisINTEGERYes
Study_IDVariant_XrefINTEGERYes
Study_IDStudyPKSERIALYes
Study_IDTranslocation_MappingINTEGERYes
Study_IDMethod_Platform_SampleINTEGERYes
Study_IDMerged_AnalysisINTEGERYes
Study_IDSample_PooledINTEGERYes
Study_IDVariantINTEGERNo
Study_IDPlatform_StudyFKINTEGERYes
Study_IDReferenceFKINTEGERYes
Study_IDFilterINTEGERYes
Study_IDSupporting_Merged_VariantINTEGERYes
Study_IDAnalysisFKINTEGERYes
Study_IDMethod_StudyFKINTEGERYes
Study_IDVariant_MappingINTEGERNo
Study_IDDataset_XrefINTEGERYes
Study_IDDataset_AnalysisFKINTEGERYes
Study_IDDatasetFKINTEGERNo
Study_MappingTranslocation_MappingCHARACTER VARYINGYes
Study_MappingVariant_MappingCHARACTER VARYINGYes
Subject_IDSampleCHARACTER VARYINGNo
Sub_Analysis_IDMerged_AnalysisFKINTEGERYes
Super_Analysis_IDMerged_AnalysisFKINTEGERYes
Supporting_Merged_Variant_IDSupporting_Merged_VariantPKSERIALYes
Supporting_Variant_IDSupporting_Merged_VariantFKINTEGERYes
Table_IDFilterINTEGERYes
Table_NameFilterCHARACTER VARYINGYes
Total_ReportingVariant_TypeINTEGERNo
Translocation_Mapping_IDTranslocation_MappingPKSERIALYes
Unmapped_FlagTranslocation_MappingCHARACTER VARYINGNo
Unmapped_FlagVariant_MappingCHARACTER VARYINGNo
Validation_FlagVariantCHARACTER VARYINGNo
Validation_MethodVariantCHARACTER VARYINGNo
Validation_Platform_NameVariantCHARACTER VARYINGNo
Variant_Analysis_IDVariant_AnalysisPKSERIALYes
Variant_CountStudyINTEGERNo
Variant_IDVariantPKSERIALYes
Variant_IDCytoband_OverlapINTEGERNo
Variant_IDVariant_XrefFKINTEGERYes
Variant_IDVariant_MappingFKINTEGERYes
Variant_IDVariant_TypeFKINTEGERYes
Variant_IDTranslocation_MappingFKINTEGERYes
Variant_IDVariant_AnalysisFKINTEGERYes
Variant_IDGene_OverlapINTEGERNo
Variant_Mapping_IDVariant_MappingPKSERIALYes
Variant_NumberVariantINTEGERYes
Variant_NumberTranslocation_MappingINTEGERYes
Variant_NumberVariant_MappingINTEGERNo
Variant_Sub_TypeVariant_TypeCHARACTER VARYINGNo
Variant_TypeVariant_TypeCHARACTER VARYINGYes
Variant_Type_DescriptionVariant_TypeCHARACTER VARYINGNo
Variant_Type_IDCopy_NumberFKINTEGERYes
Variant_Type_IDVariant_TypePKSERIALYes
Variant_Xref_IDVariant_XrefPKSERIALYes
ZygosityVariant_TypeCHARACTER VARYINGNo