DeZign for Databases v5.2

Logical model

List of attributes

Attribute name	Entity name	Key	Data type	Not null
Analysis_Criteria	Analysis		CHARACTER VARYING	No
Analysis_Description	Analysis		CHARACTER VARYING	No
Analysis_ID	Dataset_Analysis	FK	INTEGER	Yes
Analysis_ID	Analysis	PK	SERIAL	Yes
Analysis_Number	Analysis		INTEGER	No
Analysis_Tool	Analysis		CHARACTER VARYING	No
Analysis_Tool_Description	Analysis		CHARACTER VARYING	No
Analysis_Tool_Type	Analysis		CHARACTER VARYING	No
Analysis_Tool_Version	Analysis		CHARACTER VARYING	No
Analysis_Type	Analysis		CHARACTER VARYING	No
ArrayExpress_Accession_Num	Platform_Study		CHARACTER VARYING	No
Biological_Source	Sample		CHARACTER VARYING	No
Calculated_Frequency	Variant_Type		INTEGER	No
Calc_Frequency_Qualifier	Variant_Type		CHARACTER VARYING	No
Case_or_Control	Sample_Study		CHARACTER VARYING	No
Chromosome	Coverage		CHARACTER VARYING	No
Chromosome_Length	Coverage		BIGINT	No
Chromosome_Number	Translocation_Mapping		CHARACTER VARYING	No
Chromosome_Number	Variant_Mapping		CHARACTER VARYING	No
Chromosome_Random_Num	Translocation_Mapping		CHARACTER VARYING	No
Chromosome_Random_Num	Variant_Mapping		CHARACTER VARYING	No
Cohort_Description	Cohort		CHARACTER VARYING	No
Cohort_ID	Sample	FK	INTEGER	No
Cohort_ID	Cohort	PK	SERIAL	Yes
Cohort_Name	Variant		CHARACTER VARYING	No
Cohort_Name	Sample_Xref		CHARACTER VARYING	No
Cohort_Name	Cohort		CHARACTER VARYING	No
Comments	Variant		CHARACTER VARYING	No
Comments	Variant_Type		CHARACTER VARYING	No
Copy_Chromosome	Copy_Number		CHARACTER VARYING	No
Copy_Description	Copy_Number		CHARACTER VARYING	No
Copy_End	Copy_Number		CHARACTER VARYING	No
Copy_Number	Copy_Number		CHARACTER VARYING	Yes
Copy_Number_Count	Variant_Type		INTEGER	No
Copy_Number_ID	Copy_Number	PK	SERIAL	Yes
Copy_Start	Copy_Number		CHARACTER VARYING	No
Count	Variant_Type		INTEGER	No
Curation_Comments	Study		CHARACTER VARYING	No
Current_Record_Flag	Study_File_Prefix		CHARACTER VARYING	No
Current_Record_Flag	Variant_Analysis		CHARACTER VARYING	No
Current_Record_Flag	Merged_Analysis		CHARACTER VARYING	No
Current_Record_Flag	Translocation_Mapping		CHARACTER VARYING	No
Current_Record_Flag	Filter		CHARACTER VARYING	No
Current_Record_Flag	Sample_Xref		CHARACTER VARYING	No
Current_Record_Flag	Dataset_Xref		CHARACTER VARYING	No
Current_Record_Flag	Variant_Xref		CHARACTER VARYING	No
Current_Record_Flag	Sample_Pooled		CHARACTER VARYING	No
Current_Record_Flag	Variant_Mapping		CHARACTER VARYING	No
Current_Record_Flag	Copy_Number		CHARACTER VARYING	No
Current_Record_Flag	Study		CHARACTER VARYING	No
Current_Record_Flag	Platform_Study		CHARACTER VARYING	No
Current_Record_Flag	Method_Study		CHARACTER VARYING	No
Current_Record_Flag	Reference		CHARACTER VARYING	No
Current_Record_Flag	Variant		CHARACTER VARYING	No
Current_Record_Flag	Dataset_Analysis		CHARACTER VARYING	No
Current_Record_Flag	Cohort		CHARACTER VARYING	No
Current_Record_Flag	Analysis		CHARACTER VARYING	No
Current_Record_Flag	Dataset		CHARACTER VARYING	No
Current_Record_Flag	Method_Platform_Sample		CHARACTER VARYING	No
Current_Record_Flag	Variant_Type		CHARACTER VARYING	No
Current_Record_Flag	Supporting_Merged_Variant		CHARACTER VARYING	No
Current_Record_Flag	Sample_Study		CHARACTER VARYING	No
Current_Record_Flag	Sample		CHARACTER VARYING	No
Cytoband	Cytoband_Overlap		CHARACTER VARYING	No
Dataset_Analysis_ID	Variant_Analysis	FK	INTEGER	Yes
Dataset_Analysis_ID	Dataset_Analysis	PK	SERIAL	Yes
Dataset_Analysis_Number	Dataset_Analysis		INTEGER	Yes
Dataset_Description	Dataset		CHARACTER VARYING	No
Dataset_ID	Dataset_Xref	FK	INTEGER	Yes
Dataset_ID	Reference	FK	INTEGER	Yes
Dataset_ID	Dataset_Analysis	FK	INTEGER	Yes
Dataset_ID	Dataset	PK	SERIAL	Yes
Dataset_ID	Method_Platform_Sample	FK	INTEGER	Yes
Dataset_Name	Dataset		CHARACTER VARYING	No
Dataset_Number	Dataset		INTEGER	No
Dataset_Xref_ID	Dataset_Xref	PK	SERIAL	Yes
Description	Study		CHARACTER VARYING	No
DGVA_Inferred_Flag	Variant		CHARACTER VARYING	No
DGV_Calculated_Size	Translocation_Mapping		INTEGER	No
DGV_Calculated_Size	Variant_Mapping		INTEGER	No
DGV_End	Translocation_Mapping		INTEGER	No
DGV_End	Variant_Mapping		INTEGER	No
DGV_Merged_Flag	Variant		CHARACTER VARYING	No
DGV_Start	Translocation_Mapping		INTEGER	No
DGV_Start	Variant_Mapping		INTEGER	No
Display_Name	Study		CHARACTER VARYING	Yes
End_A	Variant_Mapping		INTEGER	No
End_B	Translocation_Mapping		INTEGER	No
End_Random	Translocation_Mapping		CHARACTER VARYING	No
End_Random	Variant_Mapping		CHARACTER VARYING	No
Estimated_Size	Translocation_Mapping		INTEGER	No
Estimated_Size	Variant_Mapping		INTEGER	No
Ethnicity	Sample		CHARACTER VARYING	No
Ethnicity	Variant		CHARACTER VARYING	No
External_Dataset_ID	Dataset_Xref		CHARACTER VARYING	Yes
External_ID_Source	Sample_Xref		CHARACTER VARYING	Yes
External_ID_Source	Dataset_Xref		CHARACTER VARYING	Yes
External_ID_Source	Variant_Xref		CHARACTER VARYING	Yes
External_ID_Type	Sample_Xref		CHARACTER VARYING	No
External_ID_Type	Variant_Xref		CHARACTER VARYING	No
External_Sample_ID	Sample_Xref		CHARACTER VARYING	Yes
External_Variant_ID	Variant_Xref		CHARACTER VARYING	Yes
Family_ID	Sample		CHARACTER VARYING	No
Family_Member	Sample		CHARACTER VARYING	No
Family_Type	Sample		CHARACTER VARYING	No
Father_ID	Sample		CHARACTER VARYING	No
Feature	Feature_Overlap		CHARACTER VARYING	No
Filter_ID	Filter	PK	SERIAL	Yes
Filter_Reason	Filter		CHARACTER VARYING	Yes
Filter_Step	Filter		INTEGER	Yes
Gender	Sample		CHARACTER VARYING	No
Gender	Variant		CHARACTER VARYING	No
Gene	Gene_Overlap		CHARACTER VARYING	No
Genotype	Variant_Type		CHARACTER VARYING	No
GEO_Accession_Num	Platform_Study		CHARACTER VARYING	No
Hold_Until_Publication_Flag	Study		CHARACTER VARYING	No
ID	Cytoband_Overlap	PK	SERIAL	Yes
ID	Gene_Overlap	PK	SERIAL	Yes
ID	Coverage	PK	SERIAL	Yes
ID	Feature_Overlap	PK	SERIAL	Yes
Individual_Sample_ID	Sample_Pooled	FK	INTEGER	Yes
Inheritance	Variant		CHARACTER VARYING	No
Inner_End_A	Variant_Mapping		INTEGER	No
Inner_End_B	Translocation_Mapping		INTEGER	No
Inner_Start_A	Variant_Mapping		INTEGER	No
Inner_Start_B	Translocation_Mapping		INTEGER	No
Karyotype	Sample		CHARACTER VARYING	No
Landmark	Variant		CHARACTER VARYING	No
Load_Date	Study_File_Prefix		TIMESTAMP	Yes
Load_Date	Variant_Analysis		TIMESTAMP	Yes
Load_Date	Merged_Analysis		TIMESTAMP	Yes
Load_Date	Reference_Assembly		TIMESTAMP	No
Load_Date	Analysis		TIMESTAMP	Yes
Load_Date	Cytoband_Overlap		TIMESTAMP	No
Load_Date	Method_Platform_Sample		TIMESTAMP	Yes
Load_Date	Gene_Overlap		TIMESTAMP	No
Load_Date	Coverage		TIMESTAMP	No
Load_Date	Dataset		TIMESTAMP	Yes
Load_Date	Feature_Overlap		TIMESTAMP	No
Load_Date	Sample		TIMESTAMP	Yes
Load_Date	Cohort		TIMESTAMP	Yes
Load_Date	Dataset_Analysis		TIMESTAMP	Yes
Load_Date	Translocation_Mapping		TIMESTAMP	No
Load_Date	Variant		TIMESTAMP	Yes
Load_Date	Sample_Study		TIMESTAMP	Yes
Load_Date	Filter		TIMESTAMP	Yes
Load_Date	Sample_Xref		TIMESTAMP	Yes
Load_Date	Dataset_Xref		TIMESTAMP	Yes
Load_Date	Variant_Xref		TIMESTAMP	Yes
Load_Date	Variant_Type		TIMESTAMP	Yes
Load_Date	Sample_Pooled		TIMESTAMP	Yes
Load_Date	Variant_Mapping		TIMESTAMP	No
Load_Date	Reference		TIMESTAMP	Yes
Load_Date	Copy_Number		TIMESTAMP	Yes
Load_Date	Study		TIMESTAMP	Yes
Load_Date	Supporting_Merged_Variant		TIMESTAMP	Yes
Load_Date	Platform_Study		TIMESTAMP	Yes
Load_Date	Method_Study		TIMESTAMP	Yes
Merged_Analysis_ID	Merged_Analysis	PK	SERIAL	Yes
Merged_ID	Supporting_Merged_Variant	FK	INTEGER	Yes
Merging_Criteria	Variant		TEXT	No
Method_Description	Method_Study		CHARACTER VARYING	No
Method_Name	Method_Study		CHARACTER VARYING	No
Method_Number	Method_Study		INTEGER	No
Method_Platform_Sample_ID	Method_Platform_Sample	PK	SERIAL	Yes
Method_Study_ID	Method_Platform_Sample	FK	INTEGER	Yes
Method_Study_ID	Method_Study	PK	SERIAL	Yes
Method_Type	Method_Study		CHARACTER VARYING	No
Mother_ID	Sample		CHARACTER VARYING	No
NCBI_Tax_ID	Study		INTEGER	No
Nucleotides_Covered	Coverage		BIGINT	No
Number_of_CNVs_Overlapped	Feature_Overlap		INTEGER	No
Number_of_Features	Feature_Overlap		INTEGER	No
Number_of_Features_Overlapped	Feature_Overlap		INTEGER	No
Number_of_Gains	Variant_Type		INTEGER	No
Number_of_Gains_and_Losses	Variant_Type		INTEGER	No
Number_of_Losses	Variant_Type		INTEGER	No
OneK_Genomes_Project	Study		CHARACTER VARYING	No
Original_Method	Method_Study		CHARACTER VARYING	No
Originators_of_Data	Method_Study		CHARACTER VARYING	No
Outer_End_A	Variant_Mapping		INTEGER	No
Outer_End_B	Translocation_Mapping		INTEGER	No
Outer_Start_A	Variant_Mapping		INTEGER	No
Outer_Start_B	Translocation_Mapping		INTEGER	No
Percent_Coverage	Coverage		DOUBLE PRECISION	No
Percent_of_CNVs_Overlapped	Feature_Overlap		DOUBLE PRECISION	No
Percent_of_Features_Overlapped	Feature_Overlap		DOUBLE PRECISION	No
Placement_Method	Translocation_Mapping		CHARACTER VARYING	No
Placement_Method	Variant_Mapping		CHARACTER VARYING	No
Platform_Description	Platform_Study		CHARACTER VARYING	No
Platform_Name	Variant		CHARACTER VARYING	No
Platform_Name	Platform_Study		CHARACTER VARYING	No
Platform_Number	Platform_Study		INTEGER	No
Platform_Study_ID	Platform_Study	PK	SERIAL	Yes
Platform_Study_ID	Method_Platform_Sample	FK	INTEGER	Yes
Platform_Type	Platform_Study		CHARACTER VARYING	No
Platform_Version	Platform_Study		CHARACTER VARYING	No
Pooled_Sample_ID	Sample_Pooled	FK	INTEGER	Yes
Primary_Author_ID	Study		CHARACTER VARYING	No
Primary_Author_Name	Study		CHARACTER VARYING	No
Primary_Data_Flag	Method_Study		CHARACTER VARYING	No
Principal_Investigator	Study		CHARACTER VARYING	No
Probe_Count	Variant		INTEGER	No
Project_ID	Study		CHARACTER VARYING	No
Publish_Date	Study		TIMESTAMP	No
PubMed_ID	Study		INTEGER	No
Recipient	Variant_Mapping		CHARACTER VARYING	No
Recipient	Translocation_Mapping		CHARACTER VARYING	No
Reference_Assembly	Cytoband_Overlap		CHARACTER VARYING	No
Reference_Assembly	Gene_Overlap		CHARACTER VARYING	No
Reference_Assembly	Coverage		CHARACTER VARYING	No
Reference_Assembly	Feature_Overlap		CHARACTER VARYING	No
Reference_Assembly	Variant_Mapping		CHARACTER VARYING	No
Reference_Assembly	Translocation_Mapping		CHARACTER VARYING	Yes
Reference_Assembly_ID	Reference_Assembly	PK	SERIAL	Yes
Reference_Assembly_Name	Reference_Assembly		CHARACTER VARYING	No
Reference_Description	Reference		CHARACTER VARYING	No
Reference_ID	Dataset_Analysis	FK	INTEGER	Yes
Reference_ID	Reference	PK	SERIAL	Yes
Reference_Number	Reference		INTEGER	Yes
Reference_Sample_ID	Reference		CHARACTER VARYING	No
Reference_Sequence	Reference		CHARACTER VARYING	No
Reference_Type	Reference		CHARACTER VARYING	No
Remap_Status	Variant_Mapping		CHARACTER VARYING	No
Remap_Status	Translocation_Mapping		CHARACTER VARYING	No
Reported_Frequency	Variant_Type		NUMERIC	No
Run_ID	Filter		INTEGER	Yes
Sample_Description	Sample		CHARACTER VARYING	No
Sample_ID	Sample	PK	SERIAL	Yes
Sample_ID	Sample_Study	FK	INTEGER	Yes
Sample_ID	Sample_Xref	FK	INTEGER	Yes
Sample_Merged_Flag	Variant		CHARACTER VARYING	Yes
Sample_Number	Sample_Study		INTEGER	No
Sample_Pooled_ID	Sample_Pooled	PK	SERIAL	Yes
Sample_Size	Study		INTEGER	No
Sample_Study_ID	Sample_Study	PK	SERIAL	Yes
Sample_Study_ID	Variant		INTEGER	No
Sample_Study_ID	Method_Platform_Sample	FK	INTEGER	Yes
Sample_Xref_ID	Sample_Xref	PK	SERIAL	Yes
Sequence	Variant		CHARACTER VARYING	No
Site	Study		CHARACTER VARYING	No
Size	Variant_Mapping		INTEGER	No
Size	Translocation_Mapping		INTEGER	No
Source_System	Study_File_Prefix		CHARACTER VARYING	Yes
Source_System	Reference		CHARACTER VARYING	Yes
Source_System	Analysis		CHARACTER VARYING	Yes
Source_System	Variant_Analysis		CHARACTER VARYING	Yes
Source_System	Variant		CHARACTER VARYING	Yes
Source_System	Sample_Xref		CHARACTER VARYING	Yes
Source_System	Merged_Analysis		CHARACTER VARYING	Yes
Source_System	Method_Study		CHARACTER VARYING	Yes
Source_System	Study		CHARACTER VARYING	Yes
Source_System	Dataset		CHARACTER VARYING	Yes
Source_System	Sample		CHARACTER VARYING	Yes
Source_System	Copy_Number		CHARACTER VARYING	Yes
Source_System	Dataset_Analysis		CHARACTER VARYING	Yes
Source_System	Platform_Study		CHARACTER VARYING	Yes
Source_System	Method_Platform_Sample		CHARACTER VARYING	Yes
Source_System	Sample_Pooled		CHARACTER VARYING	Yes
Source_System	Dataset_Xref		CHARACTER VARYING	Yes
Source_System	Translocation_Mapping		CHARACTER VARYING	No
Source_System	Cohort		CHARACTER VARYING	Yes
Source_System	Variant_Mapping		CHARACTER VARYING	No
Source_System	Supporting_Merged_Variant		CHARACTER VARYING	Yes
Source_System	Variant_Xref		CHARACTER VARYING	Yes
Source_System	Sample_Study		CHARACTER VARYING	Yes
Source_System	Variant_Type		CHARACTER VARYING	Yes
Source_Type	Sample		CHARACTER VARYING	No
Span	Variant_Mapping		INTEGER	No
Span	Translocation_Mapping		INTEGER	No
Start_A	Variant_Mapping		INTEGER	No
Start_B	Translocation_Mapping		INTEGER	No
Start_Random	Variant_Mapping		CHARACTER VARYING	No
Start_Random	Translocation_Mapping		CHARACTER VARYING	No
Study_Accession	Study		CHARACTER VARYING	No
Study_File_Prefix	Study_File_Prefix		CHARACTER VARYING	Yes
Study_File_Prefix_ID	Study_File_Prefix	PK	SERIAL	Yes
Study_ID	Variant_Type		INTEGER	Yes
Study_ID	Sample_Study	FK	INTEGER	Yes
Study_ID	Study_File_Prefix		INTEGER	Yes
Study_ID	Copy_Number		INTEGER	Yes
Study_ID	Sample_Xref		INTEGER	No
Study_ID	Variant_Analysis		INTEGER	Yes
Study_ID	Variant_Xref		INTEGER	Yes
Study_ID	Study	PK	SERIAL	Yes
Study_ID	Translocation_Mapping		INTEGER	Yes
Study_ID	Method_Platform_Sample		INTEGER	Yes
Study_ID	Merged_Analysis		INTEGER	Yes
Study_ID	Sample_Pooled		INTEGER	Yes
Study_ID	Variant		INTEGER	No
Study_ID	Platform_Study	FK	INTEGER	Yes
Study_ID	Reference	FK	INTEGER	Yes
Study_ID	Filter		INTEGER	Yes
Study_ID	Supporting_Merged_Variant		INTEGER	Yes
Study_ID	Analysis	FK	INTEGER	Yes
Study_ID	Method_Study	FK	INTEGER	Yes
Study_ID	Variant_Mapping		INTEGER	No
Study_ID	Dataset_Xref		INTEGER	Yes
Study_ID	Dataset_Analysis	FK	INTEGER	Yes
Study_ID	Dataset	FK	INTEGER	No
Study_Mapping	Translocation_Mapping		CHARACTER VARYING	Yes
Study_Mapping	Variant_Mapping		CHARACTER VARYING	Yes
Subject_ID	Sample		CHARACTER VARYING	No
Sub_Analysis_ID	Merged_Analysis	FK	INTEGER	Yes
Super_Analysis_ID	Merged_Analysis	FK	INTEGER	Yes
Supporting_Merged_Variant_ID	Supporting_Merged_Variant	PK	SERIAL	Yes
Supporting_Variant_ID	Supporting_Merged_Variant	FK	INTEGER	Yes
Table_ID	Filter		INTEGER	Yes
Table_Name	Filter		CHARACTER VARYING	Yes
Total_Reporting	Variant_Type		INTEGER	No
Translocation_Mapping_ID	Translocation_Mapping	PK	SERIAL	Yes
Unmapped_Flag	Translocation_Mapping		CHARACTER VARYING	No
Unmapped_Flag	Variant_Mapping		CHARACTER VARYING	No
Validation_Flag	Variant		CHARACTER VARYING	No
Validation_Method	Variant		CHARACTER VARYING	No
Validation_Platform_Name	Variant		CHARACTER VARYING	No
Variant_Analysis_ID	Variant_Analysis	PK	SERIAL	Yes
Variant_Count	Study		INTEGER	No
Variant_ID	Variant	PK	SERIAL	Yes
Variant_ID	Cytoband_Overlap		INTEGER	No
Variant_ID	Variant_Xref	FK	INTEGER	Yes
Variant_ID	Variant_Mapping	FK	INTEGER	Yes
Variant_ID	Variant_Type	FK	INTEGER	Yes
Variant_ID	Translocation_Mapping	FK	INTEGER	Yes
Variant_ID	Variant_Analysis	FK	INTEGER	Yes
Variant_ID	Gene_Overlap		INTEGER	No
Variant_Mapping_ID	Variant_Mapping	PK	SERIAL	Yes
Variant_Number	Variant		INTEGER	Yes
Variant_Number	Translocation_Mapping		INTEGER	Yes
Variant_Number	Variant_Mapping		INTEGER	No
Variant_Sub_Type	Variant_Type		CHARACTER VARYING	No
Variant_Type	Variant_Type		CHARACTER VARYING	Yes
Variant_Type_Description	Variant_Type		CHARACTER VARYING	No
Variant_Type_ID	Copy_Number	FK	INTEGER	Yes
Variant_Type_ID	Variant_Type	PK	SERIAL	Yes
Variant_Xref_ID	Variant_Xref	PK	SERIAL	Yes
Zygosity	Variant_Type		CHARACTER VARYING	No