X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_9606_constraint.sql;h=396b03c95735af1688a71e6e55fb109027efde01;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=b2c9097a05e87cd7eb3959eb19e897a1edf9aec4;hpb=ea7460b34b8123c023d3f73296a9cb5f7703abbe;p=dbsnp.git

diff --git a/schema/human_9606_schema/human_9606_constraint.sql b/schema/human_9606_schema/human_9606_constraint.sql
index b2c9097..396b03c 100644
--- a/schema/human_9606_schema/human_9606_constraint.sql
+++ b/schema/human_9606_schema/human_9606_constraint.sql
@@ -1,511 +1,212 @@
-ALTER TABLE [AlleleFreqBySsPop] ADD 
-	CONSTRAINT [pk_AlleleFreqBySsPop_b129] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[pop_id],
-		[allele_id]
-	)
+ALTER TABLE [AlleleFreqBySsPop] ADD CONSTRAINT [pk_AlleleFreqBySsPop_b129]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[pop_id] ASC,[allele_id] ASC)
 GO
 
-
-ALTER TABLE [Batch] ADD 
-	CONSTRAINT [pk_Batch] PRIMARY KEY  CLUSTERED 
-	(
-		[batch_id]
-	),
-	CONSTRAINT [ck_batch_type] CHECK ([batch_type]='ANC' OR ([batch_type]='MNT' OR ([batch_type]='VAL' OR ([batch_type]='POP' OR ([batch_type]='IND' OR ([batch_type]='SNP' OR [batch_type]='NOV'))))))
+ALTER TABLE [Batch] ADD CONSTRAINT [pk_Batch]  PRIMARY KEY  CLUSTERED ([batch_id] ASC)
 GO
 
-
-ALTER TABLE [BatchCita] ADD 
-	CONSTRAINT [pk_BatchCita] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id],
-		[position]
-	)
+ALTER TABLE [BatchCita] ADD CONSTRAINT [pk_BatchCita]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC,[position] ASC)
 GO
 
-
-ALTER TABLE [BatchCommLine] ADD 
-	CONSTRAINT [pk_BatchCommLine] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id],
-		[line_num]
-	)
+ALTER TABLE [BatchCommLine] ADD CONSTRAINT [pk_BatchCommLine]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [BatchCultivar] ADD 
-	CONSTRAINT [pk_BatchCultivar] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id],
-		[line_num]
-	)
+ALTER TABLE [BatchCultivar] ADD CONSTRAINT [pk_BatchCultivar]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [BatchMeExLine] ADD 
-	CONSTRAINT [pk_BatchMeExLine] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id],
-		[line_num]
-	)
+ALTER TABLE [BatchMeExLine] ADD CONSTRAINT [pk_BatchMeExLine]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [BatchStrain] ADD 
-	CONSTRAINT [pk_BatchStrain] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id],
-		[line_num]
-	)
+ALTER TABLE [BatchStrain] ADD CONSTRAINT [pk_BatchStrain]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [BatchValCode] ADD 
-	CONSTRAINT [pk_BatchValCode] PRIMARY KEY  CLUSTERED 
-	(
-		[batch_id]
-	)
+ALTER TABLE [BatchValCode] ADD CONSTRAINT [pk_BatchValCode]  PRIMARY KEY  CLUSTERED ([batch_id] ASC)
 GO
 
-
-ALTER TABLE [Contact] ADD 
-	CONSTRAINT [pk_Contact] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id],
-		[handle]
-	)
+ALTER TABLE [ClinSigCode] ADD CONSTRAINT [DF__ClinSigCo__creat__5FBB8CD0] DEFAULT (GETDATE()) FOR [create_time]
+ALTER TABLE [ClinSigCode] ADD CONSTRAINT [DF__ClinSigCo__last___60AFB109] DEFAULT (GETDATE()) FOR [last_updated_time]
+ALTER TABLE [ClinSigCode] ADD CONSTRAINT [PK__ClinSigC__357D4CF85DD3445E]  PRIMARY KEY  CLUSTERED ([code] ASC)
 GO
 
-
-ALTER TABLE [FreqSummaryBySsPop] ADD 
-	CONSTRAINT [pk_FreqSummaryBySsPop] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[pop_id]
-	)
+ALTER TABLE [Contact] ADD CONSTRAINT [pk_Contact]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC,[handle] ASC)
 GO
 
 
-ALTER TABLE [GeneIdToName] ADD 
-	CONSTRAINT [pk_GeneIdToName] PRIMARY KEY  CLUSTERED 
-	(
-		[gene_id]
-	)
+ALTER TABLE [GeneIdToName] ADD CONSTRAINT [pk_GeneIdToName]  PRIMARY KEY  CLUSTERED ([gene_id] ASC)
 GO
 
-
-ALTER TABLE [GtyFreqBySsPop] ADD 
-	CONSTRAINT [pk_GtyFreqBySsPop_b129] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[pop_id],
-		[unigty_id]
-	)
+ALTER TABLE [GtyFreqBySsPop] ADD CONSTRAINT [pk_GtyFreqBySsPop_b129]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[pop_id] ASC,[unigty_id] ASC)
 GO
 
-
-ALTER TABLE [IndGrpCode] ADD 
-	CONSTRAINT [pk_IndGrpCode] PRIMARY KEY  CLUSTERED 
-	(
-		[code]
-	)
+ALTER TABLE [IndGrpCode] ADD CONSTRAINT [pk_IndGrpCode]  PRIMARY KEY  CLUSTERED ([code] ASC)
 GO
 
-
-ALTER TABLE [IndivBySource] ADD 
-	CONSTRAINT [pk_IndivBySource] PRIMARY KEY  NONCLUSTERED 
-	(
-		[src_id],
-		[src_ind_id]
-	)
+ALTER TABLE [IndivBySource] ADD CONSTRAINT [pk_IndivBySource]  PRIMARY KEY  NONCLUSTERED ([src_id] ASC,[src_ind_id] ASC)
 GO
 
 
-
-ALTER TABLE [Individual] ADD 
-	CONSTRAINT [pk_Individual] PRIMARY KEY  CLUSTERED 
-	(
-		[ind_id]
-	)
+ALTER TABLE [Individual] ADD CONSTRAINT [pk_Individual]  PRIMARY KEY  CLUSTERED ([ind_id] ASC)
 GO
 
-
-
-ALTER TABLE [Pedigree] ADD 
-	CONSTRAINT [p_ped_id] PRIMARY KEY  CLUSTERED 
-	(
-		[ped_id]
-	)
+ALTER TABLE [OmimVarLocusIdSNP] ADD CONSTRAINT [fk_OmimVarLocusIdSNP_snp_id] FOREIGN KEY (snp_id) REFERENCES [b134_SNP](snp_id)
 GO
 
-
-ALTER TABLE [PedigreeIndividual] ADD 
-	CONSTRAINT [pk_PedigreeIndividual] PRIMARY KEY  CLUSTERED 
-	(
-		[ped_id],
-		[ind_id]
-	)
+ALTER TABLE [Pedigree] ADD CONSTRAINT [p_ped_id]  PRIMARY KEY  CLUSTERED ([ped_id] ASC)
 GO
 
-
-ALTER TABLE [PopLine] ADD 
-	CONSTRAINT [pk_PopLine] PRIMARY KEY  CLUSTERED 
-	(
-		[pop_id],
-		[line_num]
-	)
+ALTER TABLE [PedigreeIndividual] ADD CONSTRAINT [pk_PedigreeIndividual]  PRIMARY KEY  CLUSTERED ([ped_id] ASC,[ind_id] ASC)
 GO
 
-
-ALTER TABLE [PopMandLine] ADD 
-	CONSTRAINT [pk_PopMandLine] PRIMARY KEY  NONCLUSTERED 
-	(
-		[pop_id],
-		[line_num]
-	)
+ALTER TABLE [PopLine] ADD CONSTRAINT [pk_PopLine]  PRIMARY KEY  CLUSTERED ([pop_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [Population] ADD 
-	CONSTRAINT [pk_Population_pop_id] PRIMARY KEY  CLUSTERED 
-	(
-		[pop_id]
-	)
+ALTER TABLE [PopMandLine] ADD CONSTRAINT [pk_PopMandLine]  PRIMARY KEY  NONCLUSTERED ([pop_id] ASC,[line_num] ASC)
 GO
 
+ALTER TABLE [Population] ADD CONSTRAINT [pk_Population_pop_id]  PRIMARY KEY  CLUSTERED ([pop_id] ASC)
+GO
 
 
 
 
-ALTER TABLE [SNPAlleleFreq] ADD 
-	CONSTRAINT [pk_SNPAlleleFreq] PRIMARY KEY  CLUSTERED 
-	(
-		[snp_id],
-		[allele_id]
-	)
+ALTER TABLE [SNPAlleleFreq] ADD CONSTRAINT [pk_SNPAlleleFreq]  PRIMARY KEY  CLUSTERED ([snp_id] ASC,[allele_id] ASC)
 GO
 
 
-ALTER TABLE [SNPAncestralAllele] ADD 
-	CONSTRAINT [DF__SNPAncest__batch__664F5149] DEFAULT ((0)) FOR [batch_id],
-	CONSTRAINT [pk_SNPAncestralAllele] PRIMARY KEY  CLUSTERED 
-	(
-		[snp_id],
-		[batch_id]
-	)
+ALTER TABLE [SNPAncestralAllele] ADD CONSTRAINT [DF__SNPAncest__batch__664F5149] DEFAULT ((0)) FOR [batch_id]
+ALTER TABLE [SNPAncestralAllele] ADD CONSTRAINT [pk_SNPAncestralAllele]  PRIMARY KEY  CLUSTERED ([snp_id] ASC,[batch_id] ASC)
 GO
 
-
-ALTER TABLE [SNPGtyFreq] ADD 
-	CONSTRAINT [pk_SNPGtyFreq] PRIMARY KEY  CLUSTERED 
-	(
-		[snp_id],
-		[unigty_id]
-	)
+ALTER TABLE [SNPClinSig] ADD CONSTRAINT [DF__SNPClinSi__upd_t__1BBC3395] DEFAULT (GETDATE()) FOR [upd_time]
+ALTER TABLE [SNPClinSig] ADD CONSTRAINT [PK__SNPClinS__430A13A119D3EB23]  PRIMARY KEY  CLUSTERED ([snp_id] ASC)
 GO
 
-
-ALTER TABLE [SNPHWProb] ADD 
-	CONSTRAINT [pk_SNPHWProb] PRIMARY KEY  CLUSTERED 
-	(
-		[snp_id]
-	)
+ALTER TABLE [SNPGtyFreq] ADD CONSTRAINT [pk_SNPGtyFreq]  PRIMARY KEY  CLUSTERED ([snp_id] ASC,[unigty_id] ASC)
 GO
 
-
-ALTER TABLE [SNPHistory] ADD 
-	CONSTRAINT [pk_SNPHistory] PRIMARY KEY  CLUSTERED 
-	(
-		[snp_id]
-	)
+ALTER TABLE [SNPHWProb] ADD CONSTRAINT [pk_SNPHWProb]  PRIMARY KEY  CLUSTERED ([snp_id] ASC)
 GO
 
-
-ALTER TABLE [SNPPubmed] ADD 
-	CONSTRAINT [pk_SNPPubmed] PRIMARY KEY  CLUSTERED 
-	(
-		[snp_id],
-		[subsnp_id],
-		[pubmed_id],
-		[type]
-	)
+ALTER TABLE [SNPHistory] ADD CONSTRAINT [pk_SNPHistory]  PRIMARY KEY  CLUSTERED ([snp_id] ASC)
 GO
 
 
-
-
-ALTER TABLE [SNPVal] ADD 
-	CONSTRAINT [pk_SNPVal] PRIMARY KEY  CLUSTERED 
-	(
-		[batch_id],
-		[snp_id]
-	)
+ALTER TABLE [SNPSubSNPLink] ADD CONSTRAINT [fk_SNPSubSNPLink_ss] FOREIGN KEY (subsnp_id) REFERENCES [SubSNP](subsnp_id)
 GO
 
 
-
-ALTER TABLE [SNP_bitfield] ADD 
-	CONSTRAINT [pk_SNP_bitfield] PRIMARY KEY  CLUSTERED 
-	(
-		[snp_id]
-	)
+ALTER TABLE [SNPSuspect] ADD CONSTRAINT [DF__SNPSuspec__upd_t__18BF0002] DEFAULT (GETDATE()) FOR [upd_time]
+ALTER TABLE [SNPSuspect] ADD CONSTRAINT [PK__SNPSuspe__430A13A116D6B790]  PRIMARY KEY  CLUSTERED ([snp_id] ASC)
 GO
 
-
-ALTER TABLE [SubPop] ADD 
-	CONSTRAINT [DF__SubPopB10__last___19AB9A98] DEFAULT (getdate()) FOR [last_updated_time],
-	 PRIMARY KEY  CLUSTERED 
-	(
-		[batch_id],
-		[subsnp_id],
-		[pop_id],
-		[type]
-	),
-	CONSTRAINT [fk_SubPop_batch_id] FOREIGN KEY 
-	(
-		[batch_id]
-	) REFERENCES [Batch] (
-		[batch_id]
-	),
-	CONSTRAINT [fk_SubPop_pop] FOREIGN KEY 
-	(
-		[pop_id]
-	) REFERENCES [Population] (
-		[pop_id]
-	),
-	 CHECK ([type] = 'GTY' or ([type] = 'HET' or [type] = 'ALE'))
+ALTER TABLE [SNPVal] ADD CONSTRAINT [pk_SNPVal]  PRIMARY KEY  CLUSTERED ([batch_id] ASC,[snp_id] ASC)
 GO
 
 
-ALTER TABLE [SubPopAllele] ADD 
-	CONSTRAINT [fk_SubPopAllele_bid_ss_pop_type] FOREIGN KEY 
-	(
-		[batch_id],
-		[subsnp_id],
-		[pop_id],
-		[type]
-	) REFERENCES [SubPop] (
-		[batch_id],
-		[subsnp_id],
-		[pop_id],
-		[type]
-	) ON DELETE CASCADE 
+ALTER TABLE [SNP_bitfield] ADD CONSTRAINT [pk_SNP_bitfield]  PRIMARY KEY  CLUSTERED ([snp_id] ASC)
 GO
 
-
-ALTER TABLE [SubPopGty] ADD 
-	CONSTRAINT [pk_SubPopGty] PRIMARY KEY  CLUSTERED 
-	(
-		[subpop_id],
-		[gty_id]
-	)
+ALTER TABLE [SubPop] ADD CONSTRAINT [DF__SubPopB10__last___19AB9A98] DEFAULT (GETDATE()) FOR [last_updated_time]
+ALTER TABLE [SubPop] ADD CONSTRAINT [fk_SubPop_batch_id] FOREIGN KEY (batch_id) REFERENCES [Batch](batch_id)
 GO
-
-
-ALTER TABLE [SubSNP] ADD 
-	CONSTRAINT [pk_SubSNP] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id]
-	)
+ALTER TABLE [SubPop] ADD CONSTRAINT [fk_SubPop_pop] FOREIGN KEY (pop_id) REFERENCES [Population](pop_id)
 GO
-
-
-ALTER TABLE [SubSNPAcc_ins] ADD 
-	CONSTRAINT [pk_SubSNPAcc] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[acc_part],
-		[acc_type_ind]
-	),
-	CONSTRAINT [ck_SubSNPAcc_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
+ALTER TABLE [SubPop] ADD CONSTRAINT [PK__SubPop_new__180E3640]  PRIMARY KEY  CLUSTERED ([batch_id] ASC,[subsnp_id] ASC,[pop_id] ASC,[type] ASC)
 GO
 
-
-ALTER TABLE [SubSNPCommLine_ins] ADD 
-	CONSTRAINT [pk_SubSNPCommLine] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPCommLine_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
+ALTER TABLE [SubPopAllele] ADD CONSTRAINT [fk_SubPopAllele_bid_ss_pop_type] FOREIGN KEY (batch_id,subsnp_id,pop_id,type) REFERENCES [SubPop](batch_id,subsnp_id,pop_id,type)
 GO
 
-
-ALTER TABLE [SubSNPHGVS] ADD 
-	CONSTRAINT [pk_SubSNPHGVS] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id]
-	)
+ALTER TABLE [SubPopGty] ADD CONSTRAINT [pk_SubPopGty]  PRIMARY KEY  CLUSTERED ([subpop_id] ASC,[gty_id] ASC)
 GO
 
-
-ALTER TABLE [SubSNPLinkout] ADD 
-	CONSTRAINT [DF__SubSNPLin__link___660506BC] DEFAULT ('NA') FOR [link_type],
-	CONSTRAINT [pk_SubSNPLinkout] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[link_type]
-	),
-	CONSTRAINT [ck_SubSNPLinkout_link_type] CHECK ([link_type]='NA' OR [link_type]='OTH' OR [link_type]='SRC')
+ALTER TABLE [SubSNP] ADD CONSTRAINT [pk_SubSNP]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC)
 GO
 
-
-ALTER TABLE [SubSNPMdFailLn] ADD 
-	CONSTRAINT [pk_SubSNPMdFailLn] PRIMARY KEY  NONCLUSTERED 
-	(
-		[subsnp_id],
-		[line_num]
-	)
+ALTER TABLE [SubSNPAcc_ins] ADD CONSTRAINT [pk_SubSNPAcc]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[acc_type_ind] ASC,[acc_part] ASC)
 GO
 
-
-ALTER TABLE [SubSNPNoVariSeq] ADD 
-	CONSTRAINT [pk_SubSNPNoVariSeq] PRIMARY KEY  NONCLUSTERED 
-	(
-		[subsnp_id],
-		[line_num]
-	)
+ALTER TABLE [SubSNPCommLine_ins] ADD CONSTRAINT [pk_SubSNPCommLine]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPOmim] ADD 
-	CONSTRAINT [pk_SubSNPOmim] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id]
-	)
+ALTER TABLE [SubSNPHGVS] ADD CONSTRAINT [pk_SubSNPHGVS]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC)
 GO
 
-
-ALTER TABLE [SubSNPPubmed] ADD 
-	CONSTRAINT [pk_SubSNPPubmed] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[line_num]
-	)
+ALTER TABLE [SubSNPLinkout] ADD CONSTRAINT [DF__SubSNPLin__link___660506BC] DEFAULT ('NA') FOR [link_type]
+ALTER TABLE [SubSNPLinkout] ADD CONSTRAINT [pk_SubSNPLinkout]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[link_type] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq3_ins] ADD 
-	CONSTRAINT [pk_SubSNPSeq3] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq3_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
+ALTER TABLE [SubSNPMdFailLn] ADD CONSTRAINT [pk_SubSNPMdFailLn]  PRIMARY KEY  NONCLUSTERED ([subsnp_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq5_ins] ADD 
-	CONSTRAINT [pk_SubSNPSeq5] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq5_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
+ALTER TABLE [SubSNPNoVariSeq] ADD CONSTRAINT [pk_SubSNPNoVariSeq]  PRIMARY KEY  NONCLUSTERED ([subsnp_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeqPos] ADD 
-	CONSTRAINT [pk_SubSNPSeqPos] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id]
-	)
+ALTER TABLE [SubSNPOmim] ADD CONSTRAINT [pk_SubSNPOmim]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC)
 GO
 
-
-ALTER TABLE [SubSNP_top_or_bot] ADD 
-	CONSTRAINT [PK__t_ss_top_or_bot__0D5DFFA8] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id]
-	)
+ALTER TABLE [SubSNPPubmed] ADD CONSTRAINT [pk_SubSNPPubmed]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[line_num] ASC)
 GO
 
+ALTER TABLE [SubSNPSeq3_ins] ADD CONSTRAINT [pk_SubSNPSeq3]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
+GO
 
-ALTER TABLE [SubmittedIndividual] ADD 
-	CONSTRAINT [DF__Submitted__ploid__41661CE5] DEFAULT (2) FOR [ploidy],
-	CONSTRAINT [pk_SubmittedIndividual] PRIMARY KEY  CLUSTERED 
-	(
-		[pop_id],
-		[loc_ind_id_upp]
-	)
+ALTER TABLE [SubSNPSeq5_ins] ADD CONSTRAINT [pk_SubSNPSeq5]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
 GO
 
+ALTER TABLE [SubSNPSeqPos] ADD CONSTRAINT [pk_SubSNPSeqPos]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC)
+GO
 
-ALTER TABLE [Synonym] ADD 
-	CONSTRAINT [pk_Synonym] PRIMARY KEY  NONCLUSTERED 
-	(
-		[subsnp_id],
-		[type]
-	)
+ALTER TABLE [SubSNP_top_or_bot] ADD CONSTRAINT [PK__t_ss_top_or_bot__0D5DFFA8]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC)
 GO
 
+ALTER TABLE [SubmittedIndividual] ADD CONSTRAINT [DF__Submitted__ploid__41661CE5] DEFAULT (2) FOR [ploidy]
+ALTER TABLE [SubmittedIndividual] ADD CONSTRAINT [pk_SubmittedIndividual]  PRIMARY KEY  CLUSTERED ([pop_id] ASC,[loc_ind_id_upp] ASC)
+GO
 
-ALTER TABLE [b132_ContigInfo_37_1] ADD 
-	CONSTRAINT [pk_b132_ContigInfo] PRIMARY KEY  CLUSTERED 
-	(
-		[ctg_id]
-	)
+ALTER TABLE [Synonym] ADD CONSTRAINT [pk_Synonym]  PRIMARY KEY  NONCLUSTERED ([subsnp_id] ASC,[type] ASC)
 GO
 
+ALTER TABLE [b135_ContigInfo_37_3] ADD CONSTRAINT [df_b135_ContigInfo_37_3_last_updated_time] DEFAULT (GETDATE()) FOR [last_updated_time]
+ALTER TABLE [b135_ContigInfo_37_3] ADD CONSTRAINT [pk_b135_ContigInfo_37_3]  PRIMARY KEY  CLUSTERED ([contig_gi] ASC)
+GO
 
 
 
+ALTER TABLE [b135_MapLink_37_3] ADD CONSTRAINT [fk_b135_MapLink_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
+GO
 
 
 
-ALTER TABLE [b132_SNPContigLoc_37_1] ADD 
-	CONSTRAINT [ck_snp_type] CHECK ([snp_type]='rs')
+ALTER TABLE [b135_SNPChrPosOnRef_37_3] ADD CONSTRAINT [fk_b135_SNPChrPosOnRef_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
 GO
 
-
-ALTER TABLE [b132_SNPContigLocusId_37_1] ADD 
-	CONSTRAINT [ck_fxn] CHECK ([fxn_class]=(75) OR [fxn_class]=(73) OR [fxn_class]=(55) OR [fxn_class]=(53) OR [fxn_class]=(45) OR [fxn_class]=(44) OR [fxn_class]=(43) OR [fxn_class]=(42) OR [fxn_class]=(41) OR [fxn_class]=(15) OR [fxn_class]=(13) OR [fxn_class]=(8) OR [fxn_class]=(6) OR [fxn_class]=(3))
+ALTER TABLE [b135_SNPContigLoc_37_3] ADD CONSTRAINT [fk_b135_SNPContigLoc_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
 GO
 
-
-ALTER TABLE [b132_SNPMapInfo_37_1] ADD 
-	CONSTRAINT [ck_SNPMapInfo_snp_type] CHECK ([snp_type]='rs')
+ALTER TABLE [b135_SNPContigLocusId_37_3] ADD CONSTRAINT [fk_b135_SNPContigLocusId_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
 GO
 
-
-ALTER TABLE [dn_IND_batchCount] ADD 
-	CONSTRAINT [pk_dn_IND_batchCount] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id],
-		[pop_id]
-	)
+ALTER TABLE [b135_SNPContigProtein_37_3] ADD CONSTRAINT [fk_b135_SNPContigProtein_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
 GO
 
+ALTER TABLE [b135_SNPMapInfo_37_3] ADD CONSTRAINT [fk_b135_SNPMapInfo_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
+GO
 
+ALTER TABLE [b135_SNPMapLinkProtein_37_3] ADD CONSTRAINT [fk_b135_SNPMapLinkProtein_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
+GO
 
-ALTER TABLE [dn_PopulationIndGrp] ADD 
-	CONSTRAINT [pk_dn_PopulationIndGrp] PRIMARY KEY  CLUSTERED 
-	(
-		[pop_id]
-	)
+ALTER TABLE [dn_IND_batchCount] ADD CONSTRAINT [pk_dn_IND_batchCount]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC,[pop_id] ASC)
 GO
 
 
-ALTER TABLE [dn_batchCount] ADD 
-	CONSTRAINT [pk_dn_batchCount] PRIMARY KEY  NONCLUSTERED 
-	(
-		[batch_id]
-	)
+ALTER TABLE [dn_PopulationIndGrp] ADD CONSTRAINT [pk_dn_PopulationIndGrp]  PRIMARY KEY  CLUSTERED ([pop_id] ASC)
 GO
 
-
-ALTER TABLE [dn_handleCount] ADD 
-	CONSTRAINT [pk_dn_handleCount] PRIMARY KEY  NONCLUSTERED 
-	(
-		[handle],
-		[batch_type]
-	)
+ALTER TABLE [dn_batchCount] ADD CONSTRAINT [pk_dn_batchCount]  PRIMARY KEY  NONCLUSTERED ([batch_id] ASC)
 GO
 
+ALTER TABLE [dn_handleCount] ADD CONSTRAINT [pk_dn_handleCount]  PRIMARY KEY  NONCLUSTERED ([handle] ASC,[batch_type] ASC)
+GO